RDS Data Dictionary - 2017.2

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.)