HRS_HIRE_DFRA

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
3	DISABLE_TYPE_FRA	Character(3)	VARCHAR2(3) NOT NULL	Disability Type AAH=Disabled Person Allowance COT=Known as COTOREP COT=Known as COTOREP DIS=Disability Card FEM=Spouse of mentally disabled ORP=War Orphan PEN=Pensioned, Volunteer Fire Man RQT=Disabled Worker Recognition TPI=Disability Pension Owner TPM=Disability Milit Pension Owner VAM=Work Accident or Disease VGN=Re-Married War Widow VGR=Not-Married War Widow
4	DIS_BEGIN_DT_FRA	Date(10)	DATE	Disability Begin Date
5	DIS_END_DT_FRA	Date(10)	DATE	Disability End Date
6	DIS_COTOREP_RT_FRA	Character(1)	VARCHAR2(1) NOT NULL	COTOREP Category A=COTOREP A - Category B=COTOREP B Category C=COTOREP C Category
7	DIS_IPP_RT_FRA	Number(6,2)	DECIMAL(5,2) NOT NULL	Disability Rate
8	DIS_PRIOR_PLC_FRA	Character(1)	VARCHAR2(1) NOT NULL	Previous Placement Y/N Table Edit Default Value: N
9	PLACEMENT_TYPE_FRA	Character(4)	VARCHAR2(4) NOT NULL	Previous Placement Type AP=Protected WorkShop CAT=Helped by a Work Center CDTD=Home Work Center CFP=Professional Training Center IMPR=Professional/Medical Center
10	WRK_ACCDNT_DIS_FRA	Character(1)	VARCHAR2(1) NOT NULL	Disability Due to WorkAccident Y/N Table Edit Default Value: N
11	TITLE_NBR_FRA	Character(12)	VARCHAR2(12) NOT NULL	Title Number
12	NOTIF_DT_FRA	Date(10)	DATE	Notification Date
13	ACCDNT_ILLNESS_FRA	Character(1)	VARCHAR2(1) NOT NULL	Accident Cause. A=Work Accident M=Disease
14	OCC_ILLNESS_FRA	Character(3)	VARCHAR2(3) NOT NULL	Professional Disease Prompt Table: HRS_ILL_FRA_I
15	COMMENTS	Long Character	CLOB	Comment
16	HRS_HIRE_SEQ	Number(10,0)	DECIMAL(10) NOT NULL	Hire Sequence ID