Entity Care Team

DescriptionThis is an anchor entity that anchors one or more detail entities. Relationships in AWM are created between anchor entities using associative entities.

Attributes
Care Team BkCare Team Bk
Care Team Id NumCare Team Id Num
Care Team NmCare Team Nm
Care Team SkCare Team Sk
Load Info SkLoad Info Sk
Tenant SkTenant Sk

Primary Key
Care Team PKCare Team PK

Dependencies
 

Reverse Dependencies
 

Attribute Details

 Care Team Bk
DescriptionConcatenated values of a set of business attributes that uniquely identify the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Business Key [VARCHAR(255)]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Care Team Id Num
DescriptionUnique identifier for a Care Team
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Care Team Nm
DescriptionName of the Care Team
Data TypeStandards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Care Team Sk
DescriptionSurrogate key for the anchor entity.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeytrue
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keytrue



 Load Info Sk
DescriptionThe surrogate key of the load information entry describing the details regarding the loading of the row.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key Large [LONG]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse



 Tenant Sk
DescriptionThe surrogate key of the entry identifying the legal owner of the data.
Data TypeStandards - Data Domains.ddm/Data Domains/Surrogate Key [INTEGER]
Is Part Of PrimaryKeyfalse
Is Requiredtrue
Is Derivedfalse
Is Surrogate Keyfalse

Primary Key Details

 Care Team PK
Key AttributeCare Team Sk