GP_PA_ERDDHS_VW

(SQL View)
 Index Back

ERN& DED Rpt Archive Record

Archive record for ERN& DED Reporting Record

SELECT PSARCH_ID ,PSARCH_BATCHNUM , 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_ERDD_HST

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