Synergy CSP Process Tables

E"PROJECT NAME""FORM NAME"

If the designed form is a table, the values of some form design objects are hosted on this table.

ID	bigint, not null	PK
FORMID	bigint, not null	The FK is associated with the ID column in the E"PROJECT NAME""FORM NAME" VR table.
VERSION	bigint, not null
DOCUMENTID	bigint, not null
UNIQUEID	nvarchar(50)	Unique id defined on the forma
CREATEDAT	datetimeoffset(7), not null	Creation date
CREATEDBY	bigint, not null	Creator user ID
MODIFIEDAT	datetimeoffset(7)	Date modified
MODIFIEDBY	bigint	Modified by user id
DELETEDAT	datetimeoffset(7)	Date of deletion
DELETEDBY	bigint	Deleted user id
MASKINPUT1		The column that contains the information entered into the MaskInput object on the form. The name MASKINPUT1 will vary according to the nomenclature given to the MaskInput object on the form.
LOOKUP1		The column in the Lookup object on the form that contains the type of the selected element. The name LOOKUP1 will vary depending on the naming given to the Lookup object on the form.
RADIO1		If the Radio object on the form is selected, it is the column that contains the selection. The name RADIO1 will vary according to the nomenclature given to the Radio object on the form.
CHECKBOX1		If a CheckBox object on the form is selected, it is the column that contains the selection. The name CHECKBOX1 will vary depending on the naming given to the CheckBox object on the form.
NUMBERBOX1		The column that contains the information entered in the NumberBox object on the form. The name NUMBERBOX1 will vary depending on the naming given to the NumberBox object on the form.
DATETIMEPICKER1		The column that contains the information entered in the DateTimePicker object on the form. The name DATETIMEPICKER1 will vary depending on the naming given to the DateTimePicker object on the form.
DATERANGEPICKER1_START		The column in the DateRangePicker object on the form that contains the information entered for the start date. The name DATERANGEPICKER1 will vary depending on the nomenclature given to the DateRangePicker object on the form.

DATERANGEPICKER1_END		The column in the DateRangePicker object on the form that contains the information entered for the end date. The name DATERANGEPICKER1 will vary depending on the nomenclature given to the DateRangePicker object on the form.
RATE1		The column that contains the value information selected in the Rate object on the form. The name RATE1 will vary according to the nomenclature given to the Rate object on the form.
TIMEPICKER1		The column that contains the selected date information in the TimePicker object on the form. The name TIMEPICKER1 will vary depending on the nomenclature given to the TimePicker object on the form.
SWITCH1		The column in which the active/passive information is contained in the Switch object on the form. The name SWITCH1 will vary according to the nomenclature given to the Switch object on the form.
BARCODE1		The column that contains the information shown in the Barcode object on the form. The name BARCODE1 will vary according to the nomenclature given to the Barcode object on the form.
SLIDER1		The column that contains the selected value information in the Slider object on the form. The name SLIDER1 will vary according to the nomenclature given to the Slider object on the form.
DOCUMENTMETADATA1		The column that contains the information shown in the DocumentMetadata object on the form. The name DOCUMENTMETADATA1 will vary depending on the nomenclature given to the DocumentMetadata object on the form.
USERMETADATA1		The column that contains the information shown in the UserMetadata object on the form. The name USERMETADATA1 will vary according to the nomenclature given to the UserMetadata object on the form.

E"PROJECT NAME""FORM NAME"ML

A table that contains objects on a form that have multilanguage capability.

ID	bigint, not null	PK
PARENTID	bigint, not null	The FK is associated with the ID column in the E"PROJECT NAME""FORM NAME" table.
CULTURE	nvarchar(50), not null
TEXTBOX1		The column that contains the information entered in the TextBox object on the form. The name TEXTBOX1 will vary according to the nomenclature given to the Textbox object on the form. If the object has multi-language input turned on, the information entered for the other language(s) is visible in the CULTURE column.
PASSWORD1		The column that contains the information entered in the Password object on the form. The name PASSWORD1 will vary according to the nomenclature given to the Password object on the form.
LOOKUP1		The column in the Lookup object on the form that contains the value of the selected element. The name LOOKUP1 will vary depending on the naming given to the Lookup object on the form.
TEXTAREA1		The column that contains the information entered in the TextArea object on the form. The name TEXTAREA1 will vary according to the nomenclature given to the TextArea object on the form. If the object has multi-language input turned on, the information entered for the other language(s) is visible in the CULTURE column.
SEACHBOX1		The column that contains the information entered in the SearchBox object on the form. The name SEACHBOX1 will vary depending on the nomenclature given to the SearchBox object on the form.
HTMLTEXTBOX1		This is the column that contains the information entered in the HTMLTextBox object on the form. The name HTMLTEXTBOX1 will vary depending on the nomenclature given to the HTMLTextBox object on the form. If the object has multi-language input turned on, the information entered for the other language(s) is visible in the CULTURE column.

E"PROJECT NAME""FORM NAME"RD

A table on the form that holds information about the files that are attached to the associated documents object.

ID	bigint, not null	PK
PARENTID	bigint, not null	FK, The form information to which it is linked. E"PROJECT NAME""FORM NAME" is associated with the ID column in the table.
CATEGORYID	bigint, not null	The FK is associated with the ID column in the RDC table E"PROJECT NAME""FORM NAME".
FILEID	bigint, not null	The ID of the file loaded into the Related documents object on the form.

E"PROJECT NAME""FORM NAME"RDC

A table that holds category information in the associated documents object on the form.

ID	bigint, not null	PK
KEY	nvarchar(50)	The unique ID information defined to the Category in the associated Docs object. E"PROJECT NAME""FORM NAME" is associated with the KEY column in the RDCML table.
PARENTID	bigint, not null
CONTROLID	nvarchar(50), not null	The column with the name of the Related Documents object where the category is defined.

E"PROJECT NAME""FORM NAME"RDCML

A table that holds the multilingual equivalents of the category information in the associated documents object on the form.

NAME	nvarchar(100), not null	The column of the category added to the Associated Documents object that contains the information typed in the "Category Name" field.
DESCRIPTION	nvarchar(250)	The column of the category added to the Associated Docs object that contains the information typed in the "Description" field.
ID	bigint, not null	PK
PARENTID	bigint, not null	FK, E"PROJECT NAME""FORM NAME" is associated with the ID column in the RDC table.
CULTURE	nvarchar(10), not null	In the Related documents object, the Category Name is the column (such as en-US) that indicates the culture in which the information entered in the Description field is written
KEY	nvarchar(50)	The unique ID information defined to the Category in the associated Docs object. E"PROJECT NAME""FORM NAME" is associated with the KEY column in the RDC table.

E"PROJECT NAME""FORM NAME"RDML

It is the table that holds the multi-language information of the description of the files added to the associated documents object on the form.

DESCRIPTION	nvarchar(250), not null	The column that contains the description information entered in the file uploaded to the associated Docs object.
ID	bigint, not null	PK
PARENTID	bigint, not null	The FK is associated with the ID column in the E"PROJECT NAME""FORM NAME" RD table.
CULTURE	nvarchar(10), not null	Culture information (such as en-US) where the description was entered

E"PROJECT NAME""FORM NAME"SL

It is the table that contains the name of the objects of type (Dropdown, Combobox, ListBox, RadioList, AutoComplete, Tagbox, Transfer) and the selected value on the form.

ID	bigint, not null	PK
PARENTID	bigint, not null	The DR is associated with the ID column in the E"PROJECT NAME""FORM NAME" table.
CONTROLID	nvarchar(50), not null	If there are any Dropdown, Combobox, ListBox, RadioList, AutoComplete, Tagbox, Transfer objects used in the form, this is the column with their name
VALUE	sql_variant, not null	If there are any Dropdown, Combobox, ListBox, RadioList, AutoComplete, Tagbox, Transfer objects used in the form, each of them is the column with the value of the selected item

E"PROJECT NAME""FORM NAME"SLML

E"PROJECT NAME""FORM NAME" is the table that contains the culture of the object in the CONTROLID column in the SL table, with the corresponding culture of the selected VALUE value.

ID	bigint, not null	PK
PARENTID	bigint, not null	FK, E"PROJECT NAME""FORM NAME" is associated with the ID column in the SL table.
CULTURE	nvarchar(10), not null	Culture name (such as en-US)
TEXT	nvarchar(500), not null	E"PROJECT NAME""FORM NAME" contains the caption of the selected VALUE value of the object in the CONTROLID column in the SL table.

E"PROJECT NAME""FORM NAME"_DataGrid (Static/Dynamic column, Data Source not selected)

This is the table that holds information entered in specific column types if the DataGrid object type on the form is selected as Dynamic and set to be queried-feed, or if static columns are created without connecting queries.

ID	bigint, IDENTITY(1,1), not null	PK
PARENTID	bigint, not null	The FK is associated with the ID column in the E"PROJECT NAME""FORM NAME" table.
CREATEDAT	datetimeoffset(7)	Creation date
CREATEDBY	bigint	The creator is associated with the ID column in OSUSERS.
MODIFIEDAT	datetimeoffset(7)	Date modified
MODIFIEDBY	bigint	Modified by user id
DELETEDAT	datetimeoffset(7)	Date of deletion
DELETEDBY	bigint	Deleted user id
NUMBER, BOOLEAN, DATETIME, DATE, TIME		If columns of type Number, Boolean, DateTime, Date, Time were added to the Colums area in the DataGrid object, this is the column that contains that information.

E"PROJECT NAME""FORM NAME"_DataGridML

A table on the form that contains the information entered in a column of type Text in the DataGrid object.

ID	bigint, IDENTITY(1,1), not null	PK
PARENTID	bigint, not null	The DR is associated with the ID column in the E"PROJECT NAME""FORM NAME"_DataGrid table.
CULTURE	nvarchar(10), not null	Culture name (such as en-US)
TEXT		If a column of type Text was added to the Colums area of the DataGrid object, this is the column that contains the information.

E"PROJECT NAME""FORM NAME"_DataGridSL

Contains the value of the selected item in the column of type Select in the DataGrid object on the form

table.

ID	bigint, IDENTITY(1,1), not null	PK
PARENTID	bigint, not null	The DR is associated with the ID column in the E"PROJECT NAME""FORM NAME"_DataGrid table.
CONTROLID	nvarchar(50), not null	If a column of type Select was added to the Colums area of the DataGrid object, it is the column that contains the name of the column that is being added.
VALUE		In the Colums field of the DataGrid object, the column added as the Select type is the column that contains the information written in the Value field of the selected item.

E"PROJECT NAME""FORM NAME"_DataGridSLML

A DataGrid object on a form that contains the text of the selected item in a column of type Select

table.

ID	bigint, IDENTITY(1,1), not null	PK
PARENTID	bigint, not null	The E is associated with the ID column in the "PROJECT NAME""FORM NAME" _DataGrid1SL table.
CULTURE	nvarchar(10), not null	Culture name (such as en-US)
TEXT	nvarchar(500)	EInformation written in the text part of the value in the "PROJECT NAME""FORM NAME" _DataGrid1SL table

E"PROJECT NAME""FORM NAME"_DataGrid (Associated Data Grid)

The table on the form that holds the information in the DataGrid object whose data source type is selected as "Related".

ID	bigint, IDENTITY(1,1), not null	PK
PARENTID	bigint, not null	The FK is associated with the ID column in the E"PROJECT NAME""FORM NAME" table.
RELATIONDOCUMENTID		The form ID with which the object is bound
CREATEDAT	datetimeoffset(7)	Creation date
CREATEDBY	bigint	The creator is associated with the ID column in OSUSERS.
MODIFIEDAT	datetimeoffset(7)	Date modified
MODIFIEDBY	bigint	Modified by user id
DELETEDAT	datetimeoffset(7)	Date of deletion
DELETEDBY	bigint	Deleted user id

E"PROJECT NAME""FORM NAME"_Scheduler

A table on the form that holds date information for tasks that are added in the Scheduler object.

ID	bigint, IDENTITY(1,1), not null	PK
PARENTID	bigint, not null	The FK is associated with the ID column in the E"PROJECT NAME""FORM NAME" table.
STARTDATE		Plan start date information added to the Scheduler object
ENDDATE		Plan end date information added to the Scheduler object
CREATEDAT	datetimeoffset(7)	Creation date
CREATEDBY	bigint	The creator is associated with the ID column in OSUSERS.
MODIFIEDAT	datetimeoffset(7)	Date modified
MODIFIEDBY	bigint	Modified by user id
DELETEDAT	datetimeoffset(7)	Date of deletion
DELETEDBY	bigint	Deleted user id

E"PROJECT NAME""FORM NAME"_SchedulerML

A table on the form that holds the description information entered for the tasks that are added to the Scheduler object.

ID	bigint, IDENTITY(1,1), not null	PK
PARENTID	bigint, not null	The FK is associated with the ID column in the E"PROJECT NAME""FORM NAME"_Scheduler table.
CULTURE	nvarchar(10), not null	Cultural knowledge (such as en-TR)
TITLE	nvarchar(500)	Description information written to the plan that is added to the Scheduler object

E"PROJECT NAME""FORM NAME"VR

The table that contains the version information of the form.

ID	bigint, IDENTITY(1,1), not null	The PK can be associated with the FORMID column in the EPROJECT NAME""FORM NAME" table.
VERSION	bigint, not null	E "PROJECT NAME""FORM NAME" can be associated with the VERSION column in the table.

1. System Tables

DOCUMENTS

It is the table where information about the documents created in the CSP system is kept.

ID	bigint, not null	The PK is associated with the DOCUMENTID column in the form table that begins with E for the Process.
PROJECT	nvarchar(255), not null	Name of the process that owns the document
FORM	nvarchar(255), not null	Form name
UNIQUEID	nvarchar(255)	Customized document number with defined format
CREATEDBY	bigint, not null	The document creator is associated with the ID column in the OSUSERS table.
CREATEDELEGATEDBY	bigint
CREATEDAT	datetimeoffset(7), not null	Document created
DELETEDBY	bigint	The person who deleted the document is associated with the ID column in the OSUSERS table.
DELETEDAT	datetimeoffset(7)	Document deleted date
DELETEDELEGATEDBY	bigint
STATUS	int
MODIFIEDBY	bigint
MODIFYDELEGATEDBY	bigint
MODIFIEDAT	datetimeoffset(7)

OSUSERS

A table that contains the users in the system and some information about the users. It can also be used by JOINING with other tables starting with the OS.

ID	int, IDENTITY(1,1), not null	PK, User ID
USERNAME	nvarchar(50), not null	User Registry
FIRSTNAME	nvarchar(50), not null	Name
LASTNAME	nvarchar(50), not null	Surname
PASSWORD	nvarchar(255), not null	Password
EMAIL	nvarchar(200), not null	E-mail
STATUS	int, not null	Information indicating whether the user is active or passive 0: Passive 1: Active
TYPE	int	User type 0: Normal 1:Custom
IMPORTSTATUS	int	Information showing whether it will come from Human Resources transfer 0:Passive 1:Active
BIRTHDATE	datetimeoffset(7)	Date of birth
EMPLOYEMENTSTART	datetimeoffset(7)	Employment start date
EMPLOYEMENTEND	datetimeoffset(7)	Quit your job
CATEGORY	int	User category 0: Blue Collar 1: White Collar
SEX	int	User Gender 0: Female 1:Male
DEPARTMENT	int, not null	The business unit code that the user is in is associated with the ID column in the OSDEPARTMENTS table
PROFESSION	int, not null	The user's title code is associated with the ID column in the OSPROFESSIONS table

PROJECTS

This is the table that contains the project properties.

ID	nvarchar(38), not null	PK
NAME	nvarchar(100), not null	Project Name
CREATEDBY	bigint, not null	The person who created the project writes the information in the ID column in the OSUSERS table.
CREATEDELEGATEDBY	bigint
CREATEDAT	datetimeoffset(7), not null	Project creation date
PROJECTPATH	nvarchar(250)	The directory where the project is located
STATUS	bit, not null	Project active or passive information Active: 1 Passive: 0
BUILDVERSION	int, not null	Build version of the project
DEPLOYMENTID	bigint
FASTAPPROVE	bit, not null	Quick confirmation 0: Off 1: On

HIDEAPPROVALS	bit, not null	Hide approvers 0: Off 1: On
DELEGABLE	bit, not null	Power of Attorney Can Be Granted 0: Off 1: On
SHOWPARENTHISTORY	bit, not null	Show streaming history the moment it was connected 0: Off 1: On

PROCESSES

ID	bigint, not null	PK, Process number
PROJECTID	nvarchar(38), not null	Project ID. It is associated with the ID column in the Projects table.
FLOWID	nvarchar(38), not null	The flow ID used in the process.
DEPLOYMENTID	bigint, not null
USERID	int, not null	The ID of the user who started the process. It is associated with the ID column in the OSUSERS table.
DELEGATIONID	int	The user name that initiated the process by proxy. It is associated with the ID column in the OSUSERS table.
FLOWSTATUSID	bigint	The FK is associated with the ID column in the PROJECTFLOWSTATUSES table.
WORKFLOWINSTANCEID	nvarchar(38), not null
CREATEDATE	datetimeoffset(7), not null	Date the process was started
FINISHDATE	datetimeoffset(7)	Date the process was completed
LASTEXECUTEDATE	datetimeoffset(7), not null
DELETEDATE	datetimeoffset(7)	Date the process was deleted
PARENTPROCESSID	bigint	The process number of the main flow to which it is connected, if any

PROJECTFORMS

A table that contains forms designed in projects.

ID	nvarchar(38), not null	The PK is the ID of the Project form.
PROJECTID	nvarchar(38), not null	The FK is associated with the ID column in the PROJECTS table.
NAME	nvarchar(100), not null	Name of the form
FORMTYPE	int, not null	Form Type 0: Standard Form 1: Parameterized Form 2: Outlook Form 3: Checklist Form
IDFORMATID	bigint, not null	The form ID format selected in the Identity Format field in the Form Property Viewer
IDFORMAT	nvarchar(100), not null	The form identity format name selected in the Identity Format field in the Form Property Viewer
ALLOWCOPYPASTE	bit, not null
READONLY	bit, not null	Specifies whether the Read Only property on the form is active 0: Passive 1: Active
PRINTINGENABLED	bit, not null	Specifies whether printing the form is active 0: Passive 1: Active
PRINTVIEW	nvarchar(100), not null	Name of the view to print on the form
VERSIONINGENABLED	bit, not null	Indicates that the form versioning is not turned on

		0: Passive 1: Active

PROJECTFLOWS

A table that contains flows designed in projects.

ID	nvarchar(38), not null	PK, id of the project flow
PROJECTID	nvarchar(38), not null	The FK is associated with the ID column in the PROJECTS table.
NAME	nvarchar(100), not null	Name of the feed
APPROVERFORMID	nvarchar(38)

PROCESSREQUESTDOCUMENTS

It is the table with the details of the document defined in the process requests..

ID	bigint, identity(1,1),not null	PK
PROCESSREQUESTID	bigint, not null	The FK is associated with the ID column in the PROCESSREQUESTS table.
ORDERNO	int, not null
DOCUMENTID	bigint, not null	Document ID
FORMID	nvarchar(38), not null	The Id of the form. It is associated with the ID column in the PROJECTFORMS table.
DOCUMENTTYPE	int, not null
ALLOWEDIT	bit, not null	Can be modified information 0: Passive 1: Active
ISMODIFIED	bit, not null
DIGITALSIGNATURETYPE	int, not null
SHOWEVENTS	bit, not null	Data indicating whether events appear 0: Passive 1: Active
DIGITALSIGNATUREOPTIONS	nvarchar(max), not null	Digital signature information

PROCESSREQUESTS

This is the table that contains the steps of the process requests.

ID	bigint, IDENTITY(1,1), not null	PK
PROCESSID	bigint, not null	The FK is associated with the ID column in the PROCESSES table.
REQUESTTYPE	int, not null
STATUS	int, not null
EVENTID	int, not null	ID of the button used to perform operations in the process
EVENTFORMID	int	Event form ID information
OBJECTNAME	nvarchar(100), not null	Flow object information of the outgoing request
REQUESTDATE	datetimeoffset(7), not null	Date the request was made
RESPONSEDATE	datetimeoffset(7)	Date of response to request

POSITIONID	int	If the request was made with a position, position ID information
USERID	int	If the request was made with the user, the user ID information
DELEGATIONID	int
PROCESSSTEPID	bigint, not null
HIDDENTYPE	int
DELETEDFROMLIST	bit, not null
OWNEDREQUESTID	int
OWNEDENABLED	bit, not null
OWNEDDATE	datetimeoffset(7)
EVENTS	nvarchar(max)	On-object events
SHOWINHISTORY	bit	Show in stream history 0: Passive 1: Active
HIDEAPPROVER	bit	Indicates whether to hide approver information 0: Passive 1: Active
AUTOOPEN	bit	Turn approvals on auto confirm info 0: Auto on 1: Auto On
TIMEOUT	nvarchar(max)	Timeout information on object

PROJECTFLOWSTATUSES

This is the table that contains the details of the flow states in the project.

ID	bigint, not null	The PK is associated with the FLOWSTATUSID column in the PROCESSES table.
FLOWID	nvarchar(38), not null	The FK is associated with the ID column in the PROJECTFLOWS table.
DEPLOYMENTID	bigint, not null	The FK is associated with the ID column in the PROJECTDEPLOYMENTS table.
STATUSID	int, not null	Flow status ID number
ICON	nvarchar(100), not null	Image selected for streaming state
FLOWVIEW	nvarchar(100), not null	Flow view false: Flow view property not selected in the stream in the corresponding state true: Flow view property selected in the stream in the corresponding state

PROJECTFLOWSTATUSESML

A table that contains descriptions of flow states in the project by culture.

ID	bigint, not null	PK
FLOWSTATUSID	bigint, not null	The FK is associated with the ID column in the PROJECTFLOWSTATUSES table.
CULTURE	nvarchar(5), not null	Culture name
CAPTION	nvarchar(max)	Explanation of flow status in that culture