Data Access Rights Table

STEPforward controls access to data on the data field and user level. That is, every data field maintains an access mask for every user registered with STEPforward. The access masks are stored in SF_SYSDataAccess table that has the following structure:

Column Generalized data type Use
SF_TemplateName VARCHAR(8) Name of Global, Subledger or Transaction Template
SF_CloneName VARCHAR(8) Name of Template clone
SF_Type CHAR(1) Template type (base or clone)
SF_Domain CHAR(1) Domain of the Template (M or T)
SF_FieldName VARCHAR(31) System name of data field
SF_UserId VARCHAR(255) User Id of the registered user
SF_AccessCode TINYINT Access code
SF_TimeStamp SMALLINT Version of the row (incremented with each update)

Notes:

SF_CloneName is set to an empty string for base Templates.

SF_Type is a one-character code that marks the Template as being of the base (B) or clone (C) type.

SF_Domain is a one-character code that identifies the Template as belonging to the category of the accounting transaction data (T) or general data (M) which includes both Global and Subledger categories.

SF_FieldName is the system name of the data field.

SF_UserId is the login account of the registered user. Empty string in this field means "Other" account; those users whose login accounts are not recorded in SF_SYSDataAccess table are treated as "Other" users, and receive the access mask set for this user id (the default access mask).

SF_AccessCode sets specific type of access permitted to the user "SF_UserId" on the filed "SF_FieldName". The following access codes are valid:

0 No access (the field is blanked out)
1 Read only (no updates)
2 Read and write (full access)

The following is a partial sample of contents of SF_SYSDataAccess table:

SF_TemplateName SF_CloneName SF_Type SF_Domain SF_FieldName                    SF_UserId  SF_AccessCode
--------------- ------------ ------- --------- ------------------------------- ---------- -------------
Name                         B       M         Date_Time_Button                alex       1
Name                         B       M         Date_Time_Button                alexnet    1
Name                         B       M         Date_Time_Button                heidi      1
Name                         B       M         Date_Time_Button                helga      1
Name                         B       M         Date_Time_Button                hold       1
Name                         B       M         Date_Time_Button                wolf       1
Name                         B       M         Date_Time_Button                wr         1
Name                         B       M         Date_Time_Button                           1
Name                         B       M         History                         alex       2
Name                         B       M         History                         alexnet    2
Name                         B       M         History                         heidi      2
Name                         B       M         History                         helga      2
Name                         B       M         History                         hold       2
Name                         B       M         History                         wolf       2
Name                         B       M         History                         wr         2
Name                         B       M         History                                    2