RXA_INTERMEDIARY_IDS_OUT
Description:
Contains information relating to a single contact of an adjudication record's intermediary ID's from the intermediary segment.

Primary Key
Column Name Ordinal Position
RECORD_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 RECORD_ID NUMERIC No
The unique identifier (.1 item) for the adjudication record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 O_INTRMD_ID_CODE_ID NUMERIC No
Code identifying the type of Intermediary ID (B48-8M).
6 O_INTRMD_ID_CODE_ID_EXT_CODE_LST_NAME VARCHAR No
The name of the list value.
7 O_INTRMD_ID_TYP_ENT_ID NUMERIC No
Code Identifying the type of entity associated with the Intermediary ID (B48-8M).
8 O_INTRMD_ID_TYP_ENT_ID_EXT_CODE_LST_NAME VARCHAR No
The name of the list value.
9 O_INTRMD_ID_QUAL_ID NUMERIC No
Code qualifying the Intermediary ID (B48-8M).
10 O_INTRMD_ID_QUAL_ID_EXT_CODE_LST_NAME VARCHAR No
The name of the list value.
11 O_INTERMEDIARY_ID_S VARCHAR No
Intermediary ID assigned to the type entity (B48-8M).
12 O_INTRMD_ID_STE_ID NUMERIC No
The postal state code abbreviation that is used in conjunction with the Intermediary ID Qualifier and the Intermediary ID fields to identify what state the identification is from (B49-8N).
13 O_INTRMD_ID_STE_ID_EXT_CODE_LST_NAME VARCHAR No
The name of the list value.
14 O_INTRMD_ID_CNTY_ID NUMERIC No
The associated Postal country code of the associated Intermediary ID (B55-8U).
15 O_INTRMD_ID_CNTY_ID_EXT_CODE_LST_NAME VARCHAR No
The name of the list value.