HCI_DISAB_FR_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID Prompt Table: PERSON
2	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 Default Value: RQT
3	DIS_BEGIN_DT_FRA	Date(10)	DATE NOT NULL	Disability Begin Date
4	DIS_END_DT_FRA	Date(10)	DATE	Disability End Date
5	DIS_COTOREP_RT_FRA	Character(1)	VARCHAR2(1) NOT NULL	COTOREP Category A=COTOREP A - Category B=COTOREP B Category C=COTOREP C Category
6	DIS_IPP_RT_FRA	Number(6,2)	DECIMAL(5,2) NOT NULL	Disability Rate
7	DIS_PRIOR_PLC_FRA	Character(1)	VARCHAR2(1) NOT NULL	Previous Placement Y/N Table Edit Default Value: N
8	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
9	WRK_ACCDNT_DIS_FRA	Character(1)	VARCHAR2(1) NOT NULL	Disability Due to WorkAccident Y/N Table Edit Default Value: N
10	TITLE_NBR_FRA	Character(12)	VARCHAR2(12) NOT NULL	Title Number
11	NOTIF_DT_FRA	Date(10)	DATE	Notification Date
12	ACCDNT_ILLNESS_FRA	Character(1)	VARCHAR2(1) NOT NULL	Accident Cause. A=Work Accident M=Disease
13	OCC_ILLNESS_FRA	Character(3)	VARCHAR2(3) NOT NULL	Professional Disease Prompt Table: OCC_ILLNESS_FRA