SAR_INFO

Description: |
The general/administrative information for a specific case of a SAR (Service Authorization Request). The diagnoses for this section of the SAR can be found in the SAR_INFO_DIAGNOSES table with the same referral and coverage ID. The associated service line adjudication information can be found in the SAR_SVC_LN_INFO table with the same referral and coverage ID.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REFERRAL_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REFERRAL_ID | NUMERIC | No |
The referral ID for the referral record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | SAR_CVG_ID | NUMERIC | No |
The coverage ID for the Service Authorization Request (SAR) adjudication information.
4 | SAR_NUM | VARCHAR | No |
The Service Authorization Request (SAR) number for the Service Authorization Request (SAR) adjudication information.
5 | CCS_CASE_NUM | VARCHAR | No |
The California Children's Services (CCS) case number for the Service Authorization Request (SAR) adjudication information.
6 | SAR_COMMENTS | VARCHAR | No |
The free text comments for the Service Authorization Request (SAR) adjudication information.
7 | CCS_COUNTY_C_NAME | VARCHAR | No |
The county for the Service Authorization Request (SAR) adjudication information.
May contain organization-specific values: Yes
Category Entries:
Alameda
Alpine
Amador
Butte
Calaveras
Contra Costa
Colusa
Del Norte
El Dorado
Fresno
Glenn
Humboldt
Imperial
Inyo
Kern
Kings
Los Angeles
Lake
Lassen
Madera
Mendocino
Merced
Mono
Modoc
Monterey
Mariposa
Marin
Napa
Nevada
Orange
Placer
Plumas
Riverside
Sacramento
Santa Barbara
San Bernardino
San Benito
Santa Clara
Santa Cruz
San Diego
San Francisco
Shasta
Sierra
Siskiyou
San Joaquin
San Luis Obispo
San Mateo
Solano
Sonoma
Stanislaus
Sutter
Tehama
Trinity
Tulare
Tuolumne
Ventura
Yolo
Yuba
8 | SAR_PROV_GRP_NUM | VARCHAR | No |
The provider group number for the Service Authorization Request (SAR) adjudication information.
9 | SAR_PROV_NUM | VARCHAR | No |
The provider number (NPI) for the Service Authorization Request (SAR) adjudication information.
10 | SAR_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
11 | SAR_PROV_DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
12 | SAR_PROV_FAC_NUM | VARCHAR | No |
The facility number for the Service Authorization Request (SAR) adjudication information.
13 | SAR_REF_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.