Object Description
One record per calendar date between January 1, 1901 and December 31, 2050.
Metadata
- Table Name: ursa.mi_ursa_core_100
- Layer: METADATA_AND_INTEGRATION
- Object Type: Ursa Reference
- Temporal Class: Event
- Case ID: Reference Date
- Event Date: Reference Date
- Primary Key: Reference Date
Published Fields
-
Data Model Keys
- Reference Date
- Date ID
- Source ID -- The identifier for the original source data system from which the current record originated.
-
Metadata Fields
- Day of Month Integer
- Month Integer
- Year Integer
- Date Text YYYYMMDD
- Date Text MMDD
- Date Text YYYYMM
- Is Month Start
- Is Quarter Start
- Is Year Start
- Month Description
- Days in This Month
- Month Start Date -- The start date (e.g., January 1, February 1, etc.) of the month in the patient's life described by the current record.
- Next Month Start Date
- Day Description
- Day of Week Integer 1 Sunday
- Is Weekday
- Week of Year Integer
- Is Leap Year
- Source Data Effective Datetime -- The "as of" date and time of the original source data system at the moment the current record was extracted. For example, if a snapshot of the data in a production system is taken at 12:05 AM on the first of each month and used to generate a package of flat files that are eventually loaded into the Ursa Studio client database later that month, the Source Data Effective Datetime of all records in that month's package will be 12:05 AM on the first. Not to be confused with Record Last Updated Datetime. (See also [URSA-CORE] Record Last Updated Datetime)