Population_Information

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Population_Information_id int 4 null
Code.Population_Information_Id Implied ConstraintR
Code_Category.Population_Information_Id Implied ConstraintR
Code_Code_Map.Population_Information_Id Implied ConstraintR
Code_With_Categories.Population_Information_Id Implied ConstraintR
Electronic_Address.Population_Information_Id Implied ConstraintR
Employee.Population_Information_Id Implied ConstraintR
Employee_Hist.Population_Information_Id Implied ConstraintR
Facility.Population_Information_Id Implied ConstraintR
INFTalentMatrixReport.Population_Information_Id FK_UltiPro_INFTalentMatrix_Population_InformationR
JobHistoryReport.Population_Information_Id FK_UltiPro_JobHistory_Population_InformationR
MDS_Metric.Population_Information_Id Implied ConstraintR
MDS_Metric_Score.Population_Information_Id Implied ConstraintR
PARTY.Population_Information_Id Implied ConstraintR
PayHistoryByJobTitleReport.Population_Information_Id FK_UltiPro_PayHistoryByJobTitle_Population_InformationR
Person.Population_Information_Id Implied ConstraintR
Physician.Population_Information_Id Implied ConstraintR
PointInTimeReport.Population_Information_Id FK_UltiPro_PointInTimeReport_Population_InformationR
Postal_Address.Population_Information_Id Implied ConstraintR
Reach_Out.Population_Information_Id Implied ConstraintR
Resident.Population_Information_Id Implied ConstraintR
Resident_Facility.Population_Information_Id Implied ConstraintR
Telephone_Address.Population_Information_Id Implied ConstraintR
TerminationListReport.Population_Information_Id FK_UltiPro_TerminationListReport_Population_InformationR
Theraphy_Diagnosis.Population_Information_Id Implied ConstraintR
VW_UltiPro_TerminationListReport.Population_Information_Id Implied ConstraintR
Population_Information_Name varchar 50 null
Population_Information_Description varchar 200 null
Insert_Date datetime 16,3 (getdate())
Insert_User varchar 50 null
Last_Update_Date datetime 16,3 null
Last_Update_User varchar 50 null
Delete_Ind bit 1 √ ((0))
Source_System_Id int 4 √ null
Source_System.Source_System_id FK_Population_Information_Source_SystemR

Indexes

Constraint Name Type Sort Column(s)
PK_Population_Information Primary key Asc Population_Information_id
UK_Population_Information Must be unique Asc Population_Information_Name

Relationships

Close relationships within degrees of separation