Skip to main content
Kinetic Community

KS_SAMPLE_Compliance_Event_join

This form is an Inner join between the KS_SAMPLE_Compliance (Primary) and the KS_SAMPLE_Event (Seconday) forms.  The join criteria uses the instanceId from the KS_SAMPLE_Compliance form and joins to the Reference_Id on the KS_SAMPLE_Event form.  This form is used as a source form in the Kinetic Calendar application.

Details

This form contains the following fields:

 

Label Field ID Type Source Form
Compliance_Description Compliance_Description 707000000 Character KS_SAMPLE_Compliance
Compliance_Owning_Group Compliance_Owning_Group 707000005 Character KS_SAMPLE_Compliance
Compliance_Notes Compliance_Notes 707000004 Character KS_SAMPLE_Compliance
Compliance_Area Compliance_Area 707000001 Character KS_SAMPLE_Compliance
Compliance_Frequency Compliance_Frequency 707000002 Character KS_SAMPLE_Compliance
Compliance_instanceId Compliance_instanceId 179 Character KS_SAMPLE_Compliance
Compliance_Status Compliance_Status 7 Selection KS_SAMPLE_Compliance
Event_Type Event_Type 707000100 Character KS_SAMPLE_Event
Event_Event_Type Event_Event_Type 707000101 Character KS_SAMPLE_Event
Event_instanceId Event_instanceId 536870915 Character KS_SAMPLE_Event
Event_Event_Details Event_Event_Details 707000102 Character KS_SAMPLE_Event
Event_Event_Link Event_Event_Link 707000103 Character KS_SAMPLE_Event
Event_Event_Start Event_Event_Start 707000104 Date/Time KS_SAMPLE_Event
Event_Event_End Event_Event_End 707000106 Date/Time KS_SAMPLE_Event
Event_Generic_Field_1 Event_Generic_Field_1 707000107 Character KS_SAMPLE_Event
Event_Generic_Field_2 Generic_Field_2 707000108 Character KS_SAMPLE_Event
Event_Generic_Field_3 Event_Generic_Field_3 707000109 Character KS_SAMPLE_Event
Event_Reference_Id Event_Reference_Id 707000110 Character KS_SAMPLE_Event
Event_Request_ID Event_Request_ID 536870918 Character KS_SAMPLE_Event
Event_Status Event_Status 536870919 Selection KS_SAMPLE_Event

An Excel file containing this table is attached here.

If you would like to download and import this form into your Remedy environment the definition file can be downloaded here.