GPBR_NRP_IRF_VW (SQL View)	Index Back
Monthly DIRF Parameters View Monthly DIRF Parameters View

GPBR_NRP_IRF_VW

(SQL View)

Monthly DIRF Parameters View

SELECT OPRID ,RUN_CNTL_ID ,GPBR_PAYROLL_TYPE ,GPBR_DIRF_PARM ,GPBR_ENTRY_DIRF , PIN_NUM + 50000000 FROM PS_GPBR_RC_DIRF_PM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

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

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

4 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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	GPBR_PAYROLL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Payroll Type Brazil 10=Regular Payroll 20=13 th. Salary 30=Profit Sharing Program
4	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
5	GPBR_ENTRY_DIRF	Character(2)	VARCHAR2(2) NOT NULL	DIRF Entry Type Earning / Deduction / Acumulator AC=Acumulator DD=Deduction ER=Earning
6	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number