EOPCMAINR_SRCVW

(SQL View)
Index Back

SELECT D.EOPCDEFN_ID , D.EOPCSOURCE_CD , M.EOPCMAIN_ID , S.RECNAME , S.EOPCAPPKEY_GRP , S.EOPCBUFFER_LEVEL , S.EOPCREC_ALIAS , S.WHERE_CLAUSE , S.EOPCAPP_SRCREC_ID , M.EOPCMAIN_FIELD_HSH FROM PS_EOPCAPP_SRC_REC S , PS_EOPCMAIN_DISP M , PS_EOPC_DEFN D WHERE M.EOPCDEFN_ID = D.EOPCDEFN_ID AND S.EOPCMAIN_ID = M.EOPCMAIN_ID AND M.HTMLDISPLAY IS NOT NULL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EOPCDEFN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Definition ID
2 EOPCSOURCE_CD Character(4) VARCHAR2(4) NOT NULL EOPC Source Code
3 EOPCMAIN_ID Character(20) VARCHAR2(20) NOT NULL EOPC Section ID
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
5 EOPCAPPKEY_GRP Character(20) VARCHAR2(20) NOT NULL EOPC App Key Group
6 EOPCBUFFER_LEVEL Number(2,0) SMALLINT NOT NULL Buffer Level
7 EOPCREC_ALIAS Character(5) VARCHAR2(5) NOT NULL Record Alias
8 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause
9 EOPCAPP_SRCREC_ID Character(20) VARCHAR2(20) NOT NULL EOPC App Source Rec ID
10 EOPCMAIN_FIELD_HSH Character(28) VARCHAR2(28) NOT NULL Composition Hash Key