GPBR_NRP_IRF_AD (SQL Table)	Index Back
Monthly DIRF Parameters Monthly DIRF Parameters

GPBR_NRP_IRF_AD

(SQL Table)

Monthly DIRF Parameters

# 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 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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_DIRF_PARM Character(4) VARCHAR2(4) NOT NULL Parameter DIRF
10=Taxable income
20=Deductions
30=Withholding tax
40=Compensated tax previous years
50=Compensated tax current year
60=Income tax suspended liability
70=Deduction suspended liability
80=Withholding tax sus. liability
90=Income tax in court deposit

6 GPBR_ENTRY_DIRF Character(2) VARCHAR2(2) NOT NULL DIRF Entry Type Earning / Deduction / Acumulator
AC=Acumulator
DD=Deduction
ER=Earning

7 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

#	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	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
3	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
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_DIRF_PARM	Character(4)	VARCHAR2(4) NOT NULL	Parameter DIRF 10=Taxable income 20=Deductions 30=Withholding tax 40=Compensated tax previous years 50=Compensated tax current year 60=Income tax suspended liability 70=Deduction suspended liability 80=Withholding tax sus. liability 90=Income tax in court deposit
6	GPBR_ENTRY_DIRF	Character(2)	VARCHAR2(2) NOT NULL	DIRF Entry Type Earning / Deduction / Acumulator AC=Acumulator DD=Deduction ER=Earning
7	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number