CA_PLAN_TMPL

(SQL Table)
 Index Back

Plan Templates

Plan Templates

  • Related Language Record: CA_PLAN_TMPL_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 PLAN_TMPL_ID Character(10) VARCHAR2(10) NOT NULL Plan Template ID

    Prompt Table: CA_PLAN_TMPL

    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
    5 BASIS_DT_SOURCE Character(1) VARCHAR2(1) NOT NULL Basis Date Source
    C=Current Date
    D=Contract Line Start Date
    S=Contract Sign Date

    Default Value: S

    6 BASIS_DT_OPTION Character(1) VARCHAR2(1) NOT NULL Basis Date Option
    L=Last Day of Month
    S=Specify Day of Month
    U=Use Basis Date

    Default Value: U

    7 BASIS_DT_DAY Character(2) VARCHAR2(2) NOT NULL Basis Day of Month
    01=1st Day of Month
    02=2nd Day of Month
    03=3rd Day of Month
    04=4th Day of Month
    05=5th Day of Month
    06=6th Day of Month
    07=7th Day of Month
    08=8th Day of Month
    09=9th Day of Month
    10=10th Day of Month
    11=11th Day of Month
    12=12th Day of Month
    13=13th Day of Month
    14=14th Day of Month
    15=15th Day of Month
    16=16th Day of Month
    17=17th Day of Month
    18=18th Day of Month
    19=19th Day of Month
    20=20th Day of Month
    21=21st Day of Month
    22=22nd Day of Month
    23=23rd Day of Month
    24=24th Day of Month
    25=25th Day of Month
    26=26th Day of Month
    27=27th Day of Month
    28=28th Day of Month
    8 SCHEDULE Character(10) VARCHAR2(10) NOT NULL Schedule ID

    Prompt Table: CA_SCHED_TBL_VW

    9 EVENT_NUM Number(3,0) SMALLINT NOT NULL Event Number
    10 PLAN_CONTR_ACT Character(1) VARCHAR2(1) NOT NULL Activate Contract
    P=Leave Pending
    R=Set to Ready

    Y/N Table Edit

    Default Value: N

    11 PLAN_AMEND_PROC Character(1) VARCHAR2(1) NOT NULL Process Amendment
    P=Leave Pending
    R=Set to Ready

    Y/N Table Edit

    Default Value: N

    12 PLAN_RENEW_APPR Character(1) VARCHAR2(1) NOT NULL Approve Renewal
    P=Leave Pending
    R=Set to Ready

    Y/N Table Edit

    Default Value: N

    13 PLAN_PGP_WKS Character(1) VARCHAR2(1) NOT NULL Auto-ready Progress Payment Bill Plan

    Y/N Table Edit

    Default Value: N

    14 PLAN_PPD_APPR Character(1) VARCHAR2(1) NOT NULL Field used to indicate the option whether to Ready the Billplans for an active contract when the associated prepaids is set to Ready status

    Y/N Table Edit

    Default Value: N