PA_SP_STP_WDC

(SQL View)
 Index Back

SP Withrawals

This view lists withdrawal contributions

SELECT EMPLID ,BENEFIT_PLAN ,SP_GAP_TYPE ,PA_SEQ_NUM ,SVC_PURCHASE_TYPE ,ELIGIBILITY_STATUS ,ELIG_OVERIDDEN ,EMPL_RCD ,BEGIN_DT ,END_DT ,WITHDRAW_DATE ,FUNCTN_RESULT_NM ,EACCT_FR_NAME ,WITHDRAW_AMT ,WITHDRAW_AMT_PRE ,WITHDRAW_AMT_POST ,PURCHASED_AMT ,PURCHASED_AMT_PRE ,PURCHASED_AMT_POST ,VERIF_ID ,CUSTOM_STMT_NAME FROM PS_PA_SP_STP_PRDS WHERE SP_GAP_TYPE = 'W'

  • Parent record: PA_SP_STP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERS_SRCH_GBL

    2 BENEFIT_PLAN Character(6) VARCHAR2(6) NOT NULL Benefit Plan

    Prompt Table: PA_PELG_HIST

    3 SP_GAP_TYPE Character(1) VARCHAR2(1) NOT NULL Service Purchase Gap Type
    G=Gaps in Service
    U=Unknown
    W=Withdrawn Contribution

    Default Value: W

    4 PA_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 SVC_PURCHASE_TYPE Character(4) VARCHAR2(4) NOT NULL Service Purchase Type

    Prompt Table: PA_SP_TYPE_DEFN

    6 ELIGIBILITY_STATUS Character(1) VARCHAR2(1) NOT NULL ERP Eligibility Status
    E=Eligible
    I=Ineligible
    U=Undetermined
    7 ELIG_OVERIDDEN Character(1) VARCHAR2(1) NOT NULL Sp Eligibility
    8 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    9 BEGIN_DT Date(10) DATE Begin Date
    10 END_DT Date(10) DATE end date
    11 WITHDRAW_DATE Date(10) DATE Withdrawal \ Cancel Date
    12 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name
    13 EACCT_FR_NAME Character(10) VARCHAR2(10) NOT NULL This field represents a Contribution Employee Account Function Result.
    14 WITHDRAW_AMT Signed Number(15,2) DECIMAL(13,2) NOT NULL Withdrawal Amount
    15 WITHDRAW_AMT_PRE Signed Number(15,2) DECIMAL(13,2) NOT NULL Withdrawal Amount
    16 WITHDRAW_AMT_POST Signed Number(15,2) DECIMAL(13,2) NOT NULL Withdrawn Amount Post-Tax
    17 PURCHASED_AMT Signed Number(15,2) DECIMAL(13,2) NOT NULL Purchased Amount
    18 PURCHASED_AMT_PRE Signed Number(15,2) DECIMAL(13,2) NOT NULL Purchased Amount Pre-Tax
    19 PURCHASED_AMT_POST Signed Number(15,2) DECIMAL(13,2) NOT NULL Purchased Amount Post-Tax
    20 VERIF_ID Number(3,0) SMALLINT NOT NULL Verification ID

    Prompt Table: PA_SP_EMPLRVER

    21 CUSTOM_STMT_NAME Character(10) VARCHAR2(10) NOT NULL Custom Statement Name

    Prompt Table: PA_CUSTOM6_VW