GPBR_STG_SH_EMP(SQL Table) |
Index Back |
---|---|
Labor Event eSocial shifteSocial Stage Table This record is used to generate informations for eSocial layout S-2100 - Labor Event - Employees Initial Loading - TAG- horario S-2200 - Labor Event � Hiring - TAG- horario S-2206 - Labor Event - Employment Contract Changes - TAG- horario |
# | 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_DAY_OFWEEK | Number(1,0) | SMALLINT NOT NULL | Shift day of week |
4 | ROTATION_ID | Character(10) | VARCHAR2(10) NOT NULL | Rotation ID |
5 | GPBR_SHIFT_ID | Character(30) | VARCHAR2(30) NOT NULL | eSocial Shift ID |