COMPANYPrompt Table: GPBR_COMPBRA_VW
GPBR_PROC_SOURCE1=Judicial
2=Submitted to CCP or NINTER
GPBR_PROC_NUMGPBR_CPF_ID1=CNPJ
2=CPF
Prompt Table: STATE_BRA_VW
Prompt Table: CODE_CITY_BRA
1=CCP Company
2=CCP Union
3=NINTER
GPBR_LBR_PROC_H(SQL Table) |
Index Back |
|---|---|
Labor Proceedings BRA - HeaderLabor Proceedings BRA - Header |
| # | 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 | GPBR_DESCR3 | Character(30) | VARCHAR2(30) NOT NULL | eSocial Events Monitor - generic description. |
| 6 | GPBR_INSCR_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Inscription Type.
1=CNPJ 2=CPF |
| 7 | GPBR_INSCR_NUMBER | Character(20) | VARCHAR2(20) NOT NULL | Inscription Number. |
| 8 | DECIS_DATE_BRA | Date(10) | DATE | Desicion Date Legal Proceedings table |
| 9 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_BRA_VW |
| 10 | CITY | Character(30) | VARCHAR2(30) NOT NULL |
City
Prompt Table: CODE_CITY_BRA |
| 11 | COURTID_BRA | Number(4,0) | SMALLINT NOT NULL | Court ID Value BRA |
| 12 | GPBR_CONCIL_DATE | Date(10) | DATE | Date of Conciliation. |
| 13 | GPBR_AMBIT_AGRMNT | Character(1) | VARCHAR2(1) NOT NULL |
Ambit of Agreement
1=CCP Company 2=CCP Union 3=NINTER |
| 14 | GPBR_CNPJ | Character(14) | VARCHAR2(14) NOT NULL | Establlishment CNPJ Number |
| 15 | GPBR_COMMENTS | Long Character | CLOB | Comments. |