Code_With_Categories

108597 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Code_id int identity 4 √ null
Code.Code_id Implied ConstraintR
Code_Code_Map.Left_Code_Id Implied ConstraintR
Code_Code_Map.Right_Code_Id Implied ConstraintR
Theraphy_Diagnosis.Diagnosis_Code_Id Implied ConstraintR
Code_Name varchar 50 null
Code_Value varchar 50 null
Code_Description varchar 255 √ null
Code_Category_Id int 4 √ null
Source_System_Id int 4 null
Source_System.Source_System_id Implied ConstraintR
Population_Information_Id int 4 null
Population_Information.Population_Information_id Implied ConstraintR
Insert_Date datetime 16,3 null
Insert_User varchar 50 null
Last_Update_Date datetime 16,3 null
Last_Update_User varchar 50 null
Delete_Ind bit 1 √ null
SNF_Impact varchar 100 √ null
Effective_Date datetime 16,3 √ null
Infinity_Category_Name varchar 100 √ null
PDPM_Category_Name varchar 100 √ null

Indexes

Constraint Name Type Sort Column(s)
PK__Code_Wit__CEAEF0EAB866284F Primary key Asc Code_id

Relationships

Close relationships within degrees of separation