Table Name | OM Class | Description
--- | --- | ---
ACCT_DD_ATTR_DOC | ACCT_DD_ATTR_DOC |
KREN_CHNL_PRODCR_T | KREN_CHNL_PRODCR_T |
KREN_CHNL_SUBSCRP_T | KREN_CHNL_SUBSCRP_T |
KREN_CHNL_T | KREN_CHNL_T |
KREN_CNTNT_TYP_T | KREN_CNTNT_TYP_T |
KREN_MSG_DELIV_T | KREN_MSG_DELIV_T |
KREN_MSG_T | KREN_MSG_T |
KREN_NTFCTN_MSG_DELIV_T | KREN_NTFCTN_MSG_DELIV_T |
KREN_NTFCTN_T | KREN_NTFCTN_T |
KREN_PRIO_T | KREN_PRIO_T |
KREN_PRODCR_T | KREN_PRODCR_T |
KREN_RECIP_DELIV_T | KREN_RECIP_DELIV_T |
KREN_RECIP_LIST_T | KREN_RECIP_LIST_T |
KREN_RECIP_PREFS_T | KREN_RECIP_PREFS_T |
KREN_RECIP_T | KREN_RECIP_T |
KREN_RVWER_T | KREN_RVWER_T |
KREN_SNDR_T | KREN_SNDR_T |
KREW_ACTN_ITM_T | KREW_ACTN_ITM_T |
KREW_ACTN_RQST_T | KREW_ACTN_RQST_T |
KREW_ACTN_TKN_T | KREW_ACTN_TKN_T |
KREW_APP_DOC_STAT_TRAN_T | KREW_APP_DOC_STAT_TRAN_T |
KREW_ATT_T | KREW_ATT_T |
KREW_DLGN_RSP_T | KREW_DLGN_RSP_T |
KREW_DOC_HDR_CNTNT_T | KREW_DOC_HDR_CNTNT_T |
KREW_DOC_HDR_EXT_DT_T | KREW_DOC_HDR_EXT_DT_T |
KREW_DOC_HDR_EXT_FLT_T | KREW_DOC_HDR_EXT_FLT_T |
KREW_DOC_HDR_EXT_LONG_T | KREW_DOC_HDR_EXT_LONG_T |
KREW_DOC_HDR_EXT_T | KREW_DOC_HDR_EXT_T |
KREW_DOC_HDR_T | KREW_DOC_HDR_T |
KREW_DOC_LNK_T | KREW_DOC_LNK_T |
KREW_DOC_NTE_T | KREW_DOC_NTE_T |
KREW_DOC_TYP_APP_DOC_STAT_T | KREW_DOC_TYP_APP_DOC_STAT_T |
KREW_DOC_TYP_ATTR_T | KREW_DOC_TYP_ATTR_T |
KREW_DOC_TYP_PLCY_RELN_T | KREW_DOC_TYP_PLCY_RELN_T |
KREW_DOC_TYP_PROC_T | KREW_DOC_TYP_PROC_T |
KREW_DOC_TYP_T | KREW_DOC_TYP_T |
KREW_EDL_ASSCTN_T | KREW_EDL_ASSCTN_T |
KREW_EDL_DEF_T | KREW_EDL_DEF_T |
KREW_EDL_DMP_T | KREW_EDL_DMP_T |
KREW_EDL_FLD_DMP_T | KREW_EDL_FLD_DMP_T |
KREW_HLP_T | KREW_HLP_T |
KREW_INIT_RTE_NODE_INSTN_T | KREW_INIT_RTE_NODE_INSTN_T |
KREW_OUT_BOX_ITM_T | KREW_OUT_BOX_ITM_T |
KREW_RMV_RPLC_DOC_T | KREW_RMV_RPLC_DOC_T |
KREW_RMV_RPLC_GRP_T | KREW_RMV_RPLC_GRP_T |
KREW_RMV_RPLC_RULE_T | KREW_RMV_RPLC_RULE_T |
KREW_RTE_BRCH_PROTO_T | KREW_RTE_BRCH_PROTO_T |
KREW_RTE_BRCH_ST_T | KREW_RTE_BRCH_ST_T |
KREW_RTE_BRCH_T | KREW_RTE_BRCH_T |
KREW_RTE_NODE_CFG_PARM_T | KREW_RTE_NODE_CFG_PARM_T |
KREW_RTE_NODE_INSTN_LNK_T | KREW_RTE_NODE_INSTN_LNK_T |
KREW_RTE_NODE_INSTN_ST_T | KREW_RTE_NODE_INSTN_ST_T |
KREW_RTE_NODE_INSTN_T | KREW_RTE_NODE_INSTN_T |
KREW_RTE_NODE_LNK_T | KREW_RTE_NODE_LNK_T |
KREW_RTE_NODE_T | KREW_RTE_NODE_T |
KREW_RULE_ATTR_T | KREW_RULE_ATTR_T |
KREW_RULE_EXPR_T | KREW_RULE_EXPR_T |
KREW_RULE_EXT_T | KREW_RULE_EXT_T |
KREW_RULE_EXT_VAL_T | KREW_RULE_EXT_VAL_T |
KREW_RULE_RSP_T | KREW_RULE_RSP_T |
KREW_RULE_T | KREW_RULE_T |
KREW_RULE_TMPL_ATTR_T | KREW_RULE_TMPL_ATTR_T |
KREW_RULE_TMPL_OPTN_T | KREW_RULE_TMPL_OPTN_T |
KREW_RULE_TMPL_T | KREW_RULE_TMPL_T |
KREW_STYLE_T | KREW_STYLE_T |
KREW_USR_OPTN_T | KREW_USR_OPTN_T |
KRIM_ADDR_TYP_T | KRIM_ADDR_TYP_T |
KRIM_AFLTN_TYP_T | KRIM_AFLTN_TYP_T |
KRIM_ATTR_DEFN_T | KRIM_ATTR_DEFN_T |
KRIM_CTZNSHP_STAT_T | KRIM_CTZNSHP_STAT_T |
KRIM_DLGN_MBR_ATTR_DATA_T | KRIM_DLGN_MBR_ATTR_DATA_T |
KRIM_DLGN_MBR_T | KRIM_DLGN_MBR_T |
KRIM_DLGN_T | KRIM_DLGN_T |
KRIM_EMAIL_TYP_T | KRIM_EMAIL_TYP_T |
KRIM_EMP_STAT_T | KRIM_EMP_STAT_T |
KRIM_EMP_TYP_T | KRIM_EMP_TYP_T |
KRIM_ENTITY_ADDR_T | KRIM_ENTITY_ADDR_T |
KRIM_ENTITY_AFLTN_T | KRIM_ENTITY_AFLTN_T |
KRIM_ENTITY_BIO_T | KRIM_ENTITY_BIO_T |
KRIM_ENTITY_CACHE_T | KRIM_ENTITY_CACHE_T |
KRIM_ENTITY_CTZNSHP_T | KRIM_ENTITY_CTZNSHP_T |
KRIM_ENTITY_EMAIL_T | KRIM_ENTITY_EMAIL_T |
KRIM_ENTITY_EMP_INFO_T | KRIM_ENTITY_EMP_INFO_T |
KRIM_ENTITY_ENT_TYP_T | KRIM_ENTITY_ENT_TYP_T |
KRIM_ENTITY_ETHNIC_T | KRIM_ENTITY_ETHNIC_T |
KRIM_ENTITY_EXT_ID_T | KRIM_ENTITY_EXT_ID_T |
KRIM_ENTITY_NM_T | KRIM_ENTITY_NM_T |
KRIM_ENTITY_PHONE_T | KRIM_ENTITY_PHONE_T |
KRIM_ENTITY_PRIV_PREF_T | KRIM_ENTITY_PRIV_PREF_T |
KRIM_ENTITY_RESIDENCY_T | KRIM_ENTITY_RESIDENCY_T |
KRIM_ENTITY_T | KRIM_ENTITY_T |
KRIM_ENTITY_VISA_T | KRIM_ENTITY_VISA_T |
KRIM_ENT_NM_TYP_T | KRIM_ENT_NM_TYP_T |
KRIM_ENT_TYP_T | KRIM_ENT_TYP_T |
KRIM_EXT_ID_TYP_T | KRIM_EXT_ID_TYP_T |
KRIM_GRP_ATTR_DATA_T | KRIM_GRP_ATTR_DATA_T |
KRIM_GRP_DOCUMENT_T | KRIM_GRP_DOCUMENT_T |
KRIM_GRP_MBR_T | KRIM_GRP_MBR_T |
KRIM_GRP_T | KRIM_GRP_T |
KRIM_PERM_ATTR_DATA_T | KRIM_PERM_ATTR_DATA_T |
KRIM_PERM_T | KRIM_PERM_T |
KRIM_PERM_TMPL_T | KRIM_PERM_TMPL_T |
KRIM_PERSON_DOCUMENT_T | KRIM_PERSON_DOCUMENT_T |
KRIM_PHONE_TYP_T | KRIM_PHONE_TYP_T |
KRIM_PND_ADDR_MT | KRIM_PND_ADDR_MT |
KRIM_PND_AFLTN_MT | KRIM_PND_AFLTN_MT |
KRIM_PND_CTZNSHP_MT | KRIM_PND_CTZNSHP_MT |
KRIM_PND_DLGN_MBR_ATTR_DATA_T | KRIM_PND_DLGN_MBR_ATTR_DATA_T |
KRIM_PND_DLGN_MBR_T | KRIM_PND_DLGN_MBR_T |
KRIM_PND_DLGN_T | KRIM_PND_DLGN_T |
KRIM_PND_EMAIL_MT | KRIM_PND_EMAIL_MT |
KRIM_PND_EMP_INFO_MT | KRIM_PND_EMP_INFO_MT |
KRIM_PND_GRP_ATTR_DATA_T | KRIM_PND_GRP_ATTR_DATA_T |
KRIM_PND_GRP_MBR_T | KRIM_PND_GRP_MBR_T |
KRIM_PND_GRP_PRNCPL_MT | KRIM_PND_GRP_PRNCPL_MT |
KRIM_PND_NM_MT | KRIM_PND_NM_MT |
KRIM_PND_PHONE_MT | KRIM_PND_PHONE_MT |
KRIM_PND_PRIV_PREF_MT | KRIM_PND_PRIV_PREF_MT |
KRIM_PND_ROLE_MBR_ATTR_DATA_MT | KRIM_PND_ROLE_MBR_ATTR_DATA_MT |
KRIM_PND_ROLE_MBR_MT | KRIM_PND_ROLE_MBR_MT |
KRIM_PND_ROLE_MT | KRIM_PND_ROLE_MT |
KRIM_PND_ROLE_PERM_T | KRIM_PND_ROLE_PERM_T |
KRIM_PND_ROLE_RSP_ACTN_MT | KRIM_PND_ROLE_RSP_ACTN_MT |
KRIM_PND_ROLE_RSP_T | KRIM_PND_ROLE_RSP_T |
KRIM_PRNCPL_T | KRIM_PRNCPL_T |
KRIM_ROLE_DOCUMENT_T | KRIM_ROLE_DOCUMENT_T |
KRIM_ROLE_MBR_ATTR_DATA_T | KRIM_ROLE_MBR_ATTR_DATA_T |
KRIM_ROLE_MBR_T | KRIM_ROLE_MBR_T |
KRIM_ROLE_PERM_T | KRIM_ROLE_PERM_T |
KRIM_ROLE_RSP_ACTN_T | KRIM_ROLE_RSP_ACTN_T |
KRIM_ROLE_RSP_T | KRIM_ROLE_RSP_T |
KRIM_ROLE_T | KRIM_ROLE_T |
KRIM_RSP_ATTR_DATA_T | KRIM_RSP_ATTR_DATA_T |
KRIM_RSP_T | KRIM_RSP_T |
KRIM_RSP_TMPL_T | KRIM_RSP_TMPL_T |
KRIM_TYP_ATTR_T | KRIM_TYP_ATTR_T |
KRIM_TYP_T | KRIM_TYP_T |
KRNS_ADHOC_RTE_ACTN_RECIP_T | KRNS_ADHOC_RTE_ACTN_RECIP_T |
KRNS_ATT_T | KRNS_ATT_T |
KRNS_CAMPUS_T | KRNS_CAMPUS_T |
KRNS_CMP_TYP_T | KRNS_CMP_TYP_T |
KRNS_DOC_HDR_T | KRNS_DOC_HDR_T |
KRNS_LOOKUP_RSLT_T | KRNS_LOOKUP_RSLT_T |
KRNS_LOOKUP_SEL_T | KRNS_LOOKUP_SEL_T |
KRNS_MAINT_DOC_ATT_T | KRNS_MAINT_DOC_ATT_T |
KRNS_MAINT_DOC_T | KRNS_MAINT_DOC_T |
KRNS_MAINT_LOCK_T | KRNS_MAINT_LOCK_T |
KRNS_NMSPC_T | KRNS_NMSPC_T |
KRNS_NTE_T | KRNS_NTE_T |
KRNS_NTE_TYP_T | KRNS_NTE_TYP_T |
KRNS_PARM_DTL_TYP_T | KRNS_PARM_DTL_TYP_T |
KRNS_PARM_T | KRNS_PARM_T |
KRNS_PARM_TYP_T | KRNS_PARM_TYP_T |
KRNS_PESSIMISTIC_LOCK_T | KRNS_PESSIMISTIC_LOCK_T |
KRNS_SESN_DOC_T | KRNS_SESN_DOC_T |
KRSB_BAM_PARM_T | KRSB_BAM_PARM_T |
KRSB_BAM_T | KRSB_BAM_T |
KRSB_FLT_SVC_DEF_T | KRSB_FLT_SVC_DEF_T |
KRSB_MSG_PYLD_T | KRSB_MSG_PYLD_T |
KRSB_MSG_QUE_T | KRSB_MSG_QUE_T |
KRSB_QRTZ_BLOB_TRIGGERS | KRSB_QRTZ_BLOB_TRIGGERS |
KRSB_QRTZ_CALENDARS | KRSB_QRTZ_CALENDARS |
KRSB_QRTZ_CRON_TRIGGERS | KRSB_QRTZ_CRON_TRIGGERS |
KRSB_QRTZ_FIRED_TRIGGERS | KRSB_QRTZ_FIRED_TRIGGERS |
KRSB_QRTZ_JOB_DETAILS | KRSB_QRTZ_JOB_DETAILS |
KRSB_QRTZ_JOB_LISTENERS | KRSB_QRTZ_JOB_LISTENERS |
KRSB_QRTZ_LOCKS | KRSB_QRTZ_LOCKS |
KRSB_QRTZ_PAUSED_TRIGGER_GRPS | KRSB_QRTZ_PAUSED_TRIGGER_GRPS |
KRSB_QRTZ_SCHEDULER_STATE | KRSB_QRTZ_SCHEDULER_STATE |
KRSB_QRTZ_SIMPLE_TRIGGERS | KRSB_QRTZ_SIMPLE_TRIGGERS |
KRSB_QRTZ_TRIGGERS | KRSB_QRTZ_TRIGGERS |
KRSB_QRTZ_TRIGGER_LISTENERS | KRSB_QRTZ_TRIGGER_LISTENERS |
KRSB_SVC_DEF_T | KRSB_SVC_DEF_T |
KR_COUNTRY_T | KR_COUNTRY_T |
KR_COUNTY_T | KR_COUNTY_T |
KR_KIM_TEST_BO | KR_KIM_TEST_BO |
KR_POSTAL_CODE_T | KR_POSTAL_CODE_T |
KR_STATE_T | KR_STATE_T |
TRAV_DOC_2_ACCOUNTS | TRAV_DOC_2_ACCOUNTS |
TRV_ACCT | TRV_ACCT |
TRV_ACCT_EXT | TRV_ACCT_EXT |
TRV_ACCT_FO | TRV_ACCT_FO |
TRV_ACCT_TYPE | TRV_ACCT_TYPE |
TRV_DOC_2 | TRV_DOC_2 |
TRV_DOC_ACCT | 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

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
CHNL_ID | DECIMAL | (8) |  | CHNL_ID | X | X |  |
PRODCR_ID | DECIMAL | (8) |  | PRODCR_ID | X | X |  |

## KREN_CHNL_SUBSCRP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
CHNL_SUBSCRP_ID | DECIMAL | (8) |  | CHNL_SUBSCRP_ID | X |  |  |
CHNL_ID | DECIMAL | (8) |  | CHNL_ID |  | X | X |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (8) |  | VER_NBR |  |  |  |

## KREN_CHNL_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
CHNL_ID | DECIMAL | (8) |  | CHNL_ID | X |  |  |
NM | VARCHAR | (200) |  | NM |  |  | X |
DESC_TXT | VARCHAR | (4000) |  | DESC_TXT |  |  | X |
SUBSCRB_IND | CHAR | (1) |  | SUBSCRB_IND |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |

## KREN_CNTNT_TYP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
CNTNT_TYP_ID | DECIMAL | (8) |  | CNTNT_TYP_ID | X |  |  |
NM | VARCHAR | (200) |  | NM |  |  | X |
CUR_IND | CHAR | (1) | T | CUR_IND |  |  | X |
CNTNT_TYP_VER_NBR | DECIMAL | (8) | 0 | CNTNT_TYP_VER_NBR |  |  | X |
DESC_TXT | VARCHAR | (1000) |  | DESC_TXT |  |  | X |
NMSPC_CD | VARCHAR | (1000) |  | NMSPC_CD |  |  | X |
XSD | CLOB |  |  | XSD |  |  | X |
XSL | CLOB |  |  | XSL |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |

## KREN_MSG_DELIV_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
MSG_DELIV_ID | DECIMAL | (8) |  | MSG_DELIV_ID | X |  |  |
MSG_ID | DECIMAL | (8) |  | MSG_ID |  | X | X |
TYP_NM | VARCHAR | (200) |  | TYP_NM |  |  | X |
SYS_ID | VARCHAR | (300) |  | SYS_ID |  |  |  |
STAT_CD | VARCHAR | (15) |  | STAT_CD |  |  | X |
PROC_CNT | DECIMAL | (4) | 0 | PROC_CNT |  |  | X |
LOCKD_DTTM | DATE |  |  | LOCKD_DTTM |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  | X |

## KREN_MSG_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
MSG_ID | DECIMAL | (8) |  | MSG_ID | X |  |  |
ORGN_ID | VARCHAR | (128) |  | ORGN_ID |  |  |  |
DELIV_TYP | VARCHAR | (500) |  | DELIV_TYP |  |  | X |
CRTE_DTTM | DATE |  |  | CRTE_DTTM |  |  | X |
TTL | VARCHAR | (255) |  | TTL |  |  |  |
CHNL | VARCHAR | (300) |  | CHNL |  |  | X |
PRODCR | VARCHAR | (300) |  | PRODCR |  |  |  |
CNTNT | CLOB |  |  | CNTNT |  |  | X |
CNTNT_TYP | VARCHAR | (128) |  | CNTNT_TYP |  |  |  |
URL | VARCHAR | (512) |  | URL |  |  |  |
RECIP_ID | VARCHAR | (300) |  | RECIP_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  | X |

## KREN_NTFCTN_MSG_DELIV_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
NTFCTN_MSG_DELIV_ID | DECIMAL | (8) |  | NTFCTN_MSG_DELIV_ID | X |  |  |
NTFCTN_ID | DECIMAL | (8) |  | NTFCTN_ID |  | X | X |
RECIP_ID | VARCHAR | (40) |  | RECIP_ID |  |  | X |
STAT_CD | VARCHAR | (15) |  | STAT_CD |  |  | X |
SYS_ID | VARCHAR | (300) |  | SYS_ID |  |  |  |
LOCKD_DTTM | DATE |  |  | LOCKD_DTTM |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |

## KREN_NTFCTN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
NTFCTN_ID | DECIMAL | (8) |  | NTFCTN_ID | X |  |  |
DELIV_TYP | VARCHAR | (3) |  | DELIV_TYP |  |  | X |
CRTE_DTTM | DATE |  |  | CRTE_DTTM |  |  | X |
SND_DTTM | DATE |  |  | SND_DTTM |  |  |  |
AUTO_RMV_DTTM | DATE |  |  | AUTO_RMV_DTTM |  |  |  |
PRIO_ID | DECIMAL | (8) |  | PRIO_ID |  | X | X |
TTL | VARCHAR | (255) |  | TTL |  |  |  |
CNTNT | CLOB |  |  | CNTNT |  |  | X |
CNTNT_TYP_ID | DECIMAL | (8) |  | CNTNT_TYP_ID |  | X | X |
CHNL_ID | DECIMAL | (8) |  | CHNL_ID |  | X | X |
PRODCR_ID | DECIMAL | (8) |  | PRODCR_ID |  | X | X |
PROCESSING_FLAG | VARCHAR | (15) |  | PROCESSING_FLAG |  |  | X |
LOCKD_DTTM | DATE |  |  | LOCKD_DTTM |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |

## KREN_PRIO_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PRIO_ID | DECIMAL | (8) |  | PRIO_ID | X |  |  |
NM | VARCHAR | (40) |  | NM |  |  | X |
DESC_TXT | VARCHAR | (500) |  | DESC_TXT |  |  | X |
PRIO_ORD | DECIMAL | (4) |  | PRIO_ORD |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |

## KREN_PRODCR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PRODCR_ID | DECIMAL | (8) |  | PRODCR_ID | X |  |  |
NM | VARCHAR | (200) |  | NM |  |  | X |
DESC_TXT | VARCHAR | (1000) |  | DESC_TXT |  |  | X |
CNTCT_INFO | VARCHAR | (1000) |  | CNTCT_INFO |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |

## KREN_RECIP_DELIV_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RECIP_DELIV_ID | DECIMAL | (8) |  | RECIP_DELIV_ID | X |  |  |
RECIP_ID | VARCHAR | (40) |  | RECIP_ID |  |  | X |
CHNL | VARCHAR | (300) |  | CHNL |  |  | X |
NM | VARCHAR | (200) |  | NM |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  | X |

## KREN_RECIP_LIST_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RECIP_LIST_ID | DECIMAL | (8) |  | RECIP_LIST_ID | X |  |  |
CHNL_ID | DECIMAL | (8) |  | CHNL_ID |  | X | X |
RECIP_TYP_CD | VARCHAR | (10) |  | RECIP_TYP_CD |  |  | X |
RECIP_ID | VARCHAR | (40) |  | RECIP_ID |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (8) |  | VER_NBR |  |  |  |

## KREN_RECIP_PREFS_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RECIP_PREFS_ID | DECIMAL | (8) |  | RECIP_PREFS_ID | X |  |  |
RECIP_ID | VARCHAR | (40) |  | RECIP_ID |  |  | X |
PROP | VARCHAR | (200) |  | PROP |  |  | X |
VAL | VARCHAR | (1000) |  | VAL |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  | X |

## KREN_RECIP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RECIP_ID | DECIMAL | (8) |  | RECIP_ID | X |  |  |
NTFCTN_ID | DECIMAL | (8) |  | NTFCTN_ID |  | X | X |
RECIP_TYP_CD | VARCHAR | (10) |  | RECIP_TYP_CD |  |  | X |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (8) |  | VER_NBR |  |  |  |

## KREN_RVWER_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RVWER_ID | DECIMAL | (8) |  | RVWER_ID | X |  |  |
CHNL_ID | DECIMAL | (8) |  | CHNL_ID |  | X | X |
TYP | VARCHAR | (10) |  | TYP |  |  | X |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |

## KREN_SNDR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
SNDR_ID | DECIMAL | (8) |  | SNDR_ID | X |  |  |
NTFCTN_ID | DECIMAL | (8) |  | NTFCTN_ID |  | X | X |
NM | VARCHAR | (200) |  | NM |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (8) |  | VER_NBR |  |  |  |

## KREW_ACTN_ITM_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ACTN_ITM_ID | DECIMAL | (14) |  | ACTN_ITM_ID | X |  |  |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  | X |
ASND_DT | DATE |  |  | ASND_DT |  |  | X |
RQST_CD | CHAR | (1) |  | RQST_CD |  |  | X |
ACTN_RQST_ID | DECIMAL | (14) |  | ACTN_RQST_ID |  |  | X |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  | X |
ROLE_NM | VARCHAR | (2000) |  | ROLE_NM |  |  |  |
DLGN_PRNCPL_ID | VARCHAR | (40) |  | DLGN_PRNCPL_ID |  |  |  |
DOC_HDR_TTL | VARCHAR | (255) |  | DOC_HDR_TTL |  |  |  |
DOC_TYP_LBL | VARCHAR | (128) |  | DOC_TYP_LBL |  |  | X |
DOC_HDLR_URL | VARCHAR | (255) |  | DOC_HDLR_URL |  |  | X |
DOC_TYP_NM | VARCHAR | (64) |  | DOC_TYP_NM |  |  | X |
RSP_ID | DECIMAL | (14) |  | RSP_ID |  |  | X |
DLGN_TYP | VARCHAR | (1) |  | DLGN_TYP |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
DTYPE | VARCHAR | (50) |  | DTYPE |  |  |  |
GRP_ID | VARCHAR | (40) |  | GRP_ID |  |  |  |
DLGN_GRP_ID | VARCHAR | (40) |  | DLGN_GRP_ID |  |  |  |
RQST_LBL | VARCHAR | (255) |  | RQST_LBL |  |  |  |

## KREW_ACTN_RQST_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ACTN_RQST_ID | DECIMAL | (14) |  | ACTN_RQST_ID | X |  |  |
PARNT_ID | DECIMAL | (14) |  | PARNT_ID |  |  |  |
ACTN_RQST_CD | CHAR | (1) |  | ACTN_RQST_CD |  |  | X |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  | X |
RULE_ID | DECIMAL | (19) |  | RULE_ID |  |  |  |
STAT_CD | CHAR | (1) |  | STAT_CD |  |  | X |
RSP_ID | DECIMAL | (14) |  | RSP_ID |  |  | X |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  |  |
ROLE_NM | VARCHAR | (2000) |  | ROLE_NM |  |  |  |
QUAL_ROLE_NM | VARCHAR | (2000) |  | QUAL_ROLE_NM |  |  |  |
QUAL_ROLE_NM_LBL_TXT | VARCHAR | (2000) |  | QUAL_ROLE_NM_LBL_TXT |  |  |  |
RECIP_TYP_CD | CHAR | (1) |  | RECIP_TYP_CD |  |  |  |
PRIO_NBR | DECIMAL | (8) |  | PRIO_NBR |  |  | X |
RTE_TYP_NM | VARCHAR | (255) |  | RTE_TYP_NM |  |  |  |
RTE_LVL_NBR | DECIMAL | (8) |  | RTE_LVL_NBR |  |  | X |
RTE_NODE_INSTN_ID | DECIMAL | (19) |  | RTE_NODE_INSTN_ID |  |  |  |
ACTN_TKN_ID | DECIMAL | (14) |  | ACTN_TKN_ID |  |  |  |
DOC_VER_NBR | DECIMAL | (8) |  | DOC_VER_NBR |  |  | X |
CRTE_DT | DATE |  |  | CRTE_DT |  |  | X |
RSP_DESC_TXT | VARCHAR | (200) |  | RSP_DESC_TXT |  |  |  |
FRC_ACTN | DECIMAL | (1) | 0 | FRC_ACTN |  |  |  |
ACTN_RQST_ANNOTN_TXT | VARCHAR | (2000) |  | ACTN_RQST_ANNOTN_TXT |  |  |  |
DLGN_TYP | CHAR | (1) |  | DLGN_TYP |  |  |  |
APPR_PLCY | CHAR | (1) |  | APPR_PLCY |  |  |  |
CUR_IND | DECIMAL | (1) | 1 | CUR_IND |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
GRP_ID | VARCHAR | (40) |  | GRP_ID |  |  |  |
RQST_LBL | VARCHAR | (255) |  | RQST_LBL |  |  |  |

## KREW_ACTN_TKN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ACTN_TKN_ID | DECIMAL | (14) |  | ACTN_TKN_ID | X |  |  |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  | X |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  | X |
DLGTR_PRNCPL_ID | VARCHAR | (40) |  | DLGTR_PRNCPL_ID |  |  |  |
ACTN_CD | CHAR | (1) |  | ACTN_CD |  |  | X |
ACTN_DT | DATE |  |  | ACTN_DT |  |  | X |
DOC_VER_NBR | DECIMAL | (8) |  | DOC_VER_NBR |  |  | X |
ANNOTN | VARCHAR | (2000) |  | ANNOTN |  |  |  |
CUR_IND | DECIMAL | (1) | 1 | CUR_IND |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
DLGTR_GRP_ID | VARCHAR | (40) |  | DLGTR_GRP_ID |  |  |  |

## KREW_APP_DOC_STAT_TRAN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
APP_DOC_STAT_TRAN_ID | DECIMAL | (19) |  | APP_DOC_STAT_TRAN_ID | X |  |  |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  |  |
APP_DOC_STAT_FROM | VARCHAR | (64) |  | APP_DOC_STAT_FROM |  |  |  |
APP_DOC_STAT_TO | VARCHAR | (64) |  | APP_DOC_STAT_TO |  |  |  |
STAT_TRANS_DATE | DATE |  |  | STAT_TRANS_DATE |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_ATT_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ATTACHMENT_ID | DECIMAL | (19) |  | ATTACHMENT_ID | X |  |  |
NTE_ID | DECIMAL | (19) |  | NTE_ID |  |  | X |
FILE_NM | VARCHAR | (255) |  | FILE_NM |  |  | X |
FILE_LOC | VARCHAR | (255) |  | FILE_LOC |  |  | X |
MIME_TYP | VARCHAR | (255) |  | MIME_TYP |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_DLGN_RSP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DLGN_RULE_ID | DECIMAL | (19) |  | DLGN_RULE_ID | X |  |  |
RSP_ID | DECIMAL | (19) |  | RSP_ID |  |  | X |
DLGN_RULE_BASE_VAL_ID | DECIMAL | (19) |  | DLGN_RULE_BASE_VAL_ID |  |  | X |
DLGN_TYP | VARCHAR | (20) |  | DLGN_TYP |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_DOC_HDR_CNTNT_T

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

## KREW_DOC_HDR_EXT_DT_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_EXT_DT_ID | DECIMAL | (19) |  | DOC_HDR_EXT_DT_ID | X |  |  |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  | X |
KEY_CD | VARCHAR | (256) |  | KEY_CD |  |  | X |
VAL | DATE |  |  | VAL |  |  |  |

## KREW_DOC_HDR_EXT_FLT_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_EXT_FLT_ID | DECIMAL | (19) |  | DOC_HDR_EXT_FLT_ID | X |  |  |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  | X |
KEY_CD | VARCHAR | (256) |  | KEY_CD |  |  | X |
VAL | DECIMAL | (30,15) |  | VAL |  |  |  |

## KREW_DOC_HDR_EXT_LONG_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_EXT_LONG_ID | DECIMAL | (19) |  | DOC_HDR_EXT_LONG_ID | X |  |  |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  | X |
KEY_CD | VARCHAR | (256) |  | KEY_CD |  |  | X |
VAL | DECIMAL | (22) |  | VAL |  |  |  |

## KREW_DOC_HDR_EXT_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_EXT_ID | DECIMAL | (19) |  | DOC_HDR_EXT_ID | X |  |  |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  | X |
KEY_CD | VARCHAR | (256) |  | KEY_CD |  |  | X |
VAL | VARCHAR | (2000) |  | VAL |  |  |  |

## KREW_DOC_HDR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID | X |  |  |
DOC_TYP_ID | DECIMAL | (19) |  | DOC_TYP_ID |  |  |  |
DOC_HDR_STAT_CD | CHAR | (1) |  | DOC_HDR_STAT_CD |  |  | X |
RTE_LVL | DECIMAL | (8) |  | RTE_LVL |  |  | X |
STAT_MDFN_DT | DATE |  |  | STAT_MDFN_DT |  |  | X |
CRTE_DT | DATE |  |  | CRTE_DT |  |  | X |
APRV_DT | DATE |  |  | APRV_DT |  |  |  |
FNL_DT | DATE |  |  | FNL_DT |  |  |  |
RTE_STAT_MDFN_DT | DATE |  |  | RTE_STAT_MDFN_DT |  |  |  |
RTE_LVL_MDFN_DT | DATE |  |  | RTE_LVL_MDFN_DT |  |  |  |
TTL | VARCHAR | (255) |  | TTL |  |  |  |
APP_DOC_ID | VARCHAR | (255) |  | APP_DOC_ID |  |  |  |
DOC_VER_NBR | DECIMAL | (8) |  | DOC_VER_NBR |  |  | X |
INITR_PRNCPL_ID | VARCHAR | (40) |  | INITR_PRNCPL_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
RTE_PRNCPL_ID | VARCHAR | (40) |  | RTE_PRNCPL_ID |  |  |  |
DTYPE | VARCHAR | (50) |  | DTYPE |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
APP_DOC_STAT | VARCHAR | (64) |  | APP_DOC_STAT |  |  |  |
APP_DOC_STAT_MDFN_DT | DATE |  |  | APP_DOC_STAT_MDFN_DT |  |  |  |

## KREW_DOC_LNK_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_LNK_ID | DECIMAL | (19) |  | DOC_LNK_ID | X |  |  |
ORGN_DOC_ID | DECIMAL | (14) |  | ORGN_DOC_ID |  |  | X |
DEST_DOC_ID | DECIMAL | (14) |  | DEST_DOC_ID |  |  | X |

## KREW_DOC_NTE_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_NTE_ID | DECIMAL | (19) |  | DOC_NTE_ID | X |  |  |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  | X |
AUTH_PRNCPL_ID | VARCHAR | (40) |  | AUTH_PRNCPL_ID |  |  | X |
CRT_DT | DATE |  |  | CRT_DT |  |  | X |
TXT | VARCHAR | (4000) |  | TXT |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_DOC_TYP_APP_DOC_STAT_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_TYP_ID | DECIMAL | (19) |  | DOC_TYP_ID | X |  |  |
DOC_STAT_NM | VARCHAR | (20) |  | DOC_STAT_NM | X |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_DOC_TYP_ATTR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_TYP_ATTRIB_ID | DECIMAL | (19) |  | DOC_TYP_ATTRIB_ID | X |  |  |
DOC_TYP_ID | DECIMAL | (19) |  | DOC_TYP_ID |  |  | X |
RULE_ATTR_ID | DECIMAL | (19) |  | RULE_ATTR_ID |  |  | X |
ORD_INDX | DECIMAL | (4) | 0 | ORD_INDX |  |  |  |

## KREW_DOC_TYP_PLCY_RELN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_TYP_ID | DECIMAL | (19) |  | DOC_TYP_ID | X |  |  |
DOC_PLCY_NM | VARCHAR | (255) |  | DOC_PLCY_NM | X |  |  |
PLCY_NM | DECIMAL | (1) |  | PLCY_NM |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
PLCY_VAL | VARCHAR | (64) |  | PLCY_VAL |  |  |  |
PLCY_DESC | VARCHAR | (20) |  | PLCY_DESC |  |  |  |

## KREW_DOC_TYP_PROC_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_TYP_PROC_ID | DECIMAL | (19) |  | DOC_TYP_PROC_ID | X |  |  |
DOC_TYP_ID | DECIMAL | (19) |  | DOC_TYP_ID |  |  | X |
INIT_RTE_NODE_ID | DECIMAL | (22) |  | INIT_RTE_NODE_ID |  |  |  |
NM | VARCHAR | (255) |  | NM |  |  | X |
INIT_IND | DECIMAL | (1) | 0 | INIT_IND |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_DOC_TYP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_TYP_ID | DECIMAL | (19) |  | DOC_TYP_ID | X |  |  |
PARNT_ID | DECIMAL | (19) |  | PARNT_ID |  |  |  |
DOC_TYP_NM | VARCHAR | (64) |  | DOC_TYP_NM |  |  |  |
DOC_TYP_VER_NBR | DECIMAL | (10) | 0 | DOC_TYP_VER_NBR |  |  |  |
ACTV_IND | DECIMAL | (1) |  | ACTV_IND |  |  |  |
CUR_IND | DECIMAL | (1) |  | CUR_IND |  |  |  |
LBL | VARCHAR | (128) |  | LBL |  |  |  |
PREV_DOC_TYP_VER_NBR | DECIMAL | (19) |  | PREV_DOC_TYP_VER_NBR |  |  |  |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  |  |
DOC_TYP_DESC | VARCHAR | (4000) |  | DOC_TYP_DESC |  |  |  |
DOC_HDLR_URL | VARCHAR | (255) |  | DOC_HDLR_URL |  |  |  |
POST_PRCSR | VARCHAR | (255) |  | POST_PRCSR |  |  |  |
JNDI_URL | VARCHAR | (255) |  | JNDI_URL |  |  |  |
BLNKT_APPR_PLCY | VARCHAR | (10) |  | BLNKT_APPR_PLCY |  |  |  |
ADV_DOC_SRCH_URL | VARCHAR | (255) |  | ADV_DOC_SRCH_URL |  |  |  |
CSTM_ACTN_LIST_ATTRIB_CLS_NM | VARCHAR | (255) |  | CSTM_ACTN_LIST_ATTRIB_CLS_NM |  |  |  |
CSTM_ACTN_EMAIL_ATTRIB_CLS_NM | VARCHAR | (255) |  | CSTM_ACTN_EMAIL_ATTRIB_CLS_NM |  |  |  |
CSTM_DOC_NTE_ATTRIB_CLS_NM | VARCHAR | (255) |  | CSTM_DOC_NTE_ATTRIB_CLS_NM |  |  |  |
RTE_VER_NBR | VARCHAR | (2) | 1 | RTE_VER_NBR |  |  |  |
NOTIFY_ADDR | VARCHAR | (255) |  | NOTIFY_ADDR |  |  |  |
SVC_NMSPC | VARCHAR | (255) |  | SVC_NMSPC |  |  |  |
EMAIL_XSL | VARCHAR | (255) |  | EMAIL_XSL |  |  |  |
SEC_XML | CLOB |  |  | SEC_XML |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
BLNKT_APPR_GRP_ID | VARCHAR | (40) |  | BLNKT_APPR_GRP_ID |  |  |  |
RPT_GRP_ID | VARCHAR | (40) |  | RPT_GRP_ID |  |  |  |
GRP_ID | VARCHAR | (40) |  | GRP_ID |  |  |  |
HELP_DEF_URL | VARCHAR | (4000) |  | HELP_DEF_URL |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
DOC_SEARCH_HELP_URL | VARCHAR | (4000) |  | DOC_SEARCH_HELP_URL |  |  |  |

## KREW_EDL_ASSCTN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
EDOCLT_ASSOC_ID | DECIMAL | (19) |  | EDOCLT_ASSOC_ID | X |  |  |
DOC_TYP_NM | VARCHAR | (64) |  | DOC_TYP_NM |  |  | X |
EDL_DEF_NM | VARCHAR | (200) |  | EDL_DEF_NM |  |  |  |
STYLE_NM | VARCHAR | (200) |  | STYLE_NM |  |  |  |
ACTV_IND | DECIMAL | (1) |  | ACTV_IND |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_EDL_DEF_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
EDOCLT_DEF_ID | DECIMAL | (19) |  | EDOCLT_DEF_ID | X |  |  |
NM | VARCHAR | (200) |  | NM |  |  | X |
XML | CLOB |  |  | XML |  |  | X |
ACTV_IND | DECIMAL | (1) |  | ACTV_IND |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_EDL_DMP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID | X |  |  |
DOC_TYP_NM | VARCHAR | (64) |  | DOC_TYP_NM |  |  | X |
DOC_HDR_STAT_CD | CHAR | (1) |  | DOC_HDR_STAT_CD |  |  | X |
DOC_HDR_MDFN_DT | DATE |  |  | DOC_HDR_MDFN_DT |  |  | X |
DOC_HDR_CRTE_DT | DATE |  |  | DOC_HDR_CRTE_DT |  |  | X |
DOC_HDR_TTL | VARCHAR | (255) |  | DOC_HDR_TTL |  |  |  |
DOC_HDR_INITR_PRNCPL_ID | VARCHAR | (40) |  | DOC_HDR_INITR_PRNCPL_ID |  |  | X |
CRNT_NODE_NM | VARCHAR | (30) |  | CRNT_NODE_NM |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_EDL_FLD_DMP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
EDL_FIELD_DMP_ID | DECIMAL | (14) |  | EDL_FIELD_DMP_ID | X |  |  |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  | X |
FLD_NM | VARCHAR | (255) |  | FLD_NM |  |  | X |
FLD_VAL | VARCHAR | (4000) |  | FLD_VAL |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_HLP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
HLP_ID | DECIMAL | (19) |  | HLP_ID | X |  |  |
NM | VARCHAR | (500) |  | NM |  |  | X |
KEY_CD | VARCHAR | (500) |  | KEY_CD |  |  | X |
HLP_TXT | VARCHAR | (4000) |  | HLP_TXT |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_INIT_RTE_NODE_INSTN_T

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

## KREW_OUT_BOX_ITM_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ACTN_ITM_ID | DECIMAL | (14) |  | ACTN_ITM_ID | X |  |  |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  | X |
ASND_DT | DATE |  |  | ASND_DT |  |  | X |
RQST_CD | CHAR | (1) |  | RQST_CD |  |  | X |
ACTN_RQST_ID | DECIMAL | (14) |  | ACTN_RQST_ID |  |  | X |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  | X |
ROLE_NM | VARCHAR | (2000) |  | ROLE_NM |  |  |  |
DLGN_PRNCPL_ID | VARCHAR | (40) |  | DLGN_PRNCPL_ID |  |  |  |
DOC_HDR_TTL | VARCHAR | (255) |  | DOC_HDR_TTL |  |  |  |
DOC_TYP_LBL | VARCHAR | (128) |  | DOC_TYP_LBL |  |  | X |
DOC_HDLR_URL | VARCHAR | (255) |  | DOC_HDLR_URL |  |  | X |
DOC_TYP_NM | VARCHAR | (64) |  | DOC_TYP_NM |  |  | X |
RSP_ID | DECIMAL | (14) |  | RSP_ID |  |  | X |
DLGN_TYP | VARCHAR | (1) |  | DLGN_TYP |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
GRP_ID | VARCHAR | (40) |  | GRP_ID |  |  |  |
DLGN_GRP_ID | VARCHAR | (40) |  | DLGN_GRP_ID |  |  |  |
RQST_LBL | VARCHAR | (255) |  | RQST_LBL |  |  |  |

## KREW_RMV_RPLC_DOC_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID | X |  |  |
OPRN | CHAR | (1) |  | OPRN |  |  | X |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  | X |
RPLC_PRNCPL_ID | VARCHAR | (40) |  | RPLC_PRNCPL_ID |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_RMV_RPLC_GRP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID | X |  |  |
GRP_ID | DECIMAL | (14) |  | GRP_ID | X |  |  |

## KREW_RMV_RPLC_RULE_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID | X |  |  |
RULE_ID | DECIMAL | (19) |  | RULE_ID | X |  |  |

## KREW_RTE_BRCH_PROTO_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RTE_BRCH_PROTO_ID | DECIMAL | (19) |  | RTE_BRCH_PROTO_ID | X |  |  |
BRCH_NM | VARCHAR | (255) |  | BRCH_NM |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_RTE_BRCH_ST_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RTE_BRCH_ST_ID | DECIMAL | (19) |  | RTE_BRCH_ST_ID | X |  |  |
RTE_BRCH_ID | DECIMAL | (19) |  | RTE_BRCH_ID |  |  | X |
KEY_CD | VARCHAR | (255) |  | KEY_CD |  |  | X |
VAL | VARCHAR | (2000) |  | VAL |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_RTE_BRCH_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RTE_BRCH_ID | DECIMAL | (19) |  | RTE_BRCH_ID | X |  |  |
NM | VARCHAR | (255) |  | NM |  |  | X |
PARNT_ID | DECIMAL | (19) |  | PARNT_ID |  |  |  |
INIT_RTE_NODE_INSTN_ID | DECIMAL | (19) |  | INIT_RTE_NODE_INSTN_ID |  |  |  |
SPLT_RTE_NODE_INSTN_ID | DECIMAL | (19) |  | SPLT_RTE_NODE_INSTN_ID |  |  |  |
JOIN_RTE_NODE_INSTN_ID | DECIMAL | (19) |  | JOIN_RTE_NODE_INSTN_ID |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_RTE_NODE_CFG_PARM_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RTE_NODE_CFG_PARM_ID | DECIMAL | (19) |  | RTE_NODE_CFG_PARM_ID | X |  |  |
RTE_NODE_ID | DECIMAL | (19) |  | RTE_NODE_ID |  | X | X |
KEY_CD | VARCHAR | (255) |  | KEY_CD |  |  | X |
VAL | VARCHAR | (4000) |  | VAL |  |  |  |

## KREW_RTE_NODE_INSTN_LNK_T

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

## KREW_RTE_NODE_INSTN_ST_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RTE_NODE_INSTN_ST_ID | DECIMAL | (19) |  | RTE_NODE_INSTN_ST_ID | X |  |  |
RTE_NODE_INSTN_ID | DECIMAL | (19) |  | RTE_NODE_INSTN_ID |  |  | X |
KEY_CD | VARCHAR | (255) |  | KEY_CD |  |  | X |
VAL | VARCHAR | (2000) |  | VAL |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_RTE_NODE_INSTN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RTE_NODE_INSTN_ID | DECIMAL | (19) |  | RTE_NODE_INSTN_ID | X |  |  |
DOC_HDR_ID | DECIMAL | (19) |  | DOC_HDR_ID |  |  | X |
RTE_NODE_ID | DECIMAL | (19) |  | RTE_NODE_ID |  |  | X |
BRCH_ID | DECIMAL | (19) |  | BRCH_ID |  |  |  |
PROC_RTE_NODE_INSTN_ID | DECIMAL | (19) |  | PROC_RTE_NODE_INSTN_ID |  |  |  |
ACTV_IND | DECIMAL | (1) | 0 | ACTV_IND |  |  | X |
CMPLT_IND | DECIMAL | (1) | 0 | CMPLT_IND |  |  | X |
INIT_IND | DECIMAL | (1) | 0 | INIT_IND |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_RTE_NODE_LNK_T

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

## KREW_RTE_NODE_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RTE_NODE_ID | DECIMAL | (19) |  | RTE_NODE_ID | X |  |  |
DOC_TYP_ID | DECIMAL | (19) |  | DOC_TYP_ID |  |  |  |
NM | VARCHAR | (255) |  | NM |  |  | X |
TYP | VARCHAR | (255) |  | TYP |  |  | X |
RTE_MTHD_NM | VARCHAR | (255) |  | RTE_MTHD_NM |  |  |  |
RTE_MTHD_CD | VARCHAR | (2) |  | RTE_MTHD_CD |  |  |  |
FNL_APRVR_IND | DECIMAL | (1) |  | FNL_APRVR_IND |  |  |  |
MNDTRY_RTE_IND | DECIMAL | (1) |  | MNDTRY_RTE_IND |  |  |  |
ACTVN_TYP | VARCHAR | (250) |  | ACTVN_TYP |  |  |  |
BRCH_PROTO_ID | DECIMAL | (19) |  | BRCH_PROTO_ID |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
CONTENT_FRAGMENT | VARCHAR | (4000) |  | CONTENT_FRAGMENT |  |  |  |
GRP_ID | VARCHAR | (40) |  | GRP_ID |  |  |  |
NEXT_DOC_STAT | VARCHAR | (64) |  | NEXT_DOC_STAT |  |  |  |

## KREW_RULE_ATTR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RULE_ATTR_ID | DECIMAL | (19) |  | RULE_ATTR_ID | X |  |  |
NM | VARCHAR | (255) |  | NM |  |  | X |
LBL | VARCHAR | (2000) |  | LBL |  |  | X |
RULE_ATTR_TYP_CD | VARCHAR | (2000) |  | RULE_ATTR_TYP_CD |  |  | X |
DESC_TXT | VARCHAR | (2000) |  | DESC_TXT |  |  |  |
CLS_NM | VARCHAR | (2000) |  | CLS_NM |  |  |  |
XML | CLOB |  |  | XML |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
SVC_NMSPC | VARCHAR | (255) |  | SVC_NMSPC |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_RULE_EXPR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RULE_EXPR_ID | DECIMAL | (19) |  | RULE_EXPR_ID | X |  |  |
TYP | VARCHAR | (256) |  | TYP |  |  | X |
RULE_EXPR | VARCHAR | (4000) |  | RULE_EXPR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_RULE_EXT_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RULE_EXT_ID | DECIMAL | (19) |  | RULE_EXT_ID | X |  |  |
RULE_TMPL_ATTR_ID | DECIMAL | (19) |  | RULE_TMPL_ATTR_ID |  |  | X |
RULE_ID | DECIMAL | (19) |  | RULE_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_RULE_EXT_VAL_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RULE_EXT_VAL_ID | DECIMAL | (19) |  | RULE_EXT_VAL_ID | X |  |  |
RULE_EXT_ID | DECIMAL | (19) |  | RULE_EXT_ID |  |  | X |
VAL | VARCHAR | (2000) |  | VAL |  |  | X |
KEY_CD | VARCHAR | (2000) |  | KEY_CD |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_RULE_RSP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RULE_RSP_ID | DECIMAL | (19) |  | RULE_RSP_ID | X |  |  |
RSP_ID | DECIMAL | (19) |  | RSP_ID |  |  | X |
RULE_ID | DECIMAL | (19) |  | RULE_ID |  |  | X |
PRIO | DECIMAL | (5) |  | PRIO |  |  |  |
ACTN_RQST_CD | VARCHAR | (2000) |  | ACTN_RQST_CD |  |  |  |
NM | VARCHAR | (200) |  | NM |  |  |  |
TYP | VARCHAR | (1) |  | TYP |  |  |  |
APPR_PLCY | CHAR | (1) |  | APPR_PLCY |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_RULE_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RULE_ID | DECIMAL | (19) |  | RULE_ID | X |  |  |
NM | VARCHAR | (256) |  | NM |  |  |  |
RULE_TMPL_ID | DECIMAL | (19) |  | RULE_TMPL_ID |  |  |  |
RULE_EXPR_ID | DECIMAL | (19) |  | RULE_EXPR_ID |  | X |  |
ACTV_IND | DECIMAL | (1) |  | ACTV_IND |  |  | X |
RULE_BASE_VAL_DESC | VARCHAR | (2000) |  | RULE_BASE_VAL_DESC |  |  |  |
FRC_ACTN | DECIMAL | (1) |  | FRC_ACTN |  |  | X |
DOC_TYP_NM | VARCHAR | (64) |  | DOC_TYP_NM |  |  | X |
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID |  |  |  |
TMPL_RULE_IND | DECIMAL | (1) |  | TMPL_RULE_IND |  |  |  |
FRM_DT | DATE |  |  | FRM_DT |  |  |  |
TO_DT | DATE |  |  | TO_DT |  |  |  |
DACTVN_DT | DATE |  |  | DACTVN_DT |  |  |  |
CUR_IND | DECIMAL | (1) | 0 | CUR_IND |  |  |  |
RULE_VER_NBR | DECIMAL | (8) | 0 | RULE_VER_NBR |  |  |  |
DLGN_IND | DECIMAL | (1) |  | DLGN_IND |  |  |  |
PREV_RULE_VER_NBR | DECIMAL | (19) |  | PREV_RULE_VER_NBR |  |  |  |
ACTVN_DT | DATE |  |  | ACTVN_DT |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_RULE_TMPL_ATTR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RULE_TMPL_ATTR_ID | DECIMAL | (19) |  | RULE_TMPL_ATTR_ID | X |  |  |
RULE_TMPL_ID | DECIMAL | (19) |  | RULE_TMPL_ID |  |  | X |
RULE_ATTR_ID | DECIMAL | (19) |  | RULE_ATTR_ID |  |  | X |
REQ_IND | DECIMAL | (1) |  | REQ_IND |  |  | X |
ACTV_IND | DECIMAL | (1) |  | ACTV_IND |  |  | X |
DSPL_ORD | DECIMAL | (5) |  | DSPL_ORD |  |  | X |
DFLT_VAL | VARCHAR | (2000) |  | DFLT_VAL |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_RULE_TMPL_OPTN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RULE_TMPL_OPTN_ID | DECIMAL | (19) |  | RULE_TMPL_OPTN_ID | X |  |  |
RULE_TMPL_ID | DECIMAL | (19) |  | RULE_TMPL_ID |  |  |  |
KEY_CD | VARCHAR | (250) |  | KEY_CD |  |  |  |
VAL | VARCHAR | (2000) |  | VAL |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KREW_RULE_TMPL_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RULE_TMPL_ID | DECIMAL | (19) |  | RULE_TMPL_ID | X |  |  |
NM | VARCHAR | (250) |  | NM |  |  | X |
RULE_TMPL_DESC | VARCHAR | (2000) |  | RULE_TMPL_DESC |  |  |  |
DLGN_RULE_TMPL_ID | DECIMAL | (19) |  | DLGN_RULE_TMPL_ID |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_STYLE_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
STYLE_ID | DECIMAL | (19) |  | STYLE_ID | X |  |  |
NM | VARCHAR | (200) |  | NM |  |  | X |
XML | CLOB |  |  | XML |  |  | X |
ACTV_IND | DECIMAL | (1) |  | ACTV_IND |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KREW_USR_OPTN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID | X |  |  |
PRSN_OPTN_ID | VARCHAR | (200) |  | PRSN_OPTN_ID | X |  |  |
VAL | VARCHAR | (2000) |  | VAL |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KRIM_ADDR_TYP_T

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

## KRIM_AFLTN_TYP_T

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

## KRIM_ATTR_DEFN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
KIM_ATTR_DEFN_ID | VARCHAR | (40) |  | KIM_ATTR_DEFN_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
NM | VARCHAR | (100) |  | NM |  |  |  |
LBL | VARCHAR | (40) |  | LBL |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
NMSPC_CD | VARCHAR | (40) |  | NMSPC_CD |  |  |  |
CMPNT_NM | VARCHAR | (100) |  | CMPNT_NM |  |  |  |

## KRIM_CTZNSHP_STAT_T

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

## KRIM_DLGN_MBR_ATTR_DATA_T

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

## KRIM_DLGN_MBR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DLGN_MBR_ID | VARCHAR | (40) |  | DLGN_MBR_ID | X |  |  |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
DLGN_ID | VARCHAR | (40) |  | DLGN_ID |  | X |  |
MBR_ID | VARCHAR | (40) |  | MBR_ID |  |  |  |
MBR_TYP_CD | CHAR | (1) | P | MBR_TYP_CD |  |  |  |
ACTV_FRM_DT | DATE |  |  | ACTV_FRM_DT |  |  |  |
ACTV_TO_DT | DATE |  |  | ACTV_TO_DT |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |
ROLE_MBR_ID | VARCHAR | (40) |  | ROLE_MBR_ID |  |  |  |

## KRIM_DLGN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DLGN_ID | VARCHAR | (40) |  | DLGN_ID | X |  |  |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
ROLE_ID | VARCHAR | (40) |  | ROLE_ID |  | X |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
KIM_TYP_ID | VARCHAR | (40) |  | KIM_TYP_ID |  | X | X |
DLGN_TYP_CD | VARCHAR | (1) |  | DLGN_TYP_CD |  |  |  |

## KRIM_EMAIL_TYP_T

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

## KRIM_EMP_STAT_T

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

## KRIM_EMP_TYP_T

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

## KRIM_ENTITY_ADDR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_ADDR_ID | VARCHAR | (40) |  | ENTITY_ADDR_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
ENT_TYP_CD | VARCHAR | (40) |  | ENT_TYP_CD |  | X |  |
ADDR_TYP_CD | VARCHAR | (40) |  | ADDR_TYP_CD |  | X |  |
ADDR_LINE_1 | VARCHAR | (45) |  | ADDR_LINE_1 |  |  |  |
ADDR_LINE_2 | VARCHAR | (45) |  | ADDR_LINE_2 |  |  |  |
ADDR_LINE_3 | VARCHAR | (45) |  | ADDR_LINE_3 |  |  |  |
CITY_NM | VARCHAR | (30) |  | CITY_NM |  |  |  |
POSTAL_STATE_CD | VARCHAR | (2) |  | POSTAL_STATE_CD |  |  |  |
POSTAL_CD | VARCHAR | (20) |  | POSTAL_CD |  |  |  |
POSTAL_CNTRY_CD | VARCHAR | (2) |  | POSTAL_CNTRY_CD |  |  |  |
DFLT_IND | VARCHAR | (1) | N | DFLT_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_ENTITY_AFLTN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_AFLTN_ID | VARCHAR | (40) |  | ENTITY_AFLTN_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
AFLTN_TYP_CD | VARCHAR | (40) |  | AFLTN_TYP_CD |  | X |  |
CAMPUS_CD | VARCHAR | (2) |  | CAMPUS_CD |  |  |  |
DFLT_IND | VARCHAR | (1) | N | DFLT_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_ENTITY_BIO_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
BIRTH_DT | DATE |  |  | BIRTH_DT |  |  |  |
GNDR_CD | VARCHAR | (1) |  | GNDR_CD |  |  | X |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |
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

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID | X |  |  |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  | X |
PRNCPL_NM | VARCHAR | (40) |  | PRNCPL_NM |  |  |  |
ENTITY_TYP_CD | VARCHAR | (40) |  | ENTITY_TYP_CD |  |  |  |
FIRST_NM | VARCHAR | (40) |  | FIRST_NM |  |  |  |
MIDDLE_NM | VARCHAR | (40) |  | MIDDLE_NM |  |  |  |
LAST_NM | VARCHAR | (40) |  | LAST_NM |  |  |  |
PRSN_NM | VARCHAR | (40) |  | PRSN_NM |  |  |  |
CAMPUS_CD | VARCHAR | (40) |  | CAMPUS_CD |  |  |  |
PRMRY_DEPT_CD | VARCHAR | (40) |  | PRMRY_DEPT_CD |  |  |  |
EMP_ID | VARCHAR | (40) |  | EMP_ID |  |  |  |
LAST_UPDT_TS | DATE |  |  | LAST_UPDT_TS |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KRIM_ENTITY_CTZNSHP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_CTZNSHP_ID | VARCHAR | (40) |  | ENTITY_CTZNSHP_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
POSTAL_CNTRY_CD | VARCHAR | (2) |  | POSTAL_CNTRY_CD |  |  |  |
CTZNSHP_STAT_CD | VARCHAR | (40) |  | CTZNSHP_STAT_CD |  | X |  |
STRT_DT | DATE |  |  | STRT_DT |  |  |  |
END_DT | DATE |  |  | END_DT |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_ENTITY_EMAIL_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_EMAIL_ID | VARCHAR | (40) |  | ENTITY_EMAIL_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
ENT_TYP_CD | VARCHAR | (40) |  | ENT_TYP_CD |  | X |  |
EMAIL_TYP_CD | VARCHAR | (40) |  | EMAIL_TYP_CD |  |  |  |
EMAIL_ADDR | VARCHAR | (200) |  | EMAIL_ADDR |  |  |  |
DFLT_IND | VARCHAR | (1) | N | DFLT_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_ENTITY_EMP_INFO_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_EMP_ID | VARCHAR | (40) |  | ENTITY_EMP_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
ENTITY_AFLTN_ID | VARCHAR | (40) |  | ENTITY_AFLTN_ID |  | X |  |
EMP_STAT_CD | VARCHAR | (40) |  | EMP_STAT_CD |  | X |  |
EMP_TYP_CD | VARCHAR | (40) |  | EMP_TYP_CD |  | X |  |
BASE_SLRY_AMT | DECIMAL | (15,2) |  | BASE_SLRY_AMT |  |  |  |
PRMRY_IND | VARCHAR | (1) |  | PRMRY_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |
PRMRY_DEPT_CD | VARCHAR | (40) |  | PRMRY_DEPT_CD |  |  |  |
EMP_ID | VARCHAR | (40) |  | EMP_ID |  |  |  |
EMP_REC_ID | VARCHAR | (40) |  | EMP_REC_ID |  |  |  |

## KRIM_ENTITY_ENT_TYP_T

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

## KRIM_ENTITY_ETHNIC_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ID | VARCHAR | (40) |  | ID | X |  |  |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
ETHNCTY_CD | VARCHAR | (40) |  | ETHNCTY_CD |  |  |  |
SUB_ETHNCTY_CD | VARCHAR | (40) |  | SUB_ETHNCTY_CD |  |  |  |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KRIM_ENTITY_EXT_ID_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_EXT_ID_ID | VARCHAR | (40) |  | ENTITY_EXT_ID_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
EXT_ID_TYP_CD | VARCHAR | (40) |  | EXT_ID_TYP_CD |  | X |  |
EXT_ID | VARCHAR | (100) |  | EXT_ID |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_ENTITY_NM_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_NM_ID | VARCHAR | (40) |  | ENTITY_NM_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
NM_TYP_CD | VARCHAR | (40) |  | NM_TYP_CD |  |  |  |
FIRST_NM | VARCHAR | (40) |  | FIRST_NM |  |  |  |
MIDDLE_NM | VARCHAR | (40) |  | MIDDLE_NM |  |  |  |
LAST_NM | VARCHAR | (80) |  | LAST_NM |  |  |  |
SUFFIX_NM | VARCHAR | (20) |  | SUFFIX_NM |  |  |  |
TITLE_NM | VARCHAR | (20) |  | TITLE_NM |  |  |  |
DFLT_IND | VARCHAR | (1) | N | DFLT_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_ENTITY_PHONE_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_PHONE_ID | VARCHAR | (40) |  | ENTITY_PHONE_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
ENT_TYP_CD | VARCHAR | (40) |  | ENT_TYP_CD |  | X |  |
PHONE_TYP_CD | VARCHAR | (40) |  | PHONE_TYP_CD |  | X |  |
PHONE_NBR | VARCHAR | (20) |  | PHONE_NBR |  |  |  |
PHONE_EXTN_NBR | VARCHAR | (8) |  | PHONE_EXTN_NBR |  |  |  |
POSTAL_CNTRY_CD | VARCHAR | (2) |  | POSTAL_CNTRY_CD |  |  |  |
DFLT_IND | VARCHAR | (1) | N | DFLT_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_ENTITY_PRIV_PREF_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
SUPPRESS_NM_IND | VARCHAR | (1) | N | SUPPRESS_NM_IND |  |  |  |
SUPPRESS_EMAIL_IND | VARCHAR | (1) | Y | SUPPRESS_EMAIL_IND |  |  |  |
SUPPRESS_ADDR_IND | VARCHAR | (1) | Y | SUPPRESS_ADDR_IND |  |  |  |
SUPPRESS_PHONE_IND | VARCHAR | (1) | Y | SUPPRESS_PHONE_IND |  |  |  |
SUPPRESS_PRSNL_IND | VARCHAR | (1) | Y | SUPPRESS_PRSNL_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_ENTITY_RESIDENCY_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ID | VARCHAR | (40) |  | ID | X |  |  |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
DETERMINATION_METHOD | VARCHAR | (40) |  | DETERMINATION_METHOD |  |  |  |
IN_STATE | VARCHAR | (40) |  | IN_STATE |  |  |  |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KRIM_ENTITY_T

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

## KRIM_ENTITY_VISA_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ID | VARCHAR | (40) |  | ID | X |  |  |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
VISA_TYPE_KEY | VARCHAR | (40) |  | VISA_TYPE_KEY |  |  |  |
VISA_ENTRY | VARCHAR | (40) |  | VISA_ENTRY |  |  |  |
VISA_ID | VARCHAR | (40) |  | VISA_ID |  |  |  |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |

## KRIM_ENT_NM_TYP_T

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

## KRIM_ENT_TYP_T

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

## KRIM_EXT_ID_TYP_T

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

## KRIM_GRP_ATTR_DATA_T

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

## KRIM_GRP_DOCUMENT_T

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

## KRIM_GRP_MBR_T

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

## KRIM_GRP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
GRP_ID | VARCHAR | (40) |  | GRP_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
GRP_NM | VARCHAR | (80) |  | GRP_NM |  |  | X |
NMSPC_CD | VARCHAR | (40) |  | NMSPC_CD |  |  | X |
GRP_DESC | VARCHAR | (4000) |  | GRP_DESC |  |  |  |
KIM_TYP_ID | VARCHAR | (40) |  | KIM_TYP_ID |  | X | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_PERM_ATTR_DATA_T

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

## KRIM_PERM_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PERM_ID | VARCHAR | (40) |  | PERM_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
PERM_TMPL_ID | VARCHAR | (40) |  | PERM_TMPL_ID |  | X |  |
NMSPC_CD | VARCHAR | (40) |  | NMSPC_CD |  |  |  |
NM | VARCHAR | (100) |  | NM |  |  |  |
DESC_TXT | VARCHAR | (400) |  | DESC_TXT |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |

## KRIM_PERM_TMPL_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PERM_TMPL_ID | VARCHAR | (40) |  | PERM_TMPL_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
NMSPC_CD | VARCHAR | (40) |  | NMSPC_CD |  |  |  |
NM | VARCHAR | (100) |  | NM |  |  |  |
DESC_TXT | VARCHAR | (400) |  | DESC_TXT |  |  |  |
KIM_TYP_ID | VARCHAR | (40) |  | KIM_TYP_ID |  | X | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |

## KRIM_PERSON_DOCUMENT_T

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

## KRIM_PHONE_TYP_T

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

## KRIM_PND_ADDR_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
ADDR_TYP_CD | VARCHAR | (40) |  | ADDR_TYP_CD |  |  |  |
ADDR_LINE_1 | VARCHAR | (50) |  | ADDR_LINE_1 |  |  |  |
ADDR_LINE_2 | VARCHAR | (50) |  | ADDR_LINE_2 |  |  |  |
ADDR_LINE_3 | VARCHAR | (50) |  | ADDR_LINE_3 |  |  |  |
CITY_NM | VARCHAR | (30) |  | CITY_NM |  |  |  |
POSTAL_STATE_CD | VARCHAR | (2) |  | POSTAL_STATE_CD |  |  |  |
POSTAL_CD | VARCHAR | (20) |  | POSTAL_CD |  |  |  |
POSTAL_CNTRY_CD | VARCHAR | (2) |  | POSTAL_CNTRY_CD |  |  |  |
DISPLAY_SORT_CD | VARCHAR | (2) |  | DISPLAY_SORT_CD |  |  |  |
DFLT_IND | VARCHAR | (1) | N | DFLT_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
ENTITY_ADDR_ID | VARCHAR | (40) |  | ENTITY_ADDR_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |

## KRIM_PND_AFLTN_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X | X |  |
ENTITY_AFLTN_ID | VARCHAR | (40) |  | ENTITY_AFLTN_ID | X |  |  |
AFLTN_TYP_CD | VARCHAR | (40) |  | AFLTN_TYP_CD |  |  |  |
CAMPUS_CD | VARCHAR | (2) |  | CAMPUS_CD |  |  |  |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |
DFLT_IND | VARCHAR | (1) | N | DFLT_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |

## KRIM_PND_CTZNSHP_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
ENTITY_CTZNSHP_ID | VARCHAR | (40) |  | ENTITY_CTZNSHP_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
POSTAL_CNTRY_CD | VARCHAR | (2) |  | POSTAL_CNTRY_CD |  |  |  |
CTZNSHP_STAT_CD | VARCHAR | (40) |  | CTZNSHP_STAT_CD |  |  |  |
STRT_DT | DATE |  |  | STRT_DT |  |  |  |
END_DT | DATE |  |  | END_DT |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |

## KRIM_PND_DLGN_MBR_ATTR_DATA_T

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

## KRIM_PND_DLGN_MBR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
DLGN_MBR_ID | VARCHAR | (40) |  | DLGN_MBR_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
DLGN_ID | VARCHAR | (40) |  | DLGN_ID |  |  | X |
MBR_ID | VARCHAR | (40) |  | MBR_ID |  |  |  |
MBR_NM | VARCHAR | (40) |  | MBR_NM |  |  |  |
MBR_TYP_CD | VARCHAR | (40) |  | MBR_TYP_CD |  |  | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
ACTV_FRM_DT | DATE |  |  | ACTV_FRM_DT |  |  |  |
ACTV_TO_DT | DATE |  |  | ACTV_TO_DT |  |  |  |
ROLE_MBR_ID | VARCHAR | (40) |  | ROLE_MBR_ID |  |  |  |

## KRIM_PND_DLGN_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
DLGN_ID | VARCHAR | (40) |  | DLGN_ID | X |  |  |
ROLE_ID | VARCHAR | (40) |  | ROLE_ID |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
KIM_TYP_ID | VARCHAR | (40) |  | KIM_TYP_ID |  |  |  |
DLGN_TYP_CD | VARCHAR | (100) |  | DLGN_TYP_CD |  |  | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |

## KRIM_PND_EMAIL_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
ENTITY_EMAIL_ID | VARCHAR | (40) |  | ENTITY_EMAIL_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENT_TYP_CD | VARCHAR | (40) |  | ENT_TYP_CD |  |  |  |
EMAIL_TYP_CD | VARCHAR | (40) |  | EMAIL_TYP_CD |  |  |  |
EMAIL_ADDR | VARCHAR | (200) |  | EMAIL_ADDR |  |  |  |
DFLT_IND | VARCHAR | (1) | N | DFLT_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |

## KRIM_PND_EMP_INFO_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
PRMRY_DEPT_CD | VARCHAR | (40) |  | PRMRY_DEPT_CD |  |  |  |
ENTITY_EMP_ID | VARCHAR | (40) |  | ENTITY_EMP_ID | X |  |  |
EMP_ID | VARCHAR | (40) |  | EMP_ID |  |  |  |
EMP_REC_ID | VARCHAR | (40) |  | EMP_REC_ID |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENTITY_AFLTN_ID | VARCHAR | (40) |  | ENTITY_AFLTN_ID |  |  |  |
EMP_STAT_CD | VARCHAR | (40) |  | EMP_STAT_CD |  |  |  |
EMP_TYP_CD | VARCHAR | (40) |  | EMP_TYP_CD |  |  |  |
BASE_SLRY_AMT | DECIMAL | (15,2) |  | BASE_SLRY_AMT |  |  |  |
PRMRY_IND | VARCHAR | (1) |  | PRMRY_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |

## KRIM_PND_GRP_ATTR_DATA_T

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

## KRIM_PND_GRP_MBR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
GRP_MBR_ID | VARCHAR | (40) |  | GRP_MBR_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
GRP_ID | VARCHAR | (40) |  | GRP_ID |  |  | X |
MBR_ID | VARCHAR | (40) |  | MBR_ID |  |  |  |
MBR_NM | VARCHAR | (40) |  | MBR_NM |  |  |  |
MBR_TYP_CD | VARCHAR | (40) |  | MBR_TYP_CD |  |  | X |
ACTV_FRM_DT | DATE |  |  | ACTV_FRM_DT |  |  |  |
ACTV_TO_DT | DATE |  |  | ACTV_TO_DT |  |  |  |

## KRIM_PND_GRP_PRNCPL_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
GRP_MBR_ID | VARCHAR | (40) |  | GRP_MBR_ID | X |  |  |
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
GRP_ID | VARCHAR | (40) |  | GRP_ID |  |  | X |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
GRP_NM | VARCHAR | (80) |  | GRP_NM |  |  | X |
GRP_TYPE | VARCHAR | (80) |  | GRP_TYPE |  |  |  |
KIM_TYP_ID | VARCHAR | (40) |  | KIM_TYP_ID |  |  |  |
NMSPC_CD | VARCHAR | (40) |  | NMSPC_CD |  |  |  |
ACTV_FRM_DT | DATE |  |  | ACTV_FRM_DT |  |  |  |
ACTV_TO_DT | DATE |  |  | ACTV_TO_DT |  |  |  |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |

## KRIM_PND_NM_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
ENTITY_NM_ID | VARCHAR | (40) |  | ENTITY_NM_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
NM_TYP_CD | VARCHAR | (40) |  | NM_TYP_CD |  |  |  |
FIRST_NM | VARCHAR | (40) |  | FIRST_NM |  |  |  |
MIDDLE_NM | VARCHAR | (40) |  | MIDDLE_NM |  |  |  |
LAST_NM | VARCHAR | (80) |  | LAST_NM |  |  |  |
SUFFIX_NM | VARCHAR | (20) |  | SUFFIX_NM |  |  |  |
TITLE_NM | VARCHAR | (20) |  | TITLE_NM |  |  |  |
DFLT_IND | VARCHAR | (1) | N | DFLT_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |

## KRIM_PND_PHONE_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
ENTITY_PHONE_ID | VARCHAR | (40) |  | ENTITY_PHONE_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ENT_TYP_CD | VARCHAR | (40) |  | ENT_TYP_CD |  |  |  |
PHONE_TYP_CD | VARCHAR | (40) |  | PHONE_TYP_CD |  |  |  |
PHONE_NBR | VARCHAR | (20) |  | PHONE_NBR |  |  |  |
PHONE_EXTN_NBR | VARCHAR | (8) |  | PHONE_EXTN_NBR |  |  |  |
POSTAL_CNTRY_CD | VARCHAR | (2) |  | POSTAL_CNTRY_CD |  |  |  |
DFLT_IND | VARCHAR | (1) | N | DFLT_IND |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |

## KRIM_PND_PRIV_PREF_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
SUPPRESS_NM_IND | VARCHAR | (1) | N | SUPPRESS_NM_IND |  |  |  |
SUPPRESS_EMAIL_IND | VARCHAR | (1) | Y | SUPPRESS_EMAIL_IND |  |  |  |
SUPPRESS_ADDR_IND | VARCHAR | (1) | Y | SUPPRESS_ADDR_IND |  |  |  |
SUPPRESS_PHONE_IND | VARCHAR | (1) | Y | SUPPRESS_PHONE_IND |  |  |  |
SUPPRESS_PRSNL_IND | VARCHAR | (1) | Y | SUPPRESS_PRSNL_IND |  |  |  |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |

## KRIM_PND_ROLE_MBR_ATTR_DATA_MT

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

## KRIM_PND_ROLE_MBR_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
ROLE_MBR_ID | VARCHAR | (40) |  | ROLE_MBR_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ROLE_ID | VARCHAR | (40) |  | ROLE_ID |  |  | X |
MBR_ID | VARCHAR | (40) |  | MBR_ID |  |  |  |
MBR_TYP_CD | VARCHAR | (40) |  | MBR_TYP_CD |  |  | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
ACTV_FRM_DT | DATE |  |  | ACTV_FRM_DT |  |  |  |
ACTV_TO_DT | DATE |  |  | ACTV_TO_DT |  |  |  |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |

## KRIM_PND_ROLE_MT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
ROLE_ID | VARCHAR | (40) |  | ROLE_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ROLE_NM | VARCHAR | (100) |  | ROLE_NM |  |  | X |
KIM_TYP_ID | VARCHAR | (40) |  | KIM_TYP_ID |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
NMSPC_CD | VARCHAR | (40) |  | NMSPC_CD |  |  |  |
EDIT_FLAG | VARCHAR | (1) | N | EDIT_FLAG |  |  |  |

## KRIM_PND_ROLE_PERM_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
ROLE_PERM_ID | VARCHAR | (40) |  | ROLE_PERM_ID | X |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ROLE_ID | VARCHAR | (40) |  | ROLE_ID |  |  | X |
PERM_ID | VARCHAR | (40) |  | PERM_ID |  |  | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |

## KRIM_PND_ROLE_RSP_ACTN_MT

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

## KRIM_PND_ROLE_RSP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
ROLE_RSP_ID | VARCHAR | (40) |  | ROLE_RSP_ID | X |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ROLE_ID | VARCHAR | (40) |  | ROLE_ID |  |  | X |
RSP_ID | VARCHAR | (40) |  | RSP_ID |  |  | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |

## KRIM_PRNCPL_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
PRNCPL_NM | VARCHAR | (100) |  | PRNCPL_NM |  |  | X |
ENTITY_ID | VARCHAR | (40) |  | ENTITY_ID |  | X |  |
PRNCPL_PSWD | VARCHAR | (400) |  | PRNCPL_PSWD |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_ROLE_DOCUMENT_T

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

## KRIM_ROLE_MBR_ATTR_DATA_T

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

## KRIM_ROLE_MBR_T

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

## KRIM_ROLE_PERM_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ROLE_PERM_ID | VARCHAR | (40) |  | ROLE_PERM_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ROLE_ID | VARCHAR | (40) |  | ROLE_ID |  |  |  |
PERM_ID | VARCHAR | (40) |  | PERM_ID |  | X |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |

## KRIM_ROLE_RSP_ACTN_T

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

## KRIM_ROLE_RSP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ROLE_RSP_ID | VARCHAR | (40) |  | ROLE_RSP_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ROLE_ID | VARCHAR | (40) |  | ROLE_ID |  |  |  |
RSP_ID | VARCHAR | (40) |  | RSP_ID |  | X |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |

## KRIM_ROLE_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ROLE_ID | VARCHAR | (40) |  | ROLE_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ROLE_NM | VARCHAR | (80) |  | ROLE_NM |  |  | X |
NMSPC_CD | VARCHAR | (40) |  | NMSPC_CD |  |  | X |
DESC_TXT | VARCHAR | (4000) |  | DESC_TXT |  |  |  |
KIM_TYP_ID | VARCHAR | (40) |  | KIM_TYP_ID |  | X | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
LAST_UPDT_DT | DATE |  | SYSDATE | LAST_UPDT_DT |  |  |  |

## KRIM_RSP_ATTR_DATA_T

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

## KRIM_RSP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RSP_ID | VARCHAR | (40) |  | RSP_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
RSP_TMPL_ID | VARCHAR | (40) |  | RSP_TMPL_ID |  | X |  |
NMSPC_CD | VARCHAR | (40) |  | NMSPC_CD |  |  |  |
NM | VARCHAR | (100) |  | NM |  |  |  |
DESC_TXT | VARCHAR | (400) |  | DESC_TXT |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |

## KRIM_RSP_TMPL_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
RSP_TMPL_ID | VARCHAR | (40) |  | RSP_TMPL_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
NMSPC_CD | VARCHAR | (40) |  | NMSPC_CD |  |  |  |
NM | VARCHAR | (80) |  | NM |  |  |  |
KIM_TYP_ID | VARCHAR | (100) |  | KIM_TYP_ID |  | X | X |
DESC_TXT | VARCHAR | (400) |  | DESC_TXT |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |

## KRIM_TYP_ATTR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
KIM_TYP_ATTR_ID | VARCHAR | (40) |  | KIM_TYP_ATTR_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
SORT_CD | VARCHAR | (2) |  | SORT_CD |  |  |  |
KIM_TYP_ID | VARCHAR | (40) |  | KIM_TYP_ID |  | X | X |
KIM_ATTR_DEFN_ID | VARCHAR | (40) |  | KIM_ATTR_DEFN_ID |  | X |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |

## KRIM_TYP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
KIM_TYP_ID | VARCHAR | (40) |  | KIM_TYP_ID | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
NM | VARCHAR | (100) |  | NM |  |  |  |
SRVC_NM | VARCHAR | (200) |  | SRVC_NM |  |  |  |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  |  |
NMSPC_CD | VARCHAR | (40) |  | NMSPC_CD |  |  |  |

## KRNS_ADHOC_RTE_ACTN_RECIP_T

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

## KRNS_ATT_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
NTE_ID | DECIMAL | (14) |  | NTE_ID | X | X |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
MIME_TYP | VARCHAR | (150) |  | MIME_TYP |  |  |  |
FILE_NM | VARCHAR | (250) |  | FILE_NM |  |  |  |
ATT_ID | VARCHAR | (36) |  | ATT_ID |  |  |  |
FILE_SZ | DECIMAL | (14) |  | FILE_SZ |  |  |  |
ATT_TYP_CD | VARCHAR | (40) |  | ATT_TYP_CD |  |  |  |

## KRNS_CAMPUS_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
CAMPUS_CD | VARCHAR | (2) |  | CAMPUS_CD | X |  |  |
CAMPUS_NM | VARCHAR | (250) |  | CAMPUS_NM |  |  |  |
CAMPUS_SHRT_NM | VARCHAR | (250) |  | CAMPUS_SHRT_NM |  |  |  |
CAMPUS_TYP_CD | VARCHAR | (1) |  | CAMPUS_TYP_CD |  | X |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  | X |

## KRNS_CMP_TYP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
CAMPUS_TYP_CD | VARCHAR | (1) |  | CAMPUS_TYP_CD | X |  |  |
CMP_TYP_NM | VARCHAR | (250) |  | CMP_TYP_NM |  |  |  |
DOBJ_MAINT_CD_ACTV_IND | VARCHAR | (1) |  | DOBJ_MAINT_CD_ACTV_IND |  |  | X |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  | X |

## KRNS_DOC_HDR_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_ID | VARCHAR | (14) |  | DOC_HDR_ID | X |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
FDOC_DESC | VARCHAR | (40) |  | FDOC_DESC |  |  |  |
ORG_DOC_HDR_ID | VARCHAR | (10) |  | ORG_DOC_HDR_ID |  |  |  |
TMPL_DOC_HDR_ID | VARCHAR | (14) |  | TMPL_DOC_HDR_ID |  |  |  |
EXPLANATION | VARCHAR | (400) |  | EXPLANATION |  |  |  |

## KRNS_LOOKUP_RSLT_T

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

## KRNS_LOOKUP_SEL_T

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

## KRNS_MAINT_DOC_ATT_T

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

## KRNS_MAINT_DOC_T

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

## KRNS_MAINT_LOCK_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
MAINT_LOCK_REP_TXT | VARCHAR | (500) |  | MAINT_LOCK_REP_TXT |  |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
DOC_HDR_ID | VARCHAR | (14) |  | DOC_HDR_ID |  |  | X |
MAINT_LOCK_ID | VARCHAR | (14) |  | MAINT_LOCK_ID | X |  |  |

## KRNS_NMSPC_T

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

## KRNS_NTE_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
NTE_ID | DECIMAL | (14) |  | NTE_ID | X |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
RMT_OBJ_ID | VARCHAR | (36) |  | RMT_OBJ_ID |  |  | X |
AUTH_PRNCPL_ID | VARCHAR | (40) |  | AUTH_PRNCPL_ID |  |  | X |
POST_TS | DATE |  |  | POST_TS |  |  | X |
NTE_TYP_CD | VARCHAR | (4) |  | NTE_TYP_CD |  | X | X |
TXT | VARCHAR | (800) |  | TXT |  |  |  |
PRG_CD | VARCHAR | (1) |  | PRG_CD |  |  |  |
TPC_TXT | VARCHAR | (40) |  | TPC_TXT |  |  |  |

## KRNS_NTE_TYP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
NTE_TYP_CD | VARCHAR | (4) |  | NTE_TYP_CD | X |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
TYP_DESC_TXT | VARCHAR | (100) |  | TYP_DESC_TXT |  |  |  |
ACTV_IND | VARCHAR | (1) |  | ACTV_IND |  |  |  |

## KRNS_PARM_DTL_TYP_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
NMSPC_CD | VARCHAR | (20) |  | NMSPC_CD | X | X |  |
PARM_DTL_TYP_CD | VARCHAR | (100) |  | PARM_DTL_TYP_CD | X |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
NM | VARCHAR | (255) |  | NM |  |  |  |
ACTV_IND | CHAR | (1) | Y | ACTV_IND |  |  | X |

## KRNS_PARM_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
NMSPC_CD | VARCHAR | (20) |  | NMSPC_CD | X | X |  |
PARM_DTL_TYP_CD | VARCHAR | (100) |  | PARM_DTL_TYP_CD | X |  |  |
PARM_NM | VARCHAR | (255) |  | PARM_NM | X |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
PARM_TYP_CD | VARCHAR | (5) |  | PARM_TYP_CD |  | X | X |
TXT | VARCHAR | (4000) |  | TXT |  |  |  |
PARM_DESC_TXT | VARCHAR | (4000) |  | PARM_DESC_TXT |  |  |  |
CONS_CD | VARCHAR | (1) |  | CONS_CD |  |  |  |
APPL_NMSPC_CD | VARCHAR | (20) | KUALI | APPL_NMSPC_CD | X |  |  |

## KRNS_PARM_TYP_T

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

## KRNS_PESSIMISTIC_LOCK_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
PESSIMISTIC_LOCK_ID | DECIMAL | (14) |  | PESSIMISTIC_LOCK_ID | X |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
LOCK_DESC_TXT | VARCHAR | (4000) |  | LOCK_DESC_TXT |  |  |  |
DOC_HDR_ID | VARCHAR | (14) |  | DOC_HDR_ID |  |  | X |
GNRT_DT | DATE |  |  | GNRT_DT |  |  | X |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID |  |  | X |

## KRNS_SESN_DOC_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
SESN_DOC_ID | VARCHAR | (40) |  | SESN_DOC_ID | X |  |  |
DOC_HDR_ID | VARCHAR | (14) |  | DOC_HDR_ID | X |  |  |
PRNCPL_ID | VARCHAR | (40) |  | PRNCPL_ID | X |  |  |
IP_ADDR | VARCHAR | (60) |  | IP_ADDR | X |  |  |
SERIALZD_DOC_FRM | BLOB |  |  | SERIALZD_DOC_FRM |  |  |  |
LAST_UPDT_DT | DATE |  |  | LAST_UPDT_DT |  |  |  |
CONTENT_ENCRYPTED_IND | CHAR | (1) | N | CONTENT_ENCRYPTED_IND |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KRSB_BAM_PARM_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
BAM_PARM_ID | DECIMAL | (14) |  | BAM_PARM_ID | X |  |  |
BAM_ID | DECIMAL | (14) |  | BAM_ID |  |  | X |
PARM | CLOB |  |  | PARM |  |  | X |

## KRSB_BAM_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
BAM_ID | DECIMAL | (14) |  | BAM_ID | X |  |  |
SVC_NM | VARCHAR | (255) |  | SVC_NM |  |  | X |
SVC_URL | VARCHAR | (500) |  | SVC_URL |  |  | X |
MTHD_NM | VARCHAR | (2000) |  | MTHD_NM |  |  | X |
THRD_NM | VARCHAR | (500) |  | THRD_NM |  |  | X |
CALL_DT | DATE |  |  | CALL_DT |  |  | X |
TGT_TO_STR | VARCHAR | (2000) |  | TGT_TO_STR |  |  | X |
SRVR_IND | DECIMAL | (1) |  | SRVR_IND |  |  | X |
EXCPN_TO_STR | VARCHAR | (2000) |  | EXCPN_TO_STR |  |  |  |
EXCPN_MSG | CLOB |  |  | EXCPN_MSG |  |  |  |

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

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

## KRSB_MSG_QUE_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
MSG_QUE_ID | DECIMAL | (14) |  | MSG_QUE_ID | X |  |  |
DT | DATE |  |  | DT |  |  | X |
EXP_DT | DATE |  |  | EXP_DT |  |  |  |
PRIO | DECIMAL | (8) |  | PRIO |  |  | X |
STAT_CD | CHAR | (1) |  | STAT_CD |  |  | X |
RTRY_CNT | DECIMAL | (8) |  | RTRY_CNT |  |  | X |
IP_NBR | VARCHAR | (2000) |  | IP_NBR |  |  | X |
SVC_NM | VARCHAR | (255) |  | SVC_NM |  |  |  |
SVC_NMSPC | VARCHAR | (255) |  | SVC_NMSPC |  |  | X |
SVC_MTHD_NM | VARCHAR | (2000) |  | SVC_MTHD_NM |  |  |  |
APP_VAL_ONE | VARCHAR | (2000) |  | APP_VAL_ONE |  |  |  |
APP_VAL_TWO | VARCHAR | (2000) |  | APP_VAL_TWO |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## KRSB_QRTZ_BLOB_TRIGGERS

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

## KRSB_QRTZ_CALENDARS

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

## KRSB_QRTZ_CRON_TRIGGERS

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

## KRSB_QRTZ_FIRED_TRIGGERS

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

## KRSB_QRTZ_JOB_DETAILS

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

## KRSB_QRTZ_JOB_LISTENERS

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

## KRSB_QRTZ_LOCKS

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

## KRSB_QRTZ_PAUSED_TRIGGER_GRPS

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

## KRSB_QRTZ_SCHEDULER_STATE

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

## KRSB_QRTZ_SIMPLE_TRIGGERS

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

## KRSB_QRTZ_TRIGGERS

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

## KRSB_QRTZ_TRIGGER_LISTENERS

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

## KRSB_SVC_DEF_T

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
SVC_DEF_ID | DECIMAL | (14) |  | SVC_DEF_ID | X |  |  |
SVC_NM | VARCHAR | (255) |  | SVC_NM |  |  | X |
SVC_URL | VARCHAR | (500) |  | SVC_URL |  |  | X |
SRVR_IP | VARCHAR | (40) |  | SRVR_IP |  |  | X |
SVC_NMSPC | VARCHAR | (255) |  | SVC_NMSPC |  |  | X |
SVC_ALIVE | DECIMAL | (1) |  | SVC_ALIVE |  |  | X |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |
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) |  | POSTAL_CNTRY_CD | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
POSTAL_CNTRY_NM | VARCHAR | (40) |  | POSTAL_CNTRY_NM |  |  |  |
PSTL_CNTRY_RSTRC_IND | VARCHAR | (1) |  | PSTL_CNTRY_RSTRC_IND |  |  | X |
ACTV_IND | VARCHAR | (1) | Y | ACTV_IND |  |  | X |

## KR_COUNTY_T

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

## KR_KIM_TEST_BO

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

## KR_POSTAL_CODE_T

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

## KR_STATE_T

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

## TRAV_DOC_2_ACCOUNTS

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

## TRV_ACCT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ACCT_NUM | VARCHAR | (10) |  | ACCT_NUM | X |  |  |
ACCT_NAME | VARCHAR | (50) |  | ACCT_NAME |  |  |  |
ACCT_TYPE | VARCHAR | (100) |  | ACCT_TYPE |  |  |  |
ACCT_FO_ID | DECIMAL | (14) |  | ACCT_FO_ID |  | X |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## TRV_ACCT_EXT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ACCT_NUM | VARCHAR | (10) |  | ACCT_NUM | X |  |  |
ACCT_TYPE | VARCHAR | (100) |  | ACCT_TYPE | X |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## TRV_ACCT_FO

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ACCT_FO_ID | DECIMAL | (14) |  | ACCT_FO_ID | X |  |  |
ACCT_FO_USER_NAME | VARCHAR | (50) |  | ACCT_FO_USER_NAME |  |  | X |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## TRV_ACCT_TYPE

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
ACCT_TYPE | VARCHAR | (10) |  | ACCT_TYPE | X |  |  |
ACCT_TYPE_NAME | VARCHAR | (50) |  | ACCT_TYPE_NAME |  |  |  |
OBJ_ID | VARCHAR | (36) |  | OBJ_ID |  |  |  |
VER_NBR | DECIMAL | (8) | 0 | VER_NBR |  |  |  |

## TRV_DOC_2

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
FDOC_NBR | VARCHAR | (14) |  | FDOC_NBR | X |  |  |
OBJ_ID | VARCHAR | (36) | SYS_GUID() | OBJ_ID |  |  | X |
VER_NBR | DECIMAL | (8) | 1 | VER_NBR |  |  | X |
FDOC_EXPLAIN_TXT | VARCHAR | (400) |  | FDOC_EXPLAIN_TXT |  |  |  |
REQUEST_TRAV | VARCHAR | (30) |  | REQUEST_TRAV |  |  | X |
TRAVELER | VARCHAR | (200) |  | TRAVELER |  |  |  |
ORG | VARCHAR | (60) |  | ORG |  |  |  |
DEST | VARCHAR | (60) |  | DEST |  |  |  |

## TRV_DOC_ACCT

Name | Type | Size | Default | JavaName | PK | FK | not null | Description
--- | --- | --- | --- | --- | --- | --- | --- | ---
DOC_HDR_ID | DECIMAL | (14) |  | DOC_HDR_ID | X |  |  |
ACCT_NUM | VARCHAR | (10) |  | ACCT_NUM | 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 |  |  |  |