| Previous: person_account | Unanet Data Model | Next: person_accrual_plan |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | accrual_plan_key | decimal(15) | accrual_plan | fk_person_accrual1 | ||
| 2. | person_accrual_plan_key | decimal(15) | person_accrual_plan | fk_person_accrual5 | ||
| 3. | accrual_period_key | decimal(15) | accrual_period | fk_person_accrual6 | ||
| 4. | person_key | decimal(15) | person | fk_person_accrual2 | ||
| 5. | project_key | decimal(15) | project | fk_person_accrual3 | ||
| 6. | task_key | decimal(15) | task | fk_person_accrual4 | ||
| 7. | posted_by_key | decimal(15) | ||||
| 8. | posted_timestamp | datetime | ||||
| 9. | source_ind | char(1) | ('I') | |||
| 10. | accrued_hours | decimal(17,12) | ||||
| 11. | comments | varchar(2000) | ||||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| accrual_period_key | accrual_period | accrual_period_key | fk_person_accrual6 |
| accrual_plan_key | accrual_plan | accrual_plan_key | fk_person_accrual1 |
| person_key | person | person_key | fk_person_accrual2 |
| person_accrual_plan_key | person_accrual_plan | person_accrual_plan_key | fk_person_accrual5 |
| project_key | project | project_key | fk_person_accrual3 |
| task_key | task | task_key | fk_person_accrual4 |
| Name | Definition |
| cc_person_accrual_source_ind | ([source_ind]='T' OR [source_ind]='C' OR [source_ind]='U' OR [source_ind]='P' OR [source_ind]='A' OR [source_ind]='I') |
| Index Name | Unique | Column Name | Asc Or Desc |
| idx_person_accrual1 | false | accrual_plan_key | Asc |
| person_accrual_plan_key | |||
| person_key | |||
| project_key | |||
| task_key | |||
| idx_person_accrual2 | false | person_accrual_plan_key | Asc |
| idx_person_accrual3 | false | person_key | Asc |
| idx_person_accrual4 | false | project_key | Asc |
| idx_person_accrual5 | false | task_key | Asc |
| idx_person_accrual6 | false | accrual_period_key | Asc |