| # |
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 |
GPGB_TAX_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Tax Period
|
| 4 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
|
| 5 |
CALC_RSLT_VAL |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Calculation Numeric Result
|
| 6 |
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)
|
| 7 |
PIN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Element Type
|
| 8 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 9 |
PAY_ENTITY |
Character(10) |
VARCHAR2(10) NOT NULL |
Pay Entity
|
| 10 |
FREQUENCY_ID |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
|
| 11 |
GPGB_NI_CATEGORY |
Character(2) |
VARCHAR2(2) NOT NULL |
NI Category Code
A=Standard Not C/Out
A1=IOM - CATEGORY A
AA=Standard Not C/Out in APP
AA=Standard Not C/Out in APP
B=Reduced Not C/Out
BA=Reduced Not C/Out in APP
BA=Reduced Not C/Out in APP
C=Retirement Age Exemption
CA=Co Deferrment in APPS
CO=C/Out Deferment in COSR Scheme
D=Standard C/Out Salary Related
D1=IOM - CATEGORY D
E=Reduced C/Out Salary Related
F=Standard C/Out Money Purchase
F=Standard C/Out Money Purchase
G=Reduced C/Out Money Purchase
G=Reduced C/Out Money Purchase
J=Deferment Not C/Out
L=Deferment C/Out Salary Related
N=Contracted-OSR-standard rate
O=Contracted-OUS-reduced rate
Q=Deferment
R=Standard Rate
S=Deferment C/Out Money Purchase
S=Deferment C/Out Money Purchase
T=Reduced Rate
W=Over State Pension Age
X=Other Exemption
|
| 12 |
TAXCODE_UK |
Character(15) |
VARCHAR2(15) NOT NULL |
Tax Code
|
| 13 |
NATIONAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
National ID
|
| 14 |
DESCR1 |
Character(30) |
VARCHAR2(30) NOT NULL |
Descr
|
| 15 |
FIRST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 16 |
MIDDLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
MIDDLE_NAME
|
| 17 |
LAST_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|