PAYMENT_PLAN_VW

(SQL View)
 Index Back

Payment Plan Contract View

This view will be used to display the valid Payment Plan Contracts - TP_CON_TYPE = 'P'

select a.business_unit ,b.emplid ,a.contract_num ,a.tp_con_type ,a.plan_type_sf ,a.tp_con_plan_fee ,b.tp_status ,a.strm ,a.descr ,b.tp_con_num_payment ,a.tp_con_bill_cycle ,b.tp_con_bill_dt ,b.tp_cap_student ,b.pre_plan_amt ,b.guess_amt ,b.guess_amt_expir_dt from ps_tp_contract a, PS_TP_STUDENT b where a.business_unit = b.business_unit and a.contract_num = b.contract_num

  • Related Language Record: PAYMENTPLNVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT

    Prompt Table: SP_BU_SF_NONVW

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract Number
    4 TP_CON_TYPE Character(1) VARCHAR2(1) NOT NULL Third Party Contract Type
    C=Collection Agreement
    D=Deferral Contract
    M=Multi-year Payment Plan
    P=Payment Plan
    R=Pre-Payment Plan
    T=Third Party
    5 PLAN_TYPE_SF Character(1) VARCHAR2(1) NOT NULL Plan Type
    1=Existing Charges Only
    2=Lump Sum
    3=Calculated
    6 TP_CON_PLAN_FEE Signed Number(12,2) DECIMAL(10,2) NOT NULL Plan Fee Amount
    7 TP_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Status
    A=Active
    C=Cancelled
    H=Hold
    I=Inactive
    U=Not Posted
    8 STRM Character(4) VARCHAR2(4) NOT NULL Term
    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 TP_CON_NUM_PAYMENT Number(3,0) SMALLINT NOT NULL Number Of Payments
    11 TP_CON_BILL_CYCLE Character(1) VARCHAR2(1) NOT NULL Billing Cycle
    B=Bi-Monthly
    M=Monthly
    O=One Time
    U=User Selected
    W=Weekly
    12 TP_CON_BILL_DT Date(10) DATE First Billing Date
    13 TP_CAP_STUDENT Number(15,2) DECIMAL(14,2) NOT NULL Third Party Student Maximum
    14 TOTAL_AMOUNT_SF Signed Number(17,2) DECIMAL(15,2) NOT NULL Total Amount
    15 GUESS_AMT Signed Number(17,2) DECIMAL(15,2) NOT NULL Guess Amt
    16 GUESS_AMT_EXPIR_DT Date(10) DATE Guess Amt Exp. DT