HRS_APPLICA_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	APPLID	Character(11)	VARCHAR2(11) NOT NULL	External Job Applicant ID Prompt Table: HRS_APP_PROFILE
5	APP_PER_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Identifies the type of applicant - External Applicant, Employee or Non-Employee A=External Applicant E=Employee N=Non-Employee Default Value: A
6	SEX	Character(1)	VARCHAR2(1) NOT NULL	Gender F=Female M=Male U=Unknown X=Indeterminate/Intersex/Unspec Default Value: U
7	BIRTHDATE	Date(10)	DATE	Date of Birth
8	BIRTHPLACE	Character(30)	VARCHAR2(30) NOT NULL	Birth Location
9	BIRTHCOUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Birth Country Prompt Table: BIRTHCOUNTRY_VW
10	BIRTHSTATE	Character(6)	VARCHAR2(6) NOT NULL	Birth State Prompt Table: BIRTHSTATE_VW
11	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: HRS_PERSON_NM_I
12	HRS_APP_PREF_CONT	Character(1)	VARCHAR2(1) NOT NULL	Preferred Method of Contact E=EMail M=Mail N=Not Specified P=Phone Default Value: N
13	STATUS_CODE	Character(3)	VARCHAR2(3) NOT NULL	Identifies a status. Prompt Table: HRS_STS_APP_I
14	STATUS_REASON	Character(3)	VARCHAR2(3) NOT NULL	Identifies a reason associated with a particular status. Prompt Table: HRS_RSN_APP_I
15	STATUS_DT	Date(10)	DATE	Status Date Default Value: %date
16	HRS_EXT_TRN	Character(1)	VARCHAR2(1) NOT NULL	Applicant - External Trainee Flag
17	POI_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Defines the Transactional usage of POIs in HRMS.
18	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
19	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
20	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
21	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id