View slot9.WORLD.TSTA.ZZV1_CHARGE_CODES
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
AUDIT_TIMESTAMP date 7  √  null
AUDIT_TRANSACTION_TYPE varchar2 1  √  null
AUDIT_USER_NAME varchar2 100  √  null
AUDIT_TRUE_NULLS varchar2 250  √  null
CODE varchar2 30  √  null
BLOOD_TYPE_CODES.CODE Implied Constraint R
STATUTE varchar2 20  √  null
CHARGE_CLASS_CODE varchar2 1  √  null
CHARGE_CATEGORY_CODE varchar2 2  √  null
CHARGE_CATEGORY_CODES.CHARGE_CATEGORY_CODE Implied Constraint R
CHA_DESC varchar2 255  √  null
ADDCHG varchar2 1  √  null
APR varchar2 1  √  null
AOSEQ number 6  √  null
ACT number 5  √  null
EFFDATE date 7  √  null
INADATE date 7  √  null
SOS varchar2 1  √  null
BOI varchar2 1  √  null
REMARKS varchar2 30  √  null
INA varchar2 1  √  null
LUPDATE date 7  √  null
SUFFCK number 0  √  null
CHAPTER number 4  √  null
SECTION varchar2 25  √  null
MVRDATE date 7  √  null
STATUTE_NEW varchar2 60  √  null
SHORT_LIST varchar2 1  √  null
OFFNS_CD_OFFENSE_CODE varchar2 30  √  null
DISPLAY_FLAG varchar2 1  √  null
SPEEDING_FLAG varchar2 1  √  null
SUSPEND_FLAG varchar2 1  √  null
VARIABLE_FINE_FLAG varchar2 1  √  null
FINE number 9,2  √  null
STATE_CODE varchar2 3  √  null
FINGERPRINT_FLG varchar2 1  √  null
ADMIN_CRT varchar2 1  √  null
COMMISSARY_RESTRICTED_HOURS number 0  √  null
RESTRICT_COMMISSARY varchar2 1  √  null
REC_ID number 0  √  null
ARREST_CHARGE_CODE varchar2 30  √  null
ARREST_CHARGE_CODES.ARREST_CHARGE_CODE Implied Constraint R
DV_FLAG varchar2 1  √  null
REQUIRE_TYPE_FLAG varchar2 1  √  null
REQUIRE_CLASS_FLAG varchar2 1  √  null
DEFAULT_ON_ENTRY_FLAG varchar2 1  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT ZZ1.AUDIT_TIMESTAMP AUDIT_TIMESTAMP, ZZ1.AUDIT_TRANSACTION_TYPE AUDIT_TRANSACTION_TYPE, ZZ1.AUDIT_USER_NAME AUDIT_USER_NAME, ZZ1.AUDIT_TRUE_NULLS AUDIT_TRUE_NULLS, ZZ1.CODE CODE, ZZ1.STATUTE STATUTE, ZZ1.CHARGE_CLASS_CODE CHARGE_CLASS_CODE, ZZ1.CHARGE_CATEGORY_CODE CHARGE_CATEGORY_CODE, ZZ1.CHA_DESC CHA_DESC, ZZ1.ADDCHG ADDCHG, ZZ1.APR APR, ZZ1.AOSEQ AOSEQ, ZZ1.ACT ACT, ZZ1.EFFDATE EFFDATE, ZZ1.INADATE INADATE, ZZ1.SOS SOS, ZZ1.BOI BOI, ZZ1.REMARKS REMARKS, ZZ1.INA INA, ZZ1.LUPDATE LUPDATE, ZZ1.SUFFCK SUFFCK, ZZ1.CHAPTER CHAPTER, ZZ1.SECTION SECTION, ZZ1.MVRDATE MVRDATE, ZZ1.STATUTE_NEW STATUTE_NEW, ZZ1.SHORT_LIST SHORT_LIST, ZZ1.OFFNS_CD_OFFENSE_CODE OFFNS_CD_OFFENSE_CODE, ZZ1.DISPLAY_FLAG DISPLAY_FLAG, ZZ1.SPEEDING_FLAG SPEEDING_FLAG, ZZ1.SUSPEND_FLAG SUSPEND_FLAG, ZZ1.VARIABLE_FINE_FLAG VARIABLE_FINE_FLAG, ZZ1.FINE FINE, ZZ1.STATE_CODE STATE_CODE, ZZ1.FINGERPRINT_FLG FINGERPRINT_FLG, ZZ1.ADMIN_CRT ADMIN_CRT, ZZ1.COMMISSARY_RESTRICTED_HOURS COMMISSARY_RESTRICTED_HOURS, ZZ1.RESTRICT_COMMISSARY RESTRICT_COMMISSARY, ZZ1.REC_ID REC_ID, ZZ1.ARREST_CHARGE_CODE ARREST_CHARGE_CODE, ZZ1.DV_FLAG DV_FLAG, ZZ1.REQUIRE_TYPE_FLAG REQUIRE_TYPE_FLAG, ZZ1.REQUIRE_CLASS_FLAG REQUIRE_CLASS_FLAG, ZZ1.DEFAULT_ON_ENTRY_FLAG DEFAULT_ON_ENTRY_FLAG FROM ZZ_CHARGE_CODES ZZ1 union all select sysdate, 'C', null, null, ZZ2.CODE, ZZ2.STATUTE, ZZ2.CHARGE_CLASS_CODE, ZZ2.CHARGE_CATEGORY_CODE, ZZ2.CHA_DESC, ZZ2.ADDCHG, ZZ2.APR, ZZ2.AOSEQ, ZZ2.ACT, ZZ2.EFFDATE, ZZ2.INADATE, ZZ2.SOS, ZZ2.BOI, ZZ2.REMARKS, ZZ2.INA, ZZ2.LUPDATE, ZZ2.SUFFCK, ZZ2.CHAPTER, ZZ2.SECTION, ZZ2.MVRDATE, ZZ2.STATUTE_NEW, ZZ2.SHORT_LIST, ZZ2.OFFNS_CD_OFFENSE_CODE, ZZ2.DISPLAY_FLAG, ZZ2.SPEEDING_FLAG, ZZ2.SUSPEND_FLAG, ZZ2.VARIABLE_FINE_FLAG, ZZ2.FINE, ZZ2.STATE_CODE, ZZ2.FINGERPRINT_FLG, ZZ2.ADMIN_CRT, ZZ2.COMMISSARY_RESTRICTED_HOURS, ZZ2.RESTRICT_COMMISSARY, ZZ2.REC_ID, ZZ2.ARREST_CHARGE_CODE, ZZ2.DV_FLAG, ZZ2.REQUIRE_TYPE_FLAG, ZZ2.REQUIRE_CLASS_FLAG, ZZ2.DEFAULT_ON_ENTRY_FLAG FROM CHARGE_CODES ZZ2 where exists ( select * from ZZ_CHARGE_CODES where CODE= ZZ2.CODE )
 
Possibly Referenced Tables/Views:
CHARGE_CODES ZZ_CHARGE_CODES 


Close relationships: