EOPC_FLD_LBL_VW

(SQL View)
 Index Back

SELECT EOPCMAIN_ID , EOPC_ISLABEL , EOPCALT_LABEL , EOPCLBL_MSGSET , EOPCLBL_MSGNBR , EOPCFORMAT_ID , EOPCFIELD_ID , RECNAME , FIELDNAME , EOPCOBJECT_ID , EOPCBIND_IDX , LABEL_ID , EOPCIMAGE_ID , EOPCFIELDSTYLE_ID , EOPCIMAGESTYLE_ID , EOPCLABELSTYLE_ID , EOPCLABEL_TYPE_ALL , EOPCLABEL_TYPE , EOPCXLAT_TYPE , EOPCAPPCLASS_PATH , APPCLASSID , EOPCDTTM_ADDED , EOPCOPRID_ADDED , EOPCLASTUPDDTTM , EOPCLASTOPRID FROM PS_EOPC_FIELD WHERE EOPC_ISLABEL = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOPCMAIN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Section ID
2 EOPC_ISLABEL Character(1) VARCHAR2(1) NOT NULL LABEL FIELD

Y/N Table Edit

Default Value: Y

3 EOPCALT_LABEL Character(30) VARCHAR2(30) NOT NULL Alternate Label
4 EOPCLBL_MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
5 EOPCLBL_MSGNBR Number(5,0) INTEGER NOT NULL Message Number
6 EOPCFORMAT_ID Character(20) VARCHAR2(20) NOT NULL EOPC Format ID
7 EOPCFIELD_ID Character(20) VARCHAR2(20) NOT NULL EOPC Field ID
8 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
10 EOPCOBJECT_ID Character(10) VARCHAR2(10) NOT NULL EOPC Object ID
11 EOPCBIND_IDX Number(4,0) SMALLINT NOT NULL EOPC Bind Index
12 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
13 EOPCIMAGE_ID Character(30) VARCHAR2(30) NOT NULL Image
14 EOPCFIELDSTYLE_ID Character(20) VARCHAR2(20) NOT NULL EOPC Field Style ID
15 EOPCIMAGESTYLE_ID Character(20) VARCHAR2(20) NOT NULL EOPC Image Style ID
16 EOPCLABELSTYLE_ID Character(20) VARCHAR2(20) NOT NULL EOPC Label Style ID
17 EOPCLABEL_TYPE_ALL Character(1) VARCHAR2(1) NOT NULL Label Type
L=Long Name
M=Message Catalog
S=Short Name
T=Text
18 EOPCLABEL_TYPE Character(1) VARCHAR2(1) NOT NULL Label Type
L=Long Name
S=Short Name
19 EOPCXLAT_TYPE Character(1) VARCHAR2(1) NOT NULL XLAT Type
L=Long Name
S=Short Name
V=Value
20 EOPCAPPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL App Class Path
21 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
22 EOPCDTTM_ADDED DateTime(26) TIMESTAMP Datetime Added
23 EOPCOPRID_ADDED Character(30) VARCHAR2(30) NOT NULL OprID Added
24 EOPCLASTUPDDTTM DateTime(26) TIMESTAMP Last Updated
25 EOPCLASTOPRID Character(30) VARCHAR2(30) NOT NULL Last Updated By