| Previous: approval_chain | Unanet Data Model | Next: assignment_display |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | approval_history_key | decimal(15) | |||
| 2. | person_time_key | decimal(15) | person_time | fk_approval_history1 | ||
| 3. | person_key | decimal(15) | person | fk_approval_history2 | ||
| 4. | alternate_for_key | decimal(15) | person | fk_approval_history6 | ||
| 5. | action_date | datetime | ||||
| 6. | approved | char(1) | ||||
| 7. | passed_to | decimal(15) | person | fk_approval_history4 | ||
| 8. | project_key | decimal(15) | project | fk_approval_history3 | ||
| 9. | comments | varchar(2000) | ||||
| 10. | status | varchar(25) | ||||
| 11. | adjustment_status | varchar(25) | ||||
| 12. | pending_adjustment | char(1) | ('N') | |||
| 13. | role_key | decimal(15) | role | fk_approval_history5 | ||
| 14. | review_required | char(1) | ('N') | |||
| 15. | review_date | datetime | ||||
| 16. | review_comments | varchar(2000) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| person_key | person | person_key | fk_approval_history2 |
| passed_to | person | person_key | fk_approval_history4 |
| alternate_for_key | person | person_key | fk_approval_history6 |
| person_time_key | person_time | person_time_key | fk_approval_history1 |
| project_key | project | project_key | fk_approval_history3 |
| role_key | role | role_key | fk_approval_history5 |
| Name | Definition |
| cc_ah_adjustment_status | (([adjustment_status]='APPROVING' OR [adjustment_status]='DISAPPROVED' OR [adjustment_status]='COMPLETED' OR [adjustment_status]='SUBMITTED' OR [adjustment_status]='INUSE') AND ([status]='EXTRACTED' OR [status]='LOCKED') OR [adjustment_status] IS NULL) |
| cc_ah_approved | ([approved]='N' OR [approved]='Y') |
| cc_ah_pending_adjustment | ([pending_adjustment]='N' OR [pending_adjustment]='Y') |
| cc_ah_status | ([status]='LOCKED' OR [status]='EXTRACTED' OR [status]='COMPLETED' OR [status]='DISAPPROVED' OR [status]='APPROVING' OR [status]='SUBMITTED' OR [status]='INUSE') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_approval_history | true | approval_history_key | Asc |
| idx_approval_history1 | false | person_time_key | Asc |
| idx_approval_history2 | false | alternate_for_key | Asc |
| role_key | |||
| idx_approval_history3 | false | person_key | Asc |
| idx_approval_history4 | false | project_key | Asc |
| idx_approval_history5 | false | passed_to | Asc |