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