Show 

Table: person

Columns
  Column Name Data Type Default
Value
References
Table
Foreign Key
Name
1. PK person_key decimal(15)      
2.   person_code varchar(25)      
3.   username varchar(55)      
4.   password varchar(32)      
5.   password_date datetime      
6.   ssn varchar(11)      
7.   emp_id varchar(25)      
8.   first_name varchar(50)      
9.   last_name varchar(50)      
10.   middle_initial char(1)      
11.   suffix varchar(10)      
12.   email varchar(50)      
13.   customer_key decimal(15)   customer fk_person3
14.   pay_code_key decimal(15)   pay_code fk_person5
15.   hour_increment decimal(15,2)      
16.   time_period_key decimal(15)   time_period_setup fk_person4
17.   time_vendor_key decimal(15)   customer fk_person15
18.   chain_key decimal(15)   chain fk_person2
19.   expense_chain_key decimal(15)   chain fk_person6
20.   expense_vendor_key decimal(15)   customer fk_person16
21.   active char(1)      
22.   timesheet_lines char(1)      
23.   timesheet_email char(1)      
24.   leave_request_email char(1) ('N')    
25.   expense_email char(1)      
26.   hide_vat char(1) ('N')    
27.   tito_required char(1) ('N')    
28.   payment_method_key decimal(15)   payment_method fk_person14
29.   currency_key decimal(15)      
30.   expense_approval_amount decimal(15,2)      
31.   vehicle_number varchar(32)      
32.   project_key decimal(15)   project fk_person7
33.   task_key decimal(15)   task fk_person8
34.   labor_category_key decimal(15)   labor_category fk_person9
35.   business_week_key decimal(15) ((1)) business_week fk_person11
36.   assignment_email char(1) ('Y')    
37.   hire_date datetime      
38.   payment_currency_key decimal(15)   currency fk_person10
39.   login_failures decimal(3) ((0))    
40.   location_key decimal(15)   location fk_person12
41.   employee_type_key decimal(15)   employee_type fk_person13
42.   tbd_user char(1) ('N')    
43.   user01 varchar(128)      
44.   user02 varchar(128)      
45.   user03 varchar(128)      
46.   user04 varchar(128)      
47.   user05 varchar(128)      
48.   user06 varchar(128)      
49.   user07 varchar(128)      
50.   user08 varchar(128)      
51.   user09 varchar(128)      
52.   user10 varchar(128)      
Foreign Keys
Column References Foreign Key Name
Table Column
business_week_key business_week business_week_key fk_person11
expense_chain_key chain chain_key fk_person6
chain_key chain chain_key fk_person2
payment_currency_key currency currency_key fk_person10
customer_key customer customer_key fk_person3
time_vendor_key customer customer_key fk_person15
expense_vendor_key customer customer_key fk_person16
employee_type_key employee_type employee_type_key fk_person13
labor_category_key labor_category labor_category_key fk_person9
location_key location location_key fk_person12
pay_code_key pay_code pay_code_key fk_person5
payment_method_key payment_method payment_method_key fk_person14
project_key project project_key fk_person7
task_key task task_key fk_person8
time_period_key time_period_setup time_period_key fk_person4
Referenced from
Table Column Foreign Key Name
accrual_period posted_by_key fk_accrual_period2
adhoc_criteria_set person_key fk_adhoc_criteria_set1
alternate alternate_key fk_alternate1
approval_chain person_key fk_approval_chain2
approval_history alternate_for_key fk_approval_history6
approval_history passed_to fk_approval_history4
approval_history person_key fk_approval_history2
assignment_display person_key fk_assignment_display3
bank_reconciliation created_by fk_bank_rec3
bank_reconciliation reconciled_by fk_bank_rec4
check_print_history printed_by fk_check_print_history1
cost_pool_group_calc calculated_by fk_cost_pool_group_calc2
cost_pool_group_calc posted_by fk_cost_pool_group_calc3
cost_pool_group_calc voided_by fk_cost_pool_group_calc4
cost_struct_pool_rate modifier_key fk_cost_struct_pool_rate3
credit_card person_key fk_credit_card1
criteria_set person_key fk_criteria_set1
customer_contact created_by fk_customer_contact2
customer_contact last_updated_by fk_customer_contact3
dashboard_chart person_key fk_dashboard_chart1
dashboard_list person_key fk_dashboard_list1
dashboard_section person_key fk_dashboard_section1
expense_history controller fk_expense_history2
expense_history performed_by fk_expense_history3
expense_report controller_key fk_expense_report3
expense_report creator_key fk_expense_report2
expense_report owner_key fk_expense_report1
export_template owner_key fk_export_template1
fin_document created_by fk_fin_document3
fin_document last_updated_by fk_fin_document2
fin_document posted_by fk_fin_document5
fin_document submitted_by fk_fin_document4
fin_document_detail person_key fk_fin_document_detail4
fiscal_month_org_feature_close closed_by fk_fm_org_feature_close3
fiscal_year_org_close closed_by fk_fiscal_year_org_close3
general_alert_prefs person_key fk_general_alert_prefs1
general_ledger person_key fk_general_ledger5
image_setup last_modified_by fk_image_setup2
invoice completed_by fk_invoice3
invoice created_by fk_invoice2
leave_request person_key fk_leave_request1
leave_request_approval alternate_for_key fk_leave_request_approval3
leave_request_approval person_key fk_leave_request_approval2
list_criteria_set person_key fk_list_criteria_set1
member person_key fk_member1
org_access_person person_key fk_org_access_person1
password_reset_request person_key fk_password_reset_request1
payroll person_key fk_payroll1
person_account person_key fk_person_account1
person_accrual person_key fk_person_accrual2
person_accrual_plan person_key fk_person_accrual_plan2
person_rate person_key fk_person_rate1
person_time control_key fk_person_time1
person_time person_key fk_person_time2
plan_set_history modified_by fk_plan_set_history2
planned_time person_key fk_planned_time1
post_history posted_by_key fk_post_history1
project_alert_recipient person_key fk_project_alert_recipient2
project_assignment person_key fk_project_assignment1
project_budget_history modified_by fk_project_budget_history1
project_controller person_key fk_project_controller2
project_criteria_set person_key fk_project_criteria_set1
project_note assignee_person_key fk_project_note6
project_note creator_person_key fk_project_note2
project_note modified_person_key fk_project_note3
project_note_audit assignee fk_project_note_audit5
project_note_audit modified_by fk_project_note_audit2
project_note_comment commentor fk_project_note_comment2
project_note_comment modifier fk_project_note_comment3
res_req_planner planner_key fk_res_req_planner2
res_req_resource resource_key fk_res_req_resource2
resource_request requestor_key fk_resource_request1
resource_request_history alternate_for_key fk_resource_request_history3
resource_request_history person_key fk_resource_request_history2
shared_criteria_set modified_by fk_shared_criteria_set1
skill_assignment person_key fk_skill_assignment1
task_alert_recipient person_key fk_task_alert_recipient2
task_assignment person_key fk_task_assignment1
task_budget_history modified_by fk_task_budget_history1
unanet_properties_history updater_key fk_unanet_properties_history1
Check Constraints
Name Definition
cc_active ([active]='N' OR [active]='Y')
cc_assignment_email ([assignment_email]='N' OR [assignment_email]='Y')
cc_expense_email ([expense_email]='N' OR [expense_email]='Y')
cc_hide_vat ([hide_vat]='N' OR [hide_vat]='Y')
cc_leave_request_email ([leave_request_email]='N' OR [leave_request_email]='Y')
cc_person_hire_date ([hire_date]>='1900-01-01' AND [hire_date]<='2099-12-31')
cc_person_tbd_user ([tbd_user]='Y' OR [tbd_user]='N')
cc_person_tito_required ([tito_required]='D' OR [tito_required]='C' OR [tito_required]='N')
cc_timesheet_email ([timesheet_email]='N' OR [timesheet_email]='Y')
cc_timesheet_lines ([timesheet_lines]='N' OR [timesheet_lines]='Y')
Indices
Index Name Unique Column Name Asc Or Desc
pk_person true person_key Asc
idx_person1 true username Asc
idx_person2 false customer_key Asc
Dependent Views
View Name
assignment_view