GPES_TAX_FLXERN

(SQL Table)
Index Back

Adjust Tax Estimatn Rules ESP

Adjust Tax Estimation 2 ESP. Earnings & Rules

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPES_TAX_FLX_ID Character(6) VARCHAR2(6) NOT NULL Tax estimation set id
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %GP_EDIT_FLD4

4 ENTRY_TYPE_ID Character(3) VARCHAR2(3) NOT NULL Element Entry Type ID

Prompt Table: GPES_ENT_FLX_VW

5 PIN_NUM_2 Number(8,0) INTEGER NOT NULL Pin Number 2

Prompt Table: %RECNAME_EDIT

6 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