EO_RC_AUD1_VW (SQL View)	Index Back
CCU Run Control View for Audit Used by the Currency Conversion Utilitily as the online run control interface for the Audit Report EO002.SQR

EO_RC_AUD1_VW

(SQL View)

CCU Run Control View for Audit

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

SELECT DISTINCT A.PROC_GRP_ID , A.RUN_CNTL_ID FROM PS_RUN_CNTL_CC3_EO A , PS_RUN_CNTL_AUD_EO B WHERE A.RUN_CNTL_ID = B.RUN_CNTL_ID

# 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.

#	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.