usm_fiscal_period

The fiscal periods are defined in this table

Column Name Column Datatype Column Null Option Column Comment
fp_id integer not null Unique id for fiscal period.
name nvarchar(50) with null Descriptive name for the period. Ex: January 2002
year integer not null The fiscal year of this period. This value can and often is different from the year specified in start_date and end_date.
start_date date not null Beginning date of fiscal period
end_date date not null Ending date of fiscal period
period integer with null 0=monthly, 1=quarterly, 2=yearly
domain varchar(50) with null Domain to which the period was defined.

Product Name: Unicenter Service Management

Table Type: Table

Relationships:

Primary Key Related Table Related Column
fp_id usm_plan_data fp_id


Copyright © 2006 CA. All rights reserved.