INCIDENT_NBRPrompt Table: INCIDENT_DATA
Prompt Table: ESTAB_TBL
1=Work
2=Journey
3=Occupational Disease/Illness
4=Other
Default Value: 1
Y/N Table Edit
1=Police Report
2=State Transport Administration
3=Railways
4=Airlines
5=Other
Default Value: 1
INC_DATA_IND(SQL Table) |
Index Back |
|---|---|
India Related Incident DetailsThis record defines the Incident Details for India |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL |
Incident Number
Prompt Table: INCIDENT_DATA |
| 2 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL |
| 3 | HS_INC_SUB_IND | Character(1) | VARCHAR2(1) NOT NULL |
This field Defines the Incident Subtype for India specific
1=Work 2=Journey 3=Occupational Disease/Illness 4=Other Default Value: 1 |
| 4 | HS_ALCOHOL_IND | Character(1) | VARCHAR2(1) NOT NULL |
This field defines the Alcohol/Substance Taken for India
Y/N Table Edit |
| 5 | HS_REPORTED_BY_IND | Character(1) | VARCHAR2(1) NOT NULL |
This field defines the Reported By from External Agencies for a Incident for India
1=Police Report 2=State Transport Administration 3=Railways 4=Airlines 5=Other Default Value: 1 |