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 Name Field Type Column Type Description
MC_TYPE_ID Character(30) VARCHAR2(30) NOT NULL Mass Change Type ID
MC_STMNT_SEQ Number(3,0) SMALLINT NOT NULL Mass Change Statement Sequence
FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19