InvestigatorActions
Name: Investigator Actions
Type: Application
Modules: COM-Investigator, COM-Representative
Description: Actions taken for a particular COM feedback and subject.
| Field | Documentation |
|---|---|
| SourceType | Source of an action. For example, 'C' for COM actions, 'A' for OPS Absence. |
| ActionId | Unique identifier for investigator action. |
| SubjectId | Subject identifier from ComSubject.SubjectId. |
| ParentActionid | Parent action identifier from InvestigatorActions.ActionId. This field indicates the action from which a specific action is forwarded. |
| Sequence | Order number of action within a subject. |
| InvestigatorActionTypeId | Investigator action type identifier from InvestigatorActionTypes.InvestigatorActionTypeId. References the type of action. |
| ActionDate | Date when the action was taken. Format: YYYYMMDD. |
| ActionTime | Time when the action was taken. Value is in seconds from midnight. |
| InvestigatorName | Name of the investigator who takes the action. |
| InvestigatorPhone | Phone number of the investigator. |
| InvestigatorEmail | Email address of the investigator. |
| DateLogged | Date when the action detail was logged. |
| TimeLogged | Time when the action detail was logged. Value is in seconds from midnight. |
| IsActive | Indicates whether the action is active. |
| DepartmentAbbr | Department identifier from Departments.DepartmentAbbr. References the department the investigator belongs to. |
| InvestigatorId | Investigator identifier from Investigators.InvestigatorId. References who is taking the specific action. |
| CommunicationModeAbbr | Communication mode identifier from CommunicationModes.CommunicationModeAbbr. References the response method, e.g., email, fax, call, the investigator used to communicate with the customer. |
| DepartmentDescription | Description of the department. Value comes from Departments.DepartmentDescription. |
| DivisionId | Division identifier from MasterDivisions.DivisionId. References the division the investigator belongs to. |
| CallBackDetails | Callback details of a specific action. |
| PostResolutionFollowup | Post-resolution follow-up of a specific action. |
| PagerNumber | Pager number of the investigator. |
| UserString1 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString2 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString3 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString4 | User-defined string data, usually used as a supplementary field for a a short string. |
| UserString5 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString6 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString7 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString8 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString9 | User-defined string data, usually used as a supplementary field for a short string. |
| UserString10 | User-defined string data, usually used as a supplementary field for a short string. |
| UserLongString1 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString2 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString3 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString4 | User-defined string data, usually used as a supplementary field for a long string. |
| UserLongString5 | User-defined string data, usually used as a supplementary field for a long string. |
| UserShort1 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort2 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort3 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort4 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserShort5 | User-defined numeric data, usually used as a supplementary field for a small integer. |
| UserLong1 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong2 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong3 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong4 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserLong5 | User-defined numeric data, usually used as a supplementary field for a large integer. |
| UserDouble1 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble2 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble3 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble4 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UserDouble5 | User-defined numeric data, usually used as a supplementary field for a decimal value. |
| UpdateStamp | Timestamp of when the action was last modified. |
| InvestigationComplete | Indicates whether the action is completed. |
| EmployeeComment | The involved employee's comment on a specific action. |
| InvestigationText | The investigation details of a specific action. |
| InvestigatorComment | The investigator's comment on a specific action. |
| Recommendation | The investigator's recommendation. |
| InvestigationCompleteTimeStamp | Timestamp of when the investigation was completed. |