EOPCMAIN_ZTHLNG

(SQL View)
 Index Back

SELECT R.EOPCSOURCE_CD , R.EOPCDEFN_ID , R.EOPCMAIN_ID , L.LANGUAGE_CD , R.EOPCBUFFER_LEVEL , R.RECNAME , K.FIELDNAME , K.EOPCALT_LABEL , K.EOPCALT_LABEL , K.EOPCAPPCLASS_PATH , K.APPCLASSID FROM PS_EOPCMAIN_LNG L , PS_EOPCAPP_KEY_VW K , PS_EOPCMAIN_SRECVW R , PS_EOPC_OBJECT O WHERE L.EOPCMAIN_ID = R.EOPCMAIN_ID AND 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 , L.LANGUAGE_CD , R.EOPCBUFFER_LEVEL , R.RECNAME , K.FIELDNAME , %Substring(M.MESSAGE_TEXT, 1, 30) , M.MESSAGE_TEXT , K.EOPCAPPCLASS_PATH , K.APPCLASSID FROM PSMSGCATLANG M , PS_EOPCMAIN_LNG L , PS_EOPCAPP_KEY_VW K , PS_EOPCMAIN_SRECVW R , PS_EOPC_OBJECT O WHERE K.FIELDNAME = O.EOPCOBJECT_NAME AND K.EOPCAPP_SRCREC_ID = R.EOPCAPP_SRCREC_ID AND L.EOPCMAIN_ID = R.EOPCMAIN_ID AND M.MESSAGE_SET_NBR = K.EOPCLBL_MSGSET AND M.MESSAGE_NBR = K.EOPCLBL_MSGNBR AND M.LANGUAGE_CD = L.LANGUAGE_CD 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 EOPCBUFFER_LEVEL Number(2,0) SMALLINT NOT NULL Buffer Level
6 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
7 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
8 EOPCALT_LABEL Character(30) VARCHAR2(30) NOT NULL Alternate Label
9 EOPCALT_LABEL2 Character(100) VARCHAR2(100) NOT NULL Alternate Long Label
10 EOPCAPPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL App Class Path
11 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID