Clarity PPM

Expand all | Collapse all

Which DB table translates Time Periods like the END_PERIOD_ID in FIN_PLANS?

  • 1.  Which DB table translates Time Periods like the END_PERIOD_ID in FIN_PLANS?

    Posted 04-20-2015 12:50 AM

    Hi All,

     

    Probably a silly question but which table stores the time periods for Financial Plans (likely among other things)? I know that PRTIMEPERIOD stores the values for the timesheet periods, but I don't think that's where I need to be looking for this. I'm trying to query out the End Dates of all the Cost Plans in projects, which is usually just month/year (i.e. 2015 06 June).

     

    Regards,

     

    Matthew



  • 2.  Re: Which DB table translates Time Periods like the END_PERIOD_ID in FIN_PLANS?

    Posted 04-20-2015 03:39 AM

    If you look at the tech ref, it clearly states the table (I've highlighted in BOLD for your reference - BIZ_COM_PERIODS)

     

    FIN_PLANS

    This table stores the properties of the plans in the system.

    Column

    Description

    ACTUAL_BENEFIT

    This numeric column represents the total actual benefit of a benefit plan.

    AGG_BENEFIT

    This column is not used.

    AGG_BREAKEVEN

    This column is not used.

    AGG_COST

    This column is not used.

    AGG_END_PERIOD_ID

    This column is not used.

    AGG_NPV

    This column is not used.

    AGG_REVENUE

    This column is not used.

    AGG_ROI

    This column is not used.

    AGG_START_PERIOD_ID

    This column is not used.

    AGG_TOTAL_BENEFIT

    This column is not used.

    AGG_TOTAL_COST

    This column is not used.

    AGG_TOTAL_REVENUE

    This column is not used.

    AGG_TOTAL_UNITS

    This column is not used.

    AGG_UNITS

    This column is not used.

    BENEFIT

    The time-sliced value of planned benefit amount.

    BENEFIT_PLAN_ID

    The benefit plan ID with which this plan is associated. This refers to the internal ID of the table FIN_PLANS.

    CODE

    The ID of the financial plan.

    COST

    The time-scaled value of the planned cost amount.

    CREATED_BY

    This column refers to the resource (CMN_SEC_USERS.ID) that created this row.

    CREATED_DATE

    This column refers to the date and time this row was created.

    DESCRIPTION

    The description of the financial plan.

    END_PERIOD_ID

    The end time period of the plan. This refers to the internal ID column of the BIZ_COM_PERIODS table.

    ID

    This column refers to the internal ID of the plan.

    IS_PLAN_OF_RECORD

    This column indicates if the plan is the plan of record.

    LAST_UPDATED_BY

    The resource that last updated this row. This refers to CMN_SEC_USERS.ID.

    LAST_UPDATED_DATE

    The date and time this row was last updated.

    NAME

    The name of the financial plan.

    OBJECT_CODE

    The object ID for which the plan was created.

    OBJECT_ID

    The object for which the plan was created. This refers to the internal ID of the object instance.

    PERIOD_TYPE_CODE

    This column indicates the plan period type. It is one of the values from the lookup type "PERIOD_TYPE."

    PLAN_BY_1_CODE

    This column indicates the first plan by option. Values are:

    • 0 = Transaction class
    • 1 = Roles
    • 2 = Charge codes
    • 3 = Utility code 1
    • 4 = Utility code 2
    PLAN_BY_2_CODE

    This column indicates the second plan by option. Value are:

    • 0 = Transaction class
    • 1 = Roles
    • 2 = Charge codes
    • 3 = Utility code 1
    • 4 = Utility code 2
    PLAN_TYPE_CODE

    This column indicates the plan type. Values can be either budget or forecast. These are the lookup values from lookup type FIN_PLAN_TYPE.

    REVENUE

    The time-scaled value of the planned revenue amount.

    REVISION

    The plan revision.

    START_PERIOD_ID

    The starting time period of the plan. This refers to the internal ID column of the BIZ_COM_PERIODS table.

    STATUS_CODE

    The status of the plan. Values are:

    • 0 = Not submitted
    • 1 = Submitted
    • 2 = Approved

    SUB_PLAN_TYPE

    The sub type of the plan. This indicates if the plan is a cost plan or a benefit plan.

    TOTAL_ACTUAL_BENEFIT

    This numeric column represents the total actual benefit for a line item of a benefit plan.

    TOTAL_BENEFIT

    The total planned benefit amount.

    TOTAL_BILLING_BENEFIT

    The total benefit amount in billing currency.

    TOTAL_COST

    The total planned cost amount.

    TOTAL_REVENUE

    The total planned revenue amount.

    TOTAL_UNITS

    The total planed units.

    UNITS

    The time-scaled value of the plan units.

     

     

     

     

    NJ