| Previous: per_diem_rate | Unanet Data Model | Next: person_account |
| 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. | 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. | expense_vendor_key | decimal(15) | customer | fk_person16 | ||
| 19. | active | char(1) | ||||
| 20. | timesheet_lines | char(1) | ||||
| 21. | timesheet_email | char(1) | ||||
| 22. | leave_request_email | char(1) | ('N') | |||
| 23. | expense_email | char(1) | ||||
| 24. | hide_vat | char(1) | ('N') | |||
| 25. | tito_required | char(1) | ('N') | |||
| 26. | payment_method_key | decimal(15) | payment_method | fk_person14 | ||
| 27. | currency_key | decimal(15) | ||||
| 28. | expense_approval_amount | decimal(15,2) | ||||
| 29. | vehicle_number | varchar(32) | ||||
| 30. | project_key | decimal(15) | project | fk_person7 | ||
| 31. | task_key | decimal(15) | task | fk_person8 | ||
| 32. | labor_category_key | decimal(15) | labor_category | fk_person9 | ||
| 33. | business_week_key | decimal(15) | ((1)) | business_week | fk_person11 | |
| 34. | assignment_email | char(1) | ('Y') | |||
| 35. | hire_date | datetime | ||||
| 36. | payment_currency_key | decimal(15) | currency | fk_person10 | ||
| 37. | login_failures | decimal(3) | ((0)) | |||
| 38. | location_key | decimal(15) | location | fk_person12 | ||
| 39. | employee_type_key | decimal(15) | employee_type | fk_person13 | ||
| 40. | tbd_user | char(1) | ('N') | |||
| 41. | user01 | varchar(128) | ||||
| 42. | user02 | varchar(128) | ||||
| 43. | user03 | varchar(128) | ||||
| 44. | user04 | varchar(128) | ||||
| 45. | user05 | varchar(128) | ||||
| 46. | user06 | varchar(128) | ||||
| 47. | user07 | varchar(128) | ||||
| 48. | user08 | varchar(128) | ||||
| 49. | user09 | varchar(128) | ||||
| 50. | user10 | varchar(128) | ||||
| 51. | purchase_approval_amount | decimal(15,2) | ||||
| 52. | purchase_email | char(1) | ||||
| 53. | vendor_invoice_person | char(1) | ('N') | |||
| 54. | po_form_title | varchar(240) | ||||
| 55. | po_signature_key | decimal(15) | attachment | fk_person17 | ||
| 56. | user11 | varchar(128) | ||||
| 57. | user12 | varchar(128) | ||||
| 58. | user13 | varchar(128) | ||||
| 59. | user14 | varchar(128) | ||||
| 60. | user15 | varchar(128) | ||||
| 61. | user16 | varchar(128) | ||||
| 62. | user17 | varchar(128) | ||||
| 63. | user18 | varchar(128) | ||||
| 64. | user19 | varchar(128) | ||||
| 65. | user20 | varchar(128) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| po_signature_key | attachment | attachment_key | fk_person17 |
| business_week_key | business_week | business_week_key | fk_person11 |
| payment_currency_key | currency | currency_key | fk_person10 |
| time_vendor_key | customer | customer_key | fk_person15 |
| expense_vendor_key | customer | customer_key | fk_person16 |
| customer_key | customer | customer_key | fk_person3 |
| 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 |
| 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_group_submitter | person_key | fk_approval_group_submitter2 |
| approval_history | alternate_for_key | fk_approval_history6 |
| approval_history | person_key | fk_approval_history2 |
| assignment_display | person_key | fk_assignment_display3 |
| attachment_reference | attached_by | fk_attachment_reference2 |
| 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_approval | performed_by | fk_fd_approval2 |
| fin_document_approval | performed_for | fk_fd_approval3 |
| 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 |
| po_expense_assignment | person_key | fk_po_expense_assignment3 |
| po_expense_line_descriptor | person_key | fk_po_expense_line_descr9 |
| po_format | signer_key | fk_po_fmt_signer_key |
| po_item_line_descriptor | person_key | fk_po_item_line_descr10 |
| po_labor_assignment | person_key | fk_po_labor_assignment3 |
| po_labor_line_descriptor | person_key | fk_po_labor_line_descr9 |
| post_history | posted_by_key | fk_post_history1 |
| pr_expense_line_descriptor | person_key | fk_pr_expense_line_descr7 |
| pr_item_line_descriptor | person_key | fk_pr_item_line_descr9 |
| pr_labor_line_descriptor | person_key | fk_pr_labor_line_descr8 |
| 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 |
| purchase_order | controller_key | fk_purchase_order11 |
| purchase_order | emailed_by | fk_purchase_order14 |
| purchase_order | po_owner_key | fk_purchase_order3 |
| purchase_order | printed_by | fk_purchase_order15 |
| purchase_order | purchaser_key | fk_purchase_order7 |
| purchase_order | receiver_key | fk_purchase_order13 |
| purchase_order_approval | performed_by | fk_po_approval2 |
| purchase_order_approval | performed_for | fk_po_approval3 |
| purchase_requisition | controller_key | fk_purchase_request4 |
| purchase_requisition | purchaser_key | fk_purchase_request9 |
| purchase_requisition | requestor_key | fk_purchase_request2 |
| purchase_requisition_approval | performed_by | fk_pr_approval2 |
| purchase_requisition_approval | performed_for | fk_pr_approval3 |
| 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 |
| shared_document | created_by | fk_shared_document3 |
| shared_document | last_updated_by | fk_shared_document4 |
| 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 |
| vendor_invoice | controller_key | fk_vendor_invoice8 |
| vendor_invoice | receiver_key | fk_vendor_invoice9 |
| 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_purchase_approval_amount | ([purchase_approval_amount]>=(0)) |
| cc_purchase_email | ([purchase_email]='N' OR [purchase_email]='Y') |
| cc_timesheet_email | ([timesheet_email]='N' OR [timesheet_email]='Y') |
| cc_timesheet_lines | ([timesheet_lines]='N' OR [timesheet_lines]='Y') |
| cc_vendor_invoice_person | ([vendor_invoice_person]='N' OR [vendor_invoice_person]='Y') |
| 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 |
| idx_person3 | false | po_signature_key | Asc |
| View Name |
| assignment_view |
| vendor_payment_1099_view |