SF_Cases Table
The SF_Cases table is probably the most important table in the Database, as it is the only one that contains the information that allows binding (or connecting) the other Tables in the context of time. The information required for the binding (or connecting) is as follows:
- ID for current CASE
- ID for Previous CASE
- StartTime and End Time
- Model
- Analysis
EXAMPLE: SF_Cases table example
When joining the 'SF_Case' table to the other Element tables, you are able to find data related to a desired time-span for a defined Model and Analysis (please review Create TSQL Queries for Report Development for additional information).
Note: The column "ID" in the 'SF_Case' table refers to the "CaseID" column in the other Element tables.
The table below provides pertinent information regarding the columns in the SF_Case table.
SF_Cases Table Columns
| Column | Type |
|---|---|
| ID (PK) | Nvarchar(40), not null |
| Description | Nvarchar(255), not null |
| StartTime | Datetime, not null |
| StartTimeUTC | Datetime, not null |
| EndTime | Datetime, not null |
| EndTimeUTC | Datetime, not null |
| Model | Nvarchar(40), not null |
| Analysis | Nvarchar(40), not null |
| Layers | Nvarchar(40), null |
| PreviousCase | Nvarchar(40), null |
| PublishTime | Datetime, null |
| PublishID | Nvarchar(40), null |
| PublishResult | Int, null |
| PublishUser | Nvarchar(128), null |
PublicationResults:
- 0 = Publication completed without errors
- 1 = Publication completed with errors
- 2 = Publication in progress