SF_ProcessTemplate
The table below provides pertinent information regarding the columns in the SF_ProcessTemplate table.
SF_ProcessTemplate Table Columns
| Column | Type |
|---|---|
| CaseID (PK, FK) | Nvarchar(40), not null |
| ID (PK) | Nvarchar(40), not null |
| Name | Nvarchar(128), null |
| Description | Nvarchar(128), null |
| Categories | Nvarchar(128), null |
| Layers | Nvarchar(128), null |
| ReconciledVolumeVariance | Float, null |
| ReconciledVolumeTest4 | Float, null |
| ReconciledVolumeTest3 | Float, null |
| ReconciledVolumeImbalance | Float, null |
| ReconciledResidual | Float, null |
| ReconciledMassVariance | Float, null |
| ReconciledMassTest4 | Float, null |
| ReconciledMassTest3 | Float, null |
| ReconciledMassImbalance | Float, null |
| ReconciledEnergyVariance | Float, null |
| ReconciledEnergyTest4 | Float, null |
| ReconciledEnergyTest3 | Float, null |
| ReconciledEnergyImbalance | Float, null |
| ReconciledComponentResults | Sql_variant, null |
| ObjectStatus | Nvarchar(252), null |
| InequalityBalanceFlag | Bit, null |
| HoldupProduct | Nvarchar(252), null |
| HoldupDensity | Float, null |
| Holdup | Float, null |
| EnergyBalanceFlag | Bit, null |
| Efficiency | Float, null |
| DocumentumCode | Nvarchar(252), null |
| DensityBalanceFlag | Bit, null |
| CostCenter | Sql_variant, null |
| ConstrainedComponentBalanceFlag | Bit, null |
| CompositionTrackingBalanceFlag | Bit, null |
| ComponentBalanceFlag | Bit, null |