...
The Business Dates table contains the following fields.
Options | Description |
|---|---|
Effective_date | Specifies a date to use as the As Of date when you build the Business Dates table, either alone or within a build of other tables. This date may or may not be a valid business date according to the business calendar in use as you build data. |
Snapshot_ID | Specifies the ID of a Data Mart snapshot used when you build the Business Dates table. This may be the DEFAULT snapshot if you did not choose a snapshot that you set up for special purposes. Every snapshot is associated with a business calendar that tells where the business dates information comes from in the Eagle Business Calendar table associated with the snapshot in use. The DEFAULT snapshot is linked to the EAGLE PACE™ business calendar (source interface instance = 4). Different snapshots may share the same business calendar source without restriction. |
Day_flag | A value of 1 if the effective_date is a business date for the associated business calendar. Otherwise, the value is 0. |
Month_end_flag | A value of 1 if the effective_date is a monthend date for the associated business calendar, else 0. |
Quarter_end_flag | A value of 1 if the effective_date is a quarter-end date for the associated business calendar, else 0. |
Year_end_flag | A value of 1 if the effective_date is a yearend date for the associated business calendar, else 0. |
Week_end_flag | A value of 1 if the effective_date is a weekend date for the associated business calendar. Otherwise, the value is 0. |
...