DCFColumnMap (ver9.1.0)
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
CoreColumn | 9.1.0 | Varchar2(30) | Name of the column in the DCFTable.CoreTable table. Required. |
DCFColumn | 9.1.0 | Varchar2(28) | Generated name of the column to be used in the AU or LG table. Required |
DCFColumnMapID | 9.1.0 | Number(19) | Unique sequential number generated by the application. Required. Indexed. |
DCFTableID | 9.1.0 | Number(19) | Internal number for the associated DCFTable record. Required. FK constrained. |
| MANAGED | 20.11.0 | Number(1) | Indicates whether this is managed or unmanaged column.Managed columns are those that are defined in the Change History configuration. Whereas unmanaged columns are those that are exclusive to DCF definition. Valid values: 1 = Indicates as managed column, 0 = Indicates as unmanaged column, Null = Indicates as key column. |
WhenCreated | 9.1.0 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 9.1.0 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 9.1.0 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 9.1.0 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |