COMPANYGPBR_CNPJGPBR_BATCH_CODECALENDAR_YEARHPROV_CNPJ_BRAPrompt Table: GPBR_HPROV_VW
NID_CPF_BRAPrompt Table: GPBR_DIRF_PA_VW
GPBR_AU_DIRF_HE(SQL Table) |
Index Back |
|---|---|
Health Provider AutonomousHealth Provider Autonomous |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY |
Character(3) | VARCHAR2(3) NOT NULL | Company |
| 2 | GPBR_CNPJ |
Character(14) | VARCHAR2(14) NOT NULL | Establlishment CNPJ Number |
| 3 | GPBR_BATCH_CODE |
Character(15) | VARCHAR2(15) NOT NULL | Batch Code for Vacation Credit |
| 4 | CALENDAR_YEAR |
Number(4,0) | SMALLINT NOT NULL | Calendar Year |
| 5 | HPROV_CNPJ_BRA |
Character(14) | VARCHAR2(14) NOT NULL |
Health Provider CNPJ
Prompt Table: GPBR_HPROV_VW |
| 6 | NID_CPF_BRA |
Character(20) | VARCHAR2(20) NOT NULL |
Brazilian CPF National ID
Prompt Table: GPBR_DIRF_PA_VW |
| 7 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |