INCIDENT_NBR1=Typical
2=Illness
3=Route
1=Employer Establishment
2=Employee Service Taker
3=Public Thoroughfare
4=Rural Area
5=Other
Default Value: 1
Prompt Table: ESTAB_COMP_VW
Y/N Table Edit
Default Value: N
HS_INCIDENT_BRA(SQL Table) |
Index Back |
|---|---|
Incident BrazilIncident Brazil |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INCIDENT_NBR |
Character(8) | VARCHAR2(8) NOT NULL | Incident Number |
| 2 | CAT_INC_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
CAT Incident Type
1=Typical 2=Illness 3=Route |
| 3 | CAT_LOCTYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
CAT Location Type
1=Employer Establishment 2=Employee Service Taker 3=Public Thoroughfare 4=Rural Area 5=Other Default Value: 1 |
| 4 | NID_SPECIAL_CHAR | Character(20) | VARCHAR2(20) NOT NULL | NID as stored |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_COMP_VW |
| 7 | CAT_SPEC_LOC_BRA | Long Character | CLOB | CAT Specific Location |
| 8 | CAT_POLICE_REG_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Police Register for Brazil (CAT)
Y/N Table Edit Default Value: N |