GP_RSLTAD_ED_VW

(SQL View)
 Index Back

Results - GP RSLT ERN DED view

Results - GP RSLT ERN DED view

SELECT EMPLID , EMPL_RCD , CAL_RUN_ID , GP_PAYGROUP , CAL_ID , ORIG_CAL_RUN_ID , RSLT_SEG_NUM , PYMT_KEY1 , PYMT_KEY2 , PYMT_KEY3 , PYMT_KEY4 , INSTANCE , PIN_NUM , SLICE_BGN_DT , SLICE_END_DT , CALC_RULE , CALC_RSLT_VAL , CALC_RSLT_VAL , CALC_ADJ_VAL , BASE_RSLT_VAL , BASE_ADJ_VAL , RATE_RSLT_VAL , UNIT_RSLT_VAL , UNIT_ADJ_VAL , PCT_RSLT_VAL , RECIPIENT_ID , RECIPIENT_TAG , RSLT_NOT_TKN , RSLT_ADD_ARR , RSLT_PAYBK , RSLT_XFER_VAL , PIN_TYPE , PIN_NM , USER_FLD1 , USER_FLD2 , USER_FLD3 , USER_FLD4 , USER_FLD5 , USER_FLD6 , ED_ASSIGN_INSTANCE , PI_INSTANCE , DRIVER_EXISTS_IND , CALC_RSLT_SRC , BASE_RSLT_SRC , PCT_RSLT_SRC , RATE_RSLT_SRC , UNIT_RSLT_SRC FROM PS_GP_RSLT_ED_VW

  • Related Language Record: GP_RSLT_ED_VL

    • # 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 PYMT_KEY1 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
    9 PYMT_KEY2 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
    10 PYMT_KEY3 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
    11 PYMT_KEY4 Character(25) VARCHAR2(25) NOT NULL Payment key field. Used for optional tracking of a payment per Department, Company, Establishment or Contract Number
    12 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number
    13 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    14 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
    15 SLICE_END_DT Date(10) DATE Element Slice End Date
    16 CALC_RULE Character(2) VARCHAR2(2) NOT NULL Function Library field
    AM=Amount
    PB=Base * Percent
    RP=Unit * Rate * Percent
    RU=Unit * Rate
    17 GP_RSLT_ADM_CALC_V Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
    18 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
    19 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
    20 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
    21 BASE_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Adjustment
    22 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
    23 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
    24 UNIT_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Adjustment
    25 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
    26 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
    27 RECIPIENT_TAG Number(3,0) SMALLINT NOT NULL Used to identify recipients for E/D, PI
    28 RSLT_NOT_TKN Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Not Taken
    29 RSLT_ADD_ARR Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Added To Arrears
    30 RSLT_PAYBK Signed Number(20,6) DECIMAL(18,6) NOT NULL Payback Amount Result
    31 RSLT_XFER_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Bank Transfer Value of Deduct
    32 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

    Prompt Table: GP_PIN_TYPE

    33 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    34 USER_FLD1 Character(25) VARCHAR2(25) NOT NULL User Field 1
    35 USER_FLD2 Character(25) VARCHAR2(25) NOT NULL User Field 2
    36 USER_FLD3 Character(25) VARCHAR2(25) NOT NULL User Field 3
    37 USER_FLD4 Character(25) VARCHAR2(25) NOT NULL User Field 4
    38 USER_FLD5 Character(25) VARCHAR2(25) NOT NULL User FIeld 5
    39 USER_FLD6 Character(25) VARCHAR2(25) NOT NULL User Field 6
    40 ED_ASSIGN_INSTANCE Number(3,0) SMALLINT NOT NULL Earn/Ded Assignment Instance
    41 PI_INSTANCE Number(3,0) SMALLINT NOT NULL Positive Input Instance
    42 DRIVER_EXISTS_IND Character(1) VARCHAR2(1) NOT NULL Driver Accumulator Row Exists during resolution indicator

    Y/N Table Edit

    43 CALC_RSLT_SRC Character(1) VARCHAR2(1) NOT NULL Source of Amount or Calculated Result
    A=Assigned via Element
    E=Earn Ded Assignment
    F=Post Formula
    N=Not Applicable
    P=Positive Input
    R=Rule Definition
    44 BASE_RSLT_SRC Character(1) VARCHAR2(1) NOT NULL Source of Base on Result
    A=Assigned via Element
    E=Earn Ded Assignment
    F=Post Formula
    N=Not Applicable
    P=Positive Input
    R=Rule Definition
    45 PCT_RSLT_SRC Character(1) VARCHAR2(1) NOT NULL Source of Percent on Result
    A=Assigned via Element
    E=Earn Ded Assignment
    F=Post Formula
    N=Not Applicable
    P=Positive Input
    R=Rule Definition
    46 RATE_RSLT_SRC Character(1) VARCHAR2(1) NOT NULL Source of Rate on Result
    A=Assigned via Element
    E=Earn Ded Assignment
    F=Post Formula
    N=Not Applicable
    P=Positive Input
    R=Rule Definition
    47 UNIT_RSLT_SRC Character(1) VARCHAR2(1) NOT NULL Source of Unit on Result
    A=Assigned via Element
    E=Earn Ded Assignment
    F=Post Formula
    N=Not Applicable
    P=Positive Input
    R=Rule Definition