GP_AUDIT_SUM_VW

(SQL View)
 Index Back

Sum PINs Audit Trace

Summed PINs Audit Trace View

SELECT A.CAL_RUN_ID , A.EMPLID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.FICT_CAL_ID , A.FICT_CAL_RUN_ID , A.FICT_RSLT_SEG_NUM , A.AUDIT_SORT_KEY , A.PIN_NUM , SUM(A.CALC_RSLT_VAL) , SUM(A.CALC_ADJ_VAL) , SUM(A.CALC_RAW_VAL) FROM PS_GP_AUDIT_TBL A WHERE A.SUM_INSTANCE_IND = 'Y' GROUP BY A.CAL_RUN_ID , A.EMPLID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID, A.RSLT_SEG_NUM , A.FICT_CAL_ID, A.FICT_CAL_RUN_ID, A.FICT_RSLT_SEG_NUM, A.AUDIT_SORT_KEY , A.PIN_NUM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee 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 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 FICT_CAL_ID Character(18) VARCHAR2(18) NOT NULL Ficitious Cal ID
9 FICT_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Group ID of Fictitious Calculation; used when data for both Present and Fictitious Calc are present
10 FICT_RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Fictitious Segment Number
11 AUDIT_SORT_KEY Number(8,0) INTEGER NOT NULL Chain Sort Key
12 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
13 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
14 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
15 CALC_RAW_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation unrounded/unconverted value