Skip to main content
Skip table of contents

VirtualTablesLegacyData2 (ver10.1.4)

The actual data that is stored for the user-defined/custom tables. These could hold relationships to other data fields, such as Parent-Child relationships. Previously called VirtualTablesData2.

Column NameInitial VersionData TypeDescription

Created_By

3.6.1

Varchar(31)

Name of the user that created this record.

Created_On

3.6.1

Date

Date this record was created.

Custom

3.6.1

CLOB

This field contains the data for all the virtual fields.

DCID

4.0.0

Number(10,0)

Unique identifier for this table. Indexed. Required.

ForeignKey

3.6.1

Number(10,0)

When the virtual table is linked to another table, this field will contain the unique key from the linked table. Indexed.

ForeignKey_Alpha

3.6.1

Varchar(31)

Same function as foreignkey but for alphanumeric keys. When the virtual table is linked to another table, this field will contain the unique key from the linked table. Indexed.

Last_Modified

3.6.1

Date

Date this record was last modified.

Linkto_Def_ID

3.6.1

Number(10,0)

Unique ID from VirtualTableDef, to which this field data belongs. Indexed.

Modified_By

3.6.1

Varchar(31)

Name of the user that modified this record.

Related_To_Table

3.6.1

Varchar(31)

This field contains the name of the virtual table for optimization purposes since ID is already provided in Link_To_Def_ID.

SchoolID

3.6.1

Number(10,0)

The School_Number of the associated Schools record.

Unique_ID

3.6.1

Number(10,0)

Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed.

User_Defined_Date

3.6.1

Date

The actual value of type date for the associated field.

User_Defined_Date2

3.6.1

Date

The actual value of type date if more than one for the associated field.

User_Defined_Integer

3.6.1

Number(10,0)

The actual value of type integer for the associated field.

User_Defined_Numeric

3.6.1

Float

The actual value of type number for the associated field.

User_Defined_Text

3.6.1

Varchar(79)

The actual value of type text for the associated field.

User_Defined_Text2

3.6.1

Varchar(79)

The actual value of type text if more than one for the associated field

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.