HSP_ACCT_CPT_CODES

Description:

This table contains hospital account CPT(R) codes from the Hospital Accounts Receivable (HAR) master file.

Primary Key

Column Name	Ordinal Position
HSP_ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCOUNT_ID	NUMERIC	No
	The ID number of a hospital account.
2	LINE	INTEGER	No
	The line number in the results of a query. Since multiple CPT™ codes can be stored in one hospital account, each CPT™ code will have a unique line number.
3	CPT_CODE	VARCHAR	No
	A CPT™ code stored in the hospital account.
4	CPT_CODE_DATE	DATETIME	No
	A date associated with a CPT™ code stored in the hospital account.
5	CPT_PERF_PROV_ID_PROV_NAME	VARCHAR	No
	The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
6	CPT_EVENT_NUMBER	INTEGER	No
	The event number associated with a CPT™ code stored in the hospital account. Event number are used to associate CPT™ codes with procedure codes.
7	CPT_MODIFIERS	VARCHAR	No
	A modifier or modifiers associated with a CPT™ code stored in the hospital account.
8	LMRP_CODE	VARCHAR	No
	A Local Medical Review Policy (LMRP) code associated with a CPT™ code stored in the hospital account.
9	CPT_CODE_DESC	VARCHAR	No
	The description of a CPT® code stored in the hospital account.
10	PX_APC_FAC_RMB_AMT	NUMERIC	No
	The monetary reimbursement amount for the procedure Ambulatory Payment Classification (APC) FAC on the hospital account.
11	PX_OCE_EDIT_CODE	VARCHAR	No
	The procedure Outpatient Code Editor (OCE) edit code for the hospital account.
12	PX_APC_CODE	VARCHAR	No
	The procedure Ambulatory Payment Classification (APC) code for the hospital account.
13	PX_HCFA_PAYMT_AMT	NUMERIC	No
	The procedure Health Care Payment and Remittance Advice (HCFA) monetary payment amount for the hospital account.
14	PX_COPAY_AMT	NUMERIC	No
	The monetary copay amount for the procedure on the hospital account.
15	PX_REV_CODE_ID	NUMERIC	No
	The unique ID of the revenue code.
16	PX_REV_CODE_ID_REVENUE_CODE_NAME	VARCHAR	No
	The name of the revenue code.
17	CPT_EXCLD_RPT_YN	VARCHAR	No
	Indicates whether to exclude CPT codes from clinical reporting. This is frequently used to filter out procedures copied over during an account merge to prevent double counting. May contain organization-specific values: No Category Entries: Yes No
18	CPT_QUANTITY	INTEGER	No
	Quantity of the CPT(R)/HCPCS code. Hospital accounts created prior to Epic 2014 have a null value in this column which implies a quantity of 1.
19	CPT_POS_TYPE_C_NAME	VARCHAR	No
	Stores the Place of Service (POS) Type value for a coded CPT on an account.. May contain organization-specific values: Yes Category Entries: Telehealth - Provided in Patient's Home Office Home Assisted Living Facility Group Home Mobile Unit Temporary Lodging Walk-in Retail Health Clinic Place of Employment - Worksite Off Campus - Outpatient Hospital Urgent Care Facility Inpatient Hospital On Campus - Outpatient Hospital Emergency Room - Hospital Ambulatory Surgical Center Birthing Center Military Treatment Facility Outreach Site/Street Skilled Nursing Facility Nursing Facility Custodial Care Facility Hospice Adult Living Care Facility Ambulance - Land Ambulance - Air or Water Independent Clinic Federally Qualified Health Center Inpatient Psychiatric Facility Psychiatric Facility - Partial Hospitalization Community Mental Health Center Intermediate Care Facility/ Individuals with Intellectual Disabilities Residential Substance Abuse Treatment Facility Psychiatric Residential Treatment Center Non-residential Substance Abuse Treatment Facility Non-residential Opioid Treatment Facility Mass Immunization Center Comprehensive Inpatient Rehabilitation Facility Comprehensive Outpatient Rehabilitation Facility End-Stage Renal Disease Treatment Facility Programs of All-Inclusive Care for the Elderly (PACE) Center Public Health Clinic Rural Health Clinic Independent Laboratory Other Place of Service Pharmacy Telehealth - Provided Other than in Patient's Home School Homeless Shelter Indian Health Service Free-standing Facility Indian Health Service Provider-based Facility Tribal 638 Free-standing Facility Tribal 638 Provider-based Facility Prison/Correctional Facility