| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
GPBR_MAN_ROW_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
MANAD Record Type
|
| 3 |
ESTAB_ID_BRA |
Character(20) |
VARCHAR2(20) NOT NULL |
Establishment ID Brazil
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 6 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 7 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 8 |
PYMNT_DT |
Date(10) |
DATE |
Date the payment should be sent to the bank for execution
|
| 9 |
RUN_TYPE |
Character(10) |
VARCHAR2(10) NOT NULL |
Run Type Name
|
| 10 |
PIN_NM |
Character(18) |
VARCHAR2(18) NOT NULL |
Element Name field
|
| 11 |
PIN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Element Type
|
| 12 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 13 |
SEFIP_CATEGORY_BRA |
Character(2) |
VARCHAR2(2) NOT NULL |
SEFIP CATEGORY Brazil
01=Employee
02=Temporary Worker
03=Worker w/FGTS benefit w/o link
04=Limited Period Employee
05=Director not employed w/FGTS
07=Underaged Intern
11=Director not employed w/o FGTS
12=Other Public Agents
13=Self-empl w/payment withholdng
14=Selfempl w/base-sal withholdng
15=Ind. transporter w/contr compe
16=Ind. transporter w/contr salar
17=Coop worker, Service Provider
18=Freight Coop, service provider
19=Political Agent
20=Non-permanent Governmnt Worker
21=Permanent Government Worker
22=Not Applicable
|
| 14 |
GPBR_SEFIP_RIS_LVL |
Character(2) |
VARCHAR2(2) NOT NULL |
SEFIP risk lever Brazil
00=Default
01=Non Exp.Harmful Agent
02=Exp. Ret. at 15 years
03=Exp. Ret. at 20 years
04=Exp. Ret. at 25 years
05=Non Exp. Harmful Agent M.Jobs
06=Exp. Ret. at 15 years M.Jobs
07=Exp. Ret. at 20 years M.Jobs
08=Exp. Ret. at 25 years M.Jobs
09=Not Applicable
|
| 15 |
GPBR_SERVICE_TAKER |
Character(3) |
VARCHAR2(3) NOT NULL |
Service Taker
|
| 16 |
GPBR_TAKER_INSCR |
Character(14) |
VARCHAR2(14) NOT NULL |
Service Taker Inscription
|
| 17 |
GPBR_RUN_TYPE_ID |
Character(1) |
VARCHAR2(1) NOT NULL |
Run Type ID
1=1-Regular Payroll
2=2-13th Salary
3=3-Vacations
4=4-Complementary Payroll
5=5-Complementary 13 Salary
6=6-Other
|
| 18 |
GPBR_MAN_EMP_FORM |
Character(1) |
VARCHAR2(1) NOT NULL |
MANAD Show EmplID + Empl Rcd
|
| 19 |
CBO_CD_BRA |
Character(7) |
VARCHAR2(7) NOT NULL |
Occupation Code for Brazil
|
| 20 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 21 |
GPBR_IT_BASE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Income Tax Base Type
1=1-Monthly Salary
2=2-13th Salary
9=9-Other Income Tax Bases
|
| 22 |
GPBR_IT2_BASE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Income Tax Base Type
|
| 23 |
GPBR_INSS_BSE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
INSS Base Type
1=1-Monthly Salary Base
2=2-13th Salary Base
3=3-Payee Discounted Amount
4=4-Family Salary Paid
5=5-Maternity Salary Base
6=6-Exclusive for FGTS Base
7=7-Base Discount
9=9-Other INSS Bases
|
| 24 |
GPBR_INS2_BSE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
INSS Base Type
|
| 25 |
GPBR_FAM_ALLOW_IND |
Number(1,0) |
SMALLINT NOT NULL |
Family Salary Brazil
|
| 26 |
GPBR_INC_TAX_IND |
Number(1,0) |
SMALLINT NOT NULL |
Income Tax Brazil
|
| 27 |
GPBR_IRRF_BASE_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 28 |
GPBR_INSS_BASE_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 29 |
CALC_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|