| Table Name: | act_entry |
| Table Number: | 21 |
| Group: | Customer Mgr |
| Description: | Activity log object which acts as the audit trail of cases, subcases, solutions, parts, sites, employees, part requests and change requests |
| Flags: | CACHEOBJIDS |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| act_code | LONG | int | DIRECT | Activity code for the activity log entry; internally assigned with a unique code for each type of activity | Search (24) | |||
| addnl_info | CHAR | varchar | 255 | Additional information about activity log entry | Search (23) | |||
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| entry_time | CLK_TIME | datetime | Date and time of entry into activity log | Search (23) | ||||
| focus_lowid | LONG | int | DIRECT, ALLOW_NULL | Internal record number of the default drill down object for the event | Search (6) | |||
| focus_type | LONG | smallint | DIRECT, ALLOW_NULL | Object type ID of the default drill down object for the event | Search (6) | |||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (27) | ||
| proxy | CHAR | varchar | 30 | Login name of the user that performed the activity on behalf of another user via the Switch User feature | ||||
| removed | LONG | int | 0 | DIRECT | Contains encoded information used by DWE transport server. Reserved; future |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| act_entry_child2parent | OTOP | act_entry | act_entry_parent2child | For subcase close, links from the activity log entry on the subcase to the duplicate activity log entry in the parent case | |||
| act_entry_parent2child | OTOF | act_entry | act_entry_child2parent | For subcase close, links from the activity log entry on the parent case to the duplicate activity log entry in the child subcase | |||
| act_entry2biz_cal_hdr | MTO | biz_cal_hdr | biz_cal_hdr2act_entry | Activity log entries for the business calendar. Reserved | Search (1) | ||
| act_entry2bug | MTO | bug | bug2act_entry | Activity log entries for the change request | Search (1) | ||
| act_entry2case | MTO | case | case_act2act_entry | Activity log entries for the case | Search (5) | ||
| act_entry2close_bug | OTOF | close_bug | close_bug2act_entry | Activity log entry for the change request closure activity | |||
| act_entry2close_case | OTOF | close_case | close_case2act_entry | Activity log entry for the case closure activity | |||
| act_entry2commit_log | MTO | commit_log | commit_log2act_entry | Activity log entries for the commitment log | |||
| act_entry2contact | MTO | contact | contact2act_entry | Activity log entries for the contact | Search (1) | ||
| act_entry2contr_itm | MTO | contr_itm | srvc_itm2act_entry | Services authorized by contract for the related case | |||
| act_entry2contract | MTO | contract | contr_act2act_entry | Activity log entries for the contract | Search (1) | ||
| act_entry2count_setup | MTO | count_setup | setup2act_entry | Related physical inventory count profile | |||
| act_entry2demand_dtl | MTO | demand_dtl | demand_dtl2act_entry | Activity log entries for the part request detail | Search (1) | ||
| act_entry2disptchfe | MTO | disptchfe | disptchfe2act_entry | Activity log entries for the engineer dispatch | |||
| act_entry2doc_inst | MTO | doc_inst | doc_inst2act_entry | Activity log entries for the document. Reserved; future | |||
| act_entry2email_log | MTO | email_log | email_log2act_entry | Activity log entries for the email log | Search (1) | ||
| act_entry2employee | MTO | employee | employee2act_entry | Activity log entries for the employee; change to work group or site | |||
| act_entry2escalation | MTO | escalation | escalate2act_entry | Reserved; obsolete | |||
| act_entry2exch_log | OTOP | exch_log | exch_log2act_entry | The exchange_log which holds additional details about the event | Search (1) | ||
| entry2exch_timebomb | OTM | exch_timebomb | bomb2act_entry | Related exchange time bombs | |||
| act_entry2exchange | MTO | exchange | exchange2act_entry | Activity log entries for the exchange | Search (1) | ||
| act_entry2fix_bug | OTOF | fix_bug | fix_bug2act_entry | Activity log entry for the change request fixed activity | |||
| entry_name2gbst_elm | MTO | gbst_elm | act_name2act_entry | Type of activity log entry from Clarify-defined pop up list | Search (23) | ||
| act_entry2job | MTO | job | job_act2act_entry | Activity log entries for the job | |||
| act_entry2module | OTM | module | module2act_entry | Activity log entries for the code module | |||
| act_entry2notes_log | MTO | notes_log | notes_log2act_entry | Activity log entries for the notes log entry | Search (1) | ||
| act_entry2onsite_log | MTO | onsite_log | onsite_log2act_entry | Activity log entries for the T&E summary | |||
| act_entry2opportunity | MTO | opportunity | opp2act_entry | Activity log entries for the opportunity | Search (1) | ||
| act_entry2part_trans | MTO | part_trans | part_trans2act_entry | Activity log entries for the part transaction | Search (1) | ||
| fact2participant | OTM | participant | participant2act_entry | Participants in the fact represented by the act_entry | |||
| act_entry2phone_log | MTO | phone_log | phone_log2act_entry | Activity log entries for the phone log entry | Search (4) | ||
| act_entry2probdesc | MTO | probdesc | probdesc2act_entry | Activity log entries for the solution | Search (1) | ||
| act_entry2reject_msg | MTO | reject_msg | reject_act2act_entry | Activity log entries for the case, bug, subcase, etc., rejection | Search (1) | ||
| act_entry2resrch_log | MTO | resrch_log | resrch_log2act_entry | Activity log entries for the research log entry | Search (3) | ||
| act_entry2schedule | MTO | schedule | schedule2act_entry | Activity log entries for changes to the employee or installed part schedule | Search (1) | ||
| act_entry2site | MTO | site | cust_loc2act_entry | Activity log entries for the site | Search (1) | ||
| act_entry2site_part | MTO | site_part | site_part2act_entry | Activity log entries for the installed part | Search (1) | ||
| act_entry2status_chg | OTOF | status_chg | status_chg2act_entry | Activity log entry for the CR, case, part request, or subcase status change event | |||
| act_xentry2subcase | OTOF | subcase | aux_subcase2act_entry | When a subcase is created there is a subcase-create activity log entry in the parent case. This is the entry for the subcase created event | |||
| act_entry2subcase | MTO | subcase | subcase2act_entry | Activity log entries for the subcase | Search (4) | ||
| act_entry2svc_intrup | OTM | svc_intrup | svc_intrup2act_entry | Reserved; obsolete | |||
| act_entry2task | MTO | task | task2act_entry | Activity log entries for the task | Search (1) | ||
| act_entry2to_do_entry | OTM | to_do_entry | to_do_entry2act_entry | Distribution tasks generated by the event | |||
| act_entry2todo | OTM | to_do_list | to_do2data | Replication request triggered by the activity. Reserved | |||
| act_entry2user | MTO | user | originator2act_entry | User that performed the logged activity | Search (23) | ||
| act_entry2workaround | MTO | workaround | workaround2act_entry | Activity log entries for the workaround. Reserved |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ae2rl0021 | act_entry2resrch_log | nonclustered located on PRIMARY |
| ind_act_code | act_code | nonclustered located on PRIMARY |
| ind_act_entry_child2parent | act_entry_child2parent, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2bug | act_entry2bug, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2case | act_entry2case, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2contact | act_entry2contact, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2contr_itm | act_entry2contr_itm, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2contract | act_entry2contract, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2demand_dtl | act_entry2demand_dtl, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2doc_inst | act_entry2doc_inst, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2exch_log | act_entry2exch_log, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2exchange | act_entry2exchange, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2notes_log | act_entry2notes_log, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2opportunity | act_entry2opportunity, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2part_trans | act_entry2part_trans, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2phone_log | act_entry2phone_log, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2probdesc | act_entry2probdesc, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2reject_msg | act_entry2reject_msg, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2schedule | act_entry2schedule, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2site | act_entry2site, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2site_part | act_entry2site_part, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2subcase | act_entry2subcase, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2task | act_entry2task, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2user | act_entry2user, objid | nonclustered, unique located on PRIMARY |
| ind_act_entry2workaround | act_entry2workaround, objid | nonclustered, unique located on PRIMARY |
| ind_entry_name2gbst_elm | entry_name2gbst_elm, objid | nonclustered, unique located on PRIMARY |
| ind_entry_time | entry_time | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| act_entry | |||