HRS_EE_RFRL_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_PROFILE_SEQ	Number(3,0)	SMALLINT NOT NULL	Profile sequece
5	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON_NAME
6	REFERRAL_DTTM	DateTime(26)	TIMESTAMP	Referral Time Stamp Default Value: %DateTime
7	REFERRAL_ID	Character(20)	VARCHAR2(20) NOT NULL	Referral Track ID
8	REFERRAL_PWD	Character(6)	VARCHAR2(6) NOT NULL	Referral Password
9	APPL_EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Applicant Employee ID
10	APPL_EMPL_RCD	Number(3,0)	SMALLINT NOT NULL	Applicant Empl Rcd#
11	HIRE_DT	Date(10)	DATE	First Start Date
12	HRS_JO_ID_HIRED	Number(15,0)	DECIMAL(15) NOT NULL	Job Opening Clone Prompt Table: HRS_JOB_OPENING
13	PREV_TERM_DT	Date(10)	DATE	Previous Termination Date
14	REFERRER_NAME	Character(50)	VARCHAR2(50) NOT NULL	Referral Name
15	EMAIL_ADDR	Character(70)	VARCHAR2(70) NOT NULL	Email Address
16	PREV_EMPL_BY_COMPY	Character(1)	VARCHAR2(1) NOT NULL	Previously Employed by Company Y/N Table Edit Default Value: N
17	APP_IS_FAMILY	Character(1)	VARCHAR2(1) NOT NULL	Applicant is a family member Y/N Table Edit Default Value: N
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
22	HRS_AL_LOG_SRC_SEQ	Number(15,0)	DECIMAL(15) NOT NULL	Unique Identifier - For Log Source