Dict-Physical

Table MD_ColleagueBudgetSecurity

Card of table MD_ColleagueBudgetSecurity

Name	MD_ColleagueBudgetSecurity
Dimensional Type	Dimension
Comment	This "dimension" is used internally to handle business-office budget security in SQL Server Analysis Services. It is not to be used for reporting purposes. It simply answers the question: Can user X view budget Y. User X is identified by both a Colleague ID and a NetID. The NetID is assumed to be the also the ADS login ID. E.g., 'rgoerwit' is assumed to correspond to ads\rgoerwit. Again, this dimension is meant for data-warehouse-internal consumption and administrativa.

Check constraint name of the table MD_ColleagueBudgetSecurity

CKT_MD_COLLEAGUEBUDGETSECURITY

List of referencing views of the table MD_ColleagueBudgetSecurity

VW_GLInfoWithDynamicSecurity

VW_GLINFOWITHDYNAMICSECURITY

List of diagrams containing the table MD_ColleagueBudgetSecurity

DimsOtherDiagrams

List of columns of the table MD_ColleagueBudgetSecurity

MD_BudgSec_SurrogateKey

<None>

numeric

MD_BudgSec_14DigitCode

14-digit GL account code. For more information on GL codes, see the MD_GLAccount dimension (in the StarsBusiness package).

Do not use this field for reporting, at least not here, using this dimension. Use MD_GLAccount instead.

DW_GLCode

varchar(30)

MD_BudgSec_ColleagueID

The 7-digit Colleague ID. Do not use this field for reporting. If you need to access the Colleague ID, do it via the appropriate 'people' dimension (on which, see the DimsPeople package).

This entire dimension is used purely for data-warehouse-internal security.

DW_ColleagueID

char(7)

MD_BudgSec_NetID

The user's NetID, i.e., the user's general Carleton login ID. Do not use this field for reporting. If you need to access the NetID, do it via the appropriate 'people' dimension (on which, see the DimsPeople package).

This entire dimension is used purely for data-warehouse-internal security.

DW_NetID

nvarchar(128)

128

MD_BudgSec_AuditKey

DW_AuditKey

bigint

MD_BudgSec_Timestamp

<None>

timestamp