Source_System

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Source_System_id int 4 null
Code.Source_System_Id Implied ConstraintR
Code_Category.Source_System_Id Implied ConstraintR
Code_Code_Map.Source_System_Id Implied ConstraintR
Code_With_Categories.Source_System_Id Implied ConstraintR
Electronic_Address.Source_System_Id Implied ConstraintR
Employee.Source_System_Id Implied ConstraintR
Employee_Hist.Source_System_Id Implied ConstraintR
Facility.Source_System_Id Implied ConstraintR
INFTalentMatrixReport.Source_System_Id FK_UltiPro_INFTalentMatrix_Source_SystemR
JobHistoryReport.Source_System_Id FK_UltiPro_JobHistory_Source_SystemR
MDS_Metric.Source_System_Id Implied ConstraintR
MDS_Metric_Score.Source_System_Id Implied ConstraintR
PARTY.Source_System_Id Implied ConstraintR
PayHistoryByJobTitleReport.Source_System_Id FK_UltiPro_PayHistoryByJobTitle_Source_SystemR
Person.Source_System_Id Implied ConstraintR
Physician.Source_System_Id Implied ConstraintR
PointInTimeReport.Source_System_Id FK_UltiPro_PointInTimeReport_Source_SystemR
Population_Information.Source_System_Id FK_Population_Information_Source_SystemR
Postal_Address.Source_System_Id Implied ConstraintR
Reach_Out.Source_System_Id Implied ConstraintR
Resident.Source_System_Id Implied ConstraintR
Resident_Facility.Source_System_Id Implied ConstraintR
Telephone_Address.Source_System_Id Implied ConstraintR
TerminationListReport.Source_System_Id FK_UltiPro_TerminationListReport_Source_SystemR
Theraphy_Diagnosis.Source_System_Id Implied ConstraintR
Type.Source_System_Id FK_Type_Source_SystemR
VW_UltiPro_TerminationListReport.Source_System_Id Implied ConstraintR
Source_System_Name varchar 50 null
Source_System_Description varchar 200 null
Insert_Date datetime 16,3 null
Insert_User varchar 50 null
Last_Update_Date datetime 16,3 null
Last_Update_User varchar 50 null

Indexes

Constraint Name Type Sort Column(s)
PK_Source_System Primary key Asc Source_System_id

Relationships

Close relationships within degrees of separation