DOCS_RCVD_DEDUP_LNK_INGST

Description: |
This table stores data ingestion category-specific information about the composite data element associated with a row in DOCS_RCVD_DEDUP_LNK. The table only stores data for composite data elements with multiple associated data ingestion categories.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
DOCUMENT_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | DOCUMENT_ID | NUMERIC | No |
The unique identifier (.1 item) for the document record.
2 | GROUP_LINE | INTEGER | No |
The line number of the link between a composite and deduplicated data element in a deduplicated DXR record. Together with DOCUMENT_ID, this forms the foreign key to the DOCS_RCVD_DEDUP_LNK table.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple data ingestion categories associated with a link between a composite and deduplicated data element in a deduplicated DXR record from the DOCS_RCVD_DEDUP_LNK table.
4 | EXT_DATA_INGESTION_CAT_C | INTEGER | No |
The data ingestion category ID of the specific data ingestion category associated with a composite data element.
5 | PREF_SRC_DOCUMENT_CSN_ID | NUMERIC | No |
The unique contact serial number of the received document (DXR) contact that is the preferred source contact associated with this data ingestion category for a composite data element.
6 | EARLIEST_SRC_DOCUMENT_CSN_ID | NUMERIC | No |
The unique contact serial number of the received document (DXR) contact that is the earliest received source contact associated with this data ingestion category for a composite data element.
7 | EARLIEST_RCV_INST_LOCAL_DTTM | DATETIME (Local) | No |
The document received date and time for the earliest received source document (DXR) contact associated with this data ingestion category for a composite data element.