Reporting Data Store - Data Dictionary
Overview
The Enterprise Back Office solution is a prolific collector of operational data. This data is invaluable in the analysis and optimization of business process. This data is incredibly useful for a number of purposes including:
- Transactional analytics
- Operational reporting
- Financial reporting
- Enterprise Resource Planning (ERP) integration
- Data warehouse integration
The RDS is an Enterprise Back Office (EBO) module that provides you direct access to your operational data, collected by EBO. The Reporting Data Store (RDS) has been conceived in order to give users ownership and access to their data. The user has the ability to design and build their own reports and extracts for this data and interrogate this database, at will.
This feature improves access to data as well as significantly reducing the need for custom reporting allowing users to focus on more functional areas of value.
The Reporting Data Store (RDS) Data Dictionary is a set of information describing the contents and structure of the RDS database and the relationship between its elements.
|
Data Type |
References |
|
bigint |
8-byte storage |
|
binary |
Maximum length of 8,000 bytes (Fixed-length binary data) |
|
Bit |
Integer data type that can take a value of 1, 0, or null |
|
datetime |
Structure to the specified year, month, and day for the specified calendar |
|
decimal |
Fixed precision and scale numbers (Maximum number of decimal digits is 38. Default precision is 18.) |
|
float |
Scientific notation |
|
int |
4-byte storage |
|
money |
8-bytes, supports 2 decimals |
|
numeric |
Fixed precision and scale numbers |
|
nvarchar |
Stores Unicode data |
|
nvarchar(#) |
Stores Unicode data with “X” maximum values |
|
PK |
Primary Key |
|
smalldatetime |
Date that is combined with a time of day |
|
smallint |
2-byte storage |
|
smallmoney |
4-bytes (supports 4 decimals) |
|
time |
Defines a time of day |
|
tinyint |
|
|
UQ |
Unique |
|
varchar |
Stores ASCII data |
|
varchar(#) |
Stores ASCII data with “X” maximum values |
Description Note: PK = Primary Key; UQ - Unique
Data Dictionary
A list and description of tables available in the RDS.
|
Category |
Description |
|
Foundation |
System foundation tables |
|
Transaction |
Sales Transaction related tables |
|
Inventory |
Inventory master and transaction tables |
|
Financial |
Financial tables for Settlements, Deposits, Safe Counts, and Petty Cash |
|
Workforce |
Workforce related tables |
|
Forecast |
Budgets and Forecasts |
|
Polling |
Polling configuration |
|
Loyalty |
Loyalty reference and transaction tables |
|
Integration |
Integration data tables |
|
External |
External tables (not for general use) |
|
System |
Tables to support ETL process |
******************
Comments
0 comments
Article is closed for comments.