Previous: lodging_per_diem_detail | Unanet Data Model | Next: member |
Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
1. | PK | person_time_key | decimal(15) | person_time | fk_manager_approval_status1 | |
2. | PK | project_key | decimal(15) | project | fk_manager_approval_status2 | |
3. | approved | char(1) |
Column | References | Foreign Key Name | |
Table | Column | ||
person_time_key | person_time | person_time_key | fk_manager_approval_status1 |
project_key | project | project_key | fk_manager_approval_status2 |
Name | Definition |
cc_mas_approved | ([approved]='N' OR [approved]='Y') |
Index Name | Unique | Column Name | Asc Or Desc |
pk_manager_approval_status | true | person_time_key | Asc |
project_key |