ContractStatus Table

ContractStatus is a static table listing all contract status values in the system.

Table 1. Database columns for ContractStatus table

Database Column

Details
ContractStatusID

Type: integer. Key. Generated ID

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

  • 1 = Active
  • 2 = Archived
  • 3 = Draft
  • 4 = Suspended
  • 5 = Cancelled
  • 6 = Expired
  • 7 = Completed.
ResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing a contract status. Foreign key to the ComplianceResourceString table.
DefaultValue

Type: text (max 100 characters)

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