HRS_PERSON_IDDISABILITY_STS_USAN=Not Disabled
X=Not Indicated
Y=Disabled
HR_DISCLOSURE_DTHRS_APPL_DIS_VW(SQL View) |
Index Back |
|---|
| SELECT A.HRS_PERSON_ID , CASE WHEN A.DISABLED = 'Y' THEN A.DISABLED ELSE A.DISABILITY_STS_USA END , A.HR_DISCLOSURE_DT , ' ' FROM PS_HRS_APP_DIS A |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | DISABILITY_STS_USA |
Character(1) | VARCHAR2(1) NOT NULL |
Disability (Section 503) Status USA
N=Not Disabled X=Not Indicated Y=Disabled |
| 3 | HR_DISCLOSURE_DT |
Date(10) | DATE | Disclosure Date |
| 4 | AUDIT_STAMP | DateTime(26) | TIMESTAMP | Date and Time Stamp |