DayPart (ver7.2.2)
These are parts of a day (for example, "AM" or "PM") that can be used for period-to-day part and time-to-day part attendance conversions.
Column Name | Initial Version | Data Type | Description |
---|---|---|---|
Description | 7.2.2 | Varchar(256) | Description for the day part, if necessary. |
ID | 7.2.2 | Number(10,0) | Unique identifier, preferably a sequential number. Normally this column is not generated automatically, but rather inserted as part of state-specific report schema updates. Indexed. |
IsEnabled | 7.2.2 | Number(3,0) | If 1, row is enabled. Can be used to disable day parts used in past years but no longer are. |
IsValidDayPart | 7.2.2 | Number(3,0) | If 1, row is a valid day part. Because the tables that update day parts are legacy tables, and the code that typically accesses that cannot write null for an empty value, but rather writes 0, one or more non-valid day part entries may be required. |
Name | 7.2.2 | CVarchar(40) | Name for the day part as displayed in the user interface and reports. |
WhenCreated | 7.2.2 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 7.2.2 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 7.2.2 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 7.2.2 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |