GPIN_NRP_PT1_VW(SQL View) |
Index Back |
|---|---|
PT set up headerProfessional tax set up. |
| SELECT STATE , GPIN_PT_SLVL_VAL , EFFDT , EFF_STATUS , GPIN_ENT_TYPE_CTG1 , GPIN_ENT_TYPE_CTG2 , GPIN_ENT_TYPE_CTG3 , GPIN_PIN_PT1_NUM + 50000000 , GPIN_PIN_PT2_NUM + 50000000 , GPIN_PIN_PT3_NUM + 50000000 , GPIN_PT_INCOM_FREQ , GPIN_PT_DEDUC_FREQ FROM PS_GPIN_PT_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  STATE |
Character(6) | VARCHAR2(6) NOT NULL |
State
Prompt Table: GPIN_STATE_VW |
| 2 | GPIN_PT_SLVL_VAL |
Character(20) | VARCHAR2(20) NOT NULL |
Sublevel value
Prompt Table: GPIN_DISTRT_VW |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 5 | GPIN_ENT_TYPE_CTG1 | Character(3) | VARCHAR2(3) NOT NULL |
Professional tax search key 1 entry type
Prompt Table: GPIN_ENT_PT1_VW |
| 6 | GPIN_ENT_TYPE_CTG2 | Character(3) | VARCHAR2(3) NOT NULL |
Professional tax search key 2 entry type
Prompt Table: GPIN_ENT_PT1_VW |
| 7 | GPIN_ENT_TYPE_CTG3 | Character(3) | VARCHAR2(3) NOT NULL |
Professional tax search key 3 entry type
Prompt Table: GPIN_ENT_PT1_VW |
| 8 | GPIN_PIN_PT1_NUM | Number(8,0) | INTEGER NOT NULL |
Global payroll element containing the Slab search key 1 value. I.e. Category: Gender.
Prompt Table: %GP_EDIT_FLD1 |
| 9 | GPIN_PIN_PT2_NUM | Number(8,0) | INTEGER NOT NULL |
Global payroll element containing the Slab search key 2 value.
Prompt Table: %GP_EDIT_FLD2 |
| 10 | GPIN_PIN_PT3_NUM | Number(8,0) | INTEGER NOT NULL |
Global payroll element containing the Slab search key 3 value.
Prompt Table: %GP_EDIT_FLD3 |
| 11 | GPIN_PT_INCOM_FREQ | Character(1) | VARCHAR2(1) NOT NULL |
Professional tax income frequency. Used to point out the gross salary range frequency
A=Yearly M=Monthly N=Half-Yearly Q=Quarterly Default Value: M |
| 12 | GPIN_PT_DEDUC_FREQ | Character(1) | VARCHAR2(1) NOT NULL |
Professional tax deduction frequency. Used to point out the PT tax imposed slab frequency.
A=Yearly M=Monthly N=Half-Yearly Q=Quarterly Default Value: M |