RepoLookupTablesDefItems, 66 (ver3.6.1)
This table stores the definition of each value in the lookup tables in the reports.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
DCID | 4.0.0 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
Description | 3.6.1 | CLOB | An optional area to describe any information about this item. |
Field_Index | 3.6.1 | Number(10,0) | The number provided to this item for referencing purposes. |
Internal_ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Item_Name | 3.6.1 | Varchar(31) | Name of item to be listed in the lookup table. |
LookupTableID | 3.6.1 | Number(10,0) | The internal number for the parent RepoLookupTables with which this record is associated. Indexed. |
Max_Nbr_Of_Chars | 3.6.1 | Number(10,0) | Maximum number of characters allowed for this item. Not being set on page or import yet. |
Value_Type | 3.6.1 | Number(10,0) | Default Datatype of the Variable to be used, such as 1=Integer, 2=Real, 3=Text, 4=Date, 5=Boolean, 6=Time, 7= Undefined. |