GPBR_STG_LPCTVW

(SQL View)
 Index Back

Labor Proceedings BRA

Staging Record. This record is used to generate information related to eSocial layout S-2500 - Labor Proceedings.

SELECT DISTINCT LBR_CTR.GPBR_DRIVER_SEQ , LBR_CTR.GPBR_DRV_SPLIT_SEQ , LBR_CTR.SEQNBR , LBR_CTR.GPBR_PRC_CNTR_TYPE , LBR_CTR.GPBR_ESOC_SENT_IND , LBR_CTR.ORIG_HIRE_DT , LBR_CTR.GPBR_REINSTMT_IND , LBR_CTR.GPBR_EMP_CAT_CHG , LBR_CTR.GPBR_NAT_ACTV_CHG , LBR_CTR.GPBR_RSN_TERM_CHG , LBR_CTR.GPBR_CNTR_UNI_IND , LBR_CTR.REG_ESOCIAL_BRA , LBR_CTR.GPBR_EMP_LBR_CATEG , LBR_CTR.GPBR_HIRE_TSV_DT , LBR_CTR.CBO_CD_BRA , LBR_CTR.GPBR_NAT_ACTV , LBR_CTR.GPBR_WORK_TYPE , LBR_CTR.GPBR_SOC_SEC_TYPE , LBR_CTR.HIRE_DT , LBR_CTR.GPBR_PARCIAL_TIME , LBR_CTR.GPBR_CONTRACT_TYPE , LBR_CTR.CONTRACT_END_DT , LBR_CTR.GPBR_CNTRCT_CLAUSE , LBR_CTR.GPBR_DESCR254 , LBR_CTR.GPBR_INSCR_TYPE , LBR_CTR.GPBR_CNPJ_PREV , LBR_CTR.GPBR_REG_ESOC_PREV , LBR_CTR.GPBR_ORIG_DATE1 , LBR_CTR.TERMINATION_DT , LBR_CTR.GPBR_TERM_CODE , LBR_CTR.GPBR_TERM_NOTIF , LBR_CTR.GPBR_TERM_DT_FR , LBR_CTR.GPBR_ACTION_ABS , LBR_CTR.GPBR_ESTAB_IN_TYPE , LBR_CTR.GPBR_CNPJ , LBR_CTR.GPBR_DATE1 , LBR_CTR.GPBR_DATE2 , LBR_CTR.GPBR_PRC_REPERCUSS , LBR_CTR.GPBR_ESOC_AMT_01 , LBR_CTR.GPBR_ESOC_AMT_02 , LBR_CTR.GPBR_ESOC_AMT_03 , LBR_CTR.GPBR_ESOC_AMT_04 , LBR_CTR.GPBR_ESOC_AMT_05 , LBR_CTR.GPBR_FGTS_PAID , LBR_CTR.GPBR_ALIMONY_IND , LBR_CTR.GPBR_ALIM_FGTS_PER , LBR_CTR.GPBR_ALIM_FGTS_AMT , LBR_CTR.GPBR_PRC_REPER_IND , LBR_CTR.GPBR_UNEMP_BEN_REP , CASE WHEN LBALLW.GPBR_YEAR_CD IS NOT NULL THEN 'S' ELSE ' ' END FROM %Table(GPBR_STG_LP_CTR) LBR_CTR LEFT OUTER JOIN %Table(GPBR_STG_LBALLW) LBALLW ON LBALLW.GPBR_DRIVER_SEQ = LBR_CTR.GPBR_DRIVER_SEQ AND LBALLW.GPBR_DRV_SPLIT_SEQ = LBR_CTR.GPBR_DRV_SPLIT_SEQ AND LBALLW.SEQNBR = LBR_CTR.SEQNBR , %Table(GPBR_DRIVER_DAT) DRV WHERE LBR_CTR.GPBR_DRIVER_SEQ = DRV.GPBR_DRIVER_SEQ AND LBR_CTR.GPBR_DRV_SPLIT_SEQ = DRV.GPBR_DRV_SPLIT_SEQ AND DRV.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 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
4 GPBR_PRC_CNTR_TYPE Character(1) VARCHAR2(1) NOT NULL Contract Type.
1=Employee-No Change
2=Employee-Hire Date Changed
3=Employee-TerminationDtChanged
4=Employee-Hire and Term Changed
5=Employment Relation Recognized
6=TSVE-No Employment Relation
7=Empl Record prior to eSocial
8=Indirect Liability
9=Unified Employment Contracts
5 GPBR_ESOC_SENT_IND Character(1) VARCHAR2(1) NOT NULL Sent to eSocial Indicator.
N=No
Y=Yes
6 ORIG_HIRE_DT Date(10) DATE Original Start Date
7 GPBR_REINSTMT_IND Character(1) VARCHAR2(1) NOT NULL Reinstatement
N=No
Y=Yes
8 GPBR_EMP_CAT_CHG Character(1) VARCHAR2(1) NOT NULL Employee Category Changed.
N=No
Y=Yes
9 GPBR_NAT_ACTV_CHG Character(1) VARCHAR2(1) NOT NULL Nature of Activity Changed.
N=No
Y=Yes
10 GPBR_RSN_TERM_CHG Character(1) VARCHAR2(1) NOT NULL Reason for Termination Changed.
N=No
Y=Yes
11 GPBR_CNTR_UNI_IND Character(1) VARCHAR2(1) NOT NULL Contractual Unification Indicator.
N=No
Y=Yes
12 REG_ESOCIAL_BRA Character(30) VARCHAR2(30) NOT NULL eSocial Reg. Number
13 GPBR_EMP_LBR_CATEG Character(3) VARCHAR2(3) NOT NULL eSocial Employee Labor Category Code.
14 GPBR_HIRE_TSV_DT Date(10) DATE Hire TSV Date
15 CBO_CD_BRA Character(7) VARCHAR2(7) NOT NULL Occupation Code for Brazil
16 GPBR_NAT_ACTV Character(1) VARCHAR2(1) NOT NULL eSocial Nature of Activity
0=Not Applicable
1=URBAN
2=RURAL
17 GPBR_WORK_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Work Type
0=Not Applicable
1=CLT
2=RJP
18 GPBR_SOC_SEC_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Social Security Type
0=Not Applicable
1=RGPS
2=RPPS
3=RPSE
19 HIRE_DT Date(10) DATE First Start Date
20 GPBR_PARCIAL_TIME Character(1) VARCHAR2(1) NOT NULL Parcial Time
0=Not a part-time contract
1=Limited to 25 hours per week
2=Limited to 30 hours per week
3=Limited to 26 hours per week
21 GPBR_CONTRACT_TYPE Character(1) VARCHAR2(1) NOT NULL Contract Type.
1=Indeterminate
2=Determinate - Defined in Days
3=Determinate - Fact Occurred
22 CONTRACT_END_DT Date(10) DATE Contract End Date
23 GPBR_CNTRCT_CLAUSE Character(1) VARCHAR2(1) NOT NULL Clause of Mutual Termination Rights
N=No
Y=Yes
24 GPBR_DESCR254 Character(254) VARCHAR2(254) NOT NULL Description.
25 GPBR_INSCR_TYPE Character(1) VARCHAR2(1) NOT NULL Inscription Type.
1=CNPJ
2=CPF
26 GPBR_CNPJ_PREV Character(14) VARCHAR2(14) NOT NULL CNPJ Number Previous
27 GPBR_REG_ESOC_PREV Character(30) VARCHAR2(30) NOT NULL Register Previous Number
28 GPBR_ORIG_DATE1 Date(10) DATE Date 1
29 TERMINATION_DT Date(10) DATE Termination Date
30 GPBR_TERM_CODE Character(2) VARCHAR2(2) NOT NULL eSocial:Termination Legal Code.
31 GPBR_TERM_NOTIF Date(10) DATE Termination Notification
32 GPBR_TERM_DT_FR Date(10) DATE Termination Date From
33 GPBR_ACTION_ABS Character(2) VARCHAR2(2) NOT NULL Absence Type Action Brazil
01=Close
02=Continue After Return
34 GPBR_ESTAB_IN_TYPE Character(1) VARCHAR2(1) NOT NULL eSocial Establishment Inscription Type
1=CNPJ
3=CAEPF
4=CNO
35 GPBR_CNPJ Character(14) VARCHAR2(14) NOT NULL Establlishment CNPJ Number
36 GPBR_DATE1 Date(10) DATE Date 1
37 GPBR_DATE2 Date(10) DATE Date Field used by Negative Delta Writable Array
38 GPBR_PRC_REPERCUSS Character(1) VARCHAR2(1) NOT NULL Proceeding Repercussion.
1=With Payment of Remunation Amt
2=Without Payment of Remun Amt
39 GPBR_ESOC_AMT_01 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
40 GPBR_ESOC_AMT_02 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
41 GPBR_ESOC_AMT_03 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
42 GPBR_ESOC_AMT_04 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
43 GPBR_ESOC_AMT_05 Number(17,2) DECIMAL(16,2) NOT NULL eSocial generic amount.
44 GPBR_FGTS_PAID Character(1) VARCHAR2(1) NOT NULL FGTS Paid
N=No
Y=Yes
45 GPBR_ALIMONY_IND Character(1) VARCHAR2(1) NOT NULL Alimony Indicator
0=No Alimony
1=Percentage
2=Amount
3=Percentage and Amount
46 GPBR_ALIM_FGTS_PER Number(6,2) DECIMAL(5,2) NOT NULL Alimony percentage deduction of FGTS amount.
47 GPBR_ALIM_FGTS_AMT Signed Number(23,2) DECIMAL(21,2) NOT NULL Alimony deduction of FGTS amount.
48 GPBR_PRC_REPER_IND Character(1) VARCHAR2(1) NOT NULL Proceeding Repercussion Indicator.
1=With Tax Impact and/or FGTS
2=Without Tax Impact or FGTS
3=Exclusive for Income Statement
49 GPBR_UNEMP_BEN_REP Character(1) VARCHAR2(1) NOT NULL Unemployment Benefit Replacement.
N=No
Y=Yes
50 GPBR_SAL_ALLOW_IND Character(1) VARCHAR2(1) NOT NULL Salary Allowance Indicator.