INCIDENT_NBREMPLIDEMPL_RCDNON_EMPLOYEE_IDSTART_DATEDefault Value: %DATE
1=Away From Work Due to Injury
2=Restricted Activity
3=Temp. Transfer Due to Injury
INJURY_ABSENCES(SQL Table) |
Index Back |
|---|---|
Injury AbsencesInjury Absences |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 4 | NON_EMPLOYEE_ID |
Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID |
| 5 | START_DATE |
Date(10) | DATE NOT NULL |
Start Date for Gen Standing PO
Default Value: %DATE |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | HS_AWAY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Absence or Restriction Type
1=Away From Work Due to Injury 2=Restricted Activity 3=Temp. Transfer Due to Injury |
| 8 | COMMENTSHORT | Character(30) | VARCHAR2(30) NOT NULL | Short Comment |