Lookup Table Definition
Column Name Type Allow Nulls Notes
LookupID int No  
LookupCode varchar(40) No  
LookupDesc varchar(256) Yes  
ActiveFlag varchar(1) No  
StartDate datetime Yes  
EndDate datetime Yes  
CreationDate datetime No  
CreatedBy nvarchar(256) No  
LastUpdateDate datetime No  
LastUpdatedBy nvarchar(256) No  
Lookup Value Table Definition
Column Name Type Allow Nulls Notes
LookupValueID int No  
LookupID int  No  
LookupValueCode varchar(40) No  
LookupValueDesc varchar(256) Yes  
Attribute1 varchar(128) Yes  
Attribute2 varchar(128) Yes  
Attribute3 varchar(128) Yes  
Attribute4 varchar(128) Yes  
Attribute5 varchar(128) Yes  
Attribute6 varchar(128) Yes  
Attribute7 varchar(128) Yes  
Attribute8 varchar(128) Yes  
Attribute9 varchar(128) Yes  
Attribute10 varchar(128) Yes  
ActiveFlag varchar(1) No  
StartDate datetime Yes  
EndDate datetime Yes  
CreationDate datetime No  
CreatedBy nvarchar(256) No  
LastUpdateDate datetime No  
LastUpdatedBy nvarchar(256) No