|
Name |
Type |
Discontinued? |
|
1 |
REFERRAL_ID |
NUMERIC |
No |
|
|
|
The unique ID of the referral in database. |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The line number of the procedure associated with the referral. For example, if a referral has two associated procedures, the first procedure will have a line value of 1, while the second procedure will have a line value of 2. |
|
|
3 |
PX_ID_PROC_NAME |
VARCHAR |
No |
|
|
|
The name of each procedure. |
|
|
4 |
UNITS_REQUESTED |
INTEGER |
No |
|
|
|
The number of units of this procedure that were requested |
|
|
5 |
UNITS_APPROVED |
INTEGER |
No |
|
|
|
The number of units of this procedure that were approved |
|
|
6 |
TOTAL_PRICE |
NUMERIC |
No |
|
|
|
The total price calculated for this procedure using fee schedules or vendor contracts (for outgoing referrals) |
|
|
7 |
NET_PAYABLE |
NUMERIC |
No |
|
|
|
The total net payable calculated for this procedure (the price - the patient portion). |
|
|
8 |
PATIENT_PORTION |
NUMERIC |
No |
|
|
|
The total patient responsibility calculated for this procedure using the benefits engine |
|
|
9 |
PROV_ID_PROV_NAME |
VARCHAR |
No |
|
|
|
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table. |
|
|
10 |
AUTH_REQ_YN |
VARCHAR |
No |
|
|
|
A flag that indicates whether the member's benefits require a referral for this service. Yes=> a referral is required, No=> a referral is not required. |
|
|
11 |
COVERED |
VARCHAR |
No |
|
|
|
A flag that indicates whether the procedure is not covered by the member's benefits or it is covered but by supplemental insurance |
|
|
12 |
REVENUE_CODE_ID |
NUMERIC |
No |
|
|
|
Stores the revenue billing code entered on the service. |
|
|