bSDD Units - Time, Duration vs. Calendar

Users bSDD
1

I am attempting to create a DD for a schema based on Occupant Behavior Modeling (OBM - obXML). As part of this, there are a number of obXML properties which indicate time as:

  • calendar time of day (hour/minute/second)
  • time of day (Morning, Noon, Afternoon, Evening, Day, Night, All)
  • calendar day of year (year/month/day) month could be named or number
  • named day of the week (Monday, Tuesday, Wednesday, etc.)
  • numbered day of the week (0/7, 1, 2, 3, etc.)
  • time as duration (seconds, minutes, hours, days, weeks, months, years)
  • season (Spring, Summer, Fall, Winter, All)
  • frequency (hourly, daily, weekly, monthly, yearly, etc.)

What I can’t easily figure out is how to differentiate these in the bSDD, if I can at all, as I fill out the bSDD template Excel workbook and sheets.

Right now, I only see differentiation for “mo” = “julian month” and “Month” = “Month”.

Is that it?
What to do?

2

bSDD has a dedicated data type “Time”, as explained in the docs.

It follows this formatYYYY-MM-DDThh:mm:ssTZD so it accepts both 2023-05-10 and 2023-05-10T15:10:12+02:00. More here.

  • calendar time of day (hour/minute/second)
  • calendar day of year (year/month/day) month could be named or number

I would use Time datatype value for capturing those, as explained above.

  • numbered day of the week (0/7, 1, 2, 3, etc.)
  • time as duration (seconds, minutes, hours, days, weeks, months, years)

Those look like numeric values.

  • time of day (Morning, Noon, Afternoon, Evening, Day, Night, All)
  • named day of the week (Monday, Tuesday, Wednesday, etc.)
  • season (Spring, Summer, Fall, Winter, All)
  • frequency (hourly, daily, weekly, monthly, yearly, etc.)

Those are String values, and you can enumerate list of allowed values (“morning”, “noon”…).