DCFColumnMap (ver9.1.0)

This table stores information that defines the column names generated for DCF tables.

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.

MANAGED20.11.0Number(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.

Copyright © 2021 PowerSchool Group LLC