EOPCAPP_KEY_LNG

(SQL View)
 Index Back

SELECT A.EOPCSOURCE_CD , A.EOPCDEFN_ID , B.EOPCMAIN_ID , C.EOPCAPP_KEYFLD_ID , C.EOPCAPP_SRCREC_ID , L.LANGUAGE_CD , C.EOPCAPPKEY_GRP , C.EOPCBIND_IDX , C.FIELDNAME , B.RECNAME , C.EOPCALT_LABEL , C.EOPCALT_LABEL , C.EOPCAPPCLASS_PATH , C.APPCLASSID , C.EOPCLBL_MSGNBR , C.EOPCLBL_MSGSET FROM PS_EOPCMAIN_LNG L , PS_EOPCAPP_KEY_FLD C , PS_EOPCAPP_SRC_REC B , PS_EOPCMAIN_DISP A WHERE B.EOPCMAIN_ID = A.EOPCMAIN_ID AND C.EOPCAPP_SRCREC_ID = B.EOPCAPP_SRCREC_ID AND L.EOPCMAIN_ID = A.EOPCMAIN_ID AND NOT EXISTS ( SELECT 'X' FROM PSMSGCATDEFN M WHERE M.MESSAGE_SET_NBR = C.EOPCLBL_MSGSET AND M.MESSAGE_NBR = C.EOPCLBL_MSGNBR) UNION SELECT A.EOPCSOURCE_CD , A.EOPCDEFN_ID , B.EOPCMAIN_ID , C.EOPCAPP_KEYFLD_ID , C.EOPCAPP_SRCREC_ID , L.LANGUAGE_CD , C.EOPCAPPKEY_GRP , C.EOPCBIND_IDX , C.FIELDNAME , B.RECNAME , %Substring(M.MESSAGE_TEXT, 1, 30) , M.MESSAGE_TEXT , C.EOPCAPPCLASS_PATH , C.APPCLASSID , C.EOPCLBL_MSGNBR , C.EOPCLBL_MSGSET FROM PSMSGCATLANG M , PS_EOPCMAIN_LNG L , PS_EOPCAPP_KEY_FLD C , PS_EOPCAPP_SRC_REC B , PS_EOPCMAIN_DISP A WHERE B.EOPCMAIN_ID = A.EOPCMAIN_ID AND C.EOPCAPP_SRCREC_ID = B.EOPCAPP_SRCREC_ID AND L.EOPCMAIN_ID = A.EOPCMAIN_ID AND M.MESSAGE_SET_NBR = C.EOPCLBL_MSGSET AND M.MESSAGE_NBR = C.EOPCLBL_MSGNBR AND M.LANGUAGE_CD = L.LANGUAGE_CD AND C.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 EOPCAPP_KEYFLD_ID Character(20) VARCHAR2(20) NOT NULL EOPC App Key Field ID
5 EOPCAPP_SRCREC_ID Character(20) VARCHAR2(20) NOT NULL EOPC App Source Rec ID
6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
7 EOPCAPPKEY_GRP Character(20) VARCHAR2(20) NOT NULL EOPC App Key Group
8 EOPCBIND_IDX Number(4,0) SMALLINT NOT NULL EOPC Bind Index
9 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
10 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
11 EOPCALT_LABEL Character(30) VARCHAR2(30) NOT NULL Alternate Label
12 EOPCALT_LABEL2 Character(100) VARCHAR2(100) NOT NULL Alternate Long Label
13 EOPCAPPCLASS_PATH Character(254) VARCHAR2(254) NOT NULL App Class Path
14 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Application Class ID
15 EOPCLBL_MSGNBR Number(5,0) INTEGER NOT NULL Message Number
16 EOPCLBL_MSGSET Number(5,0) INTEGER NOT NULL Message Set Number