EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  3. Topics

KB17189: How to convert default attribute element values to NULL elements in MicroStrategy Architect 10.x

Community Admin

• Strategy

In many databases, it is common for columns to have a 'default' value set so that if data is not inputted into the column some value still exists. This can be done for a number of reasons and the designer of the database should be consulted for the exact reason. In any event, there are times these default values have no meaning and MicroStrategy Architects would like them to be treated and considered as standard NULL values.

In many databases, it is common for columns to have a 'default' value set so that if data is not inputted into the column some value still exists. This can be done for a number of reasons and the designer of the database should be consulted for the exact reason. In any event, there are times these default values have no meaning and Strategy Architects would like them to be treated and considered as standard NULL values.
 
In order for Strategy to effectively treat an attribute element as a NULL value, the element value needs to be returned to Strategy as a NULL. This must be accomplished outside of Strategy. However, Strategy does have a method for providing database specific SQL to be passed directly to the database; this is accomplished with the ApplySimple statement.
 
The following example will walk through how to setup an attribute form that converts a default datetime value in Microsoft SQL Server 2000 into a NULL value. For the purpose of this example, the warehouse table will have the following definition; no column is allowed to contain NULL values:
 

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

For the purpose of this example, the LASTMODIFIED column was added after the table was created and populated with data. This required the existence of a default value since NULL values are not allowed in the table. After some user updates the table contains the following sample data:
 

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

After adding the table to the warehouse catalog, an attribute named User is created with the following definition:
 

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

With this definition the data returned in any report will be exactly what is stored in the database. However, those users who still have the default value will report that they were last modified at the turn of the 20th century. From a reporting standpoint this makes no sense and it would be more logical to see that the last modified time does not exist (i.e. is NULL). To accomplish this, the expression for the form needs to be modified to translate all of the default values into NULL values.
 
The following steps outline how to translate specific data values into NULL values by modifying the attribute form expression:

  • Edit the attribute.
  • On the 'Forms' tab highlight the desired attribute form row and press the 'Modify…' button, as shown below:
ka04W000000OhCJQA0_0EM440000002F4X.jpeg
  • In the new attribute form window select the form expression and click 'Modify…' as shown below:
ka04W000000OhCJQA0_0EM440000002F4N.jpeg
  • Encapsulate the existing attribute form in an ApplySimple statement which contains the necessary database specific logic to match a value and return:
ka04W000000OhCJQA0_0EM440000002F4P.jpeg
  • ApplySimple("CASE WHEN #0= '1900-01-01' THEN NULL ELSE #0 END", )
    Note: This ApplySimple statement is only provided as an example of how to accomplish the above method for Microsoft SQL Server 2000. Customizations are not provided and users are encouraged to contact their DBA to do so.
     
  • Click OK to exit the form expression editor and save the change.
  • Click OK to save the changes to the form.
  • Save and close the attribute.

The ApplySimple statement will pass the SQL change directly to the database. This will ensure that the NULL values are returned to Strategy as part of the database data. Strategy will treat these NULL values as it would any other NULL value that is actually stored in the database.
 

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

 
Column NameData TypeDefault ValueUSER_IDINT USER_NAMEVARCHAR(50) DEPT_IDINT0REGION_IDINT0LASTMODIFIEDTIMESTAMP1900-01-01USER_IDUSER_NAMEDEPT_IDREGION_IDLASTMODIFIED456Turing, Alan15211900-01-011731Hellman, Martin152371945-10-021892Rivest, Ronald2312004-08-172645Babbage, Charles12351900-01-014654Diffie, Whitfield156571900-01-014789Dijkstra, Edsger Wybe31472002-08-067859Gosling, James34541955-05-19Form nameForm categoryFormat typeExpressionIDIDNumberUSER_IDNameDESCTEXTUSER_NAMELast ModifiedNoneDatetimeLASTMODIFIEDUSERLASTMODIFIEDTuring, Alan Hellman, Martin1945-10-02Rivest, Ronald2004-08-17Babbage, Charles Diffie, Whitfield Dijkstra, Edsger Wybe2002-08-06Gosling, James1955-05-19

Comment

0 comments

Details

Knowledge Article

Published:

May 31, 2017

Last Updated:

May 31, 2017