EOPCMAINDISPSVW

(SQL View)
 Index Back

Section Search View


SELECT A.EOPCMAIN_ID , D.EOPCDEFN_NAME , L.EOPCLOGICAL_NAME , A.EOPCMAIN_DESCR , A.DESCR254 , X.XLATSHORTNAME , A.EOPCDEFN_ID , A.EOPCMAIN_FIELD_HSH , A.EOPCSOURCE_CD , A.STATUS , A.DISP_OBJ_TYPE , A.DISP_OBJ_NAME FROM PS_EOPC_DEFN D , PS_EOPCMAIN_LOGICL L , PS_EOPCMAIN_DISP A , PSXLATITEM X WHERE D.EOPCDEFN_ID = A.EOPCDEFN_ID AND L.EOPCDEFN_ID = A.EOPCDEFN_ID AND L.EOPCMAIN_FIELD_HSH = A.EOPCMAIN_FIELD_HSH AND X.FIELDNAME = 'EOPCFORM_FACTOR' AND ((X.FIELDVALUE = 'X' AND A.EOPCFORM_XLG = 'Y') OR (X.FIELDVALUE = 'L' AND A.EOPCFORM_LG = 'Y') OR (X.FIELDVALUE = 'M' AND A.EOPCFORM_MED = 'Y') OR (X.FIELDVALUE = 'S' AND A.EOPCFORM_SM = 'Y'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOPCMAIN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Section ID
2 EOPCDEFN_NAME Character(30) VARCHAR2(30) NOT NULL Definition Name

Prompt Table: EOPC_DEFN_SVW

3 EOPCLOGICAL_NAME Character(254) VARCHAR2(254) NOT NULL Composition Name

Prompt Table: EOPCMAIN_LGCSVW

4 EOPCMAIN_DESCR Character(30) VARCHAR2(30) NOT NULL Page Description
5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
6 EOPCFORM_FACTOR Character(1) VARCHAR2(1) NOT NULL Page Composer form factor
L=Large Form
M=Medium Form
S=Small Form
X=Extra Large Form
7 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID
8 EOPCMAIN_FIELD_HSH Character(28) VARCHAR2(28) NOT NULL Composition Hash Key
9 EOPCSOURCE_CD Character(4) VARCHAR2(4) NOT NULL EOPC Source Code
10 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
A=Active
I=Inactive

Default Value: A

11 DISP_OBJ_TYPE Character(2) VARCHAR2(2) NOT NULL EOPC Display Object Type - main display
E=Email
HT=Stand-Alone HTML
P=Page

Default Value: P

12 DISP_OBJ_NAME Character(30) VARCHAR2(30) NOT NULL Display Object Name