GP_MPSLP_ACM_VW

(SQL View)
 Index Back

Mobile Epay

Mobile Epay

SELECT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PSLP_SRCPRODUCT , A.GP_PSLP_ID , A.PIN_NUM , A.ACM_FROM_DT , A.ACM_THRU_DT , A.PIN_ELEM_GRP_NUM , A.SLICE_BGN_DT , A.SLICE_END_DT , A.SEG_BGN_DT , A.SEG_END_DT , A.PRD_BGN_DT , A.PRD_END_DT , A.PYMT_DT , A.RUN_TYPE , A.USER_KEY1 , A.USER_KEY2 , A.USER_KEY3 , A.USER_KEY4 , A.USER_KEY5 , A.USER_KEY6 , A.CALC_RSLT_VAL , A.CALC_RSLT_VAL , A.CALC_DELTA_VAL , A.CALC_VAL ,CASE WHEN A.GP_MPSLP_PIN_DESCR = ' ' THEN B.DESCR ELSE A.GP_MPSLP_PIN_DESCR END ,D.CURRENCY_CD ,A.GP_PAYGROUP ,A.CAL_ID ,A.SEQ_NUM8 ,A.GP_MPSLP_SECTION ,A.GP_MPSLP_SPRNT_ORD ,A.GP_MPSLP_SUBSECTN ,A.GP_MPSLP_PRNT_ORD ,CASE WHEN A.GP_MPSLP_PIN_DESCR = ' ' THEN B.DESCR ELSE A.GP_MPSLP_PIN_DESCR END ,A.GP_MPSLP_DISP_ZERO ,A.GP_MPSLP_RET_ADJ ,A.GP_MPSLP_SUM_INST ,A.GP_MPSLP_ADD_TOTAL ,A.GP_MPSLP_DISP_PYSL ,A.GP_BASE ,A.GP_UNIT ,A.GP_RATE ,A.GP_PERCENT FROM PS_GP_MPSLP_STGACM A , PS_GP_PIN B , PS_GP_ACCUMULATOR C ,PS_GP_CAL_RUN_DTL D WHERE A.PIN_NUM=B.PIN_NUM AND B.PIN_NUM=C.PIN_NUM AND A.CAL_RUN_ID=D.CAL_RUN_ID AND D.CALC_TYPE='P' AND A.GP_MPSLP_SECTION ='40' UNION SELECT A.EMPLID , A.CAL_RUN_ID , A.EMPL_RCD , A.GP_PSLP_SRCPRODUCT , A.GP_PSLP_ID , A.PIN_NUM , A.ACM_FROM_DT , A.ACM_THRU_DT , A.PIN_ELEM_GRP_NUM , A.SLICE_BGN_DT , A.SLICE_END_DT , A.SEG_BGN_DT , A.SEG_END_DT , A.PRD_BGN_DT , A.PRD_END_DT , A.PYMT_DT , A.RUN_TYPE , A.USER_KEY1 , A.USER_KEY2 , A.USER_KEY3 , A.USER_KEY4 , A.USER_KEY5 , A.USER_KEY6 , A.CALC_RSLT_VAL , A.CALC_RSLT_VAL , A.CALC_DELTA_VAL , A.CALC_VAL ,CASE WHEN A.GP_MPSLP_PIN_DESCR = ' ' THEN B.DESCR ELSE A.GP_MPSLP_PIN_DESCR END ,F.CURRENCY_CD ,A.GP_PAYGROUP ,A.CAL_ID ,A.SEQ_NUM8 ,A.GP_MPSLP_SECTION ,A.GP_MPSLP_SPRNT_ORD ,A.GP_MPSLP_SUBSECTN ,A.GP_MPSLP_PRNT_ORD ,CASE WHEN A.GP_MPSLP_PIN_DESCR = ' ' THEN B.DESCR ELSE A.GP_MPSLP_PIN_DESCR END ,A.GP_MPSLP_DISP_ZERO ,A.GP_MPSLP_RET_ADJ ,A.GP_MPSLP_SUM_INST ,A.GP_MPSLP_ADD_TOTAL ,A.GP_MPSLP_DISP_PYSL ,A.GP_BASE ,A.GP_UNIT ,A.GP_RATE ,A.GP_PERCENT FROM PS_GP_MPSLP_STGACM A , PS_GP_PIN B , PS_GP_ACCUMULATOR C ,PS_GP_CAL_RUN_OFF D ,PS_GP_PYGRP E ,PS_GP_PYENT_DTL F WHERE A.PIN_NUM=B.PIN_NUM AND A.GP_MPSLP_SECTION ='40' AND B.PIN_NUM=C.PIN_NUM AND A.CAL_RUN_ID=D.CAL_RUN_ID AND D.GP_PAYGROUP=E.GP_PAYGROUP AND E.PAY_ENTITY=F.PAY_ENTITY AND F.EFF_STATUS='A' AND F.EFFDT=( SELECT MAX(CH.EFFDT) FROM PS_GP_PYENT_DTL CH WHERE CH.PAY_ENTITY=F.PAY_ENTITY AND CH.EFF_STATUS=F.EFF_STATUS AND CH.EFFDT <= %CurrentDateIn)

  • Parent record: GP_PYE_SEG_STAT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
    3 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    4 GP_PSLP_SRCPRODUCT Character(6) VARCHAR2(6) NOT NULL Name of product providing payslips to ePay Payslip process.
    5 GP_PSLP_ID Character(40) VARCHAR2(40) NOT NULL Payslip Identifier
    6 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    7 ACM_FROM_DT Date(10) DATE From Date
    8 ACM_THRU_DT Date(10) DATE Through Date
    9 PIN_ELEM_GRP_NUM Number(8,0) INTEGER NOT NULL PIN Number for Element Group
    10 SLICE_BGN_DT Date(10) DATE Element Slice Begin Date
    11 SLICE_END_DT Date(10) DATE Element Slice End Date
    12 SEG_BGN_DT Date(10) DATE Payee Process Segment's Begin Date
    13 SEG_END_DT Date(10) DATE Payee Process Segment's End Date
    14 PRD_BGN_DT Date(10) DATE Period Begin Date
    15 PRD_END_DT Date(10) DATE Pay Period End Date
    16 PYMT_DT Date(10) DATE Payment Date
    17 RUN_TYPE Character(10) VARCHAR2(10) NOT NULL Run Type Name
    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 CALC_RSLT_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Numeric Result
    25 CALC_RSLT2_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Mobile Epay
    26 CALC_DELTA_VAL2 Signed Number(20,6) DECIMAL(18,6) NOT NULL Mobile Epay
    27 CALC_VAL Signed Number(20,6) DECIMAL(18,6) NOT NULL Calculation Value
    28 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    29 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    30 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group
    31 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
    32 SEQ_NUM8 Number(8,0) INTEGER NOT NULL Sequence Number
    33 GP_MPSLP_SECTION Character(30) VARCHAR2(30) NOT NULL Mobile Epay
    34 GP_MPSLP_SPRNT_ORD Number(3,0) SMALLINT NOT NULL Mobile Epay
    35 GP_MPSLP_SUBSECTN Character(30) VARCHAR2(30) NOT NULL Mobile Epay
    36 GP_MPSLP_PRNT_ORD Number(3,0) SMALLINT NOT NULL Mobile Epay
    37 GP_MPSLP_PIN_DESCR Character(30) VARCHAR2(30) NOT NULL Mobile Epay
    38 GP_MPSLP_DISP_ZERO Character(4) VARCHAR2(4) NOT NULL Display Zero

    Default Value: N

    39 GP_MPSLP_RET_ADJ Character(4) VARCHAR2(4) NOT NULL Retro Adjustment

    Default Value: Y

    40 GP_MPSLP_SUM_INST Character(4) VARCHAR2(4) NOT NULL Sum Instances

    Default Value: N

    41 GP_MPSLP_ADD_TOTAL Character(4) VARCHAR2(4) NOT NULL Add to Totals

    Default Value: Y

    42 GP_MPSLP_DISP_PYSL Character(4) VARCHAR2(4) NOT NULL Display in Payslip

    Default Value: Y

    43 GP_BASE Signed Number(20,6) DECIMAL(18,6) NOT NULL Base
    44 GP_UNIT Signed Number(20,6) DECIMAL(18,6) NOT NULL Unit
    45 GP_RATE Signed Number(20,6) DECIMAL(18,6) NOT NULL Rate
    46 GP_PERCENT Signed Number(20,6) DECIMAL(18,6) NOT NULL Percent