InfoAccess

  

DATA VIEW NAME

CLARIFY_SUBCASES

OVERVIEW 

This view provides basic information for subcases that were closed, and shows the relation to their main case.

LOAD FREQUENCY

Data View is refreshed nightly. The daily load appends all cases closed since the previous load.

DATA CUSTODIAN

DoIT Help Desk - Chris Holsman
DoIT User System Services –Chris Holsman

AUTHORIZATION

You must receive approval to access data from the data custodian.
 For information about how to get authorized for InfoAccess data views, connect to InfoAccess Home Page

SPECIAL CONSIDERATIONS

This view retains information for all closed subcases permanently.

QUESTIONS

Contact:  Division of Information Technology Help Desk
Phone:  264-HELP (4357)

LAST UPDATED

02/2005 – New view created.

DATA FORMATS

Primary Key Columns are identified with an asterisk(*)

Alphanumeric Data

VARCHAR2( N)  (N) = maximum length. Field contains letters and/or numbers. Trailing blanks are eliminated.
Example: VARCHAR2 (5) could contain ‘ABC12’ or  ‘ABC’ or ‘A’

Numeric Data

NUMBER (N) (N) = length. Field contains only numbers.
NUMBER (X,Y) =  format for numbers with decimal positions.
X = total number of digits Y = the number of digits after the decimal
Examples: NUMBER (6) represents 250012 NUMBER (6,2) represents 2500.12

Date

DATE  - Date can be in various formats. Date functions available with your query tool can be used to format the date. 
Examples:  DATE (YYYYMMDD), DATE (YYDDD), DATE (DD-MM-YY)

 

Column Name

Format

Description

*SUBCASE_ID

VARCHAR(16)

The ID number for the subcase.

PARENTCASE_ID

VARCHAR(11)

The ID number for the subcase’s parent case.

SUBCASE_CONDITION

VARCHAR(20)

Normally = ‘Closed’

SUBCASE_STATUS

VARCHAR(20)

Normally = ‘Closed’

SUBCASE_TITLE

VARCHAR(80)

The text for the subcase title.

*CREATION_DATETIME

DATE

The date time stamp when the subcase was entered into the clarify system.

CREATION_DATE

VARCHAR(8)

YYYYMMDD The creation date. Datestamp from Create_Datetime.

CREATION_TIME

VARCHAR(8)

HH24:MI:SS Timestamp from Create_Datetime.

SUBCASE_TYPE

VARCHAR(16)

Shows whether subcase is ‘General’ or ‘Administrative’.

CASE_SITEID

VARCHAR(80)

The SiteID for the parent case’s contact person.

CASE_SITENAME

VARCHAR(80)

The SiteName for the parent case’s contact person.

CASE_CONT_FNAME

VARCHAR(30)

The parent case contact’s first name.

CASE_CONT_LNAME

VARCHAR(30)

The parent case contact’s last name.

CLOSE_DATETIME

DATE

Date and time subcase was closed.
YYYYMMDD HH24:MM:SS

ORIGINATOR

VARCHAR(30)

Person who created the subcase.

OWNER

VARCHAR(30)

Person who owns (closes) the subcase.

EXTRACT_DATE_TIME

DATE

The date and time these data were extracted.
Format : YYYYMMDD HH24:MI:SS