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.