GPES_TAX_FLX_IDEFFDTDefault Value: %date
PIN_NUMPrompt Table: %GP_EDIT_FLD4
Prompt Table: GPES_ENT_FLX_VW
Prompt Table: %RECNAME_EDIT
Prompt Table: FREQUENCY_TBL
GPES_NRP_TX9_VW(SQL View) |
Index Back |
|---|---|
Adjust Tax Estimatn Rules ESPAdjust Tax Estimation 2 ESP. Earnings & Rules |
| SELECT GPES_TAX_FLX_ID , EFFDT , PIN_NUM + 50000000 , ENTRY_TYPE_ID , PIN_NUM_2 + 50000000 , FREQUENCY_ID FROM PS_GPES_TAX_FLXERN |
| # | 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 |