AP_CLAIM_ANSI_DATA

Description: |
Stores the information from the ANSI 837 file.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
CLAIM_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | CLAIM_ID | NUMERIC | No |
The unique identifier for the claim record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | DATA_TYPE_C_NAME | VARCHAR | No |
Stores the type of data from the ANSI 837 file.
May contain organization-specific values: No
Category Entries:
Patient Last Name
Patient First Name
Patient Middle Name
Patient Suffix
Patient ID Qualifier
Patient ID
Subscriber Last Name
Subscriber First Name
Subscriber Middle Name
Subscriber Suffix
Subscriber ID Qualifier
Subscriber ID
ISA Sender ID Qualifier
ISA Sender ID
Billing Provider Entity Type Qualifier
Billing Provider Last Name
Billing Provider First Name
Billing Provider Middle Name
Billing Provider Suffix
Billing Provider Primary ID Qualifier
Billing Provider Primary ID
Billing Provider Specialty Qualifier
Billing Provider Specialty
Pay To Provider/Address Entity Type Qualifier
Pay To Provider Last Name
Pay To Provider First Name
Pay To Provider Middle Name
Pay To Provider Suffix
Pay To Provider Primary ID Qualifier
Pay To Provider Primary ID
Pay To Provider Specialty Qualifier
Pay To Provider Specialty
Referring Provider Entity Type Qualifier
Referring Provider Last Name
Referring Provider First Name
Referring Provider Middle Name
Referring Provider Suffix
Referring Provider Primary ID Qualifier
Referring Provider Primary ID
Referring Provider Specialty Qualifier
Referring Provider Specialty
Attending Provider Entity Type Qualifier
Attending Provider Last Name
Attending Provider First Name
Attending Provider Middle Name
Attending Provider Suffix
Attending Provider Primary ID Qualifier
Attending Provider Primary ID
Attending Provider Specialty Qualifier
Attending Provider Specialty
Rendering Provider Entity Type Qualifier
Rendering Provider Last Name
Rendering Provider First Name
Rendering Provider Middle Name
Rendering Provider Suffix
Rendering Provider Primary ID Qualifier
Rendering Provider Primary ID
Rendering Provider Specialty Qualifier
Rendering Provider Specialty
Operating Provider Entity Type Qualifier
Operating Provider Last Name
Operating Provider First Name
Operating Provider Middle Name
Operating Provider Suffix
Operating Provider Primary ID Qualifier
Operating Provider Primary ID
Other Provider Entity Type Qualifier
Other Provider Last Name
Other Provider First Name
Other Provider Middle Name
Other Provider Suffix
Other Provider Primary ID Qualifier
Other Provider Primary ID
Service Facility Location Name
Service Facility Location Primary ID Qualifier
Service Facility Location Primary ID
Subscriber Entity Type Qualifier
Subscriber Address
Subscriber City
Subscriber State
Subscriber Zip
Subscriber Secondary ID Qualifier
Subscriber Secondary ID
Patient Entity Type Qualifier
Patient Address
Patient City
Patient State
Patient Zip
Patient Secondary ID Qualifier
Patient Secondary ID
Billing Provider Address
Billing Provider City
Billing Provider State
Billing Provider Zip
Billing Provider Secondary ID Qualifier
Billing Provider Secondary ID
Pay To Provider/Address Address
Pay To Provider/Address City
Pay To Provider/Address State
Pay To Provider/Address Zip
Pay To Provider Secondary ID Qualifier
Pay To Provider Secondary ID
Referring Provider Secondary ID Qualifier
Referring Provider Secondary ID
Attending Provider Secondary ID Qualifier
Attending Provider Secondary ID
Rendering Provider Secondary ID Qualifier
Rendering Provider Secondary ID
Operating Provider Secondary ID Qualifier
Operating Provider Secondary ID
Other Provider Secondary ID Qualifier
Other Provider Secondary ID
Service Facility Location Address
Service Facility Location City
Service Facility Location State
Service Facility Location Zip
Service Facility Location Secondary ID Qualifier
Service Facility Location Secondary ID
Claim Note Reference Code
Claim Note Data
Diagnosis Qualifier
Diagnosis Code
Diagnosis POA Indicator
ICD Procedure Qualifier
ICD Procedure Code
ICD Procedure Date
E-Code Qualifier
E-Code
E-Code POA Indicator
Admitting Diagnosis Qualifier
Admitting Diagnosis Code
DRG Qualifier
DRG Code
Service Line Note Reference Code
Service Line Note Data
Service Line Procedure Qualifier
Service Line Procedure Code
Service Line Revenue Code
Service Line Modifiers
Service Line Associated Diagnosis Lines
Service Line Drug Qualifier
Service Line Drug Code
Service Line Drug Quantity
Service Line Drug Units
Service Line Drug Prescription Number
Service Line Drug Link Sequence Number
Repricing Methodology
Repriced Allowed Amount
Repriced Discount Amount
Repricing Organization Identifier
Repricing Flat Rate Amount
Repriced Approved DRG Code
Repriced Approved Amount
Repriced Approved Revenue Code
Repriced Approved Procedure Code Qualifier
Repriced Approved Procedure Code
Repriced Approved Service Count Qualifier
Repriced Approved Service Count
Repricing Reject Reason Code
Repricing Policy Compliance Code
Repricing Exception Reason Code
Service Repricing Methodology
Service Repriced Allowed Amount
Service Repriced Discount Amount
Service Repricing Organization Identifier
Service Repricing Flat Rate Amount
Service Repriced Approved DRG Code
Service Repriced Approved Amount
Service Repriced Approved Revenue Code
Service Repriced Approved Procedure Code Qualifier
Service Repriced Approved Procedure Code
Service Repriced Approved Service Count Qualifier
Service Repriced Approved Service Count
Service Repricing Reject Reason Code
Service Repricing Policy Compliance Code
Service Repricing Exception Reason Code
Service Line Units or Basis for Measurement Code
Other Payer Sequence Number
Other Payer Relationship Code
Other Payer Reference ID
Other Payer Group Name
Other Payer Claim Filing Indicator Code
Claim Adjustment Group Code
Claim Adjustment Reason Code
Claim Adjustment Monetary Amount
Claim Adjustment Quantity
Other Payer Paid Amount
Other Payer Remaining Patient Liability
Other Payer Total Non-Covered Amount
Other Payer Organization Name
Other Payer ID Code Qualifier
Other Payer ID Code
Other Payor Address Line
Other Payor Address Line 2
Other Payor City Name
Other Payer State
Other Payer ZIP Code
Other Payer Country
Other Payer Adjudication/Payment Date
Service Other Payor Primary Identifier
Service Line Paid Amount
Service Line Quantity
Service Adjustment Group Code
Service Adjustment Reason Code
Service Adjustment Amount
Service Adjustment Quantity
Service Adjudication/Payment Date
Service Remaining Patient Liability
Total Claim Billed Amount
Service Billed Amount
Service Line Procedure Description
Payer Name
Payer ID Qualifier
Payer ID
Prior Authorization
Vendor NPI
Billing Provider Contact Name
Billing Provider Contact Number Qualifier
Billing Provider Contact Number
Supervising Provider Entity Type Qualifier
Supervising Provider Last Name
Supervising Provider First Name
Supervising Provider Middle Name
Supervising Provider Suffix
Supervising Provider Primary ID Qualifier
Supervising Provider Primary ID
Supervising Provider Specialty Qualifier
Supervising Provider Specialty
Supervising Provider Secondary ID Qualifier
Supervising Provider Secondary ID
Subscriber Country
Patient Country
Billing Provider Country
Pay-To Provider/Address Country
Service Facility Location Country
Referring Provider Entity Identifier Code
4 | DATA_VALUE | VARCHAR | No |
Stores the data from the ANSI 837 file.
5 | DATA_LINE_NUM | INTEGER | No |
For data that can occur multiple times in an ANSI 837 file, this is the repetition number.
6 | DATA_ENTITY_NUM | INTEGER | No |
For entities that can occur multiple times in an ANSI 837 file, this is the repetition number.
7 | SVC_LN_NUM | INTEGER | No |
If data on this row is for a service line, then this column has the service line number.