MC_TYPE_JN_VW

Return to Index

View: PS_MC_TYPE_JN_VW

Mass Change Type Join View

PlatformView Text
DefaultSELECT A.MC_TYPE_ID , A.MC_STMNT_SEQ , B.FIELDNAME FROM PS_MC_TYPE_RECORD A , PSRECFIELDDB B WHERE A.RECNAME = B.RECNAME AND A.MC_RECORD_TYPE IN ('S','T','M') GROUP BY A.MC_TYPE_ID, A.MC_STMNT_SEQ, B.FIELDNAME HAVING COUNT(*) > 1

PeopleSoft Field NameDescription
MC_TYPE_IDMass Change Type ID
MC_STMNT_SEQMass Change Statement Sequence
FIELDNAMEField Name

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010