GP_KB_RSLT_VW

(SQL View)
 Index Back

Payroll analytics AE record

used in payroll analytics appengine for storing data in staging table

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.CAL_RUN_ID , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.GP_RPT_RETRO , A.PIN_NUM , A.SEG_BGN_DT , A.SEG_END_DT , A.SLICE_BGN_DT , A.SLICE_END_DT , A.PRD_BGN_DT , A.PRD_END_DT , A.GP_RPT_BGN_DT , A.GP_RPT_END_DT , A.RUN_TYPE , A.BUSINESS_UNIT , A.BUSINESS_DESCR , A.PAY_ENTITY , A.COUNTRY , A.COMPANY , A.GP_PA_COMP_DESCR , A.LOCATION , A.LOCATION_DESCR , A.CONTRACT_TYPE , A.ESTABID , A.ESTAB_DESCR , A.DEPTID , A.DEPT_DESCR , A.FTE , A.JOBCODE , A.JOBCODE_DESCR , A.SETID_JOBCODE , A.SETID_DEPT , A.SETID_LOCATION , A.GP_INCLUDE_RETRO , A.FIRST_NAME , A.LAST_NAME , A.CALC_VAL , A.CALC_ADJ_VAL , A.PYE_CALC_STAT , A.FREQUENCY_ID , A.GP_SEG_COUNT , A.GROUP_LIST_ID , A.STRM_NUM , A.PIN_GROSS_VAL , A.PIN_GROSS_NUM , A.PIN_NET_VAL , A.PIN_NET_NUM , A.FULL_PART_TIME , A.SUPERVISOR_ID , A.EMPL_STATUS , A.GP_PA_HIRE_DT , A.TERMINATION_DT , A.CONTRACT_NUM , A.PRC_ORD_TS , A.GP_SEG_EXISTS , A.GP_CALC_VAL2 , A.GP_CALC_VAL1 , A.CURRENCY_CD , A.PYMT_DT , A.SETID_EMPL_CLASS , A.EMPL_CLASS FROM PS_GP_PA_RSLT_ANL A WHERE A.PIN_NUM = A.PIN_GROSS_NUM AND A.RSLT_SEG_NUM = 1

# 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 Record
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
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 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
7 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
8 GP_RPT_RETRO Character(1) VARCHAR2(1) NOT NULL Retroactivity Type
1=Original
2=Recalculation
3=Prior Calculation
4=Last Version/Revision
5=Result Delta - Corrective
6=Result Delta - Forwarded
9 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
10 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
11 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
12 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
13 SLICE_END_DT Date(10) DATE Element Slice End Date
14 PRD_BGN_DT Date(10) DATE Period Begin Date
15 PRD_END_DT Date(10) DATE Pay Period End Date
16 GP_RPT_BGN_DT Date(10) DATE Payment begin date
17 GP_RPT_END_DT Date(10) DATE Payment end date
18 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
19 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
20 BUSINESS_DESCR Character(60) VARCHAR2(60) NOT NULL Business Description
21 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
22 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
23 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
24 GP_PA_COMP_DESCR Character(30) VARCHAR2(30) NOT NULL Used in payroll analytics
25 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
26 LOCATION_DESCR Character(30) VARCHAR2(30) NOT NULL Location Description
27 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type
28 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
29 ESTAB_DESCR Character(30) VARCHAR2(30) NOT NULL Description
30 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
31 DEPT_DESCR Character(30) VARCHAR2(30) NOT NULL Department Description
32 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
33 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
34 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Job Code Description
35 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
36 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
37 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
38 GP_INCLUDE_RETRO Character(2) VARCHAR2(2) NOT NULL used in payroll analytics
N=No
Y=Yes
39 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
40 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
41 CALC_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Value
42 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
43 PYE_CALC_STAT Character(2) VARCHAR2(2) NOT NULL Calculation Status: field indicates the processing status of a segment (payment)
00=Identified
02=Calculation Error
03=Calculation Error - Bypassed
04=Calculation Error - By Rule
11=No Segment Created
50=Calculation Successful
55=Frozen For Further Calc
70=Finalized
75=Finalized - With Banking
44 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.
45 GP_SEG_COUNT Number(3,0) SMALLINT NOT NULL Used in payroll analytics
46 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List
47 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
48 PIN_GROSS_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Gross Pay Value
49 PIN_GROSS_NUM Number(8,0) INTEGER NOT NULL Element number field
50 PIN_NET_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Net Pay Value
51 PIN_NET_NUM Number(8,0) INTEGER NOT NULL Element number field
52 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
53 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
54 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
55 GP_PA_HIRE_DT Date(10) DATE used in payroll analytics
56 TERMINATION_DT Date(10) DATE Termination Date
57 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
58 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp
59 GP_SEG_EXISTS Character(1) VARCHAR2(1) NOT NULL multiple segments exist
N=No
Y=Yes

Y/N Table Edit

Default Value: N

60 GP_CALC_VAL2 Signed Number(20,6) DECIMAL(18,6) NOT NULL GP Calculation value 2
61 GP_CALC_VAL1 Signed Number(20,6) DECIMAL(18,6) NOT NULL GP Calculation value 1
62 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
63 PYMT_DT Date(10) DATE Payment Date
64 SETID_EMPL_CLASS Character(5) VARCHAR2(5) NOT NULL Employee class Set ID
65 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification