EMPLIDGPIN_TAX_YEARDefault Value: GPIN_SSTD_ADMIN.GPIN_TAX_YEAR
10=Saved for Later
20=Submitted
30=Not Declared
N=New Regime
O=Old Regime
Default Value: O
GPIN_TDS_MAIN_V(SQL View) |
Index Back |
|---|---|
Global payroll IndiaGP India Tax Deducted at Source |
| SELECT A.EMPLID , A.GPIN_TAX_YEAR , A.GPIN_SS_TD_STATUS , A.GPIN_SS_TD_TS , A.GPIN_TDS_NOTIFY_DT , A.GPIN_SS_SUBMIT_DT , A.GPIN_TAX_REGIME FROM PS_GPIN_TDS_MAIN A , PS_GPIN_TAX_YR_VW B WHERE A.GPIN_TAX_YEAR = B.GPIN_TAX_YEAR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 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 |
| 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 |