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	VARCHAR	No
	The provider ID for the Service Authorization Request (SAR) adjudication information.
11	SAR_PROV_DEPT_ID	NUMERIC	No
	The department ID for the Service Authorization Request (SAR) adjudication information.
12	SAR_PROV_FAC_NUM	VARCHAR	No
	The facility number for the Service Authorization Request (SAR) adjudication information.
13	SAR_REF_PROV_ID	VARCHAR	No
	The referring provider ID for the Service Authorization Request (SAR) adjudication information.