Note: This table contains the same data as the Casetype table.


Name Type Length Precision Scale References In Description
case_type_extid VARCHAR2 255 Case type external ID
case_type_id NUMBER 39 0 Case type ID
date_last_modified TIMESTAMP Date last modified
description VARCHAR2 200 Description
isinactive VARCHAR2 3 Whether the case type is inactive
name VARCHAR2 50 Name

Primary key

PK Column Name

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Support_incidents_case_types_fk case_type_id Support_incidents case_type_id 1