HOLDING
The HOLDING table contains records of personal holdings. For example, a list of assets and liabilities such as Vehicles, Dwellings and Mortgage.
This table is used by the following domains.
Name | Comment | Datatype | Null Option | Is PK |
---|---|---|---|---|
HOLDING_ID | A unique, system-generated key that identifies a party holding in the system. | BIGINT | Not Null | Yes |
HOLD_TP_CD | Identifies a type of party holding. Some examples include Vehicles, Property, or Stocks. | BIGINT | Not Null | No |
HOLDING_CODE | Identifies the holding code: V - vehicle; P - property. | CHAR(1) | Not Null | No |
HOLDING_VALUE_AMT | The value of the specific holding. | DECIMAL(17,3) | Null | No |
DESCRIPTION | Provides extra information. | VARCHAR(255) | 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_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 |
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 |
VALUAMT_CUR_TP | The currency type for the holding value amount. | BIGINT | Null | No |