GP_PKG_IDSTATEGPIN_PT_SLVL_VALEFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
A=Yearly
M=Monthly
N=Half-Yearly
Q=Quarterly
Default Value: M
A=Yearly
M=Monthly
N=Half-Yearly
Q=Quarterly
Default Value: M
GPIN_NRP_PT1_AD(SQL Table) |
Index Back |
|---|---|
PT set up headerProfessional tax set up. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | STATE |
Character(6) | VARCHAR2(6) NOT NULL | State |
| 3 | GPIN_PT_SLVL_VAL |
Character(20) | VARCHAR2(20) NOT NULL | Sublevel value |
| 4 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 5 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
| 6 | GPIN_ENT_TYPE_CTG1 | Character(3) | VARCHAR2(3) NOT NULL | Professional tax search key 1 entry type |
| 7 | GPIN_ENT_TYPE_CTG2 | Character(3) | VARCHAR2(3) NOT NULL | Professional tax search key 2 entry type |
| 8 | GPIN_ENT_TYPE_CTG3 | Character(3) | VARCHAR2(3) NOT NULL | Professional tax search key 3 entry type |
| 9 | GPIN_PIN_PT1_NUM | Number(8,0) | INTEGER NOT NULL | Global payroll element containing the Slab search key 1 value. I.e. Category: Gender. |
| 10 | GPIN_PIN_PT2_NUM | Number(8,0) | INTEGER NOT NULL | Global payroll element containing the Slab search key 2 value. |
| 11 | GPIN_PIN_PT3_NUM | Number(8,0) | INTEGER NOT NULL | Global payroll element containing the Slab search key 3 value. |
| 12 | 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 |
| 13 | 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 |