GP_PA_RSLANL_VW

(SQL View)
 Index Back

Payroll analytics AE record

used in payroll analytics appengine for storing data in staging table

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

# 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 SETID_EMPL_CLASS Character(5) VARCHAR2(5) NOT NULL Employee class Set ID
63 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
64 PYMT_DT Date(10) DATE Payment Date
65 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code