EOCC_TRK_RG_VW3

(SQL View)
 Index Back

Change Tracking Seq Records


SELECT DISTINCT RCFLD.RECNAME ,DEFN.RECDESCR FROM PSRECFIELD RCFLD ,PSRECDEFN DEFN WHERE DEFN.RECNAME=RCFLD.RECNAME AND RCFLD.FIELDNAME = 'EOCC_TRK_SEQSBR' AND RCFLD.SUBRECORD = 'Y' AND RCFLD.RECNAME NOT IN ('EOCC_CHGTRK_SEQ')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description