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