EMPLIDPrompt Table: PERS_SRCH_GBL
GPIN_TAX_YEARDefault Value: GPIN_SSTD_ADMIN.GPIN_TAX_YEAR
10=Saved for Later
20=Submitted
30=Not Declared
Default Value: 30
N=New Regime
O=Old Regime
Default Value: O
GPIN_TDS_MAIN(SQL Table) |
Index Back |
|---|---|
Main record for Approved DeclaThis record serves as main record for Approved amounts page |
| # | 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 | GPIN_TAX_YEAR |
Number(4,0) | SMALLINT NOT NULL |
This field is used to store the Tax Year.
Default Value: GPIN_SSTD_ADMIN.GPIN_TAX_YEAR |
| 3 | GPIN_SS_TD_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
This field is used to store the Self-Service declaration status of an Employee.
10=Saved for Later 20=Submitted 30=Not Declared Default Value: 30 |
| 4 | GPIN_SS_TD_TS | DateTime(26) | TIMESTAMP | Self Service Time Stamp |
| 5 | GPIN_TDS_NOTIFY_DT | Date(10) | DATE | This field is used to store the date on which the employee is last notified to review the approved amounts of his/her Tax investment declarations. |
| 6 | GPIN_SS_SUBMIT_DT | Date(10) | DATE | Submit Date |
| 7 | GPIN_TAX_REGIME | Character(1) | VARCHAR2(1) NOT NULL |
Tax Regime field for the new Tax Regime
N=New Regime O=Old Regime Default Value: O |