MC_TYPE_JN_VW

index back

Mass Change Type Join View


SELECT 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 NameField TypeColumn TypeDescription
MC_TYPE_IDCharacter(30)VARCHAR2(30) NOT NULLMass Change Type ID
MC_STMNT_SEQNumber(3,0)SMALLINT NOT NULLMass Change Statement Sequence
FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19