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