GP_RSLT_TOT_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.ACM_PRD_OPTN , 0 , 0 , ' ' FROM PS_GP_RSLT_ACUM A

# 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 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
16 GP_RSLT_ADM_SEGAMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Displayed Monthly Total
17 GP_RSLT_ADM_YTDAMT Signed Number(20,6) DECIMAL(18,6) NOT NULL Displayed Yearly Total
18 GP_RSLT_ADM_SKIP Character(1) VARCHAR2(1) NOT NULL Skip the row in the Administrator Results