PA_SP_STP_ADJ

(SQL Table)
 Index Back

SP SVC FN results table

This table holds Service functional results of a gap or withdrawn contribution.

  • 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
    4 PA_SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence Number
    5 SVC_FUNCTN_RESULT Character(10) VARCHAR2(10) NOT NULL Benefit Service Functn Result
    6 BEGIN_DT Date(10) DATE Begin Date
    7 END_DT Date(10) DATE end date
    8 FUNCTN_RESULT_NM Character(10) VARCHAR2(10) NOT NULL Function Result Name
    9 EACCT_FR_NAME Character(10) VARCHAR2(10) NOT NULL This field represents a Contribution Employee Account Function Result.
    10 ADJ_START_DT Date(10) DATE Adjustment Start Date
    11 ADJ_END_DT Date(10) DATE Adjustment End Date
    12 LAST_PROC_DT Date(10) DATE Last Proc Date
    13 BRKS_PRD Number(10,6) DECIMAL(9,6) NOT NULL Breaks for Period
    14 UNITS Character(1) VARCHAR2(1) NOT NULL Units
    M=Months
    Y=Years
    15 FNL_MAX_SVC_NBR Number(10,6) DECIMAL(9,6) NOT NULL Maximum
    16 FNL_MIN_SVC_NBR Number(10,6) DECIMAL(9,6) NOT NULL Minimum
    17 TOTAL_SVC Number(10,6) DECIMAL(9,6) NOT NULL Total Service
    18 PERIOD_SVC Number(10,6) DECIMAL(9,6) NOT NULL Service Period
    19 PERIOD_ADJ Number(10,6) DECIMAL(9,6) NOT NULL Period Adjustments
    20 AVAIL_TO_PURCH Number(10,6) DECIMAL(9,6) NOT NULL Available to Purchase
    21 AMT_TO_PURCH Number(10,6) DECIMAL(9,6) NOT NULL Amount to Purchase
    22 SVC_WITHDRAWN Number(10,6) DECIMAL(9,6) NOT NULL Service Withdrawn
    23 SVC_BUYBACK Number(10,6) DECIMAL(9,6) NOT NULL Service Buyback
    24 PERIOD_DT Date(10) DATE Period Date