GPCH_RS_ACM_VW

(SQL View)
 Index Back

Results - Accumulator View

Payee Results Accumulator View. Filters in only accums for current EMPL_RCD

SELECT A.EMPLID , A.EMPL_RCD , A.CAL_RUN_ID , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.PIN_NUM , A.EMPL_RCD_ACUM , A.ACM_FROM_DT , A.ACM_THRU_DT , A.SLICE_BGN_DT , A.SLICE_END_DT , A.SEQ_NUM8 , A.USER_KEY1 , A.USER_KEY2 , A.USER_KEY3 , A.USER_KEY4 , A.USER_KEY5 , A.USER_KEY6 , A.COUNTRY , A.ACM_TYPE , A.ACM_PRD_OPTN , A.CALC_RSLT_VAL , A.CALC_VAL , A.USER_ADJ_VAL , A.PIN_PARENT_NUM FROM PS_GP_RSLT_ACUM A , PS_GP_PYE_PRC_STAT B WHERE A.EMPLID = B.EMPLID AND A.EMPL_RCD = B.EMPL_RCD AND A.CAL_RUN_ID = B.CAL_RUN_ID AND A.GP_PAYGROUP = B.GP_PAYGROUP AND A.CAL_ID = B.CAL_ID AND A.ORIG_CAL_RUN_ID = B.ORIG_CAL_RUN_ID AND (A.EMPL_RCD = A.EMPL_RCD_ACUM OR ACM_TYPE = 'N') AND B.CALC_TYPE = 'P'

# 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 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
9 EMPL_RCD_ACUM Number(3,0) SMALLINT NOT NULL Accumulator Empl record
10 ACM_FROM_DT Date(10) DATE From Date
11 ACM_THRU_DT Date(10) DATE Through Date
12 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
13 SLICE_END_DT Date(10) DATE Element Slice End Date
14 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number
15 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
16 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
17 USER_KEY3 Character(25) VARCHAR2(25) NOT NULL User Key 3
18 USER_KEY4 Character(25) VARCHAR2(25) NOT NULL User Key 4
19 USER_KEY5 Character(25) VARCHAR2(25) NOT NULL User Key 5
20 USER_KEY6 Character(25) VARCHAR2(25) NOT NULL User Key 6
21 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
22 ACM_TYPE Character(1) VARCHAR2(1) NOT NULL Accumulator Level - this is the same as the PYE RCDN KEY IND field
23 ACM_PRD_OPTN Character(1) VARCHAR2(1) NOT NULL Accumulator Period
1=Segment
2=Calendar Period
3=Month to Date
4=Quarter to Date
5=Year to Date
6=Custom Period
24 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
25 CALC_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Value
26 USER_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL User Adjustment Value
27 PIN_PARENT_NUM Number(8,0) INTEGER NOT NULL Parent Element Number