GPSC_ELM_ED

(SQL View)
 Index Back

Earnings & Deduction Setup

Earnings & Deduction Setup

SELECT PIN_NUM , EFFDT , EFF_STATUS , FREQUENCY_OPTN , FREQUENCY_ID , CURRENCY_CD , CALC_RULE , ENTRY_TYPE_AMT , ENTRY_TYPE_RATE , ENTRY_TYPE_UNIT , ENTRY_TYPE_PCT , ENTRY_TYPE_BASE , ENTRY_TYPE_RCP , PIN_AMT_NUM , PIN_RATE_NUM , PIN_UNIT_NUM , PIN_PCT_NUM , PIN_BASE_NUM , PIN_RCP_NUM , GP_AMT , GP_RATE , GP_UNIT , GP_PCT , GP_BASE , RECIPIENT_ID , PIN_GCTL_NUM , PIN_PYBK_DED_NUM , RTO_RECALC_OPTN , RND_OPTN_RATE , RND_OPTN_UNIT , RND_OPTN_PCT , RND_OPTN_BASE , RND_OPTN_RSLV , PIN_RND_RATE_NUM , PIN_RND_UNIT_NUM , PIN_RND_PCT_NUM , PIN_RND_BASE_NUM , PIN_RND_RSLV_NUM , PRORATION_OPTN , PIN_PRO_NUM , NET_PAY_VALID_IND , PART_AMT_ALLOW_IND , GP_PART_FRML_OPTN , PIN_PARTL_FRML_NUM , ARR_ALLOW_IND , ARR_PYBK_AMT_OPTN , ENTRY_TYPE_ARR_AMT , PIN_ARR_AMT_NUM , ARR_PYBK_AMT , ARR_PYBK_CNTL_OPTN , PIN_PRE_FRML_NUM , PIN_POST_FRML_NUM , DED_XFER_OPTN , GP_PRIORITY_NBR , GP_VERSION FROM PS_GP_ERN_DED WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , EFFDT , EFF_STATUS , FREQUENCY_OPTN , FREQUENCY_ID , CURRENCY_CD , CALC_RULE , ENTRY_TYPE_AMT , ENTRY_TYPE_RATE , ENTRY_TYPE_UNIT , ENTRY_TYPE_PCT , ENTRY_TYPE_BASE , ENTRY_TYPE_RCP , PIN_AMT_NUM , PIN_RATE_NUM , PIN_UNIT_NUM , PIN_PCT_NUM , PIN_BASE_NUM , PIN_RCP_NUM , GP_AMT , GP_RATE , GP_UNIT , GP_PCT , GP_BASE , RECIPIENT_ID , PIN_GCTL_NUM , PIN_PYBK_DED_NUM , RTO_RECALC_OPTN , RND_OPTN_RATE , RND_OPTN_UNIT , RND_OPTN_PCT , RND_OPTN_BASE , RND_OPTN_RSLV , PIN_RND_RATE_NUM , PIN_RND_UNIT_NUM , PIN_RND_PCT_NUM , PIN_RND_BASE_NUM , PIN_RND_RSLV_NUM , PRORATION_OPTN , PIN_PRO_NUM , NET_PAY_VALID_IND , PART_AMT_ALLOW_IND , GP_PART_FRML_OPTN , PIN_PARTL_FRML_NUM , ARR_ALLOW_IND , ARR_PYBK_AMT_OPTN , ENTRY_TYPE_ARR_AMT , PIN_ARR_AMT_NUM , ARR_PYBK_AMT , ARR_PYBK_CNTL_OPTN , PIN_PRE_FRML_NUM , PIN_POST_FRML_NUM , DED_XFER_OPTN , GP_PRIORITY_NBR , GP_VERSION FROM PS_GPSC_RM_ERN_DED WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

# 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
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 FREQUENCY_OPTN Character(2) VARCHAR2(2) NOT NULL Frequency Option
CP=Use Calendar Period Frequency
ED=Use Element Frequency
SP=Use Specified Frequency
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
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

Prompt Table: GP_ENT_RCP_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_PCT_NUM Number(8,0) INTEGER NOT NULL Percent to Accum Element

Prompt Table: %GP_EDIT_FLD4

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

Prompt Table: %GP_EDIT_FLD5

19 PIN_RCP_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD7

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

Prompt Table: RECIPIENT_G_VW

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

Prompt Table: GP_PIN_GC0_VW

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
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
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
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
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
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
34 PIN_RND_RATE_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

35 PIN_RND_UNIT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

36 PIN_RND_PCT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

37 PIN_RND_BASE_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

38 PIN_RND_RSLV_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

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
40 PIN_PRO_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_PO0_VW

41 NET_PAY_VALID_IND Character(1) VARCHAR2(1) NOT NULL Perform Net Pay Validation

Y/N Table Edit

42 PART_AMT_ALLOW_IND Character(1) VARCHAR2(1) NOT NULL Partial Amount Allowed

Y/N Table Edit

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.

Prompt Table: GP_PIN_FM_VW

45 ARR_ALLOW_IND Character(1) VARCHAR2(1) NOT NULL Deduction Arrears Allowed

Y/N Table Edit

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
47 ENTRY_TYPE_ARR_AMT Character(3) VARCHAR2(3) NOT NULL entry type array amount

Prompt Table: GP_ENT_APYBK_VW

48 PIN_ARR_AMT_NUM Number(8,0) INTEGER NOT NULL Arrears Amount element number

Prompt Table: %GP_EDIT_FLD6

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
51 PIN_PRE_FRML_NUM Number(8,0) INTEGER NOT NULL Pin Number

Prompt Table: GP_PIN_FM5_VW

52 PIN_POST_FRML_NUM Number(8,0) INTEGER NOT NULL Pin Number

Prompt Table: GP_PIN_FM5_VW

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
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.