EHI Export Schema
PersonInsuranceAuthorization
Table documenting authorizations for services by patients' insurance.
| Column Name | Data Type | Constraint Type | Is Nullable |
|---|---|---|---|
| PersonInsuranceAuthorizationId | int | PK | NO |
| PersonInsuranceId | int | FK | YES |
| InsuranceAuthorizationName | varchar(50) | YES | |
| ProcedureCodeId | int | FK | YES |
| Quantity | int | YES | |
| Comments | varchar(max) | YES | |
| PeriodStart | datetime | YES | |
| PeriodEnd | datetime | YES | |
| Created | datetime | YES | |
| CreatedBy | varchar(100) | YES | |
| Modified | datetime | YES | |
| ModifiedBy | varchar(100) | YES | |
| Deleted | datetime | YES | |
| DeletedBy | varchar(100) | YES | |
| ProcedureCodeFreeText | varchar(50) | YES |
