EOPCAPP_SREC_VW

(SQL View)
 Index Back

SELECT SR.EOPCMAIN_ID , SR.RECNAME , SR.EOPCAPPKEY_GRP , SR.EOPCAPP_SRCREC_ID , SR.EOPCBUFFER_LEVEL , SR.EOPCREC_ALIAS , B.EOPCFORM_LG , B.EOPCFORM_MED , B.EOPCFORM_SM , B.EOPCFORM_XLG , SR.EOPCLBL_MSGNBR , SR.EOPCLBL_MSGSET , R.RECDESCR FROM PS_EOPCMAIN_DISP B , PSRECDEFN R , PS_EOPCAPP_SRC_REC SR WHERE R.RECNAME = SR.RECNAME AND B.EOPCMAIN_ID = SR.EOPCMAIN_ID AND NOT EXISTS ( SELECT 'X' FROM PSMSGCATDEFN M WHERE M.MESSAGE_SET_NBR = SR.EOPCLBL_MSGSET AND M.MESSAGE_NBR = SR.EOPCLBL_MSGNBR) UNION SELECT SR.EOPCMAIN_ID , SR.RECNAME , SR.EOPCAPPKEY_GRP , SR.EOPCAPP_SRCREC_ID , SR.EOPCBUFFER_LEVEL , SR.EOPCREC_ALIAS , B.EOPCFORM_LG , B.EOPCFORM_MED , B.EOPCFORM_SM , B.EOPCFORM_XLG , SR.EOPCLBL_MSGNBR , SR.EOPCLBL_MSGSET , %Substring(M.MESSAGE_TEXT, 1, 30) FROM PSMSGCATDEFN M , PS_EOPCMAIN_DISP B , PSRECDEFN R , PS_EOPCAPP_SRC_REC SR WHERE R.RECNAME = SR.RECNAME AND B.EOPCMAIN_ID = SR.EOPCMAIN_ID AND M.MESSAGE_SET_NBR = SR.EOPCLBL_MSGSET AND M.MESSAGE_NBR = SR.EOPCLBL_MSGNBR AND SR.EOPCLBL_MSGNBR > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOPCMAIN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Section ID
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
3 EOPCAPPKEY_GRP Character(20) VARCHAR2(20) NOT NULL EOPC App Key Group
4 EOPCAPP_SRCREC_ID Character(20) VARCHAR2(20) NOT NULL EOPC App Source Rec ID
5 EOPCBUFFER_LEVEL Number(1,0) SMALLINT NOT NULL Buffer Level
6 EOPCREC_ALIAS Character(5) VARCHAR2(5) NOT NULL Record Alias
7 EOPCFORM_LG Character(1) VARCHAR2(1) NOT NULL Large
8 EOPCFORM_MED Character(1) VARCHAR2(1) NOT NULL Medium
9 EOPCFORM_SM Character(1) VARCHAR2(1) NOT NULL Small
10 EOPCFORM_XLG Character(1) VARCHAR2(1) NOT NULL X-Large
11 EOPCLBL_MSGNBR Number(5,0) INTEGER NOT NULL Message Number
12 EOPCLBL_MSGSET Number(5,0) INTEGER NOT NULL Message Set Number
13 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description