CONTRACTREL
The CONTRACTREL table represents the relationship that an agreement can have with another agreement.
This table is used by the following domains.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| CONTRACT_REL_ID | A unique, system-generated key that identifies a contract relationship in the system. | BIGINT | Not Null | Yes |
| TO_CONTRACT_ID | A unique, system-generated key that identifies a contract in the system. | BIGINT | Not Null | No |
| FROM_CONTRACT_ID | A unique, system-generated key that identifies a contract in the system. | BIGINT | Not Null | No |
| CONTR_REL_TP_CD | Describes the type of relationship. Examples include master contract and contract term. | BIGINT | Not Null | No |
| CONTR_REL_ST_TP_CD | Identifies the status of the relationship between two contracts, such as "pending", "active", and "terminated". | BIGINT | 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 |
| REL_DESCRIPTION | Provides for comments that a user might have concerning the contract relationship. | VARCHAR(255) | 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 |