PeriodType Table

PeriodType is a static table holding a collection of supported time periods to indicate the frequency of license charge-backs.

Table 1. Database columns for PeriodType table

Database Column

Details

PeriodTypeID

Type: integer. Key. Generated ID

A unique identifier for each PeriodType. Possible values and the corresponding default strings are:

  • 1 = None
  • 2 = Weekly
  • 3 = Monthly
  • 4 = Quarterly
  • 5 = Yearly
  • 6 = Lump Sum.
PeriodTypeResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing a period type. Foreign key to the ComplianceResourceString table.

PeriodTypeDefaultValue

Type: text (max 100 characters)

The text to display if the type resource string has no translation.