EPA_NUM_COMPS
Description:
This table holds the conditional comparison information 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 SING_COMP_OP_C_NAME VARCHAR No
This item holds the comparison operator to use when doing a single comparison for an electronic prior authorization question.
May contain organization-specific values: No
Category Entries:
Equal to
Not equal to
Greater than
Greater than or equal to
Less than
Less than or equal to
In range
Not in range
Always equal to
No values equal to
Always greater than
Always greater than or equal to
Always less than
Always less than or equal to
Contains
Does not contain
Starts with
Ends with
Exists
Does not exist
Field is blank
Field does not contain
4 SING_COMP_VAL NUMERIC No
This item holds the comparison value to use when doing a single comparison for an electronic prior authorization question.
5 RNG_COMP_LOW_OP_C_NAME VARCHAR No
This item holds the lower comparison operator to use when doing a range comparison for an electronic prior authorization question.
The category values for this column were already listed for column: SING_COMP_OP_C_NAME
6 RNG_COMP_LOW_VAL NUMERIC No
This item holds the lower comparison value to use when doing a range comparison for an electronic prior authorization question.
7 RNG_COMP_UP_OP_C_NAME VARCHAR No
This item holds the upper comparison operator to use when doing a range comparison for an electronic prior authorization question.
The category values for this column were already listed for column: SING_COMP_OP_C_NAME
8 RNG_COMP_UP_VAL NUMERIC No
This item holds the upper comparison value to use when doing a range comparison for an electronic prior authorization question.
9 NUM_COMP_NEXT_QUESN VARCHAR No
This item holds the ID of the next question to show after a question meets the conditional logic comparison requirements.
10 SING_COMP_DATE DATETIME No
This item holds the comparison operator to use when doing a single date comparison for an electronic prior authorization question.
11 SING_COMP_UTC_DTTM DATETIME (UTC) No
This item holds the comparison value to use when doing a single instant comparison for an electronic prior authorization question.
12 RNG_COMP_LOW_DATE DATETIME No
This item holds the lower comparison operator to use when doing a date range comparison for an electronic prior authorization question.
13 RNG_COMP_LOW_UTC_DTTM DATETIME (UTC) No
This item holds the lower comparison operator to use when doing an instant range comparison for an electronic prior authorization question.
14 RNG_COMP_UP_DATE DATETIME No
This item holds the upper comparison operator to use when doing a date range comparison for an electronic prior authorization question.
15 RNG_COMP_UP_UTC_DTTM DATETIME (UTC) No
This item holds the upper comparison operator to use when doing an instant range comparison for an electronic prior authorization question.