EPA_SELECT_CHOICES

Description: |
This table holds the select choices for electronic prior authorization questions.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
REFERRAL_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | REFERRAL_ID | NUMERIC | No |
The unique identifier for the referral record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | SEL_CHOICE_ID | VARCHAR | No |
This item holds the ID of the multiple choice option for electronic prior authorization.
4 | SEL_CHOICE_SEQUENCE | NUMERIC | No |
This item holds the sequence for the multiple choice option.
5 | ALLOW_FREE_TEXT_C_NAME | VARCHAR | No |
Indicates whether a free text comment was allowed for the multiple choice option. If set to No, free text comments will not be allowed. If set to Yes-Required, a free text comment will be required. If set to Yes-Optional, a free text comment will be allowed, but optional.
May contain organization-specific values: No
Category Entries:
No
Yes - Required
Yes - Optional
6 | SEL_QUESN_NEXT_ID | VARCHAR | No |
This item holds the ID of the next question if this answer choice is selected.
7 | SEL_CODE_REF_START | INTEGER | No |
This item holds the line number of the first coded reference detail line associated with this electronic prior authorization multiple choice option. The actual coded reference details are stored in referral file (RFL) related group 9390.
8 | SEL_CODE_REF_END | INTEGER | No |
This item holds the line number of the last coded reference detail line associated with this electronic prior authorization multiple choice option. The actual coded reference details are stored in referral file (RFL) related group 9390.
9 | SEL_CHOICE_VALUE_YN | VARCHAR | No |
This item holds whether this selection option was chosen. If it is set to 1-Yes, it indicates that the answer was selected. If it is set to null or 0-No, it indicates that the answer was not selected.
May contain organization-specific values: No
Category Entries:
No
Yes