GPBR_STG_RISK

(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 GPBR_EVENT_CD Character(6) VARCHAR2(6) NOT NULL eSocial - Event Code
4 GPBR_EVENT_ID Character(40) VARCHAR2(40) NOT NULL eSocial - Generate ID Number Governant
5 GPBR_RECT Number(30,0) DECIMAL(30) NOT NULL eSocial Ind Calculation
6 GPBR_RECEIPT_NUM Character(40) VARCHAR2(40) NOT NULL Receipt Num
7 GPBR_TP_ENV Character(1) VARCHAR2(1) NOT NULL eSocial Environment Identification
8 GPBR_ISSUER Number(1,0) SMALLINT NOT NULL eSocial Issuer
9 GPBR_VERSION Character(9) VARCHAR2(9) NOT NULL eSocial version
10 GPBR_COMP_INS_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Company Inscription Type
11 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
12 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
13 GPBR_NAT_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
14 GPBR_REG_ESOCIAL Character(30) VARCHAR2(30) NOT NULL eSocial eSocial Register
15 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code
16 GPBR_ES_PS Date(10) DATE eSocial on PeopleSoft Date
17 WPLACE_LOC_BRA Character(1) VARCHAR2(1) NOT NULL Worplace location.
1=Employer Establishment
2=Service Taker Establishment
3=Third Party Establishment
18 WPLACE_DESCR_BRA Character(100) VARCHAR2(100) NOT NULL Workplace description.
19 DESCRLONG Long Character CLOB Long Description
20 ENV_OBSER_BRA Long Character CLOB ENV_OBSER_BRA
21 GPBR_EVENT Character(6) VARCHAR2(6) NOT NULL eSocial Event Code
22 ESTAB_ID2_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil