| Data element |
Definition |
| Snap_Id Indexed - yes
Format - Number
May be Null? N | Unique identifier of the StarRez Housing database snapshot. |
| Snapshot_Date Indexed - no
Format - Date
May be Null? N | Actual Datetime the snapshot was taken. Time will be slightly different from the SNAPSHOT_PERIOD_END. |
| Snapshot_Desc Indexed - no
Format - Varchar2(400)
May be Null? N | Description /purpose of the snapshot.
eg) "Weekly snapshot - Friday@11PM" |
| Snapshot_Job Indexed - no
Format - Varchar2(200)
May be Null? Y | Job used to create the snapshot. eg) "RD03100J" |
| Snapshot_Period_End Indexed - no
Format - Date
May be Null? Y | Latest datetime in the range covered by this snapshot. For example, assuimng a weekly snapshot taken on a Friday end-of-day (May 8), the end date is Friday (May 8).
NOTE: Time is set to 11:59.59 PM, regardless of the actual time the snapshot was generated, for reporting purposes. |
| Snapshot_Period_Start Indexed - no
Format - Date
May be Null? Y | Earliest date in the range covered by this snapshot. For example, assuimng a weekly snapshot taken on a Friday end-of-day (May 8), the start date is previous Saturday. (May 2). |
