Incoming 270 request information is stored in two tables named EDI_EligRequestHeader and EDI_EligRequestDetail.
Request Tables schema.
Member/dependent identifying information is stored in EDI_EligResponseMembers and any benefit or eligibility information on any given member or dependent is stored in EDI_EligResponseBenefits.
Response tables Schema.
In terms of the outgoing EDI file, the table EDI_EligResponseMembers contain information for loop Loop 2000C/2100C and 2000D/2100D respectively, while the table EDI_EligResponseBenefits covers loops 2110C to 2120C and 2110D to 2120D. The loop 2000A, information source detail, is generated dynamically from the Company Setup table. The company setup form has fields reserved for this purpose.
Company Setup screen. Emphasis on Information Source fields.
Loops 2000B/2100B are created from the incoming request's Information Receiver Details.