GPAU_PYE_OVRD

(SQL View)
 Index Back

Aust Payee Override Table

Australian Payee Override main table.

SELECT EMPLID , EMPL_RCD , PIN_NUM , BGN_DT , END_DT , ENTRY_TYPE_ELEM , ENTRY_TYPE_AMT , ENTRY_TYPE_RATE , ENTRY_TYPE_UNIT , ENTRY_TYPE_BASE , ENTRY_TYPE_PCT , PIN_AMT_NUM , PIN_RATE_NUM , PIN_UNIT_NUM , PIN_BASE_NUM , PIN_PCT_NUM , 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 , ARR_PYBK_AMT_OPTN , ARR_PYBK_AMT 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 BGN_DT Date(10) DATE NOT NULL Begin Date

Default Value: %Date

5 END_DT Date(10) DATE end date
6 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

Prompt Table: GP_ENT_OVRD4_VW

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

Prompt Table: GP_ENT_PYAMT_VW

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

Prompt Table: GP_ENT_PYRT_VW

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

Prompt Table: GP_ENT_PYUN_VW

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

Prompt Table: GP_ENT_PYBSE_VW

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

Prompt Table: GP_ENT_PYPCT_VW

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

Prompt Table: %GP_EDIT_FLD1

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

Prompt Table: %GP_EDIT_FLD2

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

Prompt Table: %GP_EDIT_FLD3

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

Prompt Table: %GP_EDIT_FLD4

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

Prompt Table: %GP_EDIT_FLD5

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

Prompt Table: CURRENCY_CD_TBL

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

Y/N Table Edit

Default Value: Y

24 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

25 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

26 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

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

Prompt Table: GP_PIN_GC0_VW

28 ARR_PYBK_AMT_OPTN Character(1) VARCHAR2(1) NOT NULL Payback Option
A=Use Specified Amount
E=Use Element Payback Amount
N=No Limit
29 ARR_PYBK_AMT Number(19,6) DECIMAL(18,6) NOT NULL Maximum Arrears Payback Amount