DISABILITY_BRA (SQL Table)	Index Back
Disability Brazil Disability Table Brazil

DISABILITY_BRA

(SQL Table)

Disability Brazil

Disability Table Brazil

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

4 PPP_SITUATION_BRA Character(3) VARCHAR2(3) NOT NULL PPP Situation Brazil
PDH=Deficiency Carrier Habilitated
REB=Rehabilitated Beneficiary

5 DISABLED_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Disabled Type for Brazil
0=Not Disabled
1=Physical Disability
2=Hearing Disability
3=Visual Disability
4=Mental Disability
5=Multiple Disability
6=Rehabilitated
7=Reduced Mobility
8=Intellectual Disability
Default Value: 0

6 DISAB_QUOTA_BRA Character(1) VARCHAR2(1) NOT NULL Disability Quota
N=No
Y=Yes
Default Value: N

7 DISAB_QTA_DTL_BRA Long Character CLOB Details

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	PPP_SITUATION_BRA	Character(3)	VARCHAR2(3) NOT NULL	PPP Situation Brazil PDH=Deficiency Carrier Habilitated REB=Rehabilitated Beneficiary
5	DISABLED_TYPE_BRA	Character(1)	VARCHAR2(1) NOT NULL	Disabled Type for Brazil 0=Not Disabled 1=Physical Disability 2=Hearing Disability 3=Visual Disability 4=Mental Disability 5=Multiple Disability 6=Rehabilitated 7=Reduced Mobility 8=Intellectual Disability Default Value: 0
6	DISAB_QUOTA_BRA	Character(1)	VARCHAR2(1) NOT NULL	Disability Quota N=No Y=Yes Default Value: N
7	DISAB_QTA_DTL_BRA	Long Character	CLOB	Details