Category: Accounting
Database: DBC
View Column | Data Type | Format | Comment |
---|---|---|---|
UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the Teradata Database userid of the user who is currently logged on. |
AccountName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Expanded account in effect when a request was submitted. SYSTEMACCOUNTNO tracks console utility activity such as table rebuild, Diskcopy, or Scandisk. |
SessionNo | INTEGER NOT NULL | --,---,---,--9 | Returns the session identifier assigned to the session by the TDP or LAN interface. |
DefaultDataBase | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the name of the current default database for the user. |
IFPNo | SMALLINT NOT NULL | -(5)9 | Returns the vproc number of the PE through which the session was connected or assigned. |
Partition | CHAR(16) LATIN NOT CASESPECIFIC | X(16) | Returns the name of the Teradata Database partition to which the user is currently attached. |
LogicalHostId | SMALLINT NOT NULL | -(5)9 | Returns a unique identifier of the logon source for the logged query. A value of zero indicates an internal session. |
HostNo | SMALLINT NOT NULL | ---,--9 | Returns the number of the client system through which the user logged on to the Teradata Database. |
CurrentCollation | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | Returns the current collation of the session. |
LogonDate | DATE NOT NULL | YY/MM/DD | Returns the date that the session for which the log entry was made was logged on to the Teradata Database. |
LogonTime | FLOAT NOT NULL | 99:99:99.99 | Returns the time on which logon for the session occurred (useful on logoff events). |
LogonSequenceNo | BYTE(4) | X(8) | Returns the logon sequence number of the session. |
LogonSource | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Channel-Attached Systems Using the CLIv2 API Returns the origin of the CLIv2 mainframe session being reported, such as the user ID or session number of the client system. |
ExpiredPassword | CHAR(1) LATIN UPPERCASE | X(1) | Returns a code that indicates whether or not the defined session is in the process of a logon for a user with an expired password. |
TwoPCMode | VARCHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns one of the following codes: 2 = 2PC mode, N = non-2PC mode. |
Transaction_Mode | VARCHAR(1) LATIN NOT CASESPECIFIC | X(1) | Returns one of the following codes to indicate the mode of the session: T = TDBS, A = ANSI. |
CurrentRole | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the current role for a session. |
ProfileName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the profile. |
LogonAcct | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Returns the account string used when a session is established. |
LDAP | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | The LDAP column denotes how a directory user for a given session is mapped. The column displays one of these options: P means "permanent user", X means "external user" and N means "not externally authenticated". |
AuditTrailId | VARCHAR(128) UNICODE UPPERCASE NOT NULL | X(128) | Returns the identifier that is used for access logging. |
CurIsolationLevel | VARCHAR(16) UNICODE NOT CASESPECIFIC | X(16) | Returns the isolation level; SR - Serializable; RU - Read uncommitted; RC - Read Committed; RR - Repeatable Read. |
QueryBand | VARCHAR(4096) UNICODE NOT CASESPECIFIC | X(4096) | Returns the band under which the query is submitted. |
ProxyUser | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the proxy user. |
ProxyCurRole | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the current role of the proxy user. |
TemporalQualifier | VARCHAR(1024) LATIN NOT CASESPECIFIC | X(1024) | DBC.SESSIONINFOVX.TemporalQualifier is used to reset the qualifier in the session across a database restart |
CalendarName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | The SESSIONINFOVX.CalendarName column describes the calendar set in the session |
ExtendedLogonSource | VARCHAR(2048) UNICODE NOT CASESPECIFIC | X(2048) | The ExtendedLogonSource column is an identification of the place from where the user accessed the system |
ClientIpAddress | VARCHAR(45) UNICODE NOT CASESPECIFIC | X(45) | The ClientIpAddress column is the standard text representation of the IP address where the user accessed the system |
ClientProgramName | VARCHAR(1024) UNICODE NOT CASESPECIFIC | X(1024) | The ClientProgramName is the client system program name |
ClientSystemUserId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientSystemUserId is the client user id |
ClientConnectionType | BYTEINT | -(3)9 | The ClientConnectionType is 1 for TCP/IP or 2 for Channel connect |
ClientCoordName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientCoordName is the Coordinator name for clients using CICS or IMS |
ClientEnvName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientEnvName is the TDP Environment Name |
ClientJobId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientJobId is the TDP Job ID |
ClientJobName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientJobName is the TDP Job Name |
ClientOsName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientOsName is the TDP Operating System Name |
ClientProcThreadId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientProcThreadId is the client process/thread identifier |
ClientSecProdGrp | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientSecProdGrp is the TDP Security Product Group |
ClientSecProdUserId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientSecProdUserId is TDP Security Product Userid |
ClientTcpPortNumber | INTEGER | --,---,---,--9 | The ClientTcpPortNumber is the TCP port number on the client system |
ClientTdHostName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientTdHostName is the Teradata Database hostname that the client used to connect to the Teradata Database |
ClientTerminalId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientTerminalId is TDP Terminal Identifier |
ClientTransactionId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientTransactionId is TDP Transaction Identifier |
ClientUserOperId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientUserOperId is the TDP User/Operator Identifier |
ClientVmName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientVmName is the TDP Virtual Machine Name |
ClientVmUserId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientVmUserId is the TDP Virtual Machine User Id |
MechanismName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The MechanismName is authentication method used to authenticate the user |
ClientTDPReleaseId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientTDPReleaseId is the TDP Release Identifier |
ClientCLIv2ReleaseId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientCLIv2ReleaseId is the CLIv2 Release Identifier |
ClientSessionDesc | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientSessionDesc is the TDP session description |
ClientWorkload | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientWorkload is the TDP Workload |
ClientJobData | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The ClientJobData is the client Job Data from the LSINFO environmental variable |
ClientODBCDriverVersion | VARCHAR(16) UNICODE NOT CASESPECIFIC | X(16) | The ClientODBCDriverVersion is the client ODBC Driver Version |
ClientNetDataProviderVersion | VARCHAR(16) UNICODE NOT CASESPECIFIC | X(16) | The ClientNetDataProviderVersion is the client .NET Data Provider Version |
ClientODBCDriverManagerVersion | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | The ClientODBCDriverManagerVersion is the client ODBC Driver Manager Version |
ClientNetFrameworkVersion | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | The ClientNetFrameworkVersion is the client .NET Framework Version |
ClientAttributesEx | VARCHAR(512) UNICODE NOT CASESPECIFIC | X(512) | The ClientAttributesEx field contains extra description of the client that do not match any of the other Client Attributes fields |
ClientJDBCDriverVersion | VARCHAR(16) UNICODE NOT CASESPECIFIC | X(16) | The ClientJDBCDriverVersion is the client JDBC Driver Version |
ClientJavaVersion | VARCHAR(30) UNICODE NOT CASESPECIFIC | X(30) | The ClientJavaVersion is the client Java Framework Version |
ExportDefinitionName | VARCHAR(30) LATIN NOT CASESPECIFIC | X(30) | The ExportDefinitionName is the current ExportDefinitionName of the session that is inherited from the user when a session is logged on. |
ExportWidthRuleSet | BYTE(20) | X(40) | The ExportWidthRuleSet is the current ExportWidthRuleSet of the session that is inherited from the user when a session is logged on. It is maintained for the duration of the session (even if the user is modified while the session is active). |
RecoverableNetworkProtocol | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | The RecoverableNetworkProtocol column indicates whether the client supports the RecoverableNetwork client-database interface |
LogonRedrive | VARCHAR(33) UNICODE NOT CASESPECIFIC | X(33) | The LogonRedrive column indicates the sessions participation in Redrive |
ClientIPAddrByClient | VARCHAR(45) UNICODE NOT CASESPECIFIC | X(45) | Client IP Address by Client |
ClientPortByClient | INTEGER | --,---,---,--9 | Client Port by Client |
ServerIPAddrByClient | VARCHAR(45) UNICODE NOT CASESPECIFIC | X(45) | Serve IP Address by Client |
ServerPortByClient | INTEGER | --,---,---,--9 | Server Port by Client |
ClientIPAddrByUnity | VARCHAR(45) UNICODE NOT CASESPECIFIC | X(45) | Client IP Address by Unity |
ClientPortByUnity | INTEGER | --,---,---,--9 | Client Port by Unity |
UnityClientSideIPAddr | VARCHAR(45) UNICODE NOT CASESPECIFIC | X(45) | Unity Client Side IP Address |
UnityClientSidePort | INTEGER | --,---,---,--9 | Unity Client Side Port |
UnityServerSideIPAddr | VARCHAR(45) UNICODE NOT CASESPECIFIC | X(45) | Unity Server Side IP Address |
UnityServerSidePort | INTEGER | --,---,---,--9 | Unity Server Side Port |
ServerIPAddrByUnity | VARCHAR(45) UNICODE NOT CASESPECIFIC | X(45) | Server IP Address by Unity |
ServerPortByUnity | INTEGER | --,---,---,--9 | Server Port by Unity |
ServerIPAddrByServer | VARCHAR(45) UNICODE NOT CASESPECIFIC | X(45) | Server IP Address by Server |
ServerPortByServer | INTEGER | --,---,---,--9 | Server Port by Server |
ClientCOPSuffixedHostName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Client COP Suffixed Hostname |
UnitySessNo | INTEGER | --,---,---,--9 | Unity Session Number |
UnityVersion | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Unity Version |
UnityAuthMechName | VARCHAR(1571) UNICODE NOT CASESPECIFIC | X(1571) | Unity Authorized Mechanism Name |
UnityMechanismName | VARCHAR(1571) UNICODE NOT CASESPECIFIC | X(1571) | Unity Mechanism Name |
UserAuthenticatedBy | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | User Authenticated by |
ClientTDSessionPoolName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Client TD Session Pool Name |
UnityTcpPortNumber | INTEGER | --,---,---,--9 | Unity TCP Port Number |
UnityIpAddress | VARCHAR(45) UNICODE NOT CASESPECIFIC | X(45) | Unity IP Address |
TTGranularity | VARCHAR(30) UNICODE NOT CASESPECIFIC | X(30) | The SESSIONINFOVX.TTGranularity column describes the Transaction Time Granularity set in the session |
LoadingOp | CHAR(1) LATIN UPPERCASE | X(1) | The LoadingOp is set to "T" when session isolated loading is enabled and "F" when session isolated loading is disabled. |
UnicodePassThrough | CHAR(1) LATIN UPPERCASE | X(1) | The SessionInfoV.UnicodePassThrough returns the Unicode Pass Through attribute of the session. |
DirUserNetConfidentiality | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | This column contains the user's network confidentiality policy that applies on the connection between the client and the gateway or between the client and Unity, obtained from the LDAP directory used for security policy. |
DirUserNetPolicyLevel | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | When DirUserNetConfidentiality is "I" or "C", this column contains the level of protection required, obtained by lookup in the LDAP directory used for security policy. |
UnityNetConfidentiality | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | This column contains the user's network confidentiality policy that applies on the connection between Unity and the gateway, obtained from the LDAP directory used for security policy. |
UnityNetPolicyLevel | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | When UnityNetConfidentiality is "I" or "C", this column contains the level of protection required, obtained by lookup in the LDAP directory used for security policy. |
EffectiveSessionNetConf | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | This column contains the effective network confidentiality policy for the session, that applies on the connection between the client and the gateway or between the client and Unity, integrated from all sources of security policy that do not change. |
EffectiveSessionNetPolicyLevel | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | When EffectiveSessionNetConfidentiality is "I" or "C", this column contains the level of protection required, integrated from all sources of security policy that do not change within a session. |
ProxyLogon | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | The ProxyLogon column indicates T if logon request uses Passwordless Proxy for TD2. |
ClientConfType | CHAR(1) LATINC | X(1) | The ClientConfType column indicates Client Confidentiality Type. |
ServerConfType | CHAR(1) LATINC | X(1) | The ServerConfType column indicates Server Confidentiality Type. |
UnityConfType | CHAR(1) LATINC | X(1) | The UnityConfType column indicates Unity Confidentiality Type. |
ServerUnityConfType | CHAR(1) LATINC | X(1) | The ServerUnityConfType column indicates Server Unity Confidentiality Type. |
ClientConfVersion | VARCHAR(16) LATIN NOT CASESPECIFIC | X(16) | The ClientConfVersion column indicates Client TLS version number. |
ClientConfCipherSuite | VARCHAR(64) LATIN NOT CASESPECIFIC | X(64) | The ClientConfCipherSuite column indicates Client TLS cipher suite. |
UnityConfVersion | VARCHAR(16) LATIN NOT CASESPECIFIC | X(16) | The UnityConfVersion column indicates Unity TLS version number. |
UnityConfCipherSuite | VARCHAR(64) LATIN NOT CASESPECIFIC | X(64) | The UnityConfCipherSuite column indicates Unity TLS cipher suite. |
TimeZoneString | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the time zone string set for the user session. |