View slot9.WORLD.TSTA.CHARGE_OFFENSE_VW
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
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 318  √  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
OFFNS_CD_OFFENSE_CODE varchar2 30  √  null
OFFENSE_CODE varchar2 30  √  null
OFFENSE_CODES.OFFENSE_CODE Implied Constraint R
OFFENSE_DESC varchar2 255  √  null
SHORT_LIST varchar2 1  √  null

Analyzed at Mon Sep 20 21:05 MDT 2021

View Definition:
SELECT C.CODE , C.STATUTE , C.CHARGE_CLASS_CODE , C.CHARGE_CATEGORY_CODE , C.CHA_DESC || ',No Commissary for ' || nvl(C.COMMISSARY_RESTRICTED_HOURS, 0) || ' Hrs' CHA_DESC , C.ADDCHG , C.APR , C.AOSEQ , C.ACT , C.EFFDATE , C.INADATE , C.SOS , C.BOI , C.REMARKS , C.INA , C.LUPDATE , C.SUFFCK , C.CHAPTER , C.SECTION , C.MVRDATE , C.STATUTE_NEW , C.OFFNS_CD_OFFENSE_CODE , O.OFFENSE_CODE , O.OFFENSE_DESC , O.SHORT_LIST FROM CHARGE_CODES C, OFFENSE_CODES O, Charge_Class_codes CCC WHERE C.OFFNS_CD_OFFENSE_CODE = O.OFFENSE_CODE (+) AND CCC.charge_class_code = C.charge_class_code AND CCC.Charge_category_code = c.charge_category_code AND CCC.Display_flag = 'Y' AND c.Display_flag = 'Y' and nvl(C.COMMISSARY_RESTRICTED_HOURS, 0) > 0 UNION SELECT C.CODE , C.STATUTE , C.CHARGE_CLASS_CODE , C.CHARGE_CATEGORY_CODE , C.CHA_DESC , C.ADDCHG , C.APR , C.AOSEQ , C.ACT , C.EFFDATE , C.INADATE , C.SOS , C.BOI , C.REMARKS , C.INA , C.LUPDATE , C.SUFFCK , C.CHAPTER , C.SECTION , C.MVRDATE , C.STATUTE_NEW , C.OFFNS_CD_OFFENSE_CODE , O.OFFENSE_CODE , O.OFFENSE_DESC , O.SHORT_LIST FROM CHARGE_CODES C, OFFENSE_CODES O, Charge_Class_codes CCC WHERE C.OFFNS_CD_OFFENSE_CODE = O.OFFENSE_CODE (+) AND CCC.charge_class_code = C.charge_class_code AND CCC.Charge_category_code = c.charge_category_code AND CCC.Display_flag = 'Y' AND c.Display_flag = 'Y'
 
Possibly Referenced Tables/Views:
CHARGE_CLASS_CODES CHARGE_CODES OFFENSE_CODES 


Close relationships: