IATIMEPRD – No description in the Lawson data dictionary

System
Analytic Architect (IA)
Prefix
IPD
Primary key
USER-DIM-NAME, YEAR, PERIOD-NBR
Fields
8
Updated by
4 programs
Referenced by
9 programs

IATIMEPRD is a Lawson Analytic Architect table (prefix IPD); no description in the lawson data dictionary. It is indexed by USER-DIM-NAME, YEAR, PERIOD-NBR (IPDSET1); alternate indexes: IPDSET2, IPDSET3, IPDSET4 and IPDSET5. It is updated by IA80.1, IA80.5, IA80.6 and IA80.9 and referenced by HCCE.1, HCDL.1, HCHE.1, HCHP.1, IARP.1, IATB.1, IATM.1, IATS.1 and 1 more. The table has 8 fields, 5 indexes and 0 documented relations.

About IATIMEPRD

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the IPD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#IPD-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, IA80.9
#IPD-YEAR PK
YEAR		Numeric 4Contains the fiscal year for the data stored on this record.IA80.1, IA80.9
#IPD-PERIOD-NBR PK
PERIOD_NBR		Numeric 3—IA80.1, IA80.9
#IPD-MEMBER-NAME SET4
MEMBER_NAME		Alpha 50 (Lower Case)This is an override member name for Data Mart dimensions with no association to a Budget dimension.IA80.1, IA80.5, IA80.9
#IPD-QUARTER-CONSOL SET2
QUARTER_CONSOL		Numeric 1—IA80.1, IA80.5, IA80.9
#IPD-ENDING-WEEK
ENDING_WEEK		Numeric 2——
#IPD-ENDING-DAY SET5
ENDING_DAY		Numeric 4 (mmdd)—IA80.1, IA80.6, IA80.9
#IPD-ENDING-YEAR SET5
ENDING_YEAR		Numeric 4—IA80.1, IA80.6, IA80.9

Indexes (5)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
IPDSET1
  1. USER-DIM-NAME
  2. YEAR
  3. PERIOD-NBR
Primary, KeyChangeIA80.1, IA80.5, IA80.6, IA80.9, IARP.1, IATB.1, IATM.1, IATS.1 +1 more
IPDSET2
  1. USER-DIM-NAME
  2. YEAR
  3. QUARTER-CONSOL
  4. PERIOD-NBR
KeyChangeIATM.1
IPDSET3
  1. USER-DIM-NAME
  2. PERIOD-NBR
  3. YEAR
KeyChangeIA80.5, IATM.1
IPDSET4
  1. USER-DIM-NAME
  2. YEAR
  3. MEMBER-NAME
  4. PERIOD-NBR
KeyChangeIA80.5
IPDSET5
  1. USER-DIM-NAME
  2. ENDING-YEAR
  3. ENDING-DAY
  4. YEAR
  5. PERIOD-NBR
HCCE.1, HCDL.1, HCHE.1, HCHP.1

Programs

Updated by (4)

Referenced by (9)