| objid | subcase | objid | Subcase internal record number | 3 (UNIQUE) |
| id_number | subcase | id_number | Unique ID number for the subcase; consists of case number-# | |
| title | subcase | title | Subcase title | |
| description | subcase | description | Subcase description | |
| required_date | subcase | required_date | Date and time task must be completed | |
| creation_time | subcase | creation_time | The date and time the subcase was created | |
| behavior | subcase | behavior | Internal field indicating the behavior of the subcase type; i.e., 1=normal, 2=administrative subcase | |
| sub_type | subcase | sub_type | Subcase type; general or administrative | |
| elapsed_time | subcase | elapsed_time | Elapsed time in seconds | |
| warning_time | subcase | warning_time | Date and time of commitment warning | |
| priority | gse_priority(gbst_elm) | objid | Subcase priority internal record number | |
| severity | gse_severity(gbst_elm) | objid | Subcase severity internal record number | |
| status | gse_status(gbst_elm) | objid | Subcase status internal record number | |
| case_objid | case | objid | Case internal record number | |
| case_id_number | case | id_number | Unique Case number assigned based on auto-numbering definition | |
| case_title | case | title | Case or service call title; summary of case details | |
| contact_objid | contact | objid | Contact internal record number | |
| first_name | contact | first_name | Contact first name | |
| last_name | contact | last_name | Contact last name | |
| e_mail | contact | e_mail | Contact e-mail address | |
| phone | contact | phone | Contact's phone number which includes area code, number, and extension | |
| condition_objid | condition | objid | Condition internal record number | |
| condition_code | condition | condition | Code number for subcase condition | |
| condition_title | condition | title | Subcase condition | |
| owner_objid | user | objid | Subcase owner's internal record number | |
| owner | user | login_name | Subcase owner login name | |
| wipbin_objid | wipbin | objid | WIPbin internal record number | |
| wipbin_name | wipbin | title | WIPbin title | |
| queue_objid | queue | objid | Queue internal record number | |
| queue_name | queue | title | Name of the queue | |
| priority_title | gse_priority(gbst_elm) | title | Subcase priority title | |
| severity_title | gse_severity(gbst_elm) | title | Subcase severity title | |
| status_title | gse_status(gbst_elm) | title | Subcase status title | |