GPBR_R20_SEFIP(SQL Table) |
Index Back |
|---|---|
SEFIP Report Temp TableThis Record is used to store temporary R20 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 3=Phisic Person National Reg |
| 6 | GPBR_STAKER_INSCR | Character(14) | VARCHAR2(14) NOT NULL | Service Taker Inscription Brazil |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | ADDRESS1 | Character(55) | VARCHAR2(55) NOT NULL | Address 1 |
| 9 | ADDRESS4 | Character(55) | VARCHAR2(55) NOT NULL | Address 4 |
| 10 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 11 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 12 | STATE | Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: STATE_TBL |
| 13 | GPS_PAY_CD_BRA | Number(4,0) | SMALLINT NOT NULL | Payment Code for GPS (Social Security Contribution Code) |
| 14 | GPBR_13SAL_COMPENS | Character(15) | VARCHAR2(15) NOT NULL | 13th Salary Compensation |
| 15 | GPBR_INSURED_DSC | Character(15) | VARCHAR2(15) NOT NULL | Insured Discount |
| 16 | GPBR_KEY_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Define the Key Type for Element Mapping (Record or Component)
C=Component R=Record |
| 17 | GPBR_PROVIDENCE | Character(15) | VARCHAR2(15) NOT NULL | Providence Contribution |
| 18 | GPBR_PROV_13 | Character(15) | VARCHAR2(15) NOT NULL | Social Providence 13 |
| 19 | GPBR_GPS_PROV | Character(15) | VARCHAR2(15) NOT NULL | GPS Providence |