EOPCMAIN_IDEOPCAPP_SRCREC_IDEOPCAPP_FLDEVNT_IDEOPCADSC_FEVTVW(SQL View) |
Index Back |
|---|---|
FEvent ADS Compare Display VWADS display view for ADS Workbench compare. View for Page Composer EOPCAPP_FLDEVNT record. |
| SELECT R.RECDESCR || ': ' || L.LONGNAME , A.EOPCDEFN_ID , A.EOPCMAIN_ID , S.EOPCAPP_SRCREC_ID , F.EOPCAPP_FLDEVNT_ID FROM PSDBFLDLABL L , PS_EOPCAPP_FLDEVNT F , PS_EOPCAPP_SRC_REC S , PS_EOPCMAIN_DISP A , PSRECDEFN R WHERE S.EOPCMAIN_ID = A.EOPCMAIN_ID AND F.EOPCMAIN_ID = S.EOPCMAIN_ID AND F.EOPCAPP_SRCREC_ID = S.EOPCAPP_SRCREC_ID AND L.FIELDNAME = F.FIELDNAME AND L.DEFAULT_LABEL = 1 AND R.RECNAME = 'EOPCAPP_FLDEVNT' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCADS_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Field Event |
| 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_FLDEVNT_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Source Field Event ID |