| View Name: | probdesc2case |
| View Number: | 5682 |
| Group: | Support |
| Description: | Cases linked to the Solution/PD; used by form Solution. Used in SolutionToCaseOverviewWB.java and solution_overview.jsp |
| 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_creation_time | case | creation_time | The date and time the case was created | |
| case_id_number | case | id_number | Unique case number assigned based on auto-numbering definition | |
| case_is_supercase | case | is_supercase | Indicates whether the case is a super or a victim case; i.e., 0=normal or victim case, 1=supercase | |
| case_objid | case | objid | Case internal record number | 3 (UNIQUE) |
| case_title | case | title | Case or service call title; summary of case details | |
| gse_priority_objid | gse_priority(gbst_elm) | objid | Gbst_elm internal record number | |
| gse_severity | gse_severity(gbst_elm) | objid | Gbst_elm internal record number | |
| gse_type | gse_calltype(gbst_elm) | objid | Gbst_elm internal record number | |
| priority | gse_priority(gbst_elm) | title | Case priority, Name of the item/element | |
| probdesc_id_number | probdesc | id_number | Unique ID number for the solution; assigned according to auto-numbering definition | |
| probdesc_objid | probdesc | objid | Solution/Probdesc internal record number | |
| severity | gse_severity(gbst_elm) | title | Case severity, Name of the item/element | |
| type | gse_calltype(gbst_elm) | title | Case title, Name of the item/element | |
| workaround_objid | workaround | objid | Workaround/Resolution internal record number | |
| workaround_title | workaround | title | Title of resolution |
Join From | Join To |
|---|---|
| (workaround).workaround2probdesc | (probdesc).probdesc2workaround |
| (case).case_soln2workaround | (workaround).solution2case |
| (case).respprty2gbst_elm | gse_priority(gbst_elm).resp_priority2case |
| (case).respsvrty2gbst_elm | gse_severity(gbst_elm).resp_severity2case |
| (case).calltype2gbst_elm | gse_calltype(gbst_elm).call_type2case |
| probdesc2case | |||