- DATA VIEW NAME
- CLARIFY_ACTIVITY_LOG
- OVERVIEW
- This view contains the information from a Clarify case activity log, The activity log allows users to view the history of events with a particular case or sub case, such as phone calls, notes or actions taken. Personal information in the activity log should be regarded as confidential.
This View can be used in conjunction with the following views:
UW.CLARIFY_CASES - LOAD FREQUENCY
- Data is refreshed nightly. The daily load appends all activities of 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 the InfoAccess Home Page
- SPECIAL
CONSIDERATIONS - The view retains all information about Clarify Case Activity logs permanently.
- QUESTIONS
- Contact: Division of Information Technology Help Desk
Phone: 264-HELP (4357) - LAST UPDATED
- 5/2001– 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 |
|---|---|---|
| ID_NUMBER | CHAR (11) | ID number assigned to a case. Use to link to a case. |
| ACTIVITY | CHAR (80) | A defined Clarify event such as logging notes or case actions. Example: Case create. |
| ENTRY_TIME | DATE | The date time stamp of when the activity was entered into the clarify system. |
| DESCRIPTION | CHAR (255) | Full description of the activity being logged. |
| PROXY_ID | CHAR (8) | The logon of the person if acting for another performed the activity. |
| LOGIN_ID | CHAR (8) | The logon of the person performing the activity. |
| EXTRACT_DATE_TIME | DATE | The date and time these data were extracted. Format : YYYYMMDD HH24:MI:SS |