Skip Headers
Oracle® Fusion Middleware Reference for Oracle Identity Management
11g Release 1 (11.1.1)
E10035-04
  Go To Table Of Contents
Contents		 Go To Index
Index
Previous
Previous 		 Next
Next		  

9 Oracle Adaptive Access Manager Database Schema

This document describes the Oracle Adaptive Access Manager tables.

9.1 Database/Application Objects

9.1.1 List of All Classes

9.1.2 Tables and Index in category 1

Class Name Table Name Table TS Index TS Table Initrans Index Initrans
VCryptAccount VCRYPT_ACCOUNTS BRSATBS1 BRSAINDX1 2 2
VCryptAccountHist VCRYPT_ACCOUNTS_HIST BRSATBS1 BRSAINDX1 2 2
VCryptUserGroup VCRYPT_USER_GROUPS BRSATBS1 BRSAINDX1 2 2
VCryptUserRole VCRYPT_USER_ROLES BRSATBS1 BRSAINDX1 2 2
VCryptUserGroupRoleMap VCRYPT_USERGROUP_ROLE_MAPS BRSATBS1 BRSAINDX1 2 2
VCryptUserHist VCRYPT_USERS_HIST BRSATBS1 BRSAINDX1 2 2
VQuestionCategory V_Q_CATEGORY BRSATBS1 BRSAINDX1 2 2
VQuestionCategoryHist V_Q_CATEGORY_HIST BRSATBS1 BRSAINDX1 2 2
VCryptUserQuestion V_USER_QUESTIONS BRSATBS1 BRSAINDX1 2 2
VCryptUserQuestionHist V_USER_QUESTIONS_HIST BRSATBS1 BRSAINDX1 2 2
VCryptQuestionGlobalValidation V_Q_GLOBAL_VALID BRSATBS1 BRSAINDX1 2 2
VCryptQuestionGlobalValidationHist V_Q_GLOBAL_VALID_HIST BRSATBS1 BRSAINDX1 2 2
VCryptQuestionValidationMap V_Q_VALIDATION_MAP BRSATBS1 BRSAINDX1 2 2
VCryptQuestionValidationMapHist V_Q_VALIDATION_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VCryptValidation V_VALIDATION BRSATBS1 BRSAINDX1 2 2
VCryptValidationHist V_VALIDATION_HIST BRSATBS1 BRSAINDX1 2 2
VCryptGlobalAnswerHint V_GLOBAL_ANS_HINT BRSATBS1 BRSAINDX1 2 2
VCryptGlobalAnswerHintHist V_GLOBAL_ANS_HINT_HIST BRSATBS1 BRSAINDX1 2 2
VCryptQuestionAnswerHintMap V_Q_ANS_HINT_MAP BRSATBS1 BRSAINDX1 2 2
VCryptQuestionAnswerHintMapHist V_Q_ANS_HINT_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VCryptAnswerHint V_ANS_HINT BRSATBS1 BRSAINDX1 2 2
VCryptAnswerHintHist V_ANS_HINT_HIST BRSATBS1 BRSAINDX1 2 2
VCryptUserQA V_USER_QA BRSATBS1 BRSAINDX1 2 2
VCryptUserQAHist V_USER_QA_HIST BRSATBS1 BRSAINDX1 2 2
VCryptScoringPolicy V_SCORING_POLICY BRSATBS1 BRSAINDX1 2 2
VCryptScoringPolicyHist V_SCORING_POLICY_HIST BRSATBS1 BRSAINDX1 2 2
VCryptScoreAttributes V_SCORE_ATTR BRSATBS1 BRSAINDX1 2 2
VCryptScoreAttributesHist V_SCORE_ATTR_HIST BRSATBS1 BRSAINDX1 2 2
VMonitorData V_MONITOR_DATA BRSATBS1 BRSAINDX1 2 2
VBharosaConfig V_B_CONFIG BRSATBS1 BRSAINDX1 2 2
VBharosaConfigHist V_B_CONFIG_HIST BRSATBS1 BRSAINDX1 2 2
VBharosaEnum V_B_ENUM BRSATBS1 BRSAINDX1 2 2
VBharosaEnumHist V_B_ENUM_HIST BRSATBS1 BRSAINDX1 2 2
VBharosaEnumElement V_B_ENUM_ELMNT BRSATBS1 BRSAINDX1 2 2
VBharosaEnumElementHist V_B_ENUM_ELMNT_HIST BRSATBS1 BRSAINDX1 2 2
VBharosaEnumElementAttribute V_B_ENUM_ELMNT_ATTR BRSATBS1 BRSAINDX1 2 2
VBharosaEnumElementAttributeHist V_B_ENUM_ELMNT_ATTR_HIST BRSATBS1 BRSAINDX1 2 2
VBharosaLocale V_B_LOCALE BRSATBS1 BRSAINDX1 2 2
VBharosaLocaleHist V_B_LOCALE_HIST BRSATBS1 BRSAINDX1 2 2
VBharosaConfigRB V_B_CONFIG_RB BRSATBS1 BRSAINDX1 2 2
VPattern V_PATTERN BRSATBS1 BRSAINDX1 2 2
VPatternHist V_PATTERN_HIST BRSATBS1 BRSAINDX1 2 2
VPatternEntity V_PATTERN_ENTITY BRSATBS1 BRSAINDX1 2 2
VPatternEntityHist V_PATTERN_ENTITY_HIST BRSATBS1 BRSAINDX1 2 2
VPatternParam V_PATTERN_PARAM BRSATBS1 BRSAINDX1 2 2
VPatternParamHist V_PATTERN_PARAM_HIST BRSATBS1 BRSAINDX1 2 2
VPatternEntityOperation V_PAT_ENT_OPER BRSATBS1 BRSAINDX1 2 2
VPatternEntityOperationHist V_PAT_ENT_OPER_HIST BRSATBS1 BRSAINDX1 2 2
VCryptFingerPrint V_FPRINTS BRSATBS1 BRSAINDX1 2 2
VCryptFPNameValue V_FP_NV BRSATBS1 BRSAINDX1 2 2
VCryptFPMap V_FP_MAP BRSATBS1 BRSAINDX1 2 2
VCryptUserLog VCRYPT_USER_LOGS BRSATBS1 BRSAINDX1 2 2
VCryptPinReset VCRYPT_PIN_RESETS BRSATBS1 BRSAINDX1 2 2
VCryptPinRetrieval VCRYPT_PIN_RETRIEVALS BRSATBS1 BRSAINDX1 2 2
VCryptAuthSessionGroup VCRYPT_AUTH_SESSION_GROUPS BRSATBS1 BRSAINDX1 2 2
VCryptAuthSession VCRYPT_AUTH_SESSIONS BRSATBS1 BRSAINDX1 2 2
VCryptAuthAttempt VCRYPT_AUTH_ATTEMPTS BRSATBS1 BRSAINDX1 2 2
VCryptSystemMessage VCRYPT_SYS_MESSAGES BRSATBS1 BRSAINDX1 2 2
VSystemLogs V_SYS_LOGS BRSATBS1 BRSAINDX1 2 2
VCryptDBPatch VCRYPT_DB_PATCHES BRSATBS1 BRSAINDX1 2 2
VActionLogSession V_ACTION_LOG_SESS BRSATBS1 BRSAINDX1 2 2
VActionLog V_ACTION_LOGS BRSATBS1 BRSAINDX1 2 2
VTInvalidUser VT_INVALID_USERS BRSATBS1 BRSAINDX1 2 2
VTSessionActionMap VT_SESSION_ACTION_MAP BRSATBS1 BRSAINDX1 2 2
VTUserGroup VT_USER_GROUPS BRSATBS1 BRSAINDX1 2 2
VTWFYears VT_WF_YEARS BRSATBS1 BRSAINDX1 16 16
VTWFMonths VT_WF_MONTHS BRSATBS1 BRSAINDX1 16 16
VTWFDays VT_WF_DAYS BRSATBS1 BRSAINDX1 16 16
VTWFHours VT_WF_HOURS BRSATBS1 BRSAINDX1 16 16
VTTrxDef VT_TRX_DEF BRSATBS1 BRSAINDX1 2 2
VTTrxDefHist VT_TRX_DEF_HIST BRSATBS1 BRSAINDX1 2 2
VTTrxInputDef VT_TRX_INPUT_DEF BRSATBS1 BRSAINDX1 2 2
VTTrxInputDefHist VT_TRX_INPUT_DEF_HIST BRSATBS1 BRSAINDX1 2 2
VTEntityDef VT_ENTITY_DEF BRSATBS1 BRSAINDX1 2 2
VTEntityDefHist VT_ENTITY_DEF_HIST BRSATBS1 BRSAINDX1 2 2
VTTrxDefEntityDefMap VT_TRX_ENT_DEFS_MAP BRSATBS1 BRSAINDX1 2 2
VTTrxDefEntityDefMapHist VT_TRX_ENT_DEFS_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VTEntityDefEntityDefMap VT_ENT_DEFS_MAP BRSATBS1 BRSAINDX1 2 2
VTEntityDefEntityDefMapHist VT_ENT_DEFS_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VTDataDef VT_DATA_DEF BRSATBS1 BRSAINDX1 2 2
VTDataDefHist VT_DATA_DEF_HIST BRSATBS1 BRSAINDX1 2 2
VTDataDefElement VT_DATA_DEF_ELEM BRSATBS1 BRSAINDX1 2 2
VTDataDefElementHist VT_DATA_DEF_ELEM_HIST BRSATBS1 BRSAINDX1 2 2
VTDataDefMap VT_DATA_DEF_MAP BRSATBS1 BRSAINDX1 2 2
VTDataDefMapHist VT_DATA_DEF_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VTDataDefTranslation VT_DATA_DEF_TRANS BRSATBS1 BRSAINDX1 2 2
VTDataDefTranslationHist VT_DATA_DEF_TRANS_HIST BRSATBS1 BRSAINDX1 2 2
VTDataDefElementTranslation VT_ELEM_DEF_TRANS BRSATBS1 BRSAINDX1 2 2
VTDataDefElementTranslationHist VT_ELEM_DEF_TRANS_HIST BRSATBS1 BRSAINDX1 2 2
VTTranslationSourceElement VT_TRANS_SRC_ELEM BRSATBS1 BRSAINDX1 2 2
VTTranslationSourceElementHist VT_TRANS_SRC_ELEM_HIST BRSATBS1 BRSAINDX1 2 2
VCountry VCRYPT_COUNTRY BRSATBS1 BRSAINDX1 2 2
VCountryHist V_COUNTRY_HIST BRSATBS1 BRSAINDX1 2 2
VState VCRYPT_STATE BRSATBS1 BRSAINDX1 2 2
VStateHist V_STATE_HIST BRSATBS1 BRSAINDX1 2 2
VCity VCRYPT_CITY BRSATBS1 BRSAINDX1 2 2
VCityHist V_CITY_HIST BRSATBS1 BRSAINDX1 2 2
VISP VCRYPT_ISP BRSATBS1 BRSAINDX1 2 2
VISPHist V_ISP_HIST BRSATBS1 BRSAINDX1 2 2
VLocationLookup V_LOC_LOOKUP BRSATBS1 BRSAINDX1 2 2
VIPLocationMap VCRYPT_IP_LOCATION_MAP BRSATBS1 BRSAINDX1 2 2
VIPLocationMapHist V_IP_LOC_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VIPLocationMapSplit V_IP_LOC_MAP_SPLIT BRSATBS1 BRSAINDX1 2 2
VIPLocationMapSplitHist V_IP_LOC_MAP_SPLIT_HIST BRSATBS1 BRSAINDX1 2 2
VLocationUpdateSession V_LOC_UPD_SESS BRSATBS1 BRSAINDX1 2 2
VLocationUpdateLogs V_UPD_LOGS BRSATBS1 BRSAINDX1 2 2
VIPCluster VT_IP_CLUSTER BRSATBS1 BRSAINDX1 2 2
VIPClusterGroup VT_IP_CLUSTER_GROUP BRSATBS1 BRSAINDX1 2 2
VIPClusterGroupMap VT_IP_CLUSTER_GROUPMAP BRSATBS1 BRSAINDX1 2 2
VRuleVersion VR_VERSION BRSATBS1 BRSAINDX1 2 2
VRuleVersionHist VR_VERSION_HIST BRSATBS1 BRSAINDX1 2 2
VRuleVersionTree VR_VERSION_TREE BRSATBS1 BRSAINDX1 2 2
VRuleVersionMap VR_VERSION_MAP BRSATBS1 BRSAINDX1 2 2
VRule VCRYPT_RULE BRSATBS1 BRSAINDX1 2 2
VRuleHist VCRYPT_RULE_HIST BRSATBS1 BRSAINDX1 2 2
VRuleCondition VR_RULE_CONDN BRSATBS1 BRSAINDX1 2 2
VRuleConditionHist VR_RULE_CONDN_HIST BRSATBS1 BRSAINDX1 2 2
VRuleConditionScope VR_RULE_CONDN_SCOPE BRSATBS1 BRSAINDX1 2 2
VRuleConditionScopeHist VR_RULE_CONDN_SCOPE_HIST BRSATBS1 BRSAINDX1 2 2
VRuleConditionMap VR_RULE_CONDN_MAP BRSATBS1 BRSAINDX1 2 2
VRuleConditionMapHist VR_RULE_CONDN_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VRuleParam VCRYPT_RULE_PARAMS BRSATBS1 BRSAINDX1 2 2
VRuleParamHist VCRYPT_RULE_PARAMS_HIST BRSATBS1 BRSAINDX1 2 2
VRuleParamCustom VR_RULE_PARAM_CUSTOM BRSATBS1 BRSAINDX1 2 2
VRuleParamCustomHist VR_RULE_PARAM_CUSTOM_HIST BRSATBS1 BRSAINDX1 2 2
VProfile VCRYPT_PROFILE BRSATBS1 BRSAINDX1 2 2
VProfileHist VCRYPT_PROFILE_HIST BRSATBS1 BRSAINDX1 2 2
VProfileRuleMap VCRYPT_PROFILE_RULE_MAP BRSATBS1 BRSAINDX1 2 2
VProfileRuleMapHist VCRYPT_PROFILE_RULE_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VProfileListMap VCRYPT_PROFILE_LIST_MAP BRSATBS1 BRSAINDX1 2 2
VProfileListMapHist VCRYPT_PROFILE_LIST_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VRuleParamValue VCRYPT_RULE_PARAM_VALUES BRSATBS1 BRSAINDX1 2 2
VRuleParamValueHist VCRYPT_RULE_PARAM_VALUES_HIST BRSATBS1 BRSAINDX1 2 2
VRuleOverRide VR_OVERRIDE BRSATBS1 BRSAINDX1 2 2
VRuleOverRideHist VR_OVERRIDE_HIST BRSATBS1 BRSAINDX1 2 2
VRuleOverRideLog VR_OVERRIDE_LOGS BRSATBS1 BRSAINDX1 2 2
VRuleException VR_EXCEPTION BRSATBS1 BRSAINDX1 2 2
VRuleExceptionHist VR_EXCEPTION_HIST BRSATBS1 BRSAINDX1 2 2
VRuleSetRow VR_RULESET_ROW BRSATBS1 BRSAINDX1 2 2
VRuleSetRowHist VR_RULESET_ROW_HIST BRSATBS1 BRSAINDX1 2 2
VRuleSetColumn VR_RULESET_COL BRSATBS1 BRSAINDX1 2 2
VRuleSetColumnHist VR_RULESET_COL_HIST BRSATBS1 BRSAINDX1 2 2
VScoreAction VR_SCORE_ACTION BRSATBS1 BRSAINDX1 2 2
VScoreActionHist VR_SCORE_ACTION_HIST BRSATBS1 BRSAINDX1 2 2
VMaxBlock VR_MAX_BLOCKS BRSATBS1 BRSAINDX1 2 2
VMaxBlockHist VR_MAX_BLOCKS_HIST BRSATBS1 BRSAINDX1 2 2
VMaxBlockLogs VR_MAX_BLOCKS_LOGS BRSATBS1 BRSAINDX1 2 2
VPolicySetPkg V_POLICY_SET_PKG BRSATBS1 BRSAINDX1 2 2
VPolicySet VR_POLICY_SET BRSATBS1 BRSAINDX1 2 2
VPolicySetHist VR_POLICY_SET_HIST BRSATBS1 BRSAINDX1 2 2
VPolicy VR_POLICY BRSATBS1 BRSAINDX1 2 2
VPolicyHist VR_POLICY_HIST BRSATBS1 BRSAINDX1 2 2
VDynamicAction VR_DYN_ACTION BRSATBS1 BRSAINDX1 2 2
VDynamicActionHist VR_DYN_ACTION_HIST BRSATBS1 BRSAINDX1 2 2
VDynamicActionParam VR_DYN_ACT_PAR BRSATBS1 BRSAINDX1 2 2
VDynamicActionParamHist VR_DYN_ACT_PAR_HIST BRSATBS1 BRSAINDX1 2 2
VDynamicActionInstance VR_DYN_ACTION_INST BRSATBS1 BRSAINDX1 2 2
VDynamicActionInstanceHist VR_DYN_ACTION_INST_HIST BRSATBS1 BRSAINDX1 2 2
VDynamicActionParamValue VR_DYN_ACT_PAR_VAL BRSATBS1 BRSAINDX1 2 2
VDynamicActionParamValueHist VR_DYN_ACT_PAR_VAL_HIST BRSATBS1 BRSAINDX1 2 2
VDynamicActionExecLog VT_DYN_ACT_EXEC_LOG BRSATBS1 BRSAINDX1 2 2
VAlertTemplate VCRYPT_ALERT_TEMPLATES BRSATBS1 BRSAINDX1 2 2
VAlertTemplateHist VCRYPT_ALERT_TEMPLATES_HIST BRSATBS1 BRSAINDX1 2 2
VRunStatus V_RUN_STATUS BRSATBS1 BRSAINDX1 2 2
VRunStatusHist V_RUN_STATUS_HIST BRSATBS1 BRSAINDX1 2 2
VCacheStatus VCRYPT_CACHE_STATUS BRSATBS1 BRSAINDX1 2 2
VGlobalLookup V_G_LOOKUP BRSATBS1 BRSAINDX1 2 2
VGlobalLookupHist V_G_LOOKUP_HIST BRSATBS1 BRSAINDX1 2 2
VReportQuery V_REP_QUERY BRSATBS1 BRSAINDX1 2 2
VReportQueryHist V_REP_QUERY_HIST BRSATBS1 BRSAINDX1 2 2
VReportSchedule V_REP_SCHED BRSATBS1 BRSAINDX1 2 2
VReportScheduleHist V_REP_SCHED_HIST BRSATBS1 BRSAINDX1 2 2
VReportSaved V_REP_SAVED BRSATBS1 BRSAINDX1 2 2
VReportSavedHist V_REP_SAVED_HIST BRSATBS1 BRSAINDX1 2 2
VJavaBinaryClass VR_JAVA_BIN BRSATBS1 BRSAINDX1 2 2
VJavaBinaryClassHist VR_JAVA_BIN_HIST BRSATBS1 BRSAINDX1 2 2
VAlert VCRYPT_ALERT BRSATBS1 BRSAINDX1 16 16
VCSRCase V_CASE BRSATBS1 BRSAINDX1 2 2
VCSRCaseHist V_CASE_HIST BRSATBS1 BRSAINDX1 2 2
VCaseActionLogSessionMap V_ACTION_LOG_SESS_MAP BRSATBS1 BRSAINDX1 2 2
VCaseMap V_CASE_MAP BRSATBS1 BRSAINDX1 2 2
VCaseMapHist V_CASE_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VAdminUser V_ADMIN_USER BRSATBS1 BRSAINDX1 2 2
VAdminUserHist V_ADMIN_USER_HIST BRSATBS1 BRSAINDX1 2 2
VAdminUserGroup V_ADMIN_USERGROUP BRSATBS1 BRSAINDX1 2 2
VAdminUserGroupHist V_ADMIN_USER_GROUP_HIST BRSATBS1 BRSAINDX1 2 2
VAdminUserGroupMap V_ADMIN_USERGROUP_MAP BRSATBS1 BRSAINDX1 2 2
VAdminUserGroupMapHist V_ADMIN_USERGROUP_MAP_HIST BRSATBS1 BRSAINDX1 2 2
VAdminUserProfile V_ADMIN_USERPROFILE BRSATBS1 BRSAINDX1 2 2
VAdminUserProfileHist V_ADMIN_USER_PROFILE_HIST BRSATBS1 BRSAINDX1 2 2
VRAConfig VRA_CONFIG BRSATBS1 BRSAINDX1 2 2
VRAConfigHist VRA_CONFIG_HIST BRSATBS1 BRSAINDX1 2 2
VRAConfigProperty VRA_CONFIG_PROP BRSATBS1 BRSAINDX1 2 2
VRAConfigPropertyHist VRA_CONFIG_PROP_HIST BRSATBS1 BRSAINDX1 2 2
VRARunLogs VRA_RUN_LOGS BRSATBS1 BRSAINDX1 2 2
VRASessionSet VRA_SESS_SET BRSATBS1 BRSAINDX1 2 2
VRASessionSetHist VRA_SESS_SET_HIST BRSATBS1 BRSAINDX1 2 2
VRARunSession VRA_RUN_SESS BRSATBS1 BRSAINDX1 2 2
VRARunSessionHist VRA_RUN_SESS_HIST BRSATBS1 BRSAINDX1 2 2
VRAReports VRA_REPORTS BRSATBS1 BRSAINDX1 2 2
VRASchedule VRA_SCHEDULE BRSATBS1 BRSAINDX1 2 2
VRAScheduleHist VRA_SCHEDULE_HIST BRSATBS1 BRSAINDX1 2 2
VRADeviceMap VRA_DEVICE_MAP BRSATBS1 BRSAINDX1 2 2

9.1.3 Tables and Index in category 2

Class Name Table Name Table TS Index TS Table Initranss Index Initranss
VCryptTrackerNode VCRYPT_TRACKER_NODE BRSATBS2 BRSAINDX2 16 16
VCryptTrackerNodeHistory VCRYPT_TRACKER_NODE_HISTORY BRSATBS2 BRSAINDX2 16 16

9.1.4 Tables and Index in category 3

Class Name Table Name Table TS Index TS Table Initranss Index Initranss
VTUserSession VT_USER_SESS BRSATBS3 BRSAINDX3 16 16
VCryptTrackerUserNodeLog VCRYPT_TRACKER_USERNODE_LOGS BRSATBS3 BRSAINDX3 16 16
VTSesssionFPMap VT_SESS_FP_MAP BRSATBS3 BRSAINDX3 16 16
VTUserDeviceMap VTUserDeviceMap BRSATBS3 BRSAINDX3 16 16
VTEntityOneProfile VT_ENTITY_ONE_PROFILE BRSATBS3 BRSAINDX3 16 16
VTEntityOneMap VT_USER_ENTITY1_MAP BRSATBS3 BRSAINDX3 16 16
VTEntityTrxMap VT_ENT_TRX_MAP BRSATBS3 BRSAINDX3 16 16
VTUserProfile VT_USER_PROFILE BRSATBS3 BRSAINDX3 16 16
VTDeviceProfile VT_DEVICE_PROFILE BRSATBS3 BRSAINDX3 16 16
VTIPProfile VT_IP_PROFILE BRSATBS3 BRSAINDX3 16 16
VTBaseIPProfile VT_BASE_IP_PROFILE BRSATBS3 BRSAINDX3 16 16
VTCountryProfile VT_COUNTRY_PROFILE BRSATBS3 BRSAINDX3 16 16
VTStateProfile VT_STATE_PROFILE BRSATBS3 BRSAINDX3 16 16
VTCityProfile VT_CITY_PROFILE BRSATBS3 BRSAINDX3 16 16
VTTrxData VT_TRX_DATA BRSATBS3 BRSAINDX3 16 16

9.1.5 Tables and Index in category 4

Class Name Table Name Table TS Index TS Table Initranss Index Initranss
VTransactionLog VT_TRX_LOGS BRSATBS4 BRSAINDX4 16 16
VPolicySetLog VR_POLICYSET_LOGS BRSATBS4 BRSAINDX4 16 16
VPolicyLog VR_POLICY_LOGS BRSATBS4 BRSAINDX4 16 16
VModelLog VR_MODEL_LOGS BRSATBS4 BRSAINDX4 16 16
VRuleLog VR_RULE_LOGS BRSATBS4 BRSAINDX4 16 16

9.2 Details of each class

9.2.1 VCryptAccount

Description: These are the vcrypt accounts.

Database table name : VCRYPT_ACCOUNTS

Primary Keys : acctId (ACCT_ID)

Name DB name DB type Java type Description Length Enum values
acctId ACCT_ID (PK) BIGINT Long Id for this account 16 -
acctName ACCT_NAME TEXT String Name of this account 4000 -
acctStatus ACCT_STATUS INT int Status of this account. 2 STATUS_ACTIVE

STATUS_INACTIVE

STATUS_DELETED
acctType ACCT_TYPE INT int Type of this account. - -
groupId GROUP_ID BIGINT Long Group Id to which account belongs to 16 -
createTime CREATE_TIME DATETIME Date Date/Time when this account was created - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
acctContact ACCT_CONTACT TEXT String Contact information for this account. 4000 -
notes NOTES TEXT String Notes for this account 4000 -

9.2.2 VCryptAccountHist

Description: These are the vcrypt accounts shadow table.

Database table name : VCRYPT_ACCOUNTS_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME BIGINT Date Active from time. -
toTime TO_TIME BIGINT Date Active from time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
acctId ACCT_ID BIGINT Long Id for this account 16
acctName ACCT_NAME TEXT String Name of this account 4000
acctStatus ACCT_STATUS INT int Status of this account. 2
acctType ACCT_TYPE INT int Type of this account. -
groupId GROUP_ID BIGINT Long Group Id to which account belongs to 16
acctContact ACCT_CONTACT TEXT String Contact information for this account. 4000
notes NOTES TEXT String Notes for this account 4000

9.2.3 VCryptUserGroup

Description: This contains the user group details.

Database table name : VCRYPT_USER_GROUPS

Primary Keys : userGroupId (GROUP_ID)

Name DB name DB type Java type Description Length Enum values
userGroupId GROUP_ID (PK) BIGINT Long Id for the UserGroup 16 -
groupName GROUP_NAME TEXT String Name of the group 4000 -
description DESCRIPTION TEXT String Description for this group. 4000 -
createTime CREATE_TIME DATETIME Date Date/Time creation of this user. - -
updateTime UPDATE_TIME TIMESTAMP Date Last update time. - -
groupType USERGROUP_TYPE_CODE INT int Type of the User group - -
status USERGROUP_STATUS_CODE INT int Status of the User group 2 STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
notes NOTES TEXT String Note 4000 -

9.2.4 VCryptUserRole

Description: This contains the user role details.

Database table name : VCRYPT_USER_ROLES

Primary Keys : roleId (ROLE_ID)

Name DB name DB type Java type Description Length Enum values
roleId ROLE_ID (PK) BIGINT Long Id for the UserRole 16 -
roleName ROLE_NAME TEXT String Name of the role 4000 -
description DESCRIPTION TEXT String Description for this role. 4000 -
createTime CREATE_TIME DATETIME Date Date/Time creation of this user. - -
updateTime UPDATE_TIME TIMESTAMP Date Last update time. - -
roleType ROLE_TYPE_CODE INT int Type of the User role - -
status USERROLE_STATUS_CODE INT int Status of the role 2 STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
notes NOTES TEXT String Note 4000 -

9.2.5 VCryptUserGroupRoleMap

Description: This contains mapping of roles to user groups.

Database table name : VCRYPT_USERGROUP_ROLE_MAPS

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
mapId MAP_ID (PK) BIGINT Long Id for the map 16
groupId GROUP_ID BIGINT Long Group Id. 16
roleId ROLE_ID BIGINT Long Role Id. 16

9.2.6 VCryptUser

Description: This contains the user details.

Database table name : VCRYPT_USERS

Primary Keys : userId (USER_ID)

Name DB name DB type Java type Description Length Enum value
userId USER_ID (PK) BIGINT Long Id for the User 16 -
externalUserId EXT_USER_ID VARCHAR String User id used by the external system 255 -
loginId LOGIN_ID VARCHAR String Login id of the User 255 -
groupId GROUP_ID BIGINT Long Group Id. 16 -
acctId ACCT_ID BIGINT Long Account Id to which this user belongs to 16 -
userName USER_NAME VARCHAR String Name of the User 255 -
userEmail USER_EMAIL VARCHAR String Email address of the User. 255 -
password PASSWORD VARCHAR String Password for the User 255 -
pin PIN VARCHAR String Password for the User 255 -
createTime CREATE_TIME DATETIME Date Date/Time creation of this user. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
statusUpdateTime STATUS_UPDATE_TIME DATETIME Date Date/Time when the status was updated. - -
userType USER_TYPE_CODE INT int Type of the User 2 USER_USER
authMode AUTH_MODE_CODE INT int Mode of authorization 2 -
authType AUTH_TYPE_CODE INT int Type of authorization 2 AUTH_TYPE_NORMAL

AUTH_TYPE_VCRYPT

AUTH_TYPE_PERSONALIZED_VCRYPT
status USER_STATUS_CODE INT int Status of the User 2 STATUS_PENDING_ACTIVATION

STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
isPinEnabled IS_PIN_ENABLED CHAR boolean Whether PIN is enabled for this user - -
isADA IS_ADA CHAR boolean Is ADA - -
isLocked IS_LOCKED CHAR boolean Is this user locked. - -
lockedTime LOCKED_TIME DATETIME Date Date/Time when this user was locked. - -
passwordStatus PASSWORD_STATUS INT int Status of the password 2 -
passwordUpdateTime PASSWORD_UPDATE_TIME DATETIME Date Date/Time when the password was last updated. - -
passwordHistory PASSWORD_HISTORY TEXT String List of password which was used by this user. 4000 -
pinStatus PIN_STATUS INT int Status of the pin 2 -
pinUpdateTime PIN_UPDATE_TIME DATETIME Date Date/Time when the pin was last updated. - -
pinHistory PIN_HISTORY TEXT String List of pin which was used by this user. 4000 -
imagePath IMAGE_PATH VARCHAR String Path to the image file 255 -
personalNote PERSONAL_NOTE TEXT String Personalized note 4000 -
imageStatus IMAGE_STATUS INT int Status of the image 4 -
phraseStatus PHRASE_STATUS INT int Status of the phrase 4 -
questionStatus QUESTION_STATUS INT int Status of the question 4 -
currentQAId CURRENT_QA_ID BIGINT Long The Id of the current question given to the user - -
defaultLocaleId DEFAULT_LOCALE_ID BIGINT Long Default locale for the user 16 -
phraseLocaleId PHRASE_LOCALE_ID BIGINT Long Locale for the phrase 16 -
notes NOTES TEXT String Note 4000 -

9.2.7 VCryptUserHist

Description: This contains the user details.

Database table name : VCRYPT_USERS_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
userId USER_ID BIGINT Long Id for the User 16
externalUserId EXT_USER_ID VARCHAR String User id used by the external system 255
loginId LOGIN_ID VARCHAR String Login id of the User 255
groupId GROUP_ID BIGINT Long Group Id. 16
acctId ACCT_ID BIGINT Long Account Id to which this user belongs to 16
userName USER_NAME VARCHAR String Name of the User 255
userEmail USER_EMAIL VARCHAR String Email address of the User. 255
password PASSWORD VARCHAR String Password for the User 255
pin PIN VARCHAR String Password for the User 255
statusUpdateTime STATUS_UPDATE_TIME DATETIME Date Date/Time when the status was updated. -
userType USER_TYPE_CODE INT int Type of the User 2
authMode AUTH_MODE_CODE INT int Mode of authorization 2
authType AUTH_TYPE_CODE INT int Type of authorization 2
status USER_STATUS_CODE INT int Status of the User 2
isPinEnabled IS_PIN_ENABLED CHAR boolean Whether PIN is enabled for this user -
isADA IS_ADA CHAR boolean Is ADA -
isLocked IS_LOCKED CHAR boolean Is this user locked. -
lockedTime LOCKED_TIME DATETIME Date Date/Time when this user was locked. -
passwordStatus PASSWORD_STATUS INT int Status of the password 2
passwordUpdateTime PASSWORD_UPDATE_TIME DATETIME Date Date/Time when the password was last updated. -
passwordHistory PASSWORD_HISTORY TEXT String List of password which was used by this user. 4000
pinStatus PIN_STATUS INT int Status of the pin 2
pinUpdateTime PIN_UPDATE_TIME DATETIME Date Date/Time when the pin was last updated. -
pinHistory PIN_HISTORY TEXT String List of pin which was used by this user. 4000
imagePath IMAGE_PATH VARCHAR String Path to the image file 255
personalNote PERSONAL_NOTE TEXT String Personalized note 4000
imageStatus IMAGE_STATUS INT int Status of the image 4
phraseStatus PHRASE_STATUS INT int Status of the phrase 4
questionStatus QUESTION_STATUS INT int Status of the question 4
currentQAId CURRENT_QA_ID BIGINT Long The Id of the current question given to the user -
defaultLocaleId DEFAULT_LOCALE_ID BIGINT Long Default locale for the user 16
phraseLocaleId PHRASE_LOCALE_ID BIGINT Long Locale for the phrase 16
notes NOTES TEXT String Note 4000

9.2.8 VQuestionCategory

Description: Question category

Database table name : V_Q_CATEGORY

Primary Keys : categoryId (CATEGORY_ID)

Name DB name DB type Java type Description Length Enum values
categoryId CATEGORY_ID (PK) BIGINT Long Id for the category 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
versionNumber VERSION_NUM INT int Version Number - -
createTime CREATE_TIME DATETIME Date Date/Time for this log. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
name CATEGORY_NAME TEXT String Name of the category 4000 -
nameRBKey NAME_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description 4000 -
categoryType CATEGORY_TYPE INT int The type for this category. 6 -
categoryStatus STATUS INT int The status for this category. 6 STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
notes NOTES TEXT String Note against this question 4000 -

9.2.9 VQuestionCategoryHist

Description: User Question shadow table

Database table name : V_Q_CATEGORY_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
categoryId CATEGORY_ID BIGINT Long Id for the category 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
name CATEGORY_NAME TEXT String Name of the category 4000
nameRBKey NAME_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description 4000
categoryType CATEGORY_TYPE INT int The type for this category. 6
categoryStatus STATUS INT int The status for this category. 6
notes NOTES TEXT String Note against this question 4000

9.2.10 VCryptUserQuestion

Description: User Question

Database table name : V_USER_QUESTIONS

Primary Keys : questionId (QUESTION_ID)

Name DB name DB type Java type Description Length Enum values
questionId QUESTION_ID (PK) BIGINT Long Id for the question 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
versionNumber VERSION_NUM INT int Version Number - -
createTime CREATE_TIME DATETIME Date Date/Time for this log. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
questionType QUESTION_TYPE INT int The type for this question. 2 TYPE_SYSTEM

TYPE_USER
questionStatus QUESTION_STATUS INT int The status for this question. 2 STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
categoryId QUESTION_CATEGORY BIGINT Long Category of the question 16 -
localeId LOCALE_ID BIGINT Long Locale for this question 16 -
question QUESTION TEXT String Question 4000 -
help HELP TEXT String Help for the validation 4000 -
errorText ERROR_TEXT TEXT String Error text for the validation 4000 -
notes NOTES TEXT String Note against this question 4000 -

9.2.11 VCryptUserQuestionHist

Description: User Question shadow table

Database table name : V_USER_QUESTIONS_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
questionId QUESTION_ID BIGINT Long Id for the question 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
questionType QUESTION_TYPE INT int The type for this question. 2
questionStatus QUESTION_STATUS INT int The status for this question. 2
question QUESTION TEXT String Question 4000
categoryId QUESTION_CATEGORY BIGINT Long Category of the question 16
localeId LOCALE_ID BIGINT Long Locale for this question 16
help HELP TEXT String Help for the validation 4000
errorText ERROR_TEXT TEXT String Error text for the validation 4000
notes NOTES TEXT String Note against this question 4000

9.2.12 VCryptQuestionGlobalValidation

Description: Global question validation

Database table name : V_Q_GLOBAL_VALID

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length Enum values
mapId MAP_ID (PK) BIGINT Long Id for the map 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
versionNumber VERSION_NUM INT int Version Number - -
validationId VALIDATION_ID BIGINT Long Id for the validation 16 -
status STATUS INT int The status for this validation. 2 STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
createTime CREATE_TIME DATETIME Date Date/Time for this log. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -

9.2.13 VCryptQuestionGlobalValidationHist

Description: Question validation map history

Database table name : V_Q_GLOBAL_VALID_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
mapId MAP_ID BIGINT Long Id for the map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
validationId VALIDATION_ID BIGINT Long Id for the validation 16
status STATUS INT int The status for this validation. 2

9.2.14 VCryptQuestionValidationMap

Description: Question validation map

Database table name : V_Q_VALIDATION_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
mapId MAP_ID (PK) BIGINT Long Id for the map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
questionId QUESTION_ID BIGINT Long Id for the question 16
validationId VALIDATION_ID BIGINT Long Id for the validation 16
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -

9.2.15 VCryptQuestionValidationMapHist

Description: Question validation map history

Database table name : V_Q_VALIDATION_MAP_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
mapId MAP_ID BIGINT Long Id for the map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
questionId QUESTION_ID BIGINT Long Id for the question 16
validationId VALIDATION_ID BIGINT Long Id for the validation 16

9.2.16 VCryptValidation

Description: Validation

Database table name : V_VALIDATION

Primary Keys : validationId (VALIDATION_ID)

Name DB name DB type Java type Description Length
validationId VALIDATION_ID (PK) BIGINT Long Id for the validation 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
name NAME TEXT String Name 4000
nameRBKey NAME_RBKEY TEXT String Resource bundle key for the name 4000
validationScope VALID_SCOPE INT int What is the scope of the this validation. Whether it works on individual questions or on all the questions. E.g. to support validations like, no 2 answers can be the same. 4
help HELP TEXT String Help for the validation 4000
errorText ERROR_TEXT TEXT String Error text for the validation 4000
validationScheme VALIDATION_SCHEME INT int Validation scheme -
validationScript VALIDATION_SCRIPT TEXT String Validation script. This is interpretted based on the validation scheme 4000
javaClass JAVA_CLASS TEXT String Java class path 4000
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
notes NOTES TEXT String Notes 4000

9.2.17 VCryptValidationHist

Description: Validation map history

Database table name : V_VALIDATION_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
validationId VALIDATION_ID BIGINT Long Id for the validation 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
name NAME TEXT String Name 4000
nameRBKey NAME_RBKEY TEXT String Resource bundle key for the name 4000
validationScope VALID_SCOPE INT int What is the scope of the this validation. Whether it works on individual questions or on all the questions. E.g. to support validations like, no 2 answers can be the same. 4
help HELP TEXT String Help for the validation 4000
errorText ERROR_TEXT TEXT String Error text for the validation 4000
validationScheme VALIDATION_SCHEME INT int Validation scheme -
validationScript VALIDATION_SCRIPT TEXT String Validation script. This is interpretted based on the validation scheme 4000
javaClass JAVA_CLASS TEXT String Java class path 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
notes NOTES TEXT String Notes 4000

9.2.18 VCryptGlobalAnswerHint

Description: Global answer hint

Database table name :V_GLOBAL_ANS_HINT

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length Enum values
mapId MAP_ID (PK) BIGINT Long Id for the map 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
versionNumber VERSION_NUM INT int Version Number - -
answerHintId ANS_HINT_ID BIGINT Long Id for the answer hint 16 -
status STATUS INT int The status for this validation. 2 STATUS_ACTIVE STATUS_DISABLED STATUS_DELETED
createTime CREATE_TIME DATETIME Date Date/Time for this hint. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -

9.2.19 VCryptGlobalAnswerHintHist

Description: Global answer hint. Shadow table

Database table name :V_GLOBAL_ANS_HINT_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
mapId MAP_ID BIGINT Long Id for the map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
answerHintId ANS_HINT_ID BIGINT Long Id for the answer hint 16
status STATUS INT int The status for this validation. 2

9.2.20 VCryptQuestionAnswerHintMap

Description: Question answer hint map

Database table name :V_Q_ANS_HINT_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
mapId MAP_ID (PK) BIGINT Long Id for the map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
questionId QUESTION_ID BIGINT Long Id for the question 16
answerHintId ANS_HINT_ID BIGINT Long Id for the answer hint 16
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -

9.2.21 VCryptQuestionAnswerHintMapHist

Description: Question answer hint map history

Database table name :V_Q_ANS_HINT_MAP_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
mapId MAP_ID BIGINT Long Id for the map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
questionId QUESTION_ID BIGINT Long Id for the question 16
answerHintId ANS_HINT_ID BIGINT Long Id for the answer hint 16

9.2.22 VCryptAnswerHint

Description: Answer Hint

Database table name :V_ANS_HINT

Primary Keys : answerHintId (ANS_HINT_ID)

Name DB name DB type Java type Descriptions Length
answerHintId ANS_HINT_ID (PK) BIGINT Long Id for the answer hint 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
name NAME TEXT String Name 4000
nameRBKey NAME_RBKEY TEXT String Resource bundle key for the name 4000
answerHintScheme ANS_HINT_SCHEME INT int Answer Hint scheme -
answerHintScript ANS_HINT_SCRIPT TEXT String Answer Hint script. This is interpretted based on the answer hint scheme 4000
javaClass JAVA_CLASS TEXT String Java class path 4000
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
notes NOTES TEXT String Notes 4000

9.2.23 VCryptAnswerHintHist

Description: Answer Hint map history

Database table name :V_ANS_HINT_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
answerHintId ANS_HINT_ID BIGINT Long Id for the answer hint 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
name NAME TEXT String Name 4000
nameRBKey NAME_RBKEY TEXT String Resource bundle key for the name 4000
answerHintScheme ANS_HINT_SCHEME INT int Answer Hint scheme -
answerHintScript ANS_HINT_SCRIPT TEXT String Answer Hint script. This is interpretted based on the answer hint scheme 4000
javaClass JAVA_CLASS TEXT String Java class path 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
notes NOTES TEXT String Notes 4000

9.2.24 VCryptUserQA

Description: User Question/Answer

Database table name: V_USER_QA

Primary Keys: qaId (QA_ID)

Name DB name DB type Java type Description Length Enum values
qaId QA_ID (PK) BIGINT Long Id for the question/answer 16 -
userId USER_ID BIGINT Long Id of the user. 16 -
questionId QUESTION_ID BIGINT Long Id for the question 16 -
qaStatus QA_STATUS INT int The status for this question/answer. 2 STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
createTime CREATE_TIME DATETIME Date Date/Time for this log. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
answer ANSWER TEXT String Answer to the question 4000 -
answerHint ANSWER_HINT TEXT String Hint for the answer 4000 -

9.2.25 VCryptUserQAHist

Description: User Question/Answer shadow table

Database table name :V_USER_QA_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
qaId QA_ID BIGINT Long Id for the question/answer 16
userId USER_ID BIGINT Long Id of the user. 16
questionId QUESTION_ID BIGINT Long Id for the question 16
qaStatus QA_STATUS INT int The status for this question/answer. 2
answer ANSWER TEXT String Answer to the question 4000
answerHint ANSWER_HINT TEXT String Hint for the answer 4000

9.2.26 VCryptScoringPolicy

Description: Scoring Policy

Database table name :V_SCORING_POLICY

Primary Keys : policyId (POLICY_ID)

Name DB name DB type Java type Description Length
policyId POLICY_ID (PK) BIGINT Long Id for the policy 16
policyType POLICY_TYPE INT int Policy type -
runtimeType RUNTIME_TYPE INT int Type of runtime 6
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
minFinalScore MIN_FINAL_SCORE INT int Minimum final score to return success -
notes NOTES TEXT String Note 4000
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -

9.2.27 VCryptScoringPolicyHist

Description: Scoring Policy shadow table

Database table name :V_SCORING_POLICY_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
policyId POLICY_ID BIGINT Long Id for the policy 16
policyType POLICY_TYPE INT int Policy type -
runtimeType RUNTIME_TYPE INT int Type of runtime 6
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
minFinalScore MIN_FINAL_SCORE INT int Minimum final score to return success -
notes NOTES TEXT String Note 4000

9.2.28 VCryptScoreAttributes

Description: Score attributes

Database table name :V_SCORE_ATTR

Primary Keys : attrId (ATTR_ID)

Name DB name DB type Java type Description Length
attrId ATTR_ID (PK) BIGINT Long Id for the attribute 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
policyId POLICY_ID BIGINT Long Id for the policy to which this belongs to 16
attrType ATTR_TYPE INT int Attribute type -
score SCORE INT int Default score for this policy -
weight WEIGHT INT int Weight for this profile -
notes NOTES TEXT String Note 4000
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -

9.2.29 VCryptScoreAttributesHist

Description: Score Attributes for shadow table

Database table name :V_SCORE_ATTR_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
attrId ATTR_ID BIGINT Long Id for the attribute 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
versionNumber VERSION_NUM INT int Version Number -
policyId POLICY_ID BIGINT Long Id for the policy to which this belongs to 16
attrType ATTR_TYPE INT int Attribute type -
score SCORE INT int Default score for this policy -
weight WEIGHT INT int Weight for this profile -
notes NOTES TEXT String Note 4000

9.2.30 VMonitorData

Description: This contains the monitor data.

Database table name :V_MONITOR_DATA

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Id for finger print 16
createTime CREATE_TIME DATETIME Date Date/Time of this finger print. -
updateTime UPDATE_TIME TIMESTAMP Date Date/Time of the last update. -
monitorType MONITOR_TYPE INT int Monitor type 5
fingerPrintId FPRINT_ID BIGINT Long Id for the finger print 16
dataValue DATA_VALUE TEXT String Data value for the finger print 4000
count MONITOR_COUNT INT int Monitor count -
beginTime BEGIN_TIME DATETIME Date Date/Time for begin time. -
endTime END_TIME DATETIME Date End time. -
runningTime RUNNING_TIME BIGINT long Running time 20
elapsedTime ELAPLSED_TIME BIGINT long Elapsed time in micro seconds 20
minTime MIN_TIME BIGINT long Minimum time taken for processing in micro seconds 20
maxTime MAX_TIME BIGINT long Maximum time taken for processing in micro seconds 20
hour AGGR_HOUR DATETIME Date Hour for this aggregate -
day AGGR_DAY DATETIME Date Day for this aggregate -
week AGGR_WEEK DATETIME Date Week for this aggregate -
month AGGR_MONTH DATETIME Date Week for this aggregate -
quarter AGGR_QUARTER DATETIME Date Week for this aggregate -
year AGGR_YEAR DATETIME Date Year for this aggregate -
serverId SERVER_ID TEXT String Server Id 4000

9.2.31 VBharosaConfig

Description: Bharosa Config

Database table name :V_B_CONFIG

Primary Keys : configId (CONFIG_ID)

Name DB name DB type Java type Description Length
configId CONFIG_ID (PK) BIGINT Long Id for the config 16
versionNumber VERSION_NUM INT int Version Number -
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name CONFIG_NAME TEXT String Name of the attribute 4000
value CONFIG_VALUE TEXT String Value of the attribute 4000
configType CONFIG_TYPE INT int The type of this config. 5
isEncrypted IS_SECURE CHAR boolean Is this property encrypted -
description DESCRIPTION TEXT String Description 4000
notes NOTES TEXT String Notes 4000

9.2.32 VBharosaConfigHist

Description: Bharosa Config shadow

Database table name :V_B_CONFIG_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
configId CONFIG_ID BIGINT Long Id for the config 16
versionNumber VERSION_NUM INT int Version Number -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name CONFIG_NAME TEXT String Name of the attribute 4000
value CONFIG_VALUE TEXT String Value of the attribute 4000
configType CONFIG_TYPE INT int The type of this config. 5
isEncrypted IS_SECURE CHAR boolean Is this property encrypted -
description DESCRIPTION TEXT String Description 4000
notes NOTES TEXT String Notes 4000

9.2.33 VBharosaEnum

Description: User Defined Enums

Database table name :V_B_ENUM

Primary Keys : enumId (ENUM_ID)

Name DB name DB type Java type Description Length
createTime CREATE_TIME DATETIME Date Create Date/Time. -
updateTime UPDATE_TIME TIMESTAMP Date Update Date/Time. -
enumId ENUM_ID (PK) BIGINT Long Id for the enum 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name of the User Def Enum. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
propertyName PROP_NAME TEXT String Property name for this enum 4000
notes NOTES TEXT String Notes 4000

9.2.34 VBharosaEnumHist

Description: Bharosa Config shadow

Database table name :V_B_ENUM_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Descriptions Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
enumId ENUM_ID BIGINT Long Id for the enum 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name of the User Def Enum. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
propertyName PROP_NAME TEXT String Property name for this enum 4000
notes NOTES TEXT String Notes 4000

9.2.35 VBharosaEnumElement

Description: Element in User Defined Enums

Database table name :V_B_ENUM_ELMNT

Primary Keys : elementId (ELEMENT_ID)

Name DB name DB type Java type Description Length
createTime CREATE_TIME DATETIME Date Create Date/Time. -
updateTime UPDATE_TIME TIMESTAMP Date Update Date/Time. -
elementId ELEMENT_ID (PK) BIGINT Long Id for the enum 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
enumId ENUM_ID BIGINT Long Id for the Enum 16
name LABEL TEXT String Name of the Element. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
propertyName PROP_NAME TEXT String Property name for this enum 4000
numericValue NUM_VALUE INT int Numeric value of the element -
stringValue STR_VALUE TEXT String String value of the element 4000
isEnabled IS_ENABLED CHAR boolean Is this element enabled -
notes NOTES TEXT String Notes 4000

9.2.36 VBharosaEnumElementHist

Description: Shadow object for BharosaEnumElement

Database table name :V_B_ENUM_ELMNT_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
elementId ELEMENT_ID BIGINT Long Id for the enum 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
enumId ENUM_ID BIGINT Long Id for the Enum 16
name LABEL TEXT String Name of the Element. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
propertyName PROP_NAME TEXT String Property name for this enum 4000
numericValue NUM_VALUE INT int Numeric value of the element -
stringValue STR_VALUE TEXT String String value of the element 4000
isEnabled IS_ENABLED CHAR boolean Is this element enabled -
notes NOTES TEXT String Notes 4000

9.2.37 VBharosaEnumElementAttribute

Description: Element attribute in User Defined Enums

Database table name :V_B_ENUM_ELMNT_ATTR

Primary Keys : attributeId (ATTR_ID)

Name DB name DB type Java type Description Length
createTime CREATE_TIME DATETIME Date Create Date/Time. -
updateTime UPDATE_TIME TIMESTAMP Date Update Date/Time. -
attributeId ATTR_ID (PK) BIGINT Long Id for the enum 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
elementId ELEMENT_ID BIGINT Long Id for the Enum 16
attributeName ATTR_NAME TEXT String Name of the attribute. 4000
attributeValue ATTR_VALUE TEXT String Value of the attribute 4000
propertyName PROP_NAME TEXT String Property name for this attribute 4000
notes NOTES TEXT String Notes 4000

9.2.38 VBharosaEnumElementAttributeHist

Description: Enum Element attribute shadow

Database table name :V_B_ENUM_ELMNT_ATTR_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
attributeId ATTR_ID BIGINT Long Id for the enum 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
elementId ELEMENT_ID BIGINT Long Id for the Enum 16
attributeName ATTR_NAME TEXT String Name of the attribute. 4000
attributeValue ATTR_VALUE TEXT String Value of the attribute 4000
propertyName PROP_NAME TEXT String Property name for this attribute 4000
notes NOTES TEXT String Notes 4000

9.2.39 VBharosaLocale

Description: Bharosa Locale

Database table name :V_B_LOCALE

Primary Keys : localeId (LOCALE_ID)

Name DB name DB type Java type Description Length
localeId LOCALE_ID (PK) BIGINT Long Id for the Locale 16
versionNumber VERSION_NUM INT int Version Number -
createTime CREATE_TIME DATETIME Date Create Date/Time for this object. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LOCALE_NAME TEXT String Name of the Locale 4000
nameRBKey NAME_RBKEY TEXT String Resource bundle key for the name 4000
language LANGUAGE TEXT String Language of the Locale 4000
country COUNTRY TEXT String Country of the Locale 4000
variant VARIANT TEXT String Variant of the Locale 4000
localeKey LOCALE_KEY TEXT String This is the concatenation of all the elements 4000
notes NOTES TEXT String Notes 4000

9.2.40 VBharosaLocaleHist

Description: Bharosa Locale shadow

Database table name :V_B_LOCALE_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
localeId LOCALE_ID BIGINT Long Id for the locale 16
versionNumber VERSION_NUM INT int Version Number -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LOCALE_NAME TEXT String Name of the Locale 4000
nameRBKey NAME_RBKEY TEXT String Resource bundle key for the name 4000
language LANGUAGE TEXT String Language of the Locale 4000
country COUNTRY TEXT String Country of the Locale 4000
variant VARIANT TEXT String Variant of the Locale 4000
localeKey LOCALE_KEY TEXT String This is the concatenation of all the elements 4000
notes NOTES TEXT String Notes 4000

9.2.41 VBharosaConfigRB

Description: Bharosa Config with resource bundle

Database table name :V_B_CONFIG_RB

Primary Keys : configId (CONFIG_ID)

Name DB name DB type Java type Description Length
configId CONFIG_ID (PK) BIGINT Long Id for the config 16
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -
name CONFIG_NAME TEXT String Name of the attribute 4000
value CONFIG_VALUE TEXT String Value of the attribute 4000
localeId LOCALE_ID BIGINT Long Locale for this property 16

9.2.42 VPattern

Description: This represents a pattern

Database table name :V_PATTERN

Primary Keys : patternId (PATTERN_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Create Date/Time for this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
patternId PATTERN_ID (PK) BIGINT Long Id for the pattern 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name of the pattern. 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the pattern 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
trxDefId TRX_DEF_ID BIGINT Long Id for the Transaction type id 16 -
evalRuntime EVAL_RUNTIME INT int Defines when the pattern will be evaluated. E.g real-time, batch-mode, asyn-mode, etc 6 -
status STATUS INT int The status for this pattern. 2 STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
notes NOTES TEXT String Notes 4000 -

9.2.43 VPatternHist

Description: VPattern shadow class

Database table name :V_PATTERN_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
patternId PATTERN_ID BIGINT Long Id for the pattern 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name of the pattern. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the pattern 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
trxDefId TRX_DEF_ID BIGINT Long Id for the Transaction type 16
evalRuntime EVAL_RUNTIME INT int Defines when the pattern will be evaluated. E.g real-time, batch-mode, asyn-mode, etc 6
status STATUS INT int The status for this pattern. 2
notes NOTES TEXT String Notes 4000

9.2.44 VPatternEntity

Description: These are the entities which are associated with the Pattern.

Database table name :V_PATTERN_ENTITY

Primary Keys : patternEntityId (PAT_ENT_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Create Date/Time for this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
patternEntityId PAT_ENT_ID (PK) BIGINT Long Id for this pattern and entity map 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name of the pattern and entity mapping 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the pattern and entity mapping 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
patternId PATTERN_ID BIGINT Long Id for the pattern this maps to. 16 -
trxEntityDefMapId TRX_ENT_DEF_MAP_ID BIGINT Long Id to the transaction entity definition map 16 -
status STATUS INT int The status for this mapping. 2 STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
notes NOTES TEXT String Notes 4000 -

9.2.45 VPatternEntityHist

Description: VPatternEntity shadow class

Database table name :V_PATTERN_ENTITY_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
patternEntityId PAT_ENT_ID BIGINT Long Id for this pattern and entity map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name of the pattern and entity mapping 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the pattern and entity mapping 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
patternId PATTERN_ID BIGINT Long Id for the pattern this maps to. 16
trxEntityDefMapId TRX_ENT_DEF_MAP_ID BIGINT Long Id to the transaction entity definition map 16
status STATUS INT int The status for this mapping. 2
notes NOTES TEXT String Notes 4000

9.2.46 VPatternParam

Description: This contains the information about the pattern params and the comparison or math operations that can be applied to the parameters when calculating membership to patterns

Database table name :V_PATTERN_PARAM

Primary Keys : paramId (PARAM_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Create Date/Time for this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
paramId PARAM_ID (PK) BIGINT Long Id for the param 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name of the pattern and entity mapping 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the pattern and entity mapping 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
patternId PATTERN_ID BIGINT Long Id for the pattern this maps to. 16 -
status STATUS INT int The status for this mapping. 2 STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
orderNumber ORDER_NUMBER INT int Order number. This is used to create the grammer for prompts - -
compareOperator COMPARE_OPER INT int Comparision operator - -
paramKey PARAM_KEY TEXT String Key to the parameter 4000 -
paramType PARAM_TYPE INT int Type of the parameter - -
paramValue PARAM_VALUE TEXT String Param value 4000 -
beginRange BEGIN_RANGE INT Integer Begin value for the range 10 -
endRange END_RANGE INT Integer End value for the range 10 -
maxRange MAX_RANGE INT Integer Max value for the range 10 -
rangeIncrementStep RANGE_INCR_STEP INT Integer Increment step for range 10 -
notes NOTES TEXT String Notes 4000 -

9.2.47 VPatternParamHist

Description: VPatternParam shadow class

Database table name :V_PATTERN_PARAM_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
paramId PARAM_ID BIGINT Long Id for the param 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name of the pattern and entity mapping 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the pattern and entity mapping 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
patternId PATTERN_ID BIGINT Long Id for the pattern this maps to. 16
status STATUS INT int The status for this mapping. 2
orderNumber ORDER_NUMBER INT int Order number. This is used to create the grammer for prompts -
compareOperator COMPARE_OPER INT int Comparision operator -
paramKey PARAM_KEY TEXT String Key to the parameter 4000
paramType PARAM_TYPE INT int Type of the parameter -
paramValue PARAM_VALUE TEXT String Param value 4000
beginRange BEGIN_RANGE INT Integer Begin value for the range 10
endRange END_RANGE INT Integer End value for the range 10
maxRange MAX_RANGE INT Integer Max value for the range 10
rangeIncrementStep RANGE_INCR_STEP INT Integer Increment step for range 10
notes NOTES TEXT String Notes 4000

9.2.48 VPatternEntityOperation

Description: This table stores data about the operations that be applied to the entities (observables) in the pattern. This table essentially keeps data about the profiling that needs to be collected for the entity. So we can have one to many relationship between pattern_entity table and this table

Database table name :V_PAT_ENT_OPER

Primary Keys : operationId (OPER_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Create Date/Time for this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
operationId OPER_ID (PK) BIGINT Long Id for the operation 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name of the operation 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the operation 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
patternEntityId PAT_ENT_ID BIGINT Long Id for the pattern entity map. 16 -
operationType OPER_TYPE INT int Type of the operation. 5 -
status STATUS INT int The status for this mapping. 2 STATUS_ACTIVE

STATUS_DISABLED

STATUS_DELETED
notes NOTES TEXT String Notes 4000 -

9.2.49 VPatternEntityOperationHist

Description: VPatternEntityOperation shadow class

Database table name :V_PAT_ENT_OPER_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
operationId OPER_ID BIGINT Long Id for the operation 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name of the operation 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the operation 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
patternEntityId PAT_ENT_ID BIGINT Long Id for the pattern entity map. 16
operationType OPER_TYPE INT int Type of the operation. 5
status STATUS INT int The status for this mapping. 2
notes NOTES TEXT String Notes 4000

9.2.50 VCryptFingerPrint

Description: This contains the finger prints.

Database table name :V_FPRINTS

Primary Keys : fingerPrintId (FPRINT_ID)

Name DB name DB type Java type Description Length
fingerPrintId FPRINT_ID (PK) BIGINT Long Id for finger print 16
createTime CREATE_TIME DATETIME Date Date/Time of this finger print. -
fingerPrintType FPRINT_TYPE INT int Type of finger printing 6
patternId PATTERN_ID BIGINT Long Id for the pattern this maps to. 16
hashValue HASH_VALUE TEXT String Hash value for the finger print 512
dataValue DATA_VALUE TEXT String Data value for the finger print 4000

9.2.51 VCryptFPNameValue

Description: Name value pairs in the finger printDatabase table name :V_FP_NV

Database table name :V_FP_NV

Primary Keys : nameValueId (FP_NV_ID)

Name DB name DB type Java type Description Length
nameValueId FP_NV_ID (PK) BIGINT Long Id for name value 16
fingerPrintId FPRINT_ID BIGINT Long Id for the finger print 16
name ATTR_NAME VARCHAR String Name of the attribute 64
value ATTR_VALUE TEXT String Value of the attribute 256

9.2.52 VCryptFPMap

Description: Map for finger print

Database table name :V_FP_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
mapId MAP_ID (PK) BIGINT Long Id for map 16
fingerPrintId FPRINT_ID BIGINT Long Id for the finger print 16
fingerPrintType FPRINT_TYPE INT int Type of finger printing 6
name ATTR_NAME VARCHAR String Name of the attribute 64
value ATTR_VALUE TEXT String value of the attribute 256

9.2.53 VCryptUserLog

Description: User Log

Database table name :VCRYPT_USER_LOGS

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length Enum values
logId LOG_ID (PK) BIGINT Long Id for the message 16 -
userId USER_ID BIGINT Long Id of the user if available. 16 -
authSessionId SESSION_ID BIGINT Long Id to group discrete operations for a session. 16 -
createTime CREATE_TIME DATETIME Date Date/Time for this log. - -
logType LOG_TYPE_CODE INT int The type for this log. 2 TYPE_OTHER

TYPE_CREATE

TYPE_UPDATE

TYPE_DELETE
message MESSAGE TEXT String Message for this log. 4000 -
messageDetail MESSAGE_DETAIL TEXT String Message detail 4000 -
notes NOTES TEXT String Note against this message 4000 -

9.2.54 VCryptPinReset

Description: Pin reset log

Database table name :VCRYPT_PIN_RESETS

Primary Keys : resetId (RESET_ID)

Name DB name DB type Java type Description Length Enum values
resetId RESET_ID (PK) BIGINT Long Id for the reset 16 -
userId USER_ID BIGINT Long Id of the user if available. 16 -
newPin NEW_PIN VARCHAR String New pin for the user 255 -
requestTime REQUEST_TIME DATETIME Date Date/Time of the request. - -
resetStatus RESET_STATUS_CODE INT int Status of the reset 2 STATUS_NONE

STATUS_NOTIFIED

STATUS_RETRIEVED

STATUS_OBSOLETE

STATUS_EXPIRED
magicKey MAGIC_KEY TEXT String Magic key sent to the client. 256 -
notes NOTES TEXT String Note 4000 -

9.2.55 VCryptPinRetrieval

Description: Pin retrieval

Database table name :VCRYPT_PIN_RETRIEVALS

Primary Keys : retrievalId (RETRIEVE_ID)

Name DB name DB type Java type Description Length Enum values
retrievalId RETRIEVE_ID (PK) BIGINT Long Id for the retrieval 16 -
resetId RESET_ID BIGINT Long Id for the User 16 -
retrieveTime RETRIEVE_TIME DATETIME Date Date/Time of the retrieval. - -
retrieveStatus RETRIEVE_STATUS_CODE INT int Status of this retrieval 2 STATUS_NONE

STATUS_SUCCESS

STATUS_REJECTED
rejectReason REJECT_REASON_CODE INT int Reason of rejection 2 REJECT_NONE

REJECT_EXPIRED

REJECT_DUPLICATE_REQUEST

REJECT_INVALID_USER

REJECT_INVALID_PASSWORD

REJECT_INVALID_SECURITY_ANSWER
notes NOTES TEXT String Note 4000 -

9.2.56 VCryptAuthSessionGroup

Description: VCrypt Session

Database table name :VCRYPT_AUTH_SESSION_GROUPS

Primary Keys : sessionGroupId (SESSION_GROUP_ID)

Name DB name DB type Java type Description Length Enum values
sessionGroupId SESSION_GROUP_ID (PK) BIGINT Long Id for the session group 16 -
sessionType SESSION_TYPE INT int Type of the authentication session. It could be for login, pin reset or on-demand in session authentication - -
createTime CREATE_TIME DATETIME Date Date/Time for this session group. - -
authStatus AUTH_STATUS INT int Status of the this authentication session group. 3 AUTH_PENDING

AUTH_SUCCESS

AUTH_FAILED

9.2.57 VCryptAuthSession

Description: VCrypt Session

Database table name :VCRYPT_AUTH_SESSIONS

Primary Keys : sessionId (SESSION_ID)

Name DB name DB type Java type Description Length
sessionId SESSION_ID (PK) BIGINT Long Id for the session 16
sessionGroupId SESSION_GROUP_ID BIGINT Long Id of the session group. 16
userId USER_ID BIGINT Long Id of the user if available. 16
clientType CLIENT_TYPE_CODE INT int Type of the client used 2
clientVersion CLIENT_VERSION VARCHAR String Version of the client 64
authCount AUTH_COUNT INT int How many times the same session was used for authentication. -
createTime CREATE_TIME DATETIME Date Date/Time for this session. -
requestData REQUEST_DATA TEXT String Data sent by the user. 4000
sessionData SESSION_DATA TEXT String Data sent to the user. 4000
host HOST TEXT String IP or hostname of the user 4000
fingerPrintId FPRINT_ID BIGINT Long Log id for the finger print 16
notes NOTES TEXT String Note against this message 4000

9.2.58 VCryptAuthAttempt

Description: VCrypt statistics

Database table name :VCRYPT_AUTH_ATTEMPTS

Primary Keys : attemptId (ATTEMPT_ID)

Name DB name DB type Java type Description Length Enum values
attemptId ATTEMPT_ID (PK) BIGINT Long Id for the message 16 -
userId USER_ID BIGINT Long Id of the user if available. 16 -
loginId LOGIN_ID VARCHAR String Login Id provided by the user. 255 -
authSessionId SESSION_ID BIGINT Long Id to group discrete operations for a session. 16 -
authAttemptCount ATTEMPT_COUNT INT int Count of authentication attempts for this authentication session. - -
authStatus AUTH_STATUS INT int Status of the this authentication. 3 AUTH_PENDING, AUTH_SUCCESS, AUTH_FAILED
authReason AUTH_REASON INT int Reason for the status code. This code is dependent on the status code of the authStatus. - -
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. - -
updateTime UPDATE_TIME TIMESTAMP Date Date/Time of the last update. - -
startTime STARTTIME DATETIME Date Start time. - -
timer1 TIMER1 BIGINT long First timer. 16 -
timer2 TIMER2 BIGINT long Second timer. 16 -
timer3 TIMER3 BIGINT long Third timer. 16 -
timer4 TIMER4 BIGINT long Fourth timer. 16 -
timer5 TIMER5 BIGINT long Fifth timer. 16 -
total TOTAL BIGINT long Total of all timers. This is a redundant column, but useful in queries 16 -
requestData REQUEST_DATA TEXT String Data sent by the user. 4000 -
requestResult REQUEST_RESULT TEXT String Data sent to the user. 4000 -
remoteIPAddr REMOTE_IP_ADDR BIGINT String The IP address from where the client connected 15 -
fingerPrintId FPRINT_ID BIGINT Long Log id for the finger print 16 -
notes NOTES TEXT String Note against this message 4000 -

9.2.59 VCryptSystemMessage

Description: SystemMessage

Database table name :VCRYPT_SYS_MESSAGES

Primary Keys : messageId (MESSAGE_ID)

Name DB name DB type Java type Description Length
messageId MESSAGE_ID (PK) BIGINT Long Message id 16
userName USER_NAME TEXT String User Name 4000
systemMessage SYSTEM_MESSAGE TEXT String System message 4000
messageTime MESSAGE_TIME DATETIME Date Date/Time for this message. -

9.2.60 VSystemLogs

Description: System log messages

Database table name :V_SYS_LOGS

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Id for the log 16
adminLoginId ADMIN_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Date/Time of the last update. -
logType LOG_TYPE INT int Log type 5
logSubType LOG_SUB_TYPE INT int Log sub type 5
logMessage LOG_MESSAGE TEXT String Log message 4000
logData LOG_DATA TEXT String Log data. This is a opaque object. -
notes NOTES TEXT String Note against this rule 4000

9.2.61 VCryptDBPatch

Description: Class which has the list of db patches applied

Database table name :VCRYPT_DB_PATCHES

Primary Keys : patchId (PATCH_ID)

Name DB name DB type Java type Description Length Enum values
patchId PATCH_ID (PK) BIGINT Long Patch id 16 -
patchDescription PATCH_DESC TEXT String Description of the patch 4000 -
patchVersion PATCH_VERSION VARCHAR String Patch version 64 -
patchStatus STATUS INT int Patch status 2 PATCH_SUCCESS, PATCH_FAILURE, PATCH_PARTIAL
patchDate PATCH_DATE DATETIME Date Date/Time when the patch was applied. - -
notes NOTES TEXT String Note for this patch 4000 -

9.2.62 VActionLogSession

Description: Session for the action logs

Database table name :V_ACTION_LOG_SESS

Primary Keys : sessionId (SESSION_ID)

Name DB name DB type Java type Description Length
sessionId SESSION_ID (PK) BIGINT Long Id for this session 16
parentSessionId PARENT_SESSION_ID BIGINT Long Id for the parent session 16
sessionType SESSION_TYPE INT int Type of this session 3
adminLoginId ADMIN_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
adminUserRole ADMIN_USER_ROLE VARCHAR String Role of the administrator. 64
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Date/Time of the last update. -
notes NOTES TEXT String Notes 4000

9.2.63 VActionLog

Description: Action logs

Database table name :V_ACTION_LOGS

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Id for this log 16
sessionId SESSION_ID BIGINT Long Id for this session 16
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Date/Time of the last update. -
category CATEGORY INT int Category of the action 3
action ACTION INT int Action performed 3
accessType ACCESS_TYPE INT int Access type 3
data DATA TEXT String Data for this action 4000
notes NOTES TEXT String Notes 4000

9.2.64 VTUserSession

Description: This contains the user session

Database table name :VT_USER_SESS

Primary Keys : userSessionId (SESS_ID)

Name DB name DB type Java type Description Length
userSessionId SESS_ID (PK) BIGINT Long Id of the session 16
requestId REQUEST_ID TEXT String Id of the external user session 256
extSessionId EXT_SESSION_ID TEXT String External session id 512
userId USER_ID BIGINT Long Id of the user. 16
channelType CHANNEL_TYPE INT int Type of the channel used for this session. Channel could online, CC phone challenge, IVR, etc 5
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
executeTime EXEC_TIME TIMESTAMP Date The time when this request was processed. -
authClientType AUTH_CLIENT_TYPE_CODE INT int Type of the client used by the user for authentication 5
authStatus AUTH_STATUS INT int Status of the authentication. 3
postProcessStatus POST_PROCESS_STATUS INT int Status of the post processing 5
postProcessResult POST_PROCESS_RESULT INT int Status of the post processing 5

9.2.65 VCryptTrackerUserNodeLog

Description: This logs all the activities for the nodes.

Database table name :VCRYPT_TRACKER_USERNODE_LOGS

Primary Keys : userNodeLogId (USER_NODE_LOG_ID)

Name DB name DB type Java type Description Length
userNodeLogId USER_NODE_LOG_ID (PK) BIGINT Long Log id of the user for a given node 16
requestId REQUEST_ID TEXT String Id of the request. This is used to co-relate the post authentication request. 256
extSessionId EXT_SESSION_ID TEXT String External session id 512
clientDeviceId CLIENT_DEVICE_ID TEXT String Id of the device which is generated by the application. 256
remoteIPAddr REMOTE_IP_ADDR BIGINT String The IP address from where the client connected 15
baseIPAddr BASE_IP_ADDR BIGINT String This is the base IP address for quick search 15
nodeId NODE_ID BIGINT Long Id of the nodeId. 16
nodeHistoryId TRACKER_NODE_HISTORY_ID BIGINT Long Id of the Tracker Node History (if available). 16
userId USER_ID TEXT String User Id of the user if available. 256
loginId USER_LOGIN_ID TEXT String Login Id of the user if available. 256
groupId USER_GROUP_ID TEXT String GroupId of the user if available. 256
subGroupId USER_SUB_GROUP_ID TEXT String Sub GroupId of the user if available. 256
authStatus AUTH_STATUS INT int Status of the authentication. 3
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
executeTime EXEC_TIME TIMESTAMP Date The time when this request was processed. -
isRegistered IS_REGISTERED CHAR boolean Whether this node is registered. -
digitalSigCookie SENT_DIG_SIG_COOKIE VARCHAR String Digital signature cookie that was sent by the UI 128
expectedDigitalSigCookie EXPECTED_DIG_SIG_COOKIE VARCHAR String Digital signature cookie that was expected by the server from the UI for this node 128
secureCookie SENT_SECURE_COOKIE VARCHAR String Secure cookie that was sent by the UI 128
expectedSecureCookie EXPECTED_SECURE_COOKIE VARCHAR String The secure cookie that was expected by the server from the UI for this node 128
authClientType AUTH_CLIENT_TYPE_CODE INT int Type of the client used by the user for authentication 2
authClientVersion CLIENT_VERSION VARCHAR String Version of the client used for authentication 24
digitalClientType DIGITAL_CLIENT_TYPE_CODE INT int Type of the client used by the digital cookie client 2
digitalClientVersion DIGITAL_CLIENT_VERSION VARCHAR String Version of the client used by the digital cookie client 24
secureClientType SECURE_CLIENT_TYPE_CODE INT int Type of the client used by the secure cookie client 2
secureClientVersion SECURE_CLIENT_VERSION VARCHAR String Version of the client used by the secure cookie client 24
digitalFingerPrintId DIGITAL_FP_ID BIGINT Long Finger print id of the digital cookie request 16
fingerPrintId FPRINT_ID BIGINT Long Log id for the finger print 16
loadDuration LOAD_DURATION INT int Time taken to load the page 8
deviceScore DEVICE_SCORE INT int Score for the device for this login -
preAuthScore PREAUTH_SCORE INT int Pre Authentication score -
postAuthScore POST_SCORE INT int Post Authentication score -
preAuthAction PREAUTH_ACTION TEXT String Pre Authentication action 256
postAuthAction POST_ACTION TEXT String Post Authentication action 256
cityScore CITY_SCORE INT int Score for the city for this login -
stateScore STATE_SCORE INT int Score for the state for this login -
countryScore COUNTRY_SCORE INT int Score for the country for this login -
postProcessStatus POST_PROCESS_STATUS INT int Status of the post processing 5
postProcessResult POST_PROCESS_RESULT INT int Status of the post processing 5
loginFlag LOGIN_FLAG INT int Flagging this authentication 3
isDeviceDerived IS_DEVICE_DERIVED CHAR boolean Is the device identified using derived mechanism. -
notes NOTES VARCHAR String Note against this node 255

9.2.66 VTSesssionFPMap

Description: Session finger print mapping

Database table name :VT_SESS_FP_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
mapId MAP_ID (PK) BIGINT Long Map id 16
userNodeLogId USER_NODE_LOG_ID BIGINT Long Id of the user node log. 16
requestId REQUEST_ID TEXT String Id of the request. 256
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
clientType CLIENT_TYPE INT int Client type 5
fingerPrintId FP_ID BIGINT Long Finger print id 16

9.2.67 VCryptTrackerNode

Description: This represents a node/computer

Database table name :VCRYPT_TRACKER_NODE

Primary Keys : nodeId (NODE_ID)

Name DB name DB type Java type Description Length
nodeId NODE_ID (PK) BIGINT Long Node id for this node 16
nodeVersion NODE_VERSION INT int This keeps track of how many times this node got updated. 16
createTime CREATE_TIME DATETIME Date Date/Time for this node. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
relatedNodeId RELATED_NODE_ID BIGINT Long Related node. 16
relationType RELATION_TYPE INT int Type of the relation 5
digitalSigCookie DIG_SIG_COOKIE VARCHAR String Digital signature cookie 128
secureCookie SECURE_COOKIE VARCHAR String Secure cookie 128
remoteIPAddr REMOTE_IP_ADDR BIGINT String The IP address from where the client connected 15
remoteHost REMOTE_HOST TEXT String The host name from where the client connected 256
fingerPrintId FPRINT_ID BIGINT Long Log id for the finger print 16
digitalFingerPrintId DIGITAL_FP_ID BIGINT Long Finger print id of the digital cookie request 16
deviceStatus STATUS INT int Status of this device 3
deviceScore DEVICE_SCORE INT int Score for the device for this login 6
isDeviceDerived IS_DEVICE_DERIVED CHAR boolean Is the device identified using derived mechanism. -
secureCookieState IS_COOKIE_DISABLED INT int Is the secure cookie disabled for this device or in learn mode. 1
flashCookieState IS_FLASH_DISABLED INT int Is the flash cookie disabled for this device or in learn mode. 1
notes NOTES VARCHAR String Note against this message 255
cache CACHE TEXT String Cache 4000

9.2.68 VCryptTrackerNodeHistory

Description: This keeps the history of the a node/computer

Database table name :VCRYPT_TRACKER_NODE_HISTORY

Primary Keys : nodeHistoryId (NODE_HISTORY_ID)

Name DB name DB type Java type Description Length
nodeHistoryId NODE_HISTORY_ID (PK) BIGINT Long Id for this row 16
nodeId NODE_ID BIGINT Long Id of the nodeId. 16
nodeVersion NODE_VERSION INT int This keeps track of how many times this node got updated. 16
createTime CREATE_TIME DATETIME Date Date/Time for this node. -
digitalSigCookie DIG_SIG_COOKIE VARCHAR String Digital signature cookie 128
secureCookie SECURE_COOKIES VARCHAR String Secure cookie 128
remoteIPAddr REMOTE_IP_ADDR BIGINT String The IP address from where the client connected 15
remoteHost REMOTE_HOST TEXT String The host name from where the client connected 256
fingerPrintId FPRINT_ID BIGINT Long Log id for the finger print 16
digitalFingerPrintId DIGITAL_FP_ID BIGINT Long Finger print id of the digital cookie request 16
isSecureCookieConfirmed IS_SECURE_CONFIRMED CHAR boolean Whether the secure cookie is confirmed to be written -
isFlashCookieConfirmed IS_FLASH_CONFIRMED CHAR boolean Whether the flash cookie is confirmed to be written -
deviceScore DEVICE_SCORE INT int Score for the device for this login -
isDeviceDerived IS_DEVICE_DERIVED CHAR boolean Is the device identified using derived mechanism. -
notes NOTES VARCHAR String Note against this node 255

9.2.69 VTUser

Description: This maintains the list of the users using the tracker

Database table name :VT_USER

Primary Keys : localUserId (LOCAL_USER_ID)

Name DB name DB type Java type Description Length
localUserId LOCAL_USER_ID (PK) BIGINT Long Id of the user 16
extUserId EXT_USER_ID VARCHAR String External user id 255
loginId LOGIN_ID VARCHAR String Login id of the user 255
groupId USERGROUP_ID BIGINT Long Id of the group to which user belongs to. 16
isValid IS_VALID CHAR boolean The user is considered valid if the user had authenticated successfully atleast once. -
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -
firstLoginTime FIRST_LOGIN_TIME DATETIME Date First time login for this user. -
notes NOTES VARCHAR String Notes for this user 255
cache CACHE TEXT String Cache 4000

9.2.70 VTInvalidUser

Description: This maintains the list of invalid users

Database table name :VT_INVALID_USERS

Primary Keys : userId (USER_ID)

Name DB name DB type Java type Description Length
userId USER_ID (PK) BIGINT Long Id of the user 16
loginId LOGIN_ID VARCHAR String Login id of the user 255
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -
loginCount LOGIN_COUNT INT int Total login count for this user 10
imagePath IMAGE_PATH TEXT String Image path 512

9.2.71 VTSessionActionMap

Description: This maintains the actions for each session

Database table name :VT_SESSION_ACTION_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
mapId MAP_ID (PK) BIGINT Long Map Id 16
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
requestId REQUEST_ID TEXT String Id of the request. This is used to co-relate the post authentication request. 256
trxId TRX_ID BIGINT Long Id for the transaction for this log 16
runtimeType RUNTIME_TYPE INT int Type of runtime 6
action ACTION TEXT String Actions for this runtime and session 256
originalAction ORIGINAL_ACTION TEXT String This was the original action, which got overrriden finally 256
overrideReason OVERRIDE_REASON INT int Override reason -
actionList ACTION_LIST TEXT String List of action. 256
score SCORE INT int Score for this runtime and runtime. The same score will appear for all the rows for this transaction -
isFinalAction IS_FINAL_ACTION CHAR boolean Is this final action -

9.2.72 VTUserGroup

Description: This contains the user group details.

Database table name :VT_USER_GROUPS

Primary Keys : localUserGroupId (LOCAL_GROUP_ID)

Name DB name DB type Java type Description Length Enum values
localUserGroupId LOCAL_GROUP_ID (PK) BIGINT Long Id for the UserGroup 16 -
extUserGroupId EXT_USERGROUP_ID VARCHAR String External User group id 255 -
description DESCRIPTION TEXT String Description for this group. 2000 -
createTime CREATE_TIME DATETIME Date Date/Time creation of this user. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
userListId USER_LIST_ID BIGINT Long Id of the userList 16 -
status USERGROUP_STATUS_CODE INT int Status of the User group 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED
notes NOTES TEXT String Note 4000 -

9.2.73 VTUserDeviceMap

Description: This maintains the list of devices the user is using

Database table name :VT_USER_DEVICE_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
mapId MAP_ID (PK) BIGINT Long Map id 16
userId USER_ID BIGINT Long Id of the user. 16
nodeId NODE_ID BIGINT Long Id of the nodeId. 16
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
lastUsedTime LAST_USED_TIME DATETIME Date Last used time for this device. -
lastAuthStatus LAST_AUTH_STATUS INT int Last authentication status for the user using this device. 3
isSecure IS_SECURE CHAR boolean Is this node secure for this user. -
totalCount TOTAL_COUNT INT int Total authentication count for this user/device 10
successCount SUCCESS_COUNT INT int Total success count for this user/device 10
failedCount FAILED_COUNT INT int Total failed count for this user/device 10
cache CACHE TEXT String Cache 4000
secureCookieState IS_COOKIE_DISABLED INT int Is the secure cookie disabled for this device or in learn mode. 1
flashCookieState IS_FLASH_DISABLED INT int Is the flash cookie disabled for this device or in learn mode. 1
fingerPrintId FPRINT_ID BIGINT Long Finger print of secure cookie 16
digitalFingerPrintId DIGITAL_FP_ID BIGINT Long Finger print id of the digital cookie request 16

9.2.74 VTEntityOne

Description: EntityOne details

Database table name :VT_ENTITY_ONE

Primary Keys : entityId (ENTITY_ID)

Name DB name DB type Java type Description Length
entityId ENTITY_ID (PK) BIGINT Long Id of the entity 16
extEntityId EXT_ENTITY_ID VARCHAR String External entity id 255
entityName ENTITYNAME TEXT String Name of the entity 4000
entityKey ENTITY_KEY TEXT String Key for the entity 4000
entityType ENTITY_TYPE INT int Type of the entity 6
entityDefId ENTITY_DEF_ID BIGINT Long Id for the entity type 16
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -
expiryTime EXPIRY_TIME DATETIME Date Expiry Date value. -
renewTime RENEW_TIME DATETIME Date Renew Date value. -
notes NOTES VARCHAR String Notes for this user 255
cache CACHE TEXT String Cache 4000

9.2.75 VTEntityOneProfile

Description: This maintains the entity profile

Database table name :VT_ENTITY_ONE_PROFILE

Primary Keys : profileId (PROFILE_ID)

Name DB name DB type Java type Description Length
profileId PROFILE_ID (PK) BIGINT Long Id of the profile 16
entityId ENTITY_ID BIGINT Long Id of the entity. 16
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
profileTypeId PROFILE_TYPE_ID BIGINT Long - 16
dataDefId DATA_DEF_ID BIGINT Long Data def id 16
rowOrder ROW_ORDER INT int Row order 6
dataType DATA_TYPE INT int Type of data 6
data DATA TEXT String Data 512
data1 DATA1 TEXT String Data one 256
data2 DATA2 TEXT String Data two 256
data3 DATA3 TEXT String Data three 256
data4 DATA4 TEXT String Data four 256
data5 DATA5 TEXT String Data five 256
data6 DATA6 TEXT String Data six 256
data7 DATA7 TEXT String Data seven 256
data8 DATA8 TEXT String Data eight 256
data9 DATA9 TEXT String Data nine 256
data10 DATA10 TEXT String Data ten 256
numData0 NUM_DATA0 BIGINT Long Numeric data 0 16
numData1 NUM_DATA1 BIGINT Long Numeric data 1 16
numData2 NUM_DATA2 BIGINT Long Numeric data 2 16
expirationTime EXPIRE_TIME DATETIME Date Date/Time when this profile expires -
totalCount TOTAL_COUNT INT int Count for this profile 10

9.2.76 VTEntityOneMap

Description: This maintains the list of entities associated with the user

Database table name :VT_USER_ENTITY1_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
mapId MAP_ID (PK) BIGINT Long Map id 16
entityId ENTITY_ID BIGINT Long Id of the entity. 16
objectId MAP_OBJ_ID BIGINT Long Id of the mapped object. 16
objectType OBJECT_TYPE INT int Type of the object. 6
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
status STATUS INT int Status of the transaction (where applicable) 5
defMapId DEF_MAP_ID BIGINT Long Id to the definition map 16
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
expiryTime EXPIRY_TIME DATETIME Date Expiry Date value. -
renewTime RENEW_TIME DATETIME Date Renew Date value. -

9.2.77 VTEntityTrxMap

Description: This maintains the list of entities associated with the transaction

Database table name :VT_ENT_TRX_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
mapId MAP_ID (PK) BIGINT Long Map id 16
trxId TRX_ID BIGINT Long Id of the transaction. 16
objectId MAP_OBJ_ID BIGINT Long Id of the mapped object. 16
defMapId DEF_MAP_ID BIGINT Long Id to the definition map 16
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
status STATUS INT int Status of the transaction (where applicable) 5
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -

9.2.78 VTUserProfile

Description: This maintains the user profile

Database table name :VT_USER_PROFILE

Primary Keys : profileId (PROFILE_ID)

Name DB name DB type Java type Description Length
profileId PROFILE_ID (PK) BIGINT Long Id of the profile 16
userId USER_ID BIGINT Long Id of the user. 16
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
status STATUS INT int Status of the transaction (where applicable) 5
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
profileTypeId PROFILE_TYPE_ID BIGINT Long - 16
dataType DATA_TYPE INT int Type of data 6
data DATA TEXT String Data 512
data1 DATA1 TEXT String Data one 256
data2 DATA2 TEXT String Data two 256
data3 DATA3 TEXT String Data three 256
data4 DATA4 TEXT String Data four 256
data5 DATA5 TEXT String Data five 256
data6 DATA6 TEXT String Data six 256
data7 DATA7 TEXT String Data seven 256
data8 DATA8 TEXT String Data eight 256
data9 DATA9 TEXT String Data nine 256
data10 DATA10 TEXT String Data ten 256
numData0 NUM_DATA0 BIGINT Long Numeric data 0 16
numData1 NUM_DATA1 BIGINT Long Numeric data 1 16
numData2 NUM_DATA2 BIGINT Long Numeric data 2 16
expirationTime EXPIRE_TIME DATETIME Date Date/Time when this profile expires -
totalCount TOTAL_COUNT INT int Count for this profile 10

9.2.79 VTDeviceProfile

Description: This maintains the device profile

Database table name :VT_DEVICE_PROFILE

Primary Keys : profileId (PROFILE_ID)

Name DB name DB type Java type Description Length
profileId PROFILE_ID (PK) BIGINT Long Id of the profile 16
deviceId NODE_ID BIGINT Long Id of the nodeId. 16
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
status STATUS INT int Status of the transaction (where applicable) 5
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
profileTypeId PROFILE_TYPE_ID BIGINT Long - 16
dataType DATA_TYPE INT int Type of data 6
data DATA TEXT String Data 512
data1 DATA1 TEXT String Data one 256
data2 DATA2 TEXT String Data two 256
data3 DATA3 TEXT String Data three 256
data4 DATA4 TEXT String Data four 256
data5 DATA5 TEXT String Data five 256
data6 DATA6 TEXT String Data six 256
data7 DATA7 TEXT String Data seven 256
data8 DATA8 TEXT String Data eight 256
data9 DATA9 TEXT String Data nine 256
data10 DATA10 TEXT String Data ten 256
numData0 NUM_DATA0 BIGINT Long Numeric data 0 16
numData1 NUM_DATA1 BIGINT Long Numeric data 1 16
numData2 NUM_DATA2 BIGINT Long Numeric data 2 16
expirationTime EXPIRE_TIME DATETIME Date Date/Time when this profile expires -
totalCount TOTAL_COUNT INT int Count for this profile 10

9.2.80 VTIPProfile

Description: This maintains the location profile

Database table name :VT_IP_PROFILE

Primary Keys : profileId (PROFILE_ID)

Name DB name DB type Java type Description Length
profileId PROFILE_ID (PK) BIGINT Long Id of the profile 16
ipAddr REMOTE_IP_ADDR BIGINT String The IP address from where the client connected 15
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
profileTypeId PROFILE_TYPE_ID BIGINT Long - 16
dataType DATA_TYPE INT int Type of data 6
data DATA TEXT String Data 512
data1 DATA1 TEXT String Data one 256
data2 DATA2 TEXT String Data two 256
data3 DATA3 TEXT String Data three 256
data4 DATA4 TEXT String Data four 256
data5 DATA5 TEXT String Data five 256
data6 DATA6 TEXT String Data six 256
data7 DATA7 TEXT String Data seven 256
data8 DATA8 TEXT String Data eight 256
data9 DATA9 TEXT String Data nine 256
data10 DATA10 TEXT String Data ten 256
numData0 NUM_DATA0 BIGINT Long Numeric data 0 16
numData1 NUM_DATA1 BIGINT Long Numeric data 1 16
numData2 NUM_DATA2 BIGINT Long Numeric data 2 16
expirationTime EXPIRE_TIME DATETIME Date Date/Time when this profile expires -
totalCount TOTAL_COUNT INT int Count for this profile 10

9.2.81 VTBaseIPProfile

Description: This maintains the location profile

Database table name :VT_BASE_IP_PROFILE

Primary Keys : profileId (PROFILE_ID)

Name DB name DB type Java type Description Length
profileId PROFILE_ID (PK) BIGINT Long Id of the profile 16
baseIPAddr REMOTE_IP_ADDR BIGINT String The IP address from where the client connected 15
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
profileTypeId PROFILE_TYPE_ID BIGINT Long - 16
dataType DATA_TYPE INT int Type of data 6
data DATA TEXT String Data 512
data1 DATA1 TEXT String Data one 256
data2 DATA2 TEXT String Data two 256
data3 DATA3 TEXT String Data three 256
data4 DATA4 TEXT String Data four 256
data5 DATA5 TEXT String Data five 256
data6 DATA6 TEXT String Data six 256
data7 DATA7 TEXT String Data seven 256
data8 DATA8 TEXT String Data eight 256
data9 DATA9 TEXT String Data nine 256
data10 DATA10 TEXT String Data ten 256
numData0 NUM_DATA0 BIGINT Long Numeric data 0 16
numData1 NUM_DATA1 BIGINT Long Numeric data 1 16
numData2 NUM_DATA2 BIGINT Long Numeric data 2 16
expirationTime EXPIRE_TIME DATETIME Date Date/Time when this profile expires -
totalCount TOTAL_COUNT INT int Count for this profile 10

9.2.82 VTCountryProfile

Description: This maintains the country profile

Database table name :VT_COUNTRY_PROFILE

Primary Keys : profileId (PROFILE_ID)

Name DB name DB type Java type Description Length
profileId PROFILE_ID (PK) BIGINT Long Id of the profile 16
countryId COUNTRY_ID BIGINT Long Id for the country to which this state belongs to. 16
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
profileTypeId PROFILE_TYPE_ID BIGINT Long - 16
dataType DATA_TYPE INT int Type of data 6
data DATA TEXT String Data 512
data1 DATA1 TEXT String Data one 256
data2 DATA2 TEXT String Data two 256
data3 DATA3 TEXT String Data three 256
data4 DATA4 TEXT String Data four 256
data5 DATA5 TEXT String Data five 256
data6 DATA6 TEXT String Data six 256
data7 DATA7 TEXT String Data seven 256
data8 DATA8 TEXT String Data eight 256
data9 DATA9 TEXT String Data nine 256
data10 DATA10 TEXT String Data ten 256
numData0 NUM_DATA0 BIGINT Long Numeric data 0 16
numData1 NUM_DATA1 BIGINT Long Numeric data 1 16
numData2 NUM_DATA2 BIGINT Long Numeric data 2 16
expirationTime EXPIRE_TIME DATETIME Date Date/Time when this profile expires -
totalCount TOTAL_COUNT INT int Count for this profile 10

9.2.83 VTStateProfile

Description: This maintains the state profile

Database table name :VT_STATE_PROFILE

Primary Keys : profileId (PROFILE_ID)

Name DB name DB type Java type Description Length
profileId PROFILE_ID (PK) BIGINT Long Id of the profile 16
stateId STATE_ID BIGINT Long Id for the state to which this state belongs to. 16
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
profileTypeId PROFILE_TYPE_ID BIGINT Long - 16
dataType DATA_TYPE INT int Type of data 6
data DATA TEXT String Data 512
data1 DATA1 TEXT String Data one 256
data2 DATA2 TEXT String Data two 256
data3 DATA3 TEXT String Data three 256
data4 DATA4 TEXT String Data four 256
data5 DATA5 TEXT String Data five 256
data6 DATA6 TEXT String Data six 256
data7 DATA7 TEXT String Data seven 256
data8 DATA8 TEXT String Data eight 256
data9 DATA9 TEXT String Data nine 256
data10 DATA10 TEXT String Data ten 256
numData0 NUM_DATA0 BIGINT Long Numeric data 0 16
numData1 NUM_DATA1 BIGINT Long Numeric data 1 16
numData2 NUM_DATA2 BIGINT Long Numeric data 2 16
expirationTime EXPIRE_TIME DATETIME Date Date/Time when this profile expires -
totalCount TOTAL_COUNT INT int Count for this profile 10

9.2.84 VTCityProfile

Description: This maintains the city profile

Database table name :VT_CITY_PROFILE

Primary Keys : profileId (PROFILE_ID)

Name DB name DB type Java type Description Length
profileId PROFILE_ID (PK) BIGINT Long Id of the profile 16
cityId CITY_ID BIGINT Long Id for the city to which this state belongs to. 16
requestId REQUEST_ID TEXT String Id of the request which last updated this row 256
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
profileTypeId PROFILE_TYPE_ID BIGINT Long - 16
dataType DATA_TYPE INT int Type of data 6
data DATA TEXT String Data 512
data1 DATA1 TEXT String Data one 256
data2 DATA2 TEXT String Data two 256
data3 DATA3 TEXT String Data three 256
data4 DATA4 TEXT String Data four 256
data5 DATA5 TEXT String Data five 256
data6 DATA6 TEXT String Data six 256
data7 DATA7 TEXT String Data seven 256
data8 DATA8 TEXT String Data eight 256
data9 DATA9 TEXT String Data nine 256
data10 DATA10 TEXT String Data ten 256
numData0 NUM_DATA0 BIGINT Long Numeric data 0 16
numData1 NUM_DATA1 BIGINT Long Numeric data 1 16
numData2 NUM_DATA2 BIGINT Long Numeric data 2 16
expirationTime EXPIRE_TIME DATETIME Date Date/Time when this profile expires -
totalCount TOTAL_COUNT INT int Count for this profile 10

9.2.85 VTWFYears

Description: This has the years to capture

Database table name :VT_WF_YEARS

Primary Keys : wfId (WF_ID)

Name DB name DB type Java type Description Length
wfId WF_ID (PK) BIGINT Long wf id 16
objectId OBJECT_ID BIGINT Long Id of the user. 16
entityDefId ENTITY_DEF_ID BIGINT Long Id for the entity type 16
fingerPrintId FPRINT_ID BIGINT Long Log id for the finger print 16
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
year1 YEAR_1 INT int Year one 6
year2 YEAR_2 INT int Year two 6
year3 YEAR_3 INT int Year three 6
year4 YEAR_4 INT int Year four 6
year5 YEAR_5 INT int Year five 6
year6 YEAR_6 INT int Year six 6
year7 YEAR_7 INT int Year seven 6
year8 YEAR_8 INT int Year eight 6

9.2.86 VTWFMonths

Description: This has the months to capture

Database table name :VT_WF_MONTHS

Primary Keys : wfId (WF_ID)

Name DB name DB type Java type Description Length
wfId WF_ID (PK) BIGINT Long wf id 16
objectId OBJECT_ID BIGINT Long Id of the user. 16
entityDefId ENTITY_DEF_ID BIGINT Long Id for the entity type 16
fingerPrintId FPRINT_ID BIGINT Long Log id for the finger print 16
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
month1 MONTH_1 INT int Month one 6
month2 MONTH_2 INT int Month two 6
month3 MONTH_3 INT int Month three 6
month4 MONTH_4 INT int Month four 6
month5 MONTH_5 INT int Month five 6
month6 MONTH_6 INT int Month six 6
month7 MONTH_7 INT int Month seven 6
month8 MONTH_8 INT int Month eight 6
month9 MONTH_9 INT int Month nine 6
month10 MONTH_10 INT int Month ten 6
month11 MONTH_11 INT int Month eleven 6
month12 MONTH_12 INT int Month twelve 6
month13 MONTH_13 INT int Month thirteen 6

9.2.87 VTWFDays

Description: This has the days to capture

Database table name :VT_WF_DAYS

Primary Keys : wfId (WF_ID)

Name DB name DB type Java type Description Length
wfId WF_ID (PK) BIGINT Long wf id 16
objectId OBJECT_ID BIGINT Long Id of the user. 16
entityDefId ENTITY_DEF_ID BIGINT Long Id for the entity type 16
fingerPrintId FPRINT_ID BIGINT Long Log id for the finger print 16
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
day1 DAY_1 INT int Day one 6
day2 DAY_2 INT int Day two 6
day3 DAY_3 INT int Day three 6
day4 DAY_4 INT int Day four 6
day5 DAY_5 INT int Day five 6
day6 DAY_6 INT int Day six 6
day7 DAY_7 INT int Day seven 6
day8 DAY_8 INT int Day eight 6
day9 DAY_9 INT int Day nine 6
day10 DAY_10 INT int Day ten 6
day11 DAY_11 INT int Day eleven 6
day12 DAY_12 INT int Day twelve 6
day13 DAY_13 INT int Day thirteen 6
day14 DAY_14 INT int Day fourteen 6
day15 DAY_15 INT int Day fifteen 6
day16 DAY_16 INT int Day sixteen 6
day17 DAY_17 INT int Day seventeen 6
day18 DAY_18 INT int Day eighteen 6
day19 DAY_19 INT int Day nineteen 6
day20 DAY_20 INT int Day twenty 6
day21 DAY_21 INT int Day twenty one 6
day22 DAY_22 INT int Day twenty two 6
day23 DAY_23 INT int Day twenty three 6
day24 DAY_24 INT int Day twenty four 6
day25 DAY_25 INT int Day twenty five 6
day26 DAY_26 INT int Day twenty six 6
day27 DAY_27 INT int Day twenty seven 6
day28 DAY_28 INT int Day twenty eight 6
day29 DAY_29 INT int Day twenty nine 6
day30 DAY_30 INT int Day thirty 6
day31 DAY_31 INT int Day thirty 6
day32 DAY_32 INT int Day thirty 6

9.2.88 VTWFHours

Description: This has the hours to capture

Database table name :VT_WF_HOURS

Primary Keys : wfId (WF_ID)

Name DB name DB type Java type Description Length
wfId WF_ID (PK) BIGINT Long wf id 16
objectId OBJECT_ID BIGINT Long Id of the user. 16
entityDefId ENTITY_DEF_ID BIGINT Long Id for the entity type 16
fingerPrintId FPRINT_ID BIGINT Long Log id for the finger print 16
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
hour1 HOUR_1 INT int Hour one 6
hour2 HOUR_2 INT int Hour two 6
hour3 HOUR_3 INT int Hour three 6
hour4 HOUR_4 INT int Hour four 6
hour5 HOUR_5 INT int Hour five 6
hour6 HOUR_6 INT int Hour six 6
hour7 HOUR_7 INT int Hour seven 6
hour8 HOUR_8 INT int Hour eight 6
hour9 HOUR_9 INT int Hour nine 6
hour10 HOUR_10 INT int Hour ten 6
hour11 HOUR_11 INT int Hour eleven 6
hour12 HOUR_12 INT int Hour twelve 6
hour13 HOUR_13 INT int Hour thirteen 6
hour14 HOUR_14 INT int Hour fourteen 6
hour15 HOUR_15 INT int Hour fifteen 6
hour16 HOUR_16 INT int Hour sixteen 6
hour17 HOUR_17 INT int Hour seventeen 6
hour18 HOUR_18 INT int Hour eighteen 6
hour19 HOUR_19 INT int Hour nineteen 6
hour20 HOUR_20 INT int Hour twenty 6
hour21 HOUR_21 INT int Hour twenty one 6
hour22 HOUR_22 INT int Hour twenty two 6
hour23 HOUR_23 INT int Hour twenty three 6
hour24 HOUR_24 INT int Hour twenty four 6
hour25 HOUR_25 INT int Hour twenty five 6

9.2.89 VTransactionLog

Description: This is the transaction log

Database table name :VT_TRX_LOGS

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log id 16
createTime CREATE_TIME DATETIME Date Date/Time of this transaction. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
userId USER_ID BIGINT Long Id of the user. 16
requestId REQUEST_ID TEXT String Id of the login session. 256
extTransactionId EXT_TRX_ID VARCHAR String External transaction id 255
trxDefId TRX_DEF_ID BIGINT Long Transaction def id 16
transactionType TRX_TYPE INT int Transaction type 3
status STATUS INT int Status of the transaction (where applicable) 5
score SCORE INT Integer Score for this transaction -
ruleAction RULE_ACTION TEXT String Action 256
trxFlag TRX_FLAG INT int Flagging this transaction 3
postProcessStatus POST_PROCESS_STATUS INT int Status of the post processing 5
postProcessResult POST_PROCESS_RESULT INT int Status of the post processing 5
transactionData TRX_DATA TEXT String Transaction data as name value pair. 4000
data1 DATA1 TEXT String Data one 256
data2 DATA2 TEXT String Data two 256
data3 DATA3 TEXT String Data three 256
data4 DATA4 TEXT String Data four 256
data5 DATA5 TEXT String Data five 256
data6 DATA6 TEXT String Data six 256
data7 DATA7 TEXT String Data seven 256
data8 DATA8 TEXT String Data eight 256
data9 DATA9 TEXT String Data nine 256
data10 DATA10 TEXT String Data ten 256

9.2.90 VTTrxData

Description: This contains the data associated with the transaction

Database table name :VT_TRX_DATA

Primary Keys : trxDataId (TRX_DATA_ID)

Name DB name DB type Java type Description Length
trxDataId TRX_DATA_ID (PK) BIGINT Long Transaction data id 16
trxId TRX_ID BIGINT Long Id of the transaction. 16
dataDefId DATA_DEF_ID BIGINT Long Data def id 16
rowOrder ROW_ORDER INT int Row order 6
createTime CREATE_TIME DATETIME Date Date/Time when this object was created. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
data1 DATA1 TEXT String Data one 4000
data2 DATA2 TEXT String Data two 4000
data3 DATA3 TEXT String Data three 4000
data4 DATA4 TEXT String Data four 4000
data5 DATA5 TEXT String Data five 4000
data6 DATA6 TEXT String Data six 4000
data7 DATA7 TEXT String Data seven 4000
data8 DATA8 TEXT String Data eight 4000
data9 DATA9 TEXT String Data nine 4000
data10 DATA10 TEXT String Data ten 4000
numData0 NUM_DATA0 BIGINT Long Numeric data 0 16
numData1 NUM_DATA1 BIGINT Long Numeric data 1 16
numData2 NUM_DATA2 BIGINT Long Numeric data 2 16

9.2.91 VTTrxDef

Description: Definition of transaction meta data

Database table name :VT_TRX_DEF

Primary Keys : trxDefId (TRX_DEF_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
trxDefId TRX_DEF_ID (PK) BIGINT Long Id for transaction definition 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name for transaction. 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the object 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
trxDefKey TRX_DEF_KEY TEXT String Key name to be used for the transaction e.g bill_pay, etc. This has to be passed in the handleTransactionLog API call. The context map should have an attribute key called transactionType 4000 -
status STATUS INT int Status 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED
notes NOTES TEXT String Note for this object 4000 -

9.2.92 VTTrxDefHist

Description: This is the object history for VTTrxDefHist

Database table name :VT_TRX_DEF_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
trxDefId TRX_DEF_ID BIGINT Long Id for transaction definition 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for transaction. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
trxDefKey TRX_DEF_KEY TEXT String Key name to be used for the transaction e.g bill_pay, etc. This has to be passed in the handleTransactionLog API call. The context map should have an attribute key called transactionType 4000
status STATUS INT int Status 2
notes NOTES TEXT String Note for this object 4000

9.2.93 VTTrxInputDef

Description: Definition of transaction input meta data

Database table name :VT_TRX_INPUT_DEF

Primary Keys : trxDefId (TRX_DEF_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
trxDefId TRX_DEF_ID (PK) BIGINT Long Id for transaction definition 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name for transaction. 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the object 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
trxDefKey TRX_DEF_KEY TEXT String Key name to be used for the transaction e.g bill_pay, etc. This has to be passed in the handleTransactionLog API call. The context map should have an attribute key called transactionType 4000 -
status STATUS INT int Status 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED
notes NOTES TEXT String Note for this object 4000 -

9.2.94 VTTrxInputDefHist

Description: This is the object history for VTTrxInputDefHist

Database table name :VT_TRX_INPUT_DEF_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
trxDefId TRX_DEF_ID BIGINT Long Id for transaction definition 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for transaction. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
trxDefKey TRX_DEF_KEY TEXT String Key name to be used for the transaction e.g bill_pay, etc. This has to be passed in the handleTransactionLog API call. The context map should have an attribute key called transactionType 4000
status STATUS INT int Status 2
notes NOTES TEXT String Note for this object 4000

9.2.95 VTEntityDef

Description: Definition of Entity meta data

Database table name :VT_ENTITY_DEF

Primary Keys : entityDefId (ENTITY_DEF_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
entityDefId ENTITY_DEF_ID (PK) BIGINT Long Id for entity definition 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name for entity. 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the object 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
entityDefKey ENTITY_DEF_KEY TEXT String Key of the entity. E.g. address, merchant, etc 256 -
status STATUS INT int Status 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED
keyGenScheme KEY_GEN_SCHEME INT int Key generation scheme - -
keyGenParams KEY_GEN_PARAMS TEXT String Static params to be passed to the java class for key genration 4000 -
nameGenScheme NAME_GEN_SCHEME INT int Name generation scheme - -
nameGenParams NAME_GEN_PARAMS TEXT String Static params to be passed to the java class for name generation 4000 -
notes NOTES TEXT String Note for this object 4000 -

9.2.96 VTEntityDefHist

Description: This is the object history for VTEntityDefHist

Database table name :VT_ENTITY_DEF_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
entityDefId ENTITY_DEF_ID BIGINT Long Id for entity definition 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for entity. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
entityDefKey ENTITY_DEF_KEY TEXT String Key of the entity. E.g. address, merchant, etc 256
status STATUS INT int Status 2
keyGenScheme KEY_GEN_SCHEME INT int Key generation scheme -
keyGenParams KEY_GEN_PARAMS TEXT String Static params to be passed to the java class for key genration 4000
nameGenScheme NAME_GEN_SCHEME INT int Name generation scheme -
nameGenParams NAME_GEN_PARAMS TEXT String Static params to be passed to the java class for name generation 4000
notes NOTES TEXT String Note for this object 4000

9.2.97 VTTrxDefEntityDefMap

Description: Association between entity and transaction

Database table name :VT_TRX_ENT_DEFS_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
mapId MAP_ID (PK) BIGINT Long Id for map 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name for the map. 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the object 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
trxDefId TRX_DEF_ID BIGINT Long Parent data def id 16 -
entityDefId ENTITY_DEF_ID BIGINT Long Parent data def id 16 -
relationType RELATION_TYPE TEXT String Type of the relation 4000 -
displayOrder DISP_ORDER INT int Display order 6 -
status STATUS INT int Status 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED
notes NOTES TEXT String Note for this object 4000 -

9.2.98 VTTrxDefEntityDefMapHist

Description: History for VTTrxDefEntityDefMap

Database table name :VT_TRX_ENT_DEFS_MAP_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
mapId MAP_ID BIGINT Long Id for map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for the map. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
trxDefId TRX_DEF_ID BIGINT Long Parent data def id 16
entityDefId ENTITY_DEF_ID BIGINT Long Parent data def id 16
relationType RELATION_TYPE TEXT String Type of the relation 4000
displayOrder DISP_ORDER INT int Display order 6
status STATUS INT int Status 2
notes NOTES TEXT String Note for this object 4000

9.2.99 VTEntityDefEntityDefMap

Description: Association between entity and transaction

Database table name :VT_ENT_DEFS_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -
mapId MAP_ID (PK) BIGINT Long Id for map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for the map. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
entityDefId1 ENTITY_DEF_ID_1 BIGINT Long Parent entity def id of object 1 16
entityDefId2 ENTITY_DEF_ID_2 BIGINT Long Parent entity def id of object 2 16
relationType RELATION_TYPE TEXT String Type of the relation 4000
displayOrder DISP_ORDER INT int Display order 6
notes NOTES TEXT String Note for this object 4000

9.2.100 VTEntityDefEntityDefMapHist

Description: History for VTEntityDefEntityDefMap

Database table name :VT_ENT_DEFS_MAP_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
mapId MAP_ID BIGINT Long Id for map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for the map. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
entityDefId1 ENTITY_DEF_ID_1 BIGINT Long Parent entity def id of object 1 16
entityDefId2 ENTITY_DEF_ID_2 BIGINT Long Parent entity def id of object 2 16
relationType RELATION_TYPE TEXT String Type of the relation 4000
displayOrder DISP_ORDER INT int Display order 6
notes NOTES TEXT String Note for this object 4000

9.2.101 VTDataDef

Description: Definition of Data meta

Database table name :VT_DATA_DEF

Primary Keys : dataDefId (DATA_DEF_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
dataDefId DATA_DEF_ID (PK) BIGINT Long Id for data definition 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name for data def. 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the object 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
dataDefKey DATA_DEF_KEY TEXT String Key of the data. E.g. street_name, zip_code, etc 256 -
status STATUS INT int Status 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED
dataDefType DATA_DEF_TYPE INT int Type of data def. Whether it is dynamic or static 5 -
isRequired IS_REQUIRED CHAR boolean Is this data required by default. - -
isAutoCreated IS_AUTO_CREATED CHAR boolean Whether this auto created. - -
notes NOTES TEXT String Note for this object 4000 -

9.2.102 VTDataDefHist

Description: This is the object history for VTDataDef

Database table name :VT_DATA_DEF_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
dataDefId DATA_DEF_ID BIGINT Long Id for data definition 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for data def. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
dataDefKey DATA_DEF_KEY TEXT String Key of the data. E.g. street_name, zip_code, etc 256
status STATUS INT int Status 2
dataDefType DATA_DEF_TYPE INT int Type of data def. Whether it is dynamic or static 5
isRequired IS_REQUIRED CHAR boolean Is this data required by default. -
isAutoCreated IS_AUTO_CREATED CHAR boolean Whether this auto created. -
notes NOTES TEXT String Note for this object 4000

9.2.103 VTDataDefElement

Description: Definition of elements in Data meta

Database table name :VT_DATA_DEF_ELEM

Primary Keys : dataDefElementId (DATA_DEF_ELEM_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
dataDefElementId DATA_DEF_ELEM_ID (PK) BIGINT Long Id for data definition element 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
defKey DEF_KEY TEXT String Key to identify this data 256 -
name LABEL TEXT String Name for column. 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the object 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
dataDefId DATA_DEF_ID BIGINT Long Parent data def id 16 -
dataRow DATA_ROW INT int Row for this data element - -
dataColumn DATA_COL INT int Column for this data element - -
isEncrypted IS_ENCRYPTED CHAR boolean Is this data element encrypted - -
dataType DATA_TYPE INT int Type of the data - -
dataFormat DATA_FORMAT TEXT String Format of the data 4000 -
status STATUS INT int Status 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED
isRequired IS_REQUIRED CHAR boolean Is this data required by default. - -
nameGenScheme NAME_GEN_SCHEME INT int Name generation scheme - -
nameGenParams NAME_GEN_PARAMS TEXT String Static params to be passed to the java class for name generation 4000 -
isAutoCreated IS_AUTO_CREATED CHAR boolean Whether this auto created. - -
notes NOTES TEXT String Note for this object 4000 -

9.2.104 VTDataDefElementHist

Description: History for VTDataDefElement

Database table name :VT_DATA_DEF_ELEM_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
dataDefElementId DATA_DEF_ELEM_ID BIGINT Long Id for data definition element 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
defKey DEF_KEY TEXT String Key to identify this data 256
name LABEL TEXT String Name for column. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
dataDefId DATA_DEF_ID BIGINT Long Parent data def id 16
dataRow DATA_ROW INT int Row for this data element -
dataColumn DATA_COL INT int Column for this data element -
isEncrypted IS_ENCRYPTED CHAR boolean Is this data element encrypted -
dataType DATA_TYPE INT int Type of the data -
dataFormat DATA_FORMAT TEXT String Format of the data 4000
status STATUS INT int Status 2
isRequired IS_REQUIRED CHAR boolean Is this data required by default. -
nameGenScheme NAME_GEN_SCHEME INT int Name generation scheme -
nameGenParams NAME_GEN_PARAMS TEXT String Static params to be passed to the java class for name generation 4000
isAutoCreated IS_AUTO_CREATED CHAR boolean Whether this auto created. -
notes NOTES TEXT String Note for this object 4000

9.2.105 VTDataDefMap

Description: Map between Objects and Data Def

Database table name :VT_DATA_DEF_MAP

Primary Keys : mapId (MAP_ID)

Name DB name DB type Java type Description Length
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. -
updateTime UPDATE_TIME TIMESTAMP Date Date value. -
mapId MAP_ID (PK) BIGINT Long Id for map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for the map. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
dataDefId DATA_DEF_ID BIGINT Long Parent data def id 16
parentObjectType PARENT_OBJ_TYPE INT int Type of source object 5
parentObjectId PARENT_OBJECT_ID BIGINT Long Parent to which datadef belongs to -
relationType RELATION_TYPE TEXT String Type of the relation 4000
notes NOTES TEXT String Note for this object 4000

9.2.106 VTDataDefMapHist

Description: History for VTDataDefMap

Database table name :VT_DATA_DEF_MAP_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
mapId MAP_ID BIGINT Long Id for map 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for the map. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
dataDefId DATA_DEF_ID BIGINT Long Parent data def id 16
parentObjectType PARENT_OBJ_TYPE INT int Type of source object 5
parentObjectId PARENT_OBJECT_ID BIGINT Long Parent to which datadef belongs to -
relationType RELATION_TYPE TEXT String Type of the relation 4000
notes NOTES TEXT String Note for this object 4000

9.2.107 VTDataDefTranslation

Description: Translation from one element to another, e.g. input transaction to normalized transaction data. Or transaction to entity

Database table name :VT_DATA_DEF_TRANS

Primary Keys : translationId (ELEM_MAP_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
translationId ELEM_MAP_ID (PK) BIGINT Long Id for data definition element 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name for this data map. 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the object 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
translationScheme TRANS_SCHEME INT int Scheme for translation - -
translationParams TRANS_PARAMS TEXT String Static params to be passed to the java class for translation 4000 -
srcObjectType SRC_OBJ_TYPE INT int Type of source object 5 -
srcObjectId SRC_OBJ_ID BIGINT Long Source object id 16 -
destObjectType DEST_OBJ_TYPE INT int Type of destination object 5 -
destObjectId DEST_OBJ_ID BIGINT Long Destination object id 16 -
relationType RELATION_TYPE TEXT String Type of the relation 4000 -
status STATUS INT int Status 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED
notes NOTES TEXT String Note for this object 4000 -

9.2.108 VTDataDefTranslationHist

Description: History for VTDataDefTranslation

Database table name :VT_DATA_DEF_TRANS_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
translationId ELEM_MAP_ID BIGINT Long Id for data definition element 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for this data map. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
translationScheme TRANS_SCHEME INT int Scheme for translation -
translationParams TRANS_PARAMS TEXT String Static params to be passed to the java class for translation 4000
srcObjectType SRC_OBJ_TYPE INT int Type of source object 5
srcObjectId SRC_OBJ_ID BIGINT Long Source object id 16
destObjectType DEST_OBJ_TYPE INT int Type of destination object 5
destObjectId DEST_OBJ_ID BIGINT Long Destination object id 16
relationType RELATION_TYPE TEXT String Type of the relation 4000
status STATUS INT int Status 2
notes NOTES TEXT String Note for this object 4000

9.2.109 VTDataDefElementTranslation

Description: Translation from one element to another, e.g. input transaction to normalized transaction data. Or transaction to entity

Database table name :VT_ELEM_DEF_TRANS

Primary Keys : destMapId (DEST_MAP_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
destMapId DEST_MAP_ID (PK) BIGINT Long Id for data definition element 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name for this data map. 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the object 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
translationScheme TRANS_SCHEME INT int Scheme for translation - -
translationParams TRANS_PARAMS TEXT String Static params to be passed to the java class for translation 4000 -
translationId TRANS_ID BIGINT Long Translation id 16 -
destElementDefId DEST_ELEMENT_ID BIGINT Long Destination data element id 16 -
status STATUS INT int Status 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED
notes NOTES TEXT String Note for this object 4000 -

9.2.110 VTDataDefElementTranslationHist

Description: History for VTDataDefElement

Database table name :VT_ELEM_DEF_TRANS_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
destMapId DEST_MAP_ID BIGINT Long Id for data definition element 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for this data map. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
translationScheme TRANS_SCHEME INT int Scheme for translation -
translationParams TRANS_PARAMS TEXT String Static params to be passed to the java class for translation 4000
translationId TRANS_ID BIGINT Long Translation id 16
destElementDefId DEST_ELEMENT_ID BIGINT Long Destination data element id 16
status STATUS INT int Status 2
notes NOTES TEXT String Note for this object 4000

9.2.111 VTTranslationSourceElement

Description: Source columns for the translation

Database table name :VT_TRANS_SRC_ELEM

Primary Keys : srcElementId (SRC_ELEM_ID)

Name DB name DB type Java type Description Length Enum values
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Date value. - -
srcElementId SRC_ELEM_ID (PK) BIGINT Long Id for data definition element 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
name LABEL TEXT String Name for this data map. 4000 -
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000 -
description DESCRIPTION TEXT String Description of the object 4000 -
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000 -
translationScheme TRANS_SCHEME INT int Scheme for translation - -
translationParams TRANS_PARAMS TEXT String Static params to be passed to the java class for translation 4000 -
destMapId DEST_MAP_ID BIGINT Long Destination map id 16 -
srcElementDefId SRC_ELEMENT_ID BIGINT Long Source data element id 16 -
sortOrder SORT_ORDER INT int Row for this data element - -
status STATUS INT int Status 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED
notes NOTES TEXT String Note for this object 4000 -

9.2.112 VTTranslationSourceElementHist

Description: History for VTTranslationSourceElement

Database table name :VT_TRANS_SRC_ELEM_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
srcElementId SRC_ELEM_ID BIGINT Long Id for data definition element 16
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255
name LABEL TEXT String Name for this data map. 4000
nameRBKey LABEL_RBKEY TEXT String Resource bundle key for the name 4000
description DESCRIPTION TEXT String Description of the object 4000
descriptionRBKey DESC_RBKEY TEXT String Resource bundle key for the description 4000
translationScheme TRANS_SCHEME INT int Scheme for translation -
translationParams TRANS_PARAMS TEXT String Static params to be passed to the java class for translation 4000
destMapId DEST_MAP_ID BIGINT Long Destination map id 16
srcElementDefId SRC_ELEMENT_ID BIGINT Long Source data element id 16
sortOrder SORT_ORDER INT int Row for this data element -
status STATUS INT int Status 2
notes NOTES TEXT String Note for this object 4000

9.2.113 VCountry

Description: Country object

Database table name :VCRYPT_COUNTRY

Primary Keys : countryId (COUNTRY_ID)

Name DB name DB type Java type Description Length
countryId COUNTRY_ID (PK) BIGINT Long Id for this country 16
countryCode COUNTRY_CODE VARCHAR String Code of the country 64
countryName COUNTRY_NAME TEXT String Name of the country 4000
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
continent CONTINENT VARCHAR String Continent to which this country belongs to 64
notes NOTES TEXT String Notes for this country 4000

9.2.114 VCountryHist

Description: Country object

Database table name :V_COUNTRY_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
countryId COUNTRY_ID BIGINT Long Id for this country 16
countryCode COUNTRY_CODE VARCHAR String Code of the country 64
countryName COUNTRY_NAME TEXT String Name of the country 4000
continent CONTINENT VARCHAR String Continent to which this country belongs to 64
notes NOTES TEXT String Notes for this country 4000

9.2.115 VState

Description: This is the state or region of the country

Database table name :VCRYPT_STATE

Primary Keys : stateId (STATE_ID)

Name DB name DB type Java type Description Length
stateId STATE_ID (PK) BIGINT Long Id for this state 16
countryId COUNTRY_ID BIGINT Long Id for the country to which this state belongs to. 16
stateCode STATE_CODE VARCHAR String Code for the state or region 64
stateName STATE_NAME TEXT String Name of the state 4000
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
notes NOTES TEXT String Notes for this state 4000

9.2.116 VStateHist

Description: This is the state or region of the country

Database table name :V_STATE_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
stateId STATE_ID BIGINT Long Id for this state 16
countryId COUNTRY_ID BIGINT Long Id for the country to which this state belongs to. 16
stateCode STATE_CODE VARCHAR String Code for the state or region 64
stateName STATE_NAME TEXT String Name of the state 4000
notes NOTES TEXT String Notes for this state 4000

9.2.117 VCity

Description: This is the city object

Database table name :VCRYPT_CITY

Primary Keys : cityId (CITY_ID)

Name DB name DB type Java type Description Length
cityId CITY_ID (PK) BIGINT Long Id for this city 16
stateId STATE_ID BIGINT Long Id for the state to which this city belongs to. 16
cityCode CITY_CODE VARCHAR String Code for the city 64
cityName CITY_NAME TEXT String Name of the city 4000
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
latitude LATITUDE VARCHAR String Latitude 20
longitude LONGITUDE VARCHAR String Longitude 20
timezone TIMEZONE VARCHAR String Time Zone 20
notes NOTES TEXT String Notes for this city 4000

9.2.118 VCityHist

Description: This is the city object

Database table name :V_CITY_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
cityId CITY_ID BIGINT Long Id for this city 16
stateId STATE_ID BIGINT Long Id for the state to which this city belongs to. 16
cityCode CITY_CODE VARCHAR String Code for the city 64
cityName CITY_NAME TEXT String Name of the city 4000
latitude LATITUDE VARCHAR String Latitude 20
longitude LONGITUDE VARCHAR String Longitude 20
timezone TIMEZONE VARCHAR String Time Zone 20
notes NOTES TEXT String Notes for this city 4000

9.2.119 VISP

Description: ISP listing

Database table name :VCRYPT_ISP

Primary Keys : ispId (ISP_ID)

Name DB name DB type Java type Description Length
ispId ISP_ID (PK) BIGINT Long Id for this ISP 16
ispName ISP_NAME TEXT String Name of the ISP 4000
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -

9.2.120 VISPHist

Description: ISP listing

Database table name :V_ISP_HIST

Primary Keys : logId (LOG_ID)

Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
ispId ISP_ID BIGINT Long Id for this ISP 16
ispName ISP_NAME TEXT String Name of the ISP 4000

9.2.121 VLocationLookup

Description: Location lookup tables for constants

Database table name :V_LOC_LOOKUP

Primary Keys : lookupId (LOOKUP_ID)

Name DB name DB type Java type Description Length Enum values
lookupId LOOKUP_ID (PK) BIGINT Long Lookup ID 16 -
globalId GLOBAL_ID VARCHAR String Unique identifier which is used in import and export feature. 255 -
versionNumber VERSION_NUM INT int Version Number - -
createTime CREATE_TIME DATETIME Date Date/Time creation of this object. - -
updateTime UPDATE_TIME TIMESTAMP Date Last update time. - -
lookupType LOOKUP_TYPE INT int Type of lookup. E.g. for profiles, etc - -
name NAME TEXT String Name of the lookup 4000 -
description DESCRIPTION TEXT String Description 4000 -
status STATUS INT int Status of the lookup 2 STATUS_ACTIVE, STATUS_DISABLED, STATUS_DELETED

9.2.122 VIPLocationMap

Description: Mapping of the IP range to city, state and country

Database table name :VCRYPT_IP_LOCATION_MAP

Primary Keys : ipRangeId (IP_RANGE_ID)

Name DB name DB type Java type Description Length
ipRangeId IP_RANGE_ID (PK) BIGINT Long Id for this range 16
fromIPAddr FROM_IP_ADDR BIGINT String The from IP address 15
toIPAddr TO_IP_ADDR BIGINT String The to IP address 15
createTime CREATE_TIME DATETIME Date Date/Time for this log. -
updateTime UPDATE_TIME TIMESTAMP Date Last update time for this object. -
countryId COUNTRY_ID BIGINT Long Id for the country to which this state belongs to. 16
stateId STATE_ID BIGINT Long Id for the state to which this IP range belongs to. 16
cityId CITY_ID BIGINT Long Id for the city to which this IP range belongs to. 16
metroId METRO_ID BIGINT Long Id of the metro for this IP -
ispId ISP_ID BIGINT Long Id for the ISP to which this IP range belongs to. 16
ipRoutingType ROUTING_TYPE INT Integer IP routing type 3
connectionType CONNECTION_TYPE INT Integer Connection type -
connectionSpeed CONNECTION_SPEED INT Integer Connection speed -
topLevelDomain TOP_LEVEL_DOMAIN VARCHAR String Top level domain 25
secondLevelDomain SEC_LEVEL_DOMAIN VARCHAR String Second level domain 128
asn ASN VARCHAR String ASN 25
carrier CARRIER VARCHAR String Carrier 128
zipCode ZIP_CODE VARCHAR String Zip code 24
dma DMA INT Integer U.S. Designated Market Area, AC Nielsen 6
msa MSA INT Integer Metropolitan Statistical Area 6
pmsa PMSA INT Integer Primary Metropolitan Statistical Area 6
regionId REGION_ID BIGINT Long Id the region 16
phoneAreaCode PHONE_AREA VARCHAR String Phone area code 10
isSplit IS_SPLIT CHAR boolean Is the IP split. If so, in some queries, we might have to do addtional checks. -
countryCF COUNTRY_CF INT Integer Confidence factor of the country 4
stateCF STATE_CF INT Integer Confidence factor of the state 4
cityCF CITY_CF INT Integer Confidence factor of the city 4
notes NOTES VARCHAR String Notes for this IP range 255

9.2.123 VIPLocationMapHist

Description: Mapping of the IP range to city, state and country. Shadow table

Database table name :V_IP_LOC_MAP_HIST

Primary Keys : logId (LOG_ID)

<
Name DB name DB type Java type Description Length
logId LOG_ID (PK) BIGINT Long Log Id 16
fromTime FROM_TIME DATETIME Date Active from time. -
toTime TO_TIME DATETIME Date Active to time. -
accessLoginId ACCESS_LOGIN_ID TEXT String Id of the administrator. 256
accessIPAddress ACCESS_IP_ADDR BIGINT String IP address from where the request came from 15
ipRangeId IP_RANGE_ID BIGINT Long Id for this range 16
fromIPAddr FROM_IP_ADDR BIGINT String The from IP address 15
toIPAddr TO_IP_ADDR BIGINT String The to IP address 15
countryId COUNTRY_ID BIGINT Long Id for the country to which this state belongs to. 16
stateId STATE_ID BIGINT Long Id for the state to which this IP range belongs to. 16
cityId CITY_ID BIGINT Long Id for the city to which this IP range belongs to. 16
metroId METRO_ID BIGINT Long Id of the metro for this IP -
ispId ISP_ID BIGINT Long Id for the ISP to which this IP range belongs to. 16
ipRoutingType ROUTING_TYPE INT Integer IP routing type 3
connectionType CONNECTION_TYPE INT Integer Connection type -
connectionSpeed CONNECTION_SPEED INT Integer Connection speed -
topLevelDomain TOP_LEVEL_DOMAIN VARCHAR String Top level domain 25
secondLevelDomain SEC_LEVEL_DOMAIN VARCHAR String Second level domain 128
asn ASN VARCHAR String ASN 25