COMPANYGPBR_CNPJGPBR_BATCH_CODECALENDAR_YEARNID_CPF_BRAGPBR_DIRF_PA_VW(SQL View) |
Index Back |
|---|---|
View for DIRF AutonomousView for DIRF Autonomous |
| SELECT DISTINCT COMPANY ,GPBR_CNPJ ,gpbr_batch_code ,calendar_year ,nid_cpf_bra , name_display FROM PS_GPBR_AU_DIRF_PA |
| # | 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 | NID_CPF_BRA |
Character(20) | VARCHAR2(20) NOT NULL | Brazilian CPF National ID |
| 6 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |