| Previous: member | Unanet Data Model | Next: mie_per_diem_detail |
| Column Name | Data Type | Default Value |
References Table |
Foreign Key Name |
||
| 1. | PK | expense_data_key | decimal(15) | expense_data | fk_mie_allowable_detail1 | |
| 2. | country_state_name | varchar(45) | ||||
| 3. | city_county_name | varchar(45) | ||||
| 4. | rate | decimal(15,3) | ((0.000)) | |||
| 5. | prorated_rate | decimal(15,3) | ((0.000)) | |||
| 6. | overage | decimal(15,3) | ((0.000)) | |||
| 7. | first_day | char(1) | ('N') | |||
| 8. | last_day | char(1) | ('N') | |||
| 9. | breakfast_provided | char(1) | ('N') | |||
| 10. | lunch_provided | char(1) | ('N') | |||
| 11. | dinner_provided | char(1) | ('N') | |||
| 12. | breakfast_amount | decimal(15,3) | ((0.000)) | |||
| 13. | lunch_amount | decimal(15,3) | ((0.000)) | |||
| 14. | dinner_amount | decimal(15,3) | ((0.000)) | |||
| Column | References | Foreign Key Name | |
| Table | Column | ||
| expense_data_key | expense_data | expense_data_key | fk_mie_allowable_detail1 |
| Name | Definition |
| cc_mad_breakfast_provided | ([breakfast_provided]='N' OR [breakfast_provided]='Y') |
| cc_mad_dinner_provided | ([dinner_provided]='N' OR [dinner_provided]='Y') |
| cc_mad_first_day | ([first_day]='N' OR [first_day]='Y') |
| cc_mad_last_day | ([last_day]='N' OR [last_day]='Y') |
| cc_mad_lunch_provided | ([lunch_provided]='N' OR [lunch_provided]='Y') |
| Index Name | Unique | Column Name | Asc Or Desc |
| pk_mie_allowable_detail | true | expense_data_key | Asc |