GPBR_NRP_RF1_VW (SQL View)	Index Back
GRRF Finacial Information NRP GRRF Finacial Information from TRCT, used to store element map from elements to report target values. Element Relationship View.

GPBR_NRP_RF1_VW

(SQL View)

GRRF Finacial Information NRP

GRRF Finacial Information from TRCT, used to store element map from elements to report target values. Element Relationship View.

SELECT COMPANY , EFFDT , GPBR_GRRF_RT41 , GPBR_ENTRY_TYPE , PIN_NUM + 50000000 FROM PS_GPBR_PARM_GRRF1

# 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_GRRF_RT41 Character(3) VARCHAR2(3) NOT NULL GRRF Layout Field, used to keep layout field mapping.
010=Worked Days w/Right of Balance
020=Balance of Salary - Value
030=13th Salary /12th
040=13th Salary - Value
050=13th Indemnified Salary /12th
060=13th Indemnified Salary - Val
070=Expired Vacations - Value
080=Proportional Vacations /12th
090=Proportional Vacations - Value
100=1/3 Salary - Vacations
110=Family Allowance - Days
120=Family Allowance - Value
130=Nightly Additional - Value
140=Commissions - Value
150=Bonus - Value
160=Overtime - Quantity
170=Overtime - Value
180=Risk/Unhealthy Additional Val
190=Social Security Deduction
200=Soc Sec13th Salary Deduction
210=Payment Advances Deduction
220=Income Tax Deduction - IRRF

4 GPBR_ENTRY_TYPE Character(2) VARCHAR2(2) NOT NULL Entry type element
10=Earnings
20=Deductions

5 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
Prompt Table: %EDITTABLE

#	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_GRRF_RT41	Character(3)	VARCHAR2(3) NOT NULL	GRRF Layout Field, used to keep layout field mapping. 010=Worked Days w/Right of Balance 020=Balance of Salary - Value 030=13th Salary /12th 040=13th Salary - Value 050=13th Indemnified Salary /12th 060=13th Indemnified Salary - Val 070=Expired Vacations - Value 080=Proportional Vacations /12th 090=Proportional Vacations - Value 100=1/3 Salary - Vacations 110=Family Allowance - Days 120=Family Allowance - Value 130=Nightly Additional - Value 140=Commissions - Value 150=Bonus - Value 160=Overtime - Quantity 170=Overtime - Value 180=Risk/Unhealthy Additional Val 190=Social Security Deduction 200=Soc Sec13th Salary Deduction 210=Payment Advances Deduction 220=Income Tax Deduction - IRRF
4	GPBR_ENTRY_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Entry type element 10=Earnings 20=Deductions
5	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Prompt Table: %EDITTABLE