| Attribute |
Entity |
Description |
| Accident Flg |
Diagnosis Code |
An indicator that this was caused by an accident. |
| Actl Athrzd Amt |
Authorized Procedure |
The net amount paid on the specific line item from the associated claim. |
| Actual Authorized Allowable Amt |
Authorized Procedure |
Indicates the actual amount for which this procedure has been authorized to be
performed. |
| Actual Claim Entered Dt |
Authorized Procedure |
The system displays the most recent entry date of the actual information from the
associated claim. |
| Actual Posted Dt |
Authorization |
The date the authorization was actually received. |
| Authorization Cmt |
Authorization |
Comments about the authorization. |
| Authorization Dt |
Authorization |
The date the authorization was requested or entered. |
| Authorization Expiration Dt |
Authorization |
The date the atthorization expires. |
| Authorization Status Dsc |
Authorization Status Type |
The description of an authorization status. |
| Authorization Type Cd |
Authorization Type |
The type of an authorization. |
| Authorized Allowed Amt |
Authorized Procedure |
The allowable $ amount that the procedure(s) is authorized for. |
| Diag Pend For Review Flg |
Diagnosis Code |
An indicator that this is pending a review to establish the diagnosis. |
| Diagnosis Dsc |
Diagnosis Code |
A description of the principle diagnosis for the condition. For hospital related
claims, this is the ICD-9 codes. |
| Discharge Dt |
Authorization |
Discharge Date: The date the patient is discharged. The date that care is ended. |
| Employee Database User Id |
Employee |
The user ID of an employee that is used when the user connects to a database or the
LAN. |
| Employee First Nm |
Employee |
The first name of an employee. |
| Employee Last Nm |
Employee |
The last name of an Employee. |
| Employee Middle Nm |
Employee |
The middle name of the employee. |
| Estimated Cost Amt |
Authorized Visit |
The estimated cost of a authorized visit. |
| Group Employee Size Type Id |
Group Master |
The identifier of the size of a group by the number of employees within that group. |
| Id Card Issue Dt |
Member |
The most recent date that an ID card is issued to a member. |
| Medicaid Id |
Member |
The medicaid ID # of the member. |
| Member Added Dt |
Member |
The date the member is ORIGINALLY added TO OUR SYSTEMS. |
| Next Review Dt |
Authorization |
The date the authorization is scheduled for the next review. |
| Org Assignd Employee Nbr |
Member |
The employee number or badge number of the subsriber. |
| Parent Group Id |
Group Master |
The surrogate key of the Parent Id. If it is NULL, it doesn't have a parent. |
| Place Of Service Cd |
Place Of Service |
The mnemonic code for the place of service. |
| Place Of Service Dsc |
Place Of Service |
A brief description of the place of service code. |
| Proc Gender Flg |
Specific Procedure Code |
Indicates whether a procedure code only is valid for a certain gendor code. |
| Procedure Dsc |
Specific Procedure Code |
The description for a procedure. |
| Procedure Pend For Review Flg |
Specific Procedure Code |
Indicates whether a claim for a procedure should always be pended for review. |
| Prov Plan Participating Flg |
Provider Plan Type |
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 Contract End Dt |
Provider Plan Type |
The date that the provider is terminated from a plan type. |
| Provider Plan Contract Start Dt |
Provider Plan Type |
The contract effective date of the provider plan type. |
| Region Id |
Group Master |
A Unique identifier of a region. |
| Service Reason Cd |
Service Reason |
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 Dsc |
Service Reason |
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 |
| Specific From Age Years Cnt |
Diagnosis Code |
The specific from age for a diagnosis code. |
| Specific Thru Age Years Cnt |
Diagnosis Code |
The specific thru age for a diagnosis code. |
| Start Age Years Cnt |
Specific Procedure Code |
The start of the age range for which a procedure code is valid. |
| Stop Age Years Cnt |
Specific Procedure Code |
The end of an age range for which a procedure code is valid. |
| Student Wvr Thr Dt |
Member |
The date through which a member has been certified as a student. |
| Trauma Related Flg |
Diagnosis Code |
An indicator that this diagnosis would be related to a trauma. |
