| Previous: res_req_resource | Unanet Data Model | Next: resource_request_budget |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | resource_request_key | decimal(15) | |||
| 2. | requestor_key | decimal(15) | person | fk_resource_request1 | ||
| 3. | project_key | decimal(15) | project | fk_resource_request3 | ||
| 4. | task_key | decimal(15) | task | fk_resource_request4 | ||
| 5. | title | varchar(128) | ||||
| 6. | description | varchar(2000) | ||||
| 7. | budget_units | char(1) | ('H') | |||
| 8. | budget_by | char(1) | ('P') | |||
| 9. | status | varchar(25) | ||||
| 10. | status_date | datetime | ||||
| 11. | period_type | varchar(10) | ||||
| 12. | periods | decimal(2) | ||||
| 13. | begin_date | datetime | ||||
| 14. | end_date | datetime | ||||
| 15. | plan_set_key | decimal(15) | plan_set | fk_resource_request5 | ||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| requestor_key | person | person_key | fk_resource_request1 |
| plan_set_key | plan_set | plan_set_key | fk_resource_request5 |
| project_key | project | project_key | fk_resource_request3 |
| task_key | task | task_key | fk_resource_request4 |
| Table | Column | Foreign Key Name |
| planned_time | resource_request_key | fk_planned_time7 |
| res_req_labor_category | resource_request_key | fk_res_req_labor_category1 |
| res_req_location | resource_request_key | fk_res_req_location1 |
| res_req_planner | resource_request_key | fk_res_req_planner1 |
| res_req_resource | resource_request_key | fk_res_req_resource1 |
| resource_request_budget | resource_request_key | fk_resource_request_budget1 |
| resource_request_history | resource_request_key | fk_resource_request_history1 |
| resource_request_skill | resource_request_key | fk_resource_request_skill1 |
| Name | Definition |
| cc_rr_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_rr_budget_by | ([budget_by]='R' OR [budget_by]='P') |
| cc_rr_budget_by_dates | ([budget_by]='P' AND [period_type] IS NOT NULL AND [periods] IS NOT NULL AND [periods]>=(1) AND [begin_date] IS NOT NULL OR [budget_by]='R' AND [begin_date] IS NOT NULL AND [end_date] IS NOT NULL AND [begin_date]<=[end_date]) |
| cc_rr_budget_units | ([budget_units]='F' OR [budget_units]='H') |
| cc_rr_end_date | ([end_date]>='1900-01-01' AND [end_date]<='2099-12-31') |
| cc_rr_period_type | ([period_type]='fQuarter' OR [period_type]='fMonth' OR [period_type]='fWeek' OR [period_type]='quarter' OR [period_type]='month' OR [period_type]='semiMonth' OR [period_type]='week' OR [period_type]='day') |
| cc_rr_status | ([status]='ACCEPTED' OR [status]='REWORK' OR [status]='UNFULFILLED' OR [status]='FULFILLED' OR [status]='FULFILLING' OR [status]='REQUESTED' OR [status]='INUSE') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_resource_request | true | resource_request_key | Asc |
| idx_resource_request1 | false | requestor_key | Asc |
| status | |||
| idx_resource_request3 | false | project_key | Asc |
| idx_resource_request4 | false | task_key | Asc |
| idx_resource_request5 | false | plan_set_key | Asc |