GPBR_STG_JCD

(SQL Table)
Index Back

Basic Table - Job Code Table

eSocial Stage Table This record is used to generate informations for eSocial layout S-1030 - Basic Table - Job Code 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_SETID_JOBCODE Character(30) VARCHAR2(30) NOT NULL eSocial Job Code
8 BEGIN_DT Date(10) DATE Begin Date
9 GPBR_PER_END_DT Date(10) DATE Period End Date -- Vacations Brazil
10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
11 CBO_CD_BRA Character(7) VARCHAR2(7) NOT NULL Occupation Code for Brazil
12 GPBR_INI_VAL_DATE Date(10) DATE Initial Validity Date
13 GPBR_END_VAL_DATE Date(10) DATE End Validity Date