EOPCMAIN_IDEOPCAPP_SRCREC_IDEOPCAPP_KEYFLD_IDEOPCADSC_SKEYVW(SQL View) |
Index Back |
|---|---|
AppKey ADS Compare Display VWADS display view for ADS Workbench compare. View for Page Composer EOPCAPP_KEY_FLD record. |
| SELECT R.RECDESCR || ': ' || L.LONGNAME , A.EOPCDEFN_ID , A.EOPCMAIN_ID , S.EOPCAPP_SRCREC_ID , K.EOPCAPP_KEYFLD_ID FROM PSDBFLDLABL L , PSRECDEFN R , PS_EOPCAPP_KEY_FLD K , PS_EOPCAPP_SRC_REC S , PS_EOPCMAIN_DISP A WHERE S.EOPCMAIN_ID = A.EOPCMAIN_ID AND K.EOPCMAIN_ID = S.EOPCMAIN_ID AND K.EOPCAPP_SRCREC_ID = S.EOPCAPP_SRCREC_ID AND L.FIELDNAME = K.FIELDNAME AND L.DEFAULT_LABEL = 1 AND R.RECNAME = 'EOPCAPP_KEY_FLD' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCADS_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Source Key Fields |
| 2 | EOPCDEFN_ID | Character(20) | VARCHAR2(20) NOT NULL | EOPC Definition ID |
| 3 | EOPCMAIN_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Section ID |
| 4 | EOPCAPP_SRCREC_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC App Source Rec ID |
| 5 | EOPCAPP_KEYFLD_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC App Key Field ID |