| # |
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
T=Other
|
| 8 |
HAZARD_CODE_BRA |
Character(9) |
VARCHAR2(9) NOT NULL |
Hazard Code BRA
Prompt Table:
HAZAR_CO_VW_BRA
|
| 9 |
HAZ_AGE_CODE_BRA |
Character(9) |
VARCHAR2(9) NOT NULL |
Hazard Agent Code.
Prompt Table:
HAZ_AGE_TBL_BRA
|
| 10 |
HAZARD_FACTOR_BRA |
Character(40) |
VARCHAR2(40) NOT NULL |
Hazard Factor Brazil
|
| 11 |
HAZARD_SOURCE_BRA |
Character(30) |
VARCHAR2(30) NOT NULL |
Hazard Source Brazil
|
| 12 |
HAZARD_TRAJECT_BRA |
Character(30) |
VARCHAR2(30) NOT NULL |
Hazard Trajectory Brazil
|
| 13 |
HAZ_EVAL_TYPE_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Hazard Evaluation Type Brazil
L=Qualitative
N=Quantitative
Default Value: L
|
| 14 |
HAZ_UNIT_ID_BRA |
Character(10) |
VARCHAR2(10) NOT NULL |
Hazard Unit
Prompt Table:
HAZ_UN_VW_BRA
|
| 15 |
HAZARD_UNITS_BRA |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Hazard Units
|
| 16 |
HAZ_CONCEPT_ID_BRA |
Character(10) |
VARCHAR2(10) NOT NULL |
Hazard Concept
Prompt Table:
HAZ_CONCEPT_BRA
|
| 17 |
HAZ_TOLERANCE_BRA |
Number(14,5) |
DECIMAL(13,5) NOT NULL |
Tolerance Limit
|
| 18 |
HAZ_CONC_TYPE_BRA |
Character(30) |
VARCHAR2(30) NOT NULL |
Concept Type Brazil
Prompt Table:
HAZ_DTL_VW_BRA
Set Control Field: HAZ_CONC_TYPE_BRA
|
| 19 |
HAZARD_TECHNIC_BRA |
Character(40) |
VARCHAR2(40) NOT NULL |
Hazard Technique Used Brazil
|
| 20 |
QUESTION1_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Question 1 BRA
N=No
Y=Yes
Default Value: N
|
| 21 |
QUESTION2_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Question 1 BRA
N=No
Y=Yes
Default Value: N
|
| 22 |
QUESTION3_BRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Question 1 BRA
N=No
Y=Yes
Default Value: N
|