Requirements ID Category Requirement Description Acceptance Criteria Data Integration - Publish The Data Source shall publish all All transactions that are needed by the DI-001 Create, Update, and Delete operations EDR are available by the publishing data on data being sent to the EDR source Data Integration - Publish The Data Source (JIS, ODY, etc.) shall Transactions occurring at the data source DI-002 publish data as close to the Create, are available with little to no delay without Update, or Delete event in near compromising transactional integrity time (as soon as practical) DI-003 Data Integration - Publish The publishing component shall be able Published transactions are either in a file to publish to either a file, a staging on a secured location or in a staging database, or with a direct call to the database. EDR Data Service DI-004 Data Integration - Staging Staging of data shall be either in a Published transactions are either in a file secure file location or database on a secured location or in a staging database. DI-005 Data Integration - Staging The staged data shall identify when data Each record stored in a staging area also arrived to the staging area. contain the date/time when data was placed there. DI-006 Data Integration - Staging The staged data shall identify the source Each record stored in a staging area also (system) providing the data. contain the data source DI-007 Data Integration - Transformations shall not fail an entire Batches complete even with rows that fail Transformation (define as batch due to a single record failure source transform destination) DI-008 Data Integration - Transformations shall log all operations A log file exists for each transformation Transformation that contains a record of operations performed as part of the transformation
Requirements ID Category Requirement Description Acceptance Criteria DI-001 Data Integration - Publish The Data Source shall publish all Create, Update, and Delete operations on data being sent to the EDR All transactions that are needed by the EDR are available by the publishing data source DI-002 Data Integration - Publish The Data Source (JIS, ODY, etc.) shall publish data as close to the Create, Update, or Delete event in near (as soon as practical) Transactions occurring at the data source are available with little to no delay without compromising transactional integrity DI-003 Data Integration - Publish The publishing component shall be able to publish to either a file, a staging database, or with a direct call to the EDR Data Service Published transactions are either in a file on a secured location or in a staging database. DI-004 Data Integration - Staging Staging of data shall be either in a secure file location or database Published transactions are either in a file on a secured location or in a staging database. DI-005 Data Integration - Staging The staged data shall identify when data arrived to the staging area. Each record stored in a staging area also contain the date/time when data was placed there. DI-006 Data Integration - Staging The staged data shall identify the source (system) providing the data. Each record stored in a staging area also contain the data source DI-007 Data Integration - Transformation (define as source transform destination) Transformations shall not fail an entire batch due to a single record failure Batches complete even with rows that fail DI-008 Data Integration - Transformation Transformations shall log all operations A log file exists for each transformation that contains a record of operations performed as part of the transformation time