GPIN_YE_F6(SQL Table) |
Index Back |
|---|---|
Details of Form 6 for ESIDetails of Form 6 for ESI |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ESTABID |
Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: GPIN_YE_F6_HDR |
| 2 | CAL_PRD_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Calendar Period ID
Prompt Table: GPIN_YE_F6_HDR |
| 3 | DEPOSIT_DATE |
Date(10) | DATE | Deposit Date |
| 4 | AMOUNT | Signed Number(20,3) | DECIMAL(18,3) NOT NULL | Commuting Allowance Paid Per Cycle. |
| 5 | GPIN_MONTH | Character(3) | VARCHAR2(3) NOT NULL |
This is the month for which the Professional Tax is deducted.
APR=April AUG=August DEC=December FEB=February JAN=January JUL=July JUN=June MAR=March MAY=May NOV=November OCT=October SEP=September |
| 6 | BANK_CD | Character(11) | VARCHAR2(11) NOT NULL |
Bank ID
Prompt Table: GPIN_YE_BNK_VW |
| 7 | BRANCH_EC_CD | Character(17) | VARCHAR2(17) NOT NULL |
Bank Branch ID
Prompt Table: GPIN_YE_BKBR_VW |
| 8 | COUNTRY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Country Code
Default Value: IND |