Received: What is required to migrate data from the final staging
tables into the production schema? The documentation refers to
validation, creating keys, various types of balances. What quality does
the data have to be? There are outstanding issues which raise questions
about some data items and configuration is still not complete for every
Answer: In order to migrate the data from staging to Production, it is expected that the following will hold true:
all validation performed via the frontend validation routines will be
met by the converted data (all table fields will meet the business needs
and code-based tables contain values defined in the Config tables.
2. all Primary keys on the staging tables are unique
3. all foreign keys on the staging tables relate to parent records (no orphan foreign keys exist).
all inter-table relationships have been satisfied for particular
business object (eg. a Person has at least one record on Person ID, and a
Bill, Adjustment or Payment has a matching record on CI_FT)
5. any custom algorithm validation is met.