Table: project_alert_prefs

Previous: project_alert Unanet Data Model Next: project_alert_recipient
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK project_key decimal(15)   project fk_project_alert_prefs1
2.   disable_alerts char(1) ('N')    
3.   show_to_pm char(1) ('N')    
4.   show_to_pm_alt char(1) ('N')    
5.   show_to_lead char(1) ('N')    
6.   show_to_lead_alt char(1) ('N')    
7.   show_to_approver char(1) ('N')    
8.   show_to_approver_alt char(1) ('N')    
9.   email_alert char(1) ('N')    
10.   time_elapsed_alert char(1) ('N')    
11.   hours_alert char(1) ('N')    
12.   total_cost_alert char(1) ('N')    
13.   labor_cost_alert char(1) ('N')    
14.   expense_cost_alert char(1) ('N')    
15.   total_bill_alert char(1) ('N')    
16.   time_elapsed_alert_pct decimal(3)      
17.   hours_alert_pct decimal(3)      
18.   total_cost_alert_pct decimal(3)      
19.   labor_cost_alert_pct decimal(3)      
20.   expense_cost_alert_pct decimal(3)      
21.   total_bill_alert_pct decimal(3)      
22.   hours_alert_denom char(1) ('B')    
23.   total_cost_alert_denom char(1) ('B')    
24.   labor_cost_alert_denom char(1) ('B')    
25.   expense_cost_alert_denom char(1) ('B')    
26.   total_bill_alert_denom char(1) ('B')    
27.   funding_expended_alert char(1) ('N')    
28.   funding_expended_alert_pct decimal(3)      
Foreign Keys
Column References Foreign Key Name
Table Column
project_key project project_key fk_project_alert_prefs1
Check Constraints
Name Definition
cc_pap_disable_alerts ([disable_alerts]='N' OR [disable_alerts]='Y')
cc_pap_email_alert ([email_alert]='N' OR [email_alert]='Y')
cc_pap_expense_cost_alert ([expense_cost_alert]='N' OR [expense_cost_alert]='Y')
cc_pap_expense_cost_alert_dnom ([expense_cost_alert_denom]='T' OR [expense_cost_alert_denom]='B')
cc_pap_expense_cost_alert_pct ([expense_cost_alert_pct] IS NULL AND [expense_cost_alert]='N' OR [expense_cost_alert_pct] IS NOT NULL AND [expense_cost_alert]='Y')
cc_pap_fund_expended_alert ([funding_expended_alert]='N' OR [funding_expended_alert]='Y')
cc_pap_fund_expended_alert_pct ([funding_expended_alert_pct] IS NULL AND [funding_expended_alert]='N' OR [funding_expended_alert_pct] IS NOT NULL AND [funding_expended_alert]='Y')
cc_pap_hours_alert ([hours_alert]='N' OR [hours_alert]='Y')
cc_pap_hours_alert_dnom ([hours_alert_denom]='T' OR [hours_alert_denom]='B')
cc_pap_hours_alert_pct ([hours_alert_pct] IS NULL AND [hours_alert]='N' OR [hours_alert_pct] IS NOT NULL AND [hours_alert]='Y')
cc_pap_labor_cost_alert ([labor_cost_alert]='N' OR [labor_cost_alert]='Y')
cc_pap_labor_cost_alert_dnom ([labor_cost_alert_denom]='T' OR [labor_cost_alert_denom]='B')
cc_pap_labor_cost_alert_pct ([labor_cost_alert_pct] IS NULL AND [labor_cost_alert]='N' OR [labor_cost_alert_pct] IS NOT NULL AND [labor_cost_alert]='Y')
cc_pap_show_to_approver ([show_to_approver]='N' OR [show_to_approver]='Y')
cc_pap_show_to_approver_alt ([show_to_approver_alt]='N' OR [show_to_approver_alt]='Y')
cc_pap_show_to_lead ([show_to_lead]='N' OR [show_to_lead]='Y')
cc_pap_show_to_lead_alt ([show_to_lead_alt]='N' OR [show_to_lead_alt]='Y')
cc_pap_show_to_pm ([show_to_pm]='N' OR [show_to_pm]='Y')
cc_pap_show_to_pm_alt ([show_to_pm_alt]='N' OR [show_to_pm_alt]='Y')
cc_pap_time_elapsed_alert ([time_elapsed_alert]='N' OR [time_elapsed_alert]='Y')
cc_pap_time_elapsed_alert_pct ([time_elapsed_alert_pct] IS NULL AND [time_elapsed_alert]='N' OR [time_elapsed_alert_pct] IS NOT NULL AND [time_elapsed_alert]='Y')
cc_pap_total_bill_alert ([total_bill_alert]='N' OR [total_bill_alert]='Y')
cc_pap_total_bill_alert_dnom ([total_bill_alert_denom]='T' OR [total_bill_alert_denom]='B')
cc_pap_total_bill_alert_pct ([total_bill_alert_pct] IS NULL AND [total_bill_alert]='N' OR [total_bill_alert_pct] IS NOT NULL AND [total_bill_alert]='Y')
cc_pap_total_cost_alert ([total_cost_alert]='N' OR [total_cost_alert]='Y')
cc_pap_total_cost_alert_dnom ([total_cost_alert_denom]='T' OR [total_cost_alert_denom]='B')
cc_pap_total_cost_alert_pct ([total_cost_alert_pct] IS NULL AND [total_cost_alert]='N' OR [total_cost_alert_pct] IS NOT NULL AND [total_cost_alert]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_project_alert_prefs true project_key Asc