UPG_HRS_DFR_AET

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	HRS_PERSON_ID	Number(15,0)	DECIMAL(15) NOT NULL	Person Id
3	HRS_DISAB_TYPE_FRA	Character(3)	VARCHAR2(3) NOT NULL	Disability Type COT=Known as COTOREP FEM=Spouse of mentally disabled ORP=War Orphan PEN=Pensioned, Volunteer Fire Man 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
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
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
15	HRS_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Row Added DateTime
16	HRS_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Added Operator Id
17	HRS_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Row Updated DateTime
18	HRS_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Row Updated Operator Id
19	COMMENTS	Long Character	CLOB	Comment