| Table Name: | workaround |
| Table Number: | 2 |
| Group: | Support |
| Description: | Contains resolutions to a problem |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| actions | LONG | int | DIRECT | Predefined actions to take. Reserved; future | ||||
| creation_time | CLK_TIME | datetime | 1 | The date and time the workaround was created | ||||
| description | CHAR | text | ALLOW_NULL | Description of workaround or resolution | ||||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| hits | LONG | int | DIRECT | Number of times resolution has been linked to a case | ||||
| id_number | CHAR | varchar | 4 | 32 | Unique ID number for the workaround; consists of solution number-# | |||
| objid | LONG | int | 3 | DIRECT | Internal record ID number | Search (6) | ||
| public_ind | LONG | smallint | 0 | DIRECT | The workaround is available for public view; i.e., 0=no, 1=yes, default=0, e.g., via Web Browser | |||
| title | CHAR | varchar | 2 | 80 | Title of resolution | Search (2) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| workaround2act_entry | OTM | act_entry | act_entry2workaround | Reserved; not used | |||
| solution2case | OTM | case | case_soln2workaround | The case that a workaround is linked to | |||
| wa_attch2doc_inst | OTM | doc_inst | attachment2workaround | Attachments related to the workaround | |||
| resolution2gbst_elm | MTO | gbst_elm | resolutn2workaround | Resolution classification: This is a Clarify-defined pop up list | |||
| workaround2probdesc | MTO | probdesc | probdesc2workaround | Solution the workaround is related to | Search (3) | ||
| workaround2template | OTM | template | tmplt2workaround | Templates using the workaround |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_workaround2probdesc | workaround2probdesc | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 56 | wipelm_case | case, condition, gbst_elm, site, user, wipbin, workaround |
| 59 | queelm_case | case, condition, gbst_elm, queue, site, user, workaround |
| 370 | pd_attch | doc_inst, doc_path, probdesc, workaround |
| 4619 | fc_bug_view | bug, bus_org, bus_site_role, case, gbst_elm, mod_level, part_num, probdesc, site, workaround |
| 4650 | fc_user_case_view | case, condition, contact, employee, gbst_elm, queue, site, user, wipbin, workaround |
| 5682 | probdesc2case | case, gbst_elm, probdesc, workaround |
| 5739 | case_overview | address, case, condition, contact, contact_role, contract, country, gbst_elm, mod_level, queue, site, site_part, user, workaround |
| workaround | |||