Many tables in the EQuIS Schema (Reference Tables in particular) contain Status Flags, stored in a STATUS_FLAG field. In general, status flags are intended to control data entering the database, not to control data reported out of the database. For example, the STATUS_FLAG set for values in reference tables (e.g. RT_ANALYTE) can determine which values the EQuIS Data Processor (EDP) will make available to check against incoming EDDs. Some EDD formats may include additional checks of the status flag for data tables (those beginning with DT_). Data manually entered directly into EQuIS tables (i.e. not uploaded through EDP) may not be checked against status flags that would otherwise be applicable. The STATUS_FLAG typically does not control what data are available for reports.
However, there are several notable exceptions where the STATUS_FLAG field functions differently, described below. This table summarizes the expected behavior of the STATUS_FLAG in various tables:
Recognized Values
1.'A' means Active or Approved. This indicates that this is an accepted value and will behave normally in the database.*
2.'R' means Needs Review or Removed. This indicates that this is not an accepted value and will behave differently in the database.
3.'B', 'C', and 'D' are valid in some tables. The database typically treats B and D values the same as an 'R' value. For instance, in ST_USER, B = New Web Account Request and D = Disabled. In ST_USER_REPORT, the DQM Start Event Form's saved Check selections for the QAPP are saved as a user report with STATUS_FLAG = 'D'.
4.Values other than 'A', 'B', 'C', 'D', or 'R' are not acceptable in some tables. If they are allowed in a table, they will generally be treated the same as an 'R' value.
*Note: Action Level Forms only display action levels and action level types with STATUS_FLAG = A. |
DT_FACILITY
If a facility’s STATUS_FLAG is anything other than 'A', then it will not be available in the list of facilities when you open EQuIS Professional and connect to a facility. EDP does not prevent users from uploading data to a facility that has a status flag other than "A".
DT_LOCATION
EDP does NOT prevent users from loading data for locations with DT_LOCATION.STATUS_FLAG = 'R'.
VW_LOCATION, which is used in third party interfaces, will exclude locations where DT_LOCATION.STATUS_FLAG = 'R'. The reports that incorporate VW_LOCATION will still include these locations; however, the information derived from VW_LOCATION (such as LOC_NAME, X_COORD, Y_COORD, LONGITUDE, and LATITUDE) will not be populated in the reports. In addition, the LogPlot interface will include locations where DT_LOCATION.STATUS_FLAG= 'R'. Information derived from VW_LOCATION (such as LOC_NAME, X_COORD, Y_COORD, LONGITUDE, and LATITUDE) will not be populated'.
In EQuIS Sample Planning Module (SPM) V7.0.0.19046 or later, setting the dt_location.status_flag='R' will cause the sys_loc_code to not appear in the location selection lists in SPM. Those locations will not be available when choosing locations for planned samples.
DT_RESULT_DQM
DT_RESULT_DQM.STATUS_FLAG is not currently utilized in DQM.
DT_SAMPLE
DT_SAMPLE.STATUS_FLAG was added in an early version of SPM, but later removed. Newer databases will likely not include it.
RT_MTH_ANL_GROUP and RT_GROUP
The status flags in rt_mth_anl_group and rt_group provide the normal function of preventing data being uploaded via EDP for groups where the STATUS_FLAG= 'R', but these two status flags have additional functions.
1.By default, only groups with STATUS_FLAG= 'A' are displayed in the group list of the report user interface. Users can undo this functionality to show all groups, regardless of STATUS_FLAG value, by following the steps shown on this the page here.
2.The status flag in the Locations Group can hide locations from being displayed in SPM. The STATUS_FLAG can either be set in RT_GROUP (to hide an entire loc group) or in RT_GROUP_MEMBER (to hide individual locations).
ST_REPORT
This table stores standard function, procedure reports, and published reports. In this table, if the STATUS_FLAG is set to 'R', the report will no longer be visible as a selectable report from the Open Reports Dialog.
ST_USER
The STATUS_FLAG values in ST_USER should NOT be manually changed. Changes to ST_USER or to user accounts should be made through the User Manager Widget/Role Manager in EQuIS Enterprise. Additional information on how to accomplish this can be found in the User Manager Widget and User Profile Editor help articles.
In ST_USER, the STATUS_FLAG values are {A, B, C, D, R}:
1.'A' = Approved. For EQuIS Enterprise, the STATUS_FLAG for the user must be set to 'A' before the user may login to the web application or submit an EDD. Any other status is considered a disabled account, and the requested activity is prohibited.
For EQuIS Professional, the STATUS_FLAG for the user must be set to 'A' before the user may login using the Server Type: "EQuIS Enterprise Login". STATUS_FLAG has no effect in EQuIS Professional if using a SQL login.
2.'B' = New Web Account Request. When a new account is created through the EQuIS Enterprise web application, the STATUS_FLAG is set to 'B' until it is either Activated or Disabled by an administrator or through Auto Provisioning.
3.'C' = Limited. These records are created when an email address that does not belong to any existing users is entered in the Recipients list for EQuIS Information Agents (EIAs). This user type cannot log into the EQuIS database but can receive EIA emails and will appear in the User Manager.
4.'D' = Disabled. In Enterprise, this status indicates that an account is disabled. To preserve a history of activity (e.g., to know who submitted a particular EDD), Enterprise users are disabled instead of deleted. Disabling an account prevents login either to the EQuIS Enterprise web application or the EQuIS Professional Server Type: "EQuIS Enterprise Login". Disabled accounts are also prevented from submitting EDDs to the EQuIS Enterprise EDP Workflow Service and do not appear in the User Manager.
5.'R' = Needs Review. Typically reserved for disabled users or SQL logins (including the ALS Role credentials). Upon first logging into EQuIS Professional with an ALS role or a SQL Server user, a record is created in ST_USER using the SQL credentials and with a STATUS_FLAG value of 'R'. These entries should only be changed if the EQuIS Enterprise web application membership provider is configured to use an LDAP session manager.
ST_USER_REPORT
In ST_USER_REPORT, the STATUS_FLAG values are {A, C, D, R}:
1.'A' = Active
User Reports with STATUS_FLAG set to 'A' will be available in Enterprise and the base reports' drop-down list in Professional.
2.'C' = DQM Check Selections
DQM Check selections can be saved with the QAPP for a user. This will allow the selected checks to be chosen by default when the QAPP is selected again in the Start an Event Form.
3.'D' = DQM Event
When a DQM event is saved, a record is created with STATUS_FLAG of 'D' which distinguishes from a User Report created in the "DQM Exceptions Report by EDD Report".
4.'R' = Retired/Removed or Historic
Standard User Reports with STATUS_FLAG of 'R' will not be available in Enterprise and the base reports' drop-down list in Professional. Completed DQM Events are listed with STATUS_FLAG 'R'.