ESTABIDPrompt Table: ESTAB_TBL
GPIN_YEAR_CDGPIN_QUARTER_ID10=Q1
20=Q2
30=Q3
40=Q4
GPIN_SR_NBRCAL_PRD_IDEMPLIDGPIN_IT_PAN_NBRA=At Lower Rate
B=No Tax
C=At Higher Rate
GPIN_QTF24_EPAN(SQL Table) |
Index Back |
|---|---|
F24Q - Employee PAN DetailsF24Q - Employee PAN Details |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: ESTAB_TBL |
| 2 | GPIN_YEAR_CD |
Character(4) | VARCHAR2(4) NOT NULL | Year-Character |
| 3 | GPIN_QUARTER_ID |
Character(2) | VARCHAR2(2) NOT NULL |
This field specifies which quarter of the year payment is being made
10=Q1 20=Q2 30=Q3 40=Q4 |
| 4 | GPIN_SR_NBR |
Number(6,0) | INTEGER NOT NULL | Serial Number |
| 5 | CAL_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL | Calendar Period ID |
| 6 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | GPIN_IT_PAN_NBR |
Character(30) | VARCHAR2(30) NOT NULL | This Field is created for Establishment ID for Global Payroll Country Estension India. This field captures the Permanent Account Number. |
| 8 | GPIN_SEC197_DED | Character(1) | VARCHAR2(1) NOT NULL |
Deduction under section 197
A=At Lower Rate B=No Tax C=At Higher Rate |
| 9 | GPIN_CERTNO_SEC197 | Character(20) | VARCHAR2(20) NOT NULL | Certificate Number u/s 197 |