ContractStatus_CODE Table

ContractStatus CODE is a dimension table storing contract status information.

Table 1. Database columns for ContractStatus_CODE table

Database Column

Details

ContractStatusID

Type: integer. Key

A unique identifier for Contract status. Possible values and the corresponding default strings are:

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

Type: text (max 1000 characters)

Compliance status of the license in English.

ContractStatus_de

Type: text (max 1000 characters)

Compliance status of the license in German.

ContractStatus_fr

Type: text (max 1000 characters)

Compliance status of the license in French.

ContractStatus_ja

Type: text (max 1000 characters)

Compliance status of the license in Japanese.

ContractStatus_es

Type: text (max 1000 characters)

Compliance status of the license in Spanish.