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
13 PX_AU_PERF_LOC_C_NAME VARCHAR No
This item stores where the procedure was performed, and is used in Australian Coding workflows.
May contain organization-specific values: No
Category Entries:
This Facility as a Direct Service
Other Facility as an Admitted Patient
Other Facility as a Non-admitted Patient
Patient's Home as an Admitted Patient
This Facility on behalf of a Public Hospital
This Facility on behalf of a Private Facility