4 Replies Latest reply: Aug 31, 2015 1:58 PM by Chase Bushey RSS

    Calendar Conundrum

    Chase Bushey

      I am trying to create a singular calendar that the user can select from but my problem is that I have multiple datasources and dates.

       

      Here is how my data model breaks down:

      Table 1:Nurse hours

      ID =LocationID&Year&Month

      Location

      Year

      Month

       

      Table 2: Pt Days

      ID =LocationID&Year&Month

      Location

      Year

      Month

       

      Table 3: Falls

      ID =LocationID&Year&Month

      Location

      Year

      Month

       

      Table 4:Ulcers

      ID =HospitalID&Year&Quarter

      Year

      Quarter

       

      Table 5: Perinatal

      ID HospitalID&Year&Month

      Year

      Month

       

      Table 6: Lactation

      ID =HospitalID&Year&Month

      Year

      Month

       

      Table 7:AbsData

      ID =AbsAccount

      StartDateTime

      EndDateTime

      LocationID

       

      Table 8:CodeBlue

      ID =LocationID&Year&Month&Day

      LocationName

      CodeDate

      CodeTime

       

      Table 9:Incidents

      ID =IncidentID

      LocationName

      EventDate

      EventTime

       

      Link:

      ID1 = LocationID&Year&Month

      ID2 = HospitalID&Year&Quarter

      ID3 = HospitalID&Year&Month

      ID4 = AbsAccount

      ID5 = LocationID&Year&Month&Day

      ID6 = IncidentID

      YearMonth (essentially the year and month of each table’s date field)

       

       

      I then build a master calendar off the year month field but I know I have issues with it because most of my tables only have one date field, but my AbsData table has two thus causing a problem.

       

      Thanks for the help!