HRS_PREMPLH_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_REF_NBR	Character(12)	VARCHAR2(12) NOT NULL	Pre-employment reference number.
7	REQUEST_DT	Date(10)	DATE	Request Date
8	ORIGINATOR_ID	Character(11)	VARCHAR2(11) NOT NULL	Originator's ID Prompt Table: HRS_ORGN_NM_VW
9	HRS_PREEMPL_STATUS	Character(50)	VARCHAR2(50) NOT NULL	Status of a pre-employment request.
10	HRS_ADJUDICATION	Character(50)	VARCHAR2(50) NOT NULL	Status of abjudication.
11	STATUS_DT	Date(10)	DATE NOT NULL	Status Date Default Value: %date
12	COMPLETED	Character(1)	VARCHAR2(1) NOT NULL	Completed Y/N Table Edit Default Value: N
13	COMPLETE_DATE	Date(10)	DATE	Date Completed
14	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
15	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
16	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
17	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id