GP_NRP_PYEOV_VW

(SQL View)
 Index Back

Payee Override Table - view

Payee Override main table - Packaging View

SELECT EMPLID ,EMPL_RCD ,PIN_NUM + 50000000 ,INSTANCE ,BGN_DT ,END_DT ,PRC_ORDER ,ENTRY_TYPE_ELEM ,ENTRY_TYPE_AMT ,ENTRY_TYPE_RATE ,ENTRY_TYPE_UNIT ,ENTRY_TYPE_BASE ,ENTRY_TYPE_PCT ,PIN_AMT_NUM + 50000000 ,PIN_RATE_NUM + 50000000 ,PIN_UNIT_NUM + 50000000 ,PIN_BASE_NUM + 50000000 ,PIN_PCT_NUM + 50000000 ,GP_AMT ,GP_RATE ,GP_UNIT ,GP_BASE ,GP_PCT ,CURRENCY_CD ,PYE_APPL_IND ,FREQUENCY_OPTN ,FREQUENCY_ID ,GCTL_CND_OPTN ,PIN_GCTL_NUM + 50000000 ,ARR_PYBK_AMT_OPTN ,ENTRY_TYPE_ARR_AMT ,PIN_ARR_AMT_NUM + 50000000 ,ARR_PYBK_AMT ,RECIPIENT_TAG ,PRIOR_END_DATE ,BATCH_UPDATE_IND ,CHANGE_CAL_RUN_ID FROM PS_GP_PYE_OVRD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %RECNAME_EDIT

4 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
5 BGN_DT Date(10) DATE NOT NULL Begin Date

Default Value: %Date

6 END_DT Date(10) DATE end date
7 PRC_ORDER Number(3,0) SMALLINT NOT NULL Process Order

Default Value: 999

8 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

Prompt Table: GP_ENT_OVRD4_VW

9 ENTRY_TYPE_AMT Character(3) VARCHAR2(3) NOT NULL entry type amount

Prompt Table: GP_ENT_PYAMT_VW

10 ENTRY_TYPE_RATE Character(3) VARCHAR2(3) NOT NULL entry type rate

Prompt Table: GP_ENT_PYRT_VW

11 ENTRY_TYPE_UNIT Character(3) VARCHAR2(3) NOT NULL entry type unit

Prompt Table: GP_ENT_PYUN_VW

12 ENTRY_TYPE_BASE Character(3) VARCHAR2(3) NOT NULL entry type base

Prompt Table: GP_ENT_PYBSE_VW

13 ENTRY_TYPE_PCT Character(3) VARCHAR2(3) NOT NULL Entry Pype Percent Option

Prompt Table: GP_ENT_PYPCT_VW

14 PIN_AMT_NUM Number(8,0) INTEGER NOT NULL PIN-Number Amount

Prompt Table: %GP_EDIT_FLD1

15 PIN_RATE_NUM Number(8,0) INTEGER NOT NULL PinNumber Rate

Prompt Table: %GP_EDIT_FLD2

16 PIN_UNIT_NUM Number(8,0) INTEGER NOT NULL Pin-Number Unit

Prompt Table: %GP_EDIT_FLD3

17 PIN_BASE_NUM Number(8,0) INTEGER NOT NULL PIN-Number Base

Prompt Table: %GP_EDIT_FLD4

18 PIN_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element

Prompt Table: %GP_EDIT_FLD5

19 GP_AMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount
20 GP_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate
21 GP_UNIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit
22 GP_BASE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base
23 GP_PCT Signed Number(11,6) DECIMAL(9,6) NOT NULL Percent
24 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURRENCY_CD_TBL

25 PYE_APPL_IND Character(1) VARCHAR2(1) NOT NULL Payee Apply Override Indicator

Y/N Table Edit

Default Value: Y

26 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: ED

27 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

28 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

Default Value: E

29 PIN_GCTL_NUM Number(8,0) INTEGER NOT NULL Generation Control Number

Prompt Table: GP_PIN_GC0_VW

30 ARR_PYBK_AMT_OPTN Character(1) VARCHAR2(1) NOT NULL Payback Option
A=Use Specified Amount
E=Use Element Payback Amount
N=No Limit
31 ENTRY_TYPE_ARR_AMT Character(3) VARCHAR2(3) NOT NULL entry type array amount
32 PIN_ARR_AMT_NUM Number(8,0) INTEGER NOT NULL Arrears Amount element number
33 ARR_PYBK_AMT Number(19,6) DECIMAL(18,6) NOT NULL Maximum Arrears Payback Amount
34 RECIPIENT_TAG Number(3,0) SMALLINT NOT NULL Used to identify recipients for E/D, PI
35 PRIOR_END_DATE Date(10) DATE Contains the prior end date value (if any) of the Earnings/Deduction Assignment.
36 BATCH_UPDATE_IND Character(1) VARCHAR2(1) NOT NULL Indicates if the Batch Process is allowed to update the Earnings/Deduction Assignment End Date
37 CHANGE_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Indicates the Calendar Run in which the Earnings/Deduction Assignment End Date was updated