GPGB_EE_P45_VW

(SQL View)
 Index Back

Employee Data from GP Process

Employee Data genarated by the GP process

SELECT EMPLID , CAL_RUN_ID , EMPL_RCD , GP_PAYGROUP , CAL_ID , RSLT_SEG_NUM , ADDRESS1 ,ADDRESS2 ,ADDRESS3 ,ADDRESS4 ,COUNTY ,POSTAL ,DEPTID , LOCATION ,JOBCODE ,COMPRATE ,COMP_FREQUENCY ,TAX_CODE_UK ,NATIONAL_ID ,GPGB_NI_CATEGORY ,TAX_BASIS_UK , GPGB_TAX_PERIOD ,COMPANY ,BUSINESS_UNIT ,PAY_ENTITY ,FREQUENCY_ID ,GPGB_TAX_BGN_YR ,EMPL_STATUS ,LEAVE_DT , HIRE_DT FROM PS_GPGB_EE_RSLT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
4 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
7 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
8 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
9 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
10 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
11 COUNTY Character(30) VARCHAR2(30) NOT NULL County
12 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
13 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
14 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
15 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
16 COMPRATE Number(19,6) DECIMAL(18,6) NOT NULL Compensation Rate
17 COMP_FREQUENCY Character(5) VARCHAR2(5) NOT NULL Compensation Frequency
A=Annual
B=Biweekly
C=Contract
D=Daily
H=Hourly
M=Monthly
S=Semimonthly
W=Weekly
18 TAX_CODE_UK Character(15) VARCHAR2(15) NOT NULL Tax Code for UK
19 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
20 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
21 TAX_BASIS_UK Character(1) VARCHAR2(1) NOT NULL Tax Basis
0=Cumulative
1=Week 1/Month 1
22 GPGB_TAX_PERIOD Number(3,0) SMALLINT NOT NULL Tax Period
23 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
24 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
25 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
26 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.
27 GPGB_TAX_BGN_YR Number(4,0) SMALLINT NOT NULL Tax Year Begins In This Calendar Year
28 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
A=Active
D=Deceased
L=Leave of Absence
P=Leave With Pay
Q=Retired With Pay
R=Retired
S=Suspended
T=Terminated
U=Terminated With Pay
V=Terminated Pension Pay Out
W=Short Work Break
X=Retired-Pension Administration
29 LEAVE_DT Date(10) DATE Leave Date
30 HIRE_DT Date(10) DATE First Start Date