Table Name | OM Class | Description
--- | --- | ---
ACCT_DD_ATTR_DOC | ACCT_DD_ATTR_DOC |
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_APP_DOC_STAT_TRAN_T | DocumentStatusTransition | Model bean representing the valid application document statuses for a document type
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 | unknown
KREW_DOC_HDR_EXT_DT_T | SearchableAttributeDateTimeValue | unknown
KREW_DOC_HDR_EXT_FLT_T | SearchableAttributeFloatValue | unknown
KREW_DOC_HDR_EXT_LONG_T | SearchableAttributeLongValue | unknown
KREW_DOC_HDR_EXT_T | SearchableAttributeStringValue | unknown
KREW_DOC_HDR_T | DocumentRouteHeaderValue | unknown
KREW_DOC_LNK_T | DocumentLink | Server side bean for DocumentLinkDAO
KREW_DOC_NTE_T | Note | A note attached to a document
KREW_DOC_TYP_APP_DOC_STAT_T | ApplicationDocumentStatus | An instance of this class represents a single valid status for a given document type
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 | unknown
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 | unknown | unknown
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 | unknown | unknown
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 | unknown
KRIM_AFLTN_TYP_T | AffiliationTypeImpl | unknown
KRIM_ATTR_DEFN_T | KimAttributeImpl | unknown
KRIM_CTZNSHP_STAT_T | CitizenshipStatusImpl | unknown
KRIM_DLGN_MBR_ATTR_DATA_T | KimDelegationMemberAttributeDataImpl | unknown
KRIM_DLGN_MBR_T | KimDelegationMemberImpl | unknown
KRIM_DLGN_T | KimDelegationImpl | unknown
KRIM_EMAIL_TYP_T | EmailTypeImpl | unknown
KRIM_EMP_STAT_T | EmploymentStatusImpl | unknown
KRIM_EMP_TYP_T | EmploymentTypeImpl | unknown
KRIM_ENTITY_ADDR_T | KimEntityAddressImpl | unknown
KRIM_ENTITY_AFLTN_T | KimEntityAffiliationImpl | unknown
KRIM_ENTITY_BIO_T | KimEntityBioDemographicsImpl | unknown
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 | unknown
KRIM_ENTITY_EMAIL_T | KimEntityEmailImpl | unknown
KRIM_ENTITY_EMP_INFO_T | KimEntityEmploymentInformationImpl | unknown
KRIM_ENTITY_ENT_TYP_T | KimEntityEntityTypeImpl | unknown
KRIM_ENTITY_ETHNIC_T | KimEntityEthnicityImpl | unknown
KRIM_ENTITY_EXT_ID_T | KimEntityExternalIdentifierImpl | unknown
KRIM_ENTITY_NM_T | KimEntityNameImpl | unknown
KRIM_ENTITY_PHONE_T | KimEntityPhoneImpl | unknown
KRIM_ENTITY_PRIV_PREF_T | KimEntityPrivacyPreferencesImpl | unknown
KRIM_ENTITY_RESIDENCY_T | KimEntityResidencyImpl | This class is used to store residency information about an entity
KRIM_ENTITY_T | KimEntityImpl | unknown
KRIM_ENTITY_VISA_T | KimEntityVisaImpl | unknown
KRIM_ENT_NM_TYP_T | EntityNameTypeImpl | unknown
KRIM_ENT_TYP_T | EntityTypeImpl | unknown
KRIM_EXT_ID_TYP_T | ExternalIdentifierTypeImpl | unknown
KRIM_GRP_ATTR_DATA_T | GroupAttributeDataImpl | unknown
KRIM_GRP_DOCUMENT_T | IdentityManagementGroupDocument |
KRIM_GRP_MBR_T | GroupMemberImpl | unknown
KRIM_GRP_T | GroupImpl | unknown
KRIM_PERM_ATTR_DATA_T | PermissionAttributeDataImpl | unknown
KRIM_PERM_T | KimPermissionImpl | unknown
KRIM_PERM_TMPL_T | KimPermissionTemplateImpl | unknown
KRIM_PERSON_DOCUMENT_T | IdentityManagementPersonDocument | unknown
KRIM_PHONE_TYP_T | PhoneTypeImpl | unknown
KRIM_PND_ADDR_MT | PersonDocumentAddress | unknown
KRIM_PND_AFLTN_MT | PersonDocumentAffiliation | unknown
KRIM_PND_CTZNSHP_MT | PersonDocumentCitizenship | unknown
KRIM_PND_DLGN_MBR_ATTR_DATA_T | RoleDocumentDelegationMemberQualifier | unknown
KRIM_PND_DLGN_MBR_T | RoleDocumentDelegationMember | unknown
KRIM_PND_DLGN_T | RoleDocumentDelegation | unknown
KRIM_PND_EMAIL_MT | PersonDocumentEmail | unknown
KRIM_PND_EMP_INFO_MT | PersonDocumentEmploymentInfo | unknown
KRIM_PND_GRP_ATTR_DATA_T | GroupDocumentQualifier | unknown
KRIM_PND_GRP_MBR_T | GroupDocumentMember | unknown
KRIM_PND_GRP_PRNCPL_MT | PersonDocumentGroup | unknown
KRIM_PND_NM_MT | PersonDocumentName | unknown
KRIM_PND_PHONE_MT | PersonDocumentPhone | unknown
KRIM_PND_PRIV_PREF_MT | PersonDocumentPrivacy | unknown
KRIM_PND_ROLE_MBR_ATTR_DATA_MT | KimDocumentRoleQualifier | unknown
KRIM_PND_ROLE_MBR_MT | KimDocumentRoleMember | unknown
KRIM_PND_ROLE_MT | PersonDocumentRole | unknown
KRIM_PND_ROLE_PERM_T | KimDocumentRolePermission | unknown
KRIM_PND_ROLE_RSP_ACTN_MT | KimDocumentRoleResponsibilityAction |
KRIM_PND_ROLE_RSP_T | KimDocumentRoleResponsibility | unknown
KRIM_PRNCPL_T | KimPrincipalImpl | unknown
KRIM_ROLE_DOCUMENT_T | IdentityManagementRoleDocument |
KRIM_ROLE_MBR_ATTR_DATA_T | RoleMemberAttributeDataImpl | unknown
KRIM_ROLE_MBR_T | RoleMemberImpl | unknown
KRIM_ROLE_PERM_T | RolePermissionImpl | unknown
KRIM_ROLE_RSP_ACTN_T | RoleResponsibilityActionImpl | unknown
KRIM_ROLE_RSP_T | RoleResponsibilityImpl | unknown
KRIM_ROLE_T | RoleImpl | unknown
KRIM_RSP_ATTR_DATA_T | ResponsibilityAttributeDataImpl | unknown
KRIM_RSP_T | KimResponsibilityImpl | unknown
KRIM_RSP_TMPL_T | KimResponsibilityTemplateImpl | unknown
KRIM_TYP_ATTR_T | KimTypeAttributeImpl | unknown
KRIM_TYP_T | KimTypeImpl | unknown
KRNS_ADHOC_RTE_ACTN_RECIP_T |  |
KRNS_ATT_T | Attachment | unknown
KRNS_CAMPUS_T | CampusImpl | unknown
KRNS_CMP_TYP_T | CampusTypeImpl | unknown
KRNS_DOC_HDR_T | DocumentHeader | unknown
KRNS_LOOKUP_RSLT_T | LookupResults | unknown
KRNS_LOOKUP_SEL_T | SelectedObjectIds | unknown
KRNS_MAINT_DOC_ATT_T | DocumentAttachment | unknown
KRNS_MAINT_DOC_T | MaintenanceDocumentBase | unknown
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 | unknown
KRNS_NTE_T | Note | Represents a user note in the system
KRNS_NTE_TYP_T | NoteType | unknown
KRNS_PARM_DTL_TYP_T | ParameterDetailType | unknown
KRNS_PARM_T | Parameter | unknown
KRNS_PARM_TYP_T | ParameterType | unknown
KRNS_PESSIMISTIC_LOCK_T | PessimisticLock | This is a business object used to lock a document pessimistically
KRNS_SESN_DOC_T | SessionDocument | unknown
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_FLT_SVC_DEF_T | KRSB_FLT_SVC_DEF_T |
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 | unknown
TRV_ACCT_EXT | TravelAccountExtension | unknown
TRV_ACCT_FO | FiscalOfficer | unknown
TRV_ACCT_TYPE | TravelAccountType | unknown
TRV_DOC_2 | TravelDocument2 | unknown
TRV_DOC_ACCT |  |
TST_SEARCH_ATTR_INDX_TST_DOC_T | TST_SEARCH_ATTR_INDX_TST_DOC_T |

## ACCT_DD_ATTR_DOC

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_ID | VARCHAR | (14) |  | DOC_HDR_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (14) |  | VER_NBR |  |  |  |
ACCT_NUM | DECIMAL | (14) |  | ACCT_NUM |  |  | X |
ACCT_OWNR | VARCHAR | (50) |  | ACCT_OWNR |  |  | X |
ACCT_BAL | DECIMAL | (16,2) |  | ACCT_BAL |  |  | X |
ACCT_OPN_DAT | DATE |  |  | ACCT_OPN_DAT |  |  | X |
ACCT_STAT | VARCHAR | (30) |  | ACCT_STAT |  |  | X |
ACCT_UPDATE_DT_TM | DATE |  |  | ACCT_UPDATE_DT_TM |  |  |  |
ACCT_AWAKE | VARCHAR | (1) |  | ACCT_AWAKE |  |  |  |

## 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) |  | Unknown | X | X |  | unknown
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 | Unknown |  |  | 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 | Unknown |  |  | X | test whether this is the current version
CNTNT_TYP_VER_NBR | DECIMAL | (8) | 0 | Unknown |  |  | X | version number
DESC_TXT | VARCHAR | (1000) |  | Description |  |  | X | description text
NMSPC_CD | VARCHAR | (1000) |  | Namespace |  |  | X | namespace code
XSD | CLOB |  |  | Xsd |  |  | X | unknown
XSL | CLOB |  |  | Xsl |  |  | X | unknown
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 |  |  | Unknown |  |  |  | unknown
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 | Unknown |  |  | X | unknown

## 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 | Unknown |  |  | X | unknown

## 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 | Unknown |  |  | X | unknown

## 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 | (40) |  | 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 | (40) |  | 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 | (40) |  | 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 | (40) |  | PrincipalId |  |  | X | principal identifier
DLGTR_PRNCPL_ID | VARCHAR | (40) |  | 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_APP_DOC_STAT_TRAN_T

Model bean representing the valid application document statuses for a document type

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
APP_DOC_STAT_TRAN_ID | DECIMAL | (19) |  | StatusTransitionId | X |  |  | application document status transition identifier
DOC_HDR_ID | DECIMAL | (14) |  | RouteHeaderId |  |  |  | document route header identifier
APP_DOC_STAT_FROM | VARCHAR | (64) |  | OldAppDocStatus |  |  |  | old application document status
APP_DOC_STAT_TO | VARCHAR | (64) |  | NewAppDocStatus |  |  |  | new application document status
STAT_TRANS_DATE | DATE |  |  | StatusTransitionDate |  |  |  | status transition date
VER_NBR | DECIMAL | (8) | 0 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## 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 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## KREW_DOC_HDR_CNTNT_T

unknown

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

unknown

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

unknown

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

unknown

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

unknown

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

unknown

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 | (40) |  | InitiatorWorkflowId |  |  | X | initiator workflow identifier
VER_NBR | DECIMAL | (8) | 0 | Unknown |  |  |  | unknown
RTE_PRNCPL_ID | VARCHAR | (40) |  | RoutedByUserWorkflowId |  |  |  | routed by user workflow identifier
DTYPE | VARCHAR | (50) |  | No longer exists |  |  |  | no longer exists
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
APP_DOC_STAT | VARCHAR | (64) |  | APP_DOC_STAT |  |  |  |
APP_DOC_STAT_MDFN_DT | DATE |  |  | APP_DOC_STAT_MDFN_DT |  |  |  |

## KREW_DOC_LNK_T

Server side bean for DocumentLinkDAO

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_LNK_ID | DECIMAL | (19) |  | DocLinkId | X |  |  | document link identifier
ORGN_DOC_ID | DECIMAL | (14) |  | OrgnDocId |  |  | X | orgn document identifier
DEST_DOC_ID | DECIMAL | (14) |  | DestDocId |  |  | X | dest document identifier

## 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 | (40) |  | 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_APP_DOC_STAT_T

An instance of this class represents a single valid status for a given document type

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_TYP_ID | DECIMAL | (19) |  | DocumentTypeId | X |  |  | document type identifier
DOC_STAT_NM | VARCHAR | (64) |  | StatusName | X |  |  | document status name
VER_NBR | DECIMAL | (8) | 0 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## 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 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
PLCY_VAL | VARCHAR | (64) |  | PLCY_VAL |  |  |  |

## 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 | (22) |  | InitialRouteNode |  |  |  | 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) |  | Unknown |  |  |  | unknown
BLNKT_APPR_PLCY | VARCHAR | (10) |  | BlanketApprovePolicy |  |  |  | blanket approve policy
ADV_DOC_SRCH_URL | VARCHAR | (255) |  | Unknown |  |  |  | unknown
CSTM_ACTN_LIST_ATTRIB_CLS_NM | VARCHAR | (255) |  | Unknown |  |  |  | unknown
CSTM_ACTN_EMAIL_ATTRIB_CLS_NM | VARCHAR | (255) |  | Unknown |  |  |  | unknown
CSTM_DOC_NTE_ATTRIB_CLS_NM | VARCHAR | (255) |  | Unknown |  |  |  | unknown
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 | Unknown |  |  |  | unknown
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) |  | Unknown |  |  | X | unknown
DOC_SEARCH_HELP_URL | VARCHAR | (4000) |  | DOC_SEARCH_HELP_URL |  |  |  |

## 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 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## 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 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## 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 | (40) |  | 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 | (40) |  | 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 | (40) |  | 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 | (40) |  | UserWorkflowId |  |  | X | user workflow identifier
RPLC_PRNCPL_ID | VARCHAR | (40) |  | 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

unknown

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) |  | Unknown |  |  | X | unknown
VAL | VARCHAR | (2000) |  | Unknown |  |  |  | unknown
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) |  | Unknown |  |  | X | unknown
VAL | VARCHAR | (4000) |  | Unknown |  |  |  | unknown

## KREW_RTE_NODE_INSTN_LNK_T

unknown

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

## 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) |  | Unknown |  |  | X | unknown
VAL | VARCHAR | (2000) |  | Unknown |  |  |  | unknown
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

unknown

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

## 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) |  | Unknown |  |  |  | unknown
GRP_ID | VARCHAR | (40) |  | ExceptionWorkgroupId |  |  |  | exception workgroup identifier
NEXT_DOC_STAT | VARCHAR | (64) |  | NEXT_DOC_STAT |  |  |  |

## 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 | Unknown |  |  |  | unknown
SVC_NMSPC | VARCHAR | (255) |  | ServiceNamespace |  |  |  | service namespace
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## 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) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 0 | Unknown |  |  |  | unknown

## 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 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## 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 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## 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 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## 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 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## 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 | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## KREW_USR_OPTN_T

An option defined for a user

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PRNCPL_ID | VARCHAR | (40) |  | 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

unknown

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

## KRIM_AFLTN_TYP_T

unknown

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

## KRIM_ATTR_DEFN_T

unknown

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) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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

## KRIM_CTZNSHP_STAT_T

unknown

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

## KRIM_DLGN_MBR_ATTR_DATA_T

unknown

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

## KRIM_DLGN_MBR_T

unknown

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 | Unknown |  |  | X | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
DLGN_ID | VARCHAR | (40) |  | DelegationId |  | X |  | delegation identifier
MBR_ID | VARCHAR | (40) |  | Unknown |  |  |  | unknown
MBR_TYP_CD | CHAR | (1) | P | Unknown |  |  |  | unknown
ACTV_FRM_DT | DATE |  |  | Unknown |  |  |  | unknown
ACTV_TO_DT | DATE |  |  | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown
ROLE_MBR_ID | VARCHAR | (40) |  | RoleMemberId |  |  |  | role member identifier

## KRIM_DLGN_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DLGN_ID | VARCHAR | (40) |  | DelegationId | X |  |  | delegation identifier
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
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

unknown

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

## KRIM_EMP_STAT_T

unknown

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

## KRIM_EMP_TYP_T

unknown

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

## KRIM_ENTITY_ADDR_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_ADDR_ID | VARCHAR | (40) |  | EntityAddressId | X |  |  | entity address identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_ENTITY_AFLTN_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_AFLTN_ID | VARCHAR | (40) |  | EntityAffiliationId | X |  |  | entity affiliation identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_ENTITY_BIO_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_ID | VARCHAR | (40) |  | EntityId | X |  |  | entity identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
BIRTH_DT | DATE |  |  | BirthDate |  |  |  | birth date
GNDR_CD | VARCHAR | (1) |  | GenderCode |  |  | X | gender code
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown
DECEASED_DT | DATE |  |  | DECEASED_DT |  |  |  |
MARITAL_STATUS | VARCHAR | (40) |  | MARITAL_STATUS |  |  |  |
PRIM_LANG_CD | VARCHAR | (40) |  | PRIM_LANG_CD |  |  |  |
SEC_LANG_CD | VARCHAR | (40) |  | SEC_LANG_CD |  |  |  |
BIRTH_CNTRY_CD | VARCHAR | (2) |  | BIRTH_CNTRY_CD |  |  |  |
BIRTH_STATE_CD | VARCHAR | (2) |  | BIRTH_STATE_CD |  |  |  |
BIRTH_CITY | VARCHAR | (30) |  | BIRTH_CITY |  |  |  |
GEO_ORIGIN | VARCHAR | (100) |  | GEO_ORIGIN |  |  |  |

## 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) |  | Unknown |  |  | X | unknown

## KRIM_ENTITY_CTZNSHP_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_CTZNSHP_ID | VARCHAR | (40) |  | EntityCitizenshipId | X |  |  | entity citizenship identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_ENTITY_EMAIL_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_EMAIL_ID | VARCHAR | (40) |  | EntityEmailId | X |  |  | entity email identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_ENTITY_EMP_INFO_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_EMP_ID | VARCHAR | (40) |  | EntityEmploymentId | X |  |  | entity employment identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown
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

unknown

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) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_ENTITY_ETHNIC_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ID | VARCHAR | (40) |  | Id | X |  |  | identifier
ENTITY_ID | VARCHAR | (40) |  | EntityId |  | X |  | entity identifier
ETHNCTY_CD | VARCHAR | (40) |  | EthnicityCode |  |  |  | ethnicity code
SUB_ETHNCTY_CD | VARCHAR | (40) |  | SubEthnicityCode |  |  |  | sub ethnicity code
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## KRIM_ENTITY_EXT_ID_T

unknown

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) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown

## KRIM_ENTITY_NM_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_NM_ID | VARCHAR | (40) |  | EntityNameId | X |  |  | entity name identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_ENTITY_PHONE_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_PHONE_ID | VARCHAR | (40) |  | EntityPhoneId | X |  |  | entity phone identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_ENTITY_PRIV_PREF_T

unknown

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

## KRIM_ENTITY_RESIDENCY_T

This class is used to store residency information about an entity

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ID | VARCHAR | (40) |  | Id | X |  |  | identifier
ENTITY_ID | VARCHAR | (40) |  | EntityId |  | X |  | entity identifier
DETERMINATION_METHOD | VARCHAR | (40) |  | DeterminationMethod |  |  |  | determination method
IN_STATE | VARCHAR | (40) |  | InStateFlag |  |  |  | in state flag
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## KRIM_ENTITY_T

unknown

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

## KRIM_ENTITY_VISA_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ID | VARCHAR | (40) |  | Id | X |  |  | identifier
ENTITY_ID | VARCHAR | (40) |  | EntityId |  | X |  | entity identifier
VISA_TYPE_KEY | VARCHAR | (40) |  | VisaTypeKey |  |  |  | visa type key
VISA_ENTRY | VARCHAR | (40) |  | VisaEntry |  |  |  | visa entry
VISA_ID | VARCHAR | (40) |  | VisaId |  |  |  | visa identifier
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown

## KRIM_ENT_NM_TYP_T

unknown

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) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
NM | VARCHAR | (40) |  | Name |  |  |  | name
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
DISPLAY_SORT_CD | VARCHAR | (2) |  | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_ENT_TYP_T

unknown

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

## KRIM_EXT_ID_TYP_T

unknown

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) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
NM | VARCHAR | (40) |  | Name |  |  |  | name
ENCR_REQ_IND | VARCHAR | (1) | N | EncryptionRequired |  |  |  | encryption required indicator
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
DISPLAY_SORT_CD | VARCHAR | (2) |  | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_GRP_ATTR_DATA_T

unknown

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

## 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

unknown

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 | Unknown |  |  | X | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
GRP_ID | VARCHAR | (40) |  | GroupId |  | X |  | group identifier
MBR_ID | VARCHAR | (40) |  | Unknown |  |  |  | unknown
MBR_TYP_CD | CHAR | (1) | P | Unknown |  |  |  | unknown
ACTV_FRM_DT | DATE |  |  | Unknown |  |  |  | unknown
ACTV_TO_DT | DATE |  |  | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_GRP_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
GRP_ID | VARCHAR | (40) |  | GroupId | X |  |  | group identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown

## KRIM_PERM_ATTR_DATA_T

unknown

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

## KRIM_PERM_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PERM_ID | VARCHAR | (40) |  | PermissionId | X |  |  | permission identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
PERM_TMPL_ID | VARCHAR | (40) |  | Unknown |  | X |  | unknown
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

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PERM_TMPL_ID | VARCHAR | (40) |  | PermissionTemplateId | X |  |  | permission template identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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

unknown

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

unknown

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

## KRIM_PND_ADDR_MT

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | Unknown | X |  |  | unknown
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) |  | Unknown |  |  |  | unknown
DFLT_IND | VARCHAR | (1) | N | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
ENTITY_ADDR_ID | VARCHAR | (40) |  | EntityAddressId | X |  |  | entity address identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
EDIT_FLAG | VARCHAR | (1) | N | Unknown |  |  |  | unknown

## KRIM_PND_AFLTN_MT

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | Unknown | X | X |  | unknown
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 | Unknown |  |  |  | unknown
DFLT_IND | VARCHAR | (1) | N | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
OBJ_ID | VARCHAR | (36) | SYS_GUID() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown

## KRIM_PND_CTZNSHP_MT

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | Unknown | X |  |  | unknown
ENTITY_CTZNSHP_ID | VARCHAR | (40) |  | EntityCitizenshipId | X |  |  | entity citizenship identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
EDIT_FLAG | VARCHAR | (1) | N | Unknown |  |  |  | unknown

## KRIM_PND_DLGN_MBR_ATTR_DATA_T

unknown

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

## KRIM_PND_DLGN_MBR_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | Unknown | X |  |  | unknown
DLGN_MBR_ID | VARCHAR | (40) |  | DelegationMemberId | X |  |  | delegation member identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
ACTV_FRM_DT | DATE |  |  | Unknown |  |  |  | unknown
ACTV_TO_DT | DATE |  |  | Unknown |  |  |  | unknown
ROLE_MBR_ID | VARCHAR | (40) |  | RoleMemberId |  |  |  | role member identifier

## KRIM_PND_DLGN_T

unknown

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

## KRIM_PND_EMAIL_MT

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | Unknown | X |  |  | unknown
ENTITY_EMAIL_ID | VARCHAR | (40) |  | EntityEmailId | X |  |  | entity email identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
EDIT_FLAG | VARCHAR | (1) | N | Unknown |  |  |  | unknown

## KRIM_PND_EMP_INFO_MT

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | Unknown | X |  |  | unknown
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) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
EDIT_FLAG | VARCHAR | (1) | N | Unknown |  |  |  | unknown

## KRIM_PND_GRP_ATTR_DATA_T

unknown

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

## KRIM_PND_GRP_MBR_T

unknown

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

## KRIM_PND_GRP_PRNCPL_MT

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
GRP_MBR_ID | VARCHAR | (40) |  | GroupMemberId | X |  |  | group member identifier
FDOC_NBR | VARCHAR | (14) |  | Unknown | X |  |  | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
GRP_ID | VARCHAR | (40) |  | GroupId |  |  | X | group identifier
PRNCPL_ID | VARCHAR | (40) |  | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
GRP_NM | VARCHAR | (80) |  | GroupName |  |  | X | group name
GRP_TYPE | VARCHAR | (80) |  | GroupType |  |  |  | group type
KIM_TYP_ID | VARCHAR | (40) |  | Unknown |  |  |  | unknown
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 | Unknown |  |  |  | unknown

## KRIM_PND_NM_MT

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | Unknown | X |  |  | unknown
ENTITY_NM_ID | VARCHAR | (40) |  | EntityNameId | X |  |  | entity name identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
EDIT_FLAG | VARCHAR | (1) | N | Unknown |  |  |  | unknown

## KRIM_PND_PHONE_MT

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | Unknown | X |  |  | unknown
ENTITY_PHONE_ID | VARCHAR | (40) |  | EntityPhoneId | X |  |  | entity phone identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown
ACTV_IND | VARCHAR | (1) | Y | Unknown |  |  |  | unknown
EDIT_FLAG | VARCHAR | (1) | N | Unknown |  |  |  | unknown

## KRIM_PND_PRIV_PREF_MT

unknown

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

## KRIM_PND_ROLE_MBR_ATTR_DATA_MT

unknown

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

## KRIM_PND_ROLE_MBR_MT

unknown

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

## KRIM_PND_ROLE_MT

unknown

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

## KRIM_PND_ROLE_PERM_T

unknown

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

## 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

unknown

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

## KRIM_PRNCPL_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PRNCPL_ID | VARCHAR | (40) |  | PrincipalId | X |  |  | principal identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown

## 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 |  |  |  |  |
DESC_TXT | VARCHAR | (4000) |  |  |  |  |  |

## KRIM_ROLE_MBR_ATTR_DATA_T

unknown

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

## KRIM_ROLE_MBR_T

unknown

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 | Unknown |  |  | X | unknown
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
ROLE_ID | VARCHAR | (40) |  | RoleId |  | X |  | role identifier
MBR_ID | VARCHAR | (40) |  | Unknown |  |  |  | unknown
MBR_TYP_CD | CHAR | (1) | P | Unknown |  |  |  | unknown
ACTV_FRM_DT | DATE |  |  | Unknown |  |  |  | unknown
ACTV_TO_DT | DATE |  |  | Unknown |  |  |  | unknown
LAST_UPDT_DT | DATE |  | SYSDATE | Unknown |  |  |  | unknown

## KRIM_ROLE_PERM_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ROLE_PERM_ID | VARCHAR | (40) |  | RolePermissionId | X |  |  | role permission identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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

unknown

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

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ROLE_RSP_ID | VARCHAR | (40) |  | RoleResponsibilityId | X |  |  | role responsibility identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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

unknown

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 | Unknown |  |  | X | unknown
ROLE_NM | VARCHAR | (80) |  | Unknown |  |  | X | unknown
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 | Unknown |  |  |  | unknown

## KRIM_RSP_ATTR_DATA_T

unknown

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

## KRIM_RSP_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RSP_ID | VARCHAR | (40) |  | ResponsibilityId | X |  |  | responsibility identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
RSP_TMPL_ID | VARCHAR | (40) |  | Unknown |  | X |  | unknown
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

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RSP_TMPL_ID | VARCHAR | (40) |  | ResponsibilityTemplateId | X |  |  | responsibility template identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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

unknown

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) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
KIM_TYP_ID | VARCHAR | (40) |  | KimTypeId | X |  |  | kim type identifier
OBJ_ID | VARCHAR | (36) |  | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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

unknown

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() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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

unknown

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() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
ACTV_IND | VARCHAR | (1) | Y | Active |  |  | X | active indicator

## KRNS_CMP_TYP_T

unknown

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() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
ACTV_IND | VARCHAR | (1) | Y | Active |  |  | X | active indicator

## KRNS_DOC_HDR_T

unknown

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() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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

unknown

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

## KRNS_LOOKUP_SEL_T

unknown

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

## KRNS_MAINT_DOC_ATT_T

unknown

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

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_ID | VARCHAR | (14) |  | Unknown | X | X |  | unknown
OBJ_ID | VARCHAR | (36) | SYS_GUID() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
DOC_HDR_ID | VARCHAR | (14) |  | DocumentNumber |  |  | X | document header identifier
MAINT_LOCK_ID | VARCHAR | (14) |  | LockId | X |  |  | maintenance lock identifier

## KRNS_NMSPC_T

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
NMSPC_CD | VARCHAR | (20) |  | Unknown | X |  |  | unknown
OBJ_ID | VARCHAR | (36) | SYS_GUID() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
NM | VARCHAR | (40) |  | Unknown |  |  |  | unknown
ACTV_IND | CHAR | (1) | Y | Unknown |  |  | X | unknown
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() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
RMT_OBJ_ID | VARCHAR | (36) |  | RemoteObjectIdentifier |  |  | X | remote object identifier
AUTH_PRNCPL_ID | VARCHAR | (40) |  | 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

unknown

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() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
TYP_DESC_TXT | VARCHAR | (100) |  | NoteTypeDescription |  |  |  | note type description text
ACTV_IND | VARCHAR | (1) |  | NoteTypeActiveIndicator |  |  |  | note type indicator

## KRNS_PARM_DTL_TYP_T

unknown

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() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
NM | VARCHAR | (255) |  | ParameterDetailTypeName |  |  |  | parameter detail type name
ACTV_IND | CHAR | (1) | Y | Active |  |  | X | active indicator

## KRNS_PARM_T

unknown

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() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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

unknown

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() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
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 | (40) |  | OwnedByPrincipalIdentifier |  |  | X | owned by principal identifier

## KRNS_SESN_DOC_T

unknown

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_FLT_SVC_DEF_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FLT_SVC_DEF_ID | DECIMAL | (14) |  | FLT_SVC_DEF_ID | X |  |  |
FLT_SVC_DEF | CLOB |  |  | FLT_SVC_DEF |  |  | X |

## 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
VER_NBR | DECIMAL | (8) | 0 | LockVerNbr |  |  |  | lock version number
FLT_SVC_DEF_ID | DECIMAL | (14) |  | FLT_SVC_DEF_ID |  |  | X |
SVC_DEF_CHKSM | VARCHAR | (30) |  | SVC_DEF_CHKSM |  |  | X |

## 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

unknown

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

unknown

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

unknown

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

unknown

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

unknown

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | Unknown | X |  |  | unknown
OBJ_ID | VARCHAR | (36) | SYS_GUID() | Unknown |  |  | X | unknown
VER_NBR | DECIMAL | (8) | 1 | Unknown |  |  | X | unknown
FDOC_EXPLAIN_TXT | VARCHAR | (400) |  | Unknown |  |  |  | unknown
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 |  |  |

## TST_SEARCH_ATTR_INDX_TST_DOC_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_ID | VARCHAR | (14) |  | DOC_HDR_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (14) |  | VER_NBR |  |  |  |
RTE_LVL_CNT | DECIMAL | (14) |  | RTE_LVL_CNT |  |  |  |
CNSTNT_STR | VARCHAR | (50) |  | CNSTNT_STR |  |  |  |
RTD_STR | VARCHAR | (50) |  | RTD_STR |  |  |  |
HLD_RTD_STR | VARCHAR | (50) |  | HLD_RTD_STR |  |  |  |
RD_ACCS_CNT | DECIMAL | (14) |  | RD_ACCS_CNT |  |  |  |