SAR_SVC_GRP

Description: |
The code group for the service authorization request (SAR) service line. This table extracts the related multiple response SAR Service Groups (I RFL 235) item. Table SAR_SVC_GRP_UNITS contains additional information related to each row in this table. Join to it using the primary key columns in each table. Additionally, each row in these tables relates to a parent row in the SAR_SVC_LN_INFO table. Join to it using the REFERRAL_ID columns and SAR_SVC_LN_INFO.LINE = GROUP_LINE from these tables.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REFERRAL_ID | NUMERIC | No |
The referral ID for the referral record.
2 | GROUP_LINE | INTEGER | No |
The line number for the information associated with this record.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple values associated with a specific group of data within this record.
4 | SAR_SVC_GROUP_ID | VARCHAR | No |
The component (CMP) record id for a service line of the Service Authorization Request (SAR).
5 | SAR_SVC_GROUP_ID_COMPONENT_NAME | VARCHAR | No |
The name of the component