HRS_PREMPLD_HST

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
4	HRS_VENDOR_ID	Number(15,0)	DECIMAL(15) NOT NULL	Integration Vendor ID Prompt Table: HRS_VENDOR_PT
5	HRS_PREMPL_PERS_ID	Number(15,0)	DECIMAL(15) NOT NULL	Pre-Employment Person Id
6	PREEMPLOY_REQ_ID	Character(32)	VARCHAR2(32) NOT NULL	Pre-Employment Request ID
7	PREEMPLOY_REF_NBR	Character(12)	VARCHAR2(12) NOT NULL	Pre-employment reference number.
8	PREEMPLOYMENT_INQ	Character(50)	VARCHAR2(50) NOT NULL	Pre-employment subrequest.
9	HRS_PREEMPL_STATUS	Character(50)	VARCHAR2(50) NOT NULL	Status of a pre-employment request.
10	COMPLETED	Character(1)	VARCHAR2(1) NOT NULL	Completed Y/N Table Edit Default Value: N
11	COMPLETE_DATE	Date(10)	DATE	Date Completed
12	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
13	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
14	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
15	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id