GPBR_SHI1UPD_VW

(SQL View)
 Index Back

Basic Table - Work Shift

eSocial Stage Table This record is used to generate informations for eSocial layout S-1050 - Basic Table - Work Shift and Time Labor Table TAG "horarioIntervalo" inside TAG "alteracao"

SELECT A.GPBR_DRIVER_SEQ ,A.GPBR_DRV_SPLIT_SEQ ,A.GPBR_STOP_TYPE ,A.GPBR_STOP_SCHED ,A.GPBR_STOP_START ,A.GPBR_STOP_END FROM %Table(GPBR_STG_SHIFT1) A , %Table(GPBR_DRIVER_DAT) B WHERE A.GPBR_DRIVER_SEQ = B.GPBR_DRIVER_SEQ AND A.GPBR_DRV_SPLIT_SEQ = B.GPBR_DRV_SPLIT_SEQ AND B.GPBR_STATUS = 'XRDY' AND B.GPBR_ACTION = 'UPD' AND A.SCH_TYPE <> 'E'

# 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_STOP_TYPE Number(1,0) SMALLINT NOT NULL eSocial Stop Type
4 GPBR_STOP_SCHED Number(3,0) SMALLINT NOT NULL eSocial Stop Schedule
5 GPBR_STOP_START Character(4) VARCHAR2(4) NOT NULL eSocial Stop Start
6 GPBR_STOP_END Character(4) VARCHAR2(4) NOT NULL eSocial Stop End