|
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 |
|
|
|
|
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 |
|
|
|
|
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. |
|
|