|
Name |
|
|
Dimensional Type |
<None> |
|
Comment |
Very simple utility table that helps us map a NetID (i.e., the username delivered to us as part of the security context created by an AD-based login) to a corresponding identifiers in key enterprise systems: Colleague ID, Advance ID, and/or Recruitment Plus (or Slate) ID. |
|
CKT_TB_NETIDEMPID |
|
Name |
Code |
|
Name |
|
Name |
Comment |
Domain |
Data Type |
Length |
|
TB_NetEmp_NetID |
|
DW_NetID |
nvarchar(128) |
128 |
|
TB_NetEmp_EUID |
Enterprise unique ID. Should not be used until Carleton installs a relatively long-term IdM system (which we have not as of 2011; instead we're using Sun IdM, which has been shelved by its new owner, Oracle). |
DW_NetID |
nvarchar(128) |
128 |
|
TB_NetEmp_ColleagueID |
|
DW_ColleagueID |
char(7) |
7 |
|
TB_NetEmp_AdvanceID |
|
DW_AdvanceID |
char(10) |
10 |
|
TB_NetEmp_CSGoldPKId |
Defined in Diebold OneCard system as 128-char VARCHAR2 (Oracle). |
<None> |
varchar(64) |
64 |
|
TB_NetEmp_LibraryPIN |
Defined in Diebold OneCard system as 128-char VARCHAR2 (Oracle). |
<None> |
varchar(128) |
128 |
|
TB_NetEmp_RecruitmentPlusPKID |
Can also be a Slate ID, in addition to a pre-2012 Recruitment Plus PKID. |
DW_RecruitmentPlusPKID |
int |
|
|
TB_NetEmp_AuditKey |
|
DW_AuditKey |
bigint |
|
|
TB_NetEmp_Timestamp |
|
<None> |
timestamp |
|
|
Name |
Unique |
Cluster |
Primary |
Foreign Key |
Alternate Key |
Table |
|
TB_NETIDEMPID_PK |
TRUE |
TRUE |
TRUE |
FALSE |
FALSE |
|
|
TB_NETIDEMPID_COLLID |
FALSE |
FALSE |
FALSE |
FALSE |
FALSE |
|
Name |
|
Identifier_1 |
|
|
|