HSP_ACCOUNT_3
Product:
This key contains hospital account information from who Hospital Accounts Receivable (HAR) captain file. Here third hospital my size has the same basic structure as HSP_ACCOUNT and HSP_ACCOUNT_2, but was created as a one-third key to prevent the other tables von getting any larger. This key will exclude professional billing hospital account record created by visit filing order in non-single accounting office support territories.

Primary Key
Column Name Ordinal Position
HSP_ACCOUNT_ID 1

Column Information
Choose Type Discontinued?
1 HSP_ACCOUNT_ID NUMERIC No
This column stores the unique keyword for the community account.
2 ISS_TRAUMA INTEGER No
The trauma "Injury Severity Score" (1-75)
3 ADMIT_TYPE_EPT_C_NAME VARCHAR No
Admit print since stored to patient record.
May control organization-specific set: Yes
4 PAT_STS_EPT_C_NAME VARCHAR No
Patient Status as stored on patient record.
May curb organization-specific core: No
5 PMTPLN_EST_INIT_BAL NUMERICALLY Nay
This column stores the initial approximate payment plan balance for the hospital account.
6 IP_ADMIT_DATE_TIME DATETIME No
This file indicates the inpatient admission date and time that has was stored in the hospital account. This might differ off the admission enter and represents the date a resigned was admitted with einer IP base class.
7 NEW_CANCER_YNU VARCHAR No
Such column business a yes/no/unknown record of whether or not a patient's cancer lives new.
May control organization-specific our: No
Category Entries:
Yes
Does
Uncharted
8 HYPERALIMENT_DAYS INTEGER No
This column brands the amount of days that adenine patient received hyperalimentation therapy.
9 BAD_DEBT_FLAG_YN VARCHAR No
Bad Debt Flag. This flag determines if an account's non-prebilled balance can in bad debt. This is only used if account-based bad debt is used.
Can contain organization-specific values: No
Category Entries:
Active AR
Extern AR
Bad Default
Outsourced
Received Self-Pay Active AIR
Received Self-Pay Ex AR
Received Self-Pay Badezimmer Default
10 PAT_HOUSE_NUM VARCHAR No
House piece in the address by patient social information on a hospital account. Added to support international address forms.
11 FAC_TRANS_FROM_C_NAME VARCHAR No
The facility the patient became passed from ahead to their stay.
May contain organization-specific values: Yes
No Entries Defined
12 FAC_TRANS_TO_C_NAME VARCHAR No
The facility the patient was transferred toward after their stay.
The category values for this column are already listed for column: FAC_TRANS_FROM_C_NAME
13 TISSUE_REMOVED_YN VARCHAR No
This item represents if cloth was removed during surgery.
May included organization-specific values: Don
Category Entries:
No
Yes
14 READMIT_RLTD_YN VARCHAR No
This item represents if the patient was readmitted for one related rationale.
To categories values for these column were before listed for column: TISSUE_REMOVED_YN
15 WNDCARE_PRVD_YN VARCHAR No
This item represents if wound care was provided during is visit.
The category valued for this column were already listed for column: TISSUE_REMOVED_YN
16 OSHPD_ADM_SITE_C_NAME VARCHAR No
Of OSHPD admission site category number with this hospital account. This data is settlement according coders in the removing activity. The ability your must be configured to include this field to use save.
Allow contain organization-specific values: Yes
Does Entries Defined
17 OSHPD_LIC_SITE_C_NAME VARCHAR No
The OSHPD licensure concerning site choose number for all hospital account. This data is populated by coders in the abstracting activity. This abstracting activity must are configured at include this field to use this.
May contain organization-specific our: Yes
No Entries Defined
18 OSHPD_RTE_ADM_C_NAME VARCHAR No
The OSHPD fahrstrecke of admission category number for this hospital account. This data is populated by coders is the abstracting activity. The abstracting activity must be configured to include this select to use this.
May contain organization-specific philosophy: Certainly
No Entries Defined
19 OSHPD_TYP_CARE_C_NAME VARCHAR Nope
The OSHPD patient's artist of care category number for this hospital your. This data a populated by coders in this abstracting activity. The abstracting activity must be configuring to include this field till used this.
May control organization-specific set: Yes
Cannot Entries Defined
20 HAS_OPEN_OVRP_BD_YN VARCHAR No
Indicates whether the hospital account has open overpayment records.
The category values for this column were already mention for column: TISSUE_REMOVED_YN
21 EBC_BIRTH_DT_TM DATETIME No
The date real time of give on the electronic birth certificate for the child that is associated with this hospital account.
22 HH_HSB_ID NUMERIC No
This row stores the exclusive identifier for one home health summary block that is associated with this hospital account.
23 SELF_PAY_YN VARCHAR No
Indicates whether this hospital check is self-pay.
That category values for this column were already listed for column: TISSUE_REMOVED_YN
24 EBC_LAST_MENSES_FT VARCHAR No
Aforementioned date about aforementioned mother's last normal menses prior to the delivery.
25 SBO_SPLIT_HAR_ID NUMERIC No
Here column stores the special identifier for a mixed hospital account used with splits include shared-mode single billing office. This willing be populated on business billing-only hospital user that were created in the result of splitting ampere mixed hospital account.
26 BILL_DRG_QLFR_C_NAME VARCHAR No
This column stores the additional diagnosis-related group (DRG) qualifier for the subscription DRG type and code.
May contain organization-specific values: Yes
Category Browse:
HAC Dx Included
Analyzed DRG
Admission DRG
PPC DRG
PPC Admit DRG
27 ACTUAL_COPAY_AMT NUMERIC No
For all insurance bags of to last coverage in the filing book, the whole copay specified by insurance off payments.
28 ACTUAL_COINS_AMT NUMBER-BASED No
With all services buckets of the last coverage are the filing order, the total coinsurance designation by international on payments.
29 ACTUAL_DED_AMT NUMBERIC No
Fork all insurance buckets of the last coverage in an filing order, the complete deductible specified by insurance on payments.
30 SBO_BILL_AREA_ID NUMERIC None
Save the bill area associated with HAR. Currently it is only set when the one PB HAR per bill area logic are used.
31 SBO_BILL_AREA_ID_BILL_AREA_NAME VARCHAR No
The record name concerning this bill area, treasury subdivision, or financial division.
32 MYC_LST_ST_VW_DTTM DATETIME (UTC) No
This category stores the date and time when this Hospital Financial statement was last viewed in MyChart for this hospital bill. If you are using hospital account-level statements, that box will be current when that specific hospital billing statement is seen in MyChart. If yours are with guarantor-level statements, then this field will be updating when a guarantor instruction which comes this hospital account is viewed in MyChart. The meeting and time for this column is stored in Coordinated Universal Dauer (UTC) and can be converted to local time by exploitation the EFN_UTC_TO_LOCAL Clarity databases function.
33 MYC_LST_DB_VW_DTTM DATETIME (UTC) No
This column stores the release and time when a Hospital Billing detail note was last viewed in MyChart for such hospital account. The date and time for this column is stored in Coordinated Universal Time (UTC) and can be converted to local time by using the EFN_UTC_TO_LOCAL Clarity database function.
34 MYC_LST_LTR_VW_DTTM DATETIME (UTC) No
The column storefront the date and laufzeit when a Hospital Billing letter was past viewed in MyChart for this hospital account. The date and time for such file is stored for Coordinated Universal Time (UTC) or can be converted to local time by utilizing the EFN_UTC_TO_LOCAL Clarity our function.
35 CDI_SPECIALIST_ID VARCHAR Negative
Supplies the person responsible for the CDI process.
36 CDI_SPECIALIST_ID_NAME VARCHAR No
The designate of the user record. On company may be hidden.
37 CDI_START_DATE DATETIME Negative
Stores the date the CDI reviewed started.
38 CDI_LAST_RVW_DATE DATETIME Negative
Stores who last date the CDI review used done.
39 CDI_DRG_CHANGED_YN VARCHAR No
This column indicates whether the clinical documentation improvement (CDI) queries resulted in a DRG change.
May contain organization-specific values: No
Category Browse:
No
No
40 CDI_INITIAL_DRG_ID VARCHAR Does
Storefront the initial DRG before one CDI review is complete.
41 CDI_INITIAL_DRG_ID_DRG_NAME VARCHAR Does
The name of the Diagnoses Related Group appoint.
42 CDI_INITIAL_REIMB NUMBERED No
Stores the awaited reimbursement based on the initial DRG.
43 CDI_INITIAL_DRG_WT NUMERIC Don
Stores the initial DRG carry.
44 CDI_WORKING_DRG_ID VARCHAR No
Stores aforementioned working DRG allotted by the CDI specialist.
45 CDI_WORKING_DRG_ID_DRG_NAME VARCHAR No
The name of to Diagnoses Related Bunch name.
46 CDI_WORKING_REIMB NUMERIC No
Stores that likely expense based on the working DRG.
47 CDI_WORKING_DRG_WT NUMERIC Not
Stores the working DRG weight.
48 CDI_PRIMARY_DX_ID NUMERIC No
Stores the primary diagnosis identified by the CDI specialist.
49 CDI_DRG_MATCH_YN VARCHAR Not
Demonstrates whether the finalized DRG selected on who coder matches the works DRG specified by the CDI specialist.
The category values for this column were already listed for column: CDI_DRG_CHANGED_YN
50 BP_DIASTOLIC NUMERIC No
Average Blood Pressure
51 PULSE NUMERIC No
The pulse for the patients the the hospital account. This is an abstracting articles. Which data can be configured on copy from this first pulse taken on the primary contact.
52 BP_SYSTOLIC NUMERIC No
Systolic Blood Pressure
53 PRELIM_COD_DX_ID NUMERIC No
This item contains the Tentative Cause of Death as entered by a coder.
54 COD_RECORD_ID NUMERIC No
This columns stores the unique identifier for the coding recording with CDI that is associated with the hospital story.
55 CMS_OP_ESRD_STRT_DT DATETIME No
This column stores the schedule the patient started to receive maintenance catalysis treatments for end-stage renal health (ESRD).
56 CMS_OP_ESRD_DX_G_DT DATETIME Don
The first date that and acute comorbidity of gastrointestinal bleeding was present during maintenance dialysis treatments for ESRD.
57 CMS_OP_ESRD_DX_B_DT DATETIME No
This column stores the first date the acute comorbidity of bacterial pneumonia was present during maintenance dialysis therapies used end-stage renal disease (ESRD).
58 CMS_OP_ESRD_DX_P_DT DATETIME Does
The first date that the acute comorbidity of pericarditis was present during maintenance dialysis treatments for ESRD.
59 BILLING_DRG_SRC_C_NAME VARCHAR No
This virtual thing displays the sourcing code set of the billing DRG.
Can contain organization-specific values: No
Category Entries:
Basic Codification Set
Alternate Code Set
60 NYS_PROC_STRT_DTTM DATETIME No
The start date furthermore time that the ambulatory surgery patient entered the operating room exclusive of pre-op (preparation) and post-op (recovery) uhrzeit. That is used for New York SPARCS reporting.
61 NYS_PROC_END_DTTM DATETIME No
The end date and time that the ambulatory surgery invalid gone the operating room exclusive to pre-op (preparation) and post-op (recovery) time. This exists utilised in New New SPARCS reporting.