GPBR_RISK05_VW

(SQL View)
 Index Back

Non Periodic Event S-2240

eSocial Stage Table This record is used to generate informations for eSocial layout S-2240

SELECT A.GPBR_DRIVER_SEQ ,A.GPBR_DRV_SPLIT_SEQ ,A.NID_CPF_BRA ,A.PIS_BRA ,A.GPBR_PERS_NAME ,A.ORG_STAT2_BRA ,A.ORG_STAT_DESC_BRA ,A.MED_CRM_BRA ,A.STATE FROM PS_GPBR_STG_RISK05 A , PS_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 NID_CPF_BRA Character(20) VARCHAR2(20) NOT NULL Brazilian CPF National ID
4 PIS_BRA Character(14) VARCHAR2(14) NOT NULL PIS / NIS Number
5 GPBR_PERS_NAME Character(70) VARCHAR2(70) NOT NULL Used to keep a person name.
6 ORG_STAT2_BRA Character(1) VARCHAR2(1) NOT NULL Organ Statutory Information
0=Not Applicable
1=CRM
4=CREA
9=Other
7 ORG_STAT_DESC_BRA Character(20) VARCHAR2(20) NOT NULL Organ Statutory Information
0=RMS
8 MED_CRM_BRA Character(15) VARCHAR2(15) NOT NULL Medical Certication Register.
9 STATE Character(6) VARCHAR2(6) NOT NULL State