CONTRACTCOMPVAL
The CONTRACTCOMPVAL table allows you to model numeric values on the Contract Component, presenting you with a mechanism to extend information associated with a contract component that is only available through back-end systems. Certain contract features such as Balances in accounts, limits, terms and rates are typically what can be modeled using the Value entity. A contract component value has the following characteristics: (i) Allows extending the information that is held within an contract component or contract component row; (ii) Any number of values can be associated with an contract component; (iii) Allow values are defined through Code Tables; (iv) Has a description; (v) Has a specific type; (vi) Has a specific value; (vii) Has a status; (viii) Has a validity period or is indefinite.
Name | Comment | Datatype | Null Option | Is PK |
---|---|---|---|---|
CONTR_COMP_VAL_ID | A unique, system-generated key that identifies a contract component value in the system. | 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, etc. | BIGINT | Not Null | No |
VALUE_STRING | The numeric value associated with the Value Type Code. | VARCHAR(50) | Not Null | No |
CONTR_COMPONENT_ID | A unique, system-generated key that identifies a contract component in the system. | BIGINT | Not Null | No |
START_DT | The date when this record becomes active. | TIMESTAMP | Not Null | No |
END_DT | The date when this record becomes inactive. | TIMESTAMP | Null | No |
LAST_UPDATE_TX_ID | A unique, system-generated key that identifies the specific transaction within the log system that either created, updated, or deleted the data row. | BIGINT | 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 |
LAST_UPDATE_USER | The ID of the user who last updated the data. | VARCHAR(20) | Null | No |