DIM Property Descriptions
Property Names and Relative Property IDs are defined in dbaim.h.
Property Name |
Description |
Property ID |
Type |
Size |
MetaloadDate |
Date the last time metaload was run. This field is set by the metaload utility (command line or as called by the MetaManager) each time the utility is run. |
PID_SYSTEM_ METALOADDATE |
String |
20 |
LoadFlag |
Flag indicating type of metaload 0 = not loaded Set by the metaload utility (command line or as called by the MetaManager). If no databases are specified on the initial load or during a resync, the flag is set to 1 (All). This indicates that the Automatic DIM Update Gateway is to maintain updates on all databases in the system. If databases are specified on the initial system load, the flag is set to 2 (specific databases). If databases are excluded on a system load, the flag is set to 3 (excluded databases). This indicates that the Automatic DIM Update Gateway is to maintain updates on only the databases that have been loaded into the MDS repository. If the flag is set to 1 (All) and metaload is run to resync a specific database or databases, the flag is not changed. |
PID_SYSTEM_ LOADFLAG |
Short |
|
MetaloadUserLogin |
Teradata user name for the metaload utility and the MDS DDL Gateway to use to logon to this Teradata Database Systems. |
PID_SYSTEM_ MLUSERLOGIN |
String |
128 |
MetaloadUserPwd |
Password for the MLUserName |
PID_SYSTEM_ MLUSERPWD |
Binary |
64 |
MetaloadSystemDSN |
ODBC DSN that connects to this system |
PID_SYSYSTEM_ MLSYSDSN |
String |
30 |
RecoveryDatabase |
Name of the database containing the MDS Recovery Table |
PID_SYSTEM_ RECOVERYDB |
String |
128 |
RecoveryTableName |
Name of the MDS Recovery Table. If the MDS DDL Gateway is down, Teradata will write the names of databases in which DDL occurs to this table. When the MDS DDL Gateway restarts, if the RecoverOnStartup option has been set, the MDS DDL Gateway will resynchronize all of the databases whose names are stored in this table. Then the names will be deleted from this table. |
PID_SYSTEM_ RECOVERYTABLE |
String |
128 |
DIMUpdatesEnabled |
Indicates if the MDS DDL Gateway is to track changes made to this Teradata system. This is done to keep the MDS repository in sync with the Teradata meta data. “Y” = yes “N” = no |
PID_SYSTEM_ DIMUPDENABLED |
String |
1 |
RecoveryDays |
Indicates which days of the week for the MDS DDL Gateway to perform recovery |
PID_SYSTEM_ RECOVERYDAYS |
Integer |
|
RecoveryTime |
Indicates the time for the MDS DDL Gateway to perform recovery |
PID_SYSTEM_ RECOVERYTIME |
Double |
|
RecoverOnStartup |
Indicates to the MDS DDL Gateway to perform recovery when the Gateway is started. |
PID_SYSTEM_ RECOVER ONSTARTUP |
Short |
|
RDBMSType |
Text containing the RDBMS type such as "Teradata" |
PID_SYSTEM_RDBMSTYPE |
String |
30 |
SecurityPropagationType |
Indicates the default Security Profile to assign to new objects that are loaded. If set to 0, the security profile assigned to the database object will be used. If set to 1, the security profile assigned to the class will be used. |
PID_SYSTEM_SECURITYPROPTYPE |
Short |
|
Property Name |
Description |
Property ID |
Type |
Size |
CommentString |
The comment stored in Teradata for this database |
PID_DATABASE_ COMMENT |
String |
255 |
CreatorName |
The Teradata user that issued the CREATE DATABASE/USER |
PID_DATABASE_CREATORNAME |
String |
128 |
DatabaseId |
Teradata assigned identifier for this database |
PID_DATABASE_ DATABASEID |
Binary |
4 |
DatabaseType |
Teradata Database types: U = the object is a Teradata User When data is loaded using the Meta Integration Model Bridges (MIMB), you may see the following values: A = the object is an MS Access database |
PID_DATABASE_TYPE |
String |
1 |
SynchronizationLevel |
Internal flag indicating the completeness of loading objects in the database. the possible values are: |
PID_DATABASE_ SYNCLEVEL |
Short |
|
Property Name |
Description |
Property ID |
Type |
Size |
CommentString |
The comment stored in Teradata for this table |
PID_TABLE_ COMMENT |
String |
255 |
CreatorName |
The Teradata user that issued the CREATE TABLE |
PID_TABLE_CREATORNAME |
String |
128 |
DatabaseId |
Teradata assigned identifier for the database where this table resides |
PID_TABLE_ DATABASEID |
Binary |
4 |
IsErrorTable |
Indicates if the table is an error table for another table. Possible values are Y=Yes, N=No. |
PID_TABLE_ISERRORTABLE |
String |
1 |
IsGlobalTemporary |
Indicates if the table is a global temporary table rather than a permanent table. Possible values are Y=Yes, N=No. |
PID_TABLE_ISGLOBALTEMPORARY |
String |
1 |
LastAlterTimeStamp |
Time that Teradata last updated the object |
PID_TABLE_LASTALTERTIMESTAMP |
TimeStamp |
|
PartitioningUsed |
Indicates the type of partitioning used in the table. Set to PPI for a PPI, or else set null. |
PID_TABLE_PARTITIONINGUSED |
String |
8 |
PrimaryIndexDefined |
Indicates if a table has a primary index. Possible values are Y=Yes, N=No. Metaload and DIM Update set this value for each table they process. |
PID_TABLE_PRIMARYINDEXDEFINED |
String |
1 |
SynchronizationLevel |
Internal Flag |
PID_TABLE_ SYNCLEVEL |
Short |
|
TableId |
Teradata assigned identifier for this table |
PID_TABLE_ TABLEID |
Binary |
6 |
Version |
Version of this table in Teradata. Each time table is altered, Teradata increments the version. |
PID_TABLE_ VERSION |
Short |
|
Property Name |
Description |
Property ID |
Type |
Size |
DatabaseID |
Teradata assigned identifier for the database containing the function that generates the table |
PID_FUNCTIONTABLE_DATABASEID |
Binary |
4 |
FunctionID |
Teradata assigned identifier for the function that generates the table |
PID_FUNCTIONTABLE_FUNCTIONID |
Binary |
6 |
NumberOfColumns |
Number of columns in a statically defined table returned by the function. A value of zero indicates that the function was created with the VARYING COLUMNS clause and the number of columns is unknown. |
PID_FUNCTIONTABLE_NUMCOLUMNS |
Short |
|
NumberOfDynamicColumns |
Maximum number of columns in the table returned by a function defined with the VARYING COLUMNS clause. |
PID_FUNCTIONTABLE_NUMDYNAMICCOLUMNS |
Short |
|
SynchronizationLevel |
Internal flag |
PID_FUNCTIONTABLE_SYNCLEVEL |
Short |
|
Property Name |
Description |
Property ID |
Type |
Size |
CharType |
Specifies the character set type of character fields. |
PID_COLUMN_ CHARTYPE |
Short |
|
ColumnFormat |
Display format for the column |
PID_COLUMN_ COLUMNFORMAT |
String |
128 |
ColumnId |
Teradata assigned identifier for this column |
PID_COLUMN_ COLUMNID |
Short |
|
ColumnLength |
Maximum size of the column |
PID_COLUMN_ COLUMNLENGTH |
Integer |
|
ColumnTitle |
Heading for displayed or printed results that is different from the column name, which is used by default. |
PID_COLUMN_ COLUMNTITLE |
String |
256 |
ColumnType |
Column data type. Values can be: |
PID_COLUMN_ COLUMNTYPE |
String |
2 |
CommentString |
Comment stored in Teradata for this column |
PID_COLUMN_ COMMENT |
String |
255 |
Compressible |
Indicates if the column is to be compressed. If yes, the column will be compressed to zero space if the data value of the column is equal to the CompressValue C = compress |
PID_COLUMN_ COMPRESSIBLE |
String |
1 |
CompressValue |
If NULL is specified, NULLs are compressed. If constant specified, NULLS and the value are compressed |
PID_COLUMN_ COMPRESSVALUE |
String |
8192 |
DatabaseID |
Teradata assigned identifier for the database where this column resides |
PID_COLUMN_ DATABASEID |
Binary |
4 |
DecimalFractDigits |
Number of digits in the decimal portion of DECIMAL and NUMERIC columns. |
PID_COLUMN_ DECIMAL FRACTDIGITS |
Short |
|
DecimalTotalDigits |
Total number of digits for data types of DECIMAL and NUMERIC. |
PID_COLUMN_ DECIMAL TOTALDIGITS |
Short |
|
DefaultValue |
Default value specified for this column |
PID_COLUMN_ DEFAULTVALUE |
String |
1024 |
DerivedPeriod |
Indicates whether the column is a derived period column or part of a derived period. Yes = is a derived period column No = is not part of a derived period definition Period Begin = the starting column of a derived period definition Period End = the ending column of a derived period definition |
PID_COLUMN_DERIVEDPERIOD |
String |
12 |
IDColType |
If this is an identity column, this field contains the parameters defined for the identity column. |
PID_COLUMN_IDCOLTYPE |
String |
164 |
IsSecurityConstraint |
Indicates whether the column represents a security constraint for the table. |
PID_COLUMN_ISSECURITYCONSTRAINT |
String |
1 |
Nullable |
Indicates if NULL is an accepted value for this column. Y = acceptable value |
PID_COLUMN_NULLABLE |
String |
1 |
TableId |
Teradata assigned identifier for the table where this column resides |
PID_COLUMN_ TABLEID |
Binary |
6 |
UppercaseFlag |
In columns declared as UPPERCASE, small-case letters are converted and stored in their capital-case equivalents Y = small-case converted |
PID_COLUMN_ UPPERCASEFLAG |
String |
1 |
Property Name |
Description |
Property ID |
Type |
Size |
CommentString |
Comment stored in Teradata for this view |
PID_VIEW_ COMMENT |
String |
255 |
CreatorName |
The Teradata user that issued the CREATE/REPLACE VIEW |
PID_VIEW_CREATORNAME |
String |
128 |
DatabaseID |
Teradata assigned identifier for the database where this view resides |
PID_VIEW_ DATABASEID |
Binary |
4 |
IsRecursive |
Indicates if a view is recursive; that is, it selects from itself. Values are Y=Yes, N=No. This property is set by metaload and DIM Update when they process a view. When an existing database in the DIM is processed by metaload, it automatically reevaluates any view that has a NULL value for the property |
PID_VIEW_ISRECURSIVE |
String |
1 |
LastAlterTimeStamp |
Time that Teradata last updated the object |
PID_VIEW_LASTALTER_TIMESTAMP |
TimeStamp |
|
ReqText |
The SQL string used to create the view |
PID_VIEW_ REQTEXT |
String |
12500 |
SynchronizationLevel |
Internal Flag |
PID_VIEW_ SYNCLEVEL |
Short |
|
ViewId |
Teradata assigned identifier for this view |
PID_VIEW_VIEWID |
Binary |
6 |
Property Name |
Description |
Property ID |
Type |
Size |
ColumnID |
Teradata assigned identifier for this view column |
PID_VIEWCOL_ COLUMNID |
Short |
|
ColumnLength |
Length of the view column |
PID_VIEWCOL_ COLUMNLENGTH |
Integer |
|
ColumnType |
Data type of this view column |
PID_VIEWCOL_ COLUMNTYPE |
String |
2 |
CommentString |
Comment stored in Teradata for this view |
PID_VIEWCOL_ COMMENT |
String |
255 |
DatabaseID |
Teradata assigned identifier for the database where this view column resides |
PID_VIEWCOL_ DATABASEID |
Binary |
4 |
DecimalFractDigits |
For data types of DECIMAL and NUMERIC this is the number of digits in the decimal portion of the number |
PID_VIEWCOL_ DECIMALFRACTDIGITS |
Short |
|
DecimalTotalDigits |
For data types of DECIMAL and NUMERIC this is the total digits in the view column |
PID_VIEWCOL_ DECIMALTOTALDIGITS |
Short |
|
IsSecurityConstraint |
Indicates whether the column represents a security constraint for the table. |
PID_VIEWCOL_ISSECURITYCONSTRAINT |
String |
1 |
Nullable |
Identifies whether the view column is nullable |
PID_VIEWCOL_ NULLABLE |
String |
1 |
ViewID |
Teradata assigned identifier for the view where this view column resides |
PID_VIEWCOL_ VIEWID |
Binary |
6 |
Property Name |
Description |
Property ID |
Type |
Size |
DatabaseID |
Teradata assigned identifier for the database where this index resides |
PID_INDEX_ DATABASEID |
Binary |
4 |
IndexNumber |
Teradata assigned identifier for this index |
PID_INDEX_ NUMBER |
Short |
|
IndexType |
IndexType field identifies the index type as: |
PID_INDEX_TYPE |
String |
1 |
TableID |
Teradata assigned identifier for the table where this index is built |
PID_INDEX_TABLEID |
Binary |
6 |
UniqueFlag |
UniqueFlag field indicates if the index is unique as Y (unique) or N (non-unique) |
PID_INDEX_ UNIQUEFLAG |
String |
1 |
Property Name |
Description |
Property ID |
Type |
Size |
ColumnPosition |
Identifies the column position within the index |
PID_INDEXCOL_ COLUMNPOSITION |
Short |
|
DatabaseID |
Teradata assigned identifier for the database where this index resides |
PID_INDEXCOL_DATABASEID |
Binary |
4 |
IndexNumber |
Teradata assigned identifier for the index |
PID_INDEXCOL_INDEXNUMBER |
Short |
|
TableID |
Teradata assigned identifier for the table where this index is built |
PID_INDEXCOL_TABLEID |
Binary |
6 |
Property Name |
Description |
Property ID |
Type |
Size |
CheckBool |
The “check <boolean>” string for this check constraint. |
PID_ CHECKCONSTRAINT_ CHECKBOOL |
String |
8192 |
ConstraintType |
C = Table level check constraint Q = Partitioned primary index constraint |
PID_CHECKCONSTRAINT_TYPE |
String |
1 |
DatabaseID |
Teradata assigned identifier for the database where this check constraint resides. |
PID_ CHECKCONSTRAINT_ DATABASEID |
Binary |
4 |
TableID |
Teradata assigned identifier for table where this check constraint resides. |
PID_ CHECKCONSTRAINT_ TABLEID |
Binary |
6 |
Property Name |
Description |
Property ID |
Type |
Size |
DatabaseID |
Teradata assigned identifier for the database where this constraint resides |
PID_ REFCONSTRAINT_ DATABASEID |
Binary |
4 |
RefDatabase |
Database of the reference table |
PID_ REFCONSTRAINT_ REFDATABASE |
String |
128 |
ReferenceID |
Teradata assigned identifier for this Reference constraint |
PID_ REFCONSTRAINT_ REFERENCEID |
Short |
|
RefTable |
Table the constraint refers to |
PID_ REFCONSTRAINT_ REFTABLE |
String |
128 |
TableID |
Teradata assigned identifier for the table the constraint is built on. |
PID_ REFCONSTRAINT_ TABLEID |
Binary |
6 |
Property Name |
Description |
Property ID |
Type |
Size |
DatabaseID |
Teradata assigned identifier for the database where this constraint resides |
PID_REFCOL_DATABASEID |
Binary |
4 |
ForeignKeyColName |
Name of the foreign key column |
PID_REFCOL_ FOREIGNKEYCOL |
String |
128 |
ReferenceColName |
Name of the reference column |
PID_REFCOL_ REFERENCECOL |
String |
128 |
ReferenceID |
Teradata assigned identifier for this Reference constraint |
PID_REFCOL_REFERENCEID |
Short |
|
TableID |
Teradata assigned identifier for the table the constraint is built on. |
PID_REFCOL_TABLEID |
Binary |
6 |
Property Name |
Description |
Property ID |
Type |
Size |
NodeStatus |
U = node is up. |
PID_NODE_NODESTATUS |
String |
1 |
Property Name |
Description |
Property ID |
Type |
Size |
CommentString |
The comment stored in Teradata for this Stored Procedure. |
PID_SP_COMMENT |
String |
255 |
CreatorName |
The Teradata user that issued the CREATE/REPLACE PROCEDURE |
PID_SP_CREATORNAME |
String |
128 |
DatabaseID |
Teradata assigned identifier for the database where this Stored Procedure resides |
PID_SP_DATABASEID |
Binary |
4 |
LastAlterTimeStamp |
Time that Teradata last updated the object |
PID_SP_LASTALTERTIMESTAMP |
TimeStamp |
|
ProcedureID |
Teradata assigned identifier for this Stored Procedure |
PID_SP_PROCEDUREID |
Binary |
6 |
SPText |
Contains Stored Procedure text. |
PID_SP_TEXT |
String |
12500 |
SynchronizationLevel |
Internal Flag |
PID_SP_SYNCLEVEL |
Short |
|
Property Name |
Description |
Property ID |
Type |
Size |
CommentString |
The comment stored in Teradata for this parameter |
PID_SPPARAMETER_COMMENT |
String |
255 |
CreatorName |
The Teradata user that issued the CREATE/REPLACE PROCEDURE |
PID_SPPARAMETER_CREATORNAME |
String |
128 |
DatabaseId |
Teradata assigned identifier for the database where this Stored Procedure resides |
PID_SPPARAMETER_DATABASEID |
Binary |
4 |
ParameterId |
Teradata assigned identifier for this Stored Procedure parameter |
PID_SPPARAMETER_PARAMETERID |
Short |
|
ParamLength |
Contains the maximum length in bytes for the value of this parameter |
PID_SPPARAMETER_PARAMLENGTH |
Integer |
|
ParamType |
Contains the data type of this parameter |
PID_SPPARAMETER_PARAMTYPE |
String |
2 |
ProcedureId |
Teradata assigned identifier for this Stored Procedure |
PID_SPPARAMETER_PROCEDUREID |
Binary |
6 |
RowTypeDatabaseName |
The name of the database containing the table referenced by a %ROWTYPE attribute |
PID_SPPARAMETER_ROWTYPEDBNAME |
String |
128 |
RowTypeTableName |
The name of the table referenced by a %ROWTYPE attribute |
PID_SPPARAMETER_ROWTYPETBLNAME |
String |
128 |
SPParamType |
Contains information on this parameter’s type. "I" = IN |
PID_SPPARAMETER_SPPARAMTYPE |
String |
1 |
Property Name |
Description |
Property ID |
Type |
Size |
ActionTime |
Action time for the trigger: “A” = After the trigger event |
PID_TRIGGER_ACTIONTIME |
String |
1 |
CommentString |
The comment stored in Teradata for the trigger. |
PID_TRIGGER_COMMENT |
String |
255 |
CreatorName |
The Teradata User who issued the CREATE/REPLACE TRIGGER statement |
PID_TRIGGER_CREATORNAME |
String |
128 |
DatabaseId |
Teradata assigned identifier for the database where this trigger resides |
PID_TRIGGER_DATABASEID |
Binary |
4 |
Event |
Type of SQL DML statement that causes trigger to fire. “D” = Delete |
PID_TRIGGER_EVENT |
String |
1 |
IsEnabled |
Whether the trigger is activated or not “Y” = Enabled |
PID_TRIGGER_ENABLED |
String |
1 |
Kind |
Trigger kind as defined by the FOR EACH clause “R” = Row |
PID_TRIGGER_KIND |
String |
1 |
LastAlterTimeStamp |
Time that Teradata last updated the object |
PID_TRIGGER_LASTALTERTIMESTAMP |
TimeStamp |
|
Ordering Position |
When one or more triggers are defined on the same table, ORDER allows you to determine the sequence for firing each trigger. |
PID_TRIGGER_ORDER |
Short |
|
RequestText |
Contains the text that created the trigger. |
PID_TRIGGER_REQUESTTEXT |
String |
12500 |
SynchronizationLevel |
Internal Flag |
PID_TRIGGER_ SYNCLEVEL |
Short |
|
TriggerCreateTimeStamp |
Time that Teradata created the trigger or the creation timestamp from the ALTER TRIGGER <name> TIMESTAMP DDL |
PID_TRIGGER_CREATETIMESTAMP |
TimeStamp |
|
TriggerEnableDisable |
Time that the Teradata trigger was last enabled or disabled |
PID_TRIGGER_ENABLEDISABLETS |
Timestamp |
|
TriggerId |
Teradata assigned identifier for this trigger |
PID_TRIGGER_TRIGGERID |
Binary |
6 |
Property Name |
Description |
Property ID |
Type |
Size |
CommentString |
The comment stored in Teradata for this macro |
PID_MACRO_COMMENT |
String |
255 |
CreatorName |
The Teradata user that issued the CREATE/REPLACE MACRO |
PID_MACRO_CREATORNAME |
String |
128 |
DatabaseID |
Teradata assigned identifier for the database containing this macro |
PID_MACRO_DATABASEID |
Binary |
4 |
LastAlterTimeStamp |
Time that Teradata last updated the macro |
PID_MACRO_LASTALTERTIMESTAMP |
Timestamp |
|
MacroID |
Teradata assigned identifier for this Macro |
PID_MACRO_MACROID |
Binary |
6 |
MacroText |
Contains the text that created the macro. |
PID_MACRO_TEXT |
String |
12500 |
SynchronizationLevel |
Internal flag property |
PID_MACRO_SYNCLEVEL |
Short |
|
Property Name |
Description |
Property ID |
Type |
Size |
CharType |
Specifies the character set type of character fields. |
PID_MACROPARAM_CHARTYPE |
Short |
|
CommentString |
The comment stored in Teradata for this parameter |
PID_MACROPARAM_COMMENT |
String |
255 |
DatabaseID |
Teradata assigned identifier for the database containing this macro property |
PID_MACROPARAM_DATABASEID |
Binary |
4 |
DataType |
Contains the data type for this parameter |
PID_MACROPARAM_DATATYPE |
String |
2 |
DefaultValue |
The value assigned to the parameter when no value is given in the EXEC statement |
PID_MACROPARAM_DEFAULTVALUE |
Character |
1024 |
MacroID |
Teradata assigned identifier for this macro parameter |
PID_MACROPARAM_PROCEDUREID |
Binary |
6 |
ParameterID |
Teradata assigned identifier for this macro |
PID_MACROPARAM_PARAMETERID |
Short |
|
ParamFormat |
Display format for the parameter |
PID_MACROPARAM_PARAMFORMAT |
String |
128 |
ParamLength |
Display length for the parameter |
PID_MACROPARAM_PARAMLENGTH |
Integer |
|
ParamTitle |
Heading for the displayed or printed results. Different from the parameter name which is the default heading. |
PID_MACROPARAM_TITLE |
String |
256 |
Property Name |
Description |
Property ID |
Type |
Size |
CommentString |
The comment stored in Teradata for the join index |
PID_JOININDEX_COMMENT |
String |
255 |
CreatorName |
Name of the Teradata user that created the join index |
PID_JOININDEX_CREATORNAME |
String |
128 |
DatabaseID |
Teradata assigned identifier for the database where the join index resides |
PID_JOININDEX_DATABASEID |
Binary |
4 |
JoinIndexID |
Teradata assigned identifier for the join index |
PID_JOININDEX_JOININDEXID |
Binary |
6 |
LastAlterTime |
Time that Teradata last updated the object |
PID_JOININDEX_LASTALTERTIMESTAMP |
Timestamp |
|
PartitioningUsed |
Indicates the type of partitioning used in the join index. Set to PPI for a PPI, or else set null |
PID_JOININDEX_PARTITIONINGUSED |
String |
8 |
RequestText |
The CREATE JOIN INDEX statement that created the join index |
PID_JOININDEX_REQUESTTEXT |
String |
12500 |
SynchronizationLevel |
Internal Flag |
PID_JOININDEX_SYNCLEVEL |
short |
|
Property Name |
Description |
Property ID |
Type |
Size |
CommentString |
The comment stored in Teradata for the hash index |
PID_HASHINDEX_COMMENT |
String |
255 |
CreatorName |
Name of the Teradata user that created the hash index |
PID_HASHINDEX_CREATORNAME |
String |
128 |
DatabaseId |
Teradata assigned identifier for the database where the hash index resides |
PID_HASHINDEX_DATABASEID |
Binary |
4 |
HashIndexId |
Teradata assigned identifier for the hash index |
PID_HASHINDEX_HASHINDEXID |
Binary |
6 |
LastAlterTime |
Time that Teradata last updated the object |
PID_HASHINDEX_LASTALTERTIMESTAMP |
Timestamp |
|
RequestText |
The CREATE HASH INDEX statement that created the hash index |
PID_HASHINDEX_REQUESTTEXT |
String |
12500 |
SynchronizationLevel |
Internal Flag |
PID_HASHINDEX_SYNCLEVEL |
short |
|
Property Name |
Description |
Property ID |
Type |
Size |
Author |
Name of the creator of the Subject Area |
PID_SUBAREA_AUTHOR |
String |
255 |
BusinessDefinition |
Business definition of the Subject Area |
PID_SUBAREA_BUSDEFID |
String |
2048 |
SubjectAreaId |
ID Number of the Subject Area |
PID_SUBAREA_SUBAREAID |
Integer |
|
Property Name |
Description |
Property ID |
Type |
Size |
BusinessDefinition |
Business description of Entity |
PID_BUSENTITY_BUSDEFID |
String |
12500 |
BusinessNotes |
Comment text |
PID_BUSENTITY_BUSNOTES |
String |
12500 |
EntityId |
ID Number of the Entity |
PID_BUSENTITY_ENTITYID |
Integer |
|
EntityType |
Value indicating the type of the Entity. Valid values = ET_DE (dependent), ET_DR (derived), ET_IE (independent) |
PID_BUSENTITY_ENTITYTYPE |
String |
6 |
SourceFile |
Name of the file that the entity was loaded from (such as the name of the ERwin file). |
PID_BUSENTITY_SOURCEFILE |
String |
255 |
Property Name |
Description |
Property ID |
Type |
Size |
AttributeId |
ID Number of the Attribute |
PID_BUSATTR_ATTRID |
Integer |
|
AttributeType |
Valid values = AT_DR (derived column), AT_NK (nonkey), AT_PK (key) |
PID_BUSATTR_ATTRTYPE |
String |
6 |
BusinessDefinition |
Business description of Attribute |
PID_BUSATTR_BUSDEFID |
String |
12500 |
BusinessNotes |
Comment text |
PID_BUSATTR_BUSNOTES |
String |
12500 |
ColumnPosition |
The ordered position of the Attribute at the logical level |
PID_BUSATTR_COLUMNPOS |
Integer |
|
Rolename |
Describes the Attribute’s role as a foreign key |
PID_BUSATTR_ROLENAME |
String |
255 |
Property Name |
Description |
Property ID |
Type |
Size |
MaximumValue |
String that specifies the maximum value |
PID_BUSRULE_MAXVALUE |
String |
255 |
MinimumValue |
String that specifies the minimum value |
PID_BUSRULE_MINVALUE |
String |
255 |
RuleDefinition |
Definition of the rule |
PID_BUSRULE_RULEDEF |
String |
12500 |
RuleId |
ID Number of the rule |
PID_BUSRULE_RULEID |
Integer |
|
Property Name |
Description |
Property ID |
Type |
Size |
DisplayValue |
The screen display form of the value |
PID_VALIDVALUE_DISPLAYVALUE |
String |
255 |
SequenceNumber |
Sequence number of the value in the list |
PID_VALIDVALUE_SEQNUM |
Integer |
|
ValueDefinition |
Definition of the value |
PID_VALIDVALUE_VALUEDEF |
String |
12500 |
Property Name |
Description |
Property ID |
Type |
Size |
LoadFlags |
Binary array with flags indicating the data types that can be loaded |
PID_LOADTYPES_LOADFLAGS |
Binary |
32 |
Property Name |
Description |
Property ID |
Type |
Size |
FunctionId |
Teradata assigned identifier for a non-built in function |
PID_FUNCTION_FUNCTIONID |
Binary |
6 |
DatabaseId |
Teradata assigned identifier for the database |
PID_FUNCTION_DATABASEID |
Binary |
4 |
RequestText |
The create text for a user-defined function |
PID_FUNCTION_REQUESTTEXT |
String |
12500 |
LastAlterTimestamp |
Time that Teradata last updated the object |
PID_FUNCTION_LASTALTERTIMESTAMP |
Timestamp |
|
CreatorName |
Name of the Teradata user that created the function |
PID_FUNCTION_CREATORNAME |
String |
128 |
CommentString |
Comment stored in Teradata for the function |
PID_FUNCTION_COMMENTSTRING |
String |
255 |
FunctionClass |
Class for the Teradata function or the user defined function |
PID_FUNCTION_CLASS |
String |
30 |
FunctionAlias |
Alias used for the function in an SQL statement |
PID_FUNCTION_ALIAS |
String |
128 |
FunctionReturnType |
Return type for the function |
PID_FUNCTION_RETURN_TYPE |
String |
270 |
SynchronizationLevel |
Internal flag |
PID_FUNCTION_SYNCLEVEL |
Short |
|
FunctionSpecificName |
The specific name for the user defined function |
PID_FUNCTION_SPECIFICNAME |
String |
128 |
FunctionCallParameters |
The actual parameters passed to the function |
PID_FUNCTION_CALLPARAMETERS |
String |
1024 |
Property Name |
Description |
Property ID |
Type |
Size |
|
ConstantType
|
The type of the constant |
|
PID_CONSTANT_TYPE |
String |
128 |
ConstantValue |
The value of the constant |
PID_CONSTANT_VALUE |
String |
1024 |
Values marked with * in the table are converted from constants to functions before being stored in the MDS repository. They have function class “BI” (built-in). Date, Time, Timestamp and Interval literals are stored with a constant type of SQUOTESTR (single quoted string).
The following notes apply to constants referenced by a view column and functions referenced by view columns, stored procedures, macros, and so on:
For example, when a view column references expressions (c1 + 10) and [sum(c1) + 10], where c1 is a table column, 10 is a constant, and sum(c1) is a function, only table column c1 and function sum(c1) are stored in the repository and associated with the view column. The constant 10 and expressions (c1 + 10) and [sum(c1) + 10] are not.
For example, when a view column references the expression [sum(c1) + avg (c1)], only the functions sum(c1) and avg (c1) are stored in the repository and associated with the view column.
Property Name |
Description |
Property ID |
Type |
Size |
CharacterSet |
Teradata assigned identifier for the character set of a distinct data type |
9 |
SHORT |
|
CommentString |
The comment stored in Teradata for the UDT |
6 |
VARCHAR |
255 |
CreatorName |
Name of user that issued CREATE TYPE |
3 |
CHAR |
128 |
DatabaseID |
Teradata assigned identifier for the database |
7 |
BYTE |
4 |
DistinctPredefinedType |
The data type on which a distinct UDT is based |
2 |
CHAR |
2 |
IsStructured |
N=distinct UDT, Y=structured UDT |
1 |
CHAR |
1 |
LastAlterTimestamp |
Time that Teradata last updated the object |
4 |
TIMESTAMP |
|
NumberOfArrayDimensions |
The number of array dimensions for a UDT defining an ARRAY type |
10 |
SMALLINT |
|
RequestText |
CREATE TYPE statement for the type |
9 |
VARCHAR |
12500 |
SynchronizationLevel |
0=not synchronized, 1=synchronized |
5 |
SMALLINT |
|
TransformGroupName |
Indicates the name of a transform group that provides the routines used by Teradata to translate the UDT’s data to or from Teradata format |
11 |
VARCHAR |
128 |
TypeID |
Teradata assigned identifier for the type |
8 |
BYTE |
6 |
Property Name |
Description |
Property ID |
Type |
Size |
AttributeFormat |
Attribute’s format, such as 9(5) |
8 |
VARCHAR |
128 |
AttributeID |
Ordering of the attribute within the structured UDT |
6 |
SMALLINT |
|
AttributeLength |
Length of the attribute |
3 |
INT |
|
CharacterSet |
Character set for CHAR data types |
2 |
SHORT |
|
CommentString |
The comment stored in Teradata for the attribute |
7 |
VARCHAR |
255 |
DataType |
The data type encoding for the attribute |
1 |
CHAR |
2 |
DecimalFractDigits |
n in DECIMAL(M,N) |
5 |
SMALLINT |
|
DecimalTotalDigits |
m in DECIMAL(m,n) |
4 |
SMALLINT |
|
TypeID |
The Teradata assigned identifier of the UDT comprising this attribute's data type |
9 |
BYTE |
6 |
Property Name |
Description |
Property ID |
Type |
Size |
PrimaryTypeID |
The DBC.TVM TVMId value of the UDT for which this UDTCast entry is defined |
PID_UDTCAST_ |
Binary |
6 |
ThisUDTIsTheSource |
Is the UDT for which this CAST is defined the source data type? Y or N |
PID_UDTCAST_ |
CHAR |
1 |
SourceDataType |
The data type of the source value; two-character code matching DBC.TVFields. FieldType |
PID_UDTCAST_ |
CHAR |
2 |
TargetDataType |
The data type of the target value; two-character code matching DBC.TVFields.FieldType |
PID_UDTCAST_ |
CHAR |
2 |
NonUDTLength |
If the source or target is a predefined type, this is the maximum length of the type |
PID_UDTCAST_ |
INTEGER |
|
NonUDTDigits |
If the source or target is a predefined type, this is the number of digits in a numeric value |
PID_UDTCAST_ |
SMALLINT |
|
NonUDTImpliedPoint |
If the source or target is a predefined type, this is the number of digits after the decimal point |
PID_UDTCAST_ |
SMALLINT |
|
NonUDTCharType |
If the source or target is a predefined character type, this is t he numeric code from Teradata for character type (ASCII, UNICODE, and so on) |
PID_UDTCAST_ |
SMALLINT |
|
Implicit Assignment |
Is the CAST routine called for an implicit assignment? Y or N |
PID_UDTCAST_ |
CHAR |
1 |
RoutineID |
DBC.TVM.TVMId value for the cast function; is '000000000000'XBF for Teradata internal routines |
PID_UDTCAST_ |
BINARY |
6 |
SynchronizationLevel |
Internal flag |
PID_UDTCAST_ |
SMALLINT |
|
Property Name |
Description |
Property ID |
Type |
Size |
CharacterSet |
Character set for CHAR data types |
2 |
SHORT |
|
CommentString |
Comment stored in Teradata for the parameter |
5 |
VARCHAR |
255 |
DataType |
Data type encoding for the parameter |
1 |
CHAR |
2 |
ParameterID |
Ordering of the parameter in the function definition |
4 |
SHORT |
|
ParameterLength |
Length of the parameter |
3 |
INT |
|
RowTypeDatabaseName |
The name of the database containing the table referenced by a %ROWTYPE attribute |
6 |
String |
128 |
RowTypeTableName |
The name of the table referenced by a %ROWTYPE attribute |
7 |
String |
128 |
Property Name |
Description |
Property ID |
Type |
Size |
PartitionType |
The type of partitioning - only value is 'PPI' for MDS 15.0 |
PID_PARTITIONING_PARTITIONTYPE |
VARCHAR |
8 |
PartitionText |
Text of the PARTITION BY clause defining the partitioning |
PID_PARTITIONING_PARTITIONTEXT |
VARCHAR |
16000 |
NumberOfLevels |
The number of levels defined by the PARTITION BY clause, if known |
PID_PARTITIONING_NUMBEROFLEVELS |
SHORT |
|
LastAlterTimeStamp |
Timestamp of when the associated partitioning definition was created |
PID_PARTITIONING_LASTALTERTS |
Timestamp |
|
SynchronizationLevel |
Internal flag |
PID_PARTITIONING_SYNCLEVEL |
SHORT |
|