GPJP_MUNIC_AET(SQL Table) |
Index Back |
|---|---|
GPJP_IHMUN State recordState Record for GPJP_IHMUN1 and GPJP_IHMUN2 Application Engine programs. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | GPJP_TAX_ESTAB | Character(15) | VARCHAR2(15) NOT NULL | Salary Payer Reference Number |
| 5 | EFFDT | Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | YEAR_CODE | Character(4) | VARCHAR2(4) NOT NULL |
Select Calendar Year
1994=1994 1995=1995 1996=1996 1997=1997 1998=1998 1999=1999 2000=2000 2001=2001 2002=2002 2003=2003 2004=2004 2005=2005 2006=2006 2007=2007 2008=2008 2009=2009 2010=2010 2011=2011 2012=2012 2013=2013 2014=2014 2015=2015 2016=2016 2017=2017 2018=2018 2019=2019 2020=2020 |
| 7 | COUNTER | Signed Number(6,0) | DECIMAL(5) NOT NULL | Counter |
| 8 | FILE_HANDLE | Character(2) | VARCHAR2(2) NOT NULL | File Handle |
| 9 | CHARSET | Character(40) | VARCHAR2(40) NOT NULL | Character Set |
| 10 | FILE_NAME | Character(80) | VARCHAR2(80) NOT NULL | File Name |
| 11 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 12 | BEGIN_DT | Date(10) | DATE | Begin Date |
| 13 | END_DATE | Date(10) | DATE | End Date |
| 14 | BGN_DT | Date(10) | DATE | Begin Date |
| 15 | END_DT | Date(10) | DATE | end date |
| 16 | ERROR_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Error Type
ERR=Stop NON=None WAR=Warning |
| 17 | GPJP_LOAD_OPTION | Character(4) | VARCHAR2(4) NOT NULL |
Overwrite option for Inhabitant Tax electronic file load process
DA=No Condition DLNO=Skip User Added/Updated Rows DLOR=Skip Matching Begin Date |