HSP_ACCT_CLAIM_HAR
Description:
This table contains hospital account claims information extracted from hospital account records.

Primary Key
Column Name Ordinal Position
ACCT_ID 1

Column Information
Name Type Discontinued?
1 ACCT_ID NUMERIC No
This column stores the unique identifier for the hospital account.
2 UB92_COVEREDDAYS INTEGER No
This column stores the UB92 Covered days (inpatient only): the number of days covered by the primary payer, as qualified by the payer organization.
3 UB92_NONCOVEREDDAY INTEGER No
This column stores the UB92 Non Covered days (inpatient only): the number of days not covered by the primary payer, as qualified by the payer organization.
4 UB92_COINSDAYS INTEGER No
This column stores the UB92 Coinsurance days: Days covered by secondary coverage in addition to primary coverage.
5 UB92_RESERVEDAYS INTEGER No
UB92 Lifetime Reserve Days (INPATIENT ONLY): Each beneficiary has a lifetime reserve of 60 additional days after using 90 days of inpatient hospital services during a spell of illness. Lifetime reserve days are not renewable.
6 ADMISSION_TYPE_C_NAME VARCHAR No
The admission type category ID for the hospital account.
May contain organization-specific values: Yes
7 ADMISSION_SOURCE_C_NAME VARCHAR No
The admission source (e.g., Physician Referral, Transfer from a Hospital, Information Not Available) for the patient encounter associated with this hospital account.
May contain organization-specific values: Yes
8 UB92_TOB_OVERRIDE VARCHAR No
This column stores the 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 TOB.
9 AUTHORIZATION_NUM VARCHAR No
Authorization Number: Used on claims for identifying patient referrals and affected reimbursements.
10 PARTA_EXHAUST_DT DATETIME No
The date on which the patient's Part A benefits are exhausted for this inpatient stay. Part A benefits cover up to 90 inpatient days per stay (plus any lifetime reserve days the patient may opt to use after the 90th day). After these days have been used, Part A claims will be denied. Inpatient Part B claims may be submitted for appropriate services.
11 PATIENT_STATUS_C_NAME VARCHAR No
The patient status for the patient associated with this hospital account (e.g., Alive, Dead, Unknown, Discharged to Home or Self Care, Admitted as an Inpatient to this Hospital).
May contain organization-specific values: Yes
12 SHAREABLE_CLAIM_ID NUMERIC No
This column stores the unique identifier for a shareable claim associated with the hospital account.
13 NONCVRD_SNF_STAY_YN VARCHAR No
This item indicates whether the Skilled Nursing Facility (SNF) stay billed on this account is non-covered due to not having a prior qualifying inpatient stay.
May contain organization-specific values: No
Category Entries:
No
Yes