RUN_CNTL_IDOPRIDGPIN_MONTHAPR=April
AUG=August
DEC=December
FEB=February
JAN=January
JUL=July
JUN=June
MAR=March
MAY=May
NOV=November
OCT=October
SEP=September
GPIN_CHALLAN_NBRGPIN_F7_CHLN_RC(SQL Table) |
Index Back |
|---|---|
ESI Challan Number RecordRecord to store ESI Challan numbers and Date |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | 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 |
| 4 | GPIN_CHALLAN_NBR |
Character(12) | VARCHAR2(12) NOT NULL | ESI Challan Number of Employer |
| 5 | GPIN_DATE | Date(10) | DATE | Date |