CLAIM_INFO_3

Description:

This table contains claims information from claim information (CLM) records for Hospital and Professional Billing.

Primary Key

Column Name	Ordinal Position
CLAIM_ID	1

Column Information

	Name	Type	Discontinued?
1	CLAIM_ID	NUMERIC	No
	The unique identifier for the Claim Info record.
2	STER_ABORTION_CD_C_NAME	VARCHAR	No
	Stores the sterilization/abortion code to print on the claim. May contain organization-specific values: Yes No Entries Defined
3	SVC_AUTH_EXCEPT_C_NAME	VARCHAR	No
	This column stores the service authorization exception code detailing why a claim was exempt from the normal authorization process. May contain organization-specific values: Yes Category Entries: Immediate/Urgent Care Services Rendered in a Retroactive Period Emergency Care Client has Temporary Medicaid Request from County for Second Opinion to Determine if Recipient Can Work Request for Override Pending Special Handling
4	AMBULANCE_LICENSE_PLATE_NUMBER	VARCHAR	No
	The license plate number of the ambulance used for transport
5	AMBULANCE_PICK_UP_UTC_DTTM	DATETIME (UTC)	No
	The pick-up time of the ambulance ride
6	AMBULANCE_DROP_OFF_UTC_DTTM	DATETIME (UTC)	No
	The drop-off time of the ambulance ride
7	AMBULANCE_ROUNDTRIP_REASON	VARCHAR	No
	The reason for roundtrip for the ambulance ride
8	AMBU_STRETCHER_REASON_C_NAME	VARCHAR	No
	The reason for stretcher for the ambulance ride May contain organization-specific values: Yes No Entries Defined
9	AMBULANCE_SQUAD_C_NAME	VARCHAR	No
	The ambulance squad of the ambulance that the patient rode in May contain organization-specific values: Yes No Entries Defined
10	AMBULANCE_RUN_NUMBER	VARCHAR	No
	The run number of the ambulance ride that transported the patient
11	AMBULANCE_VEHICLE_NUMBER	VARCHAR	No
	The vehicle number for the ambulance that transported the patient
12	AMBULANCE_DISPATCH_DX_ID_DX_NAME	VARCHAR	No
	The name of the diagnosis.