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 |