GPBR_R_SEFIP(SQL Table) |
Index Back |
|---|---|
SEFIP Report Temp TableThis Record is used to store temporary 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 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 4 | 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 |
| 5 | GPBR_INSCR | Character(14) | VARCHAR2(14) NOT NULL | Company Inscription Brazil |
| 6 | 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 |
| 7 | GPBR_STAKER_INSCR | Character(14) | VARCHAR2(14) NOT NULL | Service Taker Inscription Brazil |
| 8 | GPBR_REG_NUMBER | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 9 | GPBR_ADMISSION_DT | Character(8) | VARCHAR2(8) NOT NULL | Admission Date Brazil |
| 10 | GPBR_SEFIP_CAT | Character(2) | VARCHAR2(2) NOT NULL | SEFIP Category Brazil |
| 11 | APPLICANT_NAME | Character(70) | VARCHAR2(70) NOT NULL | Field to Capture Applicant Name in "First name" < >"Las name" format |
| 12 | GPBR_CTPS_ID | Character(7) | VARCHAR2(7) NOT NULL | CTPS National ID Brazil |
| 13 | GPBR_FGTS_DATE | Character(8) | VARCHAR2(8) NOT NULL | FGTS Date |
| 14 | GPBR_CTPS_SERIE | Character(5) | VARCHAR2(5) NOT NULL | CTPS Series |
| 15 | GPBR_BIRTH_DT | Character(8) | VARCHAR2(8) NOT NULL | Birth Date Brazil |
| 16 | GPBR_CBO_CODE | Character(5) | VARCHAR2(5) NOT NULL | CBO Code |
| 17 | GPBR_INS_DISC_VAL | Character(15) | VARCHAR2(15) NOT NULL | INS Discount Value |
| 18 | GPBR_13SAL_COMPENS | Character(15) | VARCHAR2(15) NOT NULL | 13th Salary Compensation |
| 19 | GPBR_MULTI_VINC | Character(2) | VARCHAR2(2) NOT NULL | SEFIP Category Brazil |
| 20 | GPBR_INSURED_DSC | Character(15) | VARCHAR2(15) NOT NULL | Insured Discount |
| 21 | GPBR_PROVIDENCE | Character(15) | VARCHAR2(15) NOT NULL | Providence Contribution |
| 22 | GPBR_PROV_13 | Character(15) | VARCHAR2(15) NOT NULL | Social Providence 13 |
| 23 | GPBR_GPS_PROV | Character(15) | VARCHAR2(15) NOT NULL | GPS Providence |
| 24 | EMPL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Status
A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration |
| 25 | GPBR_EMP_PERC_CONT | Number(3,0) | SMALLINT NOT NULL |
Employee's percentage contribution to social security.
Default Value: 0 |