| Previous: leave_request | Unanet Data Model | Next: list_criteria |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | leave_request_approval_key | decimal(15) | |||
| 2. | leave_request_key | decimal(15) | leave_request | fk_leave_request_approval1 | ||
| 3. | person_key | decimal(15) | person | fk_leave_request_approval2 | ||
| 4. | alternate_for_key | decimal(15) | person | fk_leave_request_approval3 | ||
| 5. | role_key | decimal(15) | role | fk_leave_request_approval4 | ||
| 6. | status | varchar(25) | ||||
| 7. | status_timestamp | datetime | ||||
| 8. | comments | varchar(2000) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| leave_request_key | leave_request | leave_request_key | fk_leave_request_approval1 |
| person_key | person | person_key | fk_leave_request_approval2 |
| alternate_for_key | person | person_key | fk_leave_request_approval3 |
| role_key | role | role_key | fk_leave_request_approval4 |
| Name | Definition |
| cc_leave_request_app_status | ([status]='LOCKED' OR [status]='CANCELED' OR [status]='APPROVING' OR [status]='DISAPPROVED' OR [status]='COMPLETED' OR [status]='SUBMITTED' OR [status]='INUSE') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_leave_request_approval | true | leave_request_approval_key | Asc |
| idx_leave_request_approval1 | false | leave_request_key | Asc |
| idx_leave_request_approval2 | false | alternate_for_key | Asc |
| role_key | |||
| idx_leave_request_approval3 | false | person_key | Asc |