Generic ANSI X12 Transactions
Intended to be used as a template (as each X12 implementation is dependent on specific business rules)
X12_811_Export.php
ANSI ASC X12.811 (Financial Series [FIN]) Consolidated Service Invoice/Statement (version 004010)
X12_835_Export.php
ANSI ASC X12.835 Health Care Claim Payment/Advice transaction set ( version: 005010X221 )
X12_999_Import.php
ANSI ASC X12.999 Functional Acknowledgement ( version: 005010X231A1 )
SQLCreate_X12_999_ErrorMessageTable:
Creates a SQL table containing X12 999 response messages
Import_X12_999:
Creates a stored procedure that imports, parses and outputs an email containing the X12 999 response file with response messages.
Note: Requires SQLCreate_X12_999_ErrorMessageTable, created by the above
SQLCreate_TA1_InterChangeNoteCode:
Creates and populates a table, tbl_TA1_InterChangeNoteCode that contains the X12 TA1 Interchange Note Codes and descriptions.
Import_X12_TA1:
Creates a stored procedure that imports, parses and outputs an email containing the X12 TA1 acknowledgement file with response messages.
Note: Requires SQLCreate_X12_TA1_InterChangeNoteCode, created by the above
usp_Import_X12
T-SQL only. Imports an X12 into a table and groups the segments by Hierarchical Level so that related data segments may be grouped together. (this was a bit of a hack I used to do a quick and dirty reconciliation, but it's come in useful for ad hoc tasks involving X12 formatted files)
See also:
X12_Import_CreateTables.sql
X12_Import_Files.sql
X12_270_Export_Template.sql
Template for outputting an X12 270 Eligibility Inquiry using MS SQL