IATIME – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
TIM
Primary key
USER-DIM-NAME
Fields
25
Updated by
1 program
Referenced by
11 programs

IATIME is a Lawson Analytic Architect table (prefix TIM); no description in the lawson data dictionary. It is indexed by USER-DIM-NAME (TIMSET1). It is updated by IA80.1 and referenced by CBDM.1, CBOP.1, HCCE.1, HCDL.1, HCHE.1, HCHP.1, IARP.1, IART.1 and 3 more. The table has 25 fields, 1 index and 0 documented relations.

About IATIME

No description in the Lawson data dictionary.

Fields (25)

Column = COBOL field name without the TIM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
TIM-USER-DIM-NAME PK
USER_DIM_NAME		Alpha 50 (Lower Case)The User Dimension Name is the name associated with the dimension in the data mart outline. This user-defined name can contain up to 50 alphanumeric characters. For example, you might name a dimension Fiscal Year or Organization.IA80.1
TIM-TIME-DEPTH
TIME_DEPTH		Alpha 1—
  • Q Quarters
  • P Periods
  • D Days
—
TIM-YEARS-INCLUDED
YEARS_INCLUDED		Alpha 1—
  • Y Yes
  • N No
IA80.1
TIM-QTRS-INCLUDED
QTRS_INCLUDED		Alpha 1—
  • Y Yes
  • N No
IA80.1
TIM-PERS-INCLUDED
PERS_INCLUDED		Alpha 1—
  • Y Yes
  • N No
IA80.1
TIM-WEEKS-INCLUDED
WEEKS_INCLUDED		Alpha 1—
  • Y Yes
  • N No
IA80.1
TIM-DAYS-INCLUDED
DAYS_INCLUDED		Alpha 1—
  • Y Yes
  • N No
IA80.1
TIM-YR-IDENTIFIER
YR_IDENTIFIER		Alpha 1—IA80.1
TIM-YR-SEPARATOR
YR_SEPARATOR		Alpha 1 (Lower Case)—IA80.1
TIM-BEGINNING-YEAR
BEGINNING_YEAR		Numeric 4—IA80.1
TIM-ENDING-YEAR
ENDING_YEAR		Numeric 4—IA80.1
TIM-UNIQUE-MEMBERS
UNIQUE_MEMBERS		Alpha 1—
  • Y Yes
  • N No
IA80.1
TIM-PRIOR-YR-MBR
PRIOR_YR_MBR		Alpha 50 (Lower Case)—IA80.1
TIM-DAY-NAMING-OPT
DAY_NAMING_OPT		Alpha 1——
TIM-NBR-OF-PERIODS
NBR_OF_PERIODS		Numeric 3—IA80.1
TIM-BEG-MONTH-DAY
BEG_MONTH_DAY		Numeric 4 (mmdd)——
TIM-END-MONTH-DAY
END_MONTH_DAY		Numeric 4 (mmdd)——
TIM-BEGIN-BAL-MBR
BEGIN_BAL_MBR		Alpha 50 (Lower Case)—IA80.1
TIM-BB-DEPTH
BB_DEPTH		Alpha 1—
  • A Annual
  • Q Quarter
  • P Period
  • W Week
  • D Day
—
TIM-QUARTER-NAMES
QUARTER_NAMES		Alpha 50 (Lower Case)Occurs 4 TimesIA80.1
TIM-LOCK-CHANGES
LOCK_CHANGES		Alpha 1——
TIM-STARTING-WKDAY
STARTING_WKDAY		Numeric 1—IA80.1
TIM-ADJUST-PERIOD
ADJUST_PERIOD		Alpha 1The Adjustment Period field determines whether or not the last period is used as an adjustment period. If Y is selected, the adjustment period is not rolled up into any Quarter member. Instead, the adjustment period is rolled up into the Period member. Valid values are:
  • Y Yes
  • N No; Default value.
—
TIM-DAY-OF-WK-ATT
DAY_OF_WK_ATT		Alpha 1—IA80.1
TIM-WEEKDAY-MBR
WEEKDAY_MBR		Alpha 50 (Lower Case)—IA80.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TIMSET1USER-DIM-NAMEPrimary, KeyChangeCBDM.1, CBOP.1, HCCE.1, HCDL.1, HCHE.1, HCHP.1, IA80.1, IA80.5 +8 more

Programs

Updated by (1)

Referenced by (11)