EMPLIDPrompt Table: PERS_SRCH_GBL
EMPL_RCDEFFDTPIN_NUMPrompt Table: GPNL_PIN_TAX_VW
GPNL_NRP_TAX_VW(SQL View) |
Index Back |
|---|---|
Tax Reductions (Export View)Export view for the deduction assignements for tax reductions. |
| SELECT EMPLID , EMPL_RCD , EFFDT , PIN_NUM+50000000 , GPNL_AUTH_DT FROM PS_GPNL_EE_TAX_DD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERS_SRCH_GBL |
| 2 | EMPL_RCD |
Number(3,0) | SMALLINT NOT NULL | Empl Rcd Nbr |
| 3 | EFFDT |
Date(10) | DATE NOT NULL | Effective Date |
| 4 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GPNL_PIN_TAX_VW |
| 5 | GPNL_AUTH_DT | Date(10) | DATE | Authorization Date |