Source Database Schema

  • AD - Address

AD_TK / char(16) NOT NULL
AD_TX_1 / varchar(40)
AD_TX_2 / varchar(40)
AD_TX_3 / varchar(40)
AD_TX_4 / varchar(40)
AD_CTY_NM / char(30)
AD_ST_CD / char(2)
AD_ZIP_CD_NU / char(10)
AD_CNY_CD / char(2)
AD_CRY_CD / char(2)
AD_UPD_TS / char(26)
AD_TRANS_ROW_TYPE_CD / char(4)
AD_TRANS_TS / char(26)
  • ADA - Address Appellate

ADA_TK / char(16) NOT NULL
ADA_TX_1 / varchar(40)
ADA_TX_2 / varchar(40)
ADA_TX_3 / varchar(40)
ADA_TX_4 / varchar(40)
ADA_CTY_NM / varchar(30)
ADA_ST_CD / char(2)
ADA_ZIP_CD_NU / varchar(10)
ADA_CNY_CD / char(2)
ADA_CRY_CD / char(2)
ADA_UPD_TS / char(26)
ADA_FL / char(1)
ADA_TRANS_ROW_TYPE_CD / char(4)
ADA_TRANS_TS / char(26)
  • ALI - Alias

ALI_PER_TK / char(16) NOT NULL
ALI_ALI_PER_TK / char(16) NOT NULL
ALI_TYP_CD / char(3) NOT NULL
ALI_END_EFF_DT / char(10)
ALI_BGN_EFF_DT / char(10)
ALI_UPD_TS / char(26) NOT NULL
ALI_TRANS_ROW_TYPE_CD / char(4)
ALI_TRANS_TS / char(26)
  • ATP - Authorization Profile

ATP_TK / char(16) NOT NULL
ATP_TYP_CD / char(3) NOT NULL
ATP_SEQ_NU / char(5) NOT NULL
ATP_DES_TX / char(64) NOT NULL
ATP_LVL_CD / char(1) NOT NULL
ATP_UPD_TS / char(26) NOT NULL
ATP_OBJ_NU / char(8)
ATP_TRANS_ROW_TYPE_CD / char(2)
ATP_TRANS_TS / char(26)
  • ATY - Attorney

ATY_OFL_PER_TK / char(16) NOT NULL
ATY_CO_AFF_NM / char(40)
ATY_UPD_TS / char(26)
ATY_PTC_CAT_CD / char(3)
ATY_TRANS_ROW_TYPE_CD / char(4)
ATY_TRANS_TS / char(26)
  • CAT - Category

CAT_TBL_NU / char(3) NOT NULL
CAT_TBL_TK / char(16) NOT NULL
CAT_TYP_CD / char(3) NOT NULL
CAT_SUB_TYP_CD / char(8) NOT NULL
CAT_BGN_EFF_TS / char(26)
CAT_END_EFF_TS / char(26) NOT NULL
CAT_CRT_ITL_NU / char(3)
CAT_OFL_PER_TK / char(16)
CAT_UPD_TS / char(26)
CAT_TRANS_ROW_TYPE_CD / char(2)
CAT_TRANS_TS / char(26)
  • CCA - Case Type Cause Code

CCA_TYP_CD / char(2) NOT NULL
CCA_CAU_CD / char(3) NOT NULL
CCA_END_EFF_DT / char(10)
CCA_BGN_EFF_DT / char(10)
CCA_DCT_CLS_VLD_FL / char(1)
CCA_SUP_CLS_VLD_FL / char(1)
CCA_SUT_AT_REQ_CD / char(1)
CCA_UPD_TS / char(26)
CCA_FIL_JIS_FL / char(1)
CCA_FIL_SCO_FL / char(1)
CCA_CNV_SCO_JIS_FL / char(1)
CCA_JUV_CLS_VLD_FL / char(1)
CCA_DV_REQ_FL / char(1)
CCA_NAV_PAR_TYP_CD / char(3)
CCA_TRANS_ROW_TYPE_CD / char(4)
CCA_TRANS_TS / char(26)
  • CCP - Case Type Cause Code Participant

CCP_CCA_TYP_CD / char(2) NOT NULL
CCP_CCA_CAU_CD / char(3) NOT NULL
CCP_PAR_TYP_CD / char(3) NOT NULL
CCP_END_EFF_DT / char(10)
CCP_BGN_EFF_DT / char(10)
CCP_DCT_CLS_VLD_FL / char(1) NOT NULL
CCP_SUP_CLS_VLD_FL / char(1) NOT NULL
CCP_UPD_SPA_FL / char(1) NOT NULL
CCP_UPD_TS / char(26) NOT NULL
CCP_CCA_END_EFF_DT / char(10)
CCP_JUV_CLS_VLD_FL / char(1)
CCP_PAR_REQ_FL / char(1)
CCP_DSP_SEQ_NU / decimal(3)
CCP_IN_REQ_FL / char(1)
CCP_CPY_CS_FL / char(1)
CCP_CPY_RFR_FL / char(1)
CCP_RLN_REQ_FL / char(1)
CCP_TRANS_ROW_TYPE_CD / char(4)
CCP_TRANS_TS / char(26)
  • CDD - Condition Definition

CDD_TK / char(16) NOT NULL
CDD_CD / char(7) NOT NULL
CDD_TYP_CD / char(3) NOT NULL
CDD_BGN_EFF_DT / char(10)
CDD_END_EFF_DT / char(10)
CDD_DES_TX / char(32) NOT NULL
CDD_ATZ_OBJ_NU / char(8) NOT NULL
CDD_DSL_SEQ_NU / decimal(3) NOT NULL
CDD_RVW_DT_FL / char(1) NOT NULL
CDD_AT_REQ_FL / char(1) NOT NULL
CDD_AT_TYP_CT / Decimal(1) NOT NULL
CDD_DUR_REQ_FL / char(1) NOT NULL
CDD_DUR_TYP_CT / decimal(1) NOT NULL
CDD_CPL_CD_REQ_FL / char(1) NOT NULL
CDD_DUE_DT_REQ_FL / char(1) NOT NULL
CDD_UPD_OFL_PER_TK / char(16) NOT NULL
CDD_UPD_TS / char(26) NOT NULL
CDD_TRANS_ROW_TYPE_CD / char(4)
CDD_TRANS_TS / char(26)
  • CHR - Charge

CHR_CRT_ITL_NU / char(3) NOT NULL
CHR_SCS_TK / char(16) NOT NULL
CHR_PER_TK / char(16) NOT NULL
CHR_INF_ENT_SEQ_NU / decimal(5) NOT NULL
CHR_CT_NU / decimal(3) NOT NULL
CHR_CMT_TX / char(35) NOT NULL
CHR_RSL_CD / char(2) NOT NULL
CHR_WPN_RSL_CD / char(2) NOT NULL
CHR_VIO_DT / char(10)
CHR_LAW_NU / char(15) NOT NULL
CHR_LAW_WPN_NU / char(15) NOT NULL
CHR_LAW_MOD_NU / char(15) NOT NULL
CHR_LAW_OTH_1_NU / char(15) NOT NULL
CHR_LAW_OTH_2_NU / char(15) NOT NULL
CHR_LAW_OTH_3_NU / char(15) NOT NULL
CHR_UPD_TS / char(26) NOT NULL
CHR_DV_FL / char(1) NOT NULL
CHR_TK / char(16) NOT NULL
CHR_JDO_CAT_CD / char(2) NOT NULL
CHR_COC_CD / char(1) NOT NULL
CHR_RSL_DT / char(10)
CHR_WPN_RSL_DT / char(10)
CHR_TRANS_ROW_TYPE_CD / char(4)
CHR_TRANS_TS / char(26)
CHR_LWC_TK / char(16)
CHR_STH_TK / char(16)
ORIGINAL_SEQ / decimal(5)
FINAL_SEQ / decimal(5)
  • CIT - Citation

CIT_DCM_ITM_TK / char(16) NOT NULL
CIT_CRT_ITL_NU / char(3) NOT NULL
CIT_VIO_DT / char(10)
CIT_AT / decimal(72)
CIT_ICD_NU / char(10)
CIT_ACD_FL / char(1)
CIT_VEH_OWN_NM_TX / char(32)
CIT_SP_ZN_CT / decimal(2)
CIT_VEH_SP_CT / decimal(3)
CIT_UPD_TS / char(26)
CIT_BLC_TYP_CD / char(2)
CIT_BLC_PR / decimal(54)
CIT_TRANS_ROW_TYPE_CD / char(4)
CIT_TRANS_TS / char(26)
  • CJ - Civil Judgment

CJ_CRT_ITL_NU / char(3) NOT NULL
CJ_CS_TK / char(16) NOT NULL
CJ_TYP_CD / char(2)
CJ_SEQ_NU / decimal(2) NOT NULL
CJ_DT / char(10)
CJ_DIS_CD / char(2)
CJ_DIS_DT / char(10)
CJ_JDG_ITL_NU / char(3)
CJ_PMT_TO_PER_TK / char(16)
CJ_UPD_TS / char(26)
CJ_TRANS_ROW_TYPE_CD / char(4)
CJ_TRANS_TS / char(26)
  • CJI - Civil Judgment Item

CJI_CS_TK / char(16) NOT NULL
CJI_CJ_SEQ_NU / decimal(2) NOT NULL
CJI_CD / char(3) NOT NULL
CJI_CRT_ITL_NU / char(3) NOT NULL
CJI_AT / decimal(92) NOT NULL
CJI_UPD_TS / char(26) NOT NULL
CJI_TRANS_ROW_TYPE_CD / char(4)
CJI_TRANS_TS / char(26)
  • CMT - Comment

CMT_TK / char(16) NOT NULL
CMT_DSL_TS / char(26) NOT NULL
CMT_DSL_SEQ_NU / int
CMT_DSL_CD / char(1)
CMT_TX / varchar(3980)
CMT_ATZ_OBJ_NU / char(8)
CMT_CRE_OFL_PER_TK / char(16)
CMT_CRE_TS / char(26)
CMT_UPD_OFL_PER_TK / char(16)
CMT_UPD_TS / char(26)
CMT_FL / char(1)
CMT_TRANS_ROW_TYPE_CD / char(2)
CMT_TRANS_TS / char(26)
  • CND - Condition

CND_TK / char(16) NOT NULL
CND_CDD_TK / char(16) NOT NULL
CND_DIS_TK / char(16) NOT NULL
CND_CMT_TK / char(16)
CND_DUE_DT / char(10)
CND_DUR_TYP_CD / char(1) NOT NULL
CND_DUR_CT / decimal(72) NOT NULL
CND_MIN_DUR_CT / decimal(72) NOT NULL
CND_MAX_DUR_CT / decimal(72) NOT NULL
CND_AT / decimal(112) NOT NULL
CND_RVW_DT / char(10)
CND_RVW_TM / char(12)
CND_CPL_CD / char(1) NOT NULL
CND_CPL_DT / char(10)
CND_CRE_OFL_PER_TK / char(16) NOT NULL
CND_CRE_TS / char(26) NOT NULL
CND_UPD_OFL_PER_TK / char(16) NOT NULL
CND_UPD_TS / char(26) NOT NULL
CND_TRANS_ROW_TYPE_CD / char(4)
CND_TRANS_TS / char(26)
  • CNS - Consolidated Case

CNS_CRT_ITL_NU / char(3) NOT NULL
CNS_MST_SCS_TK / char(16) NOT NULL
CNS_ENT_SEQ_NU / decimal(5) NOT NULL
CNS_CNS_SCS_TK / char(16) NOT NULL
CNS_CNS_CS_NU / char(12) NOT NULL
CNS_UPD_TS / char(26) NOT NULL
CNS_TRANS_ROW_TYPE_CD / char(4)
CNS_TRANS_TS / char(26)
  • CRT - Court

CRT_ORG_PER_TK / char(16)
CRT_ITL_NU / char(3) NOT NULL
CRT_WRN_EXP_DFL_CT / decimal(2)
CRT_WRN_EXP_MAX_CT / decimal(2)
CRT_WRN_EXP_MIN_CT / decimal(2)
CRT_WRN_DLY_MAX_CT / decimal(2)
CRT_WRN_GRC_CT / decimal(2)
CRT_FTA_IFR_GRC_CT / decimal(2)
CRT_FTA_CRM_GRC_CT / decimal(2)
CRT_RET_DT_DFL_CT / decimal(2)
CRT_BL_PMT_DUE_CT / decimal(2)
CRT_OP_RET_LMT_AT / decimal(42)
CRT_CIV_JUR_ITL_NU / char(3)
CRT_DFL_JUR_ITL_NU / char(3)
CRT_RCP_PRN_FL / char(1)
CRT_LST_PST_DT / char(10)
CRT_LST_PST_SEQ_NU / decimal(2)
CRT_PRF_NU / char(3)
CRT_TPA_SRT_SEQ_CD / char(1)
CRT_TPA_ACC_OPT_CD / char(1)
CRT_TPA_WKD_CD / char(2)
CRT_TPA_LST_RUN_DT / char(10)
CRT_TPA_AT_DUE_CD / char(1)
CRT_PDG_JDG_PER_TK / char(16)
CRT_PDG_JDG_ITL_NU / char(3)
CRT_IFR_DLQ_TX / varchar(500)
CRT_IFR_CMP_TX / varchar(500)
CRT_CRM_DLQ_TX / varchar(500)
CRT_CRM_CMP_TX / varchar(500)
CRT_DLQ_NTC_TX / varchar(500)
CRT_SHT_NM / char(20)
CRT_PDG_ADR_ITL_NU / char(3)
CRT_PDG_ADR_PER_TK / char(16)
CRT_UPD_TS / char(26)
CRT_LVL_CD / char(1)
CRT_MIN_CHK_AT / decimal(32)
CRT_CHK_HLD_MAX_CT / decimal(3)
CRT_DFL_MNL_CHK_FL / char(1)
CRT_DFL_BNK_ACC_CD / char(2)
CRT_PDG_OFL_TTL_TX / char(32)
CRT_LST_JRS_RCP_DT / char(10)
CRT_CHK_AGE_CT / decimal(3)
CRT_JAS_CNV_DT / char(10)
CRT_DOR_UCP_HLD_NU / char(9)
CRT_CNY_NU / decimal(2)
CRT_DOL_FTA_DLY_CT / decimal(2)
CRT_ST_WID_NPC_FL / char(1)
CRT_CLN_OFC_PER_TK / char(16)
CRT_CLN_OFL_TTL_TX / char(32)
CRT_CLN_RCP_FL / char(1)
CRT_CLN_ADJ_FL / char(1)
CRT_CLN_AGN_PER_TK / char(16)
CRT_CLN_MIN_AT / decimal(72)
CRT_TPY_RMV_BGN_CT / decimal(5)
CRT_TPY_RMV_END_CT / decimal(5)
CRT_TPY_RMV_RCP_CT / decimal(5)
CRT_DTN_RPT_SRT_CD / char(1)
CRT_CAL_APC_BGN_DT / char(10)
CRT_TRANS_ROW_TYPE_CD / char(2)
CRT_TRANS_TS / char(26)
  • CS - Case

CS_TK / char(16) NOT NULL
CS_CRT_ITL_NU / char(3)
CS_TYP_CD / char(2)
CS_LEA_ITL_NU / char(3)
CS_NU / char(9)
CS_JUR_ITL_NU / char(3)
CS_CSL_CD / char(2)
CS_CRE_DT / char(10)
CS_XPG_DT / char(10)
CS_APL_BGN_DT / char(10)
CS_APL_END_DT / char(10)
CS_DIS_CD / char(2)
CS_DIS_DT / char(10)
CS_NT_TX / char(64)
CS_CIV_CS_FL / char(1)
CS_WGT_CSL_FL / char(1)
CS_SMN_PRN_DT / char(10)
CS_SMN_PRN_TM / char(12)
CS_CLN_STS_CD / char(1)
CS_CLN_DEF_NTC_DT / char(10)
CS_UPD_TS / char(26)
CS_SUP_FLY_FL / char(1)
CS_SUP_JDM_FIL_DT / char(10)
CS_HLD_AP_FL / char(1)
CS_SCT_TYP_CD / char(1)
CS_TRANS_ROW_TYPE_CD / char(4)
CS_TRANS_TS / char(26)
  • CSA - Case Appellate

CSA_TK / char(16) NOT NULL
CSA_CRT_ITL_NU / char(3)
CSA_NU / char(9)
CSA_RCV_DT / char(10)
CSA_RVW_TYP_CD / char(3)
CSA_TTL_SHT_TX / varchar(100)
CSA_TTL_LON_CMT_TK / char(16)
CSA_STH_CD / char(3)
CSA_STH_BGN_EFF_DT / char(10)
CSA_ACL_RVW_STS_CD / char(1)
CSA_ACL_RVW_RSN_CD / char(3)
CSA_TYP_CD / char(2)
CSA_CNY_ORG_PER_TK / char(16)
CSA_UPD_TS / char(26)
CSA_TRL_JDM_DT / char(10)
CSA_TRL_OFL_PER_TK / char(16)
CSA_FIL_FEE_STS_CD / char(3)
CSA_TRC_TK / char(16)
CSA_PRC_SCH_CD / char(2)
CSA_SRC_CD / char(4)
CSA_CNS_CD / char(3)
CSA_LNK_FL / char(1)
CSA_TRANS_ROW_TYPE_CD / char(4)
CSA_TRANS_TS / char(26)
  • CSC - Civil Small Claim Complaint

CSC_DCM_ITM_TK / char(16) NOT NULL
CSC_CRT_ITL_NU / char(3) NOT NULL
CSC_SUT_AT / decimal(92)
CSC_CAU_CD / char(3)
CSC_TTL_TX / char(128)
CSC_UPD_TS / char(26)
CSC_DV_FL / char(1)
CSC_TRANS_ROW_TYPE_CD / char(4)
CSC_TRANS_TS / char(26)
  • CSG - Case General

CSG_TBL_TK / char(16) NOT NULL
CSG_TBL_NU / char(3)
CSG_ORG_PER_TK / char(16)
CSG_FIL_DT / char(10)
CSG_SCT_TYP_CD / char(1)
CSG_CMT_TK / char(16)
CSG_RSO_CD / char(4)
CSG_RSO_DT / char(10)
CSG_CML_CD / char(4)
CSG_CML_DT / char(10)
CSG_CLO_CD / char(2)
CSG_CLO_DT / char(10)
CSG_CRE_DT / char(10)
CSG_CSY_TS / char(26)
CSG_UPD_TS / char(26)
CSG_RSO_RSN_CD / char(4)
CSG_TRANS_ROW_TYPE_CD / char(4)
CSG_TRANS_TS / char(26)
  • CSU - Case Suspended History

CSU_CRT_ITL_NU / char(3) NOT NULL
CSU_SCS_TK / char(16) NOT NULL
CSU_ENT_SEQ_NU / decimal(5) NOT NULL
CSU_STS_CD / char(4) NOT NULL
CSU_STS_BGN_DT / char(10) NOT NULL
CSU_STS_END_DT / char(10) NOT NULL
CSU_AUD_TYP_CD / char(1) NOT NULL
CSU_UPD_TS / char(26) NOT NULL
CSU_TRANS_ROW_TYPE_CD / char(4)
CSU_TRANS_TS / char(26)
  • CTC - Code Table Contents

CTC_TBL_NU / char(8) NOT NULL
CTC_TBL_CRT_ITL_NU / char(3) NOT NULL
CTC_TBL_KEY_NU / varchar(8) NOT NULL
CTC_END_EFF_DT / char(10)
CTC_BGN_EFF_DT / char(10)
CTC_RSL_TX / char(65)
CTC_UPD_TS / char(26)
CTC_TRANS_ROW_TYPE_CD / char(4)
CTC_TRANS_TS / char(26)
  • DCM - Document

DCM_ITM_TK / char(16) NOT NULL
DCM_CS_TK / char(16) NOT NULL
DCM_CRT_ITL_NU / char(3) NOT NULL
DCM_TYP_CD / char(2) NOT NULL
DCM_FIL_DT / char(10)
DCM_UPD_TS / char(26) NOT NULL
DCM_TRANS_ROW_TYPE_CD / char(4)
DCM_TRANS_TS / char(26)
  • DID - Disposition Definition

DID_TK / char(16) NOT NULL
DID_TYP_CD / char(2) NOT NULL
DID_CD / char(7) NOT NULL
DID_BGN_EFF_DT / char(10)
DID_END_EFF_DT / char(10)
DID_LON_DES_TX / char(60) NOT NULL
DID_SHT_DES_TX / char(30) NOT NULL
DID_ATH_PER_REQ_FL / char(1) NOT NULL
DID_SDK_FL / char(1) NOT NULL
DID_CRE_OFL_PER_TK / char(16) NOT NULL
DID_CRE_TS / char(26) NOT NULL
DID_UPD_OFL_PER_TK / char(16) NOT NULL
DID_UPD_TS / char(26) NOT NULL
DID_TRANS_ROW_TYPE_CD / char(4)
DID_TRANS_TS / char(26)
  • DIS - Disposition

DIS_TK / char(16) NOT NULL
DIS_TBL_NU / char(3) NOT NULL
DIS_TBL_TK / char(16) NOT NULL
DIS_DID_TK / char(16) NOT NULL
DIS_DT / char(10)
DIS_ATH_PER_TK / char(16)
DIS_CMT_TK / char(16)
DIS_SDK_TK / char(16)
DIS_CRE_OFL_PER_TK / char(16) NOT NULL
DIS_CRE_TS / char(26) NOT NULL
DIS_UPD_OFL_PER_TK / char(16) NOT NULL
DIS_UPD_TS / char(26) NOT NULL
DIS_TM / char(12)
DIS_TRANS_ROW_TYPE_CD / char(4)
DIS_TRANS_TS / char(26)
  • DNE - Detention Episode

DNE_CS_TK / char(16) NOT NULL
DNE_CRE_OFL_PER_TK / char(16) NOT NULL
DNE_CRE_TS / char(26) NOT NULL
DNE_ORG_ITL_NU / char(3) NOT NULL
DNE_NU_YR / decimal(4) NOT NULL
DNE_NU_TYP_CD / char(1) NOT NULL
DNE_NU_SEQ_NU / decimal(7) NOT NULL
DNE_CS_TYP_CD / char(2) NOT NULL
DNE_BHV_LVL_CD / char(2) NOT NULL
DNE_BHV_LVL_JTL_TK / char(16)
DNE_CMT_TK / char(16)
DNE_ITK_CD / char(1) NOT NULL
DNE_ITK_DT / char(10)
DNE_ITK_TM / char(12)
DNE_CUR_ITK_JTL_TK / char(16) NOT NULL
DNE_ADT_DT / char(10)
DNE_ADT_TM / char(12)
DNE_SCH_REL_DT / char(10)
DNE_SCH_REL_TM / char(12)
DNE_ACT_REL_DT / char(10)
DNE_ACT_REL_TM / char(12)
DNE_SCH_HLD_MI_CT / decimal(9) NOT NULL
DNE_ACT_HLD_MI_CT / decimal(9) NOT NULL
DNE_REL_TO_TX / varchar(60) NOT NULL
DNE_CUR_DNF_TK / char(16)
DNE_CUR_DNF_JTL_TK / char(16)
DNE_CUR_LOC_TK / char(16)
DNE_BED_LOC_TK / char(16)
DNE_BED_LOC_JTL_TK / char(16)
DNE_UPD_OFL_PER_TK / char(16) NOT NULL
DNE_UPD_TS / char(26) NOT NULL
DNE_ARS_ORG_PER_TK / char(16)
DNE_ARS_DT / char(10)
DNE_ARS_TM / char(12)
DNE_ARS_NU / char(20) NOT NULL
DNE_TRANS_ROW_TYPE_CD / char(4)
DNE_TRANS_TS / char(26)
  • DNF - Detention Furlough

DNF_TK / char(16) NOT NULL
DNF_CRE_TS / char(26) NOT NULL
DNF_CRE_OFL_PER_TK / char(16) NOT NULL
DNF_ORG_ITL_NU / char(3) NOT NULL
DNF_DNE_CS_TK / char(16) NOT NULL
DNF_LOC_TK / char(16)
DNF_CTR_CD / char(3) NOT NULL
DNF_SCH_DPT_DT / char(10)
DNF_SCH_DPT_TM / char(12)
DNF_SCH_RET_DT / char(10)
DNF_SCH_RET_TM / char(12)
DNF_ACT_DPT_DT / char(10)
DNF_ACT_DPT_TM / char(12)
DNF_ACT_RET_DT / char(10)
DNF_ACT_RET_TM / char(12)
DNF_REL_TO_TX / varchar(60) NOT NULL
DNF_CMT_TK / char(16)
DNF_UPD_OFL_PER_TK / char(16) NOT NULL
DNF_UPD_TS / char(26) NOT NULL
DNF_REL_BED_FL / char(1) NOT NULL
DNF_TRANS_ROW_TYPE_CD / char(4)
DNF_TRANS_TS / char(26)
DNF_SQL_RCV_DT / datetime
DNF_ROWID / int NOT NULL
actual_depart_timestamp / char(19)
actual_return_timestamp / char(19)
  • DNR - Detention Reason

DNR_TK / char(16) NOT NULL
DNR_CRE_TS / char(26) NOT NULL
DNR_CRE_OFL_PER_TK / char(16) NOT NULL
DNR_ORG_ITL_NU / char(3) NOT NULL
DNR_DNE_CS_TK / char(16) NOT NULL
DNR_SEQ_NU / decimal(3) NOT NULL
DNR_TBL_NU / char(3) NOT NULL
DNR_TBL_TK / char(16) NOT NULL
DNR_CMT_TK / char(16)
DNR_CR_MI_CT / decimal(9) NOT NULL
DNR_SCH_SRV_MI_CT / decimal(9) NOT NULL
DNR_ACT_SRV_MI_CT / decimal(9) NOT NULL
DNR_UPD_OFL_PER_TK / char(16) NOT NULL
DNR_UPD_TS / char(26) NOT NULL
DNR_HLD_ORG_PER_TK / char(16)
DNR_ADM_JTL_TK / char(16)
DNR_LGL_STS_JTL_TK / char(16)
DNR_END_STS_JTL_TK / char(16)
DNR_NEW_RFR_FL / char(1) NOT NULL
DNR_WRN_NU / char(20)
DNR_WRN_CD / char(1)
DNR_BL_CD / char(1)
DNR_BL_AT / decimal(92)
DNR_BL_TX / varchar(40) NOT NULL
DNR_TRANS_ROW_TYPE_CD / char(4)
DNR_TRANS_TS / char(26)
  • DT - Date

DT_DT / datetime
DT_WKD_CD / char(1) NOT NULL
DT_MM_WK_CD / char(1) NOT NULL
DT_SUN_FL / char(1) NOT NULL
DT_MON_FL / char(1) NOT NULL
DT_TUE_FL / char(1) NOT NULL
DT_WED_FL / char(1) NOT NULL
DT_THU_FL / char(1) NOT NULL
DT_FRI_FL / char(1) NOT NULL
DT_SAT_FL / char(1) NOT NULL
DT_LST_DD_MM_FL / char(1) NOT NULL
DT_TRANS_ROW_TYPE_CD / char(4)
DT_TRANS_TS / char(26)
  • EML - Email

EML_TK / char(16) NOT NULL
EML_AD_TX / varchar(64)
EML_UPD_TS / char(26)
EML_TRANS_ROW_TYPE_CD / char(4)
EML_TRANS_TS / char(26)
  • EVA - Event Action Code

EVA_EVC_TK / char(16) NOT NULL
EVA_CD / char(3) NOT NULL
EVA_DFL_FL / char(1)
EVA_UPD_TS / char(26)
EVA_TRANS_ROW_TYPE_CD / char(4)
EVA_TRANS_TS / char(26)
  • EVC - Event Code

EVC_TK / char(16) NOT NULL
EVC_TYP_CD / char(3)
EVC_SUB_TYP_CD / char(8)
EVC_TX / varchar(244)
EVC_BGN_EFF_DT / char(10)
EVC_END_EFF_DT / char(10)
EVC_SPM_LVL_VLD_FL / char(1)
EVC_COA_LVL_VLD_FL / char(1)
EVC_UPD_TS / char(26)
EVC_MLS_FL / char(1)
EVC_SHT_TX / char(50)
EVC_TRANS_ROW_TYPE_CD / char(4)
EVC_TRANS_TS / char(26)
  • EVD - Event Date

EVD_CRT_ITL_NU / char(3)
EVD_EVN_TK / char(16)
EVD_TK / char(16) NOT NULL
EVD_DT / char(10)
EVD_DSL_SEQ_NU / int
EVD_EVA_CD / char(3)
EVD_BGN_EFF_TS / char(26)
EVD_END_EFF_TS / char(26)
EVD_UPD_OFL_PER_TK / char(16)
EVD_UPD_TS / char(26)
EVD_REQ_CD / char(1)
EVD_TRANS_ROW_TYPE_CD / char(4)
EVD_TRANS_TS / char(26)
  • EVN - Event

EVN_CRT_ITL_NU / char(16)
EVN_TK / char(16) NOT NULL
EVN_TBL_NU / char(3)
EVN_TBL_TK / char(16)
EVN_EVC_TYP_CD / char(3)
EVN_EVC_SUB_TYP_CD / char(8)
EVN_TX / varchar(244)
EVN_CMT_TK / char(16)
EVN_SCT_TYP_CD / char(1)
EVN_PRY_CD / char(1)
EVN_DCS_CD / char(3)
EVN_CRE_TYP_CD / char(1)
EVN_CRE_OFL_PER_TK / char(16)
EVN_CRE_TS / char(26)
EVN_UPD_OFL_PER_TK / char(16)
EVN_UPD_TS / char(26)
EVN_SEC_FL / char(1)
EVN_TRANS_ROW_TYPE_CD / char(4)
EVN_TRANS_TS / char(26)
  • EVO - Event Opinion

VW_EVO
EVO_EVN_TK / char(16) NOT NULL
EVO_OPD_TK / char(16) NOT NULL
EVO_UPD_TS / char(26) NOT NULL
EVO_FL / char(1)
EVO_TRANS_ROW_TYPE_CD / char(4)
EVO_TRANS_TS / char(26)
  • EVP - Event Participant

EVP_EVN_TK / char(16) NOT NULL
EVP_PER_TBL_NU / char(3) NOT NULL
EVP_PER_TBL_TK / char(16) NOT NULL
EVP_TYP_CD / char(3) NOT NULL