usm_plan_def

Contains information relating to a plans definition grouping.

Column Name Column Datatype Column Null Option Column Comment
pd_id integer not null Unique id for plan definition.
lvl integer not null Level of granularity.
lvl_type integer not null Level type: Catalog, Account, Catalog by Account
year integer not null Fiscal year.
period integer not null Period type: monthly, quarterly, yearly
start_date date not null Period start date.
end_date date not null Period end date.
set_code nvarchar(50) not null Set code associated with the definition.
activity integer not null Activity associated with the definition.
domain varchar(50) with null The domain to which the definition belongs.

Product Name: Unicenter Service Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
pd_id usm_plan id


Copyright © 2006 CA. All rights reserved.