HSP_ACCT_PX_LIST

Description:

This table contains hospital account final procedure list information 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 coded procedures can be stored in one hospital account, each procedure will have a unique line number.
3	FINAL_ICD_PX_ID	VARCHAR	No
	A coded procedure stored in the hospital account.
4	FINAL_ICD_PX_ID_ICD_PX_NAME	VARCHAR	No
	The name of the ICD procedure record.
5	PROC_DATE	DATETIME	No
	The date associated with a coded procedure stored in the hospital account.
6	PROC_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.
7	PROC_EVENT_NUMBER	INTEGER	No
	The event number associated with a coded procedure stored in the hospital account. Event numbers are used to associate coded procedures with CPT™ codes.
8	PX_AFCT_ROM_YN	VARCHAR	No
	Indicates whether the procedure has an impact on the DRG's Risk of Mortality. May contain organization-specific values: No Category Entries: Yes No
9	PX_EXCLD_RPT_YN	VARCHAR	No
	Indicates whether the procedure was marked to be excluded from clinical reporting. The category values for this column were already listed for column: PX_AFCT_ROM_YN
10	PX_AFCT_SOI_YN	VARCHAR	No
	Indicates whether the procedure has an impact on the DRG's Serverity of Illness. The category values for this column were already listed for column: PX_AFCT_ROM_YN
11	AFFECTS_DRG_YN	VARCHAR	No
	Indicates whether the procedure has an impact on the DRG. The category values for this column were already listed for column: PX_AFCT_ROM_YN
12	INTERVENTION_TYPE_C_NAME	VARCHAR	No
	The intervention type for the ICD procedure. May contain organization-specific values: No Category Entries: General Intervention Specific Intervention