EOPCDEFN_FLDXRF(SQL View) |
Index Back |
|---|
| SELECT EOPCDEFN_ID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_EOPC_DEFN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(20) | VARCHAR2(20) NOT NULL | EOPC Definition ID | |
| 2 | EOPCMAIN_ID | Character(20) | VARCHAR2(20) NOT NULL | EOPC Section ID |
| 3 | EOPC_HTML1 | Long Character | CLOB | HTML Area |
| 4 | EOPCKEY1 | Long Character | CLOB | EOPC Key 1 |
| 5 | EOPCKEY2 | Long Character | CLOB | EOPC Key 2 |
| 6 | EOPCKEY3 | Long Character | CLOB | EOPC Key 3 |
| 7 | EOPCKEY4 | Long Character | CLOB | EOPC Key 4 |
| 8 | EOPCKEY5 | Long Character | CLOB | EOPC Key 5 |
| 9 | EOPCKEY6 | Long Character | CLOB | EOPC Key 6 |
| 10 | EOPCKEY7 | Long Character | CLOB | EOPC Key 7 |
| 11 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
| 12 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 2 |
| 13 | FIELDNAME3 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 3 |
| 14 | FIELDNAME4 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 4 |
| 15 | FIELDNAME5 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 5 |
| 16 | FIELDNAME6 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 17 | FIELDNAME7 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |