Authorizations: Standard Extract Table
The Authorization data table details information about the authorization as added to the WebPT EMR. This includes the authorization data as well as the related patient, case, insurance, and clinic.
Data Element | Type | Description |
record_id | Integer | Unique ID for the authorization |
authorization_id | Integer | authorization id may not be unique |
case_id | Integer | Reference to the cases file for the case_id field |
auth_number | String | Authorization number |
auth_start_date | Date | Start date of the authorization |
auth_end_date | Date | End data of the authorization |
visit_authorized_for | Integer | Number of visits for the authorization |
notes | String | Notes about the authorization |
authorization_status | String | Status of the authorization A = Active and I = Inactive |
patient_id | Integer | Reference to the patient file for the patient_id field |
clinic_id | Integer | Reference to the clinic file for the clinic_id field |
modified_date | Date | Date Authorization was changed |
ins_name | string | Insurance Name |
policy_number | string | Policy Number |
group_number | string | Group Number |
payer_type | string | Payer Type |
export_flag | Integer | Export flag 1 = New, 2 = Modified, 3 = Removed |