GP_RSLT_ACM_HST

(SQL Table)
Index Back

Accumulator PIN Results

Result Table for ACUMulators elements

  • Parent record: GP_PYE_SEG_STAT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    5 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
    6 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    7 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    8 ORIG_CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Original Calendar Group ID
    9 RSLT_SEG_NUM Number(4,0) SMALLINT NOT NULL Result Segment Number
    10 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    11 EMPL_RCD_ACUM Number(3,0) SMALLINT NOT NULL Accumulator Empl record
    12 ACM_FROM_DT Date(10) DATE From Date
    13 ACM_THRU_DT Date(10) DATE Through Date
    14 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
    15 SLICE_END_DT Date(10) DATE Element Slice End Date
    16 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number
    17 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
    18 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
    19 USER_KEY3 Character(25) VARCHAR2(25) NOT NULL User Key 3
    20 USER_KEY4 Character(25) VARCHAR2(25) NOT NULL User Key 4
    21 USER_KEY5 Character(25) VARCHAR2(25) NOT NULL User Key 5
    22 USER_KEY6 Character(25) VARCHAR2(25) NOT NULL User Key 6
    23 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    24 ACM_TYPE Character(1) VARCHAR2(1) NOT NULL Accumulator Level - this is the same as the PYE RCDN KEY IND field
    25 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
    26 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
    27 CALC_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Value
    28 USER_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL User Adjustment Value
    29 PIN_PARENT_NUM Number(8,0) INTEGER NOT NULL Parent Element Number
    30 CORR_RTO_IND Character(1) VARCHAR2(1) NOT NULL Use Corrective Retro
    31 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.
    32 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.