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.