EOPCDEFN_IDEOPCDEFN_MFLDVW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT M.EOPCDEFN_ID , F.FIELDNAME FROM PS_EOPCMAIN_FIELDS F , PS_EOPCMAIN_DISP M WHERE F.EOPCMAIN_ID = M.EOPCMAIN_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOPCDEFN_ID |
Character(20) | VARCHAR2(20) NOT NULL | EOPC Definition ID |
| 2 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |