GPBR_STG_RISK(SQL Table) |
Index Back |
---|---|
Non Periodic Event S-2240eSocial 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 |