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.