Table: general_alert_prefs

Previous: funding_cap_adjustment

Unanet Data Model

Next: general_ledger

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	person_key	decimal(15)		person	fk_general_alert_prefs1
2.		show_to_pm	char(1)	('N')
3.		show_to_pm_alt	char(1)	('N')
4.		show_to_lead	char(1)	('N')
5.		show_to_lead_alt	char(1)	('N')
6.		show_to_approver	char(1)	('N')
7.		show_to_approver_alt	char(1)	('N')
8.		email_alert	char(1)	('N')
9.		time_elapsed_alert	char(1)	('N')
10.		hours_alert	char(1)	('N')
11.		total_cost_alert	char(1)	('N')
12.		labor_cost_alert	char(1)	('N')
13.		expense_cost_alert	char(1)	('N')
14.		total_bill_alert	char(1)	('N')
15.		time_elapsed_alert_pct	decimal(3)
16.		hours_alert_pct	decimal(3)
17.		total_cost_alert_pct	decimal(3)
18.		labor_cost_alert_pct	decimal(3)
19.		expense_cost_alert_pct	decimal(3)
20.		total_bill_alert_pct	decimal(3)
21.		hours_alert_denom	char(1)	('B')
22.		total_cost_alert_denom	char(1)	('B')
23.		labor_cost_alert_denom	char(1)	('B')
24.		expense_cost_alert_denom	char(1)	('B')
25.		total_bill_alert_denom	char(1)	('B')
26.		funding_expended_alert	char(1)	('N')
27.		funding_expended_alert_pct	decimal(3)

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
person_key	person	person_key	fk_general_alert_prefs1

Check Constraints

Name	Definition
cc_gap_email_alert	([email_alert]='N' OR [email_alert]='Y')
cc_gap_expense_cost_alert	([expense_cost_alert]='N' OR [expense_cost_alert]='Y')
cc_gap_expense_cost_alert_dnom	([expense_cost_alert_denom]='T' OR [expense_cost_alert_denom]='B')
cc_gap_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_gap_fund_expended_alert	([funding_expended_alert]='N' OR [funding_expended_alert]='Y')
cc_gap_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_gap_hours_alert	([hours_alert]='N' OR [hours_alert]='Y')
cc_gap_hours_alert_dnom	([hours_alert_denom]='T' OR [hours_alert_denom]='B')
cc_gap_hours_alert_pct	([hours_alert_pct] IS NULL AND [hours_alert]='N' OR [hours_alert_pct] IS NOT NULL AND [hours_alert]='Y')
cc_gap_labor_cost_alert	([labor_cost_alert]='N' OR [labor_cost_alert]='Y')
cc_gap_labor_cost_alert_dnom	([labor_cost_alert_denom]='T' OR [labor_cost_alert_denom]='B')
cc_gap_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_gap_show_to_approver	([show_to_approver]='N' OR [show_to_approver]='Y')
cc_gap_show_to_approver_alt	([show_to_approver_alt]='N' OR [show_to_approver_alt]='Y')
cc_gap_show_to_lead	([show_to_lead]='N' OR [show_to_lead]='Y')
cc_gap_show_to_lead_alt	([show_to_lead_alt]='N' OR [show_to_lead_alt]='Y')
cc_gap_show_to_pm	([show_to_pm]='N' OR [show_to_pm]='Y')
cc_gap_show_to_pm_alt	([show_to_pm_alt]='N' OR [show_to_pm_alt]='Y')
cc_gap_time_elapsed_alert	([time_elapsed_alert]='N' OR [time_elapsed_alert]='Y')
cc_gap_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_gap_total_bill_alert	([total_bill_alert]='N' OR [total_bill_alert]='Y')
cc_gap_total_bill_alert_dnom	([total_bill_alert_denom]='T' OR [total_bill_alert_denom]='B')
cc_gap_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_gap_total_cost_alert	([total_cost_alert]='N' OR [total_cost_alert]='Y')
cc_gap_total_cost_alert_dnom	([total_cost_alert_denom]='T' OR [total_cost_alert_denom]='B')
cc_gap_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_general_alert_prefs	true	person_key	Asc