HealthSurveys
HealthSurveys
Columns
| Name | Type | Description |
| CreatedBy | String | The user ID of the person who created the record. |
| CreationDate | Datetime | Creation date that the record was created. |
| IncidentId [KEY] | Long | An identification value used for the incident. |
| IncidentDate | Datetime | The date when the incident had happened. |
| IncidentNo | String | The number of the incident that is being associated with the main incident. |
| ObjectVersionNumber | Int | Object version number for the survey. |
| LastUpdatedBy | String | The user ID of the person who last updated the record. |
| LastUpdateLogin | String | Last update login of the user. |
| LastUpdateDate | Datetime | The last date that the record was updated. |
| IncidentTypeCode | String | A label to indicate the type of incident recorded. For example a health and safety incident or a data security incident. |
| IncidentSummary | String | Audit Detail for Incident Summary. |
| IncidentSourceCode | String | A label to indicate the origin of the incident record. For example an incident generated using an API or an incident entered using the self-service kiosk pages. |
| IncidentReviewerEmailFlag | Bool | Incident reviewer email flag. |
| OffsiteLocTypeCode | String | A label to describe the category of the off-site location. |
| ReporterTypeCode | String | Indicates whether the person who is reporting the incident is an employee of the company or a non-employee. |
| ReptrCountry | String | The name of the country where the incident occurred. |
| ReptrCountryCodeNum | String | The phone country code for the incident reporter. |
| ReptrName | String | The incident reporter name. |
| ReptrEmail | String | The incident reporter email. |
| ReptrPhoneNo | String | The incident reporter phone number. |
| TargetCompletionDate | Datetime | The date that the investigation is targeted for completion. |
| QuestionnaireId | Long | An identification value used for the questionnaire owner |
| ReptrSpecificLocation | String | The incident reporter specific location. |
| EmployeeId | Long | Identification value of the employee. |
| ReptrNonempTypeCode | String | A label to describe if the incident reporter is an employee or nonemployee. |
| LocationId | Long | An identification value used for the location. |
| ReptrAreaCode | String | Label for the phone area code of the incident reporter. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |