Type_StringPrimitiveNull |
TILDA__MAINTENANCELOG_Factory.COLS_BASE.ACTION |
This is the column definition for:
Nameaction of type String
DescriptionThe name of the maintenance resource to track.
ColumnTILDA.MaintenanceLog.action of type varchar(64)
Full Nametilda.data.TILDA.MaintenanceLog.action
Size64
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
Values
Name Value Label Default Groupings Description
0 Execute Execute Execute NONE Execute
1 Create Create Create NONE Create
2 Update Update Update NONE Update
3 Drop Drop Drop NONE Drop
4 Rename Rename Rename NONE Rename
5 Comment Comment Comment NONE Comment
6 Optimize Optimize Optimize NONE Optimize
7 Vacuum Vacuum Vacuum NONE Vacuum
8 Reorg Reorg Reorg NONE Reorg
9 Cluster Cluster Cluster NONE Cluster
10 Access Access Access NONE Access Control
11 Catalog Catalog Catalog NONE Catalog
|
Type_StringPrimitiveNull |
TILDA__CATALOG_Factory.COLS_BASE.AGGREGATE |
This is the column definition for:
Nameaggregate of type String
DescriptionThe aggregate type of the column, if any.
ColumnTILDA.Catalog.aggregate of type varchar(128)
Full Nametilda.data.TILDA.Catalog.aggregate
Size128
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOB_Factory.COLS_BASE.DATAENDTZ |
This is the column definition for:
NamedataEndTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'dataEnd'.
ColumnTILDA.Job.dataEndTZ of type character(5)
Full Nametilda.data.TILDA.Job.dataEndTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBPART_Factory.COLS_BASE.DATAENDTZ |
This is the column definition for:
NamedataEndTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'dataEnd'.
ColumnTILDA.JobPart.dataEndTZ of type character(5)
Full Nametilda.data.TILDA.JobPart.dataEndTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOB_Factory.COLS_BASE.DATASTARTTZ |
This is the column definition for:
NamedataStartTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'dataStart'.
ColumnTILDA.Job.dataStartTZ of type character(5)
Full Nametilda.data.TILDA.Job.dataStartTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBPART_Factory.COLS_BASE.DATASTARTTZ |
This is the column definition for:
NamedataStartTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'dataStart'.
ColumnTILDA.JobPart.dataStartTZ of type character(5)
Full Nametilda.data.TILDA.JobPart.dataStartTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__DATEDIM_Factory.COLS_BASE.DAYNAME |
This is the column definition for:
NamedayName of type String
DescriptionDay name (i.e., Monday, Tuesday...) of the date
ColumnTILDA.DateDim.dayName of type varchar(255)
Full Nametilda.data.TILDA.DateDim.dayName
Size255
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__ZONEINFO_Factory.COLS_BASE.DEACTIVATEDTZ |
This is the column definition for:
NamedeactivatedTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'deactivated'.
ColumnTILDA.ZoneInfo.deactivatedTZ of type character(5)
Full Nametilda.data.TILDA.ZoneInfo.deactivatedTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__MAINTENANCELOG_Factory.COLS_BASE.DESCR |
This is the column definition for:
Namedescr of type String
DescriptionThe name of the maintenance resource to track.
ColumnTILDA.MaintenanceLog.descr of type varchar(2048)
Full Nametilda.data.TILDA.MaintenanceLog.descr
Size2048
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__MAINTENANCELOG_Factory.COLS_BASE.ENDTIMETZ |
This is the column definition for:
NameendTimeTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'endTime'.
ColumnTILDA.MaintenanceLog.endTimeTZ of type character(5)
Full Nametilda.data.TILDA.MaintenanceLog.endTimeTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOB_Factory.COLS_BASE.ENDTZ |
This is the column definition for:
NameendTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'end'.
ColumnTILDA.Job.endTZ of type character(5)
Full Nametilda.data.TILDA.Job.endTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBPART_Factory.COLS_BASE.ENDTZ |
This is the column definition for:
NameendTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'end'.
ColumnTILDA.JobPart.endTZ of type character(5)
Full Nametilda.data.TILDA.JobPart.endTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__CATALOG_Factory.COLS_BASE.FORMULA |
This is the column definition for:
Nameformula of type String
DescriptionThe expression/formula that may be associated with this column.
ColumnTILDA.Catalog.formula of type text
Full Nametilda.data.TILDA.Catalog.formula
Size32000
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__DATEDIM_Factory.COLS_BASE.HOLIDAYNAME |
This is the column definition for:
NameholidayName of type String
DescriptionThe name of the holiday if applicable.
ColumnTILDA.DateDim.holidayName of type varchar(255)
Full Nametilda.data.TILDA.DateDim.holidayName
Size255
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__CATALOG_Factory.COLS_BASE.HTMLDOC |
This is the column definition for:
NamehtmlDoc of type String
DescriptionPre-rendered html fragment with the full documentation for this formula.
ColumnTILDA.Catalog.htmlDoc of type text
Full Nametilda.data.TILDA.Catalog.htmlDoc
Size32000
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBVIEW_Factory.COLS_BASE.JOBDATAENDTZ |
This is the column definition for:
NamejobDataEndTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'jobDataEnd'.
ColumnTILDA.JobView.jobDataEndTZ of type character(5)
Full Nametilda.data.TILDA.JobView.jobDataEndTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBVIEW_Factory.COLS_BASE.JOBDATASTARTTZ |
This is the column definition for:
NamejobDataStartTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'jobDataStart'.
ColumnTILDA.JobView.jobDataStartTZ of type character(5)
Full Nametilda.data.TILDA.JobView.jobDataStartTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBVIEW_Factory.COLS_BASE.JOBENDTZ |
This is the column definition for:
NamejobEndTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'jobEnd'.
ColumnTILDA.JobView.jobEndTZ of type character(5)
Full Nametilda.data.TILDA.JobView.jobEndTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBVIEW_Factory.COLS_BASE.JOBMSG |
This is the column definition for:
NamejobMsg of type String
DescriptionMessage details
ColumnTILDA.JobView.jobMsg of type text
Full Nametilda.data.TILDA.JobView.jobMsg
Size8192
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBVIEW_Factory.COLS_BASE.JOBPARTDATAENDTZ |
This is the column definition for:
NamejobPartDataEndTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'jobPartDataEnd'.
ColumnTILDA.JobView.jobPartDataEndTZ of type character(5)
Full Nametilda.data.TILDA.JobView.jobPartDataEndTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBVIEW_Factory.COLS_BASE.JOBPARTDATASTARTTZ |
This is the column definition for:
NamejobPartDataStartTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'jobPartDataStart'.
ColumnTILDA.JobView.jobPartDataStartTZ of type character(5)
Full Nametilda.data.TILDA.JobView.jobPartDataStartTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBVIEW_Factory.COLS_BASE.JOBPARTENDTZ |
This is the column definition for:
NamejobPartEndTZ of type String
DescriptionGenerated helper column to hold the time zone ID for 'jobPartEnd'.
ColumnTILDA.JobView.jobPartEndTZ of type character(5)
Full Nametilda.data.TILDA.JobView.jobPartEndTZ
Size5
Nullabletrue
ModeAUTO
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBVIEW_Factory.COLS_BASE.JOBPARTTYPE |
This is the column definition for:
NamejobPartType of type String
DescriptionJob part type
ColumnTILDA.JobView.jobPartType of type varchar(250)
Full Nametilda.data.TILDA.JobView.jobPartType
Size250
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBVIEW_Factory.COLS_BASE.JOBTYPE |
This is the column definition for:
NamejobType of type String
DescriptionJob type
ColumnTILDA.JobView.jobType of type varchar(250)
Full Nametilda.data.TILDA.JobView.jobType
Size250
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBVIEW_Factory.COLS_BASE.JOBUSERID |
This is the column definition for:
NamejobUserId of type String
DescriptionJob user Id
ColumnTILDA.JobView.jobUserId of type varchar(250)
Full Nametilda.data.TILDA.JobView.jobUserId
Size250
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__DATEDIM_Factory.COLS_BASE.MMDDYYYY |
This is the column definition for:
Namemmddyyyy of type String
DescriptionThe mmddyyyy printable version of a date.
ColumnTILDA.DateDim.mmddyyyy of type character(8)
Full Nametilda.data.TILDA.DateDim.mmddyyyy
Size8
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__DATEDIM_Factory.COLS_BASE.MMYYYY |
This is the column definition for:
Namemmyyyy of type String
DescriptionThe mmyyyy printable version of a date.
ColumnTILDA.DateDim.mmyyyy of type character(6)
Full Nametilda.data.TILDA.DateDim.mmyyyy
Size6
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__DATEDIM_Factory.COLS_BASE.MONTHNAME |
This is the column definition for:
NamemonthName of type String
DescriptionMonth name (i.e., January, February...) of the date.
ColumnTILDA.DateDim.monthName of type varchar(255)
Full Nametilda.data.TILDA.DateDim.monthName
Size255
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__DATEDIM_Factory.COLS_BASE.MONTHNAMESHORT |
This is the column definition for:
NamemonthNameShort of type String
DescriptionMonday short name (i.e., Jan, Feb...) of the date.
ColumnTILDA.DateDim.monthNameShort of type varchar(255)
Full Nametilda.data.TILDA.DateDim.monthNameShort
Size255
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOB_Factory.COLS_BASE.MSG |
This is the column definition for:
Namemsg of type String
DescriptionMessage details
ColumnTILDA.Job.msg of type text
Full Nametilda.data.TILDA.Job.msg
Size8192
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__MAINTENANCELOG_Factory.COLS_BASE.OBJECTNAME |
This is the column definition for:
NameobjectName of type String
DescriptionThe name of the resource.
ColumnTILDA.MaintenanceLog.objectName of type varchar(1024)
Full Nametilda.data.TILDA.MaintenanceLog.objectName
Size1024
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__MAINTENANCELOG_Factory.COLS_BASE.OBJECTTYPE |
This is the column definition for:
NameobjectType of type String
DescriptionThe type of the resource.
ColumnTILDA.MaintenanceLog.objectType of type varchar(128)
Full Nametilda.data.TILDA.MaintenanceLog.objectType
Size128
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
Values
Name Value Label Default Groupings Description
0 Schema Schema Schema NONE A schema
1 Table Table Table NONE A table
2 View View View NONE A view
3 Column Column Column NONE A column
4 Index Index Index NONE An index.
5 ForeignKey ForeignKey ForeignKey NONE An foreign key.
6 PrimaryKey PrimaryKey PrimaryKey NONE An primary key.
7 Function Function Function NONE A function
8 Procedure Procedure Procedure NONE A procedure
9 Script Script Script NONE A script
|
Type_StringPrimitiveNull |
TILDA__DATEDIM_Factory.COLS_BASE.QUARTERNAME |
This is the column definition for:
NamequarterName of type String
DescriptionQuarter name (i.e., Q1, Q2...) of the date.
ColumnTILDA.DateDim.quarterName of type varchar(255)
Full Nametilda.data.TILDA.DateDim.quarterName
Size255
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__MAINTENANCELOG_Factory.COLS_BASE.STATEMENT |
This is the column definition for:
Namestatement of type String
DescriptionThe value of the maintenance resource to track.
ColumnTILDA.MaintenanceLog.statement of type text
Full Nametilda.data.TILDA.MaintenanceLog.statement
Size8388608
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__CATALOG_Factory.COLS_BASE.TABLEVIEWNAME2 |
This is the column definition for:
NametableViewName2 of type String
DescriptionThe name of the secondary table/view (a derived view, a realized table), if applicable.
ColumnTILDA.Catalog.tableViewName2 of type varchar(128)
Full Nametilda.data.TILDA.Catalog.tableViewName2
Size128
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__CATALOG_Factory.COLS_BASE.TITLE |
This is the column definition for:
Nametitle of type String
DescriptionThe title of the formula/expression that may be associated with this column.
ColumnTILDA.Catalog.title of type varchar(128)
Full Nametilda.data.TILDA.Catalog.title
Size128
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOB_Factory.COLS_BASE.TYPE |
This is the column definition for:
Nametype of type String
DescriptionJob type
ColumnTILDA.Job.type of type varchar(250)
Full Nametilda.data.TILDA.Job.type
Size250
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOBPART_Factory.COLS_BASE.TYPE |
This is the column definition for:
Nametype of type String
DescriptionJob part type
ColumnTILDA.JobPart.type of type varchar(250)
Full Nametilda.data.TILDA.JobPart.type
Size250
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__JOB_Factory.COLS_BASE.USERID |
This is the column definition for:
NameuserId of type String
DescriptionJob user Id
ColumnTILDA.Job.userId of type varchar(250)
Full Nametilda.data.TILDA.Job.userId
Size250
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|
Type_StringPrimitiveNull |
TILDA__DATEDIM_Factory.COLS_BASE.YYYYMMDD |
This is the column definition for:
Nameyyyymmdd of type String
DescriptionThe yyyymmdd sortable printable version of a date.
ColumnTILDA.DateDim.yyyymmdd of type character(8)
Full Nametilda.data.TILDA.DateDim.yyyymmdd
Size8
Nullabletrue
ModeNORMAL
Invariantfalse
ProtectNONE
|