POIADIM FILE
REFERENCED BY
POA10 POAX.1
UPDATED BY
POA1.1 POA3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POI-DATA-MART-NAME Alpha 20 (Lower Case) POA1.1
Element: Data Mart NameThis field contains the name of the
data mart.
POI-VEND-DIMENSION Alpha 50 (Lower Case) POA1.1
Element: Vend Dimension
POI-PROD-DIMENSION Alpha 50 (Lower Case) POA1.1
Element: Prod Dimension
POI-ORG-DIMENSION Alpha 50 (Lower Case) POA1.1
Element: Org Dimension 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.
POI-BUYR-DIMENSION Alpha 50 (Lower Case) POA1.1
Element: Buyr Dimension
POI-TIME-DIMENSION Alpha 50 (Lower Case) POA1.1
Element: Time DimensionThe Time Dimension Name field contains
the user-defined name of the Time
dimension. This name can contain up to
30 characters of any kind.
POI-MEAS-DIMENSION Alpha 50 (Lower Case) POA1.1
Element: Meas DimensionThe Measures Dimension Name field
contains the user-defined name for the
Measures dimension. This name can
contain up to 30 characters of any kind.
POI-YEAR-DIMENSION Alpha 50 (Lower Case) POA1.1
Element: Year Dimension
POI-CAL-NAME Alpha 20 POA1.1
Element: Cal Name
POI-STATUS Numeric 1 POA1.1
Element: Status This field displays the status of the
transaction.
POI-DATA-LOAD-OPT Alpha 1 POA1.1
Element: Data Load Opt 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
POI-DATALD-BEG-PER Numeric 2 POA1.1
Element: Datald Beg Per
POI-DATALD-BEG-YR Numeric 4 POA1.1
Element: Datald Beg Yr
POI-DATALD-END-PER Numeric 2 POA1.1
Element: Datald End Per
POI-DATALD-END-YR Numeric 4 POA1.1
Element: Datald End Yr
POI-MAINT-DATE Numeric 8 (yyyymmdd)
Element: Maint Date The date last changed.
POI-MAINT-TIME Numeric 6 (hhmmss)
Element: Sys Time
POI-PHASE-RECORDS Signed 13.0 Occurs 9 Times POA3.1
Element: Phase Records
POI-PHASE-MINUTES Signed 11.0 Occurs 9 Times
Element: Phase Minutes
POI-PHASE-SECONDS Signed 2.0 Occurs 9 Times POA3.1
Element: Phase Seconds
POI-TOTAL-RECORDS Signed 11.0 POA3.1
Element: Total Records
POI-TOTAL-MINUTES Signed 11.0
Element: Total Minutes
POI-TOTAL-SECONDS Signed 2.0 POA3.1
Element: Total Seconds
POIADIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POISET1 DATA-MART-NAME POA1.1 POA10
POA3.1 POAX.1
|
