Result Set 7 - Sheet Columns

The following table lists the parameters used in a Sheet Columns Result Set.

Order	Field Name	Req	Values/Table Reference
0	Result Set Type	X	7
1	Sheet Id	X	Sheet_Columns (Sheet_Id) Sheets (Sheet_Id)
2	User Id	X	Sheet_Columns (User_Id) Users (User_Id). Allows a specific User_Id to be used and tracked. If not using a specific User_Id account then set it to 0 and the appropriate Service User_Id will be used.
3	Transaction Type	X	1 = Add 2 = Update 3 = Delete
4	Timestamp	X	Sheet_Columns (Result_On)
5	Update Type	X	0 – Pre Update. Database Manager writes to db and sends to client. 1 – Post Update. Data already in db and sent to clients only.
6	Approved User Id		Sheet_Columns.Approved_User_Id, Users.User_Id
7	Approved Reason Id		Sheet_Columns.Approved_Reason_Id, Reasons.Reason_Id
8	User Reason Id		Sheet_Columns.User_Reason_Id, Reasons.Reason_Id
9	User Sign Off Id		Sheet_Columns.User_Signoff_Id, Users.User_Id
10	ESignature		Signature ID from the ESignature table