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 6=Establishment Outside Brazil |
| 4 | ID_SRV_TKR_BRA | Character(3) | VARCHAR2(3) NOT NULL |
Service Taker ID
Prompt Table: %EDITTABLE |
| 5 | NID_SPECIAL_CHAR | Character(20) | VARCHAR2(20) NOT NULL | NID as Stored |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: %EDITTABLE2 |
| 8 | WPLACE_CODE_BRA | Character(10) | VARCHAR2(10) NOT NULL |
Workplace code.
Prompt Table: %EDITTABLE3 |
| 9 | CAT_SPEC_LOC_BRA | Long Character | CLOB | CAT Specific Location |
| 10 | CAT_POLICE_REG_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Police Register for Brazil (CAT)
Y/N Table Edit Default Value: N |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |