GPBR_APPREN_VW

(SQL View)
 Index Back

Apprentice Staging Record

Staging Record. This record is used to generate information related to apprentice.

SELECT A.GPBR_DRIVER_SEQ , A.GPBR_DRV_SPLIT_SEQ , A.EMPLID , A.EMPL_RCD , A.EFFDT , A.CNTRCT_TYPE_AP_BRA , A.CNPJ_QUAL_ENT_BRA , A.INSCR_TYPE_BRA , A.ESTAB_ID_BRA , A.CNPJ_PRACT_ACT_BRA FROM %TAble(GPBR_STG_APPREN) 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'

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: PERSON

4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 EFFDT Date(10) DATE Effective Date

Default Value: %date

6 CNTRCT_TYPE_AP_BRA Character(1) VARCHAR2(1) NOT NULL Contract Type
1=Direct
2=Indirect
7 CNPJ_QUAL_ENT_BRA Character(14) VARCHAR2(14) NOT NULL CNPJ of Qualifying Entity
1=CNPJ
2=CPF
8 INSCR_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL Inscription Type
1=CNPJ
2=CPF
9 ESTAB_ID_BRA Character(20) VARCHAR2(20) NOT NULL Establishment ID Brazil
10 CNPJ_PRACT_ACT_BRA Character(14) VARCHAR2(14) NOT NULL CNPJ of Qualifying Entity