GPIN_ITCS_TMPL_IDEFFDTDefault Value: %date
KEY_SERIAL_NBRPrompt Table: GPIN_ITCS_NM_VW
Prompt Table: GPIN_IT_YTD_VW
GPIN_ITCS_INC(SQL Table) |
Index Back |
|---|---|
ITCS Income TemplateITCS Income Template |
| # | 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 NOT NULL |
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 | GPIN_ITCS_ERN_PIN | Number(8,0) | INTEGER NOT NULL |
Used for storing Pin Number for Earnings.
Prompt Table: GPIN_ITCS_NM_VW |
| 5 | GPIN_ITCS_LBL | Character(60) | VARCHAR2(60) NOT NULL | IT Computaion Sheet Customizable Labels |
| 6 | GPIN_ITCS_ACM_PIN | Number(8,0) | INTEGER NOT NULL |
Used to store PIN number for Accumulators.
Prompt Table: GPIN_IT_YTD_VW |