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