Constraints

16 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FK_UltiPro_TerminationListReport_Source_System
TerminationListReport.Source_System_Id
Source_System.Source_System_id
Restrict delete
FK_UltiPro_TerminationListReport_Population_Information
TerminationListReport.Population_Information_Id
Population_Information.Population_Information_id
Restrict delete
FK_UltiPro_PointInTimeReport_Source_System
PointInTimeReport.Source_System_Id
Source_System.Source_System_id
Restrict delete
FK_UltiPro_PointInTimeReport_Population_Information
PointInTimeReport.Population_Information_Id
Population_Information.Population_Information_id
Restrict delete
FK_PPPL_Unbilled_file_id
PPPL_Unbilled.file_id
PPPL_Control.file_id
Restrict delete
Ref_Signature_Branch_FK
Ref_Signature_Branch.branch_company_id
Ref_Signature_Company.company_id
Restrict delete
FK_Type_Source_System
Type.Source_System_Id
Source_System.Source_System_id
Restrict delete
Medicare_StateAverages_FK
Medicare_StateAverages.AVA_FileKey
Medicare_StateAverages.AVA_YYYYMMKey
ETL_Medicare.file_key
ETL_Medicare.yyyymm_key
Restrict delete
FK_PPPL_InvoiceDetail_file_id
PPPL_InvoiceDetail.file_id
PPPL_Control.file_id
Restrict delete
FK_UltiPro_JobHistory_Source_System
JobHistoryReport.Source_System_Id
Source_System.Source_System_id
Restrict delete
FK_UltiPro_JobHistory_Population_Information
JobHistoryReport.Population_Information_Id
Population_Information.Population_Information_id
Restrict delete
FK_UltiPro_INFTalentMatrix_Population_Information
INFTalentMatrixReport.Population_Information_Id
Population_Information.Population_Information_id
Restrict delete
FK_UltiPro_INFTalentMatrix_Source_System
INFTalentMatrixReport.Source_System_Id
Source_System.Source_System_id
Restrict delete
FK_Population_Information_Source_System
Population_Information.Source_System_Id
Source_System.Source_System_id
Restrict delete
FK_UltiPro_PayHistoryByJobTitle_Population_Information
PayHistoryByJobTitleReport.Population_Information_Id
Population_Information.Population_Information_id
Restrict delete
FK_UltiPro_PayHistoryByJobTitle_Source_System
PayHistoryByJobTitleReport.Source_System_Id
Source_System.Source_System_id
Restrict delete

Check Constraints

Table Constraint Name Constraint