AR_STMT_H_VW (SQL View)	Index Back
Work record for RUN_AR0003 This record is used on run control for RUN_AR70003

AR_STMT_H_VW

(SQL View)

Work record for RUN_AR0003

This record is used on run control for RUN_AR70003

SELECT DISTINCT PSARCH_BATCHNUM ,PSARCH_ID FROM PS_AR_STMT_CUST_H

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

2 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
2	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).