AIAuthorizeSource_vw

Primary key - Authorization unique identifier linking to core authorization record

Patient reference - Links to the patient receiving authorized services (foreign key to Patient.PatientID)

IFSP reference - Links to the Individualized Family Service Plan governing the authorization (foreign key to Ifsp.IfspID)

Case reference - Links to the patient’s case administration record (foreign key to PatientAdministration.AdmitID)

Patient last name - Patient’s family name for identification and reporting purposes

Patient first name - Patient’s given name for identification and reporting purposes

EI Hub identifier - Each child has an ID assigned by EI, stored in dbo.PatientIDList table. EI Hub ID corresponds to IdTypeID = 14. Lookup ID types in ics2.dbo.PatientIDTypes table for cross-system integration

Patient birth date - Patient’s date of birth for age calculations and eligibility determination

Payment source - Paysource name with lookup reference to dbo.PaymentSource_vw table representing the county or funding source covering the authorized services

Authorization duration - Number of weeks the authorization is valid for service delivery

Authorized units - Total number of service units approved for delivery under this authorization

Session duration - Length of each service session in minutes as specified in the authorization

Service frequency - Number of service days per specified period (weekly, monthly, etc.)

Authorization start date - When the authorized services can begin delivery

Authorization end date - When the authorized services must be completed

Service type - Service name with lookup reference to ics2.dbo.ServiceType table (e.g., Speech Therapy, Physical Therapy)

Service modifier - Modifier name with lookup reference to ics2.dbo.Modifier table for additional service specification or billing modifier affecting service delivery or reimbursement

Procedure code - Procedure name with lookup reference to ics2.dbo.ProcCode table, CPT or other procedure code identifying the specific service for billing and documentation

First service date - Get the Min DateService of te claim that tied to te auth. Date when the first billable service was delivered under this authorization

Last service date - Get the Max DateService of te claim that tied to te auth. Date when the most recent billable service was delivered under this authorization

Session description - Formatted description combining session duration, frequency, and delivery pattern for easy reference

Days remaining - Current Date - EndDate of the aut. Number of days remaining before the authorization expires

Service location - Name of the facility or location with lookup reference to dbo.Locations table where services are delivered

Units remaining - Calculated as: Authorization Units – Sum of Units from claims linked to the authorization, where the claim status is not in Non-Billable, Void, or Deleted. Note: Although UnitUsed exists, calculating the sum directly is more accurate

Authorization status - Current status of the authorization (Active=services can be delivered, Inactive=services suspended, Expired=authorization ended)

Assigned providers - Displays all users assigned to the authorization through the AuthorizeTherapist table. Comma-separated list of healthcare providers assigned to deliver services under this authorization

Utilization percentage - Percentage of authorized services that have been completed, calculated as used units divided by total units

Units used - Sum of Units from claims linked to the authorization. Number of service units that have been delivered and billed under this authorization

Program name - Name of the service program with lookup reference to Ics2.dbo.ProgramType table or intervention type under which services are delivered

Case site - Display site of the kid. Bridge table: dbo.CaseSite, Lookup table: dbo.AgencySite. Primary service delivery site or agency location managing the case

Authorization type - Classification of authorization with lookup reference to dbo.Option_VW table (Initial=first authorization, Renewal=continuation, Amendment=modification)

Prior authorization number - Insurance or payer-assigned prior authorization number for billing and claims processing

Group service type - Indicates whether services are delivered individually or in group settings

IFSP plan date - Date when the Individualized Family Service Plan was created or last updated

IFSP closure date - Date when the IFSP was closed or services were discontinued

IFSP comments - Additional notes or comments related to the IFSP and service planning

IFSP status - Current status of the Individualized Family Service Plan (Active=services ongoing, Closed=services completed, Suspended=services temporarily stopped)