| View Name: | cas_secure |
| View Number: | 303 |
| Group: | WebSupport |
| Description: | View which supports case level security in WebSupport |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
(double-click a column header to select column text)
View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| case_id | case | id_number | Unique case number assigned based on auto-numbering definition | |
| case_objid | case | objid | Case internal record number | |
| case_title | case | title | Case or service call title; summary of case details | |
| contact_objid | contact | objid | Contact internal record number | |
| creation_time | case | creation_time | The date and time the case was created | |
| first_name | contact | first_name | Contact first name | |
| last_name | contact | last_name | Contact last name | |
| phone | contact | phone | Contact phone number which includes area code, number, and extension | |
| primary_site | contact_role | primary_site | Indicates the site where the contact is located | |
| role_name | contact_role | role_name | Role name | |
| role_objid | contact_role | objid | Contact_role internal record number | 3 (UNIQUE) |
| site_id | site | site_id | Site ID number assigned according to auto-numbering definition | |
| site_name | site | name | Site name | |
| site_objid | site | objid | Site internal record number |
Join From | Join To |
|---|---|
| (case).case_reporter2site | (site).cust_loc2case |
| (contact_role).contact_role2site | (site).site2contact_role |
| (contact_role).contact_role2contact | (contact).contact2contact_role |
| cas_secure | |||