SSR_HM_SDSB_VW (SQL View)	Index Back
Student Disability List of Student disability records to be posted to HEIMS

SSR_HM_SDSB_VW

(SQL View)

Student Disability

List of Student disability records to be posted to HEIMS

SELECT DISTINCT I.EMPLID , I.SCC_IMPAIRMNT_TYPE , D.SSR_IMPAIRMENT_TYP , %DatePart(I.SCC_ROW_ADD_DTTM) FROM PS_SCC_IMPAIR_DTL I , PS_SSR_DISABIL_MAP D WHERE I.SCC_IMPAIRMNT_TYPE = D.SCC_IMPAIRMNT_TYPE AND %EffdtCheck(SSR_DISABIL_MAP D2,D , %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 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

3 SSR_IMPAIRMENT_TYP Character(2) VARCHAR2(2) NOT NULL HEIMS Disability Code E615
11=Hard of hearing/Deaf
12=Physical disability
13=Intellectual disability
14=Specific learning disability
15=Mental health condition
16=Acquired brain injury
17=Low vision/blindness
18=Medical condition
19=Other
20=Neurological condition
99=Not specified

4 EFFDT_FROM Date(10) DATE Effective Date From

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	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
3	SSR_IMPAIRMENT_TYP	Character(2)	VARCHAR2(2) NOT NULL	HEIMS Disability Code E615 11=Hard of hearing/Deaf 12=Physical disability 13=Intellectual disability 14=Specific learning disability 15=Mental health condition 16=Acquired brain injury 17=Low vision/blindness 18=Medical condition 19=Other 20=Neurological condition 99=Not specified
4	EFFDT_FROM	Date(10)	DATE	Effective Date From