COMPANYPrompt Table: GPBR_COMPBRA_VW
GPBR_PROC_SOURCE1=Judicial
2=Submitted to CCP or NINTER
GPBR_PROC_NUMGPBR_CPF_IDSEQNBRREG_ESOCIAL_BRAGPBR_LABOR_CAT_CDPrompt Table: GPBR_LCAT_CD_VW
GPBR_HIRE_TSV_DTGPBR_LBR_PRC_UN(SQL Table) |
Index Back |
|---|---|
Labor Proceedings Unif CntrctLabor Proceedings - Unification of Contract |
| # | 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 | REG_ESOCIAL_BRA |
Character(30) | VARCHAR2(30) NOT NULL | eSocial Reg. Number |
| 7 | GPBR_LABOR_CAT_CD |
Character(3) | VARCHAR2(3) NOT NULL |
eSocial Labor Category Legal Code
Prompt Table: GPBR_LCAT_CD_VW |
| 8 | GPBR_HIRE_TSV_DT |
Date(10) | DATE | Hire TSV Date |