11-Attachment 6 - File Transfer Data v0.01.xlsx
XLSX spreadsheet 43 KB Posted
- Attached to
- Paternity Testing Services Request for Proposal
- Solicitation number
- 302–27–02246
- Issued by
- Texas
About this file
This document is an Excel file detailing technical specifications for a Paternity Testing Services contract from the Texas Office of the Attorney General (OAG). The file provides comprehensive data field requirements for processing paternity testing transactions, including detailed instructions for tracking case identification, sample collection, testing, and result reporting. The contract involves a structured electronic file transfer system with specific transaction codes (T010-T090) covering various stages of paternity testing, from initial scheduling through result posting.
The file outlines precise data field requirements, including mandatory and optional fields for tracking case members (alleged fathers, custodial parents, dependents), draw site information, collection dates and times, and result processing. Notable technical specifications include handling special circumstances like domestic violence indicators, jail collections, out-of-state testing, and various irregularity codes. The contract appears designed to standardize paternity testing documentation and ensure consistent, detailed tracking of genetic testing services across different collection scenarios and jurisdictions.
View the file
Other files
Show all 17
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Contractor to OAG File
| Field Number | Field Name | Format | Length | Field Definition | Edit Criteria | Required Data Fields for Transaction Code - TC010 Appointment Scheduled By Contractor | Required Data Fields for Transaction Code TC020 - Appointment Rescheduled by Contractor | |
| OAG FILE INITIATED | Required Data Fields for Transaction Code TC020 - Appointment Rescheduled by Contractor | |||||||
| OAG FORM INITIATED | Required Data Fields for Transaction Code TC030 - Show = Sample Collected | |||||||
| OAG FILE INITIATED | Required Data Fields for Transaction Code TC030 - Show = Sample Collected | |||||||
| OAG FORM INITIATED | Required Data Fields for Transaction Code TC040 - No Sample Collected | Required Data Fields for Transaction Code TC050 -Sample Received at Contractor | Required Data Fields for Transaction Code TC060 - Sample Tested | Required Data Fields for Transaction Code TC070 - Results Posted "AF" | ||||
| OAG FILE INITIATED | Required Data Fields for Transaction Code TC070 - Results Posted "AF" | |||||||
| OAG FORM INITIATED | Required Data Fields for TC071 - Results Posted "DP" | |||||||
| OAG File Initiated | Required Data Fields for TC071 - Results Posted "DP" | |||||||
| OAG Form Initiated | Required Data Fields for Transaction Code TC080 -Hardcopy Result Mailed to OAG | Required Data Fields for Transaction Code TC90-Collection Irregularity | ||||||
| 1 | CASE-ID | A | 10 | OAG Case Identification Number | Must be valid Case ID on TXCSES |
Must Use OAG Length/Format of Outbound File
| Must match a Case ID on outgoing file | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
| 2 | NOTE-TIME-STAMP | A | 16 | The Note Time Stamp is the date and time a NOTE record was added to the record being accessed. | ||||||||||||||||
| Must be present if in the OAG Outbound file | Optional | Yes | Blank | Yes | Blank | Yes | Yes | Yes | Yes | Blank | Yes | Blank | Yes | Yes | ||||||
| 3 | NOTE-ENTRY-1 | A | 250 | Notes | Optional | Optional | Must contain the father's last name in field 27 (for 20 characters), father's first name in field 46 (for 15 characters), and middle name in field 60 (for 10 characters). | Optional | Must contain the father's last name in field 27 (for 20 characters), father's first name in field 46 (for 15 characters), and middle name in field 60 (for 10 characters). | Optional | Optional | Optional | Optional | Blank | Optional | Blank | Yes | Yes | ||
| 4 | DRAW-VENDOR-ID | A | 10 | The Draw Vendor ID is the contact ID of the paternity vendor that will perform the draw. Will either be populated by OAG or vendor? | ||||||||||||||||
| Must be present if a collection transaction type | Yes | Yes | Yes. Use Vendor's Name | Yes | Yes. Use Vendor's Name | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
| 5 | NOTIFN-ID | A | 10 | |||||||||||||||||
| Yes | Yes | Blank | Yes | Blank | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||||
| 6 | MBR-RTC | A | 2 | Party Record 1 Member Relationship to Case. | Yes | Yes | Yes. For the mother, use "CP", for the child use "DP", and for the father use "AF" | Yes | Yes. For the mother, use "CP", for the child use "DP", and for the father use "AF" | Yes | Yes | Yes | Yes. Use value from OAG file. | Yes. For father, use "AF". | Yes | For the child, use "DP" | Yes | Yes | ||
| 7 | NAME-LAST | A | 20 | Party Record 1 Last Name * If suffix is present it will appear in this field. | Yes | Yes | Yes. Should be name from form | Yes | Yes. Should be name from form | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 8 | NAME-FIRST | A | 15 | Party Record 1 First Name | Yes | Yes | Yes. Should be name from form | Yes | Yes. Should be name from form | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 9 | NAME-MIDDLE | A | 10 | Party Record 1 Middle Name | Yes | Yes | Yes. Should be name from form | Yes | Yes. Should be name from form | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 10 | MBR-ID-SCHD | A | 8 | The Member Id Schedule is the member id of the person scheduled for a paternity blood test. | Yes | Yes | Blank | Yes | Blank | Yes | Yes | Yes | Yes | Blank | Yes | Blank | Yes | Yes | ||
| 11 | DRAW-SITE-NAME | A | 25 | The Draw Site Description identifies the physical draw site location where blood was taken from the member for a paternity test. | Yes | Yes | Yes. Vendor will need to populate with draw site location. | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes, Vendor will need to populated with draw site location | Yes | Yes | ||
| 12 | DRAW-SITE-ADDR-1 | A | 25 | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes, Vendor will need to populated with draw site location | Yes | Yes | |||
| 13 | DRAW-SITE-ADDR-2 | A | 25 | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes, Vendor will need to populated with draw site location | Yes | Yes | |||
| 14 | DRAW-SITE-ADDR-3 | A | 25 | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes, Vendor will need to populated with draw site location | Yes | Yes | |||
| 15 | DRAW-SITE-ADDR-CITY | A | 20 | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes, Vendor will need to populated with draw site location | Yes | Yes | |||
| 16 | DRAW-SITE-ADDR-ST-CODE | A | 2 | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes, Vendor will need to populated with draw site location | Yes | Yes | |||
| 17 | DRAW-SITE-ZIP-CODE | A | 11 | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes, Vendor will need to populated with draw site location | Yes | Yes | |||
| 18 | DRAW-SITE-CTRY-CODE | A | 3 | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes | Yes | Yes | Yes. Vendor will need to populated with draw site location. | Yes | Yes, Vendor will need to populated with draw site location | Yes | Yes | |||
| 19 | DRAW-DATE | A | 10 | Party Record 1 Draw Date | Yes | Yes | Yes, vendor will need to populate with reschedule draw date. | No | Yes, vendor will need to populate with scheduled draw date. | No | No | No | Yes | Yes, vendor will need to populate with scheduled draw date. | Yes | Yes, vendor will need to populate with scheduled draw date. | No | Yes | ||
| 20 | DRAW-TIME | A | 10 | The Draw Date and Time is when blood was drawn from a member associated with a case. | Yes | Yes | Yes, vendor will need to populate with reschedule draw time. | No | Yes, vendor will need to populate with scheduled draw time. | No | No | No | Yes | Yes, vendor will need to populate with scheduled draw time. | Yes | Yes, vendor will need to populate with scheduled draw time. | No | Yes | ||
| 21 | DRAW-OPTN-CD | A | 1 | The Draw Option Code identifies the draw option selected when the PTST record is initialized. | Must be present | |||||||||||||||
| Yes. Use the provided data from the OAG file. | Yes | Yes. Value should be "N". | Yes | Yes. Value should be "N". | Yes | Yes | Yes | Yes | Yes. Value should be "N". | Yes | Yes. Value should be "N" | Yes | Yes | |||||||
| 22 | ADDITIONAL INFORMATION | A | 10 | Optional | Yes | Blank | Yes | Blank | Yes | Yes | Yes | Yes | Blank | Yes | Blank | Yes | Yes | |||
| 23 | PROB-PCT | A | 4 | Probability Percent is the probability percentage in establishing paternity. | ||||||||||||||||
| Must be present if Transaction is a Test Result | No | No | No | No | No | No | No | Yes | No | No | Yes | Yes | No | No | ||||||
| 24 | APPEARANCE INDICATOR | A | 1 | In REFG/ Ref ID: APRC |
A - AWT Awaiting Scheduling B - SCH Currently Scheduled C - Can Canceled N - NSH No Show P - SNP - See Notepad R - RSC - Rescheduled S - SHO Show T- TRR- Test Results
| *** Discuss and ensure the vendor passes back the appearance indicator as well as the transaction code**** | Must be populated | |||||||||||||
| Must be valid TXCSES Appearance Indicator | Must be "B" | Must be "R" | Must be "R" | Must be "S" | Must be "S" | Must be "N" | Must be present | Must be present | Must be "T" | Must be "T" | Must be "T" | Must be "T" | Must exist | Must exist |
| 25 | TRANSACTION CODE | A | 4 | T010 - Scheduled |
T020 - Rescheduled T030 - Show T040 - No Show T050 - Sample Received T060 - Sample Tested T070 - Result Posted T071 - Result /Dependent T080 -Hardcopy Result Mail
| T090 - Collection Irregularity | Must be populated | |||||||||||||||||||
| Must be a valid Transaction Code | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
| 26 | TRANSACTION DATE | A | 10 | Date Transaction occurred. Linked to the transaction code field | Must be populated | |||||||||||||||
| Must be a valid date with format of MMDDYYYY | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
| 27 | IRREGULARITY CODE | A | 4 | See Attachment 7 | Must be populated if there is an irregularity of some kind. (Example Lost, Damaged, Missing Signature). | No | No | No | No | No | No | No | No | No | No | No | No | No | Yes | |
| 28 | DRAW TYPE CODE | A | 10 | Draw Type Sub Code | Must be present if provided by the OAG outbound record. | Optional | Optional | Blank | Optional | Blank | Yes | Yes | Yes | Yes | Blank | Optional | Blank | Optional | Optional | |
| 29 | OFFICE CODE | A | 5 | OAG Office Code | Must be present | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 30 | DATE OF BIRTH | A | 10 | Member's Date of Birth | Must be present. | |||||||||||||||
| Format must be MM/DD/YYYY | Yes | Yes | Yes. Must be collected by vendor. | Yes | Yes. Must be collected by vendor. | Yes | Yes | Yes | Yes | Yes. Must be collected by vendor | Yes | Yes. Must be collected by vendor. | Yes | Yes |
Transaction Codes
| Transaction Code | Transaction De-coded | Date Should Be Used to Populate Transaction Date |
| T000 | Referral Complete | This should be the date the last party scheduled was sent to the Contractor which completed the referral for testing - meaning the Contractor has a father, at least 1 child and mother (or entry for motherless). If all parties are sent as one complete referral at the same time, then this transaction should come the next day to the OAG. If one or more parties are scheduled later than the others to be tested, then this transaction will come when the last assumed party is received (1 father, 1 mother or motherless and 1 child will be assumed to be a complete referral). |
| T010 | Appointment Scheduled by Contractor | This should be the date the appointment was scheduled in the Contractor's system for system generated referrals. This transaction would be sent reflecting the date of collection when having a form generated referral. The date and time of the actual collection should appear in the DrawDate and DrawTime columns. |
| T020 | Appointment Rescheduled by Contractor | This should be the date the appointment was rescheduled in the Contractor's system - not the date the collection is expected to take place. The date and time of the actual collection should appear in the DrawDate and DrawTime columns. |
| T030 | Show = Sample Collected | This should be the actual date the sample was collected - not the date of the T030 was created and not the date the sample was received at the Contractor's lab. These transactions should come as they are occurring (i.e. don't wait until all samples are collected). |
| T040 | No Show - No Sample Collected | This should be the actual date the person was supposed to show but did not show - not the date of the T040 was created. Note: The actual date of the No Show should be kept by the Contractor for when attesting that the party did not appear for their appointment(s). |
| T050 | Sample Received at Contractor | This should be the actual dtate the sample was received at the Contractor's testing location - not the date the transaction was created in the Contractor's system. OAG should get a T050 on each and every sample whether collected by the Contractor or OAG. These transactions should come as they are occurring (i.e. don't wait until all samples are received). |
| T060 | Sample Tested | This should be the actual date the samples were tested at the lab - not the date the transaction was created in the Contractor's system. OAG should get a T060 on each party being tested all on the same file from the Contractor. No party's sample is sent to be tested until all samples are received AND the electronic referral is complete. |
| T070 | Result Posted - AF | This should be the actual date the test results are posted on the Contractor's website. The OAG will get only 1 T070 per test grouping. The T070 comes with the father's information as far as member data. The OAG uses this record to verify the invoice on Test Results. |
| T071 | Result Posted - DP | This should be the actual date the test results are posted on the Contractor's website. The T071 comes with the child's information as far as member data. The OAG uses this record to verify the invoice on Test Results. |
| T080 | Hardcopy Results Mailed | This should be the actual date the hardcopy test results were mailed to the OAG. |
| T090 | Collection Irregularity - something happened that affected collecting the sample or testing the sample or the paperwork involved, etc. | This transaction is used to notify the OAG contract division of scenarios where something has happened to affect testing. The date on this should be the date the Contractor became aware of the issue or the scenario became an issue. |
OAG to Contractor File
| ID | Field Name | Start | End | Format (A=Alpha) | Length | Field Definition | Notes | File Layout Notes |
| 1 | ENTRY-OFC-CODE | 1 | 5 | A | 5 | Entry Office Code |
Made up of 4 numerals (Office Number) followed by a letter (Office Type). See Attachment 2, Field Office Storefront Consolidations and Regional Map for information regarding Field Office numbering
| 2 | OFC-NAME | 6 | 25 | A | 20 | Originating Field Office Name |
| 3 | OFC-ADDR-LINE-1 | 26 | 50 | A | 25 | Originating Field Office Address Line 1 |
| 4 | OFC-ADDR-LINE-2 | 51 | 75 | A | 25 | Originating Field Office Address Line 2 |
| 5 | OFC-ADDR-LINE-3 | 76 | 100 | A | 25 | Originating Field Office Address Line 3 |
| 6 | OFC-ADDR-CITY | 101 | 120 | A | 20 | Originating Field Office Address City |
| 7 | OFC-ADDR-ST-CODE | 121 | 122 | A | 2 | Originating Field Office Address State Abbreviation |
| 8 | OFC-ZIP-CODE | 123 | 133 | A | 11 | Originating Field Office Zip Code |
| 9 | CONTACT-LAST | 134 | 153 | A | 20 | Originating Field Office Contact (Parentage Liaison) Last Name |
| 10 | CONTACT-FIRST | 154 | 168 | A | 15 | Originating Field Office Contact (Parentage Liaison) First Name |
| 11 | CONTACT-MIDDLE | 169 | 178 | A | 10 | Originating Field Office Contact (Parentage Liaison) Middle Name |
| 12 | CONTACT-PH-NBR | 179 | 192 | A | 14 | Originating Field Office Contact (Parentage Liaison) Phone Number |
| 13 | TEST-VENDOR-NAME | 193 | 232 | A | 40 | Parentage Testing Vendor Name |
| 14 | TEST-VENDOR-ADDR-1 | 233 | 257 | A | 25 | Parentage Testing Vendor Address Line 1 |
| 15 | TEST-VENDOR-ADDR-2 | 258 | 282 | A | 25 | Parentage Testing Vendor Address Line 2 |
| 16 | TEST-VENDOR-ADDR-3 | 283 | 307 | A | 25 | Parentage Testing Vendor Address Line 3 |
| 17 | TEST-VENDOR-ADDR-CITY | 308 | 327 | A | 20 | Parentage Testing Vendor Address City |
| 18 | TEST-VENDOR-ADDR-ST-CODE | 328 | 329 | A | 2 | Parentage Testing Vendor Address State Abbreviation |
| 19 | TEST-VENDOR-ZIP-CODE | 330 | 340 | A | 11 | Parentage Testing Vendor Zip Code |
| 20 | CASE-ID | 341 | 350 | A | 10 | OAG Case Identification Number |
| 21 | CAUSE-NBR | 351 | 365 | A | 15 | OAG Cause Number |
| 22 | COURT-NAME | 366 | 395 | A | 30 | Court Name associated with the Originating Field Office |
| 23 | NOTE-TIME-STAMP | 396 | 411 | A | 16 | The Note Time Stamp is the date and time a NOTE record was added to the record being accessed. |
24 FIRST-VALID-DATE 412 421 A 10 First Valid Date
The current date plus the Lead Time value of the parentage testing activity which is currently set to fifteen (15) days. It is used by the OAG system and to guide online users. Lead time may be overridden by users performing scheduling.
| NOTE-ENTRY-1 -99 | 422 | 5371 | A | 50 | Notes | There are 99 Note Fields. Only one field is presented on this layout. |
| VENDOR-UPDATE | 5372 | 5372 | A | 1 | Party Record 1 Vendor Update | Party Information-Repeated 13 Times. Only one member is presented on this layout. |
| DRAW-VENDOR-ID | 5373 | 5382 | A | 10 | Identifies if transaction is an OAG self collection or a vendor collection scheduled by the OAG. | |
| NOTIFN-ID | 5383 | 5392 | A | 10 | Party Record 1 Notification Identification | |
| PTST-ISN | 5393 | 5402 | A | 10 | Parentage Testing Results Internal Sequence Number | |
| LOG-COUNTER | 5403 | 5405 | A | 3 | Party Record 1 Log Counter |
The Log Counter acts as an "update odometer" for this file to prevent intervening updates.
NOTIF-DATE 5406 5415 A 10 Party Record 1 Notification Date
The Notification Date is the date the paternity test record was created and the external vendor gained access.
MBR-RTC 5416 5417 A 2 Party Record 1 Member Relationship to Case
Valid values are:
• AF – Alleged Father;
• AP – Absent/Non-Custodial Parent;
• CP – Custodial Parent;
• DP – Dependent;
• PF – Presumed Father; and
• SP – Second Parent.
| NAME-LAST | 5418 | 5437 | A | 20 | Party Record 1 Last Name |
| NAME-FIRST | 5438 | 5452 | A | 15 | Party Record 1 First Name |
| NAME-MIDDLE | 5453 | 5462 | A | 10 | Party Record 1 Middle Name |
| MBR-Member ID | 5463 | 5463 | A | 8 | Party Record 1 Member ID |
| APPERENCE CODE | 5464 | 5471 | A | 1 | Cancellation Flag |
| BRTH-DATE | 5481 | 5481 | A | 10 | Party Record 1 Birth Date in MM/DD/YYYY format |
| DRAW-SITE-NAME | 5482 | 5506 | A | 25 | Party Record 1 Draw Site Name |
The name of the location the parentage testing will occur
| DRAW-SITE-ADDR-1 | 5507 | 5531 | A | 25 | Party Record 1 Draw Site Address Line 1 |
| DRAW-SITE-ADDR-2 | 5532 | 5556 | A | 25 | Party Record 1 Draw Site Address Line 2 |
| DRAW-SITE-ADDR-3 | 5557 | 5581 | A | 25 | Party Record 1 Draw Site Address Line 3 |
| DRAW-SITE-ADDR-CITY | 5582 | 5601 | A | 20 | Party Record 1 Draw Site Address City |
| DRAW-SITE-ADDR-ST-CODE | 5602 | 5603 | A | 2 | Party Record 1 Draw Site Address State Abbreviation |
| DRAW-SITE-ZIP-CODE | 5604 | 5614 | A | 11 | Party Record 1 Draw Site Address Zip Code |
| DRAW-SITE-CTRY-CODE | 5615 | 5617 | A | 3 | Party Record 1 Draw Site Country Code |
| DRAW-DATE | 5618 | 5627 | A | 10 | Party Record 1 Draw Date |
| DRAW-TIME | 5628 | 5637 | A | 10 | Party Record 1 Draw Time |
| DRAW-OPTN-CD | 5638 | 5638 | A | 1 | Party Record 1 Draw Option Code |
Valid values are:
I – In Area;
C – Court;
A – All By City;
B – All By Office Code;
V – All By Vendor City;
Z – All By Zip Code;
J – Jail/Other; and O – Out of State T– Other E – Emergency
DOMESTIC-VIOLENCE-IND *(Commonly known as the Family Violence Indicator) 5639 5639 A 1 Party Record 1 Domestic Violence Indicator
Y or Blank
| ADDITIONAL INFORMATION | 5640 | 5649 | A | 10 | Contains various additional information for vendor | |
| DRAW-OPTN-SUB-CD | 5650 | 5659 | A | 10 | Subtype for the "T" Draw Option Code | |
| Members 2 through 13 mirror member 1 above. | ||||||
| Conditional Logic | ||||||
| The Contractor will evaluate the OAG file and for the following Draw Option Codes: |
• If the DOMESTIC-VIOLENCE-IND (Commonly known as the Family Violence Indicator) on any transaction is “Y” then flag on your communication to collection site or collector in a conspicuous manner.
• If the Draw Option Code is I, C, A, B, V, or Z, look at the Draw Vendor ID to determine OAG collection or a Contractor collection scheduled by the OAG.
o If Contractor collection is scheduled by the OAG communicate to the appropriate collection site or collector.
• If the Draw Option Code is O (out-of-state), schedule and communicate appropriate location information and notes to collection site or collector.
• If the Draw Option is J (Jail), schedule and communicate the appropriate location information and notes to the collection site or collector.
• If the Draw Option Code is T (military, posthumous, home, etc.) communicate the appropriate location information and notes to collection site or collector.
• If the following subtype codes are present in the Draw Option sub-code field on the OAG file, the Contractor should process accordingly:
o 01: PREVTEST (*Previously Tested) indicates that the member has been previously tested and a collection is not required. If all other Members of the case have been drawn proceed with testing. Note: (Before reusing a sample the Contractor must receive the appropriate form (Permission to Reuse Sample) from the OAG.
o 02: MOTHERLES (*Motherless Collection) (not billable) indicates that this is a motherless draw. The mother will be present on the OAG record but a collection does not need to be scheduled. When the Alleged Father/Presumed Father and dependents are all accounted for on the case then testing may begin.
o For all other subtypes such as DECEASED, MILITARY, and Residential collections:
• Schedule and conduct sample collections within the timelines requested by the Originating Field Office.
• Capture location information and instructions in the note fields and communicate to the appropriate collection site or collector.
• Notify the OAG of the time and date of the scheduled collection. (T010 Scheduled) o Review the Vendor-Update Field for” Y” to determine if a subsequent transaction contains updated scheduling information and update system as appropriate (Rescheduled).
Irregularity Codes
| Irregularities | Codes | Notes |
| OAG - Members Address Missing | I010 | |
| Contractor - Member Address Missing | I011 | |
| OAG – Collection Site Address Missing | I020 | |
| Contractor – Collection Site Address Missing | I021 | |
| OAG – Date Missing on Signature | I030 | |
| Contractor – Date Missing on Signature | I031 | |
| OAG - Date Missing - on Packaging | I040 | |
| Contractor - Date Missing - on Packaging | I041 | |
| OAG - Motherless not Indicated | I050 | |
| Contractor - Motherless not Indicated | I051 | |
| OAG - Name - Missing | I060 | |
| Contractor - Name - Missing | I061 | |
| OAG - Name - Not consistent on all forms | I070 | |
| Contractor - Name - Not consistent on all forms | I071 | |
| OAG Case # - Incorrect | I080 | |
| Contractor Case # - Incorrect | I081 | |
| OAG Case # - Missing | I090 | |
| Contractor Case # - Missing | I091 | |
| OAG - Picture - Missing | I100 | |
| Contractor - Picture - Missing | I101 | |
| OAG - Picture - Not acceptable too light or too dark | I110 | |
| Contractor - Picture - Not acceptable too light or too dark | I111 | |
| OAG - Signature missing - Chain of Custody | I120 | |
| OAG - Signature missing - Chain of Custody | I121 | |
| OAG - Signature missing - Member's | I130 | |
| Contractor - Signature missing - Member's | I131 | |
| OAG - Office Number – Missing | I140 | |
| Contractor - Office Number – Missing | I141 | |
| OAG - Designated Headquarters – Missing | I150 | |
| Contractor - Designated Headquarters – Missing | I151 | |
| OAG - Lost | I160 | |
| Contractor- Lost | I161 | |
| Lost In Transit | I162 | |
| OAG - Damaged | I170 | |
| Contractor- Damaged | I171 | |
| Contractor - Max Rescheduling Reached | I180 | |
| Missing Other Party Data | I190 | I190 would come with the party data Contractor did receive. In such a situation there would be a combination of a transaction code = T090 and I= I190. |
| Jail - Refusal | I200 | |
| Jail - Release | I201 | |
| Jail - Transfer | I202 | To another facility |
| Jail - Lockdown | I203 | |
| Jail - Not Available | I204 | Inmate ill, on work duty, court etc. |
Error File
| Field Number | Field Name | Format | Length | Field Definition | Edit Criteria | Required Data Fields for Transaction Code - TC010 Sample Taken (Show) | Required Data Fields for Transaction Code TC020 - No Show | Required Data Fields for Transaction Code TC030 - Sample Shipped to Contractor | Required Data Fields for Transaction Code TC040 - Sample Received at Contractor Testing Location - | Required Data Fields for Transaction Code TC050 -Sample Tested | Required Data Fields for Transaction Code TC060-Test Completed/Results Sent | Required Data Fields for Transaction Code TC070 - Lost or Damaged Sample | Required Data Fields for Transaction Code TC080 -Hardcopy Result Mailed to OAG | Required Data Fields for Transaction Code TC090 Scheduled (Non-Standard) | Required Data Fields for Transaction Code TC100 - Rescheduled (Non-Standard) | Required Data Fields for Transaction Code TC110-Collection Irregularity |
| 1 | CASE-ID | A | 10 | OAG Case Identification Number | Must be valid Case ID on TXCSES |
Must Use OAG Length/Format of Outbound File
| Must match a Case ID on outgoing file | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
| 2 | NOTE-TIME-STAMP | A | 16 | The Note Time Stamp is the date and time a NOTE record was added to the record being accessed. | |||||||||||||
| Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
| 3 | NOTE-ENTRY-1 | A | 250 | Notes | Must Use OAG Length/Format of Outbound File | Optional | Optional | Optional | Optional | Optional | Optional | Optional | Yes | Yes | Yes | Yes | |
| 4 | PARTY-RECORD 1 DRAW-VENDOR-ID | A | 10 | The Draw Vendor ID is the contact ID of the paternity vendor that will perform the draw. | |||||||||||||
| Must Use OAG Length/Format of Outbound File | |||||||||||||||||
| Must be present if a collection transaction type | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
| 5 | PARTY-RECORD 1 NOTIFN-ID | A | 10 | The Notification Date is the date the paternity test record was created and the external vendor gained access. | |||||||||||||
| Must Use OAG Length/Format of Outbound File |
| Must match outgoing file | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||
| 6 | PARTY-RECORD 1 #MBR-RTC | A | 2 | Party Record 1 Member Relationship to Case. Valid values are: • AF – Alleged Father; • AP – Absent/Non-Custodial Parent; • CP – Custodial Parent; • DP – Dependent; • PF – Presumed Father; and • SP – Second Parent. | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 7 | PARTY-RECORD 1 NAME-LAST | A | 20 | Party Record 1 Last Name | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 8 | PARTY-RECORD 1 NAME-FIRST | A | 15 | Party Record 1 First Name | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 9 | PARTY-RECORD 1 NAME-MIDDLE | A | 10 | Party Record 1 Middle Name | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 10 | MBR-ID-SCHD | A | 8 | The Member Id Schedule is the member id of the person scheduled for a paternity blood test. | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 11 | PARTY-RECORD 1 #DRAW-SITE-NAME | A | 25 | The Draw Site Description identifies the physical draw site location where blood was taken from the member for a paternity test. | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |
| 12 | PARTY-RECORD 1 #DRAW-SITE-ADDR-1 | A | 25 | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 13 | PARTY-RECORD 1 #DRAW-SITE-ADDR-2 | A | 25 | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 14 | PARTY-RECORD 1 #DRAW-SITE-ADDR-3 | A | 25 | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 15 | PARTY-RECORD 1 #DRAW-SITE-ADDR-CITY | A | 20 | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 16 | PARTY-RECORD 1 #DRAW-SITE-ADDR-ST-CODE | A | 2 | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 17 | PARTY-RECORD 1 #DRAW-SITE-ZIP-CODE | A | 11 | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 18 | PARTY-RECORD 1 #DRAW-SITE-CTRY-CODE | A | 3 | Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||
| 19 | PARTY-RECORD 1 #DRAW-DATE | A | 10 | Party Record 1 Draw Date | Must Use OAG Length/Format of Outbound File | Yes | Yes | No | No | No | No | Yes | No | Yes | Yes | Yes | |
| 20 | PARTY-RECORD 1 #DRAW-TIME | A | 10 | The Draw Date and Time is when blood was drawn from a member associated with a case. (Field owned by PTST) | Must Use OAG Length/Format of Outbound File | Yes | Yes | No | No | No | No | Yes | No | Yes | Yes | Yes | |
| 21 | PARTY-RECORD 1 DRAW-OPTN-CD | A | 1 | The Draw Option Code identifies the draw option selected when the PTST record is initialized. See REF1-OPCD for valid values. (Field owned by PTST). We will be breaking out the current Jail/Other field into two separate fields, Jail and Other. Valid values will be: |
I- In Area;
C – Court;
A – All By City B – All By Office Code V- All By Vendor City Z – All By Zip Code J – Jail T - Other O – Out of State E- Emergency
| Must be present | |||||||||||
| Must Use OAG Length/Format of Outbound File | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| 22 | DRAW OPTION SUBTYPE | A | 10 | Create a two byte subtype field for the “Other” draw option. Proposed subtypes are: |
PREVTEST (*Previously Tested) (Not billable) MOTHERLES (*Motherless Collection) (Not billable) DECEASED (*Posthumous Collection) (Non-Standard) MILITARY (*Military Collection) (Non-Standard) DIRECTED (*Directed by OAG) (Non-Standard) Must be populated Must be a valid draw option subtype
| 23 | PROB-PCT (Probability of Paternity) | A | 4 | Probability Percent is the probability percentage in establishing paternity. (Field owned by PTST) | |||||||
| Must be present if Transaction is a Test Result | |||||||||||
| Must Use OAG Length/Format of Outbound File | No | No | No | No | No | Yes | No | No | No | No | No |
| 24 | APPEARANCE INDICATOR | A | 1 | In REFG/ Ref ID: APRC |
A - AWT Awaiting Scheduling B - SCH Currently Scheduled C - Can Canceled N - NSH No Show P - SMP - See Notepad R - RSC - Rescheduled S - SHO Show T- TRR- Test Results Must be populated Must be valid TXCSES Appearance Indicator 25 TRANSACTION CODE A 4 T010 - Scheduled T020 - Rescheduled T030 - Show T040 - No Show T050 - Sample Received T060 - Sample Tested T070 - Result Posted T071 - Result /Dependent T080 -Hardcopy Result Mail T090 - Collection Irregularity
| Must be populated | |||||||||||
| Must be a valid Transaction Code | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| 26 | TRANSACTION DATE | A | 10 | Date Transaction occurred. Linked to the transaction code field | Must be populated | ||||||
| Must be a valid date with format of MMDDYYYY | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| 27 | IRREGULARTY CODE | A | 4 | See Attachment | Must be populated if there is an irregularity of some kind. (Example Lost, Damaged, Missing Signature). | ||||||
| 28 | Error Flag | A | 1 | Will be populated with 'E' | |||||||
| 29 | Error Date | A | 10 | ||||||||
| 30 | Error Text | A | 100 | Free form text |
File details come from the government source that posted it. Updated .