GP_PKG_ED1_VW

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	FREQUENCY_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Frequency Option CP=Use Calendar Period Frequency ED=Use Element Frequency SP=Use Specified Frequency Default Value: CP
5	FREQUENCY_ID	Character(5)	VARCHAR2(5) NOT NULL	Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency. Prompt Table: FREQUENCY_TBL
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Prompt Table: CURRENCY_CD_TBL
7	CALC_RULE	Character(2)	VARCHAR2(2) NOT NULL	Function Library field AM=Amount PB=Base * Percent RP=Unit * Rate * Percent RU=Unit * Rate Default Value: AM
8	ENTRY_TYPE_AMT	Character(3)	VARCHAR2(3) NOT NULL	entry type amount Prompt Table: GP_ENT_AMT_VW
9	ENTRY_TYPE_RATE	Character(3)	VARCHAR2(3) NOT NULL	entry type rate Prompt Table: GP_ENT_RATE_VW
10	ENTRY_TYPE_UNIT	Character(3)	VARCHAR2(3) NOT NULL	entry type unit Prompt Table: GP_ENT_UNIT_VW
11	ENTRY_TYPE_PCT	Character(3)	VARCHAR2(3) NOT NULL	Entry Pype Percent Option Prompt Table: GP_ENT_PCT_VW
12	ENTRY_TYPE_BASE	Character(3)	VARCHAR2(3) NOT NULL	entry type base Prompt Table: GP_ENT_BASE_VW
13	ENTRY_TYPE_RCP	Character(3)	VARCHAR2(3) NOT NULL	Recipient Type
14	PIN_AMT_NUM	Number(8,0)	INTEGER NOT NULL	PIN-Number Amount
15	PIN_RATE_NUM	Number(8,0)	INTEGER NOT NULL	PinNumber Rate
16	PIN_UNIT_NUM	Number(8,0)	INTEGER NOT NULL	Pin-Number Unit
17	PIN_PCT_NUM	Number(8,0)	INTEGER NOT NULL	Percent to Accum Element
18	PIN_BASE_NUM	Number(8,0)	INTEGER NOT NULL	PIN-Number Base
19	PIN_RCP_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
20	GP_AMT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Amount
21	GP_RATE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Rate
22	GP_UNIT	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Unit
23	GP_PCT	Signed Number(11,6)	DECIMAL(9,6) NOT NULL	Percent
24	GP_BASE	Signed Number(20,6)	DECIMAL(18,6) NOT NULL	Base
25	RECIPIENT_ID	Character(8)	VARCHAR2(8) NOT NULL	Payment recipient ID
26	PIN_GCTL_NUM	Number(8,0)	INTEGER NOT NULL	Generation Control Number
27	PIN_PYBK_DED_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
28	RTO_RECALC_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Retro Recalculation Option A=Always Recalculate D=Use Element Definition N=Do Not Recalculate Default Value: Y
29	RND_OPTN_RATE	Character(2)	VARCHAR2(2) NOT NULL	Rounding Option - Rate NR=No Rounding PG=Use Pay Group Rounding SP=Use Specified Rounding Default Value: PG
30	RND_OPTN_UNIT	Character(2)	VARCHAR2(2) NOT NULL	Rounding Option - Unit NR=No Rounding PG=Use Pay Group Rounding SP=Use Specified Rounding Default Value: PG
31	RND_OPTN_PCT	Character(2)	VARCHAR2(2) NOT NULL	Rounding Option - Percent NR=No Rounding PG=Use Pay Group Rounding SP=Use Specified Rounding Default Value: PG
32	RND_OPTN_BASE	Character(2)	VARCHAR2(2) NOT NULL	Rounding Option - Base NR=No Rounding PG=Use Pay Group Rounding SP=Use Specified Rounding Default Value: PG
33	RND_OPTN_RSLV	Character(2)	VARCHAR2(2) NOT NULL	Rounding Option - Resolved Amt NR=No Rounding PG=Use Pay Group Rounding SP=Use Specified Rounding Default Value: NR
34	PIN_RND_RATE_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
35	PIN_RND_UNIT_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
36	PIN_RND_PCT_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
37	PIN_RND_BASE_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
38	PIN_RND_RSLV_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
39	PRORATION_OPTN	Character(2)	VARCHAR2(2) NOT NULL	Proration Option NP=No Proration PG=Use Pay Group Proration Rule SP=Use Specified Proration Rule Default Value: PG
40	PIN_PRO_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
41	NET_PAY_VALID_IND	Character(1)	VARCHAR2(1) NOT NULL	Perform Net Pay Validation Y/N Table Edit Default Value: Y
42	PART_AMT_ALLOW_IND	Character(1)	VARCHAR2(1) NOT NULL	Partial Amount Allowed Y/N Table Edit Default Value: N
43	GP_PART_FRML_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Partial Formula Option - Deduction amount is set via the result of a formula defined by the rule developer. The formula is attached to the deduction on the Arrears page N=Use Remaining Net Y=Set Via Formula
44	PIN_PARTL_FRML_NUM	Number(8,0)	INTEGER NOT NULL	Partial Formula Element - Pin Number of partial formula element. Partial Formula is used to set Deduction amount via a formula.
45	ARR_ALLOW_IND	Character(1)	VARCHAR2(1) NOT NULL	Deduction Arrears Allowed Y/N Table Edit Default Value: N
46	ARR_PYBK_AMT_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Payback Option A=Use Specified Amount E=Use Element Payback Amount N=No Limit Default Value: N
47	ENTRY_TYPE_ARR_AMT	Character(3)	VARCHAR2(3) NOT NULL	entry type array amount
48	PIN_ARR_AMT_NUM	Number(8,0)	INTEGER NOT NULL	Arrears Amount element number
49	ARR_PYBK_AMT	Number(19,6)	DECIMAL(18,6) NOT NULL	Maximum Arrears Payback Amount
50	ARR_PYBK_CNTL_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Arrears Payback Controlled By R=All Pay Runs S=Deduction Schedule Default Value: R
51	PIN_PRE_FRML_NUM	Number(8,0)	INTEGER NOT NULL	Pin Number
52	PIN_POST_FRML_NUM	Number(8,0)	INTEGER NOT NULL	Pin Number
53	DED_XFER_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Deduction Transfer Option: The Amount Calculated or the amount taken. Default is Amount Taken. Has meaning only in the case of a payee not having enough salary to cover all deductions. C=Amount Calculated T=Amount Taken Default Value: T
54	GP_PRIORITY_NBR	Number(3,0)	SMALLINT NOT NULL	Priority Order - defines order in which deductions are processed within a calculation. This is only applicaple for deductions placed on a sub-process section of type NPV in Prioirty Order
55	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.