usm_plan_data

This table holds the plan data for set/cost_pool/fiscal_periods combinations.

Column Name Column Datatype Column Null Option Column Comment
set_domain varchar(50) not null  
set_code varchar(50) not null  
ps_id integer not null Unique id for plan set.
type integer not null Used in determining if item is direct cost or a cost element within a cost pool.
fp_id integer not null Unique id for fiscal period.
cp_id integer not null Unique id for cost pool.
item_id integer not null The unique id for each rate item
numeric_1 float with null Value associated to the plan item.

Product Name: Unicenter Service Management

Table Type: Table


Copyright © 2006 CA. All rights reserved.