GPBR_R21_SEFIP(SQL Table) |
Index Back |
|---|---|
SEFIP Report Temp TableThis Record is used to store temporary R21 SEFIP report values |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | REC_TYPE | Character(2) | VARCHAR2(2) NOT NULL | Record type for discounts and perks eligibility flat file. This field tells the supplier whether the record is a header, detail or footer record. |
| 3 | GPBR_FIELD_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Field Type
0=Character 1=Long Char 2=Numeric 3=Signed Number 4=Date 5=Time 6=Date Time 7=Image |
| 4 | GPBR_INSCR | Character(14) | VARCHAR2(14) NOT NULL | Company Inscription Brazil |
| 5 | GPBR_TAKE_INS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Service Taker Inscription Type
1=Juridic Person National Reg 2=INSS Special Register |
| 6 | GPBR_STAKER_INSCR | Character(14) | VARCHAR2(14) NOT NULL | Service Taker Inscription Brazil |
| 7 | GPBR_CORRECT_COMP | Number(18,2) | DECIMAL(17,2) NOT NULL | Corrected Compensation |
| 8 | GPBR_START_YEAR | Number(4,0) | SMALLINT NOT NULL | Start Year |
| 9 | GPBR_START_MONTH | Number(2,0) | SMALLINT NOT NULL | Start Month |
| 10 | GPBR_END_YEAR | Number(4,0) | SMALLINT NOT NULL | End Year |
| 11 | GPBR_END_MONTH | Number(2,0) | SMALLINT NOT NULL | End Month |
| 12 | GPBR_INSS_PAYSLIP | Number(18,2) | DECIMAL(17,2) NOT NULL | Payslip INSS Value |
| 13 | GPBR_OTH_ENTITIES | Number(18,2) | DECIMAL(17,2) NOT NULL | Other Entities Value |