Table Name OM Class Description
KREN_CHNL_PRODCR_T NotificationProducer Represents an instance of who can actually submit notification messages to the system
KREN_CHNL_SUBSCRP_T UserChannelSubscription Represents an instance of a user's subscription to a specific notification channel
KREN_CHNL_T NotificationChannel Represents and instance of a Notification Channel
KREN_CNTNT_TYP_T NotificationContentType Represents the different types of Notification content that the system can handle
KREN_MSG_DELIV_T MessageDelivery Represents an instance of a MessageDelivery
KREN_MSG_T Message Represents an abstract message that has been sent to a single user
KREN_NTFCTN_MSG_DELIV_T NotificationMessageDelivery Represents and instance of a NotificationMessageDelivery
KREN_NTFCTN_T Notification Represents an instace of a notification message that is received by the overall system
KREN_PRIO_T NotificationPriority represents a priority for a notification
KREN_PRODCR_T NotificationProducer represents an instance of who can actually submit notification messages to the system for processing
KREN_RECIP_DELIV_T RecipientDelivererConfig represents the enablement of a deliverer for a particular channel for a particular user
KREN_RECIP_LIST_T NotificationRecipientList represents the data structure that will house a default recipient list for a notification channel
KREN_RECIP_PREFS_T RecipientPreference represents a recipient preference in the system
KREN_RECIP_T NotificationRecipient houses information pertaining to each recipient for a Notification message
KREN_RVWER_T NotificationChannelReviewer A reviewer for a notification publications to a NotificationChannel
KREN_SNDR_T NotificationSender represents the data structure that will house information about the non-system sender
KREW_ACTN_ITM_T ActionItem This is the model for action items
KREW_ACTN_RQST_T ActionRequestValue Represents ActionRequest to a workgroup, user or role
KREW_ACTN_TKN_T ActionTakenValue Model object mapped to ojb for representing actions taken on documents by users
KREW_ATT_T Attachment An attachment which is attached to a {@link Note}
KREW_DLGN_RSP_T RuleDelegation Specifies the delegation type
KREW_DOC_HDR_CNTNT_T DocumentRouteHeaderValueContent
KREW_DOC_HDR_EXT_DT_T SearchableAttributeDateTimeValue
KREW_DOC_HDR_EXT_FLT_T SearchableAttributeFloatValue
KREW_DOC_HDR_EXT_LONG_T SearchableAttributeLongValue
KREW_DOC_HDR_EXT_T SearchableAttributeStringValue
KREW_DOC_HDR_T DocumentRouteHeaderValue
KREW_DOC_NTE_T Note A note attached to a document
KREW_DOC_TYP_ATTR_T DocumentTypeAttribute Data bean representing an attribute associated at the document type level
KREW_DOC_TYP_PLCY_RELN_T DocumentTypePolicy Model bean representing a policy of a document type
KREW_DOC_TYP_PROC_T Process Represents a route path defined on a {@link DocumentType}
KREW_DOC_TYP_T DocumentType Mapped to ojb representing a document type
KREW_EDL_ASSCTN_T EDocLiteAssociation Association between WorkflowDocument type -> EDocLite definition, EDocLite style
KREW_EDL_DEF_T EDocLiteDefinition EDocLite document definition
KREW_EDL_DMP_T Dump EDocLite dump
KREW_EDL_FLD_DMP_T Fields EDocLite field dump
KREW_HLP_T HelpEntry Model bean representing a piece of help information which adds extra information about fields and data in the user interface
KREW_INIT_RTE_NODE_INSTN_T
KREW_OUT_BOX_ITM_T OutboxItemActionListExtension Outbox item
KREW_RMV_RPLC_DOC_T RemoveReplaceDocument A Remove/Replace document
KREW_RMV_RPLC_GRP_T WorkgroupTarget Represents a target of a remove/replace document
KREW_RMV_RPLC_RULE_T RuleTarget
KREW_RTE_BRCH_PROTO_T BranchPrototype Represents a Branch in the definition of a DocumentType
KREW_RTE_BRCH_ST_T BranchState A piece of state on a {@link Branch} stored as a key-value pair of Strings
KREW_RTE_BRCH_T Branch Represents a branch in the routing path of the document
KREW_RTE_NODE_CFG_PARM_T RouteNodeConfigParam A route node definition configuration parameter
KREW_RTE_NODE_INSTN_LNK_T
KREW_RTE_NODE_INSTN_ST_T NodeState The state of a {@link RouteNodeInstance} represented as a key-value pair of Strings
KREW_RTE_NODE_INSTN_T RouteNodeInstance Represents a materialized instance of a {@link RouteNode} definition on a {@link DocumentRouteHeaderValue}
KREW_RTE_NODE_LNK_T
KREW_RTE_NODE_T RouteNode Represents the prototype definition of a node in the route path of {@link DocumentType}
KREW_RULE_ATTR_T RuleAttribute Model bean defining a rule attribute
KREW_RULE_EXPR_T RuleExpressionDef BO for rule expressions
KREW_RULE_EXT_T RuleExtension Provides attribute-specific data extensions to the rule for a particular {@link RuleAttribute}
KREW_RULE_EXT_VAL_T RuleExtensionValue Essentially contains a key-value pair containing the key of the extension data and it's value
KREW_RULE_RSP_T RuleResponsibility A model bean representing the responsibility of a user, workgroup, or role to perform some action on a document
KREW_RULE_T RuleBaseValues A model bean for a Rule within the KEW rules engine
KREW_RULE_TMPL_ATTR_T RuleTemplateAttribute A model bean which services as the link between a {@link RuleTemplate} and a {@link RuleAttribute}
KREW_RULE_TMPL_OPTN_T RuleTemplateOption Defines default values and other preset information for a {@link RuleBaseValues}
KREW_RULE_TMPL_T RuleTemplate A model bean which represents a template upon which a rule is created
KREW_STYLE_T EDocLiteStyle EDocLite XSLT stylesheet
KREW_USR_OPTN_T UserOptions An option defined for a user
KRIM_ADDR_TYP_T AddressTypeImpl
KRIM_AFLTN_TYP_T AffiliationTypeImpl
KRIM_ATTR_DEFN_T KimAttributeImpl
KRIM_CTZNSHP_STAT_T CitizenshipStatusImpl
KRIM_DLGN_MBR_ATTR_DATA_T KimDelegationMemberAttributeDataImpl
KRIM_DLGN_MBR_T KimDelegationMemberImpl
KRIM_DLGN_T KimDelegationImpl
KRIM_EMAIL_TYP_T EmailTypeImpl
KRIM_EMP_STAT_T EmploymentStatusImpl
KRIM_EMP_TYP_T EmploymentTypeImpl
KRIM_ENTITY_ADDR_T KimEntityAddressImpl
KRIM_ENTITY_AFLTN_T KimEntityAffiliationImpl
KRIM_ENTITY_BIO_T KimEntityBioDemographicsImpl
KRIM_ENTITY_CACHE_T KimEntityDefaultInfoCacheImpl Used to store a cache of person information to be used if the user's information disappears from KIM
KRIM_ENTITY_CTZNSHP_T KimEntityCitizenshipImpl
KRIM_ENTITY_EMAIL_T KimEntityEmailImpl
KRIM_ENTITY_EMP_INFO_T KimEntityEmploymentInformationImpl
KRIM_ENTITY_ENT_TYP_T KimEntityEntityTypeImpl
KRIM_ENTITY_EXT_ID_T KimEntityExternalIdentifierImpl
KRIM_ENTITY_NM_T KimEntityNameImpl
KRIM_ENTITY_PHONE_T KimEntityPhoneImpl
KRIM_ENTITY_PRIV_PREF_T KimEntityPrivacyPreferencesImpl
KRIM_ENTITY_T KimEntityImpl
KRIM_ENT_NM_TYP_T EntityNameTypeImpl
KRIM_ENT_TYP_T EntityTypeImpl
KRIM_EXT_ID_TYP_T ExternalIdentifierTypeImpl
KRIM_GRP_ATTR_DATA_T GroupAttributeDataImpl
KRIM_GRP_DOCUMENT_T IdentityManagementGroupDocument
KRIM_GRP_MBR_T GroupMemberImpl
KRIM_GRP_T GroupImpl
KRIM_PERM_ATTR_DATA_T PermissionAttributeDataImpl
KRIM_PERM_T KimPermissionImpl
KRIM_PERM_TMPL_T KimPermissionTemplateImpl
KRIM_PERSON_DOCUMENT_T IdentityManagementPersonDocument
KRIM_PHONE_TYP_T PhoneTypeImpl
KRIM_PND_ADDR_MT PersonDocumentAddress
KRIM_PND_AFLTN_MT PersonDocumentAffiliation
KRIM_PND_CTZNSHP_MT PersonDocumentCitizenship
KRIM_PND_DLGN_MBR_ATTR_DATA_T RoleDocumentDelegationMemberQualifier
KRIM_PND_DLGN_MBR_T RoleDocumentDelegationMember
KRIM_PND_DLGN_T RoleDocumentDelegation
KRIM_PND_EMAIL_MT PersonDocumentEmail
KRIM_PND_EMP_INFO_MT PersonDocumentEmploymentInfo
KRIM_PND_GRP_ATTR_DATA_T GroupDocumentQualifier
KRIM_PND_GRP_MBR_T GroupDocumentMember
KRIM_PND_GRP_PRNCPL_MT PersonDocumentGroup
KRIM_PND_NM_MT PersonDocumentName
KRIM_PND_PHONE_MT PersonDocumentPhone
KRIM_PND_PRIV_PREF_MT PersonDocumentPrivacy
KRIM_PND_ROLE_MBR_ATTR_DATA_MT KimDocumentRoleQualifier
KRIM_PND_ROLE_MBR_MT KimDocumentRoleMember
KRIM_PND_ROLE_MT PersonDocumentRole
KRIM_PND_ROLE_PERM_T KimDocumentRolePermission
KRIM_PND_ROLE_RSP_ACTN_MT KimDocumentRoleResponsibilityAction
KRIM_PND_ROLE_RSP_T KimDocumentRoleResponsibility
KRIM_PRNCPL_T KimPrincipalImpl
KRIM_ROLE_DOCUMENT_T IdentityManagementRoleDocument
KRIM_ROLE_MBR_ATTR_DATA_T RoleMemberAttributeDataImpl
KRIM_ROLE_MBR_T RoleMemberImpl
KRIM_ROLE_PERM_T RolePermissionImpl
KRIM_ROLE_RSP_ACTN_T RoleResponsibilityActionImpl
KRIM_ROLE_RSP_T RoleResponsibilityImpl
KRIM_ROLE_T RoleImpl
KRIM_RSP_ATTR_DATA_T ResponsibilityAttributeDataImpl
KRIM_RSP_T KimResponsibilityImpl
KRIM_RSP_TMPL_T KimResponsibilityTemplateImpl
KRIM_TYP_ATTR_T KimTypeAttributeImpl
KRIM_TYP_T KimTypeImpl
KRNS_ADHOC_RTE_ACTN_RECIP_T
KRNS_ATT_T Attachment
KRNS_CAMPUS_T CampusImpl
KRNS_CMP_TYP_T CampusTypeImpl
KRNS_DOC_HDR_T DocumentHeader
KRNS_LOOKUP_RSLT_T LookupResults
KRNS_LOOKUP_SEL_T SelectedObjectIds
KRNS_MAINT_DOC_ATT_T DocumentAttachment
KRNS_MAINT_DOC_T MaintenanceDocumentBase
KRNS_MAINT_LOCK_T MaintenanceLock List of business objects that this maintenance document is locking (prevents two documents from being routed trying to update the same object)
KRNS_NMSPC_T Namespace
KRNS_NTE_T Note Represents a user note in the system
KRNS_NTE_TYP_T NoteType
KRNS_PARM_DTL_TYP_T ParameterDetailType
KRNS_PARM_T Parameter
KRNS_PARM_TYP_T ParameterType
KRNS_PESSIMISTIC_LOCK_T PessimisticLock This is a business object used to lock a document pessimistically
KRNS_SESN_DOC_T SessionDocument
KRSB_BAM_PARM_T BAMParam A parameter of a method invocation recorded by the BAM
KRSB_BAM_T BAMTargetEntry An entry in the BAM representing a service method invocation
KRSB_MSG_PYLD_T PersistedMessagePayload Holds message payload content
KRSB_MSG_QUE_T PersistedMessage A message which has been persisted to the data store
KRSB_QRTZ_BLOB_TRIGGERS
KRSB_QRTZ_CALENDARS
KRSB_QRTZ_CRON_TRIGGERS
KRSB_QRTZ_FIRED_TRIGGERS
KRSB_QRTZ_JOB_DETAILS
KRSB_QRTZ_JOB_LISTENERS
KRSB_QRTZ_LOCKS
KRSB_QRTZ_PAUSED_TRIGGER_GRPS
KRSB_QRTZ_SCHEDULER_STATE
KRSB_QRTZ_SIMPLE_TRIGGERS
KRSB_QRTZ_TRIGGERS
KRSB_QRTZ_TRIGGER_LISTENERS
KRSB_SVC_DEF_T ServiceInfo Model bean that represents the definition of a service on the bus
KR_COUNTRY_T
KR_COUNTY_T
KR_KIM_TEST_BO
KR_POSTAL_CODE_T
KR_STATE_T
TRAV_DOC_2_ACCOUNTS
TRV_ACCT TravelAccount
TRV_ACCT_EXT TravelAccountExtension
TRV_ACCT_FO FiscalOfficer
TRV_ACCT_TYPE TravelAccountType
TRV_DOC_2 TravelDocument2
TRV_DOC_ACCT

KREN_CHNL_PRODCR_T

Represents an instance of who can actually submit notification messages to the system

Name Type Size Default JavaName PK FK not null Description
CHNL_ID DECIMAL (8)  
X
X
 
PRODCR_ID DECIMAL (8)   Id
X
X
 
producer identifier

KREN_CHNL_SUBSCRP_T

Represents an instance of a user's subscription to a specific notification channel

Name Type Size Default JavaName PK FK not null Description
CHNL_SUBSCRP_ID DECIMAL (8)   Id
X
 
 
channel subscription identifier
CHNL_ID DECIMAL (8)   Channel
 
X
X
channel identifier
PRNCPL_ID VARCHAR (40)   UserId
 
 
X
user identifier

KREN_CHNL_T

Represents and instance of a Notification Channel

Name Type Size Default JavaName PK FK not null Description
CHNL_ID DECIMAL (8)   Id
X
 
 
channel identifier
NM VARCHAR (200)   Name
 
 
X
name
DESC_TXT VARCHAR (4000)   Description
 
 
X
description text
SUBSCRB_IND CHAR (1)   Subscribable
 
 
X
subscription indicator
VER_NBR DECIMAL (8) 1
 
 
X
version number

KREN_CNTNT_TYP_T

Represents the different types of Notification content that the system can handle

Name Type Size Default JavaName PK FK not null Description
CNTNT_TYP_ID DECIMAL (8)   Id
X
 
 
content type identifier
NM VARCHAR (200)   Name
 
 
X
name
CUR_IND CHAR (1) T
 
 
X
test whether this is the current version
CNTNT_TYP_VER_NBR DECIMAL (8) 0
 
 
X
version number
DESC_TXT VARCHAR (1000)   Description
 
 
X
description text
NMSPC_CD VARCHAR (1000)   Namespace
 
 
X
namespace code
XSD CLOB     Xsd
 
 
X
XSL CLOB     Xsl
 
 
X
VER_NBR DECIMAL (8) 1 Version
 
 
X
version number

KREN_MSG_DELIV_T

Represents an instance of a MessageDelivery

Name Type Size Default JavaName PK FK not null Description
MSG_DELIV_ID DECIMAL (8)   Id
X
 
 
message delivery identifier
MSG_ID DECIMAL (8)   Message
 
X
X
message identifier
TYP_NM VARCHAR (200)   DelivererTypeName
 
 
X
deliverer type name
SYS_ID VARCHAR (300)   DelivererSystemId
 
 
 
deliverer system identifier
STAT_CD VARCHAR (15)   DeliveryStatus
 
 
X
delivery status code
PROC_CNT DECIMAL (4) 0 ProcessCount
 
 
X
process count
LOCKD_DTTM DATE    
 
 
 
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
X
lock version number

KREN_MSG_T

Represents an abstract message that has been sent to a single user

Name Type Size Default JavaName PK FK not null Description
MSG_ID DECIMAL (8)   Id
X
 
 
message identifier
ORGN_ID VARCHAR (128)   OriginId
 
 
 
origin identifier
DELIV_TYP VARCHAR (500)   DeliveryType
 
 
X
message delivery type
CRTE_DTTM DATE     CreationDateTime
 
 
X
creation date time
TTL VARCHAR (255)   Title
 
 
 
message title
CHNL VARCHAR (300)   Channel
 
 
X
message channel
PRODCR VARCHAR (300)   Producer
 
 
 
producer
CNTNT CLOB     Content
 
 
X
message content
CNTNT_TYP VARCHAR (128)   ContentType
 
 
 
message content type
URL VARCHAR (512)   Url
 
 
 
url
RECIP_ID VARCHAR (300)   Recipient
 
 
X
recipient identifier
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
X
lock version number

KREN_NTFCTN_MSG_DELIV_T

Represents and instance of a NotificationMessageDelivery

Name Type Size Default JavaName PK FK not null Description
NTFCTN_MSG_DELIV_ID DECIMAL (8)   Id
X
 
 
notification message delivery identifier
NTFCTN_ID DECIMAL (8)   Notification
 
X
X
represents an instace of a notification message that is received
RECIP_ID VARCHAR (40)   UserRecipientId
 
 
X
user recipient identifier
STAT_CD VARCHAR (15)   MessageDeliveryStatus
 
 
X
message delivery status code
SYS_ID VARCHAR (300)   DeliverySystemId
 
 
 
delivery system identifier
LOCKD_DTTM DATE     LockedDate
 
 
 
locked date
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
X
lock version number

KREN_NTFCTN_T

Represents an instace of a notification message that is received by the overall system

Name Type Size Default JavaName PK FK not null Description
NTFCTN_ID DECIMAL (8)   Id
X
 
 
notification identifier
DELIV_TYP VARCHAR (3)   DeliveryType
 
 
X
notification message delivery type
CRTE_DTTM DATE     CreationDateTime
 
 
X
notification message creation date time
SND_DTTM DATE     SendDateTime
 
 
 
notification message send date time
AUTO_RMV_DTTM DATE     AutoRemoveDateTime
 
 
 
message auto remove date time
PRIO_ID DECIMAL (8)   Priority
 
X
X
represents a priority for a notification
TTL VARCHAR (255)   Title
 
 
 
notification message title
CNTNT CLOB     Content
 
 
X
notification message content
CNTNT_TYP_ID DECIMAL (8)   ContentType
 
X
X
represents the different types of Notification content that the system can handle
CHNL_ID DECIMAL (8)   Channel
 
X
X
represents and instance of a Notification Channel
PRODCR_ID DECIMAL (8)   Producer
 
X
X
represents an instance of who can actually submit notification messages to the system
PROCESSING_FLAG VARCHAR (15)   ProcessingFlag
 
 
X
processing flag
LOCKD_DTTM DATE     LockedDate
 
 
 
locked date
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
X
lock version number

KREN_PRIO_T

represents a priority for a notification

Name Type Size Default JavaName PK FK not null Description
PRIO_ID DECIMAL (8)   Id
X
 
 
notification priority identifier
NM VARCHAR (40)   Name
 
 
X
notification name
DESC_TXT VARCHAR (500)   Description
 
 
X
description text
PRIO_ORD DECIMAL (4)   Order
 
 
X
notification priority order
VER_NBR DECIMAL (8) 1
 
 
X

KREN_PRODCR_T

represents an instance of who can actually submit notification messages to the system for processing

Name Type Size Default JavaName PK FK not null Description
PRODCR_ID DECIMAL (8)   Id
X
 
 
notification producer identifier
NM VARCHAR (200)   Name
 
 
X
name
DESC_TXT VARCHAR (1000)   Description
 
 
X
notification description
CNTCT_INFO VARCHAR (1000)   ContactInfo
 
 
X
contact info
VER_NBR DECIMAL (8) 1
 
 
X

KREN_RECIP_DELIV_T

represents the enablement of a deliverer for a particular channel for a particular user

Name Type Size Default JavaName PK FK not null Description
RECIP_DELIV_ID DECIMAL (8)   Id
X
 
 
recipient deliverer identifier
RECIP_ID VARCHAR (40)   RecipientId
 
 
X
recipient identifier
CHNL VARCHAR (300)   Channel
 
 
X
channel
NM VARCHAR (200)   DelivererName
 
 
X
deliverer name
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
X
lock version number

KREN_RECIP_LIST_T

represents the data structure that will house a default recipient list for a notification channel

Name Type Size Default JavaName PK FK not null Description
RECIP_LIST_ID DECIMAL (8)   Id
X
 
 
recipient list identifier
CHNL_ID DECIMAL (8)   Channel
 
X
X
represents and instance of a Notification Channel
RECIP_TYP_CD VARCHAR (10)   RecipientType
 
 
X
recipient type code
RECIP_ID VARCHAR (40)   RecipientId
 
 
X
recipient identifier

KREN_RECIP_PREFS_T

represents a recipient preference in the system

Name Type Size Default JavaName PK FK not null Description
RECIP_PREFS_ID DECIMAL (8)   Id
X
 
 
recipient preference identifier
RECIP_ID VARCHAR (40)   RecipientId
 
 
X
recipient identifier
PROP VARCHAR (200)   Property
 
 
X
recipient preference property
VAL VARCHAR (1000)   Value
 
 
X
recipient preference value
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
X
lock version number

KREN_RECIP_T

houses information pertaining to each recipient for a Notification message

Name Type Size Default JavaName PK FK not null Description
RECIP_ID DECIMAL (8)   Id
X
 
 
NTFCTN_ID DECIMAL (8)   NotificationId
 
X
X
recipient notification id
RECIP_TYP_CD VARCHAR (10)   RecipientType
 
 
X
This recipient can be either a user or a group - which is specified by the recipient type
PRNCPL_ID VARCHAR (40)   RecipientId
 
 
X

KREN_RVWER_T

A reviewer for a notification publications to a NotificationChannel

Name Type Size Default JavaName PK FK not null Description
RVWER_ID DECIMAL (8)   Id
X
 
 
CHNL_ID DECIMAL (8)   Channel
 
X
X
represents and instance of a Notification Channel
TYP VARCHAR (10)   ReviewerType
 
 
X
reviewer type
PRNCPL_ID VARCHAR (40)   ReviewerId
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X

KREN_SNDR_T

represents the data structure that will house information about the non-system sender

Name Type Size Default JavaName PK FK not null Description
SNDR_ID DECIMAL (8)   Id
X
 
 
sender identifier
NTFCTN_ID DECIMAL (8)   NotificationId
 
X
X
notification message identifier
NM VARCHAR (200)   SenderName
 
 
X
sender name

KREW_ACTN_ITM_T

This is the model for action items

Name Type Size Default JavaName PK FK not null Description
ACTN_ITM_ID DECIMAL (14)   ActionItemId
X
 
 
action item identifier
PRNCPL_ID VARCHAR (30)   PrincipalId
 
 
X
principal identifier
ASND_DT DATE     DateAssigned
 
 
X
assigned date
RQST_CD CHAR (1)   ActionRequestCd
 
 
X
action request code
ACTN_RQST_ID DECIMAL (14)   ActionRequestId
 
 
X
action request identifier
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
X
route header identifier
ROLE_NM VARCHAR (2000)   RoleName
 
 
 
role name
DLGN_PRNCPL_ID VARCHAR (30)   DelegatorWorkflowId
 
 
 
delegator workflow identifier
DOC_HDR_TTL VARCHAR (255)   DocTitle
 
 
 
document header title
DOC_TYP_LBL VARCHAR (128)   DocLabel
 
 
X
document type lable
DOC_HDLR_URL VARCHAR (255)   DocHandlerURL
 
 
X
document header url
DOC_TYP_NM VARCHAR (64)   DocName
 
 
X
document name
RSP_ID DECIMAL (14)   ResponsibilityId
 
 
X
responsibility identifier
DLGN_TYP VARCHAR (1)   DelegationType
 
 
 
delegation type
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number
DTYPE VARCHAR (50)   No longer exists
 
 
 
no longer exists
GRP_ID VARCHAR (40)   GroupId
 
 
 
action items group identifier
DLGN_GRP_ID VARCHAR (40)   DelegatorGroupId
 
 
 
delegator group identifier
RQST_LBL VARCHAR (255)   RequestLabel
 
 
 
request label

KREW_ACTN_RQST_T

Represents ActionRequest to a workgroup, user or role

Name Type Size Default JavaName PK FK not null Description
ACTN_RQST_ID DECIMAL (14)   ActionRequestId
X
 
 
action request identifier
PARNT_ID DECIMAL (14)   ParentActionRequestId
 
 
 
parent action request identifier
ACTN_RQST_CD CHAR (1)   ActionRequested
 
 
X
action request code
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
X
route header identifier
RULE_ID DECIMAL (19)   RuleBaseValuesId
 
 
 
rule base values identifier
STAT_CD CHAR (1)   Status
 
 
X
status code
RSP_ID DECIMAL (14)   ResponsibilityId
 
 
X
responsibility identifier
PRNCPL_ID VARCHAR (30)   PrincipalId
 
 
 
principal identifier
ROLE_NM VARCHAR (2000)   RoleName
 
 
 
role name
QUAL_ROLE_NM VARCHAR (2000)   QualifiedRoleName
 
 
 
qualified role name
QUAL_ROLE_NM_LBL_TXT VARCHAR (2000)   QualifiedRoleNameLabel
 
 
 
qualified role name label
RECIP_TYP_CD CHAR (1)   RecipientTypeCd
 
 
 
recipient type code
PRIO_NBR DECIMAL (8)   Priority
 
 
X
priority number
RTE_TYP_NM VARCHAR (255)   No longer exists
 
 
 
no longer exists
RTE_LVL_NBR DECIMAL (8)   RouteLevel
 
 
X
route level number
RTE_NODE_INSTN_ID DECIMAL (19)   NodeInstance
 
 
 
node instance identifier
ACTN_TKN_ID DECIMAL (14)   ActionTakenId
 
 
 
action taken identifier
DOC_VER_NBR DECIMAL (8)   DocVersion
 
 
X
document version number
CRTE_DT DATE     CreateDate
 
 
X
create date
RSP_DESC_TXT VARCHAR (200)   ResponsibilityDesc
 
 
 
responsibility description text
FRC_ACTN DECIMAL (1) 0 ForceAction
 
 
 
force action
ACTN_RQST_ANNOTN_TXT VARCHAR (2000)   Annotation
 
 
 
action request annotation
DLGN_TYP CHAR (1)   DelegationType
 
 
 
delegation type
APPR_PLCY CHAR (1)   ApprovePolicy
 
 
 
approve policy
CUR_IND DECIMAL (1) 1 CurrentIndicator
 
 
 
current indicator
VER_NBR DECIMAL (8) 0 JrfVerNbr
 
 
 
version number
GRP_ID VARCHAR (40)   GroupId
 
 
 
group identifier
RQST_LBL VARCHAR (255)   RequestLabel
 
 
 
request label

KREW_ACTN_TKN_T

Model object mapped to ojb for representing actions taken on documents by users

Name Type Size Default JavaName PK FK not null Description
ACTN_TKN_ID DECIMAL (14)   ActionTakenId
X
 
 
action taken identifier
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
X
route header identifier
PRNCPL_ID VARCHAR (30)   PrincipalId
 
 
X
principal identifier
DLGTR_PRNCPL_ID VARCHAR (30)   DelegatorPrincipalId
 
 
 
delegator Principal identifier
ACTN_CD CHAR (1)   ActionTaken
 
 
X
action taken code
ACTN_DT DATE     ActionDate
 
 
X
action date
DOC_VER_NBR DECIMAL (8)   DocVersion
 
 
X
document version
ANNOTN VARCHAR (2000)   Annotation
 
 
 
annotation
CUR_IND DECIMAL (1) 1 CurrentIndicator
 
 
 
current indicator
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
version number
DLGTR_GRP_ID VARCHAR (40)   DelegatorGroupId
 
 
 
delegator group identifier

KREW_ATT_T

An attachment which is attached to a {@link Note}

Name Type Size Default JavaName PK FK not null Description
ATTACHMENT_ID DECIMAL (19)   AttachmentId
X
 
 
attachment identifier
NTE_ID DECIMAL (19)   Note
 
 
X
note identifier
FILE_NM VARCHAR (255)   FileName
 
 
X
file name
FILE_LOC VARCHAR (255)   FileLoc
 
 
X
file location
MIME_TYP VARCHAR (255)   MimeType
 
 
X
mime type
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
version number

KREW_DLGN_RSP_T

Specifies the delegation type

Name Type Size Default JavaName PK FK not null Description
DLGN_RULE_ID DECIMAL (19)   RuleDelegationId
X
 
 
rule delegation identifier
RSP_ID DECIMAL (19)   ResponsibilityId
 
 
X
responsibility identifier
DLGN_RULE_BASE_VAL_ID DECIMAL (19)   DelegateRuleId
 
 
X
delegate rule identifier
DLGN_TYP VARCHAR (20)   DelegationType
 
 
X
delegation type
VER_NBR DECIMAL (8) 0
 
 
 
OBJ_ID VARCHAR (36)  
 
 
X

KREW_DOC_HDR_CNTNT_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
X
 
 
route header identifier
DOC_CNTNT_TXT CLOB     DocumentContent
 
 
 
document content

KREW_DOC_HDR_EXT_DT_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_EXT_DT_ID DECIMAL (19)   SearchableAttributeValueId
X
 
 
searchable attribute value identifier
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
X
route header identifier
KEY_CD VARCHAR (256)   SearchableAttributeKey
 
 
X
searchable attribute key
VAL DATE     SearchableAttributeValue
 
 
 
searchable attribute value

KREW_DOC_HDR_EXT_FLT_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_EXT_FLT_ID DECIMAL (19)   SearchableAttributeValueId
X
 
 
searchable attribute value identifier
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
X
route header identifier
KEY_CD VARCHAR (256)   SearchableAttributeKey
 
 
X
searchable attribute key
VAL DECIMAL (30,15)   SearchableAttributeValue
 
 
 
searchable attribute value

KREW_DOC_HDR_EXT_LONG_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_EXT_LONG_ID DECIMAL (19)   SearchableAttributeValueId
X
 
 
searchable attribute value identifier
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
X
route header identifier
KEY_CD VARCHAR (256)   SearchableAttributeKey
 
 
X
searchable attribute key
VAL DECIMAL (22)   SearchableAttributeValue
 
 
 
searchable attribute value

KREW_DOC_HDR_EXT_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_EXT_ID DECIMAL (19)   SearchableAttributeValueId
X
 
 
searchable attribute value identifier
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
X
route header identifier
KEY_CD VARCHAR (256)   SearchableAttributeKey
 
 
X
searchable attribute key
VAL VARCHAR (2000)   SearchableAttributeValue
 
 
 
searchable attribute value

KREW_DOC_HDR_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
X
 
 
route header identifier
DOC_TYP_ID DECIMAL (19)   DocumentTypeId
 
 
 
document type identifier
DOC_HDR_STAT_CD CHAR (1)   DocRouteStatus
 
 
X
document route status code
RTE_LVL DECIMAL (8)   DocRouteLevel
 
 
X
document route level
STAT_MDFN_DT DATE     StatusModDate
 
 
X
staus modification date
CRTE_DT DATE     CreateDate
 
 
X
create date
APRV_DT DATE     ApprovedDate
 
 
 
approved date
FNL_DT DATE     FinalizedDate
 
 
 
finalized date
RTE_STAT_MDFN_DT DATE     RouteStatusDate
 
 
 
route status date
RTE_LVL_MDFN_DT DATE     RouteLevelDate
 
 
 
route level date
TTL VARCHAR (255)   DocTitle
 
 
 
document title
APP_DOC_ID VARCHAR (255)   AppDocId
 
 
 
approved document identifier
DOC_VER_NBR DECIMAL (8)   DocVersion
 
 
X
document version number
INITR_PRNCPL_ID VARCHAR (30)   InitiatorWorkflowId
 
 
X
initiator workflow identifier
VER_NBR DECIMAL (8) 0
 
 
 
RTE_PRNCPL_ID VARCHAR (30)   RoutedByUserWorkflowId
 
 
 
routed by user workflow identifier
DTYPE VARCHAR (50)   No longer exists
 
 
 
no longer exists
OBJ_ID VARCHAR (36)  
 
 
X

KREW_DOC_NTE_T

A note attached to a document

Name Type Size Default JavaName PK FK not null Description
DOC_NTE_ID DECIMAL (19)   NoteId
X
 
 
note identifier
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
X
route header identifier
AUTH_PRNCPL_ID VARCHAR (30)   NoteAuthorWorkflowId
 
 
X
note author workflow identifier
CRT_DT DATE     NoteCreateDate
 
 
X
note create date
TXT VARCHAR (4000)   NoteText
 
 
 
note text
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
version number

KREW_DOC_TYP_ATTR_T

Data bean representing an attribute associated at the document type level

Name Type Size Default JavaName PK FK not null Description
DOC_TYP_ATTRIB_ID DECIMAL (19)   DocumentTypeAttributeId
X
 
 
document type attribute identifier
DOC_TYP_ID DECIMAL (19)   DocumentTypeId
 
 
X
document type identifier
RULE_ATTR_ID DECIMAL (19)   RuleAttribute
 
 
X
rule attribute
ORD_INDX DECIMAL (4) 0 OrderIndex
 
 
 
order index

KREW_DOC_TYP_PLCY_RELN_T

Model bean representing a policy of a document type

Name Type Size Default JavaName PK FK not null Description
DOC_TYP_ID DECIMAL (19)   DocumentTypeId
X
 
 
document type identifier
DOC_PLCY_NM VARCHAR (255)   PolicyName
X
 
 
policy name
PLCY_NM DECIMAL (1)   PolicyValue
 
 
X
policy value
VER_NBR DECIMAL (8) 0
 
 
 
OBJ_ID VARCHAR (36)  
 
 
X

KREW_DOC_TYP_PROC_T

Represents a route path defined on a {@link DocumentType}

Name Type Size Default JavaName PK FK not null Description
DOC_TYP_PROC_ID DECIMAL (19)   ProcessId
X
 
 
process identifier
DOC_TYP_ID DECIMAL (19)   DocumentType
 
 
X
document type identifier
INIT_RTE_NODE_ID DECIMAL (19)   InitialRouteNode
 
 
X
initial route node identifier
NM VARCHAR (255)   Name
 
 
X
name
INIT_IND DECIMAL (1) 0 Initial
 
 
X
initial indicator
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_DOC_TYP_T

Mapped to ojb representing a document type

Name Type Size Default JavaName PK FK not null Description
DOC_TYP_ID DECIMAL (19)   DocumentTypeId
X
 
 
document type identifier
PARNT_ID DECIMAL (19)   DocTypeParentId
 
 
 
document type parent identifier
DOC_TYP_NM VARCHAR (64)   Name
 
 
 
document type name
DOC_TYP_VER_NBR DECIMAL (10) 0 Version
 
 
 
document type version number
ACTV_IND DECIMAL (1)   Active
 
 
 
active indicator
CUR_IND DECIMAL (1)   CurrentInd
 
 
 
current indicator
LBL VARCHAR (128)   Label
 
 
 
lable
PREV_DOC_TYP_VER_NBR DECIMAL (19)   PreviousVersionId
 
 
 
previous document type version number
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
 
document header identifier
DOC_TYP_DESC VARCHAR (4000)   Description
 
 
 
document type description
DOC_HDLR_URL VARCHAR (255)   UnresolvedDocHandlerUrl
 
 
 
unresolved document header url
POST_PRCSR VARCHAR (255)   PostProcessorName
 
 
 
post process name
JNDI_URL VARCHAR (255)  
 
 
 
BLNKT_APPR_PLCY VARCHAR (10)   BlanketApprovePolicy
 
 
 
blanket approve policy
ADV_DOC_SRCH_URL VARCHAR (255)  
 
 
 
CSTM_ACTN_LIST_ATTRIB_CLS_NM VARCHAR (255)  
 
 
 
CSTM_ACTN_EMAIL_ATTRIB_CLS_NM VARCHAR (255)  
 
 
 
CSTM_DOC_NTE_ATTRIB_CLS_NM VARCHAR (255)  
 
 
 
RTE_VER_NBR VARCHAR (2) 1 RoutingVersion
 
 
 
routing version number
NOTIFY_ADDR VARCHAR (255)   ActualNotificationFromAddress
 
 
 
actual notification from address
SVC_NMSPC VARCHAR (255)   ActualServiceNamespace
 
 
 
actual service namespace
EMAIL_XSL VARCHAR (255)   CustomEmailStylesheet
 
 
 
custom email stylesheet
SEC_XML CLOB     DocumentTypeSecurityXml
 
 
 
document type security xml
VER_NBR DECIMAL (8) 0
 
 
 
BLNKT_APPR_GRP_ID VARCHAR (40)   BlanketApproveWorkgroupId
 
 
 
blanket approve workgroup identifier
RPT_GRP_ID VARCHAR (40)   ReportingWorkgroupId
 
 
 
routing workgroup identifier
GRP_ID VARCHAR (40)   WorkgroupId
 
 
 
workgroup identifier
HELP_DEF_URL VARCHAR (4000)   UnresolvedHelpDefinitionUrl
 
 
 
unresolved help definition url
OBJ_ID VARCHAR (36)  
 
 
X

KREW_EDL_ASSCTN_T

Association between WorkflowDocument type -> EDocLite definition, EDocLite style

Name Type Size Default JavaName PK FK not null Description
EDOCLT_ASSOC_ID DECIMAL (19)   EdocLiteAssocId
X
 
 
edocLite association identifier
DOC_TYP_NM VARCHAR (64)   EdlName
 
 
X
docunent type name
EDL_DEF_NM VARCHAR (200)   Definition
 
 
 
edocLite definition name
STYLE_NM VARCHAR (200)   Style
 
 
 
style name
ACTV_IND DECIMAL (1)   ActiveInd
 
 
X
active indicator
VER_NBR DECIMAL (8) 0
 
 
 
OBJ_ID VARCHAR (36)  
 
 
X

KREW_EDL_DEF_T

EDocLite document definition

Name Type Size Default JavaName PK FK not null Description
EDOCLT_DEF_ID DECIMAL (19)   EDocLiteDefId
X
 
 
edocLite definition identifier
NM VARCHAR (200)   Name
 
 
X
name
XML CLOB     XmlContent
 
 
X
xml content
ACTV_IND DECIMAL (1)   ActiveInd
 
 
X
active indicator
VER_NBR DECIMAL (8) 0
 
 
 
OBJ_ID VARCHAR (36)  
 
 
X

KREW_EDL_DMP_T

EDocLite dump

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID DECIMAL (14)   DocId
X
 
 
document header identifier
DOC_TYP_NM VARCHAR (64)   DocTypeName
 
 
X
document type name
DOC_HDR_STAT_CD CHAR (1)   DocRouteStatusCode
 
 
X
document route status code
DOC_HDR_MDFN_DT DATE     DocModificationDate
 
 
X
document modification code
DOC_HDR_CRTE_DT DATE     DocCreationDate
 
 
X
document creation date
DOC_HDR_TTL VARCHAR (255)   DocDescription
 
 
 
document description
DOC_HDR_INITR_PRNCPL_ID VARCHAR (30)   DocInitiatorId
 
 
X
document initiator identifier
CRNT_NODE_NM VARCHAR (30)   DocCurrentNodeName
 
 
X
document current node name
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_EDL_FLD_DMP_T

EDocLite field dump

Name Type Size Default JavaName PK FK not null Description
EDL_FIELD_DMP_ID DECIMAL (14)   FieldId
X
 
 
edocLite field dump identifier
DOC_HDR_ID DECIMAL (14)   DocId
 
 
X
document identifier
FLD_NM VARCHAR (255)   FieldName
 
 
X
field name
FLD_VAL VARCHAR (4000)   FieldValue
 
 
 
field value
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_HLP_T

Model bean representing a piece of help information which adds extra information about fields and data in the user interface

Name Type Size Default JavaName PK FK not null Description
HLP_ID DECIMAL (19)   HelpId
X
 
 
help identifier
NM VARCHAR (500)   HelpName
 
 
X
help name
KEY_CD VARCHAR (500)   HelpKey
 
 
X
help key
HLP_TXT VARCHAR (4000)   HelpText
 
 
X
help text
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_INIT_RTE_NODE_INSTN_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID DECIMAL (19)  
X
 
 
RTE_NODE_INSTN_ID DECIMAL (19)  
X
 
 

KREW_OUT_BOX_ITM_T

Outbox item

Name Type Size Default JavaName PK FK not null Description
ACTN_ITM_ID DECIMAL (14)   ActionItemId
X
 
 
action item identifier
PRNCPL_ID VARCHAR (30)   PrincipalId
 
 
X
principal identifier
ASND_DT DATE     DateAssigned
 
 
X
date assigned
RQST_CD CHAR (1)   ActionRequestCd
 
 
X
action request code
ACTN_RQST_ID DECIMAL (14)   ActionRequestId
 
 
X
action request identifier
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
X
route header identifier
ROLE_NM VARCHAR (2000)   RoleName
 
 
 
role name
DLGN_PRNCPL_ID VARCHAR (30)   DelegatorWorkflowId
 
 
 
delegator workflow identifier
DOC_HDR_TTL VARCHAR (255)   DocTitle
 
 
 
document header title
DOC_TYP_LBL VARCHAR (128)   DocLabel
 
 
X
document type lable
DOC_HDLR_URL VARCHAR (255)   DocHandlerURL
 
 
X
document handler url
DOC_TYP_NM VARCHAR (64)   DocName
 
 
X
document type name
RSP_ID DECIMAL (14)   ResponsibilityId
 
 
X
responsibility identifier
DLGN_TYP VARCHAR (1)   DelegationType
 
 
 
deligation type
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number
GRP_ID VARCHAR (40)   GroupId
 
 
 
group identifier
DLGN_GRP_ID VARCHAR (40)   DelegatorGroupId
 
 
 
delegator group identifier
RQST_LBL VARCHAR (255)   RequestLabel
 
 
 
request lable

KREW_RMV_RPLC_DOC_T

A Remove/Replace document

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID DECIMAL (14)   DocumentId
X
 
 
document header identifier
OPRN CHAR (1)   Operation
 
 
X
opration
PRNCPL_ID VARCHAR (30)   UserWorkflowId
 
 
X
user workflow identifier
RPLC_PRNCPL_ID VARCHAR (30)   ReplacementUserWorkflowId
 
 
 
replacement user workflow identifier
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_RMV_RPLC_GRP_T

Represents a target of a remove/replace document

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID DECIMAL (14)   DocumentId
X
 
 
document header identifier
GRP_ID DECIMAL (14)   WorkgroupId
X
 
 
workgroup identifier

KREW_RMV_RPLC_RULE_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID DECIMAL (14)   DocumentId
X
 
 
document identifier
RULE_ID DECIMAL (19)   RuleId
X
 
 
rule identifier

KREW_RTE_BRCH_PROTO_T

Represents a Branch in the definition of a DocumentType

Name Type Size Default JavaName PK FK not null Description
RTE_BRCH_PROTO_ID DECIMAL (19)   BranchId
X
 
 
routing branch prototype identifier
BRCH_NM VARCHAR (255)   Name
 
 
X
branch name
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_RTE_BRCH_ST_T

A piece of state on a {@link Branch} stored as a key-value pair of Strings

Name Type Size Default JavaName PK FK not null Description
RTE_BRCH_ST_ID DECIMAL (19)   StateId
X
 
 
state identifier
RTE_BRCH_ID DECIMAL (19)   Branch
 
 
X
branch identifier
KEY_CD VARCHAR (255)  
 
 
X
VAL VARCHAR (2000)  
 
 
 
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_RTE_BRCH_T

Represents a branch in the routing path of the document

Name Type Size Default JavaName PK FK not null Description
RTE_BRCH_ID DECIMAL (19)   BranchId
X
 
 
branch identifier
NM VARCHAR (255)   Name
 
 
X
name
PARNT_ID DECIMAL (19)   ParentBranch
 
 
 
parent branch identifier
INIT_RTE_NODE_INSTN_ID DECIMAL (19)   InitialNode
 
 
 
initial route node instance identifier
SPLT_RTE_NODE_INSTN_ID DECIMAL (19)   SplitNode
 
 
 
split route node instance identifier
JOIN_RTE_NODE_INSTN_ID DECIMAL (19)   JoinNode
 
 
 
join route node instance identifier
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_RTE_NODE_CFG_PARM_T

A route node definition configuration parameter

Name Type Size Default JavaName PK FK not null Description
RTE_NODE_CFG_PARM_ID DECIMAL (19)   Id
X
 
 
route node configuration parameter identifier
RTE_NODE_ID DECIMAL (19)   RouteNode
 
X
X
route node identifier
KEY_CD VARCHAR (255)  
 
 
X
VAL VARCHAR (4000)  
 
 
 

KREW_RTE_NODE_INSTN_LNK_T

Name Type Size Default JavaName PK FK not null Description
FROM_RTE_NODE_INSTN_ID DECIMAL (19)  
X
 
 
TO_RTE_NODE_INSTN_ID DECIMAL (19)  
X
 
 

KREW_RTE_NODE_INSTN_ST_T

The state of a {@link RouteNodeInstance} represented as a key-value pair of Strings

Name Type Size Default JavaName PK FK not null Description
RTE_NODE_INSTN_ST_ID DECIMAL (19)   StateId
X
 
 
route node instance state identifier
RTE_NODE_INSTN_ID DECIMAL (19)   NodeInstance
 
 
X
route node instance identifier
KEY_CD VARCHAR (255)  
 
 
X
VAL VARCHAR (2000)  
 
 
 
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_RTE_NODE_INSTN_T

Represents a materialized instance of a {@link RouteNode} definition on a {@link DocumentRouteHeaderValue}

Name Type Size Default JavaName PK FK not null Description
RTE_NODE_INSTN_ID DECIMAL (19)   RouteNodeInstanceId
X
 
 
route node instance identifier
DOC_HDR_ID DECIMAL (19)   DocumentId
 
 
X
document identifier
RTE_NODE_ID DECIMAL (19)   RouteNode
 
 
X
route node identifier
BRCH_ID DECIMAL (19)   Branch
 
 
 
branch identifier
PROC_RTE_NODE_INSTN_ID DECIMAL (19)   Process
 
 
 
process route node instance identifier
ACTV_IND DECIMAL (1) 0 Active
 
 
X
active indicator
CMPLT_IND DECIMAL (1) 0 Complete
 
 
X
complete indicator
INIT_IND DECIMAL (1) 0 Initial
 
 
X
initial indicator
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_RTE_NODE_LNK_T

Name Type Size Default JavaName PK FK not null Description
FROM_RTE_NODE_ID DECIMAL (19)  
X
 
 
TO_RTE_NODE_ID DECIMAL (19)  
X
 
 

KREW_RTE_NODE_T

Represents the prototype definition of a node in the route path of {@link DocumentType}

Name Type Size Default JavaName PK FK not null Description
RTE_NODE_ID DECIMAL (19)   RouteNodeId
X
 
 
route node identifier
DOC_TYP_ID DECIMAL (19)   DocumentTypeId
 
 
 
document type identifier
NM VARCHAR (255)   RouteNodeName
 
 
X
route node name
TYP VARCHAR (255)   NodeType
 
 
X
route node type
RTE_MTHD_NM VARCHAR (255)   RouteMethodName
 
 
 
route method name
RTE_MTHD_CD VARCHAR (2)   RouteMethodCode
 
 
 
route method code
FNL_APRVR_IND DECIMAL (1)   FinalApprovalInd
 
 
 
final approval indicator
MNDTRY_RTE_IND DECIMAL (1)   MandatoryRouteInd
 
 
 
mandatory route indicator
ACTVN_TYP VARCHAR (250)   ActivationType
 
 
 
activation type
BRCH_PROTO_ID DECIMAL (19)   Branch
 
 
 
branch prototype indicator
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number
CONTENT_FRAGMENT VARCHAR (4000)  
 
 
 
GRP_ID VARCHAR (40)   ExceptionWorkgroupId
 
 
 
exception workgroup identifier

KREW_RULE_ATTR_T

Model bean defining a rule attribute

Name Type Size Default JavaName PK FK not null Description
RULE_ATTR_ID DECIMAL (19)   RuleAttributeId
X
 
 
rule attribute identifier
NM VARCHAR (255)   Name
 
 
X
name
LBL VARCHAR (2000)   Label
 
 
X
label
RULE_ATTR_TYP_CD VARCHAR (2000)   Type
 
 
X
rule attribute type code
DESC_TXT VARCHAR (2000)   Description
 
 
 
description text
CLS_NM VARCHAR (2000)   ClassName
 
 
 
class name
XML CLOB     XmlConfigData
 
 
 
xml configuration data
VER_NBR DECIMAL (8) 0
 
 
 
SVC_NMSPC VARCHAR (255)   ServiceNamespace
 
 
 
service namespace
OBJ_ID VARCHAR (36)  
 
 
X

KREW_RULE_EXPR_T

BO for rule expressions

Name Type Size Default JavaName PK FK not null Description
RULE_EXPR_ID DECIMAL (19)   Id
X
 
 
rule expression identifier
TYP VARCHAR (256)   Type
 
 
X
type
RULE_EXPR VARCHAR (4000)   Expression
 
 
 
rule expression
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 0
 
 
 

KREW_RULE_EXT_T

Provides attribute-specific data extensions to the rule for a particular {@link RuleAttribute}

Name Type Size Default JavaName PK FK not null Description
RULE_EXT_ID DECIMAL (19)   RuleExtensionId
X
 
 
rule extension identifier
RULE_TMPL_ATTR_ID DECIMAL (19)   RuleTemplateAttributeId
 
 
X
rule template attribute identifier
RULE_ID DECIMAL (19)   RuleBaseValuesId
 
 
X
rule base values identifier
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_RULE_EXT_VAL_T

Essentially contains a key-value pair containing the key of the extension data and it's value

Name Type Size Default JavaName PK FK not null Description
RULE_EXT_VAL_ID DECIMAL (19)   RuleExtensionValueId
X
 
 
rule extension value identifier
RULE_EXT_ID DECIMAL (19)   RuleExtensionId
 
 
X
rule extension identifier
VAL VARCHAR (2000)   Value
 
 
X
value
KEY_CD VARCHAR (2000)   Key
 
 
X
key code
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_RULE_RSP_T

A model bean representing the responsibility of a user, workgroup, or role to perform some action on a document

Name Type Size Default JavaName PK FK not null Description
RULE_RSP_ID DECIMAL (19)   RuleResponsibilityKey
X
 
 
rule responsibility identifier
RSP_ID DECIMAL (19)   ResponsibilityId
 
 
X
responsibility identifier
RULE_ID DECIMAL (19)   RuleBaseValuesId
 
 
X
rule base values identifier
PRIO DECIMAL (5)   Priority
 
 
 
priority
ACTN_RQST_CD VARCHAR (2000)   ActionRequestedCd
 
 
 
action request code
NM VARCHAR (200)   RuleResponsibilityName
 
 
 
rule responsibility name
TYP VARCHAR (1)   RuleResponsibilityType
 
 
 
rule responsibility type
APPR_PLCY CHAR (1)   ApprovePolicy
 
 
 
approve policy
VER_NBR DECIMAL (8) 0
 
 
 
OBJ_ID VARCHAR (36)  
 
 
X

KREW_RULE_T

A model bean for a Rule within the KEW rules engine

Name Type Size Default JavaName PK FK not null Description
RULE_ID DECIMAL (19)   RuleBaseValuesId
X
 
 
rule base values identifier
NM VARCHAR (256)   Name
 
 
 
name
RULE_TMPL_ID DECIMAL (19)   RuleTemplateId
 
 
 
rule template identifier
RULE_EXPR_ID DECIMAL (19)   RuleExpressionDef
 
X
 
rule expression definition
ACTV_IND DECIMAL (1)   ActiveInd
 
 
X
active indicator
RULE_BASE_VAL_DESC VARCHAR (2000)   Description
 
 
 
rule base value description
FRC_ACTN DECIMAL (1)   ForceAction
 
 
X
force action
DOC_TYP_NM VARCHAR (64)   DocTypeName
 
 
X
document type name
DOC_HDR_ID DECIMAL (14)   RouteHeaderId
 
 
 
route header identifier
TMPL_RULE_IND DECIMAL (1)   TemplateRuleInd
 
 
 
template rule identifier
FRM_DT DATE     FromDate
 
 
 
from date
TO_DT DATE     ToDate
 
 
 
to date
DACTVN_DT DATE     DeactivationDate
 
 
 
deactivation date
CUR_IND DECIMAL (1) 0 CurrentInd
 
 
 
current indicator
RULE_VER_NBR DECIMAL (8) 0 VersionNbr
 
 
 
rule version indicator
DLGN_IND DECIMAL (1)   DelegateRule
 
 
 
delegation rule
PREV_RULE_VER_NBR DECIMAL (19)   PreviousVersionId
 
 
 
previous rule version number
ACTVN_DT DATE     ActivationDate
 
 
 
activation date
VER_NBR DECIMAL (8) 0
 
 
 
OBJ_ID VARCHAR (36)  
 
 
X

KREW_RULE_TMPL_ATTR_T

A model bean which services as the link between a {@link RuleTemplate} and a {@link RuleAttribute}

Name Type Size Default JavaName PK FK not null Description
RULE_TMPL_ATTR_ID DECIMAL (19)   RuleTemplateAttributeId
X
 
 
rule template attribute identifier
RULE_TMPL_ID DECIMAL (19)   RuleTemplateId
 
 
X
rule template identifier
RULE_ATTR_ID DECIMAL (19)   RuleAttributeId
 
 
X
rule attribute identifier
REQ_IND DECIMAL (1)   Required
 
 
X
required indicator
ACTV_IND DECIMAL (1)   Active
 
 
X
active indicator
DSPL_ORD DECIMAL (5)   DisplayOrder
 
 
X
display order
DFLT_VAL VARCHAR (2000)   DefaultValue
 
 
 
default value
VER_NBR DECIMAL (8) 0
 
 
 
OBJ_ID VARCHAR (36)  
 
 
X

KREW_RULE_TMPL_OPTN_T

Defines default values and other preset information for a {@link RuleBaseValues}

Name Type Size Default JavaName PK FK not null Description
RULE_TMPL_OPTN_ID DECIMAL (19)   RuleTemplateOptionId
X
 
 
rule template option identifier
RULE_TMPL_ID DECIMAL (19)   RuleTemplateId
 
 
 
rule template identifier
KEY_CD VARCHAR (250)   Key
 
 
 
key code
VAL VARCHAR (2000)   Value
 
 
 
value
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KREW_RULE_TMPL_T

A model bean which represents a template upon which a rule is created

Name Type Size Default JavaName PK FK not null Description
RULE_TMPL_ID DECIMAL (19)   RuleTemplateId
X
 
 
rule template identifier
NM VARCHAR (250)   Name
 
 
X
name
RULE_TMPL_DESC VARCHAR (2000)   Description
 
 
 
rule template description
DLGN_RULE_TMPL_ID DECIMAL (19)   DelegationTemplateId
 
 
 
deligation rule template identifier
VER_NBR DECIMAL (8) 0
 
 
 
OBJ_ID VARCHAR (36)  
 
 
X

KREW_STYLE_T

EDocLite XSLT stylesheet

Name Type Size Default JavaName PK FK not null Description
STYLE_ID DECIMAL (19)   EdocLiteStyleId
X
 
 
edocLite style identifier
NM VARCHAR (200)   Name
 
 
X
name
XML CLOB     XmlContent
 
 
X
xml context
ACTV_IND DECIMAL (1)   ActiveInd
 
 
X
active indicator
VER_NBR DECIMAL (8) 0
 
 
 
OBJ_ID VARCHAR (36)  
 
 
X

KREW_USR_OPTN_T

An option defined for a user

Name Type Size Default JavaName PK FK not null Description
PRNCPL_ID VARCHAR (30)   WorkflowId
X
 
 
workflow identifier
PRSN_OPTN_ID VARCHAR (200)   OptionId
X
 
 
option identifier
VAL VARCHAR (2000)   OptionVal
 
 
 
optional value
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KRIM_ADDR_TYP_T

Name Type Size Default JavaName PK FK not null Description
ADDR_TYP_CD VARCHAR (40)   Code
X
 
 
address type code
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)   Name
 
 
 
name
ACTV_IND VARCHAR (1) Y
 
 
 
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_AFLTN_TYP_T

Name Type Size Default JavaName PK FK not null Description
AFLTN_TYP_CD VARCHAR (40)   Code
X
 
 
affiliation type code
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)   Name
 
 
 
name
EMP_AFLTN_TYP_IND VARCHAR (1) N EmploymentAffiliationType
 
 
 
employment affiliation type indicator
ACTV_IND VARCHAR (1) Y
 
 
 
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ATTR_DEFN_T

Name Type Size Default JavaName PK FK not null Description
KIM_ATTR_DEFN_ID VARCHAR (40)   KimAttributeId
X
 
 
kim attribute definition identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (100)   AttributeName
 
 
 
attribute name
LBL VARCHAR (40)   AttributeLabel
 
 
 
attribute label
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator
NMSPC_CD VARCHAR (40)   NamespaceCode
 
 
 
namespace code
CMPNT_NM VARCHAR (100)   ComponentName
 
 
 
component name
APPL_URL VARCHAR (2000)  
 
 
 

KRIM_CTZNSHP_STAT_T

Name Type Size Default JavaName PK FK not null Description
CTZNSHP_STAT_CD VARCHAR (40)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_DLGN_MBR_ATTR_DATA_T

Name Type Size Default JavaName PK FK not null Description
ATTR_DATA_ID VARCHAR (40)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
DLGN_MBR_ID VARCHAR (40)   DelegationMemberId
 
 
 
delegation member identifier
KIM_TYP_ID VARCHAR (40)  
 
X
X
KIM_ATTR_DEFN_ID VARCHAR (40)  
 
X
 
ATTR_VAL VARCHAR (400)  
 
 
 

KRIM_DLGN_MBR_T

Name Type Size Default JavaName PK FK not null Description
DLGN_MBR_ID VARCHAR (40)   DelegationMemberId
X
 
 
delegation member identifier
VER_NBR DECIMAL (8) 1
 
 
X
OBJ_ID VARCHAR (36)  
 
 
X
DLGN_ID VARCHAR (40)   DelegationId
 
X
 
delegation identifier
MBR_ID VARCHAR (40)  
 
 
 
MBR_TYP_CD CHAR (1) P
 
 
 
ACTV_FRM_DT DATE    
 
 
 
ACTV_TO_DT DATE    
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 
ROLE_MBR_ID VARCHAR (40)   RoleMemberId
 
 
 
role member identifier

KRIM_DLGN_T

Name Type Size Default JavaName PK FK not null Description
DLGN_ID VARCHAR (40)   DelegationId
X
 
 
delegation identifier
VER_NBR DECIMAL (8) 1
 
 
X
OBJ_ID VARCHAR (36)  
 
 
X
ROLE_ID VARCHAR (40)   RoleId
 
X
 
role identifier
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator
KIM_TYP_ID VARCHAR (40)   KimTypeId
 
X
X
kim type identifier
DLGN_TYP_CD VARCHAR (1)   DelegationTypeCode
 
 
 
delegation type code

KRIM_EMAIL_TYP_T

Name Type Size Default JavaName PK FK not null Description
EMAIL_TYP_CD VARCHAR (40)   Code
X
 
 
email type code
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)   Name
 
 
 
name
ACTV_IND VARCHAR (1) Y
 
 
 
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_EMP_STAT_T

Name Type Size Default JavaName PK FK not null Description
EMP_STAT_CD VARCHAR (40)   Code
X
 
 
employment status code
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)   Name
 
 
 
name
ACTV_IND VARCHAR (1) Y
 
 
 
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_EMP_TYP_T

Name Type Size Default JavaName PK FK not null Description
EMP_TYP_CD VARCHAR (40)   Code
X
 
 
employment type code
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)   Name
 
 
 
name
ACTV_IND VARCHAR (1) Y
 
 
 
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_ADDR_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_ADDR_ID VARCHAR (40)   EntityAddressId
X
 
 
entity address identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENTITY_ID VARCHAR (40)   EntityId
 
X
 
entity identifier
ENT_TYP_CD VARCHAR (40)   EntityTypeCode
 
X
 
entity type code
ADDR_TYP_CD VARCHAR (40)   AddressTypeCode
 
X
 
address type code
ADDR_LINE_1 VARCHAR (45)   Line1
 
 
 
address line1
ADDR_LINE_2 VARCHAR (45)   Line2
 
 
 
address line2
ADDR_LINE_3 VARCHAR (45)   Line3
 
 
 
address line4
CITY_NM VARCHAR (30)   CityName
 
 
 
city name
POSTAL_STATE_CD VARCHAR (2)   StateCode
 
 
 
postal state code
POSTAL_CD VARCHAR (20)   PostalCode
 
 
 
postal code
POSTAL_CNTRY_CD VARCHAR (2)   CountryCode
 
 
 
postal country code
DFLT_IND VARCHAR (1) N
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_AFLTN_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_AFLTN_ID VARCHAR (40)   EntityAffiliationId
X
 
 
entity affiliation identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENTITY_ID VARCHAR (40)   EntityId
 
X
 
entity identifier
AFLTN_TYP_CD VARCHAR (40)   AffiliationTypeCode
 
X
 
affiliation type code
CAMPUS_CD VARCHAR (2)   CampusCode
 
 
 
campus code
DFLT_IND VARCHAR (1) N
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_BIO_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_ID VARCHAR (40)   EntityId
X
 
 
entity identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ETHNCTY_CD VARCHAR (40)  
 
 
 
BIRTH_DT DATE     BirthDate
 
 
 
birth date
GNDR_CD VARCHAR (1)   GenderCode
 
 
X
gender code
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_CACHE_T

Used to store a cache of person information to be used if the user's information disappears from KIM

Name Type Size Default JavaName PK FK not null Description
ENTITY_ID VARCHAR (40)   EntityId
X
 
 
entity identifier
PRNCPL_ID VARCHAR (40)   PrincipalId
 
 
X
principal identifier
PRNCPL_NM VARCHAR (40)   PrincipalName
 
 
 
principal name
ENTITY_TYP_CD VARCHAR (40)   EntityTypeCode
 
 
 
entity type code
FIRST_NM VARCHAR (40)   FirstName
 
 
 
first name
MIDDLE_NM VARCHAR (40)   MiddleName
 
 
 
middle name
LAST_NM VARCHAR (40)   LastName
 
 
 
last name
PRSN_NM VARCHAR (40)   Name
 
 
 
name
CAMPUS_CD VARCHAR (40)   CampusCode
 
 
 
campus code
PRMRY_DEPT_CD VARCHAR (40)   PrimaryDepartmentCode
 
 
 
primary department code
EMP_ID VARCHAR (40)   EmployeeId
 
 
 
employee identifier
LAST_UPDT_TS DATE     LastUpdateTimestamp
 
 
 
last update timestamp
OBJ_ID VARCHAR (36)  
 
 
X

KRIM_ENTITY_CTZNSHP_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_CTZNSHP_ID VARCHAR (40)   EntityCitizenshipId
X
 
 
entity citizenship identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENTITY_ID VARCHAR (40)   EntityId
 
X
 
entity identifier
POSTAL_CNTRY_CD VARCHAR (2)   CountryCode
 
 
 
postal country code
CTZNSHP_STAT_CD VARCHAR (40)   CitizenshipStatusCode
 
X
 
citizenship status code
STRT_DT DATE     StartDate
 
 
 
start date
END_DT DATE     EndDate
 
 
 
end date
ACTV_IND VARCHAR (1) Y
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_EMAIL_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_EMAIL_ID VARCHAR (40)   EntityEmailId
X
 
 
entity email identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENTITY_ID VARCHAR (40)   EntityId
 
X
 
entity identifier
ENT_TYP_CD VARCHAR (40)   EntityTypeCode
 
X
 
entity type code
EMAIL_TYP_CD VARCHAR (40)   EmailTypeCode
 
 
 
email type code
EMAIL_ADDR VARCHAR (200)   EmailAddress
 
 
 
email address
DFLT_IND VARCHAR (1) N
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_EMP_INFO_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_EMP_ID VARCHAR (40)   EntityEmploymentId
X
 
 
entity employment identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENTITY_ID VARCHAR (40)   EntityId
 
X
 
entity identifier
ENTITY_AFLTN_ID VARCHAR (40)   EntityAffiliationId
 
X
 
entity affiliation identifier
EMP_STAT_CD VARCHAR (40)   EmployeeStatusCode
 
X
 
employee status code
EMP_TYP_CD VARCHAR (40)   EmployeeTypeCode
 
X
 
employee type code
BASE_SLRY_AMT DECIMAL (15,2)   BaseSalaryAmount
 
 
 
base salary amount
PRMRY_IND VARCHAR (1)   Primary
 
 
 
primary indicator
ACTV_IND VARCHAR (1) Y
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 
PRMRY_DEPT_CD VARCHAR (40)   PrimaryDepartmentCode
 
 
 
primary department code
EMP_ID VARCHAR (40)   EmployeeId
 
 
 
employee identifier
EMP_REC_ID VARCHAR (40)   EmploymentRecordId
 
 
 
employee record identifier

KRIM_ENTITY_ENT_TYP_T

Name Type Size Default JavaName PK FK not null Description
ENT_TYP_CD VARCHAR (40)   EntityTypeCode
X
X
 
entity type code
ENTITY_ID VARCHAR (40)   EntityId
X
X
 
entity identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ACTV_IND VARCHAR (1) Y
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_EXT_ID_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_EXT_ID_ID VARCHAR (40)   EntityExternalIdentifierId
X
 
 
entity external identifier id
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENTITY_ID VARCHAR (40)   EntityId
 
X
 
entity identifier
EXT_ID_TYP_CD VARCHAR (40)   ExternalIdentifierTypeCode
 
X
 
external identitifier type code
EXT_ID VARCHAR (100)   ExternalId
 
 
 
external identifier
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_NM_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_NM_ID VARCHAR (40)   EntityNameId
X
 
 
entity name identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENTITY_ID VARCHAR (40)   EntityId
 
X
 
entity identifier
NM_TYP_CD VARCHAR (40)   NameTypeCode
 
 
 
name type code
FIRST_NM VARCHAR (40)   FirstName
 
 
 
first name
MIDDLE_NM VARCHAR (40)   MiddleName
 
 
 
middle name
LAST_NM VARCHAR (80)   LastName
 
 
 
last name
SUFFIX_NM VARCHAR (20)   Suffix
 
 
 
suffix name
TITLE_NM VARCHAR (20)   Title
 
 
 
title name
DFLT_IND VARCHAR (1) N
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_PHONE_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_PHONE_ID VARCHAR (40)   EntityPhoneId
X
 
 
entity phone identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENTITY_ID VARCHAR (40)   EntityId
 
X
 
entity identifier
ENT_TYP_CD VARCHAR (40)   EntityTypeCode
 
X
 
entity type code
PHONE_TYP_CD VARCHAR (40)   PhoneTypeCode
 
X
 
phone type code
PHONE_NBR VARCHAR (20)   PhoneNumber
 
 
 
phone number
PHONE_EXTN_NBR VARCHAR (8)   ExtensionNumber
 
 
 
phone extension number
POSTAL_CNTRY_CD VARCHAR (2)   CountryCode
 
 
 
postal country code
DFLT_IND VARCHAR (1) N
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_PRIV_PREF_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_ID VARCHAR (40)   EntityId
X
 
 
entity identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
SUPPRESS_NM_IND VARCHAR (1) N SuppressName
 
 
 
supress name indicator
SUPPRESS_EMAIL_IND VARCHAR (1) Y SuppressEmail
 
 
 
supress email indicator
SUPPRESS_ADDR_IND VARCHAR (1) Y SuppressAddress
 
 
 
supress address indicator
SUPPRESS_PHONE_IND VARCHAR (1) Y SuppressPhone
 
 
 
supress phone indicator
SUPPRESS_PRSNL_IND VARCHAR (1) Y SuppressPersonal
 
 
 
supress personal indicator
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENTITY_T

Name Type Size Default JavaName PK FK not null Description
ENTITY_ID VARCHAR (40)   EntityId
X
 
 
entity identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ACTV_IND VARCHAR (1) Y
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENT_NM_TYP_T

Name Type Size Default JavaName PK FK not null Description
ENT_NM_TYP_CD VARCHAR (40)   Code
X
 
 
entity name type code
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)   Name
 
 
 
name
ACTV_IND VARCHAR (1) Y
 
 
 
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ENT_TYP_T

Name Type Size Default JavaName PK FK not null Description
ENT_TYP_CD VARCHAR (40)   Code
X
 
 
entity type code
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)   Name
 
 
 
name
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 

KRIM_EXT_ID_TYP_T

Name Type Size Default JavaName PK FK not null Description
EXT_ID_TYP_CD VARCHAR (40)   Code
X
 
 
external identifier type code
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)   Name
 
 
 
name
ENCR_REQ_IND VARCHAR (1) N EncryptionRequired
 
 
 
encryption required indicator
ACTV_IND VARCHAR (1) Y
 
 
 
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_GRP_ATTR_DATA_T

Name Type Size Default JavaName PK FK not null Description
ATTR_DATA_ID VARCHAR (40)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
GRP_ID VARCHAR (40)   GroupId
 
X
 
group identifier
KIM_TYP_ID VARCHAR (40)  
 
X
X
KIM_ATTR_DEFN_ID VARCHAR (40)  
 
X
 
ATTR_VAL VARCHAR (400)  
 
 
 

KRIM_GRP_DOCUMENT_T

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
GRP_ID VARCHAR (40)  
 
 
X
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
KIM_TYP_ID VARCHAR (40)  
 
 
X
GRP_NMSPC VARCHAR (100)  
 
 
X
GRP_NM VARCHAR (400)  
 
 
 
GRP_DESC VARCHAR (400)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 

KRIM_GRP_MBR_T

Name Type Size Default JavaName PK FK not null Description
GRP_MBR_ID VARCHAR (40)   GroupMemberId
X
 
 
group member identifier
VER_NBR DECIMAL (8) 1
 
 
X
OBJ_ID VARCHAR (36)  
 
 
X
GRP_ID VARCHAR (40)   GroupId
 
X
 
group identifier
MBR_ID VARCHAR (40)  
 
 
 
MBR_TYP_CD CHAR (1) P
 
 
 
ACTV_FRM_DT DATE    
 
 
 
ACTV_TO_DT DATE    
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_GRP_T

Name Type Size Default JavaName PK FK not null Description
GRP_ID VARCHAR (40)   GroupId
X
 
 
group identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
GRP_NM VARCHAR (80)   GroupName
 
 
X
group name
NMSPC_CD VARCHAR (40)   NamespaceCode
 
 
X
namespace code
GRP_DESC VARCHAR (4000)   GroupDescription
 
 
 
group description
KIM_TYP_ID VARCHAR (40)   KimTypeId
 
X
X
kim type identifier
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_PERM_ATTR_DATA_T

Name Type Size Default JavaName PK FK not null Description
ATTR_DATA_ID VARCHAR (40)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
PERM_ID VARCHAR (40)   PermissionId
 
X
 
permission identifier
KIM_TYP_ID VARCHAR (40)  
 
X
X
KIM_ATTR_DEFN_ID VARCHAR (40)  
 
X
 
ATTR_VAL VARCHAR (400)  
 
 
 

KRIM_PERM_T

Name Type Size Default JavaName PK FK not null Description
PERM_ID VARCHAR (40)   PermissionId
X
 
 
permission identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
PERM_TMPL_ID VARCHAR (40)  
 
X
 
NMSPC_CD VARCHAR (40)   NamespaceCode
 
 
 
namespace code
NM VARCHAR (100)   Name
 
 
 
name
DESC_TXT VARCHAR (400)   Description
 
 
 
description text
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator

KRIM_PERM_TMPL_T

Name Type Size Default JavaName PK FK not null Description
PERM_TMPL_ID VARCHAR (40)   PermissionTemplateId
X
 
 
permission template identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NMSPC_CD VARCHAR (40)   NamespaceCode
 
 
 
namespace code
NM VARCHAR (100)   Name
 
 
 
name
DESC_TXT VARCHAR (400)   Description
 
 
 
description text
KIM_TYP_ID VARCHAR (40)   KimTypeId
 
X
X
kim type identifier
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator

KRIM_PERSON_DOCUMENT_T

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ENTITY_ID VARCHAR (40)  
 
 
X
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
PRNCPL_ID VARCHAR (40)  
 
 
X
PRNCPL_NM VARCHAR (100)  
 
 
X
PRNCPL_PSWD VARCHAR (400)  
 
 
 
TAX_ID VARCHAR (100)  
 
 
 
UNIV_ID VARCHAR (40)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 

KRIM_PHONE_TYP_T

Name Type Size Default JavaName PK FK not null Description
PHONE_TYP_CD VARCHAR (40)   Code
X
 
 
phone type code
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
PHONE_TYP_NM VARCHAR (40)   Name
 
 
 
phone type name
ACTV_IND VARCHAR (1) Y
 
 
 
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_PND_ADDR_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ADDR_TYP_CD VARCHAR (40)   AddressTypeCode
 
 
 
address type code
ADDR_LINE_1 VARCHAR (50)   Line1
 
 
 
address line 1
ADDR_LINE_2 VARCHAR (50)   Line2
 
 
 
address line 2
ADDR_LINE_3 VARCHAR (50)   Line3
 
 
 
address line 3
CITY_NM VARCHAR (30)   CityName
 
 
 
city name
POSTAL_STATE_CD VARCHAR (2)   StateCode
 
 
 
postal state code
POSTAL_CD VARCHAR (20)   PostalCode
 
 
 
postal code
POSTAL_CNTRY_CD VARCHAR (2)   CountryCode
 
 
 
postal country code
DISPLAY_SORT_CD VARCHAR (2)  
 
 
 
DFLT_IND VARCHAR (1) N
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
ENTITY_ADDR_ID VARCHAR (40)   EntityAddressId
X
 
 
entity address identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_AFLTN_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
X
 
ENTITY_AFLTN_ID VARCHAR (40)   EntityAffiliationId
X
 
 
entity affiliation identifier
AFLTN_TYP_CD VARCHAR (40)   AffiliationTypeCode
 
 
 
affiliation type code
CAMPUS_CD VARCHAR (2)   CampusCode
 
 
 
campus code
EDIT_FLAG VARCHAR (1) N
 
 
 
DFLT_IND VARCHAR (1) N
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X

KRIM_PND_CTZNSHP_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ENTITY_CTZNSHP_ID VARCHAR (40)   EntityCitizenshipId
X
 
 
entity citizenship identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
POSTAL_CNTRY_CD VARCHAR (2)   CountryCode
 
 
 
postal country code
CTZNSHP_STAT_CD VARCHAR (40)   CitizenshipStatusCode
 
 
 
citizenship status code
STRT_DT DATE     StartDate
 
 
 
start code
END_DT DATE     EndDate
 
 
 
end date
ACTV_IND VARCHAR (1) Y
 
 
 
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_DLGN_MBR_ATTR_DATA_T

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ATTR_DATA_ID VARCHAR (40)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
DLGN_MBR_ID VARCHAR (40)   DelegationMemberId
 
 
 
delegation member identifier
KIM_TYP_ID VARCHAR (40)  
 
 
 
KIM_ATTR_DEFN_ID VARCHAR (40)  
 
 
 
ATTR_VAL VARCHAR (400)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_DLGN_MBR_T

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
DLGN_MBR_ID VARCHAR (40)   DelegationMemberId
X
 
 
delegation member identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
DLGN_ID VARCHAR (40)   DelegationId
 
 
X
delegation identifier
MBR_ID VARCHAR (40)   MemberId
 
 
 
member identifier
MBR_NM VARCHAR (40)   MemberName
 
 
 
member name
MBR_TYP_CD VARCHAR (40)   MemberTypeCode
 
 
X
member type code
ACTV_IND VARCHAR (1) Y
 
 
 
ACTV_FRM_DT DATE    
 
 
 
ACTV_TO_DT DATE    
 
 
 
ROLE_MBR_ID VARCHAR (40)   RoleMemberId
 
 
 
role member identifier

KRIM_PND_DLGN_T

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
DLGN_ID VARCHAR (40)   DelegationId
X
 
 
delegation identifier
ROLE_ID VARCHAR (40)   RoleId
 
 
X
role identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
KIM_TYP_ID VARCHAR (40)   KimTypeId
 
 
 
kim type identifier
DLGN_TYP_CD VARCHAR (100)   DelegationTypeCode
 
 
X
delegation type code
ACTV_IND VARCHAR (1) Y
 
 
 

KRIM_PND_EMAIL_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ENTITY_EMAIL_ID VARCHAR (40)   EntityEmailId
X
 
 
entity email identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENT_TYP_CD VARCHAR (40)   EntityTypeCode
 
 
 
entity type code
EMAIL_TYP_CD VARCHAR (40)   EmailTypeCode
 
 
 
email type code
EMAIL_ADDR VARCHAR (200)   EmailAddress
 
 
 
email address
DFLT_IND VARCHAR (1) N
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_EMP_INFO_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
PRMRY_DEPT_CD VARCHAR (40)   PrimaryDepartmentCode
 
 
 
primary department code
ENTITY_EMP_ID VARCHAR (40)   EntityEmploymentId
X
 
 
entity employee identifier
EMP_ID VARCHAR (40)   EmployeeId
 
 
 
employee identifier
EMP_REC_ID VARCHAR (40)   EmploymentRecordId
 
 
 
employment record identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENTITY_AFLTN_ID VARCHAR (40)   EntityAffiliationId
 
 
 
entity affiliation identifier
EMP_STAT_CD VARCHAR (40)   EmployeeStatusCode
 
 
 
employee status code
EMP_TYP_CD VARCHAR (40)   EmployeeTypeCode
 
 
 
employee type code
BASE_SLRY_AMT DECIMAL (15,2)   BaseSalaryAmount
 
 
 
base salary amount
PRMRY_IND VARCHAR (1)   Primary
 
 
 
primary indicator
ACTV_IND VARCHAR (1) Y
 
 
 
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_GRP_ATTR_DATA_T

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ATTR_DATA_ID VARCHAR (40)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
GRP_ID VARCHAR (40)   GroupId
 
 
 
group identifier
KIM_TYP_ID VARCHAR (40)  
 
 
 
KIM_ATTR_DEFN_ID VARCHAR (40)  
 
 
 
ATTR_VAL VARCHAR (400)  
 
 
 

KRIM_PND_GRP_MBR_T

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
GRP_MBR_ID VARCHAR (40)   GroupMemberId
X
 
 
group member identifier
OBJ_ID VARCHAR (36)   GroupId
 
 
X
group identifier
VER_NBR DECIMAL (8) 1
 
 
X
GRP_ID VARCHAR (40)  
 
 
X
MBR_ID VARCHAR (40)   MemberId
 
 
 
member identifier
MBR_NM VARCHAR (40)  
 
 
 
MBR_TYP_CD VARCHAR (40)   MemberTypeCode
 
 
X
member type code
ACTV_FRM_DT DATE    
 
 
 
ACTV_TO_DT DATE    
 
 
 

KRIM_PND_GRP_PRNCPL_MT

Name Type Size Default JavaName PK FK not null Description
GRP_MBR_ID VARCHAR (40)   GroupMemberId
X
 
 
group member identifier
FDOC_NBR VARCHAR (14)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
GRP_ID VARCHAR (40)   GroupId
 
 
X
group identifier
PRNCPL_ID VARCHAR (40)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
GRP_NM VARCHAR (80)   GroupName
 
 
X
group name
GRP_TYPE VARCHAR (80)   GroupType
 
 
 
group type
KIM_TYP_ID VARCHAR (40)  
 
 
 
NMSPC_CD VARCHAR (40)   NamespaceCode
 
 
 
name space code
ACTV_FRM_DT DATE     ActiveFromDate
 
 
 
activation from date
ACTV_TO_DT DATE     ActiveToDate
 
 
 
activation to date
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_NM_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ENTITY_NM_ID VARCHAR (40)   EntityNameId
X
 
 
entity name identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM_TYP_CD VARCHAR (40)   NameTypeCode
 
 
 
name type code
FIRST_NM VARCHAR (40)   FirstName
 
 
 
first name
MIDDLE_NM VARCHAR (40)   MiddleName
 
 
 
middle name
LAST_NM VARCHAR (80)   LastName
 
 
 
last name
SUFFIX_NM VARCHAR (20)   Suffix
 
 
 
suffix name
TITLE_NM VARCHAR (20)   Title
 
 
 
title name
DFLT_IND VARCHAR (1) N
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_PHONE_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ENTITY_PHONE_ID VARCHAR (40)   EntityPhoneId
X
 
 
entity phone identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ENT_TYP_CD VARCHAR (40)   EntityTypeCode
 
 
 
entity type code
PHONE_TYP_CD VARCHAR (40)   PhoneTypeCode
 
 
 
phone type code
PHONE_NBR VARCHAR (20)   PhoneNumber
 
 
 
phone number
PHONE_EXTN_NBR VARCHAR (8)   ExtensionNumber
 
 
 
phone extension number
POSTAL_CNTRY_CD VARCHAR (2)   CountryCode
 
 
 
postal country code
DFLT_IND VARCHAR (1) N
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_PRIV_PREF_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
SUPPRESS_NM_IND VARCHAR (1) N SuppressName
 
 
 
supress name indicator
SUPPRESS_EMAIL_IND VARCHAR (1) Y SuppressEmail
 
 
 
supress email indicator
SUPPRESS_ADDR_IND VARCHAR (1) Y SuppressAddress
 
 
 
supress address indicator
SUPPRESS_PHONE_IND VARCHAR (1) Y SuppressPhone
 
 
 
supress phone indicator
SUPPRESS_PRSNL_IND VARCHAR (1) Y SuppressPersonal
 
 
 
supress personal indicator
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_ROLE_MBR_ATTR_DATA_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ATTR_DATA_ID VARCHAR (40)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ROLE_MBR_ID VARCHAR (40)   RoleMemberId
 
 
 
role member identifier
KIM_TYP_ID VARCHAR (40)  
 
 
 
KIM_ATTR_DEFN_ID VARCHAR (40)  
 
 
 
ATTR_VAL VARCHAR (400)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_ROLE_MBR_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ROLE_MBR_ID VARCHAR (40)   RoleMemberId
X
 
 
role member identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ROLE_ID VARCHAR (40)   RoleId
 
 
X
role identifier
MBR_ID VARCHAR (40)   MemberId
 
 
 
member identifier
MBR_NM VARCHAR (40)  
 
 
 
MBR_TYP_CD VARCHAR (40)   MemberTypeCode
 
 
X
member type code
ACTV_IND VARCHAR (1) Y
 
 
 
ACTV_FRM_DT DATE    
 
 
 
ACTV_TO_DT DATE    
 
 
 
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_ROLE_MT

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ROLE_ID VARCHAR (40)   RoleId
X
 
 
role identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ROLE_NM VARCHAR (100)  
 
 
X
KIM_TYP_ID VARCHAR (40)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 
NMSPC_CD VARCHAR (40)   NamespaceCode
 
 
 
name space code
EDIT_FLAG VARCHAR (1) N
 
 
 

KRIM_PND_ROLE_PERM_T

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ROLE_PERM_ID VARCHAR (40)   RolePermissionId
X
 
 
role permission identifier
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ROLE_ID VARCHAR (40)   RoleId
 
 
X
role identifier
PERM_ID VARCHAR (40)   PermissionId
 
 
X
permission identifier
ACTV_IND VARCHAR (1) Y
 
 
 

KRIM_PND_ROLE_RSP_ACTN_MT

Name Type Size Default JavaName PK FK not null Description
ROLE_RSP_ACTN_ID VARCHAR (40)  
X
 
 
FDOC_NBR VARCHAR (14)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ACTN_TYP_CD VARCHAR (40)  
 
 
 
PRIORITY_NBR DECIMAL (3)  
 
 
 
ACTN_PLCY_CD VARCHAR (40)  
 
 
 
ROLE_MBR_ID VARCHAR (40)  
 
 
 
ROLE_RSP_ID VARCHAR (40)  
 
 
 
EDIT_FLAG VARCHAR (1) N
 
 
 
FRC_ACTN VARCHAR (1)  
 
 
 

KRIM_PND_ROLE_RSP_T

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ROLE_RSP_ID VARCHAR (40)   RoleResponsibilityId
X
 
 
role responsibility identifier
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ROLE_ID VARCHAR (40)   RoleId
 
 
X
role identifier
RSP_ID VARCHAR (40)   ResponsibilityId
 
 
X
responsibility identifier
ACTV_IND VARCHAR (1) Y
 
 
 

KRIM_PRNCPL_T

Name Type Size Default JavaName PK FK not null Description
PRNCPL_ID VARCHAR (40)   PrincipalId
X
 
 
principal identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
PRNCPL_NM VARCHAR (100)   PrincipalName
 
 
X
principal name
ENTITY_ID VARCHAR (40)   EntityId
 
X
 
entity identifier
PRNCPL_PSWD VARCHAR (400)   Password
 
 
 
principal password
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ROLE_DOCUMENT_T

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ROLE_ID VARCHAR (40)  
 
 
X
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ROLE_TYP_ID VARCHAR (40)  
 
 
X
ROLE_NMSPC VARCHAR (100)  
 
 
X
ROLE_NM VARCHAR (400)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
 

KRIM_ROLE_MBR_ATTR_DATA_T

Name Type Size Default JavaName PK FK not null Description
ATTR_DATA_ID VARCHAR (40)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ROLE_MBR_ID VARCHAR (40)   RoleMemberId
 
 
 
role member identifier
KIM_TYP_ID VARCHAR (40)  
 
X
X
KIM_ATTR_DEFN_ID VARCHAR (40)  
 
X
 
ATTR_VAL VARCHAR (400)  
 
 
 

KRIM_ROLE_MBR_T

Name Type Size Default JavaName PK FK not null Description
ROLE_MBR_ID VARCHAR (40)   RoleMemberId
X
 
 
role member identifier
VER_NBR DECIMAL (8) 1
 
 
X
OBJ_ID VARCHAR (36)  
 
 
X
ROLE_ID VARCHAR (40)   RoleId
 
X
 
role identifier
MBR_ID VARCHAR (40)  
 
 
 
MBR_TYP_CD CHAR (1) P
 
 
 
ACTV_FRM_DT DATE    
 
 
 
ACTV_TO_DT DATE    
 
 
 
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_ROLE_PERM_T

Name Type Size Default JavaName PK FK not null Description
ROLE_PERM_ID VARCHAR (40)   RolePermissionId
X
 
 
role permission identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ROLE_ID VARCHAR (40)   RoleId
 
 
 
role identifier
PERM_ID VARCHAR (40)   PermissionId
 
X
 
permission identifier
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator

KRIM_ROLE_RSP_ACTN_T

Name Type Size Default JavaName PK FK not null Description
ROLE_RSP_ACTN_ID VARCHAR (40)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ACTN_TYP_CD VARCHAR (40)  
 
 
 
PRIORITY_NBR DECIMAL (3)  
 
 
 
ACTN_PLCY_CD VARCHAR (40)  
 
 
 
ROLE_MBR_ID VARCHAR (40)  
 
 
 
ROLE_RSP_ID VARCHAR (40)  
 
 
 
FRC_ACTN VARCHAR (1) N
 
 
 

KRIM_ROLE_RSP_T

Name Type Size Default JavaName PK FK not null Description
ROLE_RSP_ID VARCHAR (40)   RoleResponsibilityId
X
 
 
role responsibility identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ROLE_ID VARCHAR (40)   RoleId
 
 
 
role identifier
RSP_ID VARCHAR (40)   ResponsibilityId
 
X
 
responsibility identifier
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator

KRIM_ROLE_T

Name Type Size Default JavaName PK FK not null Description
ROLE_ID VARCHAR (40)   RoleId
X
 
 
role identifier
OBJ_ID VARCHAR (36)   RoleName
 
 
X
role name
VER_NBR DECIMAL (8) 1
 
 
X
ROLE_NM VARCHAR (80)  
 
 
X
NMSPC_CD VARCHAR (40)   NamespaceCode
 
 
X
name space code
DESC_TXT VARCHAR (4000)   RoleDescription
 
 
 
role description text
KIM_TYP_ID VARCHAR (40)   KimTypeId
 
X
X
kim type identifier
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator
LAST_UPDT_DT DATE   SYSDATE
 
 
 

KRIM_RSP_ATTR_DATA_T

Name Type Size Default JavaName PK FK not null Description
ATTR_DATA_ID VARCHAR (40)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
RSP_ID VARCHAR (40)   ResponsibilityId
 
X
 
responsibility identifier
KIM_TYP_ID VARCHAR (40)  
 
X
X
KIM_ATTR_DEFN_ID VARCHAR (40)  
 
X
 
ATTR_VAL VARCHAR (400)  
 
 
 

KRIM_RSP_T

Name Type Size Default JavaName PK FK not null Description
RSP_ID VARCHAR (40)   ResponsibilityId
X
 
 
responsibility identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
RSP_TMPL_ID VARCHAR (40)  
 
X
 
NMSPC_CD VARCHAR (40)   NamespaceCode
 
 
 
name space code
NM VARCHAR (100)   Name
 
 
 
name
DESC_TXT VARCHAR (400)   Description
 
 
 
description text
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator

KRIM_RSP_TMPL_T

Name Type Size Default JavaName PK FK not null Description
RSP_TMPL_ID VARCHAR (40)   ResponsibilityTemplateId
X
 
 
responsibility template identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NMSPC_CD VARCHAR (40)   NamespaceCode
 
 
 
name space code
NM VARCHAR (80)   Name
 
 
 
name
KIM_TYP_ID VARCHAR (100)   KimTypeId
 
X
X
kim type identifier
DESC_TXT VARCHAR (400)   Description
 
 
 
description text
ACTV_IND VARCHAR (1) Y Active
 
 
 
active index

KRIM_TYP_ATTR_T

Name Type Size Default JavaName PK FK not null Description
KIM_TYP_ATTR_ID VARCHAR (40)   KimTypeAttributeId
X
 
 
kim type attribute identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
SORT_CD VARCHAR (2)   SortCode
 
 
 
sort code
KIM_TYP_ID VARCHAR (40)   KimTypeId
 
X
X
kim type identifier
KIM_ATTR_DEFN_ID VARCHAR (40)   KimAttributeId
 
X
 
kim attribute definition identifier
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator

KRIM_TYP_T

Name Type Size Default JavaName PK FK not null Description
KIM_TYP_ID VARCHAR (40)   KimTypeId
X
 
 
kim type identifier
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (100)   Name
 
 
 
name
SRVC_NM VARCHAR (200)   KimTypeServiceName
 
 
 
kim type service name
ACTV_IND VARCHAR (1) Y Active
 
 
 
active indicator
NMSPC_CD VARCHAR (40)   NamespaceCode
 
 
 
name space code

KRNS_ADHOC_RTE_ACTN_RECIP_T

Name Type Size Default JavaName PK FK not null Description
RECIP_TYP_CD DECIMAL (1)  
X
 
 
ACTN_RQST_CD VARCHAR (30)  
X
 
 
ACTN_RQST_RECIP_ID VARCHAR (70)  
X
 
 
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
DOC_HDR_ID VARCHAR (14)  
X
 
 

KRNS_ATT_T

Name Type Size Default JavaName PK FK not null Description
NTE_ID DECIMAL (14)   NoteIdentifier
X
X
 
note identifier
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
MIME_TYP VARCHAR (150)   AttachmentMimeTypeCode
 
 
 
attachement mime type code
FILE_NM VARCHAR (250)   AttachmentFileName
 
 
 
attachement file name
ATT_ID VARCHAR (36)   AttachmentIdentifier
 
 
 
attachement identifier
FILE_SZ DECIMAL (14)   AttachmentFileSize
 
 
 
attachement file size
ATT_TYP_CD VARCHAR (40)   AttachmentTypeCode
 
 
 
attachement type code

KRNS_CAMPUS_T

Name Type Size Default JavaName PK FK not null Description
CAMPUS_CD VARCHAR (2)   CampusCode
X
 
 
campus code
CAMPUS_NM VARCHAR (250)   CampusName
 
 
 
campus name
CAMPUS_SHRT_NM VARCHAR (250)   CampusShortName
 
 
 
campus short name
CAMPUS_TYP_CD VARCHAR (1)   CampusTypeCode
 
X
 
campus type code
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ACTV_IND VARCHAR (1) Y Active
 
 
X
active indicator

KRNS_CMP_TYP_T

Name Type Size Default JavaName PK FK not null Description
CAMPUS_TYP_CD VARCHAR (1)   CampusTypeCode
X
 
 
campus type code
CMP_TYP_NM VARCHAR (250)   CampusTypeName
 
 
 
campus type name
DOBJ_MAINT_CD_ACTV_IND VARCHAR (1)   DataObjectMaintenanceCodeActiveIndicator
 
 
X
data object maintenance code active indicator
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
ACTV_IND VARCHAR (1) Y Active
 
 
X
active indicator

KRNS_DOC_HDR_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID VARCHAR (14)   DocumentNumber
X
 
 
document header identifier
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
FDOC_DESC VARCHAR (40)   DocumentDescription
 
 
 
document description
ORG_DOC_HDR_ID VARCHAR (10)   OrganizationDocumentNumber
 
 
 
organization document number identifier
TMPL_DOC_HDR_ID VARCHAR (14)   DocumentTemplateNumber
 
 
 
template document header identifier
EXPLANATION VARCHAR (400)   Explanation
 
 
 
explanation

KRNS_LOOKUP_RSLT_T

Name Type Size Default JavaName PK FK not null Description
LOOKUP_RSLT_ID VARCHAR (14)  
X
 
 
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
PRNCPL_ID VARCHAR (10)  
 
 
X
LOOKUP_DT DATE    
 
 
X
SERIALZD_RSLTS CLOB     SerializedLookupResults
 
 
 
serialized lookup results

KRNS_LOOKUP_SEL_T

Name Type Size Default JavaName PK FK not null Description
LOOKUP_RSLT_ID VARCHAR (14)  
X
 
 
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
PRNCPL_ID VARCHAR (10)  
 
 
X
LOOKUP_DT DATE    
 
 
X
SEL_OBJ_IDS CLOB     SelectedObjectIds
 
 
 
selected object identifiers

KRNS_MAINT_DOC_ATT_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID VARCHAR (14)  
X
 
 
ATT_CNTNT BLOB    
 
 
X
FILE_NM VARCHAR (150)  
 
 
 
CNTNT_TYP VARCHAR (50)  
 
 
 
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X

KRNS_MAINT_DOC_T

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID VARCHAR (14)  
X
X
 
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
DOC_CNTNT CLOB     XmlDocumentContents
 
 
 
xml document contents

KRNS_MAINT_LOCK_T

List of business objects that this maintenance document is locking (prevents two documents from being routed trying to update the same object)

Name Type Size Default JavaName PK FK not null Description
MAINT_LOCK_REP_TXT VARCHAR (500)   LockingRepresentation
 
 
 
maintenance locking representation text
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
DOC_HDR_ID VARCHAR (14)   DocumentNumber
 
 
X
document header identifier
MAINT_LOCK_ID VARCHAR (14)   LockId
X
 
 
maintenance lock identifier

KRNS_NMSPC_T

Name Type Size Default JavaName PK FK not null Description
NMSPC_CD VARCHAR (20)  
X
 
 
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)  
 
 
 
ACTV_IND CHAR (1) Y
 
 
X
APPL_NMSPC_CD VARCHAR (20)   ApplicationNamespaceCode
 
 
 
application name space code

KRNS_NTE_T

Represents a user note in the system

Name Type Size Default JavaName PK FK not null Description
NTE_ID DECIMAL (14)   NoteIdentifier
X
 
 
note identifier
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
RMT_OBJ_ID VARCHAR (36)   RemoteObjectIdentifier
 
 
X
remote object identifier
AUTH_PRNCPL_ID VARCHAR (30)   AuthorUniversalIdentifier
 
 
X
author universal identifier
POST_TS DATE     NotePostedTimestamp
 
 
X
note posted timestamp
NTE_TYP_CD VARCHAR (4)   NoteTypeCode
 
X
X
note type code
TXT VARCHAR (800)   NoteText
 
 
 
note text
PRG_CD VARCHAR (1)   NotePurgeCode
 
 
 
note purge code
TPC_TXT VARCHAR (40)   NoteTopicText
 
 
 
note topic text

KRNS_NTE_TYP_T

Name Type Size Default JavaName PK FK not null Description
NTE_TYP_CD VARCHAR (4)   NoteTypeCode
X
 
 
note type code
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
TYP_DESC_TXT VARCHAR (100)   NoteTypeDescription
 
 
 
note type description text
ACTV_IND VARCHAR (1)   NoteTypeActiveIndicator
 
 
 
note type indicator

KRNS_PARM_DTL_TYP_T

Name Type Size Default JavaName PK FK not null Description
NMSPC_CD VARCHAR (20)   ParameterNamespaceCode
X
X
 
param name space code
PARM_DTL_TYP_CD VARCHAR (100)   ParameterDetailTypeCode
X
 
 
parameter detail type code
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (255)   ParameterDetailTypeName
 
 
 
parameter detail type name
ACTV_IND CHAR (1) Y Active
 
 
X
active indicator

KRNS_PARM_T

Name Type Size Default JavaName PK FK not null Description
NMSPC_CD VARCHAR (20)   ParameterNamespaceCode
X
X
 
parameter name space code
PARM_DTL_TYP_CD VARCHAR (100)   ParameterDetailTypeCode
X
 
 
parameter detail type code
PARM_NM VARCHAR (255)   ParameterName
X
 
 
parameter name
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
PARM_TYP_CD VARCHAR (5)   ParameterTypeCode
 
X
X
parameter type code
TXT VARCHAR (4000)   ParameterValue
 
 
 
parameter value
PARM_DESC_TXT VARCHAR (4000)   ParameterDescription
 
 
 
parameter description text
CONS_CD VARCHAR (1)   ParameterConstraintCode
 
 
 
parameter constraint code
APPL_NMSPC_CD VARCHAR (20) KUALI ParameterApplicationNamespaceCode
X
 
 
parameter application name space code

KRNS_PARM_TYP_T

Name Type Size Default JavaName PK FK not null Description
PARM_TYP_CD VARCHAR (5)  
X
 
 
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
NM VARCHAR (40)  
 
 
 
ACTV_IND CHAR (1) Y
 
 
X

KRNS_PESSIMISTIC_LOCK_T

This is a business object used to lock a document pessimistically

Name Type Size Default JavaName PK FK not null Description
PESSIMISTIC_LOCK_ID DECIMAL (14)   Id
X
 
 
pessimistic lock identifier
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
LOCK_DESC_TXT VARCHAR (4000)   LockDescriptor
 
 
 
lock description text
DOC_HDR_ID VARCHAR (14)   DocumentNumber
 
 
X
document number
GNRT_DT DATE     GeneratedTimestamp
 
 
X
generated timestamp
PRNCPL_ID VARCHAR (10)   OwnedByPrincipalIdentifier
 
 
X
owned by principal identifier

KRNS_SESN_DOC_T

Name Type Size Default JavaName PK FK not null Description
SESN_DOC_ID VARCHAR (40)  
X
 
 
DOC_HDR_ID VARCHAR (14)  
X
 
 
PRNCPL_ID VARCHAR (40)  
X
 
 
IP_ADDR VARCHAR (60)  
X
 
 
SERIALZD_DOC_FRM BLOB    
 
 
 
LAST_UPDT_DT DATE    
 
 
 
CONTENT_ENCRYPTED_IND CHAR (1) N
 
 
 

KRSB_BAM_PARM_T

A parameter of a method invocation recorded by the BAM

Name Type Size Default JavaName PK FK not null Description
BAM_PARM_ID DECIMAL (14)   BamParamId
X
 
 
bam parameter identifier
BAM_ID DECIMAL (14)   BamTargetEntry
 
 
X
bam parameter entry
PARM CLOB     Param
 
 
X
parameter

KRSB_BAM_T

An entry in the BAM representing a service method invocation

Name Type Size Default JavaName PK FK not null Description
BAM_ID DECIMAL (14)   BamId
X
 
 
bam identifier
SVC_NM VARCHAR (255)   ServiceName
 
 
X
service name
SVC_URL VARCHAR (500)   ServiceURL
 
 
X
service url
MTHD_NM VARCHAR (2000)   MethodName
 
 
X
method name
THRD_NM VARCHAR (500)   ThreadName
 
 
X
thread name
CALL_DT DATE     CallDate
 
 
X
call date
TGT_TO_STR VARCHAR (2000)   TargetToString
 
 
X
target to string
SRVR_IND DECIMAL (1)   ServerInvocation
 
 
X
service invocation indicator
EXCPN_TO_STR VARCHAR (2000)   ExceptionToString
 
 
 
exception to string
EXCPN_MSG CLOB     ExceptionMessage
 
 
 
exception message

KRSB_MSG_PYLD_T

Holds message payload content

Name Type Size Default JavaName PK FK not null Description
MSG_QUE_ID DECIMAL (14)   RouteQueueId
X
 
 
message queue identifier
MSG_PYLD CLOB     Payload
 
 
X
message payload

KRSB_MSG_QUE_T

A message which has been persisted to the data store

Name Type Size Default JavaName PK FK not null Description
MSG_QUE_ID DECIMAL (14)   RouteQueueId
X
 
 
route queue identifier
DT DATE     QueueDate
 
 
X
queue date
EXP_DT DATE     ExpirationDate
 
 
 
expiration date
PRIO DECIMAL (8)   QueuePriority
 
 
X
queue priority
STAT_CD CHAR (1)   QueueStatus
 
 
X
queue status code
RTRY_CNT DECIMAL (8)   RetryCount
 
 
X
retry count
IP_NBR VARCHAR (2000)   IpNumber
 
 
X
ip number
SVC_NM VARCHAR (255)   ServiceName
 
 
 
service name
SVC_NMSPC VARCHAR (255)   ServiceNamespace
 
 
X
service name space
SVC_MTHD_NM VARCHAR (2000)   MethodName
 
 
 
service method name
APP_VAL_ONE VARCHAR (2000)   Value1
 
 
 
value one
APP_VAL_TWO VARCHAR (2000)   Value2
 
 
 
value two
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KRSB_QRTZ_BLOB_TRIGGERS

Name Type Size Default JavaName PK FK not null Description
TRIGGER_NAME VARCHAR (80)  
X
X
 
TRIGGER_GROUP VARCHAR (80)  
X
X
 
BLOB_DATA BLOB    
 
 
 

KRSB_QRTZ_CALENDARS

Name Type Size Default JavaName PK FK not null Description
CALENDAR_NAME VARCHAR (80)  
X
 
 
CALENDAR BLOB    
 
 
X

KRSB_QRTZ_CRON_TRIGGERS

Name Type Size Default JavaName PK FK not null Description
TRIGGER_NAME VARCHAR (80)  
X
X
 
TRIGGER_GROUP VARCHAR (80)  
X
X
 
CRON_EXPRESSION VARCHAR (80)  
 
 
X
TIME_ZONE_ID VARCHAR (80)  
 
 
 

KRSB_QRTZ_FIRED_TRIGGERS

Name Type Size Default JavaName PK FK not null Description
ENTRY_ID VARCHAR (95)  
X
 
 
TRIGGER_NAME VARCHAR (80)  
 
 
X
TRIGGER_GROUP VARCHAR (80)  
 
 
X
IS_VOLATILE VARCHAR (1)  
 
 
X
INSTANCE_NAME VARCHAR (80)  
 
 
X
FIRED_TIME DECIMAL (13)  
 
 
X
PRIORITY DECIMAL (13)  
 
 
X
STATE VARCHAR (16)  
 
 
X
JOB_NAME VARCHAR (80)  
 
 
 
JOB_GROUP VARCHAR (80)  
 
 
 
IS_STATEFUL VARCHAR (1)  
 
 
 
REQUESTS_RECOVERY VARCHAR (1)  
 
 
 

KRSB_QRTZ_JOB_DETAILS

Name Type Size Default JavaName PK FK not null Description
JOB_NAME VARCHAR (80)  
X
 
 
JOB_GROUP VARCHAR (80)  
X
 
 
DESCRIPTION VARCHAR (120)  
 
 
 
JOB_CLASS_NAME VARCHAR (128)  
 
 
X
IS_DURABLE VARCHAR (1)  
 
 
X
IS_VOLATILE VARCHAR (1)  
 
 
X
IS_STATEFUL VARCHAR (1)  
 
 
X
REQUESTS_RECOVERY VARCHAR (1)  
 
 
X
JOB_DATA BLOB    
 
 
 

KRSB_QRTZ_JOB_LISTENERS

Name Type Size Default JavaName PK FK not null Description
JOB_NAME VARCHAR (80)  
X
X
 
JOB_GROUP VARCHAR (80)  
X
X
 
JOB_LISTENER VARCHAR (80)  
X
 
 

KRSB_QRTZ_LOCKS

Name Type Size Default JavaName PK FK not null Description
LOCK_NAME VARCHAR (40)  
X
 
 

KRSB_QRTZ_PAUSED_TRIGGER_GRPS

Name Type Size Default JavaName PK FK not null Description
TRIGGER_GROUP VARCHAR (80)  
X
 
 

KRSB_QRTZ_SCHEDULER_STATE

Name Type Size Default JavaName PK FK not null Description
INSTANCE_NAME VARCHAR (80)  
X
 
 
LAST_CHECKIN_TIME DECIMAL (13)  
 
 
X
CHECKIN_INTERVAL DECIMAL (13)  
 
 
X

KRSB_QRTZ_SIMPLE_TRIGGERS

Name Type Size Default JavaName PK FK not null Description
TRIGGER_NAME VARCHAR (80)  
X
X
 
TRIGGER_GROUP VARCHAR (80)  
X
X
 
REPEAT_COUNT DECIMAL (7)  
 
 
X
REPEAT_INTERVAL DECIMAL (12)  
 
 
X
TIMES_TRIGGERED DECIMAL (7)  
 
 
X

KRSB_QRTZ_TRIGGERS

Name Type Size Default JavaName PK FK not null Description
TRIGGER_NAME VARCHAR (80)  
X
 
 
TRIGGER_GROUP VARCHAR (80)  
X
 
 
JOB_NAME VARCHAR (80)  
 
 
X
JOB_GROUP VARCHAR (80)  
 
 
X
IS_VOLATILE VARCHAR (1)  
 
 
X
DESCRIPTION VARCHAR (120)  
 
 
 
NEXT_FIRE_TIME DECIMAL (13)  
 
 
 
PREV_FIRE_TIME DECIMAL (13)  
 
 
 
PRIORITY DECIMAL (13)  
 
 
 
TRIGGER_STATE VARCHAR (16)  
 
 
X
TRIGGER_TYPE VARCHAR (8)  
 
 
X
START_TIME DECIMAL (13)  
 
 
X
END_TIME DECIMAL (13)  
 
 
 
CALENDAR_NAME VARCHAR (80)  
 
 
 
MISFIRE_INSTR DECIMAL (2)  
 
 
 
JOB_DATA BLOB    
 
 
 

KRSB_QRTZ_TRIGGER_LISTENERS

Name Type Size Default JavaName PK FK not null Description
TRIGGER_NAME VARCHAR (80)  
X
X
 
TRIGGER_GROUP VARCHAR (80)  
X
X
 
TRIGGER_LISTENER VARCHAR (80)  
X
 
 

KRSB_SVC_DEF_T

Model bean that represents the definition of a service on the bus

Name Type Size Default JavaName PK FK not null Description
SVC_DEF_ID DECIMAL (14)   MessageEntryId
X
 
 
service info message entry identifier
SVC_NM VARCHAR (255)   ServiceName
 
 
X
service name
SVC_URL VARCHAR (500)   EndpointUrl
 
 
X
service info endpoint url
SRVR_IP VARCHAR (40)   ServerIp
 
 
X
service ip
SVC_NMSPC VARCHAR (255)   ServiceNamespace
 
 
X
service name space code
SVC_ALIVE DECIMAL (1)   Alive
 
 
X
service alive
SVC_DEF CLOB     SerializedServiceNamespace
 
 
X
serialized service name space
VER_NBR DECIMAL (8) 0 LockVerNbr
 
 
 
lock version number

KR_COUNTRY_T

Name Type Size Default JavaName PK FK not null Description
POSTAL_CNTRY_CD VARCHAR (2)  
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
POSTAL_CNTRY_NM VARCHAR (40)  
 
 
 
PSTL_CNTRY_RSTRC_IND VARCHAR (1)  
 
 
X
ACTV_IND VARCHAR (1) Y
 
 
X

KR_COUNTY_T

Name Type Size Default JavaName PK FK not null Description
COUNTY_CD VARCHAR (10)  
X
 
 
STATE_CD VARCHAR (2)  
X
 
 
POSTAL_CNTRY_CD VARCHAR (2) US
X
 
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
COUNTY_NM VARCHAR (100)  
 
 
 
ACTV_IND VARCHAR (1)  
 
 
 

KR_KIM_TEST_BO

Name Type Size Default JavaName PK FK not null Description
PK VARCHAR (40)  
 
 
 
PRNCPL_ID VARCHAR (40)  
 
 
 

KR_POSTAL_CODE_T

Name Type Size Default JavaName PK FK not null Description
POSTAL_CD VARCHAR (20)  
X
 
 
POSTAL_CNTRY_CD VARCHAR (2) US
X
X
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
POSTAL_STATE_CD VARCHAR (2)  
 
X
 
COUNTY_CD VARCHAR (10)  
 
X
 
POSTAL_CITY_NM VARCHAR (30)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
X

KR_STATE_T

Name Type Size Default JavaName PK FK not null Description
POSTAL_STATE_CD VARCHAR (2)  
X
 
 
POSTAL_CNTRY_CD VARCHAR (2) US
X
X
 
OBJ_ID VARCHAR (36)  
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
POSTAL_STATE_NM VARCHAR (40)  
 
 
 
ACTV_IND VARCHAR (1) Y
 
 
X

TRAV_DOC_2_ACCOUNTS

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
ACCT_NUM VARCHAR (10)  
X
 
 

TRV_ACCT

Name Type Size Default JavaName PK FK not null Description
ACCT_NUM VARCHAR (10)   Number
X
 
 
travel account number
ACCT_NAME VARCHAR (50)   Name
 
 
 
travle account name
ACCT_TYPE VARCHAR (100)   Unkown
 
 
 
unkown
ACCT_FO_ID DECIMAL (14)   FoId
 
X
 
fiscal officer identifier

TRV_ACCT_EXT

Name Type Size Default JavaName PK FK not null Description
ACCT_NUM VARCHAR (10)   Number
X
 
 
travle account extension number
ACCT_TYPE VARCHAR (100)  
X
 
 
travle account extension type

TRV_ACCT_FO

Name Type Size Default JavaName PK FK not null Description
ACCT_FO_ID DECIMAL (14)   Id
X
 
 
account fiscal officer idfentifier
ACCT_FO_USER_NAME VARCHAR (50)   UserName
 
 
X
account fiscal officer user name

TRV_ACCT_TYPE

Name Type Size Default JavaName PK FK not null Description
ACCT_TYPE VARCHAR (10)   AccountTypeCode
X
 
 
travel account type
ACCT_TYPE_NAME VARCHAR (50)   Name
 
 
 
travle account type name

TRV_DOC_2

Name Type Size Default JavaName PK FK not null Description
FDOC_NBR VARCHAR (14)  
X
 
 
OBJ_ID VARCHAR (36) SYS_GUID()
 
 
X
VER_NBR DECIMAL (8) 1
 
 
X
FDOC_EXPLAIN_TXT VARCHAR (400)  
 
 
 
REQUEST_TRAV VARCHAR (30)   RequestType
 
 
X
travel document two request type
TRAVELER VARCHAR (200)   Traveler
 
 
 
travel document two traveler
ORG VARCHAR (60)   Origin
 
 
 
travel document two origin
DEST VARCHAR (60)   Destination
 
 
 
travel document tqo destination

TRV_DOC_ACCT

Name Type Size Default JavaName PK FK not null Description
DOC_HDR_ID DECIMAL (14)  
X
 
 
ACCT_NUM VARCHAR (10)  
X