EO_RC_AUD2_VW (SQL View)	Index Back
CCU Run Cntl for Audit Used by the Currency Conversion Utility as an online interface with the run control for Report EO002.SQR Audit Report.

EO_RC_AUD2_VW

(SQL View)

CCU Run Cntl for Audit

Used by the Currency Conversion Utility as an online interface with the run control for Report EO002.SQR Audit Report.

SELECT DISTINCT A.PROC_GRP_ID , B.RUN_CNTL_ID , C.RECNAME , B.PROCESS_INSTANCE FROM PS_RUN_CNTL_CC3_EO A , PS_RUN_CNTL_AUD_EO B , PS_EO_CC_WORKREC C WHERE A.RUN_CNTL_ID = B.RUN_CNTL_ID AND A.PROCESS_INSTANCE = B.PROCESS_INSTANCE AND B.TEOA_RECNAME = C.TEOA_RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Uniquely identifies a Currency Conversion Process Group

2 RUN_CNTL_ID_EO Character(30) VARCHAR2(30) NOT NULL Used by the Currency Conversion Utility in EO_RC_AUD1_VW which is the online interface with SQR Report EO002.SQR - Audit Report.

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

4 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROC_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Uniquely identifies a Currency Conversion Process Group
2	RUN_CNTL_ID_EO	Character(30)	VARCHAR2(30) NOT NULL	Used by the Currency Conversion Utility in EO_RC_AUD1_VW which is the online interface with SQR Report EO002.SQR - Audit Report.
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance