Page 1 of 1
CASS Stage not validating a few valid address records?
Posted: Fri Apr 01, 2011 3:16 am
by jaksani
Hi,
CASS stage not validating a few records.
For Example:
Address Validation Failed:
965 SELLS AVE SW APT 3104 -> Address
ATLANTA GA 30310-1314 -> Area
Address validation Success:
900 REAS FORD RD -> Address
EARLYSVILLE VA 22936-2318 -> Area
Observation in Failure case:
1)Zip4_CASS column has null in Failure case though input record has valid value.
I think this might be the reason for not validating?
If you have any idea please let me know the reason for not validating mentioned record.
Posted: Fri Apr 01, 2011 1:40 pm
by ray.wurlod
You have a 9-digit zip in the failed case, so you should have a value in the Zip4_CASS field.
Posted: Fri Apr 01, 2011 1:53 pm
by rjdickson
The output ZIP4 field would be null if the record failed certification.
Using the information from one of your other posts, what are the codes returned from certification? (The DPV and validation codes). Also, what are the returned delivery address lines?
Posted: Tue Apr 05, 2011 1:16 am
by jaksani
The codes returned from the certification are :
ADDRVAL_MatchFlag_Cass -> NULL
ADDRVAL_DPVCommFloag_CASS -> NULL
ADDRVAL_DPVCode1_CASS -> 'AA'
ADDRVAL_DPVCode2_CASS-> NULL
ADDRVAL_DPVCode3_CASS -> NULL
DeliveryAddressLine1_CASS -> 965 SELLS AVE SW APT 3104
Posted: Tue Apr 05, 2011 7:03 am
by rjdickson
Having a MtchFlag of null and DPVCod1 of AA is unusual. What were the outputs (like ZIP5_CASS, DeliveryPoint_CASS, CITY_CASS, etc)?
Posted: Tue Apr 05, 2011 7:16 am
by jaksani
ZIP5_CASS:30310
DeliveryPoint_CASS:NULL
DeliveryPointChkDigit_CASS:NULL
CarrierRoute_CASS:C019
City_CASS:ATLANTA
State_CASS:GA
Posted: Tue Apr 05, 2011 7:50 am
by rjdickson
Having a CarrierRoute implies that the record certified - and that is confirmed by the 'AA'.
Are you doing any mapping/transformation after the USAC stage, or does the stage go directly to an output file?
Posted: Wed Apr 06, 2011 12:16 am
by jaksani
Yes, doing some transformations.
I am just replacing NULL values in dpvmatchflag and dpvcodes with '' and this is just to prepare Returncode and Return Message for the CASS output.
Posted: Wed Apr 06, 2011 5:26 am
by rjdickson
And what is the derivation on the MatchFlag column?
Posted: Wed Apr 06, 2011 5:28 am
by rjdickson
And what is the derivation on the MatchFlag column?
Posted: Mon Apr 18, 2011 3:03 am
by jaksani
if (IsNotNull(DSLink1671.DPVMatchFlag_CASS)) Then DSLink1671.DPVMatchFlag_CASS Else ""
The above statement is used for derivation of MatchFlag.
Posted: Mon Apr 18, 2011 3:04 am
by jaksani
if (IsNotNull(DSLink1671.DPVMatchFlag_CASS)) Then DSLink1671.DPVMatchFlag_CASS Else ""
The above statement is used for derivation of MatchFlag.