Skip to main content
Kinetic Community

KS_SAMPLE_Asset_Event_join

This form is an Inner join between the KS_SAMPLE_Asset (Primary) and the KS_SAMPLE_Event (Seconday) forms.  The join criteria uses the instanceId from the KS_SAMPLE_Asset 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
Asset_Request_ID Asset_Request_ID 1 Character KS_SAMPLE_Asset
Asset_instanceId Asset_instanceId 179 Character KS_SAMPLE_Asset
Asset_Description Asset_Description 707000000 Character KS_SAMPLE_Asset
Asset_Type Asset_Type 707000001 Character KS_SAMPLE_Asset
Asset_Tag Asset_Tag 707000002 Character KS_SAMPLE_Asset
Asset_Serial_Number Asset_Serial_Number 707000003 Character KS_SAMPLE_Asset
Asset_Notes Asset_Notes 707000004 Character KS_SAMPLE_Asset
Asset_Owning_Group Asset_Owning_Group 707000005 Character KS_SAMPLE_Asset
Asset_Owning_Person Asset_Owning_Person 707000006 Character KS_SAMPLE_Asset
Asset_Aquire_Date Asset_Aquire_Date 707000007 Date/Time KS_SAMPLE_Asset
Asset_Retire_Date Asset_Retire_Date 707000008 Date/Time KS_SAMPLE_Asset
Asset_Status Asset_Status 7 Selection KS_SAMPLE_Asset
Event_Event_Details Event_Event_Details 707000102 Character KS_SAMPLE_Event
Event_Event_End Event_Event_End 707000106 Date/Time 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_Type Event_Event_Type 707000101 Character 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_instanceId Event_instanceId 536870915 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
Event_Type Event_Type 707000100 Character 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.