GP_AUDIT_PRC_VW

(SQL View)
 Index Back

Process PINs Audit Trace

Process PINs Audit Trace View

SELECT DISTINCT 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.INSTANCE_NUM , ASUM.CALC_RSLT_VAL , A.CHR_PIN_VAL , A.DATE_PIN_VAL , A.PIN_VAL_NUM , P.PIN_TYPE , A.SLICE_BGN_DT , A.SLICE_END_DT , A.SUB_PRC_ITERATION , ASUM.CALC_ADJ_VAL , ASUM.CALC_RAW_VAL , A.PIN_NUM , A.DIFF_SECONDS , A.BAD_TRACE_IND FROM PS_GP_AUDIT_TBL A , PS_GP_AUDIT_SUM_VW ASUM , PS_GP_PIN P WHERE A.PIN_CHAIN_SEQ_NUM = 1 AND A.PIN_NUM = P.PIN_NUM AND A.CAL_RUN_ID = ASUM.CAL_RUN_ID AND A.EMPLID = ASUM.EMPLID AND A.EMPL_RCD = ASUM.EMPL_RCD AND A.GP_PAYGROUP = ASUM.GP_PAYGROUP AND A.CAL_ID = ASUM.CAL_ID AND A.ORIG_CAL_RUN_ID = ASUM.ORIG_CAL_RUN_ID AND A.RSLT_SEG_NUM = ASUM.RSLT_SEG_NUM AND A.FICT_CAL_ID = ASUM.FICT_CAL_ID AND A.FICT_CAL_RUN_ID = ASUM.FICT_CAL_RUN_ID AND A.FICT_RSLT_SEG_NUM = ASUM.FICT_RSLT_SEG_NUM AND A.PIN_NUM = ASUM.PIN_NUM AND A.AUDIT_SORT_KEY = ASUM.AUDIT_SORT_KEY

# 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 INSTANCE_NUM Number(4,0) SMALLINT NOT NULL Positive Input Element Instance Number
13 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
14 CHR_PIN_VAL Character(30) VARCHAR2(30) NOT NULL Calculation Character Result
15 DATE_PIN_VAL Date(10) DATE Calculation Date Result
16 PIN_VAL_NUM Number(8,0) INTEGER NOT NULL Calculation Element Number Result
17 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type
18 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
19 SLICE_END_DT Date(10) DATE Element Slice End Date
20 SUB_PRC_ITERATION Number(3,0) SMALLINT NOT NULL Element's Subprocess Iteration Number
21 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
22 CALC_RAW_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation unrounded/unconverted value
23 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
24 DIFF_SECONDS Number(19,6) DECIMAL(18,6) NOT NULL Resolution Duration in Seconds
25 BAD_TRACE_IND Character(1) VARCHAR2(1) NOT NULL The field is populated when PIN Manager cannot successfully incorporate an element into audit trace.
N=Good Trace
Y=Bad Trace