| DESIGNATIONSYSTEMID |
uniqueidentifier |
yes |
|
dbo.[DESIGNATION].[ID] |
| DESIGNATIONISACTIVE |
bit |
yes |
|
dbo.[DESIGNATION].[ISACTIVE] |
| DESIGNATIONPROJECTCODE |
nvarchar(100) |
yes |
|
dbo.[DESIGNATION].[PROJECTCODE] |
| DESIGNATIONNAME |
nvarchar(512) |
yes |
|
dbo.[DESIGNATION].[NAME] |
| DESIGNATIONLOOKUPID |
nvarchar(512) |
yes |
|
dbo.[DESIGNATION].[USERID] |
| DESIGNATIONPUBLICNAME |
nvarchar(512) |
yes |
|
dbo.[DESIGNATION].[VANITYNAME] |
| DESIGNATIONGLACCOUNTNUMBER |
nvarchar(512) |
yes |
|
dbo.[DESIGNATION].[ACCOUNTNUMBER] |
| PURPOSELEVEL1DIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL1ID] |
| PURPOSELEVEL2DIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL2ID] |
| PURPOSELEVEL3DIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL3ID] |
| PURPOSELEVEL4DIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL4ID] |
| PURPOSELEVEL5DIMID |
int |
yes |
|
Reference key to the purpose level dimension, derived from dbo.[DESIGNATION].[DESIGNATIONLEVEL5ID] |
| DESIGNATIONREPORT1CODE |
nvarchar(100) |
yes |
|
dbo.[DESIGNATIONREPORT1CODE].[DESCRIPTION] |
| DESIGNATIONREPORT2CODE |
nvarchar(100) |
yes |
|
dbo.[DESIGNATIONREPORT2CODE].[DESCRIPTION] |
| GLDEPARTMENT |
nvarchar(100) |
yes |
|
dbo.[GLDEPARTMENT].[NAME] |
| GLCODE |
nvarchar(100) |
yes |
|
dbo.[GLDEPARTMENT].[GLCODE] |
| VSECATEGORY |
nvarchar(70) |
yes |
|
dbo.[VSECATEGORY].[VSECATEGORY] |
| VSESUBCATEGORY |
nvarchar(100) |
yes |
|
dbo.[VSESUBCATEGORY].[NAME] |
| VSEPURPOSE |
nvarchar(20) |
yes |
|
dbo.[VSECATEGORY].[PURPOSETYPE] |
| VSEUSAGE |
nvarchar(20) |
yes |
|
dbo.[VSECATEGORY].[USAGETYPE] |
| DESIGNATIONUSE |
nvarchar(100) |
yes |
|
dbo.[DESIGNATIONUSECODE].[DESCRIPTION] |
| DESIGNATIONSTARTDATE |
datetime |
yes |
|
dbo.[DESIGNATION].[STARTDATE] |
| DESIGNATIONENDDATE |
datetime |
yes |
|
dbo.[DESIGNATION].[ENDDATE] |
| DESIGNATIONSTARTDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[DESIGNATION].[STARTDATE] |
| DESIGNATIONENDDATEDIMID |
int |
yes |
|
Reference key to the date dimension, derived from dbo.[DESIGNATION].[ENDDATE] |
| ISINCLUDED |
bit |
yes |
|
Flag indicating when data should be included in results. |
| ETLCONTROLID |
int |
yes |
|
ID generated through the ETL process. |
| SOURCEDIMID |
int |
yes |
|
Source system used. |
| SITEDIMID |
int |
yes |
|
Reference key to the site dimension, derived from dbo.[DESIGNATIONLEVEL].[SITEID] |
| SITESYSTEMID |
uniqueidentifier |
yes |
|
[dbo].[DESIGNATIONLEVEL].[SITEID] |