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