GPIN_ITCS_TMPL_IDEFFDTDefault Value: %date
KEY_SERIAL_NBRPrompt Table: GPIN_IT_ACUM_VW
AC=Accumulators
DD=Deductions
ER=Earnings
FM=Formulas
VR=Variables
Default Value: ER
GPIN_NRP_PRQ_VW(SQL View) |
Index Back |
|---|---|
ITCS Perquisites templateITCS Perquisites template |
| SELECT GPIN_ITCS_TMPL_ID ,EFFDT ,KEY_SERIAL_NBR ,PIN_NUM+50000000 ,GPIN_ENTRY_TYPE ,GPIN_ITCS_LBL FROM PS_GPIN_ITCS_PRQ |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GPIN_ITCS_TMPL_ID |
Character(20) | VARCHAR2(20) NOT NULL | Used to store Template ID for IT Computaion Sheet Template. |
| 2 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 3 | 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. |
| 4 | PIN_NUM | Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: GPIN_IT_ACUM_VW |
| 5 | 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 Default Value: ER |
| 6 | GPIN_ITCS_LBL | Character(60) | VARCHAR2(60) NOT NULL | IT Computaion Sheet Customizable Labels |