Skip to main content

Appendix B: EDI Transaction Set

Currently, PKware uses EDI transaction set 837 “Healthcare claim”. In order to alter the transaction set being used, please contact PKware Professional Services.

The transaction set is used to parse data in the EDI file format. The parsing starts from the tag of each EDI line and is based on the value of each column or the position of each column. Once parsing is done for an EDI line, the sensitive data in that line is detected. PKWARE sensitive type ID is also called regex ID under some documentations.

The EDI transaction set is combined with menu.txt and multiple dictionary files. Menu.txt is the catalog for all dictionary files. Menu.txt can contain multiple lines and each line defines one column of a tag. 

One directory file can contain multiple lines and each line defines one value for the related column.

menu.txt format:

[EDI tag]*[EDI column number (start from 0)]*[dictionary file name]

dictionary file format:

[EDI value for the column defined in menu.txt](+[offset from such column]):[Dataguise sensitive type ID list (split by ',')]#[comments]

Example 1:

menu.txt:

...

NM1*8*Identification Code Qualifier.txt

...

Above line means:  if an EDI line starts with tag "NM1", we look up dictionary file "Identification Code Qualifier.txt" for how to process its column 8.

Identification Code Qualifier.txt:

...

34(+1):4,5,6#Social Security Number

...

Above line means: if column 8 has value "34", its next column (+1) can contain Security Number (whose sensitive type ID is 4, 5, or 6)

Here is an EDI line which will match above dictionary entry:

NM1*IL*1*Duo*John*X*Mr**34*365118888*12*05

Example 2:

menu.txt:

...

N4*4*country.txt

...

Above line means: if an EDI line starts with tag "N4", we look up dictionary file "country.txt" for how to process it column 4.

country.txt:

~(+0):77#Country

Above line means: regardless of what value is on column 4 (this is meaning of ~), its current column (+0) can be country name.

Here is an EDI line which will match above dictionary entry:

N4*Fremont*CA*94538*USA

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.