HSP_ACCOUNT
Description:
This table contains hospital account information from the Hospital Account (HAR) and Claim (CLM) master files. It will exclude professional billing hospital accounts created by visit filing order in non-single billing office 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 Service Area
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 this data is not stored on the hospital account yet, then this will pull the data from the primary patient encounter for the hospital account. Depending on a hospital billing system definition setting, this will pull either the admission date and time (I EPT 18850/18851) or the arrival date and time (I EPT 10820/10815). If the arrival date and time is not available than the admission date and time will be used.
9 ADM_DEPARMENT_ID NUMERIC No
The department of the account's admission event.
10 ADM_LOC_ID NUMERIC No
The location of the account's admission event.
11 ADM_PRIORITY VARCHAR No
The admission priority stored in the hospital account.
12 ADM_PROV_ID VARCHAR No
This column stores the unique identifier for the admitting provider stored on the hospital account.
13 ATTENDING_PROV_ID VARCHAR No
This column stores the unique identifier for the attending provider stored on the hospital account. See column PROV_ID in table HSP_ATND_PROV 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.
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 this data is not stored on the hospital account yet, then this will pull the discharge date and time (I EPT 18855/18856) that is stored on the primary patient encounter for the hospital account.
26 DISCH_DEPT_ID NUMERIC No
This column stores the unique identifier for the discharge department on the hospital account.
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 NUMERIC No
The discharge location stored in the hospital account.
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 NUMERIC No
The expiration unit stored in the hospital account.
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 NUMERIC No
This column stores the unique identifier for the service area stored on the hospital account.
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 NUMERIC No
This column stores the unique identifier for the primary payer associated with the hospital account.
82 PRIMARY_PLAN_ID NUMERIC No
This column stores the unique identifier for the primary benefit plan associated with the hospital account.
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 VARCHAR No
This column stores the unique identifier for the research study or client 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 VARCHAR No
This column stores the unique identifier for the prenatal physician. This is an abstracting item.
134 DELIVER_PROV_ID VARCHAR No
This column stores the unique identifier for the delivering physician associated with the hospital account. This is an abstracting item.
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.