EDI 837I 5010 SQL Database Script
A SQL DDL script that, when executed, creates a SQL Server database. This newly created database is a normalized, "relational representation" of the 5010 837I HIPAA transaction itself. So there is very little learning curve in understanding the database's structure once one has an understanding of the 837I transaction (which is defined in its implementation guide).
Steps:
- Create an empty database.
- Name it.
- Copy and paste the contents of the script into a query window.
- Point to the newly created empty database and run the script.
73 tables, 111 stored procedures and 4 user-defined functions will be generated to create a database that can store every loop, segment and data element found in an 837I 5010 X12 transaction.
Features:
- Relational representation of the 837I (INSTITUTIONAL) IG.
- Strong RFI.
- Identity PK.
- Cascade delete rules.
- Unique, non-ambiguous intuitive table/field naming conventions.
- Open source.
- All T-SQL DDL.
- Single field system generated table key fields.
- Each loop is its own table.
- Each segment that can repeat more than one is its own table.
- Database table relationships and cardinalities as defined in the implementation guide.
- The database design can accommodate the storage of any valid data element found in any 837I HIPAA X12 transaction.
- Transactional stored procedures for data inserts and updates.
Get Script: