| Previous: cost_struct_pool | Unanet Data Model | Next: credit_card |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | cost_struct_pool_rate_key | decimal(15) | |||
| 2. | cost_struct_pool_key | decimal(15) | cost_struct_pool | fk_cost_struct_pool_rate1 | ||
| 3. | fiscal_year_key | decimal(15) | fiscal_year | fk_cost_struct_pool_rate2 | ||
| 4. | modifier_key | decimal(15) | person | fk_cost_struct_pool_rate3 | ||
| 5. | modified_date | datetime | ||||
| 6. | target_rate | decimal(15,12) | ((0)) | |||
| 7. | provisional_rate | decimal(15,12) | ((0)) | |||
| 8. | actual_rate | decimal(15,12) | ((0)) | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| cost_struct_pool_key | cost_struct_pool | cost_struct_pool_key | fk_cost_struct_pool_rate1 |
| fiscal_year_key | fiscal_year | fiscal_year_key | fk_cost_struct_pool_rate2 |
| modifier_key | person | person_key | fk_cost_struct_pool_rate3 |
| Name | Definition |
| cc_cspr_actual_rate | ([actual_rate]>=(0)) |
| cc_cspr_provisional_rate | ([provisional_rate]>=(0)) |
| cc_cspr_target_rate | ([target_rate]>=(0)) |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_cost_struct_pool_rate | true | cost_struct_pool_rate_key | Asc |
| idx_cost_struct_pool_rate1 | true | cost_struct_pool_key | Asc |
| fiscal_year_key | |||
| idx_cost_struct_pool_rate2 | false | fiscal_year_key | Asc |
| idx_cost_struct_pool_rate3 | false | modifier_key | Asc |