Tables [dbo].[PhysicalManifestation_DE]
Definition of how documents can be stored. IE pdf, rtf, noteform… It's used so that code accessing different documents will know how to open them.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_PhysicalManifestation_DE_ID: IDCluster Key XAK1PhysicalManifestationDE: EntryName\IsCurrentFLAG\IDIndexes XAK2PhysicalManifestationDE, XAK3PhysicalManifestationDE, XAK4_PhysicalManisteations, TWstat_PhysicalManifestation_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_PhysicalManifestation_DE_Entry_EntryName_IsCurrentFLAG_ID, TWstat_PhysicalManifestation_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(6)ID[dbo].[dict_id]5NOT NULL1 - 1Key to the PhysicalManifestation_DE table.
EnterpriseEntryID[dbo].[uniqueid]9NOT NULLMaster (enterprise) dictionary surrogate key.  Points to Dictionary_Entry.EnterpriseEntryID
Indexes TWstat_PhysicalManifestation_DE_DefinitionSetID_EntryName_IsCurrentFLAG_IDDefinitionSetID[dbo].[dict_id]5NOT NULLPoints to Dict_Definition_Set.DefinitionSetID but is typically zero.
Indexes TWstat_PhysicalManifestation_DE_Entry_EntryName_IsCurrentFLAG_IDEntry[dbo].[dict_id]5NOT NULLCalculated during insert as rowcount + 1 from Dict_Definition_Set for this dictionary and set
Indexes XAK2PhysicalManifestationDE, XAK4_PhysicalManisteations(2)EntryCode[dbo].[code]10NOT NULLUnique alphanumeric code.  Brief but cryptic.
Cluster Key XAK1PhysicalManifestationDE: EntryName\IsCurrentFLAG\IDIndexes TWstat_PhysicalManifestation_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_PhysicalManifestation_DE_Entry_EntryName_IsCurrentFLAG_ID, TWstat_PhysicalManifestation_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(3)EntryName[dbo].[name]255NOT NULLUnique alphanumeric "friendly" display name
Indexes XAK3PhysicalManifestationDEEntryMnemonic[dbo].[code]10NOT NULLTypically the same as the Code value, but can be blank.  If present, it must be unique.
Indexes XAK4_PhysicalManisteations, TWstat_PhysicalManifestation_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(2)Check Constraints CK_PhysicalManifestation_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_PhysicalManifestation_DE_IsEnforcedFLAG_Yes_Or_No : ([IsEnforcedFLAG]='N' OR [IsEnforcedFLAG]='Y')IsEnforcedFLAG[dbo].[BOOL]1NOT NULLY=row is readonly;  N=row is modifiable
Cluster Key XAK1PhysicalManifestationDE: EntryName\IsCurrentFLAG\IDIndexes XAK2PhysicalManifestationDE, XAK3PhysicalManifestationDE, TWstat_PhysicalManifestation_DE_DefinitionSetID_EntryName_IsCurrentFLAG_ID, TWstat_PhysicalManifestation_DE_Entry_EntryName_IsCurrentFLAG_ID, TWstat_PhysicalManifestation_DE_IsInactiveFLAG_EntryName_IsCurrentFLAG_ID(5)Check Constraints CK_PhysicalManifestation_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")
Check Constraints CK_PhysicalManifestation_DE_DocumentSearchableFLAG_Yes_Or_No : ([DocumentSearchableFLAG]='N' OR [DocumentSearchableFLAG]='Y')DocumentSearchableFLAG[dbo].[BOOL]1NOT NULL('N')This doesn't mean anything to TouchWorks. It's use is in the cloud after the ETL pull for ease of reporting.