GPBR_STG_RISK01

(SQL Table)
Index Back

Non Periodic Event S-2240

eSocial Stage Table This record is used to generate informations for eSocial layout S-2240

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPBR_DRIVER_SEQ Number(30,0) DECIMAL(30) NOT NULL Driver Sequence
2 GPBR_DRV_SPLIT_SEQ Number(20,0) DECIMAL(20) NOT NULL eSocial - Split Sequence
3 HAZ_AGE_CODE_BRA Character(9) VARCHAR2(9) NOT NULL Hazard Agent Code.
4 DESCRLONG Long Character CLOB Long Description
5 HAZ_EVAL_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Hazard Evaluation Type Brazil
L=Qualitative
N=Quantitative
6 HAZ_UNIT_ID_BRA Character(10) VARCHAR2(10) NOT NULL Hazard Unit
7 HAZARD_UNITS_BRA Number(14,5) DECIMAL(13,5) NOT NULL Hazard Units
8 HAZ_TOLERANCE_BRA Number(14,5) DECIMAL(13,5) NOT NULL Tolerance Limit
9 HAZARD_TECHNIC_BRA Character(40) VARCHAR2(40) NOT NULL Hazard Technique Used Brazil
10 CPE_INFO_QU1_BRA Character(1) VARCHAR2(1) NOT NULL CPE Information Question 1 Does the Company implement collective protection measures (CPEs) to eliminate or reduce worker�s exposure to the risk factor?
0=Not Applicable
1=Not Implement
2=Implement
11 CPE_INFO_QU2_BRA Character(1) VARCHAR2(1) NOT NULL CPE Information Question 2 Are CPEs effective in neutralizing risks to the worker?
N=No
Y=Yes
12 CPE_INFO_QU3_BRA Character(1) VARCHAR2(1) NOT NULL CPE Information Question 3 Utilization of IPE: Mandatory
0=Not Applicable
1=Not Used
2=Used
13 IPE_INFO_QU1_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
14 IPE_INFO_QU2_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
15 IPE_INFO_QU3_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
16 IPE_INFO_QU4_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
17 IPE_INFO_QU5_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
18 IPE_INFO_QU6_BRA Character(1) VARCHAR2(1) NOT NULL Question for IPE Information
N=No
Y=Yes
19 IPE_EFF_BRA Character(1) VARCHAR2(1) NOT NULL IPE Code BRA Value
N=No
Y=Yes
20 PROCEED_NBR_BRA Character(20) VARCHAR2(20) NOT NULL Proceeding Number