| Previous: accrual_plan | Unanet Data Model | Next: acct_cost_pool_tree |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | accrual_schedule_key | decimal(15) | |||
| 2. | accrual_plan_key | decimal(15) | accrual_plan | fk_accrual_schedule1 | ||
| 3. | months_of_service | decimal(4) | ||||
| 4. | exceed_allowed | char(1) | ('N') | |||
| 5. | accrual_hours | decimal(15,12) | ||||
| 6. | cap_hours | decimal(15,5) | ||||
| 7. | cap_type | char(1) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| accrual_plan_key | accrual_plan | accrual_plan_key | fk_accrual_schedule1 |
| Name | Definition |
| cc_accrual_schedule_cap | ([cap_type]='P' OR [cap_type]='C' OR [cap_type]='H' OR [cap_type]='N') |
| cc_accrual_schedule_exceed | ([exceed_allowed]='N' OR [exceed_allowed]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_accrual_schedule_key | true | accrual_schedule_key | Asc |
| idx_accrual_schedule1 | true | accrual_plan_key | Asc |
| months_of_service |