Reconciliation Glossary

Critical and Non-Critical Data Fields

Critical Data Fields

Critical data fields have an impact on a client’s eligibility. Recon discrepancy worker alerts are generated when discrepancies are found in critical data fields. The critical Recon data fields are as follows:

ABAWD-DATE	RESIDENCE-ADDRESS
ABAWD-IND	RESIDENCE-COUNTY
ESAC	RESTRICTION
LTC-IND	SEX
MAILING-ADDRESS	SOC-AMOUNT
OHC	TERM-DATE
RECIPIENT-NAME	TERM-REASON
REDETERM-DATE

Non-Critical Data Fields

Non-critical data fields do not have impact on a client’s eligibility. Recon discrepancy worker alerts are not issued when discrepancies are found in non-critical data fields. The following data fields are non-critical:

ALIEN-ELIG	ETHNIC
ALIEN-NO	MBI/HIC-NO
ALIEN-SPONSOR-STATUS	INS-ENTRY-DATE
AUTH-REP-ADDRESS	LANGUAGE-WRITTEN
AUTH-REP-NAME	LANGUAGE-SPOKEN
BIRTHDATE-VER	ORIG-AID
CA - DL/ ID-NO	PHONE
CASE-NAME	REFUGEE/ALIEN-IND
COUNTRY-OF ORIGIN	SSN-VER
DISTRICT	TITLE II-CLAIM NO
EW-CODE

Updatable and Non-Updatable Data Fields

Updatable data fields are those data fields that generate a Recon update transaction when discrepancies are found. Currently, all data fields are “Updatable” except for the following:

ABAWD-Date and ABAWD-Ind

Due to complications counties may experience in maintaining this information, the State Department of Social Services has requested that discrepancies found in these data fields be reported to the counties, but not be updated on MEDS.

Redeterm-Date

This data field is not Updatable ONLY when it exists on MEDS but not on the county Recon file. An alert will be generated to notify the EW of the discrepancy, but the MEDS data will not be updated. When this data field is found on the county Recon record, it is considered Updatable and will be added to the Recon update transactions.

Reportable and Non-Reportable Data Fields

Reportable data fields are those data fields that generate a Recon alert when discrepancies are found during the Recon process. The following are the only data fields that will be displayed on an alert when discrepancies are found:

Eligibility Data Fields

ABAWD-DATE	RESTRICTION
ABAWD-IND	SOC-AMT
ESAC	TERM-DATE
LTC-IND	TERM-REAS
REDETERM-DATE

Client Data Fields

MAILING-ADDRESS	RESIDENCE-COUNTY
OHC	SEX
RESIDENCE-ADDRESS

Address

Discrepancies in the mailing or residence address fields are reported ONLY when the discrepancy is in the barcode and secondary delivery number. Otherwise, discrepancies in address fields are not reported. Discrepancies in the authorized representative address fields are NOT reported.

Other Definitions

Bypassed Record

A record on the county CalSAWS Recon file which contained an Aid Code that is bypassed for the county Recon process. These Aid Codes are valid to MEDS, but not for county use (e.g., Healthy Families Aid Code).

Case Data

Case data includes DISTRICT, EW-CODE, and CASE-NAME.

Client Data

Client data includes:

ALIEN-ELIG	MAILING-ADDRESS
ALIEN-NO	NAME
ALIEN-SPONSOR-STATUS	OHC
AUTH-REP-ADDRESS	ORIG-AID
AUTH-REP-NAME	PHONE
BIRTHDATE-VER	REFUGEE/ALIEN-IND
CA - DL/ ID-NO	RESIDENCE-ADDRESS
COUNTRY-OF ORIGIN	RESIDENCE-COUNTY
ETHNIC	RESTRICTION
HIC-NO	SEX
INS-ENTRY-DATE	SSN-VER
LANGUAGE-SPOKEN	TITLE II-CLAIM NO
LANGUAGE-WRITTEN

Critical Eligibility Error

A fatal data validation error in at least one of the following Recon critical eligibility data fields:

AID CODE	MEDS-ID
CIN	PERSON NUMBER
CIN/MEDS-ID CONFLICT	RESTRICTION
COUNTY-ID/MEDS-ID CONFLICT	SERIAL NUMBER
DATE OF BIRTH	SOC-AMOUNT
ESAC	TERM-DATE
FBU

Critical Recon Fields

Eligibility and client data fields that have an impact on a client’s eligibility or ability to access medical services.

Refer to Critical and Non-Critical Data Fields for a listing of these data fields.

Duplicate Record

A record on the county Recon files that is a duplicate record in the MEDS Recon process. A duplicate record has the same MEDS-ID, COUNTY-CODE and SEGMENT-TYPE.

Eligibility Data

Eligibility data includes:

ABAWD-DATE	LTC-IND
ABAWD-IND	SOC-AMOUNT
REDETERM-DATE	TERM-DATE
ESAC	TERM-REAS

Excluded Record

A record on the county Recon file which contained an Aid Code that is excluded from the county Recon process. These Aid Codes are valid county Aid Codes but are not reconciled. These include the Minor Consent and IE/RR Aid Codes.

Reportable Field

Data fields that generate a Recon alert when discrepancies are found.

[Refer to “Reportable and Non-Reportable Data Fields”] for a list of these data fields.]

Segment-Type

The eligibility segment associated with a specific Medi-Cal or CalFresh eligibility program. Valid segment types are assigned by MEDS based on the Aid Code and transaction code on the county MEDS reconciliation transaction. Examples of valid segment types include:

PRIMRY	Primary Medi-Cal
FSTAMP	Food Stamp
CHILD	Children Programs
DI/TPN	Dialysis and TPN
TB	Tuberculosis
MEDICR	Medicare
IH/PCS	In-Home/Personal Care Services
CMSP	County Medical Services Program
GR/CAP	General Relief/Cash Assistance to Program Immigrants
CCS/GHP	California Children Services/Genetically Handicapped Persons Program