DIM Property Descriptions

Property Names and Relative Property IDs are defined in dbaim.h.

Table 5: Database System Class Property Descriptions
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 1 = all databases loaded 2 = specific databases loaded 3 = specific databases excluded 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

Table 6: Database Class Property Descriptions
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 D = the object is a Teradata Database 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 B = the object is a DB2 database I = the object is an Informix database M = the object is an SQLServer database O = the object is an Oracle database R = the object is a Redbrick database S = the object is a Sybase database T = the object is a Teradata Database	PID_DATABASE_TYPE	String	1
SynchronizationLevel	Internal flag indicating the completeness of loading objects in the database. the possible values are: -2 = QuickLoaded database -1 = some objects in the database do not have their relationships to other objects fully defined 0 = all objects in the database are successfully defined but the owning database is not known 1 = all objects in the database are successfully defined and the owning database is known	PID_DATABASE_ SYNCLEVEL	Short

Table 7: Table Class Property Descriptions
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

Table 8: FunctionTable Class Property Descriptions
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

Table 9: Column Class Property Descriptions
Property Name	Description	Property ID	Type	Size
CharType	Specifies the character set type of character fields. Values can be: 1 Latin 2 Unicode 3 KanjiSJIS 4 Graphic 5 Kanji1	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: A1 1-dimensional Array AN n-dimensional Array AT Time BF Byte BO BLOB BV VarByte CF Character CO CLOB CV VarCharacter D Decimal DA Date DH Day To Hour DM Day To Minute DS Day To Second DY Day F Float HM Hour To Minute HR Hour HS Hour To Second I Integer I1 ByteInt I2 SmallInt I8 BigInt JN JSON MI Minute MO Month MS Minute To Second N Number PD Period Date PM Period Timestamp with Time Zone PS Period Timestamp PT Period Time PZ Period Time with Time Zone SC Second SZ Timestamp with Time Zone TS Timestamp TZ ANSI Time with Time Zone UT User-defined Type VA TD_VALIST XM XML YM Year To Month YR Year	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 N = do not 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 N = not 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 N = small-case not converted	PID_COLUMN_ UPPERCASEFLAG	String	1

Table 10: View Class Property Descriptions
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

Table 11: View Column Class Property Descriptions
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

Table 12: Index Class Property Descriptions
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: P (Primary) Q (Partitioned Primary Index) S (Secondary) J (join index) M (Multi-Column Statistics) D (Derived column partition statistics) N (hash index) K (primary key) U (unique constraint) V (value ordered secondary) H (hash ordered ALL covering secondary) G (Geospatial non-unique secondary) O (valued ordered ALL covering secondary) I (ordering column of a composite secondary index) 1 (field1 column of a join or hash index) 2 (field2 column of a join or hash index)	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

Table 13: IndexColumn Class Property Descriptions
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

Table 14: Check Class Property Descriptions
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

Table 15: Reference Class Property Descriptions
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

Table 16: ReferenceColumn Class Property Descriptions
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

Table 17: Node Class Property Descriptions
Property Name	Description	Property ID	Type	Size
NodeStatus	U = node is up. D = node is unavailable	PID_NODE_NODESTATUS	String	1

Table 18: StoredProcedure Class Property Descriptions
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

Table 19: SPParameter Class Property Descriptions
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 "O" = OUT "B" = INOUT	PID_SPPARAMETER_SPPARAMTYPE	String	1

Table 20: Trigger Class Property Descriptions
Property Name	Description	Property ID	Type	Size
ActionTime	Action time for the trigger: “A” = After the trigger event “B” = Before the trigger event “I” = Instead of 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 “I” = Insert “U” = Update	PID_TRIGGER_EVENT	String	1
IsEnabled	Whether the trigger is activated or not “Y” = Enabled “N”= Disabled	PID_TRIGGER_ENABLED	String	1
Kind	Trigger kind as defined by the FOR EACH clause “R” = Row “S” = Statement	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 TimeStamp	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

Table 21: Macros Class Property Descriptions
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

Table 22: MacroParameter Class Property Descriptions
Property Name	Description	Property ID	Type	Size
CharType	Specifies the character set type of character fields. Values can be: 1 Latin 2 Unicode 3 KanjiSJIS 4 Graphic 5 Kanji1	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

Table 23: JoinIndex Properties
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 Stamp	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

Table 24: HashIndex Properties
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 Stamp	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

Table 25: SubjectArea Class Property Descriptions
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

Table 26: BusinessEntity Class Property Descriptions
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

Table 27: BusinessAttribute Class Property Descriptions
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

Table 28: BusinessRule Class Property Descriptions
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

Table 29: ValidValues Class Property Descriptions
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

Table 30: MetaLoadTypeClass Property Descriptions
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

Table 31: Function Class Property Descriptions
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 Valid values are: UDF = general user defined function UDF: Method = user defined function that is defined within a User Defined Type (UDT) UDF: Aggregate = user defined aggregate function UDF: Ordered analytical = user defined ordered analytic window aggregate function UDF: Table UDF = user defined table function UDF: Teradata Internal = a UDF used internally by the Teradata Database UDT: Constructor = a user defined function that is the constructor for a UDT	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

Table 32: Constant Class Property Descriptions
Property Name	Description		Property ID	Type	Size
ConstantType	The type of the constant Valid values are: ACCOUNT * ACTIVITY_COUNT ALL ANSIDATE ASCII AUTOTEMP BIGINT BINARY CHARSET_COLL CHAR_SET_GRAPHIC CURRDATE * CURRENT_ROLE CURRENT_USER CURRTIME * CURRTIMESTAMP * DATABASE * DATE * DECIMAL DEFAULT DQUOTESTR EBCDIC FLOAT HEXSTR HIGH HOST INTEGER INTEGERDATE JIS_COLL KANJI KANJISJIS LATIN1 LOCAL	LOW MANUAL MULTINATIONAL MEDIUM NAME NEVER NULL OFF PARMNAME PREPARE_COUNT PROFILE * ROLE * SESSION * SOURCE_TIME_ZONE SQLCODE SQLSTATE SQUOTESTR STAR TEMPORAL_DATE TEMPORAL_TIMESTAMP TIME * UNICODE UNKNOWN USER * ZONE*	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:

If a constant is used in an expression with a table column or function, the constant and expression are not stored in the repository. Only the column or function are stored and associated with the view column.

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.

If a function is used in combination with other functions, each individual function is stored in the repository and associated with the view column, whereas the combination of functions is 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.

Operators that are used to combine functions are not stored in the repository.

Table 33: UDT Class Property Descriptions
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

Table 34: UDTAttribute Class Property Descriptions
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 1 Latin 2 Unicode 3 KanjiSJIS 4 Graphic 5 Kanji1	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

Table 35: UDTCast Class Property Descriptions
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_ PRIMARYTYPEID	Binary	6
ThisUDTIsTheSource	Is the UDT for which this CAST is defined the source data type? Y or N	PID_UDTCAST_ THISUDTISTHESOURCE	CHAR	1
SourceDataType	The data type of the source value; two-character code matching DBC.TVFields. FieldType	PID_UDTCAST_ SOURCEDATATYPE	CHAR	2
TargetDataType	The data type of the target value; two-character code matching DBC.TVFields.FieldType	PID_UDTCAST_ TARGETDATATYPE	CHAR	2
NonUDTLength	If the source or target is a predefined type, this is the maximum length of the type	PID_UDTCAST_ NONUDTLENGTH	INTEGER
NonUDTDigits	If the source or target is a predefined type, this is the number of digits in a numeric value	PID_UDTCAST_ NONUDTDIGITS	SMALLINT
NonUDTImpliedPoint	If the source or target is a predefined type, this is the number of digits after the decimal point	PID_UDTCAST_ NONUDTIMPLIEDPOINT	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_ NONUDTCHARTYPE	SMALLINT
Implicit Assignment	Is the CAST routine called for an implicit assignment? Y or N	PID_UDTCAST_ IMPLICITASSIGNMENT	CHAR	1
RoutineID	DBC.TVM.TVMId value for the cast function; is '000000000000'XBF for Teradata internal routines	PID_UDTCAST_ ROUTINEID	BINARY	6
SynchronizationLevel	Internal flag	PID_UDTCAST_ SYNCLEVEL	SMALLINT

Table 36: FunctionParameter Class Property Descriptions
Property Name	Description	Property ID	Type	Size
CharacterSet	Character set for CHAR data types 1 Latin 2 Unicode 3 KanjiSJIS 4 Graphic 5 Kanji1	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

Table 37: Partitioning Class Property Descriptions
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