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 |