HRS_PERSON_IDAUDIT_OPRIDAUDIT_STAMPN=Not Disabled
X=Not Indicated
Y=Disabled
HRS_APP_DIS_AUD(SQL Table) |
Index Back |
|---|---|
Disability history |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HRS_PERSON_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Person Id |
| 2 | AUDIT_OPRID |
Character(30) | VARCHAR2(30) NOT NULL | The OPRID of the user who made the changes audited on an audit record. |
| 3 | AUDIT_STAMP |
DateTime(26) | TIMESTAMP | Date and Time Stamp |
| 4 | DISABILITY_STS_USA | Character(1) | VARCHAR2(1) NOT NULL |
Disability (Section 503) Status USA
N=Not Disabled X=Not Indicated Y=Disabled |
| 5 | HR_EE_SIGNATURE | Character(75) | VARCHAR2(75) NOT NULL | Employee Signature |
| 6 | HR_DISCLOSURE_DT | Date(10) | DATE | Disclosure Date |
| 7 | HRS_DIS_SEEN_FLG | Character(1) | VARCHAR2(1) NOT NULL |