RECNAMEEOCC_TRK_RG_VW2(SQL View) |
Index Back |
|---|---|
Change Tracking Detail Records |
| SELECT DISTINCT RCFLD.RECNAME ,DEFN.RECDESCR FROM PSRECFIELD RCFLD ,PSRECDEFN DEFN WHERE DEFN.RECNAME=RCFLD.RECNAME AND RCFLD.FIELDNAME = 'EOCC_TRK_DTLSBR' AND RCFLD.SUBRECORD = 'Y' AND RCFLD.RECNAME NOT IN ('EOCC_CHGTRK_DTL','EOCC_CHGTRK_LOG') AND RCFLD.RECNAME NOT LIKE 'EOCC_TRKDTL_%' |
| # | 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 |