PA_SP_STP

(SQL Table)
 Index Back

SP Gaps and Withdrawals

This tables holds purchasable gaps, withdrawals and unknown to system.

  • Parent Record Of PA_SP_STP_ADJ PA_SP_STP_GAPS PA_SP_STP_PRDS PA_SP_STP_SVC PA_SP_STP_UNK PA_SP_STP_WDC PA_SP_TRAN_ADJ

    • # 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 LAST_RUN_DTM DateTime(26) TIMESTAMP Last Run On