| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 GP_PKG_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Field used for element packaging
|
| 2 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 4 |
GPBR_PAYROLL_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Payroll Type Brazil
10=Regular Payroll
20=13 th. Salary
30=Profit Sharing Program
|
| 5 |
GPBR_SECTYPE_DIRF |
Character(2) |
VARCHAR2(2) NOT NULL |
Parameter Type DIRF
65=>=65 Non Taxable Prt Incme
AP=PLR - Alimony
CV=Credit Vacation
DD=Dependents
IN=Taxable Income
IP=PLR - Taxable Income
LP=Late Payment Interest Received
OT=Other Non-Taxable Income
PA=Alimony
PD=Per Diary & Cost Allowances
PO=Official Welfare
PP=Private Welfare and FAPI
RP=PLR - Withholding Tax
SP=Supp Fund by Disease Carrier
TI=Termination Indemnity
TX=Withholding Tax
|
| 6 |
GPBR_ENTYPE_DIRF |
Character(2) |
VARCHAR2(2) NOT NULL |
Entry Type DIRF.
DD=Deductions
ER=Earnings
|
| 7 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 8 |
GPBR_SIGN_USE |
Character(1) |
VARCHAR2(1) NOT NULL |
Sign Use
A=Add
S=Substract
|
| 9 |
GPBR_SIGN_NBR |
Signed Number(3,0) |
DECIMAL(2) NOT NULL |
Sign number
|
| 10 |
FAPI_CD_BRA |
Character(10) |
VARCHAR2(10) NOT NULL |
Fapi Provider Code
|