| Previous: fin_document | Unanet Data Model | Next: fin_document_attachment |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | fin_document_approval_key | decimal(15) | |||
| 2. | fin_document_key | decimal(15) | fin_document | fk_fd_approval1 | ||
| 3. | performed_by | decimal(15) | person | fk_fd_approval2 | ||
| 4. | performed_for | decimal(15) | person | fk_fd_approval3 | ||
| 5. | project_key | decimal(15) | project | fk_fd_approval4 | ||
| 6. | role_key | decimal(15) | role | fk_fd_approval5 | ||
| 7. | status | varchar(25) | ||||
| 8. | status_timestamp | datetime | ||||
| 9. | comments | varchar(2000) | ||||
| 10. | review_required | char(1) | ('N') | |||
| 11. | review_timestamp | datetime | ||||
| 12. | review_comments | varchar(2000) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| fin_document_key | fin_document | fin_document_key | fk_fd_approval1 |
| performed_by | person | person_key | fk_fd_approval2 |
| performed_for | person | person_key | fk_fd_approval3 |
| project_key | project | project_key | fk_fd_approval4 |
| role_key | role | role_key | fk_fd_approval5 |
| Name | Definition |
| cc_fda_review_required | ([review_required]='N' OR [review_required]='Y') |
| cc_fda_review_ts | ([review_timestamp]>='1900-01-01' AND [review_timestamp]<='2099-12-31') |
| cc_fda_status | ([status]='APPROVED' OR [status]='DISAPPROVED' OR [status]='APPROVING' OR [status]='SUBMITTED' OR [status]='POSTED' OR [status]='INUSE') |
| cc_fda_status_ts | ([status_timestamp]>='1900-01-01' AND [status_timestamp]<='2099-12-31') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_fd_approval | true | fin_document_approval_key | Asc |
| idx_fin_document_approval1 | false | fin_document_key | Asc |
| idx_fin_document_approval2 | false | performed_by | Asc |
| idx_fin_document_approval3 | false | performed_for | Asc |
| idx_fin_document_approval4 | false | project_key | Asc |
| idx_fin_document_approval5 | false | role_key | Asc |