| Table Name: | onsite_log |
| Table Number: | 32 |
| Group: | Support |
| Description: | Log used for summarizing a user's time/expenses/and or materials consumed for a case, a subcase, or a parts request; e.g., onsite time, materials, etc |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| billable_exp | DECIMAL | decimal (19,4) | CURRENCY | Total T&E log expenses that are billable | Search (4) | |||
| billable_lbr | DECIMAL | decimal (19,4) | CURRENCY | Total billable labor costs | ||||
| billable_mtl | DECIMAL | decimal (19,4) | CURRENCY | Total material costs that are billable | ||||
| billable_time | LONG | int | DIRECT | Total T&E log elapsed time that is billable in seconds | Search (4) | |||
| creation_time | CLK_TIME | datetime | 1 | Date and time the T&E log was created | Search (5) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| internal_note | CHAR | varchar | 255 | Notes intended for internal use only | ||||
| last_modified | CLK_TIME | datetime | Date and time T&E log was last modified | |||||
| non_bill_exp | DECIMAL | decimal (19,4) | CURRENCY | Total T&E log expenses that are not billable | Search (4) | |||
| non_bill_lbr | DECIMAL | decimal (19,4) | CURRENCY | Total non-billable labor costs | ||||
| non_bill_mtl | DECIMAL | decimal (19,4) | CURRENCY | Total material costs that are not billable | ||||
| non_bill_time | LONG | int | DIRECT | Total T&E log elapsed time that is not billable in seconds | Search (4) | |||
| notes | CHAR | text | ALLOW_NULL | T&E log notes | ||||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (7) | ||
| perf_by | CHAR | varchar | 30 | Login name of the Person that performs the T&E task | Search (7) | |||
| removed | LONG | int | 0 | DIRECT | Indicates the logical removal of the log object; i.e., 0=present, 1=removed, default=0 | |||
| resolution | CHAR | varchar | 40 | Resolution code for T&E log. From user-defined pop up with default name RESOLUTION_CODE | ||||
| total_exp | DECIMAL | decimal (19,4) | CURRENCY | Total non-billable and billable expenses | Search (5) | |||
| total_lbr | DECIMAL | decimal (19,4) | CURRENCY | Total non-billable and billable labor costs | ||||
| total_mtl | DECIMAL | decimal (19,4) | CURRENCY | Total non-billable and billable material costs | Search (1) | |||
| total_time | LONG | int | DIRECT | Total elapsed time, both billable and non-billable in seconds | Search (6) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| onsite_log2act_entry | OTM | act_entry | act_entry2onsite_log | Related activity log entry | |||
| case_onsite2case | MTO | case | case_exps2onsite_log | Related case | Search (2) | ||
| detail_onsite2demand_dtl | MTO | demand_dtl | detail2onsite_log | Related part request | Search (2) | ||
| disfe_onsit2disptchfe | MTO | disptchfe | disptchfe2onsite_log | Related FE dispatch | Search (3) | ||
| onsite_doer2employee | MTO | employee | employee2onsite_doer | Employee who performed task; used if different from the user logging the information | |||
| onsite_log2exchange | MTO | exchange | exchange2onsite_log | Related exchange | |||
| onsite_log2expense | OTM | expense_log | expense2onsite_log | Related expense line items | |||
| onsite_log2mtl_log | OTM | mtl_log | mtl_log2onsite_log | Related material line items | |||
| onsite_log2part_inst | MTO | part_inst | part_inst2onsite_log | Related part instance | |||
| subc_onsite2subcase | MTO | subcase | subc_onsit2onsite_log | Related subcase | Search (2) | ||
| onsite_log2time | OTM | time_log | time2onsite_log | Related time line items | |||
| onsite_owner2user | MTO | user | originator2onsite_log | User that originated the T&E log |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_case_onsite2case | case_onsite2case | nonclustered located on PRIMARY |
| ind_detail_onsite2demand_dtl | detail_onsite2demand_dtl | nonclustered located on PRIMARY |
| ind_disfe_onsit2disptchfe | disfe_onsit2disptchfe | nonclustered located on PRIMARY |
| ind_onsite_doer2employee | onsite_doer2employee | nonclustered located on PRIMARY |
| ind_onsite_owner2user | onsite_owner2user | nonclustered located on PRIMARY |
| ind_subc_onsite2subcase | subc_onsite2subcase | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 275 | list_oslog | disptchfe, onsite_log |
| 358 | onsite_select | case, onsite_log |
| 360 | onsite_sub_lst | onsite_log, subcase |
| 5172 | list_drtime | demand_dtl, onsite_log, time_log |
| 5173 | list_drmatl | demand_dtl, mod_level, mtl_log, onsite_log, part_num |
| 6050 | onsite_dfe_case | case, disptchfe, onsite_log |
| 6051 | onsite_dfe_subc | disptchfe, onsite_log, subcase |
| onsite_log | |||