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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
IPD-USER-DIM-NAME PKUSER_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 PKYEAR | Numeric 4 | Contains the fiscal year for the data stored on this record. | IA80.1, IA80.9 |
IPD-PERIOD-NBR PKPERIOD_NBR | Numeric 3 | — | IA80.1, IA80.9 |
IPD-MEMBER-NAMEMEMBER_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-CONSOLQUARTER_CONSOL | Numeric 1 | — | IA80.1, IA80.5, IA80.9 |
IPD-ENDING-WEEKENDING_WEEK | Numeric 2 | — | — |
IPD-ENDING-DAYENDING_DAY | Numeric 4 (mmdd) | — | IA80.1, IA80.6, IA80.9 |
IPD-ENDING-YEARENDING_YEAR | Numeric 4 | — | IA80.1, IA80.6, IA80.9 |
Indexes (5)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
IPDSET1 | USER-DIM-NAME, YEAR, PERIOD-NBR | Primary, KeyChange | IA80.1, IA80.5, IA80.6, IA80.9, IARP.1, IATB.1, IATM.1, IATS.1 +1 more | |
IPDSET2 | USER-DIM-NAME, YEAR, QUARTER-CONSOL, PERIOD-NBR | KeyChange | IATM.1 | |
IPDSET3 | USER-DIM-NAME, PERIOD-NBR, YEAR | KeyChange | IA80.5, IATM.1 | |
IPDSET4 | USER-DIM-NAME, YEAR, MEMBER-NAME, PERIOD-NBR | KeyChange | IA80.5 | |
IPDSET5 | USER-DIM-NAME, ENDING-YEAR, ENDING-DAY, YEAR, PERIOD-NBR | HCCE.1, HCDL.1, HCHE.1, HCHP.1 |
Programs
Updated by (4)
- IA80.1 Time Dimension Definition
- IA80.5 Period Adjustment
- IA80.6 Period End date Adjustment
- IA80.9 Year Adjustment