GPBR_STG_LP_CTR(SQL Table) |
Index Back |
---|---|
Labor Proceedings BRAStaging Record. This record is used to generate information related to eSocial layout S-2500 - Labor Proceedings. |
# | 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 |