POIADIM

REFERENCED BY
POA10 POAX.1


UPDATED BY
POA1.1 POA3.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POI-DATA-MART-NAME
Element: Data Mart Name
Alpha 20 (Lower Case)
This field contains the name of the data mart.
POA1.1
POI-VEND-DIMENSION
Element: Vend Dimension
Alpha 50 (Lower Case)
POA1.1
POI-PROD-DIMENSION
Element: Prod Dimension
Alpha 50 (Lower Case)
POA1.1
POI-ORG-DIMENSION
Element: Org Dimension
Alpha 50 (Lower Case)
The Organization Dimension Name field contains the user-defined name for the Organization dimension. This name can contain up to 30 characters of any kind.
POA1.1
POI-BUYR-DIMENSION
Element: Buyr Dimension
Alpha 50 (Lower Case)
POA1.1
POI-TIME-DIMENSION
Element: Time Dimension
Alpha 50 (Lower Case)
The Time Dimension Name field contains the user-defined name of the Time dimension. This name can contain up to 30 characters of any kind.
POA1.1
POI-MEAS-DIMENSION
Element: Meas Dimension
Alpha 50 (Lower Case)
The Measures Dimension Name field contains the user-defined name for the Measures dimension. This name can contain up to 30 characters of any kind.
POA1.1
POI-YEAR-DIMENSION
Element: Year Dimension
Alpha 50 (Lower Case)
POA1.1
POI-CAL-NAME
Element: Cal Name
Alpha 20
POA1.1
POI-STATUS
Element: Status
Numeric 1
This field displays the status of the transaction.
POA1.1
POI-DATA-LOAD-OPT
Element: Data Load Opt
Alpha 1
The Data Values Load Option field specifies how the data values are loaded into the data mart. Value values are: N = No Load I = Incremental C = Complete; Default value.
P = Partial
" " = None Specified
POA1.1
POI-DATALD-BEG-PER
Element: Datald Beg Per
Numeric 2
POA1.1
POI-DATALD-BEG-YR
Element: Datald Beg Yr
Numeric 4
POA1.1
POI-DATALD-END-PER
Element: Datald End Per
Numeric 2
POA1.1
POI-DATALD-END-YR
Element: Datald End Yr
Numeric 4
POA1.1
POI-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
POI-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
POI-PHASE-RECORDS
Element: Phase Records
Signed 13.0 Occurs 9 Times
POA3.1
POI-PHASE-MINUTES
Element: Phase Minutes
Signed 11.0 Occurs 9 Times
POI-PHASE-SECONDS
Element: Phase Seconds
Signed 2.0 Occurs 9 Times
POA3.1
POI-TOTAL-RECORDS
Element: Total Records
Signed 11.0
POA3.1
POI-TOTAL-MINUTES
Element: Total Minutes
Signed 11.0
POI-TOTAL-SECONDS
Element: Total Seconds
Signed 2.0
POA3.1


POIADIM FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POISET1 DATA-MART-NAME
POA1.1 POA10
POA3.1 POAX.1


File created: Thu Jun 09 02:26:54 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.