SCC_DISAFRA_PVW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	SCC_SEQ_ID	Number(10,0)	DECIMAL(10) NOT NULL	Sequence ID
3	SCC_SEQ_ID3	Number(3,0)	SMALLINT NOT NULL	Sequence Nbr
4	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
5	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
6	DIS_BEGIN_DT_FRA	Date(10)	DATE NOT NULL	Disability Begin Date
7	DIS_END_DT_FRA	Date(10)	DATE	Disability End Date
8	DIS_COTOREP_RT_FRA	Character(1)	VARCHAR2(1) NOT NULL	COTOREP Category A=COTOREP A - Category B=COTOREP B Category C=COTOREP C Category
9	DIS_IPP_RT_FRA	Number(6,2)	DECIMAL(5,2) NOT NULL	Disability Rate
10	DIS_PRIOR_PLC_FRA	Character(1)	VARCHAR2(1) NOT NULL	Previous Placement
11	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
12	WRK_ACCDNT_DIS_FRA	Character(1)	VARCHAR2(1) NOT NULL	Disability Due to WorkAccident
13	TITLE_NBR_FRA	Character(12)	VARCHAR2(12) NOT NULL	Title Number
14	NOTIF_DT_FRA	Date(10)	DATE	Notification Date
15	ACCDNT_ILLNESS_FRA	Character(1)	VARCHAR2(1) NOT NULL	Accident Cause. A=Work Accident M=Disease
16	OCC_ILLNESS_FRA	Character(3)	VARCHAR2(3) NOT NULL	Professional Disease
17	COMMENTS	Long Character	CLOB	Comment
18	AUDIT_ACTN	Character(1)	VARCHAR2(1) NOT NULL	Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted. A=Add C=Change Old (PPR Only) D=Delete K=Change - Old Values N=Change - New Values O=Change - Original Values