PROJECT |
||||
| Column Name | Data Type | Nulls | References Table |
Foreign Key Name |
|---|---|---|---|---|
| project_key | decimal (15,0) | |||
| customer_key | decimal (15,0) | CUSTOMER | fk_project1 | |
| project_code | varchar (30) | |||
| account_number | varchar (128) | YES | ||
| title | text | YES | ||
| purpose | text | YES | ||
| manager_key | decimal (15,0) | YES | PERSON | fk_project2 |
| manager_approval | varchar (1) | |||
| project_type_key | decimal (15,0) | PROJECT_TYPE | fk_project3 | |
| project_status_key | decimal (15,0) | PROJECT_STATUS | fk_project4 | |
| orig_start_date | datetime | YES | ||
| orig_end_date | datetime | YES | ||
| rev_start_date | datetime | YES | ||
| rev_end_date | datetime | YES | ||
| budget_hours | decimal (15,2) | YES | ||
| hours_used_to_date | decimal (15,2) | YES | ||
| projected_total_hours | decimal (15,2) | YES | ||
| budget_dollars_op | decimal (15,2) | YES | ||
| dollars_used_to_date_op | decimal (15,2) | YES | ||
| projected_total_dollars_op | decimal (15,2) | YES | ||
| budget_dollars_cap | decimal (15,2) | YES | ||
| dollars_used_to_date_cap | decimal (15,2) | YES | ||
| projected_total_dollars_cap | decimal (15,2) | YES | ||
| assignment_flag | varchar (1) | |||
| expense_assignment_flag | varchar (1) | |||
| er_task_required | varchar (1) | |||
| ts_task_required | varchar (1) | |||
| open_edit | varchar (1) | YES | ||
| future_charge | varchar (1) | YES | ||
| created | datetime | YES | ||
| user01 | varchar (128) | YES | ||
| user02 | varchar (128) | YES | ||
| user03 | varchar (128) | YES | ||
| user04 | varchar (128) | YES | ||
| user05 | varchar (128) | YES | ||
| user06 | varchar (128) | YES | ||
| user07 | varchar (128) | YES | ||
| user08 | varchar (128) | YES | ||
| user09 | varchar (128) | YES | ||
| user10 | varchar (128) | YES | ||
| expense_manager_approval | varchar (1) | YES | ||
References made to PROJECT |
||
| Table Name | Field Name | Foreign Key Name |
|---|---|---|
| ADP_SETUP | project_key | fk_adp_setup1 |
| APPROVAL_HISTORY | project_key | fk_approval_history3 |
| CATEGORY_ASSIGNMENT | project_key | fk_category_assignment2 |
| CUSTOMER_APPROVER | project_key | fk_customer_approver2 |
| CUSTOMER_ASSIGNMENT | project_key | fk_customer_assignment2 |
| DEFAULT_TIME_DATA | project_key | fk_default_time_data2 |
| EXP_CUST_APPROVAL_STATUS | project_key | fk_exp_cust_approval_status2 |
| EXPENSE_DATA_ALLOCATION | project_key | fk_expense_data_allocation2 |
| EXPENSE_HISTORY | project_key | fk_expense_history4 |
| EXPENSE_PM_APPROVAL_STATUS | project_key | fk_expense_pm_approval_status2 |
| EXPENSE_PROJECT_ALLOCATION | project_key | fk_expense_project_allocation2 |
| HOLIDAY | project_key | fk_holiday1 |
| MANAGER_APPROVAL_STATUS | project_key | fk_manager_approval_status2 |
| MPX_MAPPING | project_key | fk_mpx_mapping1 |
| PERSON_TIME_DATA | project_key | fk_person_time_data3 |
| PERSON_TIME_DATA_HISTORY | project_key | fk_person_time_data_history3 |
| PROJECT_ASSIGNMENT | project_key | fk_project_assignment2 |
| PROJECT_CONTACT | project_key | fk_project_contact1 |
| PROJECT_NOTE | project_key | fk_project_note1 |
| PTD_AUDIT_TRAIL | project_key | fk_ptd_audit_trail3 |
| TASK | project_key | fk_task2 |
| TIME_CUST_APPROVAL_STATUS | project_key | fk_time_cust_approval_status2 |
| VALID_PAYCODE | project_key | fk_valid_paycode1 |
Check Constraints for PROJECT |
|
| Check Constraint Name | Definition |
|---|---|
| cc_pjt_assignment_flag | (assignment_flag = 'N' or (assignment_flag = 'Y')) |
| cc_pjt_expense_pm_approval | (expense_manager_approval = 'N' or (expense_manager_approval = 'Y')) |
| cc_pjt_manager_approval | (manager_approval = 'N' or (manager_approval = 'Y')) |
| cc_prj_er_task_required | (er_task_required = 'N' or (er_task_required = 'Y' and (er_task_required is not null))) |
| cc_prj_ts_task_required | (ts_task_required = 'N' or (ts_task_required = 'Y' and (ts_task_required is not null))) |
Indexes on PROJECT |
|
| Index Name | Column(s) |
|---|---|
| idx_project1 | customer_key, project_code |
| idx_project2 | project_status_key |
| idx_project3 | assignment_flag |
| pk_project | project_key |