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 Fieldname 2
15 FIELDNAME3 Character(18) VARCHAR2(18) NOT NULL Name of Field
16 FIELDNAME4 Character(18) VARCHAR2(18) NOT NULL Name of Field
17 FIELDNAME5 Character(18) VARCHAR2(18) NOT NULL Name of Field
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