SSC_GEN_REC_INFO

Description: |
The SSC_GEN_REC_INFO table contains one row for each patient-level SmartSet Information record in your system. Each row contains general information that is not specific to any contact such as the record's ID, name, and SmartSet Information type.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RECORD_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RECORD_ID | NUMERIC | No |
The unique ID of the patient-level SmartSet Information record.
2 | DISPLAY_NAME | VARCHAR | No |
The name of the patient-level SmartSet Information record as it appears in Hyperspace.
3 | SOURCE_STEP_ID | NUMERIC | No |
The unique ID of the Pathway Step that contains this record.
4 | SOURCE_SMARTGRP_ID | NUMERIC | No |
The unique ID of the Pathway SmartGroup that contains this record.
5 | APPLY_INSTANT_DTTM | DATETIME (Local) | No |
The instant the SmartSet Information record was applied to the pathway.