GP_PKG_IDGPIN_ITCS_TMPL_IDEFFDTKEY_SERIAL_NBRAC=Accumulators
DD=Deductions
ER=Earnings
FM=Formulas
VR=Variables
GPIN_NRP_EXM_AD(SQL Table) |
Index Back |
|---|---|
ITCS Exemption TemplateITCS Exemption Template |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | GPIN_ITCS_TMPL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Used to store Template ID for IT Computaion Sheet Template. |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | KEY_SERIAL_NBR |
Number(5,0) | INTEGER NOT NULL | This is an internal serial number for a Configurable Matrix key, used to indirectly associate a key combination with a data pointer. |
| 5 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
| 6 | GPIN_ENTRY_TYPE | Character(4) | VARCHAR2(4) NOT NULL |
Elements entry type for India used in IT Computaion Sheet.
AC=Accumulators DD=Deductions ER=Earnings FM=Formulas VR=Variables |
| 7 | GPIN_ITCS_LBL | Character(60) | VARCHAR2(60) NOT NULL | IT Computaion Sheet Customizable Labels |