CODE_VALUE CODE_DESCRIPTION CODE_TYPE A Bad/Nonexisting Case Num specification ISSUE_CODE C Found in court data only ISSUE_CODE D Dash removal/cleaning from Case Num ISSUE_CODE E Dash removal/cleaning from SSN1 ISSUE_CODE F Dash removal/cleaning from SSN2 ISSUE_CODE G Pipe removal/Cleaning from CustCode ISSUE_CODE H Invalid Check Number ISSUE_CODE I Inactive - court case_code indicates case is not Open (must be Discharged, Dismissed, Transferred) ISSUE_CODE K Bad/Nonexisting court_code -- NOT USED ISSUE_CODE N Invalid SSN2 (either 0000 or <> 4 characters) ISSUE_CODE P Non Participating Trustee ID ISSUE_CODE Q SSN2 Redacted ISSUE_CODE R SSN1 Redacted ISSUE_CODE S Invalid SSN1 (either 0000 or <> 4 characters) ISSUE_CODE T Invalid/Nonexisting Trustee ID ISSUE_CODE U Unusable data, no trusteeID and case_num ISSUE_CODE X Expired case match (closed/no activity > 720 days) OR trustee marked Do Not Display ISSUE_CODE 001 D1_L4/D1_LN/D1_FN/Address/City/State MATCH 002 D1_L4/D1_LN/D1_FI/Address/City/State MATCH 003 D1_L4/D1_LN/D1_FN/Address/State MATCH 004 D1_L4/D1_LN/D1_FI/Address/State MATCH 005 D1_L4/D1_LN/D1_FN/State MATCH 006 D1_L4/D1_FN_F3/Address MATCH 007 D1_LN/D1_FN/Address/City/State MATCH 008 D1_L4/Address/INP_LN & NDC_D1_FN/INP_FN & NDC_D1_LN MATCH 009 D1_L4/D1_LN/D1_FN_F3/City/State MATCH 010 D2_L4/D2_LN/D2_FN/Address/City/State MATCH 011 D2_L4/D2_LN/D2_FI/Address/City/State MATCH 012 D2_L4/D2_LN/D2_FN/Address/State MATCH 013 D2_L4/D2_LN/D2_FI/Address/State MATCH 014 D2_L4/D2_LN/D2_FN/State MATCH 015 D2_L4/D2_FN_F3/Address MATCH 016 D2_LN/D2_FN/Address/City/State MATCH 017 D2_L4/Address/INP_LN & NDC_D2_FN/INP_FN & NDC_D2_LN MATCH 018 D2_L4/D2_LN/D2_FN_F3/City/State MATCH 019 D1_L4/D1_LN/City/State/Zip MATCH 020 D1_L4/D1_FN/City/State/Zip MATCH 021 D1_L4/D1_LN/City/State MATCH 022 D1_L4/INP_FN & D1_LN OR INP_LN & D1_FN/City/State MATCH 03 Match on case num & last four input ssn2 = last four ndc ssn1 TEST 04 Match on NDC data only trusteeID & case num -- NOT USED TEST 05 Check for matching case_num and last 4 input ssn1 = last 4 ndc ssn1 -- NOT USED TEST 06 Match on case num & last four input ssn1 = last four ndc ssn2 TEST 07 Match on input SSN1 = NDC SSN1 only (latest PETITION_FILE_DT, Open cases ONLY) -- NOT USED TEST 08 Match on input SSN1 = NDC SSN2 only -- NOT USED TEST 09 Match on input SSN2 = NDC SSN1 only -- NOT USED TEST 10 Match on input SSN2 = NDC SSN2 only -- NOT USED TEST 11 Match on first four TrusteeID, case num, & last 4 ssn1 TEST 12 Match on TrusteeID, last four input ssn1 = last four ndc ssn1, & last four case num TEST 13 Match on TrusteeID, last four input ssn1 = last four ndc ssn2, & last four case num TEST 14 Check for matching case_num and last 4 input ssn2 = last 4 ndc ssn2 -- NOT USED TEST 15 Check for matching case_num and last 4 input ssn1 = last 4 ndc ssn2 -- NOT USED TEST 16 Check for matching case_num and last 4 input ssn2 = last 4 ndc ssn1 -- NOT USED TEST 17 Match on TrusteeID & input ssn1 = ndc ssn1 TEST 18 Match on TrusteeID & input ssn1 = ndc ssn2 TEST 19 Match TrusteeID + CheckNumber TEST 90 Set 'X'= expired flag on any returned results TEST 99 Match generated from customer_case_map, normal matching will be skipped TEST 02 Match on case num & last four input ssn1 = last four ndc ssn1 TEST 01 Match on trusteeID & case num TEST 00 Match on court code + case num -- NOT USED TEST