HSP_ACCOUNT

Description: |
This table contains hospital account information from the Hospital Account (HAR) and Claim (CLM) master files. It will exclude professional billing accounts in classic PB self-pay service areas.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
HSP_ACCOUNT_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | HSP_ACCOUNT_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account.
2 | HSP_ACCOUNT_NAME | VARCHAR | No |
The name of the patient associated with the hospital account.
3 | ACCT_CLASS_HA_C_NAME | VARCHAR | No |
The hospital account's account class.
May contain organization-specific values: Yes
4 | ACCT_FIN_CLASS_C_NAME | VARCHAR | No |
The hospital account's financial class.
May contain organization-specific values: Yes
Category Entries:
Commercial
Medicare
Medicaid
Self-Pay
Worker's Comp
Tricare
Champva
Group Health Plan
FECA Black Lung
Blue Shield
Medigap
Other
DK Regional
Client
Received Self-Pay
Sent to Consolidated Self-Pay
Patient Assistance Program
5 | ACCT_SLFPYST_HA_C_NAME | VARCHAR | No |
The hospital account's self-pay status.
May contain organization-specific values: No
Category Entries:
Full Self-Pay Due
Review
Payment Plan
Pre-collection
Bad Debt
Prorated
6 | ACCT_BILLSTS_HA_C_NAME | VARCHAR | No |
This column stores the status of the hospital account. If this is a professional billing default hospital account, this column always returns 4 (Billed).
May contain organization-specific values: No
Category Entries:
Open
Discharged/Not Billed
Billed
Zero Balance
Bad Debt
Voided
Closed
Archived
Combined
7 | ACCT_ZERO_BAL_DT | DATETIME | No |
This column stores the date the hospital account went to a zero balance. This may be empty for older accounts, as Zero Balance Date (I HAR 244) had not always been available.
8 | ADM_DATE_TIME | DATETIME (Local) | No |
This column stores the admission date and time associated with the hospital account. The admission date and time (I HAR 400/405) are first pulled from the coding information on the hospital account. If that data is not stored on the hospital account yet, then this will use the primary encounter to determine the admission date and time. The exact items used varies based on the encounter type.
9 | ADM_DEPARMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
10 | ADM_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
11 | ADM_PRIORITY | VARCHAR | No |
The admission priority stored in the hospital account.
12 | ADM_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.
13 | ATTENDING_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.
14 | AUTOPSY_DONE_YN | VARCHAR | No |
Denotes whether an autopsy was performed.
May contain organization-specific values: No
Category Entries:
Yes
No
15 | BAD_DEBT_AGENCY_ID | NUMERIC | No |
This column stores the unique identifier for the collection agency that was selected when the hospital account was sent to bad debt, sent to external agency A/R, outsourced, or pre-collected. This is cleared when the account returns from bad debt, returns from external agency A/R, or is no longer outsourced.
16 | BAD_DEBT_AGENCY_ID_COLL_AGENCY_NAME | VARCHAR | No |
The name of the collection agency.
17 | BAD_DEBT_BUCKET_ID | NUMERIC | No |
This column stores the unique identifier for the bad debt bucket that was created when the hospital account was sent to bad debt.
18 | CODE_BLUE_YNU | VARCHAR | No |
Denotes whether the patient associated with the hospital account was code blue.
May contain organization-specific values: No
Category Entries:
Yes
No
Unknown
19 | COMBINE_ACCT_ID | NUMERIC | No |
This column stores the unique identifier for the target hospital account into which this hospital account was combined.
20 | COMBINE_DATE_TIME | DATETIME (Local) | No |
The date and time that this hospital account was combined with another one.
21 | COMBINE_USER_ID | VARCHAR | No |
This column stores the unique identifier for the user who combined this hospital account with another one.
22 | COMBINE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
23 | COMPLETION_DT_TM | DATETIME (Local) | No |
The date and time when abstracting was completed for the hospital account.
24 | CVG_LIST_SELECT_YN | VARCHAR | No |
Denotes whether coverages have been put on the hospital account.
May contain organization-specific values: No
Category Entries:
No
Yes
25 | DISCH_DATE_TIME | DATETIME (Local) | No |
This column stores the discharge date and time associated with the hospital account. The discharge date and time (I HAR 425/430) are first pulled from the coding information on the hospital account. If that data is not stored on the hospital account yet, then this will use the primary encounter to determine the discharge date and time. The exact items used varies based on the encounter type.
26 | DISCH_DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
27 | DISCH_DESTIN_HA_C_NAME | VARCHAR | No |
This column stores the discharge destination stored in the hospital account. This item is copied from the patient's ADT event record.
May contain organization-specific values: Yes
28 | DISCH_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
29 | DISCH_TO | VARCHAR | No |
A discharge destination stored in the hospital account for coding and/or abstracting purposes. This is manually entered into the hospital account.
30 | DRG_EXPECTED_REIMB | NUMERIC | No |
This column stores the diagnosis-related group (DRG)-based expected reimbursement amount stored in the hospital account.
31 | ER_ADMIT_DATE_TIME | DATETIME | No |
The emergency room admission date and time stored in the hospital account.
32 | ER_DSCHG_DATE_TIME | DATETIME | No |
The emergency room discharge date and time stored in the hospital account.
33 | ER_PAT_STS_HA_C_NAME | VARCHAR | No |
The emergency room patient status stored in the hospital account.
May contain organization-specific values: Yes
34 | EXPIRATION_UNIT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
35 | FINAL_DRG_ID | VARCHAR | No |
The final coded DRG stored in the hospital account.
36 | FINAL_DRG_ID_DRG_NAME | VARCHAR | No |
The name of the Diagnoses Related Group name.
37 | FRST_DMND_STMT_DT | DATETIME | No |
The date that the first demand statement was sent for the hospital account.
38 | FRST_STMT_DATE | DATETIME | No |
The date that the first statement (non-demand) was sent for the hospital account. If you are sending informational or prorated statements this date will store the date the first informational, prorated, or full statement was sent.
39 | GUAR_ADDR_1 | VARCHAR | No |
The first line of the street address of the guarantor for the hospital account at time of discharge.
40 | GUAR_ADDR_2 | VARCHAR | No |
The second line of the street address of the guarantor for the hospital account at time of discharge.
41 | GUAR_NAME | VARCHAR | No |
The name of the guarantor for the hospital account at time of discharge.
42 | GUAR_WK_PHONE | VARCHAR | No |
The work phone number of the guarantor for the hospital account at time of discharge.
43 | GUAR_ZIP | VARCHAR | No |
The ZIP Code of the guarantor for the hospital account at time of discharge.
44 | IS_CALLED_911_YNU | VARCHAR | No |
Denotes whether 911 was called.
The category values for this column were already listed for column: CODE_BLUE_YNU
45 | IS_INSTI_YN | VARCHAR | No |
Denotes whether the hospital account is designated as an institutional account. A hospital account is considered institutional if its guarantor is of a type designated as institutional in the system definition profile.
The category values for this column were already listed for column: CVG_LIST_SELECT_YN
46 | LAST_DMND_STMT_DT | DATETIME | No |
The last date that a demand statement was sent for the hospital account.
47 | LAST_INTRM_BILL_DT | DATETIME | No |
The last date that interim billing was performed for the hospital account.
48 | MEANS_OF_ARRV_C_NAME | VARCHAR | No |
The patient's means of arrival stored in the hospital account.
May contain organization-specific values: Yes
49 | NUM_OF_DET_BILLS | INTEGER | No |
The number of detail bills that have been sent for the hospital account.
50 | NUM_OF_DMND_STMTS | INTEGER | No |
The number of demand statements that have been sent for the hospital account.
51 | NUM_OF_STMTS_SENT | INTEGER | No |
The number of statements (non-demand) that have been sent for the hospital account.
52 | PAT_CITY | VARCHAR | No |
The city portion of the address of the patient for the hospital account at time of discharge.
53 | PAT_DOB | DATETIME | No |
The date of birth of the patient for the hospital account at time of discharge.
54 | PAT_HOME_PHONE | VARCHAR | No |
The home phone number of the patient for the hospital account at time of discharge.
55 | PAT_SSN | VARCHAR | No |
The social security number of the patient for the hospital account at time of discharge.
56 | PAT_WRK_PHN | VARCHAR | No |
The work phone number of the patient for the hospital account at time of discharge.
57 | PAT_ZIP | VARCHAR | No |
The ZIP Code of the patient for the hospital account at time of discharge.
58 | POLICE_INVOLVD_YNU | VARCHAR | No |
Denotes whether the police were involved in the circumstances of the patient's hospital stay.
The category values for this column were already listed for column: CODE_BLUE_YNU
59 | POST_ADM_EXP_HA_C_NAME | VARCHAR | No |
Denotes whether the patient expired after admission.
May contain organization-specific values: Yes
60 | POST_OP_EXP_HA_C_NAME | VARCHAR | No |
Denotes whether the patient expired after an operation.
The category values for this column were already listed for column: POST_ADM_EXP_HA_C_NAME
61 | PREBILL_BUCKET_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account's prebilled bucket.
62 | PRIM_SVC_HA_C_NAME | VARCHAR | No |
The primary service stored in the hospital account for the patient's hospital stay.
May contain organization-specific values: Yes
63 | PSYCH_CASE_YNU | VARCHAR | No |
Denotes whether the patient is classified as a psychiatric case.
The category values for this column were already listed for column: CODE_BLUE_YNU
64 | REHAB_INDICATOR | VARCHAR | No |
Denotes whether the patient was undergoing rehab.
65 | SCNDRY_SVC_HA_C_NAME | VARCHAR | No |
The secondary service stored in the hospital account for the patient's hospital stay.
The category values for this column were already listed for column: PRIM_SVC_HA_C_NAME
66 | SELF_PAY_BUCKET_ID | NUMERIC | No |
This column stores the unique identifier for the hospital account's self-pay bucket.
67 | SERV_AREA_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
68 | TOT_ADJ | NUMERIC | No |
The total of all adjustments on the hospital account.
69 | TOT_CHGS | NUMERIC | No |
The total of all charges on the hospital account.
70 | TRANSFER_FROM | VARCHAR | No |
Denotes where the patient was transferred from.
71 | TREATMENT_AUTH_NUM | VARCHAR | No |
Note: This column will be deprecated in a future release. Please start referring to the column HSP_ACCT_CLAIM_HAR.AUTHORIZATION_NUM in your reports. Authorization Number: Used on claims for identifying patient referrals and affected reimbursements. Refer to CLAIM_INFO2 table if not set on the hospital account.
72 | UB92_COINS_DAYS | INTEGER | No |
The number of coinsurance days that were listed on a UB92 claim for the hospital account. This is a user-entered value that overrides the value calculated by the system. Refer to AP_CLAIM table if not set on the hospital account.
73 | UB92_COVERED_DAYS | INTEGER | No |
The number of covered days that were listed on a UB92 claim for the hospital account. This is a user-entered value that overrides the value calculated by the system. Refer to AP_CLAIM table if not set on the hospital account.
74 | UB92_LIFETIME_DAYS | INTEGER | No |
The number of lifetime reserve days that were listed on a UB92 claim for the hospital account. Refer to AP_CLAIM table if not set on the hospital account.
75 | UB92_NONCOVRD_DAYS | INTEGER | No |
The number of noncovered days that were listed on a UB92 claim for the hospital account. This is a user-entered value that overrides the value calculated by the system. Refer to AP_CLAIM table if not set on the hospital account.
76 | UB92_TOB_OVERRIDE | VARCHAR | No |
Note: This column will be deprecated in a future release. Please start referring to the column HSP_ACCT_CLAIM_HAR.UB92_TOB_OVERRIDE in your reports. Type of Bill (TOB) override: TOB is a numeric code printed on claims that provide encounter information to a payer. Values entered here will override system settings that normally determine the Type of Bill. Refer to CLAIM_INFO2 table if not set on the hospital account.
77 | UNDISTRB_BUCKET_ID | NUMERIC | No |
This column stores the unique identifier for a hospital account's undistributed bucket.
78 | PATIENT_STATUS_C_NAME | VARCHAR | No |
The patient status (discharge disposition) category ID for the hospital account.
The category values for this column were already listed for column: ER_PAT_STS_HA_C_NAME
79 | ADMISSION_SOURCE_C_NAME | VARCHAR | No |
The point of origin category ID (admission source) for the hospital account.
May contain organization-specific values: Yes
80 | ADMISSION_TYPE_C_NAME | VARCHAR | No |
The admission type category ID for the hospital account.
May contain organization-specific values: Yes
81 | PRIMARY_PAYOR_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
82 | PRIMARY_PLAN_ID_BENEFIT_PLAN_NAME | VARCHAR | No |
The name of the benefit plan record.
83 | NUM_OF_CHARGES | INTEGER | No |
The total number of charge transactions posted to the hospital account. This number may include inactive charges, such as reversals and reversed charges.
84 | SIGN_ON_FILE_C_NAME | VARCHAR | No |
The category ID indicating whether a hospital account signature is on file. This is an abstracting item.
May contain organization-specific values: Yes
Category Entries:
Yes
No
Appropriate Release of Information on File
Informed Consent to Release Information
Provider has Limited Ability to Release Data
On file at Payor or Plan Sponsor
85 | SIGN_ON_FILE_DATE | DATETIME | No |
The date the signature on file was entered for the hospital account. This is an abstracting item.
86 | PRIM_CONTACT_OVRD | VARCHAR | No |
The value for the primary contact override associated with the hospital account.
87 | CODING_STATUS_C_NAME | VARCHAR | No |
The coding status category ID for the hospital account.
May contain organization-specific values: Yes
Category Entries:
Not Started
In Progress
Waiting
Completed
Ready To Start
On Hold
88 | CODING_STS_USER_ID | VARCHAR | No |
This column stores the unique identifier for the user when the coding status for the hospital account last changed.
89 | CODING_STS_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
90 | CODING_DATETIME | DATETIME (Local) | No |
The date and time that the coding status for the hospital account was last changed.
91 | ABSTRACT_USER_ID | VARCHAR | No |
This column stores the unique identifier for the user who last changed the abstracting status of the hospital account.
92 | ABSTRACT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
93 | OLD_RECUR_PRNT_ID | NUMERIC | No |
This column stores the unique identifier for the parent recurring account before combine.
94 | CASE_MIX_GRP_CODE | VARCHAR | No |
The case-mix group code associated with the hospital account.
95 | LAST_CMG_CODE | VARCHAR | No |
The CMG code from the last CPT merge.
96 | LAST_INT_CVG_ID | NUMERIC | No |
This column stores the unique identifier for the last interim coverage associated with the hospital account.
97 | BIRTH_WEIGHT | NUMERIC | No |
The birth weight of the newborn associated with the hospital account. This is an abstracting item.
98 | GESTATIONAL_AGE | VARCHAR | No |
On the mother's hospital account, the gestational age of the baby. This is an abstracting item.
99 | DISCHARGE_WEIGHT | NUMERIC | No |
The discharge weight of the newborn associated with the hospital account. This is an abstracting item.
100 | ORGAN_DONOR_YN | VARCHAR | No |
Indicates whether the patient associated with hospital account is an organ donor. This is an abstracting item.
The category values for this column were already listed for column: AUTOPSY_DONE_YN
101 | PREMATURE_BABY_YN | VARCHAR | No |
Indicates whether the baby associated with the hospital account is premature. This is an abstracting item.
The category values for this column were already listed for column: AUTOPSY_DONE_YN
102 | CODER_INITIALS | VARCHAR | No |
The initials of the user to last change the coding status on the hospital account.
103 | ADMIT_CATEGORY_C_NAME | VARCHAR | No |
This column stores the admission category ID for this hospital account. See column ADMIT_CATEGORY_C in table PAT_ENC_HSP if coding has not been performed on this hospital account. Alternatively, see V_ARHB_HSP_ACCOUNT_ADDL_INFO for the calculated value for this column based on both hospital account and encounter data. This view should be used to maintain backwards compatibility with reports created before upgrading to the Summer 2009 release.
May contain organization-specific values: Yes
104 | FIRST_BILLED_DATE | DATETIME | No |
This column stores the date when the account moved to the billed state for the first time.
105 | LAST_CODING_DATE | DATETIME | No |
The date of the last coding status change for the hospital account. This is an abstracting item.
106 | EXP_TOTAL_CHG_AMT | NUMERIC | No |
The expected total charge amount for the hospital account.
107 | EXP_TOTAL_CHG_CMT | VARCHAR | No |
The expected total charge user comment for the hospital account.
108 | EXP_PAT_LIAB_CMT | VARCHAR | No |
The expected patient liability user comment for the hospital account.
109 | BILL_DRG_IDTYPE_ID | NUMERIC | No |
This column stores the unique identifier for the billing DRG code set on the hospital account.
110 | BILL_DRG_IDTYPE_ID_ID_TYPE_NAME | VARCHAR | No |
The name of the ID Type.
111 | BILL_DRG_MDC_VAL | VARCHAR | No |
The Major Diagnostic Category value for the billing DRG on the hospital account.
112 | BILL_DRG_WEIGHT | VARCHAR | No |
The weight for the billing DRG on the hospital account.
113 | BILL_DRG_PS_NAME | VARCHAR | No |
The severity of illness (SOI) category ID associated with the billing DRG on the hospital account.
May contain organization-specific values: No
Category Entries:
Refinement not possible
Minor
Moderate
Major
Extreme
Principal Dx Used for SOI/ROM Calc
Excluded
Duplicate Diagnosis
Excluded Complication of Care
114 | BILL_DRG_ROM_NAME | VARCHAR | No |
The risk of mortality category ID associated with the billing DRG on the hospital account.
The category values for this column were already listed for column: BILL_DRG_PS_NAME
115 | BILL_DRG_SHORT_LOS | VARCHAR | No |
The short length of stay for the billing DRG on the hospital account.
116 | BILL_DRG_LONG_LOS | VARCHAR | No |
The long length of stay for the billing DRG on the hospital account.
117 | BILL_DRG_AMLOS | VARCHAR | No |
The arithmetic mean length of stay for the billing DRG on the hospital account.
118 | BILL_DRG_GMLOS | VARCHAR | No |
The geometric mean length of stay for the billing DRG on the hospital account.
119 | BASE_INV_NUM | VARCHAR | No |
The base invoice number for this row.
120 | INV_NUM_SEQ_CTR | INTEGER | No |
The invoice number sequence counter for the hospital account.
121 | RESEARCH_ID_RESEARCH_STUDY_NAME | VARCHAR | No |
The name of the research study record.
122 | SPECIALTY_SVC_C_NAME | VARCHAR | No |
The specialty service category ID associated with the hospital account. This is an abstracting item.
May contain organization-specific values: Yes
123 | XFER_TO_NURSE_C_NAME | VARCHAR | No |
The category value of the transfer to nursing home item for the hospital account. This is an abstracting item.
May contain organization-specific values: Yes
No Entries Defined
124 | XFER_TO_ACUTE_C_NAME | VARCHAR | No |
The category value of the transfer to acute care facility item for the hospital account. This is an abstracting item.
May contain organization-specific values: Yes
125 | DEATH_TYPE_C_NAME | VARCHAR | No |
The type of death category ID for the hospital account. This is an abstracting item.
May contain organization-specific values: Yes
126 | APGAR_1_MIN | INTEGER | No |
The Apgar score at one minute for the newborn associated with the hospital account. This is an abstracting item.
127 | APGAR_5_MIN | INTEGER | No |
The Apgar score at five minutes for the newborn associated with the hospital account. This is an abstracting item.
128 | GRAVIDA | INTEGER | No |
The total number of pregnancies the patient on the hospital account has had, regardless of whether they were carried to term. This is an abstracting item.
129 | PARA | INTEGER | No |
The number of pregnancies that the patient on the hospital account has carried until the point where the fetus is viable. This is an abstracting item.
130 | BIRTH_CERT_SENT_YN | VARCHAR | No |
Indicates whether a birth certificate has been sent for this account. A null value for this column indicates that a birth certificate has not been sent. This is an abstracting item.
The category values for this column were already listed for column: CVG_LIST_SELECT_YN
131 | FAILED_VBAC_YN | VARCHAR | No |
Indicates whether a vaginal birth after caesarian failed. This is an abstracting item.
The category values for this column were already listed for column: CVG_LIST_SELECT_YN
132 | DELIVERY_DATE_TIME | DATETIME (Local) | No |
The date and time of the delivery associated with the hospital account. This is an abstracting item.
133 | PRENATAL_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.
134 | DELIVER_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.
135 | HOLD_STATUS_C_NAME | VARCHAR | No |
The coding hold status category ID for the hospital account. This is an abstracting item.
May contain organization-specific values: Yes
No Entries Defined
136 | GEST_AGE_BABY | INTEGER | No |
The gestational age of the baby associated with the hospital account. This is an abstracting item.
137 | ACCT_FOLLOWUP_DT | DATETIME | No |
This column stores the self-pay follow-up date associated with this hospital account.