EOPCMAINR_ZTHVW

(SQL View)
 Index Back

SELECT R.EOPCSOURCE_CD , R.EOPCDEFN_ID , R.EOPCMAIN_ID , R.EOPCBUFFER_LEVEL , R.RECNAME , K.FIELDNAME , K.EOPCALT_LABEL , K.EOPCALT_LABEL , K.EOPCAPPCLASS_PATH , K.APPCLASSID , R.EOPCMAIN_FIELD_HSH FROM PS_EOPCAPP_KEY_VW K , PS_EOPCMAINR_SRCVW R , PS_EOPC_OBJECT O WHERE K.FIELDNAME = O.EOPCOBJECT_NAME AND K.EOPCAPP_SRCREC_ID = R.EOPCAPP_SRCREC_ID AND O.EOPCOBJECT_TYPE = 'AA' AND NOT EXISTS ( SELECT 'X' FROM PSMSGCATDEFN M WHERE M.MESSAGE_SET_NBR = K.EOPCLBL_MSGSET AND M.MESSAGE_NBR = K.EOPCLBL_MSGNBR) UNION SELECT R.EOPCSOURCE_CD , R.EOPCDEFN_ID , R.EOPCMAIN_ID , R.EOPCBUFFER_LEVEL , R.RECNAME , K.FIELDNAME , %Substring(M.MESSAGE_TEXT, 1, 30) , M.MESSAGE_TEXT , K.EOPCAPPCLASS_PATH , K.APPCLASSID , R.EOPCMAIN_FIELD_HSH FROM PSMSGCATDEFN M , PS_EOPCAPP_KEY_VW K , PS_EOPCMAINR_SRCVW R , PS_EOPC_OBJECT O WHERE M.MESSAGE_SET_NBR = K.EOPCLBL_MSGSET AND M.MESSAGE_NBR = K.EOPCLBL_MSGNBR AND K.FIELDNAME = O.EOPCOBJECT_NAME AND K.EOPCAPP_SRCREC_ID = R.EOPCAPP_SRCREC_ID AND O.EOPCOBJECT_TYPE = 'AA' AND K.EOPCLBL_MSGNBR > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOPCSOURCE_CD Character(4) VARCHAR2(4) NOT NULL EOPC Source Code
2 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID
3 EOPCMAIN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Section ID
4 EOPCBUFFER_LEVEL Number(2,0) SMALLINT NOT NULL Buffer Level
5 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
7 EOPCALT_LABEL Character(30) VARCHAR2(30) NOT NULL Alternate Label
8 EOPCALT_LABEL2 Character(100) VARCHAR2(100) NOT NULL Alternate Long Label
9 EOPCAPPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL App Class Path
10 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
11 EOPCMAIN_FIELD_HSH Character(28) VARCHAR2(28) NOT NULL Composition Hash Key