| Attribute |
Description |
| |
Entity |
KeyTp |
Data Type |
Length |
| Accident Flg |
An indicator that this was caused by an accident. |
| |
Diagnosis Code |
|
alphanumeric |
0 |
| Actl Athrzd Amt |
The net amount paid on the specific line item from the associated claim. |
| |
Authorized Procedure |
|
real |
0. |
| Actual Authorized Allowable Amt |
Indicates the actual amount for which this procedure has been authorized
to be performed. |
| |
Authorized Procedure |
|
real |
0. |
| Actual Authorized Qty |
|
| |
Authorized Procedure |
|
integer |
0. |
| Actual Claim Entered Dt |
The system displays the most recent entry date of the actual information
from the associated claim. |
| |
Authorized Procedure |
|
alphanumeric |
0 |
| Actual Posted Dt |
The date the authorization was actually received. |
| |
Authorization |
|
alphanumeric |
0 |
| Actual Visit Cnt |
|
| |
Authorized Visit |
|
integer |
0. |
| Admit Or Primry Dt |
|
| |
Authorized Visit |
|
alphanumeric |
0 |
| Auth Detail Rc Src Cd |
|
| |
Authorized Procedure |
|
alphanumeric |
0 |
| Authorization Cmt |
Comments about the authorization. |
| |
Authorization |
|
alphanumeric |
0 |
| Authorization Dt |
The date the authorization was requested or entered. |
| |
Authorization |
|
alphanumeric |
0 |
| Authorization Expiration Dt |
The date the atthorization expires. |
| |
Authorization |
|
alphanumeric |
0 |
| Authorization Sequence Nbr |
|
| |
Authorized Diagnosis |
|
integer |
0. |
| Authorization Status Cd |
|
| |
Authorization Status Type |
PK |
alphanumeric |
0 |
| Authorization Status Dsc |
The description of an authorization status. |
| |
Authorization Status Type |
|
alphanumeric |
0 |
| Authorization Type Cd |
The type of an authorization. |
| |
Authorization Type |
PK |
alphanumeric |
0 |
| Authorized Allowed Amt |
The allowable $ amount that the procedure(s) is authorized for. |
| |
Authorized Procedure |
|
real |
0. |
| Authorized Procedure Qty |
|
| |
Authorized Procedure |
|
integer |
0. |
| Authorized Visit Cnt |
|
| |
Authorized Visit |
|
integer |
0. |
| Authoriztion Type Dsc |
|
| |
Authorization Type |
|
alphanumeric |
0 |
| Case Manager MMI Unit Nbr |
|
| |
Member |
|
integer |
0. |
| Category Cd |
|
| |
Code Category |
PK |
alphanumeric |
0 |
| Category Dsc |
|
| |
Code Category |
|
alphanumeric |
0 |
| COB History Flg |
|
| |
Member |
|
alphanumeric |
0 |
| Diag Pend For Review Flg |
An indicator that this is pending a review to establish the diagnosis. |
| |
Diagnosis Code |
|
alphanumeric |
0 |
| Diagnosis Dsc |
A description of the principle diagnosis for the condition. For hospital
related claims, this is the ICD-9 codes. |
| |
Diagnosis Code |
|
alphanumeric |
0 |
| Discharge Dt |
Discharge Date: The date the patient is discharged. The date that care is
ended. |
| |
Authorization |
|
alphanumeric |
0 |
| Employee Database User Id |
The user ID of an employee that is used when the user connects to a
database or the LAN. |
| |
Employee |
|
alphanumeric |
0 |
| |
Utilization Nurse |
I |
|
|
| Employee First Nm |
The first name of an employee. |
| |
Employee |
|
alphanumeric |
0 |
| |
Utilization Nurse |
I |
|
|
| Employee Last Nm |
The last name of an Employee. |
| |
Employee |
|
alphanumeric |
0 |
| |
Utilization Nurse |
I |
|
|
| Employee Middle Nm |
The middle name of the employee. |
| |
Employee |
|
alphanumeric |
0 |
| |
Utilization Nurse |
I |
|
|
| Estimated Cost Amt |
The estimated cost of a authorized visit. |
| |
Authorized Visit |
|
real |
0. |
| Follow Up Days Cnt |
|
| |
Specific Procedure Code |
|
integer |
0. |
| Grievance Flg |
|
| |
Member |
|
alphanumeric |
0 |
| Group Employee Size Type Id |
The identifier of the size of a group by the number of employees within
that group. |
| |
Group Master |
|
integer |
0. |
| Id Card Issue Dt |
The most recent date that an ID card is issued to a member. |
| |
Member |
|
alphanumeric |
0 |
| Medicaid Id |
The medicaid ID # of the member. |
| |
Member |
|
integer |
0. |
| Member Added Dt |
The date the member is ORIGINALLY added TO OUR SYSTEMS. |
| |
Member |
|
alphanumeric |
0 |
| Next Review Dt |
The date the authorization is scheduled for the next review. |
| |
Authorization |
|
alphanumeric |
0 |
| Org Assignd Employee Nbr |
The employee number or badge number of the subsriber. |
| |
Member |
|
integer |
0. |
| Parent Group Id |
The surrogate key of the Parent Id. If it is NULL, it doesn't have a
parent. |
| |
Group Master |
|
integer |
0. |
| Pec Auto Pend Flg |
|
| |
Specific Procedure Code |
|
alphanumeric |
0 |
| Place Of Service Cd |
The mnemonic code for the place of service. |
| |
Place Of Service |
PK |
alphanumeric |
0 |
| Place Of Service Dsc |
A brief description of the place of service code. |
| |
Place Of Service |
|
alphanumeric |
0 |
| Proc Gender Flg |
Indicates whether a procedure code only is valid for a certain gendor
code. |
| |
Specific Procedure Code |
|
alphanumeric |
0 |
| Procedure Dsc |
The description for a procedure. |
| |
Specific Procedure Code |
|
alphanumeric |
0 |
| Procedure Pend For Review Flg |
Indicates whether a claim for a procedure should always be pended for
review. |
| |
Specific Procedure Code |
|
alphanumeric |
0 |
| Prov Plan Participating Flg |
This indicates whether a provider is participating in a plan. In effect,
if a provider contracts to service a plan, they can be considered to be participating. |
| |
Provider Plan Type |
|
alphanumeric |
0 |
| Provider Plan Contract End Dt |
The date that the provider is terminated from a plan type. |
| |
Provider Plan Type |
|
alphanumeric |
0 |
| Provider Plan Contract Start Dt |
The contract effective date of the provider plan type. |
| |
Provider Plan Type |
|
alphanumeric |
0 |
| Region Id |
A Unique identifier of a region. |
| |
Group Master |
|
integer |
0. |
| Requested Visit Cnt |
|
| |
Authorized Visit |
|
integer |
0. |
| Service Reason Cd |
A code defining the reason for the service being performed. A code
indicating the type of service for the claim detail line. This is a field on the HCFA 1500
claim form. Example: Outpatient; Inpatient; General Medicine; Emergency Room |
| |
Service Reason |
PK |
alphanumeric |
0 |
| Service Reason Dsc |
A description of the type of service for the claim detail line. This is a
field on the HCFA 1500 claim form. Example: Outpatient; Inpatient; General Medicine;
Emergency Room |
| |
Service Reason |
|
alphanumeric |
0 |
| Service Type Cd |
|
| |
Service Type |
PK |
alphanumeric |
0 |
| Service Type Dsc |
|
| |
Service Type |
|
alphanumeric |
0 |
| Specific From Age Years Cnt |
The specific from age for a diagnosis code. |
| |
Diagnosis Code |
|
integer |
0. |
| Specific Thru Age Years Cnt |
The specific thru age for a diagnosis code. |
| |
Diagnosis Code |
|
integer |
0. |
| Start Age Years Cnt |
The start of the age range for which a procedure code is valid. |
| |
Specific Procedure Code |
|
integer |
0. |
| Stop Age Years Cnt |
The end of an age range for which a procedure code is valid. |
| |
Specific Procedure Code |
|
integer |
0. |
| Student Wvr Thr Dt |
The date through which a member has been certified as a student. |
| |
Member |
|
alphanumeric |
0 |
| Trauma Related Flg |
An indicator that this diagnosis would be related to a trauma. |
| |
Diagnosis Code |
|
alphanumeric |
0 |
