INCIDENT_NBREMPLIDEMPL_RCDNON_EMPLOYEE_IDSEQUENCE_NBRPrompt Table: PERSON_NAME
Default Value: INJURY_ILL_VW.HS_TIMEZONE1
10=First Aid Attendant
20=Worker's Supervisor
30=Other
Y/N Table Edit
INJURY_ILL_DESG(SQL Table) |
Index Back |
|---|---|
H&S - Injury DesignateThis is one of several records used in the Health and Safety module to record details about work-related injuries and illnesses suffered by employees or non-employees. Use INJURY_ILL_DESGI to record details about the First Aid Designate for the injured worker. |
| # | 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 Record |
| 4 | NON_EMPLOYEE_ID |
Character(11) | VARCHAR2(11) NOT NULL | Non-Employee ID |
| 5 | SEQUENCE_NBR |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 6 | DESIGNATE_EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employer Designate ID
Prompt Table: PERSON_NAME |
| 7 | DT_REPORTED | Date(10) | DATE | Date Reported |
| 8 | TM_REPORTED | Time(15) | TIMESTAMP | Time Reported |
| 9 | HS_TIMEZONE1 | Character(9) | VARCHAR2(9) NOT NULL |
Health and Safety Time Zone Field 1
Default Value: INJURY_ILL_VW.HS_TIMEZONE1 |
| 10 | DESIG_POSTYP_CD | Character(2) | VARCHAR2(2) NOT NULL |
Employer Designate Posn Type
10=First Aid Attendant 20=Worker's Supervisor 30=Other |
| 11 | FIRST_DESIGNATE_SW | Character(1) | VARCHAR2(1) NOT NULL |
First Designate Reported To
Y/N Table Edit |
| 12 | OTHER_DESIG_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Other Designate Description |
| 13 | FIRST_AID_CERT_NBR | Character(12) | VARCHAR2(12) NOT NULL | First Aid Cerificate Number |