| Previous: accrual_period | Unanet Data Model | Next: accrual_schedule |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | accrual_plan_key | decimal(15) | |||
| 2. | accrual_plan | varchar(50) | ||||
| 3. | description | varchar(128) | ||||
| 4. | period_type | char(1) | ||||
| 5. | begin_date | datetime | ||||
| 6. | begin_date2 | datetime | ||||
| 7. | carryover_ind | char(1) | ('N') | |||
| 8. | active | char(1) | ('Y') | |||
| 9. | posting_type | char(1) | ('M') | |||
| 10. | posting_emails | varchar(2000) | ||||
| Table | Column | Foreign Key Name |
| accrual_period | accrual_plan_key | fk_accrual_period1 |
| accrual_schedule | accrual_plan_key | fk_accrual_schedule1 |
| person_accrual | accrual_plan_key | fk_person_accrual1 |
| person_accrual_plan | accrual_plan_key | fk_person_accrual_plan1 |
| Name | Definition |
| cc_accrual_plan_active | ([active]='N' OR [active]='Y') |
| cc_accrual_plan_begin_date | ([begin_date]>='1900-01-01' AND [begin_date]<='2099-12-31') |
| cc_accrual_plan_begin_date2 | ([begin_date2]>='1900-01-01' AND [begin_date2]<='2099-12-31') |
| cc_accrual_plan_co_ind | ([carryover_ind]='N' OR [carryover_ind]='Y') |
| cc_accrual_plan_period | ([period_type]='Y' OR [period_type]='B' OR [period_type]='S' OR [period_type]='W' OR [period_type]='M') |
| cc_accrual_plan_posting_type | ([posting_type]='E' OR [posting_type]='B' OR [posting_type]='M') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_accrual_plan | true | accrual_plan_key | Asc |
| idx_accrual_plan1 | true | accrual_plan | Asc |