CA_PPDBPTMPL_VW

(SQL View)
 Index Back

Prepaid Bill Plan Templates

This View is created to provide a prompt to the list of Bill Plan Templates that could be associated with Prepaids. The valid Bill Plan methods that could be associated with a Prepaid are Immediate, Percent Complete and Milestone.

SELECT SETID , PLAN_TMPL_ID , PLAN_METHOD , DESCR FROM PS_CA_PLAN_TMPL WHERE PLAN_METHOD IN ('3','4','6')

  • Related Language Record: CA_PPDBP_VW_LG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_FS.SETID

    Prompt Table: SP_SETID_NONVW

    2 CA_BP_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Bill Plan Template
    3 PLAN_METHOD Character(2) VARCHAR2(2) NOT NULL Plan Method
    1=As Incurred
    2=Apportionment
    3=Percent Complete
    4=Milestone
    6=Immediate
    7=Value Based
    8=Recurring
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description