Tables [dbo].[Recording_Format_DE]
Recording format for dictations
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Recording_Format_DE_ID: IDID[dbo].[dict_id]5NOT NULL1 - 1Key to the Recording_Format_DE table
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_Recording_Format_DE_DefinitionSetID_EntryName_IsCurrentFLAGDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Entry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes NIX_Recording_Format_DE_EntryCode_WithIncludeColumns, NIX_Recording_Format_DE_EntryMnemonic_WithIncludeColumns, NIX_Recording_Format_DE_EntryName_WithIncludeColumns(3)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Indexes NIX_Recording_Format_DE_EntryCode_WithIncludeColumns, NIX_Recording_Format_DE_EntryMnemonic_WithIncludeColumns, NIX_Recording_Format_DE_EntryName_WithIncludeColumns, TWstat_Recording_Format_DE_DefinitionSetID_EntryName_IsCurrentFLAG, TWstat_Recording_Format_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG(5)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes NIX_Recording_Format_DE_EntryCode_WithIncludeColumns, NIX_Recording_Format_DE_EntryMnemonic_WithIncludeColumns, NIX_Recording_Format_DE_EntryName_WithIncludeColumns(3)EntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique
Indexes NIX_Recording_Format_DE_EntryCode_WithIncludeColumns, NIX_Recording_Format_DE_EntryMnemonic_WithIncludeColumns, NIX_Recording_Format_DE_EntryName_WithIncludeColumns, TWstat_Recording_Format_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG(4)Check Constraints CK_Recording_Format_DE_IsInactiveFLAG_Yes_Or_No : ([IsInactiveFLAG]='N' OR [IsInactiveFLAG]='Y')IsInactiveFLAG[dbo].[BOOL]1NOT NULLY=row is not active; N=row is active.  (Rows are inactivated rather than deleted for history)
Check Constraints CK_Recording_Format_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Indexes NIX_Recording_Format_DE_EntryCode_WithIncludeColumns, NIX_Recording_Format_DE_EntryMnemonic_WithIncludeColumns, NIX_Recording_Format_DE_EntryName_WithIncludeColumns, TWstat_Recording_Format_DE_DefinitionSetID_EntryName_IsCurrentFLAG, TWstat_Recording_Format_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG(5)Check Constraints CK_Recording_Format_DE_IsCurrentFLAG_Yes_Or_No : ([IsCurrentFLAG]='N' OR [IsCurrentFLAG]='Y')IsCurrentFLAG[dbo].[BOOL]1NOT NULLUsually 'Y' but occasionally used to subordinate rows.  Not exposed to the end user.
EffectiveDTdatetime8NULL allowedTime of last modification  (not "when this row goes into effect")
Formatvarchar(20)20NOT NULL('')Format type
FormatTagsmallint2NOT NULL(0)Format Tag
Channelssmallint2NOT NULL(0)Channels Supported
SamplesPerSecint4NOT NULL(0)Recording Samples per sec
AvgBytesPerSecint4NOT NULL(0)Average Bytes per sec
BlockAlignsmallint2NOT NULL(0)Block Align
BitsPerSamplesmallint2NOT NULL(0)Number of bits per sample
Sizesmallint2NOT NULL(0)Size
SamplesPerBlocksmallint2NOT NULL(0)Samples per block