POIADIM FILE
REFERENCED BY
POA4.1 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
Data Mart Name
POI-VEND-DIMENSION Alpha 50 (Lower Case) POA1.1
Vend Dimension
POI-PROD-DIMENSION Alpha 50 (Lower Case) POA1.1
Prod Dimension
POI-ORG-DIMENSION Alpha 50 (Lower Case) POA1.1
Organization The Organization Dimension Name field
Dimensioin Name 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
Buyr Dimension
POI-TIME-DIMENSION Alpha 50 (Lower Case) POA1.1
Time Dimension
POI-MEAS-DIMENSION Alpha 50 (Lower Case) POA1.1
Meas Dimension
POI-YEAR-DIMENSION Alpha 50 (Lower Case) POA1.1
Year Dimension
POI-DATA-LOAD-OPT Alpha 1 POA1.1
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
Datald Beg Per
POI-DATALD-BEG-YR Numeric 4 POA1.1
Datald Beg Yr
POI-DATALD-END-PER Numeric 2 POA1.1
Datald End Per
POI-DATALD-END-YR Numeric 4 POA1.1
Datald End Yr
POI-MAINT-DATE Numeric 8 (yyyymmdd)
Maintenance Date The date last changed.
POI-MAINT-TIME Numeric 6 (hhmmss)
Maintenance Time The time last changed.
POI-PHASE-RECORDS Signed 13.0 Occurs 9 Times POA3.1
Phase Records
POI-PHASE-MINUTES Signed 11.0 Occurs 9 Times
Phase Minutes
POI-PHASE-SECONDS Signed 2.0 Occurs 9 Times POA3.1
Phase Seconds
POI-TOTAL-RECORDS Signed 11.0 POA3.1
Total Records
POI-TOTAL-MINUTES Signed 11.0
Total Minutes
POI-TOTAL-SECONDS Signed 2.0 POA3.1
Total Seconds
POIADIM FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POISET1 DATA-MART-NAME POA1.1 POA3.1
POA4.1 POAX.1
|
