| Previous: project_budget_snapshot | Unanet Data Model | Next: project_criteria_set |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | project_controller_key | decimal(15) | ((0)) | ||
| 2. | project_key | decimal(15) | project | fk_project_controller1 | ||
| 3. | role_key | decimal(15) | role | fk_project_controller3 | ||
| 4. | person_key | decimal(15) | person | fk_project_controller2 | ||
| 5. | primary_ind | char(1) | ||||
| 6. | approval_type | tinyint | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| person_key | person | person_key | fk_project_controller2 |
| project_key | project | project_key | fk_project_controller1 |
| role_key | role | role_key | fk_project_controller3 |
| Name | Definition |
| cc_pc_approval_type1 | ([approval_type] IS NULL OR ([approval_type]='7' OR [approval_type]='6' OR [approval_type]='5' OR [approval_type]='4' OR [approval_type]='3' OR [approval_type]='2')) |
| cc_pc_approval_type2 | ([approval_type] IS NOT NULL AND ([role_key]=(13) OR [role_key]=(6)) OR [approval_type] IS NULL AND NOT ([role_key]=(13) OR [role_key]=(6))) |
| cc_pjt_ctrl_primary | ([primary_ind]='N' OR [primary_ind]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_project_controller | true | project_controller_key | Asc |
| idx_project_controller1 | true | project_key | Asc |
| role_key | |||
| person_key | |||
| approval_type | |||
| idx_project_controller2 | false | person_key | Asc |
| idx_project_controller3 | false | person_key | Asc |
| approval_type |
| View Name |
| assignment_view |
| project_approval_view |