Table: pay_code

Columns
		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	pay_code_key	decimal(15)
2.		pay_code	varchar(10)
3.		active	char(1)
4.		default_list	char(1)
5.		default_selected	char(1)
6.		factor	decimal(5,3)
7.		exempt_usage	char(1)	('R')
8.		description	varchar(100)

Referenced from
Table	Column	Foreign Key Name
adp_setup	pay_code_key	fk_adp_setup1
employee_type_pay_code	pay_code_key	fk_employee_type_pay_code2
pay_code_account	pay_code_key	fk_pay_code_account1
pay_code_mapping	pay_code_key	fk_pay_code_mapping1
pay_code_rate	pay_code_key	fk_pay_code_rate1
person	pay_code_key	fk_person5
person_time_data	pay_code_key	fk_person_time_data1
person_time_data_history	pay_code_key	fk_person_time_data_history1
project	pay_code_key	fk_project5
project_pay_code	pay_code_key	fk_project_pay_code2

Check Constraints
Name	Definition
cc_accepted_entry	([active]='N' AND [default_list]='N' AND [default_selected]='N' OR [active]='Y' AND NOT ([default_list]='N' AND [default_selected]='Y'))
cc_default_list	([default_list]='N' OR [default_list]='Y')
cc_default_selected	([default_selected]='N' OR [default_selected]='Y')
cc_pc_active	([active]='N' OR [active]='Y')
cc_pc_exempt_usage	([exempt_usage]='L' OR [exempt_usage]='E' OR [exempt_usage]='P' OR [exempt_usage]='R')

Indices
Index Name	Unique	Column Name	Asc Or Desc
pk_pay_code	true	pay_code_key	Asc
idx_pay_code1	true	pay_code	Asc