HAZARD_TBL_BRA(SQL Table) |
Index Back |
|---|---|
Hazard Table BRAHazard Table Brazil |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL |
| 2 | HAZARD_ID |
Character(5) | VARCHAR2(5) NOT NULL | Hazard ID |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |
| 7 | HAZARD_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Hazard Type Brazil
B=Biological Risk E=Ergonomic Risk F=Physical Risk M=Mechanical Risk Q=Chemical Risk |
| 8 | HAZARD_FACTOR_BRA | Character(40) | VARCHAR2(40) NOT NULL | Hazard Factor Brazil |
| 9 | HAZARD_SOURCE_BRA | Character(30) | VARCHAR2(30) NOT NULL | Hazard Source Brazil |
| 10 | HAZARD_TRAJECT_BRA | Character(30) | VARCHAR2(30) NOT NULL | Hazard Trajectory Brazil |
| 11 | HAZ_EVAL_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Hazard Evaluation Type Brazil
L=Qualitative N=Quantitative Default Value: L |
| 12 | HAZ_UNIT_ID_BRA | Character(10) | VARCHAR2(10) NOT NULL |
Hazard Unit
Prompt Table: HAZ_UNITS_BRA |
| 13 | HAZARD_UNITS_BRA | Number(14,5) | DECIMAL(13,5) NOT NULL | Hazard Units |
| 14 | HAZ_CONCEPT_ID_BRA | Character(10) | VARCHAR2(10) NOT NULL |
Hazard Concept
Prompt Table: HAZ_CONCEPT_BRA |
| 15 | HAZ_TOLERANCE_BRA | Number(14,5) | DECIMAL(13,5) NOT NULL | Tolerance Limit |
| 16 | HAZ_CONC_TYPE_BRA | Character(30) | VARCHAR2(30) NOT NULL |
Concept Type Brazil
Prompt Table:
HAZ_DTL_VW_BRA
|