GPBR_LBR_REGIME

(SQL Table)
Index Back

Labor Regime BRA

eSocial Labor Regime BRA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Prompt Table: SETID_TBL

2 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

3 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification

Prompt Table: EMPL_CLASS_TBL

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
5 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code

Prompt Table: GPBR_LCAT_CD_VW

6 GPBR_WORK_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Work Type
0=Not Applicable
1=CLT
2=RJP

Default Value: 1

7 GPBR_SOC_SEC_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Social Security Type
0=Not Applicable
1=RGPS
2=RPPS
3=RPSE

Default Value: 1

8 GPBR_NAT_ACTV Character(1) VARCHAR2(1) NOT NULL eSocial Nature of Activity
0=Not Applicable
1=URBAN
2=RURAL

Default Value: 1