SAD_UC_DISAB_MP (SQL Table)	Index Back
Apply disability mapping

SAD_UC_DISAB_MP

(SQL Table)

Apply disability mapping

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SCC_HE_DISABILITY Character(30) VARCHAR2(30) NOT NULL HESA Disability
Prompt Table: SSR_HE_DISA_VW

2 DISABILITY_CD_UK Character(3) VARCHAR2(3) NOT NULL Disability
DXT=Manual Dexterity
HRN=Hearing
LRN=Learning
MBL=Mobility
MNH=Mental Handicap
MNI=Mental Illness
OTH=Other
RSP=Respiratory
SPC=Speech
UNS=Unspecified
VSN=Vision

3 SCC_IMPAIRMNT_TYPE Character(2) VARCHAR2(2) NOT NULL Type of Impairment
20=Hearing Disability
30=Learning Disability
40=Mobility Disability
50=Vision Disability
60=Medical Disability
70=Other Disability
80=No disability

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SCC_HE_DISABILITY	Character(30)	VARCHAR2(30) NOT NULL	HESA Disability Prompt Table: SSR_HE_DISA_VW
2	DISABILITY_CD_UK	Character(3)	VARCHAR2(3) NOT NULL	Disability DXT=Manual Dexterity HRN=Hearing LRN=Learning MBL=Mobility MNH=Mental Handicap MNI=Mental Illness OTH=Other RSP=Respiratory SPC=Speech UNS=Unspecified VSN=Vision
3	SCC_IMPAIRMNT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Type of Impairment 20=Hearing Disability 30=Learning Disability 40=Mobility Disability 50=Vision Disability 60=Medical Disability 70=Other Disability 80=No disability