GPBR_NRP_DIR_VW (SQL View)	Index Back
DIRF Tax Income Elements DIRF Tax Income Elements element relationship view

GPBR_NRP_DIR_VW

(SQL View)

DIRF Tax Income Elements

DIRF Tax Income Elements element relationship view

SELECT COMPANY , EFFDT , GPBR_PAYROLL_TYPE , GPBR_SECTYPE_DIRF , GPBR_ENTYPE_DIRF , PIN_NUM + 50000000 , GPBR_SIGN_USE , GPBR_SIGN_NBR FROM PS_GPBR_DIRF_DATA

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 GPBR_PAYROLL_TYPE Character(2) VARCHAR2(2) NOT NULL Payroll Type Brazil
10=Regular Payroll
20=13 th. Salary
30=Profit Sharing Program
Default Value: 10

4 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
PA=Alimony
PD=Per Diary & Cost Allowances
PO=Official Welfare
PP=Private Welfare and FAPI
RP=PLR - Withholding Tax
TI=Termination Indemnity
TX=Withholding Tax
Default Value: IN

5 GPBR_ENTYPE_DIRF Character(2) VARCHAR2(2) NOT NULL Entry Type DIRF.
DD=Deductions
ER=Earnings
Default Value: DD

6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: %EDITTABLE2

7 GPBR_SIGN_USE Character(1) VARCHAR2(1) NOT NULL Sign Use
A=Add
S=Substract
Default Value: A

8 GPBR_SIGN_NBR Signed Number(3,0) DECIMAL(2) NOT NULL Sign number

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	GPBR_PAYROLL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Payroll Type Brazil 10=Regular Payroll 20=13 th. Salary 30=Profit Sharing Program Default Value: 10
4	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 PA=Alimony PD=Per Diary & Cost Allowances PO=Official Welfare PP=Private Welfare and FAPI RP=PLR - Withholding Tax TI=Termination Indemnity TX=Withholding Tax Default Value: IN
5	GPBR_ENTYPE_DIRF	Character(2)	VARCHAR2(2) NOT NULL	Entry Type DIRF. DD=Deductions ER=Earnings Default Value: DD
6	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %EDITTABLE2
7	GPBR_SIGN_USE	Character(1)	VARCHAR2(1) NOT NULL	Sign Use A=Add S=Substract Default Value: A
8	GPBR_SIGN_NBR	Signed Number(3,0)	DECIMAL(2) NOT NULL	Sign number