HSP_ACCT_ICDPX_ALT

Description: |
This table contains the hospital account alternate ICD procedures from the hospital account (HAR) master file. Alternate ICD procedures will be specified if hospital accounts are coded with two sets of ICD codes.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ACCT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ACCT_ID | NUMERIC | No |
The unique identifier for the hospital account 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 | ICD_PX_ALT_ID | VARCHAR | No |
The alternate ICD procedures stored in the hospital account.
4 | ICD_PX_ALT_ID_ICD_PX_NAME | VARCHAR | No |
The name of the ICD procedure record.
5 | ICD_PX_ALT_DATE | DATETIME | No |
The alternate ICD procedure service date.
6 | ICD_PX_ALT_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 | ICD_PX_ALT_EVNT_NUM | INTEGER | No |
The alternate ICD procedure event link number.
8 | ICD_PX_ALT_EXCLD_YN | VARCHAR | No |
The alternate ICD procedure exclude from clinical reporting data.
May contain organization-specific values: No
Category Entries:
Yes
No
9 | ICD_PX_ALT_AFSOI_YN | VARCHAR | No |
The alternate ICD procedure affects severity of illness data.
The category values for this column were already listed for column: ICD_PX_ALT_EXCLD_YN
10 | ICD_PX_ALT_AFROM_YN | VARCHAR | No |
The alternate ICD procedure affects risk of mortality data.
The category values for this column were already listed for column: ICD_PX_ALT_EXCLD_YN