| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 3 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 4 |
GPIN_TAX_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
This field is used to store the Tax Year.
|
| 5 |
GPIN_SECTION_ID |
Character(3) |
VARCHAR2(3) NOT NULL |
Used to store indicator for sections in IT Computation SheetTemplate.
|
| 6 |
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.
|
| 7 |
GPIN_IT_COLMN |
Character(3) |
VARCHAR2(3) NOT NULL |
IT Comutaion sheet column. Used in GPIN_ITCS_CR AppEngine.
|
| 8 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 9 |
CALC_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 10 |
GPIN_ITCS_LBL |
Character(60) |
VARCHAR2(60) NOT NULL |
IT Computaion Sheet Customizable Labels
|