EOPCDEFN_ADDLVW(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 | EOPCMAIN_FIELD_HSH | Character(28) | VARCHAR2(28) NOT NULL | Composition Hash Key |
4 | EOPCHASH_LIST | Long Character | CLOB | EOPC Hash List |
5 | EOPC_HTML1 | Long Character | CLOB | HTML Area |
6 | EOPCKEY1 | Long Character | CLOB | EOPC Key 1 |
7 | EOPCKEY2 | Long Character | CLOB | EOPC Key 2 |
8 | EOPCKEY3 | Long Character | CLOB | EOPC Key 3 |
9 | EOPCKEY4 | Long Character | CLOB | EOPC Key 4 |
10 | EOPCKEY5 | Long Character | CLOB | EOPC Key 5 |
11 | EOPCKEY6 | Long Character | CLOB | EOPC Key 6 |
12 | EOPCKEY7 | Long Character | CLOB | EOPC Key 7 |
13 | FIELDNAME1 | Character(18) | VARCHAR2(18) NOT NULL | Field Name 1 |
14 | FIELDNAME2 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
15 | FIELDNAME3 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
16 | FIELDNAME4 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
17 | FIELDNAME5 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
18 | FIELDNAME6 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
19 | FIELDNAME7 | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
20 | LONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Long Name |
21 | EOPCDESCR1 | Character(15) | VARCHAR2(15) NOT NULL | Description |
22 | EOPCDESCR2 | Character(15) | VARCHAR2(15) NOT NULL | Description |
23 | EOPCDESCR3 | Character(15) | VARCHAR2(15) NOT NULL | Description |
24 | EOPCDESCR4 | Character(15) | VARCHAR2(15) NOT NULL | Description |
25 | EOPCDESCR5 | Character(15) | VARCHAR2(15) NOT NULL | Description |
26 | EOPCDESCR6 | Character(15) | VARCHAR2(15) NOT NULL | Description |
27 | EOPCDESCR7 | Character(15) | VARCHAR2(15) NOT NULL | Description |