EOPCMAIN_IDEOPCFORMAT_IDEOPCFIELD_IDLANGUAGE_CDEOPCADSC_FLDLG(SQL View) |
Index Back |
|---|---|
EOPCADSC_FLDVW language tableADS display view language table for ADS Workbench compare. langauge View for Page Composer ADS display view EOPCADSC_FLDVW record. |
| SELECT L1.SHORTNAME || '/' || L2.SHORTNAME || ': ' || R.RECDESCR || '/' || L3.LONGNAME , F.EOPCMAIN_ID , F.EOPCFORMAT_ID , F.EOPCFIELD_ID , L1.LANGUAGE_CD FROM PSDBFLDLABL LB , PSDBFLDLABLLANG L3 , PSDBFLDLABLLANG L2 , PSDBFLDLABLLANG L1 , PSRECDEFNLANG R , PS_EOPC_FIELD F WHERE R.RECNAME = F.RECNAME AND LB.FIELDNAME = F.FIELDNAME AND LB.DEFAULT_LABEL = 1 AND LB.LABEL_ID = L3.LABEL_ID AND L2.FIELDNAME = 'FIELDNAME' AND L2.LABEL_ID = 'FIELDNAME' AND L1.FIELDNAME = 'RECNAME' AND L1.LABEL_ID = 'RECNAME' AND L2.LANGUAGE_CD = L1.LANGUAGE_CD AND L3.LANGUAGE_CD = L1.LANGUAGE_CD AND R.LANGUAGE_CD = L1.LANGUAGE_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCADS_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Section Fields |
| 2 | EOPCMAIN_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Section ID |
| 3 | EOPCFORMAT_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Format ID |
| 4 | EOPCFIELD_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Field ID |
| 5 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |