RECNAMEEOCC_TRK_RG_VW1(SQL View) |
Index Back |
|---|---|
Change Tracking Header Records |
| SELECT DISTINCT RCFLD.RECNAME ,DEFN.RECDESCR FROM PSRECFIELD RCFLD ,PSRECDEFN DEFN WHERE DEFN.RECNAME=RCFLD.RECNAME AND RCFLD.FIELDNAME = 'EOCC_TRK_HDRSBR' AND RCFLD.SUBRECORD = 'Y' AND RCFLD.RECNAME NOT IN ('EOCC_CHGTRK_HDR') AND RCFLD.RECNAME NOT LIKE 'EOCC_TRKHDR_%' |
| # | 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 |