DIM_HOUR
Description
Columns
| # | Name | Data Type | Length |
|---|---|---|---|
| 1 | HOUR_KEY | INTEGER | 4 |
| 2 | HOUR_CODE | INTEGER | 4 |
| 3 | TWELVE_HOUR_CLOCK_HOUR_NUMBER | INTEGER | 4 |
| 4 | TWELVE_HOUR_CLOCK_HOUR_LABEL | CHARACTER VARYING(9) | 9 |
| 5 | TWELVE_HOUR_CLOCK_TIME_PERIOD_LABEL | CHARACTER VARYING(9) | 9 |
| 6 | TWENTY_FOUR_HOUR_CLOCK_HOUR_NUMBER | INTEGER | 4 |
| 7 | TWENTY_FOUR_HOUR_CLOCK_HOUR_LABEL | CHARACTER VARYING(9) | 9 |
| 8 | TWENTY_FOUR_HOUR_CLOCK_PADDED_HOUR_LABEL | CHARACTER VARYING(9) | 9 |