| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 4 |
BALANCE_GRP_NUM |
Character(3) |
VARCHAR2(3) NOT NULL |
This field will be used to determine the grouping of balances from the different jobs of the employee.
|
| 5 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 6 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
|
| 7 |
PIN_CODE |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique identifier of a PIN (alternate to PIN number). critical for use in merging packages of elements from one database onto another when PINs may or may not be renumbered as they are moved across.
Constructed from PIN_NM + COUNTRY of the element definition (GP_PIN)
|
| 8 |
GPAU_ACCUM_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Total for the earning/Deduction YTD Accumulator
|
| 9 |
GPAU_SRC_PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
This field stores Pin Number for the TER FM DUR START used in EOY processing
|
| 10 |
GPAU_SRC_PIN_CODE |
Character(22) |
VARCHAR2(22) NOT NULL |
Earning/Deduction Pin Code - for EOY Exeption Reporting
|
| 11 |
GPAU_ERN_DED_TOT |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Total for the earning/Deduction Total of Period earnings
|
| 12 |
SOVR_VAL_CHAR |
Character(25) |
VARCHAR2(25) NOT NULL |
Supporting Element Character Value
|