ESTABIDPrompt Table: GPIN_ESTAB_VW
GPIN_YEAR_CDGPIN_QUARTER_ID10=Q1
20=Q2
30=Q3
40=Q4
Y/N Table Edit
Default Value: Y
GPIN_QT_F24_TBL(SQL Table) |
Index Back |
|---|---|
Form 24Q period tableThis table gives the details of the Form 24Q quarterly report |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: GPIN_ESTAB_VW |
| 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_F24Q_EXISTS | Character(1) | VARCHAR2(1) NOT NULL |
Earlier Period Form24Q Exists?
Y/N Table Edit Default Value: Y |
| 5 | GPIN_F24Q_TOKEN_NO | Signed Number(16,0) | DECIMAL(15) NOT NULL | Earlier Form24Q Token No. |