The CDDOMAINVALUETP table contains the values and descriptions for the Value Type Code, which, in a given domain, identifies the values that are captured. For example, within banking, values captured can be "account balance" and "account deposit".
This table is used by the following domain.
|Name||Comment||Datatype||Null Option||Is PK|
|LANG_TP_CD||Identifies a spoken language, such as English, French, Spanish, or German. When used as part of the primary key of a code value lookup table, the Language Type Code also represents the language of the code name.||BIGINT||Not Null||Yes|
|DOMAIN_VALUE_TP_CD||Domain Value Type Code, in a given domain, identifies the specific values that are captured. For example: Integer value, Date value, and so forth.||BIGINT||Not Null||Yes|
|PROD_TP_CD||Identifies the type of product associated with the contract (or at some level within the product family). For example, a manufacturing company might have the product types "precision tools", "switches", "defence", "electronics", and "automotive".||BIGINT||Null||No|
|NAME||A short, meaningful label for the value of the type code.||VARCHAR(120)||Not Null||No|
|DESCRIPTION||Provides extra information either as an additional definition of the type code value or as free form user comments to provide further meaning to the type code.||VARCHAR(255)||Null||No|
|DOMAIN_TP_CD||Defines the types of values can be stored. Examples include Integer, String, Decimal, Date, and so forth.||BIGINT||Not Null||No|
|PRECISION_VALUE||Defines the Value String attribute in the Contract Component Value by identifying the number of digits to be expected for that given Value Type Code.||SMALLINT||Null||No|
|EXPIRY_DT||The date that the type code is no longer valid.||TIMESTAMP||Null||No|
|LAST_UPDATE_DT||When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails.||TIMESTAMP||Not Null||No|