EO_AUDIT_DTL_VW

(SQL View)

SELECT A.RUN_CNTL_ID , A.PROCESS_INSTANCE , B.RECNAME , A.TEOA_RECNAME FROM PS_RUN_CNTL_AUD_EO A ,PS_EO_CC_WORKREC B WHERE A.TEOA_RECNAME = B.TEOA_RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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

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

4 TEOA_RECNAME Character(15) VARCHAR2(15) NOT NULL Owned by the Currency Conversion Utility. Used by the Utility on the State Record to dynamically keep track, during conversion, of the audit work record created for each conversion record. This functionality is new in Release 8.0 and will be retrofitted to Release 7.5.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
2	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
4	TEOA_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Owned by the Currency Conversion Utility. Used by the Utility on the State Record to dynamically keep track, during conversion, of the audit work record created for each conversion record. This functionality is new in Release 8.0 and will be retrofitted to Release 7.5.