...
The below table shows you the default relationship which you can set up as a System Administrator.
Join Type | Data Object | Join Field | Foreign Data Object | Join Field | |
|---|---|---|---|---|---|
LEFT | Incident_IncidentDetails_STND | INCIDENTID | = | Incident_Review_STND | INCIDENTID |
...
If the compliance action is recurring, this new dataset will capture the data from the 'Action Progress Update' tab. The following fields are captured via this new dataset:
Field Name | Datatype | Remarks |
|---|---|---|
ACTIONID | Unique ID | This is a unique identifier for each Compliance Action and can be used to link with other datasets |
Action Name | Text | Title of the action |
COMPLIANCEID | Unique ID | This is a unique identifier for each compliance record and can be used to link with other datasets |
Compliance Title | Text | Title of the compliance |
Review Frequency | Text | Review frequency for the particular action |
Review Recurrence End By | DateTime | Date when the next review will end |
Last Reviewed By | Text | Person who last reviewed the action |
Last Reviewed Date | DateTime | When the action was last reviewed |
Next Review Date | DateTime | Date of the next review |
...