GPGB_EE_NI

(SQL Table)
Index Back

Employee NI Details

GP United Kingdom Employee National Insurance Details record. Contains NI details necessary to process a UK Payroll. Most fields are retrieved in the GP process using an Array. Also store information for Reports.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Default Value: NEW

Prompt Table: PERSON

2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
3 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

4 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
5 GPGB_NI_FREQUENCY Character(1) VARCHAR2(1) NOT NULL NI Frequency
A=Annual
B=Bi-Weekly
F=Every Four Weeks
M=Monthly
Q=Quarterly
W=Weekly
6 GPGB_DIRECTOR_IND Character(1) VARCHAR2(1) NOT NULL Indicates if Employee is a Director

Y/N Table Edit

7 GPGB_DIRECTOR_DT Date(10) DATE Date Employee commenced as a Director
8 GPGB_DIRECTOR_ENDT Date(10) DATE Date Employee ended as a Director
9 GPGB_DIRECTORS_NI Character(1) VARCHAR2(1) NOT NULL Directors NI Calculation method
D=Annual Cumulative
N=Period Non-Cumulative
10 GPGB_SCON Character(9) VARCHAR2(9) NOT NULL SCON - Scheme Contracted Out Number

Prompt Table: GPGB_ACTSCON_VW

11 GPGB_ECON Character(9) VARCHAR2(9) NOT NULL Employers Contracted Out Number

Prompt Table: GPGB_ACTECON_VW

12 GPGB_NI_AGE_CERT Character(1) VARCHAR2(1) NOT NULL Indicator field for employees who have presented NI Age Certificate

Y/N Table Edit

13 GPGB_NI_DEFER_CERT Character(1) VARCHAR2(1) NOT NULL Indicator of Employee having an NI Deferrment Certificate

Y/N Table Edit

14 GPGB_NI_RDCD_CERT Character(1) VARCHAR2(1) NOT NULL Indicator field for employees who have presented NI Reduced Liability Certificate

Y/N Table Edit

15 GPGB_MULT_EMPLMT Character(1) VARCHAR2(1) NOT NULL GPGB - Multiple Employment Indicator To agregate NI accumulators

Y/N Table Edit

Default Value: N

16 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

Default Value: %datetime

17 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
18 GPGB_NI_APPRPEN Character(1) VARCHAR2(1) NOT NULL Indicator for employees who are in an approved pension scheme. --Field NOT longer used in NI Data page--
19 GPGB_NI_C_CHOICE Character(1) VARCHAR2(1) NOT NULL Indicator for employees on a NI Category Code C
20 GPGB_NI_OVRD_PRD Number(2,0) SMALLINT NOT NULL NI Override Period --Field NOT longer used in NI Data page--