| Table: dbo.Semimonthly_Period | |||
| This table contains the semimonthly period descriptions. | |||
| Columns | |||
| Name | Type | Constraints | Description |
| semimonthly_period_KEY | tinyint (1) | NOT NULL | Primary (natural) key is the one-based index of the semimontly period within the calendar year (first half of Jan is 1, last half of Dec is 24). |
| description | nvarchar (44) | NOT NULL | The text to dislay in the form period selection UI. |
| Primary key | |||
| Name | Columns | Description | |
| PK_Semimonthly_Period | semimonthly_period_KEY | ||