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 | Fieldname 2 | 
| 13 | FIELDNAME3 | Character(18) | VARCHAR2(18) NOT NULL | Field Name | 
| 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 |