COMPANYPrompt Table: GPBR_COMPBRA_VW
GPBR_PROC_SOURCE1=Judicial
2=Submitted to CCP or NINTER
GPBR_PROC_NUMGPBR_CPF_IDSEQNBRPAYMENT_DT1=Monthly
2=Fortnightly
3=Weekly
4=Daily
5=Hourly
6=Per Task
7=Commission
8=Other
GPBR_LBR_PRC_CA(SQL Table) |
Index Back |
|---|---|
Labor Proceedings ContractLabor Proceedings - Employment Contract Information. |
| # | 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 | PAYMENT_DT |
Date(10) | DATE NOT NULL | Payment Date |
| 7 | GPBR_VLREC | Number(17,2) | DECIMAL(16,2) NOT NULL | eSocial Payment |
| 8 | CONT_SAL_TYPE_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Contract Salary Type Brazil
1=Monthly 2=Fortnightly 3=Weekly 4=Daily 5=Hourly 6=Per Task 7=Commission 8=Other |
| 9 | GPBR_SAL_DESC | Character(90) | VARCHAR2(90) NOT NULL | Salary Description |