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 11:24:01 2016

Home
Contact Us



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