EOPCMAIN_SRDSVW

(SQL View)

SELECT DISTINCT D.EOPCDEFN_ID , D.EOPCSOURCE_CD , S.RECNAME , S.WHERE_CLAUSE 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

# 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 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 WHERE_CLAUSE Long Character(500) VARCHAR2(500) Where Clause

#	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	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	WHERE_CLAUSE	Long Character(500)	VARCHAR2(500)	Where Clause