GPBR_END_YEARGPBR_START_MONTHGPBR_INSCRPrompt Table: GPBR_EID_EST_VW
GPBR_TAKE_INS_TYPE1=Juridic Person National Reg
2=INSS Special Register
3=Phisic Person National Reg
GPBR_STAKER_INSCRGPBR_REG_NUMBERDefault Value: 0
Default Value: 0
GPBR_SEFIP_AUTO(SQL Table) |
Index Back |
|---|---|
SEFIP Autonomous EmployeesRecord used to keep autonomous information to be reported in SEFIP. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPBR_END_YEAR |
Number(4,0) | SMALLINT NOT NULL | End Year |
| 2 | GPBR_START_MONTH |
Number(2,0) | SMALLINT NOT NULL | Start Month |
| 3 | GPBR_INSCR |
Character(14) | VARCHAR2(14) NOT NULL |
Company Inscription Brazil
Prompt Table: GPBR_EID_EST_VW |
| 4 | GPBR_TAKE_INS_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Service Taker Inscription Type
1=Juridic Person National Reg 2=INSS Special Register 3=Phisic Person National Reg |
| 5 | GPBR_STAKER_INSCR |
Character(14) | VARCHAR2(14) NOT NULL | Service Taker Inscription Brazil |
| 6 | GPBR_REG_NUMBER |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | GPBR_SEFIP_CAT | Character(2) | VARCHAR2(2) NOT NULL | SEFIP Category Brazil |
| 8 | GPBR_PERS_NAME | Character(70) | VARCHAR2(70) NOT NULL | Used to keep a person name. |
| 9 | GPBR_CBO_CODE | Character(5) | VARCHAR2(5) NOT NULL | CBO Code |
| 10 | GPBR_INS_DISC_VAL | Character(15) | VARCHAR2(15) NOT NULL |
INS Discount Value
Default Value: 0 |
| 11 | GPBR_MULTI_VINC | Character(2) | VARCHAR2(2) NOT NULL | SEFIP Category Brazil |
| 12 | GPBR_INSURED_DSC | Character(15) | VARCHAR2(15) NOT NULL |
Insured Discount
Default Value: 0 |
| 13 | GPBR_BATCH_CODE | Character(15) | VARCHAR2(15) NOT NULL | Batch Code for Vacation Credit |
| 14 | GPBR_REFERENCE | Character(20) | VARCHAR2(20) NOT NULL | Used to keep reference data. |