| Previous: project_status | Unanet Data Model | Next: project_type_account |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | project_type_key | decimal(15) | |||
| 2. | project_type | varchar(10) | ||||
| 3. | description | varchar(100) | ||||
| 4. | administrative | char(1) | ||||
| 5. | billable | char(1) | ||||
| 6. | last_project_code_seq | decimal(15) | ((0)) | |||
| 7. | start_with_project_code_seq | decimal(15) | ((1)) | |||
| 8. | active | char(1) | ('Y') | |||
| Table | Column | Foreign Key Name |
| expense_data | project_type_key | fk_expense_data7 |
| expense_data_allocation | project_type_key | fk_expense_data_allocation6 |
| fin_document_detail_project | project_type_key | fk_fin_doc_detail_project4 |
| person_time_data | project_type_key | fk_person_time_data4 |
| person_time_data_history | project_type_key | fk_person_time_data_history4 |
| project | project_type_key | fk_project3 |
| project_type_account | project_type_key | fk_project_type_account1 |
| project_type_exp_type_acct | project_type_key | fk_project_type_exp_type_acct1 |
| task | project_type_key | fk_task3 |
| Name | Definition |
| cc_pjtt_active | ([active]='N' OR [active]='Y') |
| cc_pjtt_administrative | ([administrative]='N' OR [administrative]='Y') |
| cc_pjtt_billable | (([billable]='N' OR [billable]='Y') AND [billable] IS NOT NULL) |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_project_type | true | project_type_key | Asc |
| idx_project_type1 | true | project_type | Asc |