Skip Headers
Oracle® Fusion Middleware Reference for Oracle Identity Management
11g Release 1 (11.1.1)

Part Number E10035-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

9 Oracle Adaptive Access Manager Database Schema

This document describes the Oracle Adaptive Access Manager tables. It contains the following sections:

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

38

numData1

NUM_DATA1

BIGINT

Long

Numeric data 1

38

numData2

NUM_DATA2

BIGINT

Long

Numeric data 2

38

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

38

numData1

NUM_DATA1

BIGINT

Long

Numeric data 1

38

numData2

NUM_DATA2

BIGINT

Long

Numeric data 2

38


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