GPBR_LBR_PRC_CV

(SQL Table)
Index Back

Labor Proceedings Calculation

Labor Proceedings - Calculation Values.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: GPBR_COMPBRA_VW

2 GPBR_PROC_SOURCE Character(1) VARCHAR2(1) NOT NULL Proceeding Source.
1=Judicial
2=Submitted to CCP or NINTER
3 GPBR_PROC_NUM Character(30) VARCHAR2(30) NOT NULL Proceeding Number
4 GPBR_CPF_ID Character(11) VARCHAR2(11) NOT NULL eSocial National ID Number
5 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
6 GPBR_DATE1 Date(10) DATE Date 1
7 GPBR_ESOC_AMT_01 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
8 GPBR_ESOC_AMT_02 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
9 GPBR_ESOC_AMT_03 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
10 GPBR_ESOC_AMT_04 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
11 GPBR_SEFIP_RIS_LVL Character(2) VARCHAR2(2) NOT NULL SEFIP risk lever Brazil
00=Default
01=Non Exp.Harmful Agent
02=Exp. Ret. at 15 years
03=Exp. Ret. at 20 years
04=Exp. Ret. at 25 years
05=Non Exp. Harmful Agent M.Jobs
06=Exp. Ret. at 15 years M.Jobs
07=Exp. Ret. at 20 years M.Jobs
08=Exp. Ret. at 25 years M.Jobs
09=Not Applicable
12 GPBR_ESOC_AMT_05 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
13 GPBR_ESOC_AMT_06 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
14 GPBR_DIRECT_PYMNT Character(1) VARCHAR2(1) NOT NULL Direct Payment.
N=No
Y=Yes
15 GPBR_LABOR_CAT_CD Character(3) VARCHAR2(3) NOT NULL eSocial Labor Category Legal Code

Prompt Table: GPBR_LCAT_CD_VW

16 GPBR_ESOC_AMT_07 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
17 GPBR_ESOC_AMT_08 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
18 GPBR_ESOC_AMT_09 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
19 GPBR_ESOC_AMT_10 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.