GPBR_STG_WPLACE(SQL Table) |
Index Back |
---|---|
eSocial S-1060 BasTbl Main StgMain eSocial S-1060 (Workplace) event staging table. |
# | 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_TP_ENV | Character(1) | VARCHAR2(1) NOT NULL | eSocial Environment Identification |
4 | GPBR_ISSUER | Number(1,0) | SMALLINT NOT NULL | eSocial Issuer |
5 | GPBR_COMP_INS_TYPE | Character(1) | VARCHAR2(1) NOT NULL | eSocial Company Inscription Type |
6 | ESTAB_ID_BRA | Character(20) | VARCHAR2(20) NOT NULL | Establishment ID Brazil |
7 | GPBR_WPLACE_CODE | Character(30) | VARCHAR2(30) NOT NULL | eSocial workplace code. |
8 | BEGIN_DT | Date(10) | DATE | Begin Date |
9 | GPBR_PER_END_DT | Date(10) | DATE | Period End Date -- Vacations Brazil |
10 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
11 | WPLACE_LOC_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Worplace location.
1=Employer Establishment 2=Service Taker Establishment 3=Third Party Establishment |
12 | GPBR_COM_INS_TYPEE | Character(2) | VARCHAR2(2) NOT NULL | Company Inscription Type |
13 | GPBR_ESTAB_ID_EST | Character(20) | VARCHAR2(20) NOT NULL | Establishment ID |
14 | GPBR_COD_LOCAT | Character(30) | VARCHAR2(30) NOT NULL | eSocial Location Code |
15 | GPBR_INI_VAL_DATE | Date(10) | DATE | Initial Validity Date |
16 | GPBR_END_VAL_DATE | Date(10) | DATE | End Validity Date |
17 | DESCRLONG | Long Character | CLOB | Long Description |