com.tivoli.twg.inventory
Class TWGSystemUserTable

java.lang.Object
  extended bycom.tivoli.twg.engine.TWGObject
      extended bycom.tivoli.twg.engine.TWGPersistentObject
          extended bycom.tivoli.twg.engine.TWGDatabaseTable
              extended bycom.tivoli.twg.inventory.TWGSystemUserTable

public class TWGSystemUserTable
extends TWGDatabaseTable

SQL database table for System User information

Primary key - MANAGED_OBJ_ID

TWG_SYSTEM_USER
Field Name Data Type Description NT/2000 95/98 OS/2 Netware AS/400 SNMP AIX HPUX Solaris Unixware Linux
MANAGED_OBJ_ID INT Managed object id X X X X X X X X
FIRST_NAME CHAR(32) First Name X X X X X X X X
MIDDLE_NAME CHAR(32) Middle Name X X X X X X X X
LAST_NAME CHAR(32) Last Name X X X X X X X X
EMPLOYEE_ID CHAR(32) Employee ID X X X X X X X X
TITLE CHAR(32) Title X X X X X X X X
DEPT_NAME CHAR(32) Department Name X X X X X X X X
DEPT_NUMBER CHAR(32) Department Number X X X X X X X X
DIVISION CHAR(32) Division X X X X X X X X
WORK_PHONE CHAR(32) Work Phone Number X X X X X X X X
CELLULAR_PHONE CHAR(32) Cellular Phone Number X X X X X X X X
FAX_NUMBER CHAR(32) Fax Machine Phone Number X X X X X X X X
PAGER_NUMBER CHAR(32) Pager Phone Number X X X X X X X X
PAGER_TYPE CHAR(32) Numeric, AlphaNumberic, etc X X X X X X X X
EMAIL_ADDRESS CHAR(128) E-mail Address X X X X X X X X
HOME_PHONE CHAR(32) Home Phone Number X X X X X X X X


Note: For NT/2000 and 95/98, these fields are populated only if the client manually updates twguser.ini in \TivoliWg\data
Note: For OS/2, these fields are populated only if the client manually updates twguser.ini in \TivoliWg
Note: For AIX, these fields are populated only if the client manually updates TWGUser.properties in /usr/opt/tivoliwg/data
Note: For HPUX, Solaris, Unixware, Linux, these fields are populated only if the client manually updates TWGUser.properties in /opt/tivoliwg/data


Field Summary
static java.lang.String CELLULAR_PHONE
           
static java.lang.String DEPT_NAME
           
static java.lang.String DEPT_NUMBER
           
static java.lang.String DIVISION
           
static java.lang.String EMAIL_ADDRESS
           
static java.lang.String EMPLOYEE_ID
           
static java.lang.String FAX_NUMBER
           
static java.lang.String FIRST_NAME
           
static java.lang.String HOME_PHONE
           
static java.lang.String LAST_NAME
           
static java.lang.String MANAGED_OBJ_ID
           
static java.lang.String MIDDLE_NAME
           
static java.lang.String PAGER_NUMBER
           
static java.lang.String PAGER_TYPE
           
static java.lang.String TABLE_NAME
           
static java.lang.String TABLE_VERSION
           
static java.lang.String TITLE
           
static java.lang.String WORK_PHONE
           
 
Fields inherited from class com.tivoli.twg.engine.TWGDatabaseTable
CLASSNAME, DbKeyWords, DEFAULT_TABLE_BUNDLE_NAME, validChars
 
Fields inherited from class com.tivoli.twg.engine.TWGPersistentObject
CLASS_NAME, SIZEOF_BYTE, SIZEOF_CHAR, SIZEOF_DOUBLE, SIZEOF_FLOAT, SIZEOF_INT, SIZEOF_LONG, SIZEOF_SHORT
 
Constructor Summary
TWGSystemUserTable()
           
 
Method Summary
 void create()
          Abstract method must be overriden by subclass to define the table.
 java.lang.String getTableVersion()
          Abstract method must be overriden by subclass to get the version for table
 
Methods inherited from class com.tivoli.twg.engine.TWGDatabaseTable
deleteManagedObject, deleteTable, findTableByClassName, flatten, getAllFullColumnNames, getAllTrue, getAllTrueForSame, getAnyTrue, getBundleName, getBundleString, getColumn, getColumnByColumnRealName, getColumnLength, getColumnLength, getColumnLengths, getColumns, getColumnType, getColumnType, getColumnTypes, getDatabase, getDefaultValue, getDefaultValue, getDefaultValues, getDisplayColumnName, getDisplayFullColumnNames, getDisplayName, getDisplayValues, getEachTrueForAtLeastOne, getFilterColumns, getFilterPrompt, getFilterSQL, getGraphicName, getKey, getMatchingMoids, getMultiLocaleBundle, getMyClassName, getNumberOfColumns, getRealColumnName, getRealColumnName, getRealColumnNames, getRealName, getShortClassName, getTable, getTableBy, getTableByRealTableName, getTableInfo, getTableMultiLocaleBundle, getTableName, getTables, getTokenColumnNames, getTokenName, insertOrDeleteRow, insertRow, isFilterColumn, isMappedColumn, restoreData, saveData, setShortTableName, toString, TWGInitTable, userTableFixClassName
 
Methods inherited from class com.tivoli.twg.engine.TWGPersistentObject
Destroy, enableAsyncWrites, fromPersistID, initialize, isNewPersistentStore, isSaveRequired, PersistID, restore, restoreAll, save, save, setSaveRequired, terminate, toPersistID
 
Methods inherited from class com.tivoli.twg.engine.TWGObject
AllObjects, AllObjects, Delete, DumpTWGObjects, FindObject, isDeleted, isNewObject, isPersistent, isPersistent, isValid, isValid, ObjectID, setDistinctObjectID, SetObjectID
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Field Detail

TABLE_NAME

public static final java.lang.String TABLE_NAME
See Also:
Constant Field Values

MANAGED_OBJ_ID

public static final java.lang.String MANAGED_OBJ_ID
See Also:
Constant Field Values

FIRST_NAME

public static final java.lang.String FIRST_NAME
See Also:
Constant Field Values

MIDDLE_NAME

public static final java.lang.String MIDDLE_NAME
See Also:
Constant Field Values

LAST_NAME

public static final java.lang.String LAST_NAME
See Also:
Constant Field Values

EMPLOYEE_ID

public static final java.lang.String EMPLOYEE_ID
See Also:
Constant Field Values

TITLE

public static final java.lang.String TITLE
See Also:
Constant Field Values

DEPT_NAME

public static final java.lang.String DEPT_NAME
See Also:
Constant Field Values

DEPT_NUMBER

public static final java.lang.String DEPT_NUMBER
See Also:
Constant Field Values

DIVISION

public static final java.lang.String DIVISION
See Also:
Constant Field Values

WORK_PHONE

public static final java.lang.String WORK_PHONE
See Also:
Constant Field Values

CELLULAR_PHONE

public static final java.lang.String CELLULAR_PHONE
See Also:
Constant Field Values

FAX_NUMBER

public static final java.lang.String FAX_NUMBER
See Also:
Constant Field Values

PAGER_NUMBER

public static final java.lang.String PAGER_NUMBER
See Also:
Constant Field Values

PAGER_TYPE

public static final java.lang.String PAGER_TYPE
See Also:
Constant Field Values

EMAIL_ADDRESS

public static final java.lang.String EMAIL_ADDRESS
See Also:
Constant Field Values

HOME_PHONE

public static final java.lang.String HOME_PHONE
See Also:
Constant Field Values

TABLE_VERSION

public static final java.lang.String TABLE_VERSION
See Also:
Constant Field Values
Constructor Detail

TWGSystemUserTable

public TWGSystemUserTable()
Method Detail

create

public void create()
            throws TWGDbException
Description copied from class: TWGDatabaseTable
Abstract method must be overriden by subclass to define the table.

Specified by:
create in class TWGDatabaseTable
Throws:
TWGDbException

getTableVersion

public java.lang.String getTableVersion()
Description copied from class: TWGDatabaseTable
Abstract method must be overriden by subclass to get the version for table

Specified by:
getTableVersion in class TWGDatabaseTable
Returns:
the version id for this table