GP_NRP_PYEOV_AD

(SQL Table)
Index Back

Payee Override Table

Payee Override main table.

# 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 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
5 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
6 BGN_DT Date(10) DATE Begin Date
7 END_DT Date(10) DATE end date
8 PRC_ORDER Number(3,0) SMALLINT NOT NULL Process Order
9 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element
10 ENTRY_TYPE_AMT Character(3) VARCHAR2(3) NOT NULL entry type amount
11 ENTRY_TYPE_RATE Character(3) VARCHAR2(3) NOT NULL entry type rate
12 ENTRY_TYPE_UNIT Character(3) VARCHAR2(3) NOT NULL entry type unit
13 ENTRY_TYPE_BASE Character(3) VARCHAR2(3) NOT NULL entry type base
14 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option
15 PIN_AMT_NUM Number(8,0) INTEGER NOT NULL PIN-Number Amount
16 PIN_RATE_NUM Number(8,0) INTEGER NOT NULL PinNumber Rate
17 PIN_UNIT_NUM Number(8,0) INTEGER NOT NULL Pin-Number Unit
18 PIN_BASE_NUM Number(8,0) INTEGER NOT NULL PIN-Number Base
19 PIN_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element
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_BASE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base
24 GP_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL Percent
25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
26 PYE_APPL_IND Character(1) VARCHAR2(1) NOT NULL Payee Apply Override Indicator
27 FREQUENCY_OPTN Character(2) VARCHAR2(2) NOT NULL Frequency Option
CP=Use Calendar Period Frequency
ED=Use Element Frequency
SP=Use Specified Frequency
28 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.
29 GCTL_CND_OPTN Character(1) VARCHAR2(1) NOT NULL Generation Control Options
E=Use Element Generation Control
N=No Generation Control
S=Specified Generation Control
30 PIN_GCTL_NUM Number(8,0) INTEGER NOT NULL Generation Control Number
31 ARR_PYBK_AMT_OPTN Character(1) VARCHAR2(1) NOT NULL Payback Option
A=Use Specified Amount
E=Use Element Payback Amount
N=No Limit
32 ENTRY_TYPE_ARR_AMT Character(3) VARCHAR2(3) NOT NULL entry type array amount
33 PIN_ARR_AMT_NUM Number(8,0) INTEGER NOT NULL Arrears Amount element number
34 ARR_PYBK_AMT Number(19,6) DECIMAL(18,6) NOT NULL Maximum Arrears Payback Amount
35 RECIPIENT_TAG Number(3,0) SMALLINT NOT NULL Used to identify recipients for E/D, PI
36 PRIOR_END_DATE Date(10) DATE Contains the prior end date value (if any) of the Earnings/Deduction Assignment.
37 BATCH_UPDATE_IND Character(1) VARCHAR2(1) NOT NULL Indicates if the Batch Process is allowed to update the Earnings/Deduction Assignment End Date
38 CHANGE_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Indicates the Calendar Run in which the Earnings/Deduction Assignment End Date was updated