SCC_IMPAIR_DTL

(SQL Table)
Index Back

Impairment AUS

Detail Record.

# 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 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
4 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
5 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
6 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time