EDD data is managed as a related data group in Connect Care (Epic), with some elements stored as arrays (e.g., review dates, EDD values) of all entries and revisions. Data is attached at the intersect of patient and encounter. 

Primary Data Elements

• EDD Date: EPT 10303 - DATE - currently visible EDD for the inpatient encounter

  • SQL Column Title: EXP_DISCHARGE_DATE in table 9828 ADT_VISIT_INFO; enabled for enterprise reporting

• EDD Unknown: EPT 10308 - BINARY CATEGORY - whether "Unknown" button selected in EDD data entry activity (yes/no)

  • Set when EDD is marked as Unknown (button), which simultaneously sets EDD value to null.

  • SQL Column Title: EXP_DIS_UKNWN_C

• EDD Comment: EPT 10445 - ARRAY - Archive of explanatory comments which may be entered within the EDD data entry activity

  • SQL Column Title: HX_EXP_DIS_COMMENT in table 10442-EXPECTED_DISCH_HISTORY

• EDD Date last entered/changed: EPT 10311 - INSTANT

• EDD Time last entered/changed: EPT 10312 - INSTANT

• EDD Date last reviewed: EPT 10446 - INSTANT - when the "Reviewed" button was last selected, independent of any change to EDD

• EDD User: EPT 10313 - ID - Unique identifier of user last editing EDD

Secondary data elements

• EDD History: EPT 10442 - ARRAY - Archive of enter/change events for EPT 10303

• EDD Unknown History: EPT 10454 - ARRAY - Archive of enter/change events for EPT 10308

• EDD Comment History: EPT 10445 - ARRAY - Archive of enter/change events for EPT 

• EDD Date last entered/changed History: EPT 10446 - ARRAY - Archive of instants of EDD enter/change

  • Timestamp added to this array each time when EDD is entered or updated, when Mark as Reviewed button was clicked, or when discharge patient order is entered. 

• EDD User History: EPT 10447 - ARRAY - Unique identifier of user last editing EDD

• EDD Update Source History: EPT 10448 - ARRAY - History of source of EDD change (AHS default = User) 

Related data elements

• Encounter Discharge Date: EPT 87315 - DATE - Encounter Discharge Date

• Actual Discharge Date: EPT 18855 - DATE - Hospital Discharge Date (ADT reviewed)

  • SQL Column Title: HOSP_DISCHRG_DATE

• Pending Discharge Date: EPT 10200 - DATE - date entered in discharge order

• Actual Discharge Time: EPT 18856 - TIME - Time recorded for actual (not planned or ordered) discharge

• ELOS: EPT 10302 - NUMERIC - Entered expected length of stay (populated by EDD - Admission Date; initial default is 3, hidden)

• ELOS Change: EPT 10449 - INSTANT - Instant of entry/change for ELOS value

• ELOS Source: EPT 10314 - CATEGORY - Source and method for calculation of ELOS (AHS default: Expected Discharge Date Update [3])

• ELOS History: EPT 10451 - ARRAY - Archive of values entered or calculated for ELOS (reflects value changes to EDD in AHS configuration)

• ELOS Last Changed History: EPT 10449 - ARRAY - Archive of instants ELOS updated 

• ELOS Source History: EPT 10452 - ARRAY - Archive of calculation method for ELOS (AHS default: Expected Discharge Date Update [3])

• ELOS User History: EPT 10453 - ARRAY - Archive of user identifiers associated with ELOS change

Filter data elements

• Inpatient Class: EPT 10110 - CATEGORY - (= Inpatient)

• Discharge Status: EPT 10115 - CATEGORY - (= Discharged)

• Hospital Admitting Provider: EPT 18867 - CATEGORY

• Hospital Discharging Provider: EPT 18864 - ARRAY - last value in attending series for encounter

• Hospital Speciality Service: EPT 18886 - CATEGORY - (e.g., General Internal Medicine [106])

• Hospital Unit: EPT 18880 - CATEGORY - Inpatient unit/ward (e.g., EDM UAH WMC 5D4 GIM [101094229])

• Hospital Facility: EPT 18883 - CATEGORY - (e.g., EDM WMC University of Alberta Hospital [101094])

• ADT Service Area: EPT 18881 - CATEGORY - (Avoid as this is always going to be "AHS CONNECT CARE SERVICE AREA" in this context

• Level of Care (Patient Status): EPT 10135  - CATEGORY - (= Acute or = ALC - TBD)

• Hospital Admission Date: EPT 18850 - DATE - Date the patient was first admitted to the facility, bedded in the ED, assessed in an L&D unit or confirmed for an HOV, regardless of base patient class. 

• Hospital Admission Time: EPT 18851 - TIME - When the HOV is confirmed, the time is set equal to the Expected Admission Time (EPT 10300). If the Expected Admission Time is blank, the time is set to the time the HOV was confirmed. If the HOV is later converted to an admission, this item will update to the time of conversion. 

• Hospital Admission Instance in Coordinated Universal Time (UTC): This item calculates the hospital admission instance. Based on hospital admission date and time (EPT 18850 / 18851)

• Hospital Admission Order Release Instance: 

Order Last Edit Instant (ORD 750) 

WHERE

Order Type (ORD 30) = Admission [47]

AND

Order Patient CSN (ORD 226) = Patient in denominator

AND

Order Last Editing Action (ORD 760) = Released [6]

• Time of Admission: ADT 59 - INSTANT (not necessarily reflective of clinician admit workflow)

• Hospital Discharge Date: EPT 18855 - DATE

• Hospital Discharge Time: EPT 18856 - TIME

• 3042414702 IP_DISCHARGE_PLANNING_NAVIGATOR

  • Activity Template: ADT DISCHARGE PLANNING NAVIGATOR (ip)

  • Link: EpicACT:ADT_DISCHARGE_PLANNING_NAVIGATOR

• AHS#3520 AHS IP EDD COMMENT Buffer

• AHS#2478 AHS IP EDD Buffer

• AHS#3523 AHS IP EDD DAYS BUFFER

• AHS#3524 AHS IP EDD INTERVAL BUFFER

• AHS#3538 AHS IP EDD REVIEWED BUFFER

• AHS#3539 AHS IP EDD REVIEWED INSTANT BUFFER

• 104358 AHS RAPID ROUNDS DISCHARGE STATUS BY DISCIPLINE HOVER BUBBLE

  • Uses LRP 30445602190001

• 30410435803 AHS RAPID ROUNDS DISCHARGE MILESTONES HOVER BUBBLE

• 3043796304 AHS IP SMARTFORM SET EDD SDE PLUS 0 DAYS

• 3043796305 AHS IP SMARTFORM SET EDD SDE PLUS 1 DAYS

• 3043796306 AHS IP SMARTFORM SET EDD SDE PLUS 2 DAYS

• 3043796302 AHS IP SMARTFORM SET EDD SDE PLUS 4 DAYS

• 3043796307 AHS IP SMARTFORM SET EDD SDE PLUS 9 DAYS

• 3043796308 AHS IP SMARTFORM SET EDD SDE PLUS 15 DAYS

• 3043796309 AHS IP SMARTFORM SET EDD REVIEW SDE PLUS 0 DAYS

• 30410449101 AHS IP SET EDD COMMENT SDE FROM EPT

• 30410449102 AHS IP SET EDD COMMENT EPT FROM SDE

• 30410449111 AHS IP SET EDD REVIEWED EPT FROM SDE

• 30410449103 AHS IP SET EDD DAYS SDE FROM SCORE

• 30410449104 AHS IP SET EDD INTERVAL SDE FROM RULE TODAY

• 330410449105 AHS IP SET EDD INTERVAL SDE FROM RULE TOMORROW

• 30410449106 AHS IP SET EDD INTERVAL SDE FROM RULE < 3 DAYS

• 30410449107 AHS IP SET EDD INTERVAL SDE FROM RULE < 5 DAYS

• 30410449108 AHS IP SET EDD INTERVAL SDE FROM RULE < 10 DAYS

• 30410449109 AHS IP SET EDD INTERVAL SDE FROM RULE  10+  DAYS

• 30410449110 AHS IP SET EDD INTERVAL SDE FROM RULE  PAST

• 3044232003 AHS IP SMARTFORM SET EDD COMMENT LABEL

Patient List Definitions (ERS)

• 3040200001 ++ AHS IP RAPID ROUNDS CORE TEMPLATE++

• 3041100002 ++ AHS IP PED RAPID ROUNDS TEMPLATE++

• 3040211002 ++ AHS IP RAPID ROUNDS TEMPLATE++

• 3040200002 ++ AHS IP RAPID ROUNDS VIRTUAL TEMPLATE++

Column Blocks (FBL)

Columns (PAF)

• 106185 AHS IP RAPID ROUNDS OVERALL DISCHARGE STATUS COLUMN

• 106186 AHS IP RAPID ROUNDS OVERALL DISCHARGE STATUS SCORE CHANGED COLUMN

• 106187 AHS IP RAPID ROUNDS OVERALL DISCHARGE STATUS TIME SINCE REVIEWED COLUMN

• 304234721 AHS IP Length of Stay (LOS)

• 304234722 AHS IP Length of Stay (Days, Hours)

• 304272101 AHS RR Discharge Milestones

• 304348871 AHS IP ADMISSION DATE

Primary

• 3041500003 AHS IP DISCHARGE  READINESS SMARTFORM

Secondary

• 304234556801 MODEL_IP_MD_COMBINED_ADMISSION_TEMPLATE

• 2341100 MODEL_IP_MD_DISCHARGE_TEMPLATE

• 30445792102 AHS IP RAPID ROUNDS TRANSITION PLANNING BUTTONS

• 30445792103 AHS IP RAPID ROUNDS TRANSITION PLANNING

• 103688 AHS IP RAPID ROUNDS OVERALL DISCHARGE STATUS PRINT GROUP

• 30445792101 RAPID ROUNDS REPORT TEXT BLOCK

• 30454121190001 AHS IP RAPID Rounds Discharge Status By Discipline Hover Bubble

• 3048452618 AHS IP SIDEBAR PHYSICIAN TRANSITION PLANNING

• 3044560227 AHS IP RAPID ROUNDS REPORT

• 3044560273 AHS IP MD RAPID ROUNDS REPORT

• 3044560275 AHS IP MD RAPID ROUNDS IP ADT INFO

A number of rules return error comments used in other EDD objects, especially extensions used to set SmartForm button values.

• • 838765 AHS IP EXPECTED DISCHARGE UPDATE STATUS

  • 839412 AHS IP EXPECTED DISCHARGE DATE (EDD) COMMENT

  • 839413 AHS IP EXPECTED DISCHARGE DATE

  • 304000025 AHS IP DAYS TO EDD

  • 839423 AHS IP DAYS TO EDD MESSAGE

  • 809608 AHS IP EXPECTED DISCHARGE NOT SPECIFIED

  • 816182 AHS IP EXPECTED DISCHARGE SPECIFIED

  • 809610 AHS IP EXPECTED DISCHARGE PAST (past)

  • 809607 AHS IP EXPECTED DISCHARGE DATE >4 DAYS

  • 809609 AHS IP EXPECTED DISCHARGE TODAY (today)

  • 839424 AHS IP EXPECTED DISCHARGE TOMORROW

  • 809603 AHS IP EXPECTED DISCHARGE < 3 DAYS (<3 days)

  • 809606 AHS IP EXPECTED DISCHARGE < 5 DAYS (<5 days)

  • 839426 AHS IP EXPECTED DISCHARGE < 10 DAYS (<10 days)

  • 839427 AHS IP EXPECTED DISCHARGE 10+ DAYS (10+ days)

Primary

• 3046029501 AHS IP EXPECTED DISCHARGE DATE (EXPECTEDDCDATEAHS)

  • Retrieves and displays EPT 10303 in "MMM dd, yyyy" format

• 3046029504 AHS IP EXPECTED DISCHARGE COMMENT (EXPECTEDDCCOMMENTAHS)

• 3046029503 AHS IP POC EXPECTED DISCHARGE TIME (EXPECTEDDCTIMEAHS)

  • Retrieves and displays EPT 10304 in "h,m" format

• 3046029509 AHS IP EXPECTED DISCHARGE INTERVAL TEXT BLOCK (EXPECTEDDCBLOCK)

  • SmartLink that pulls SmartText (30428321015 AHS IP EDD AND INTERVAL TEXT BLOCK)

Secondary

• 101842 PATADMDTAHS - Admission date (using EPT 18850)

• 3041609301 AHS IP POC DISCHARGE DATE (PADDSCHDTAHS) - Discharge date (using EPT 18855)

• 304513001 AHS IP ADMITTING PROVIDER (AHSADMITPROVIDER) - Hospital Admitting Attending Provider (using EPT 18867)

• 3042120001 AHS IP DC ATTENDING (AHSDCATTENDING) - Hospital Discharging Attending Provider (using last value of EPT 18864)

• 3044560277 AHS IP RAPID ROUNDS ADT INFO

• 3046029506 AHS IP ORDERED DISCHARGE DATE (ORDEREDDCDATEAHS) - Discharge date (using EPT 10200 ADT PENDING DISCHARGE DATE)

• 3041609302 AHS ED DISCHARGE DATE (PATDSCHDTED)

• 33640 AHS IP POC DC SUPPORTS - selector for level of complexity of transition needs

• 304335043 AHS IP POC PROGRESS NOTE ASSESSMENT OPTIONS - selector that includes option for inserting simple or complex discharge planning blocks (with EDD)

Primary

• 3042832106 AHS IP DAYS TO EDD

  • Displays integer value for number of days remaining to EDD value, or "not specified" if EDD null.

• 30428321015 AHS IP EDD AND INTERVAL TEXT BLOCK

  • Displays EDD together with Rules-based CoACT interval band (e.g., "< 3 days") 

  • Interactive - has hyperlink to EDD editing activity

• 30428321016 AHS IP DAY TO EDD

  • Uses LPP 304105026 to pull in days to EDD as used in patient lists

Secondary

• 3042832101 AHS IP SIDEBAR PHYSICIAN TRANSITION PLANNING

• 3042832105 AHS IP RAPID ROUNDS TRANSITION PLANNING INTERACTIVE

• 3042832107 AHS IP POPUP PHYSICIAN TRANSITION PLANNING

• 3042656725 AHS IP POC TRANSITION PLANNING PROGRESS

• 3042656726 AHS IP POC TRANSITION PLANNING TEAM PROGRESS

• 28321 AHS IP POC CHARTING CONTENT SIDEBAR

• 3042919201 AHS IP BASIC HISTORY & PHYSICAL ADMISSION

• 3042919202 AHS IP HEADINGS HISTORY & PHYSICAL ADMISSION

• 29192 AHS IP BASIC HISTORY & PHYSICAL ADMISSION

• 28696 AHS IP POC TRANSITION NEED - includes EDD

• 26567 AHS IP POC PROGRESS NOTE

• 3042656719 AHS IP ADVANCED PROGRESS NOTE

• 3042656720 AHS IP BASIC PROGRESS NOTE