EOPCDEFN_FLDXRF(SQL View) |
Index Back |
---|
SELECT EOPCDEFN_ID , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_EOPC_DEFN |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOPCDEFN_ID | 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 | Name of Field |
14 | FIELDNAME4 | Character(18) | VARCHAR2(18) NOT NULL | Name of Field |
15 | FIELDNAME5 | Character(18) | VARCHAR2(18) NOT NULL | Name of Field |
16 | FIELDNAME6 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
17 | FIELDNAME7 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |