HGA_RSLTACM_VW

(SQL View)
Index Back

Absence Accumulator Results

Absence Balance and Take Accumulator Results used by AM pivots.

SELECT A.PROCESS_INSTANCE , A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , A.GP_RPT_KEY , A.SEQ_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 , A.CORR_RTO_IND , A.VALID_IN_SEG_IND , A.CALLED_IN_SEG_IND , A.ABS_AC_TYPE , A.ABS_TAKE_CAL_VAL , A.ABS_CALC_RSLT_VAL , A.PRD_BGN_DT , A.PRD_END_DT , A.FREQUENCY_ID , A.UNIT_TYPE , A.UNIT_TYPE , A.PAY_ENTITY , A.TOTAL_DURATION_DYS , A.TOTAL_DURATION_HRS , A.FISCAL_YEAR , A.CALENDAR_YEAR , A.FISCAL_QUARTER , A.CALENDAR_QUARTER FROM PS_HGA_RSLTACM_TMP A WHERE A.PIN_NUM > 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
5 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
6 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
7 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
8 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
9 GP_RPT_KEY Character(22) VARCHAR2(22) NOT NULL Output Result Key
10 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence
11 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
12 EMPL_RCD_ACUM Number(3,0) SMALLINT NOT NULL Accumulator Empl record
13 ACM_FROM_DT Date(10) DATE From Date
14 ACM_THRU_DT Date(10) DATE Through Date
15 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
16 SLICE_END_DT Date(10) DATE Element Slice End Date
17 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number
18 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
19 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
20 USER_KEY3 Character(25) VARCHAR2(25) NOT NULL User Key 3
21 USER_KEY4 Character(25) VARCHAR2(25) NOT NULL User Key 4
22 USER_KEY5 Character(25) VARCHAR2(25) NOT NULL User Key 5
23 USER_KEY6 Character(25) VARCHAR2(25) NOT NULL User Key 6
24 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
25 ACM_TYPE Character(1) VARCHAR2(1) NOT NULL Accumulator Level - this is the same as the PYE RCDN KEY IND field
26 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
27 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
28 CALC_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Value
29 USER_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL User Adjustment Value
30 PIN_PARENT_NUM Number(8,0) INTEGER NOT NULL Parent Element Number
31 CORR_RTO_IND Character(1) VARCHAR2(1) NOT NULL Use Corrective Retro
32 VALID_IN_SEG_IND Character(1) VARCHAR2(1) NOT NULL This Y/N flag indicates whether an accumulator is valid within a given segment of time.
33 CALLED_IN_SEG_IND Character(1) VARCHAR2(1) NOT NULL This Y/N flag indicates whether an accumulator was referenced by the PIN Manager during processing of the segment.
34 ABS_AC_TYPE Character(1) VARCHAR2(1) NOT NULL Absence Accumlator Type (Balance or Take).
B=Balance
E=Entitlement
T=Take
35 ABS_TAKE_CAL_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Absence Take for current period.
36 ABS_CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Current Balance Or Take
37 PRD_BGN_DT Date(10) DATE Period Begin Date
38 PRD_END_DT Date(10) DATE Pay Period End Date
39 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.
40 UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours
41 HGA_UNIT_TYPE Character(1) VARCHAR2(1) NOT NULL Unit Type in which the absence balances are displayed
D=Days
H=Hours
42 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
43 TOTAL_DURATION_DYS Number(9,2) DECIMAL(8,2) NOT NULL Total Duration Days
44 TOTAL_DURATION_HRS Number(9,2) DECIMAL(8,2) NOT NULL Total Duration Hours
45 FISCAL_YEAR Number(4,0) SMALLINT NOT NULL Fiscal Year
46 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
47 FISCAL_QUARTER Character(2) VARCHAR2(2) NOT NULL Fiscal Quarter
48 CALENDAR_QUARTER Character(2) VARCHAR2(2) NOT NULL Calendar Quarter