Table: dbo.Semimonthly_Period
This table contains the semimonthly period descriptions.
Columns
NameTypeConstraintsDescription
semimonthly_period_KEYtinyint (1)NOT NULLPrimary (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).
descriptionnvarchar (44)NOT NULLThe text to dislay in the form period selection UI.
Primary key
NameColumnsDescription
PK_Semimonthly_Periodsemimonthly_period_KEY

Schema diagram