ComFeedback
Name: COM Feedback
Type: Application
Modules: COM-Investigator, COM-Representative
Description: List of feedback information, includes all customer information.
| Field | Documentation |
|---|---|
| FeedbackId | Unique identifier for a feedback. |
| FeedbackNumber | Unique identifier for a feedback. This is an alternative to FeedbackId. |
| DateReceived | Date when the feedback was received. Format: YYYYMMDD. |
| TimeReceived | Time when the feedback was received. Value is in seconds from midnight. |
| DateLogged | Date when the feedback was logged into the COM system. Format: YYYYMMDD. |
| TimeLogged | Time when the feedback was logged into the COM system. Value is in seconds from midnight. |
| CustomerFirstName | First name of the customer. May match with RegisteredUsers.FirstName. |
| CustomerLastName | Last name of the customer. May match with RegisteredUsers.LastName. |
| CustomerMiddleInitial | Middle initial of the customer. May match with RegisteredUsers.MiddleInitial. |
| CustomerAddress | Address of the customer. May match with RegisteredUsers.Address. |
| CustomerCity | Name of the city where the customer resides. May match with RegisteredUsers.City. |
| CustomerZipCode | Zip code of where the customer resides. May match with RegisteredUsers.ZipCode. |
| CustomerEmail | Email address of the customer. May match with RegisteredUsers.Email. |
| CustomerHomePhone | Home phone number of the customer. May match with RegisteredUsers.PhoneHome. |
| CustomerBusinessPhone | Business phone number of the customer. May match with RegisteredUsers.PhoneBusiness. |
| CallTaker | User name of the operator who logs the feedback. |
| CommunicationModeAbbr | Abbreviated name of the communication mode. This is an identifier from CommunicationModes.CommunicationModeAbbr. |
| ClientId | Client identifier from Clients.ClientId. This field is set when the customer is a PASS client. |
| ADA | Indicates if the customer's address is in an ADA polygon. |
| EveningPhone | Evening phone number of the customer. |
| CellPhone | Cell phone number of the customer. May match with RegisteredUsers.PhoneCell. |
| FaxNumber | Fax number of the customer. May match with RegisteredUsers.Faxnumber. |
| ClientMedicaid | Medical identifier for the PASS client. This information is from Clients.Medicaid. |
| ClientSSN | Social Security Number of the PASS client. This information is from Clients.SSN. |
| 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 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-definedd 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 decimal value. |
| UpdateStamp | Timestamp of when the feedback was last modified. |
| State | Name of the state where the customer is living. May match with RegisteredUsers.State. |
| RegisteredUserId | Registered user identifier from RegisteredUsers.RegisteredUserId. COM uses this identifier to get the customer's information. |
| StreetNo | Street number of the customer's address. May match with RegisteredUsers.SteetNo. |
| Unit | Unit number of the customer's address. May match with RegisteredUsers.Unit. |
| CustomerGender | Gender of the customer. May match with RegisteredUsers.Gender. |
| SiteName | Site name of the customer's address. May match with RegisteredUsers.siteName. |
| TitleId | TBD |