| View Name: | fc_case_view |
| View Number: | 4615 |
| Group: | Support |
| Description: | |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Custom |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| elm_objid | victimcase(case) | objid | Case internal record number | 3 (UNIQUE) |
| id_number | victimcase(case) | id_number | Unique case number assigned based on auto-numbering definition | 4 |
| owner | owner(user) | login_name | User login name | 12 |
| condition | condition | title | Condition of the case | 7 |
| status | gse_status(gbst_elm) | title | Status of the case | 8 |
| title | victimcase(case) | title | Case or service call title; summary of case details | 2 |
| site_name | site | name | Name of the reporting site | |
| first_name | contact | first_name | Contact first name | |
| last_name | contact | last_name | Contact last name | |
| priority | gse_priority(gbst_elm) | title | Priority of the case | 35 |
| severity | gse_severity(gbst_elm) | title | Severity of the case | 36 |
| type | gse_type(gbst_elm) | title | Type of case | 37 |
| is_supercase | victimcase(case) | is_supercase | Flag if the case is a super case | |
| supercase_num | supercase(case) | id_number | Unique case number if it is related to a super case | |
| creation_time | victimcase(case) | creation_time | Case Creation Time | |
| role_name | bus_site_role | role_name | Name of the role | |
| role_objid | bus_site_role | objid | Internal record number | |
| org_id | bus_org | org_id | User-specified ID number of the organization | |
| org_name | bus_org | name | Name of the organization | |
| org_objid | bus_org | objid | Internal record number |
| Join From | Join To |
|---|---|
| victimcase(case).respsvrty2gbst_elm | gse_severity(gbst_elm).resp_severity2case |
| victimcase(case).case_reporter2site | (site).cust_loc2case |
| victimcase(case).case_owner2user | owner(user).curr_owner2case |
| (bus_site_role).bus_site_role2site | (site).site2bus_site_role |
| victimcase(case).respprty2gbst_elm | gse_priority(gbst_elm).resp_priority2case |
| victimcase(case).case_reporter2contact | (contact).caller2case |
| victimcase(case).calltype2gbst_elm | gse_type(gbst_elm).call_type2case |
| victimcase(case).casests2gbst_elm | gse_status(gbst_elm).case_status2case |
| victimcase(case).case_victim2case | OUTER supercase(case).super2case |
| victimcase(case).case_state2condition | (condition).case_condition2case |
| (bus_site_role).bus_site_role2bus_org | (bus_org).bus_org2bus_site_role |
| fc_case_view | |||