GP_RSLT_ED_VW

(SQL View)
 Index Back

Results - GP RSLT ERN DED view

Results - GP RSLT ERN DED view

SELECT DISTINCT A.EMPLID , A.EMPL_RCD , A.CAL_RUN_ID , A.GP_PAYGROUP , A.CAL_ID , A.ORIG_CAL_RUN_ID , A.RSLT_SEG_NUM , S.PYMT_KEY1 , S.PYMT_KEY2 , S.PYMT_KEY3 , S.PYMT_KEY4 , A.INSTANCE , A.PIN_NUM , A.USER_FLD1 , A.USER_FLD2 , A.USER_FLD3 , A.USER_FLD4 , A.USER_FLD5 , A.USER_FLD6 , A.SLICE_BGN_DT , A.SLICE_END_DT , C.CALC_RULE , A.CALC_RSLT_VAL , A.CALC_ADJ_VAL , A.BASE_RSLT_VAL , A.BASE_ADJ_VAL , A.RATE_RSLT_VAL , A.UNIT_RSLT_VAL , A.UNIT_ADJ_VAL , A.PCT_RSLT_VAL , A.RECIPIENT_ID , A.RECIPIENT_TAG , A.RSLT_NOT_TKN , A.RSLT_ADD_ARR , A.RSLT_PAYBK , A.RSLT_XFER_VAL , B.PIN_TYPE , B.PIN_NM , A.ED_ASSIGN_INSTANCE , A.PI_INSTANCE , A.DRIVER_EXISTS_IND , A.CALC_RSLT_SRC , A.BASE_RSLT_SRC , A.PCT_RSLT_SRC , A.RATE_RSLT_SRC , A.UNIT_RSLT_SRC FROM PS_GP_ERN_DED C ,PS_GP_PIN B ,PS_GP_RSLT_ERN_DED A ,PS_GP_PYE_SEG_STAT S WHERE A.PIN_NUM = B.PIN_NUM AND A.PIN_NUM = C.PIN_NUM AND A.EMPLID = S.EMPLID AND A.EMPL_RCD = S.EMPL_RCD AND A.CAL_RUN_ID = S.CAL_RUN_ID AND A.ORIG_CAL_RUN_ID = S.ORIG_CAL_RUN_ID AND A.CAL_ID = S.CAL_ID AND A.GP_PAYGROUP = S.GP_PAYGROUP AND A.RSLT_SEG_NUM = S.RSLT_SEG_NUM AND C.EFFDT = ( SELECT MAX(EFFDT) FROM PS_GP_ERN_DED C1 WHERE C.PIN_NUM = C1.PIN_NUM)

  • 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 Rcd Nbr
    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 USER_FLD1 Character(25) VARCHAR2(25) NOT NULL User Field 1
    15 USER_FLD2 Character(25) VARCHAR2(25) NOT NULL User Field 2
    16 USER_FLD3 Character(25) VARCHAR2(25) NOT NULL User Field 3
    17 USER_FLD4 Character(25) VARCHAR2(25) NOT NULL User Field 4
    18 USER_FLD5 Character(25) VARCHAR2(25) NOT NULL User FIeld 5
    19 USER_FLD6 Character(25) VARCHAR2(25) NOT NULL User Field 6
    20 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
    21 SLICE_END_DT Date(10) DATE Element Slice End Date
    22 CALC_RULE Character(2) VARCHAR2(2) NOT NULL Function Library field
    AM=Amount
    PB=Base * Percent
    RP=Unit * Rate * Percent
    RU=Unit * Rate
    23 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
    24 CALC_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Adjustment Value
    25 BASE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculated Base Value
    26 BASE_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Base Adjustment
    27 RATE_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate Result Value
    28 UNIT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Number of units used in result calculation
    29 UNIT_ADJ_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit Adjustment
    30 PCT_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent Result Value
    31 RECIPIENT_ID Character(8) VARCHAR2(8) NOT NULL Payment recipient ID
    32 RECIPIENT_TAG Number(3,0) SMALLINT NOT NULL Used to identify recipients for E/D, PI
    33 RSLT_NOT_TKN Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Not Taken
    34 RSLT_ADD_ARR Signed Number(20,6) DECIMAL(18,6) NOT NULL Amount Added To Arrears
    35 RSLT_PAYBK Signed Number(20,6) DECIMAL(18,6) NOT NULL Payback Amount Result
    36 RSLT_XFER_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Bank Transfer Value of Deduct
    37 PIN_TYPE Character(2) VARCHAR2(2) NOT NULL Element Type

    Prompt Table: GP_PIN_TYPE

    38 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    39 ED_ASSIGN_INSTANCE Number(3,0) SMALLINT NOT NULL Earn/Ded Assignment Instance
    40 PI_INSTANCE Number(3,0) SMALLINT NOT NULL Positive Input Instance
    41 DRIVER_EXISTS_IND Character(1) VARCHAR2(1) NOT NULL Driver Accumulator Row Exists during resolution indicator

    Y/N Table Edit

    42 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
    43 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
    44 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
    45 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
    46 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