| Table Name: | appointment |
| Table Number: | 260 |
| Group: | Customer Mgr |
| Description: | Items on a schedule; the details of an employee's schedule or an installed part's maintenance schedule |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| cell_text | CHAR | varchar | 255 | Contains a concatenation of locally-selected fields for display by Schedule Tracker. Default is appointment sub_type with start time and end time | Search (2) | |||
| condition | LONG | int | DIRECT | Reserved; not used | ||||
| description | CHAR | varchar | 2 | 255 | Description of the appointment entry | Search (1) | ||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| duration | LONG | int | 6 | DIRECT | Length of appointment in seconds | Search (5) | ||
| end_time | CLK_TIME | datetime | 30 | End time of appointment | Search (4) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (5) | ||
| start_time | CLK_TIME | datetime | 29 | Start time of appointment | Search (5) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| appt2case | MTO | case | case2appt | For service interuption, case the appointment is logged against | |||
| appt2appt_type | MTO | gbst_elm | appt_type2appt | Class of appointment or responsible group/department; e.g., field service, training | Search (2) | ||
| appt2sub_type | MTO | gbst_elm | sub_type2appt | Type of appointment or kind of activity scheduled; e.g., preventive maintenance, warranty upgrade | Search (1) | ||
| appt2schedule | MTO | schedule | schedule2appt | Related schedule | Search (4) |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_appt2case | appt2case, appt2schedule | nonclustered located on PRIMARY |
| ind_appt2schedule | appt2schedule, appt2case | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 281 | appt_schedule | appointment, gbst_elm, schedule |
| 293 | site_svc_appt | appointment, gbst_elm, schedule, site, site_part |
| 395 | employee_appt | appointment, employee, schedule |
| 6017 | schdl_tracker_sub_v1 | address, appointment, employee, hgsl2hgse, site, user |
| 6022 | schdl_tracker_sub_v6 | address, appointment, employee, hgsl2hgse, site, user |
| appointment | |||