Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| AgClID | int identity | 4 | √ | null |
|
|
Primary key - Unique identifier for each agency clearing house configuration |
|
| fkClearingHouseID | int | 4 | √ | null |
|
|
Clearing house reference - Links to ClearingHouse table for the clearing house provider |
|
| AgInterchangeQualifier | varchar | 2 | √ | null |
|
|
Agency interchange qualifier - EDI interchange qualifier code for the agency |
|
| AgInterchangeID | varchar | 15 | √ | null |
|
|
Agency interchange ID - EDI interchange identification number for the agency |
|
| AcknoledgementReq | int | 4 | √ | null |
|
|
Acknowledgement required - Flag indicating if EDI acknowledgement is required |
|
| UsageIndicator | varchar | 1 | √ | null |
|
|
Usage indicator - EDI usage indicator (P=Production, T=Test) |
|
| FunctionalIdentifier | varchar | 2 | √ | null |
|
|
Functional identifier - EDI functional identifier code for transaction type |
|
| RespAgencyCode | varchar | 1 | √ | null |
|
|
Responsible agency code - Code identifying the responsible agency |
|
| VersionCode | varchar | 12 | √ | null |
|
|
Version code - EDI version/release code for transaction standards |
|
| EDI | varchar | 3 | √ | null |
|
|
EDI code - Electronic Data Interchange transaction code |
|
| BHT_StructureCode | varchar | 4 | √ | null |
|
|
BHT structure code - Beginning of Hierarchical Transaction structure code |
|
| BHT_TrPurposeCode | varchar | 2 | √ | null |
|
|
BHT transaction purpose code - Transaction purpose code for BHT segment |
|
| BHT_TrTypeCode | varchar | 2 | √ | null |
|
|
BHT transaction type code - Transaction type code for BHT segment |
|
| REF_IDQualifier | varchar | 3 | √ | null |
|
|
REF ID qualifier - Reference identification qualifier for REF segment |
|
| REF_VersionCode | varchar | 30 | √ | null |
|
|
REF version code - Reference version code for REF segment |
|
| NM1_EntityIDCode | varchar | 3 | √ | null |
|
|
NM1 entity ID code - Entity identifier code for NM1 segment |
|
| NM1_EntityTypeQualifier | varchar | 1 | √ | null |
|
|
NM1 entity type qualifier - Entity type qualifier for NM1 segment |
|
| NM1_IDCodeQualifier | varchar | 2 | √ | null |
|
|
NM1 ID code qualifier - Identification code qualifier for NM1 segment |
|
| NM1_IDCode | varchar | 10 | √ | null |
|
|
NM1 ID code - Identification code for NM1 segment |
|
| PER_ContFuncCode | varchar | 2 | √ | null |
|
|
PER contact function code - Contact function code for PER segment |
|
| PER_ContName | varchar | 25 | √ | null |
|
|
PER contact name - Contact name for PER segment |
|
| PER_NumQualifier | varchar | 2 | √ | null |
|
|
PER number qualifier - Communication number qualifier for PER segment |
|
| PER_Num | varchar | 25 | √ | null |
|
|
PER number - Communication number for PER segment |
|
| HL_A_LevelCode | varchar | 2 | √ | null |
|
|
HL A level code - Hierarchical level code for HL segment A |
|
| HL_A_ChildCode | varchar | 1 | √ | null |
|
|
HL A child code - Hierarchical child code for HL segment A |
|
| HL_A_PRV_Code | varchar | 3 | √ | null |
|
|
HL A PRV code - Provider code for PRV segment in HL A |
|
| HL_A_PRV_RefIDQualifier | varchar | 3 | √ | null |
|
|
HL A PRV reference ID qualifier - Reference ID qualifier for PRV segment in HL A |
|
| HL_A_PRV_RefID | varchar | 30 | √ | null |
|
|
HL A PRV reference ID - Reference ID for PRV segment in HL A |
|
| HL_A_NM1_EntityIDCode | varchar | 3 | √ | null |
|
|
HL A NM1 entity ID code - Entity ID code for NM1 segment in HL A |
|
| HL_A_NM1_EntityTypeQualifier | varchar | 1 | √ | null |
|
|
HL A NM1 entity type qualifier - Entity type qualifier for NM1 segment in HL A |
|
| HL_A_NM1_IDCodeQualifier | varchar | 2 | √ | null |
|
|
HL A NM1 ID code qualifier - ID code qualifier for NM1 segment in HL A |
|
| HL_A_NM1_IDCode | varchar | 10 | √ | null |
|
|
HL A NM1 ID code - ID code for NM1 segment in HL A |
|
| HL_A_REF_ID1Qualifier | varchar | 3 | √ | null |
|
|
HL A REF ID1 qualifier - First reference ID qualifier for REF segment in HL A |
|
| HL_A_REF_ID1Value | varchar | 20 | √ | null |
|
|
HL A REF ID1 value - First reference ID value for REF segment in HL A |
|
| HL_A_REF_ID2Qualifier | varchar | 3 | √ | null |
|
|
HL A REF ID2 qualifier - Second reference ID qualifier for REF segment in HL A |
|
| HL_A_REF_ID2Value | varchar | 20 | √ | null |
|
|
HL A REF ID2 value - Second reference ID value for REF segment in HL A |
|
| HL_B_LevelCode | varchar | 2 | √ | null |
|
|
HL B level code - Hierarchical level code for HL segment B |
|
| HL_B_ChildCode | varchar | 1 | √ | null |
|
|
HL B child code - Hierarchical child code for HL segment B |
|
| HL_B_SBR_PayerResp | varchar | 1 | √ | null |
|
|
HL B SBR payer responsibility - Payer responsibility code for SBR segment in HL B |
|
| HL_B_SBR_Relationship | varchar | 2 | √ | null |
|
|
HL B SBR relationship - Individual relationship code for SBR segment in HL B |
|
| HL_B_SBR_FilingIndicator | varchar | 2 | √ | null |
|
|
HL B SBR filing indicator - Claim filing indicator for SBR segment in HL B |
|
| NMR_EntityIDCode | varchar | 3 | √ | null |
|
|
NMR entity ID code - Entity identifier code for NMR segment |
|
| NMR_EntityTypeQualifier | varchar | 1 | √ | null |
|
|
NMR entity type qualifier - Entity type qualifier for NMR segment |
|
| NMR_IDCodeQualifier | varchar | 2 | √ | null |
|
|
NMR ID code qualifier - Identification code qualifier for NMR segment |
|
| SefFilePath | varchar | 100 | √ | null |
|
|
SEF file path - Standard Exchange Format file path for EDI validation |
|
| X12OutputPath | varchar | 100 | √ | null |
|
|
X12 output path - File path for X12 EDI output files |
|
| x12SegmentTerm | varchar | 10 | √ | null |
|
|
X12 segment terminator - Character(s) used to terminate EDI segments |
|
| x12ElementTerm | varchar | 1 | √ | null |
|
|
X12 element terminator - Character used to separate EDI data elements |
|
| x12CompositeTerm | varchar | 1 | √ | null |
|
|
X12 composite terminator - Character used to separate composite data elements |
|
| HL_B_NMR_EntityIDCode | varchar | 3 | √ | null |
|
|
HL B NMR entity ID code - Entity ID code for NMR segment in HL B |
|
| HL_B_NMR_IDCodeQualifier | varchar | 2 | √ | null |
|
|
HL B NMR ID code qualifier - ID code qualifier for NMR segment in HL B |
|
| CLM_FacilityCodeQualifier | varchar | 2 | √ | null |
|
|
CLM facility code qualifier - Facility code qualifier for CLM segment |
|
| CLM_FacilityCodeValue | varchar | 2 | √ | null |
|
|
CLM facility code value - Facility code value for CLM segment |
|
| CLM_SignatureOnFile | varchar | 1 | √ | null |
|
|
CLM signature on file - Signature on file indicator for CLM segment |
|
| CLM_AcceptAssign | varchar | 1 | √ | null |
|
|
CLM accept assignment - Accept assignment indicator for CLM segment |
|
| CLM_BenefitAssign | varchar | 1 | √ | null |
|
|
CLM benefit assignment - Benefit assignment indicator for CLM segment |
|
| CLM_ReleaseofInfo | varchar | 1 | √ | null |
|
|
CLM release of info - Release of information indicator for CLM segment |
|
| toBill | int | 4 | √ | null |
|
|
To bill flag - Flag indicating if this configuration should be used for billing |
|
| NM1_2010BB_Payer | varchar | 35 | √ | null |
|
|
NM1 2010BB payer - Payer name for NM1 segment in 2010BB loop |
Relationships
Close relationships within degrees of separation
