GP_PA_ERNDD_VW

(SQL View)
 Index Back

ERN& DED Reporting Record

ERN& DED Reporting Record

SELECT EMPLID ,EMPL_RCD ,CAL_RUN_ID , ORIG_CAL_RUN_ID , CAL_ID , GP_PAYGROUP , PIN_NUM + 50000000 , RSLT_SEG_NUM , PIN_TYPE , CALC_RSLT_VAL , BASE_RSLT_VAL , UNIT_RSLT_VAL , RATE_RSLT_VAL , PCT_RSLT_VAL , CALC_RSLT_SUM , UNIT_RSLT_SUM , GP_SEG_COUNT , PRD_BGN_DT , PRD_END_DT , SEG_BGN_DT , SEG_END_DT , RUN_TYPE , BUSINESS_UNIT , PAY_ENTITY , COUNTRY , COMPANY , LOCATION , CONTRACT_TYPE , ESTABID , DEPTID , FTE , JOBCODE , SETID_JOBCODE , SETID_DEPT , SETID_LOCATION , GP_INCLUDE_RETRO , GP_MULT_INS_EXIST , FIRST_NAME , LAST_NAME , FULL_PART_TIME , SUPERVISOR_ID , EMPL_STATUS , GP_PA_HIRE_DT , TERMINATION_DT , CONTRACT_NUM , STRM_NUM , GROUP_LIST_ID , PYE_CALC_STAT , PRC_ORD_TS , GP_SEG_EXISTS , GP_CALC_VAL1 , GP_CALC_VAL2 , GP_RPT_RETRO , SETID_EMPL_CLASS , EMPL_CLASS , PYMT_DT , CURRENCY_CD FROM PS_GP_PA_ERN_DED

# 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 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
5 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
7 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
10 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
11 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
12 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
13 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
14 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
15 CALC_RSLT_SUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Summary of calculations
16 UNIT_RSLT_SUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Summary of units used in result calculation
17 GP_SEG_COUNT Number(3,0) SMALLINT NOT NULL Used in payroll analytics
18 PRD_BGN_DT Date(10) DATE Period Begin Date
19 PRD_END_DT Date(10) DATE Pay Period End Date
20 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
21 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
22 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
23 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
24 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
25 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
26 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
27 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
28 CONTRACT_TYPE Character(3) VARCHAR2(3) NOT NULL Contract Type
29 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
30 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
31 FTE Number(8,6) DECIMAL(7,6) NOT NULL This field represent Full Time Equivalence
32 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
33 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
34 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
35 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
36 GP_INCLUDE_RETRO Character(2) VARCHAR2(2) NOT NULL used in payroll analytics
N=No
Y=Yes
37 GP_MULT_INS_EXIST Character(2) VARCHAR2(2) NOT NULL Used in Payroll Analytics
N=No
Y=Yes
38 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
39 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
40 FULL_PART_TIME Character(1) VARCHAR2(1) NOT NULL Full/Part Time
D=On Demand
F=Full-Time
P=Part-Time
41 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
42 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
43 GP_PA_HIRE_DT Date(10) DATE used in payroll analytics
44 TERMINATION_DT Date(10) DATE Termination Date
45 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
46 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number
47 GROUP_LIST_ID Character(10) VARCHAR2(10) NOT NULL Group List
48 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
49 PRC_ORD_TS DateTime(26) TIMESTAMP Process Order Timestamp
50 GP_SEG_EXISTS Character(1) VARCHAR2(1) NOT NULL multiple segments exist
N=No
Y=Yes

Y/N Table Edit

Default Value: N

51 GP_CALC_VAL1 Signed Number(20,6) DECIMAL(18,6) NOT NULL GP Calculation value 1
52 GP_CALC_VAL2 Signed Number(20,6) DECIMAL(18,6) NOT NULL GP Calculation value 2
53 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
54 SETID_EMPL_CLASS Character(5) VARCHAR2(5) NOT NULL Employee class Set ID
55 EMPL_CLASS Character(3) VARCHAR2(3) NOT NULL Employee Classification
56 PYMT_DT Date(10) DATE Payment Date
57 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code