Home Up Contents

 HC EntAttrRpt
Back Next

 

Home
Up

 

CWTI

Health Care Enterprise Data Model

Entity Attribute Detail Report

Subject Area: Authorization

Attribute Key Domain Data Type Length
Entity: Authorization
Authorization Expiration Dt   Date alphanumeric 0
Discharge Dt   Date alphanumeric 0
Authorization Dt   Date alphanumeric 0
Authorization Cmt   Description 100 alphanumeric 0
Actual Posted Dt   Date alphanumeric 0
Next Review Dt   Date alphanumeric 0
Entity: Authorization Status Type
Authorization Status Cd PK Code 2 alphanumeric 0
Authorization Status Dsc   Description 30 alphanumeric 0
Entity: Authorization Type
Authorization Type Cd PK Code 1 alphanumeric 0
Authoriztion Type Dsc   Description 30 alphanumeric 0
Entity: Authorized Diagnosis
Authorization Sequence Nbr   Identifier 10 integer 0.
Entity: Authorized Procedure
Auth Detail Rc Src Cd   Code 1 alphanumeric 0
Authorized Procedure Qty   Quantity integer 0.
Actl Athrzd Amt   Amount real 0.
Actual Authorized Allowable Amt   Amount real 0.
Actual Claim Entered Dt   Date alphanumeric 0
Authorized Allowed Amt   Amount real 0.
Actual Authorized Qty   Quantity integer 0.
Entity: Authorized Visit
Estimated Cost Amt   Amount real 0.
Actual Visit Cnt   Quantity integer 0.
Authorized Visit Cnt   Quantity integer 0.
Requested Visit Cnt   Quantity integer 0.
Admit Or Primry Dt   Date alphanumeric 0
Entity: Code Category
Category Cd PK Code 2 alphanumeric 0
Category Dsc   Description 30 alphanumeric 0
Entity: Diagnosis Code
Accident Flg   Flag alphanumeric 0
Trauma Related Flg   Flag alphanumeric 0
Specific From Age Years Cnt   Age integer 0.
Diag Pend For Review Flg   Flag alphanumeric 0
Diagnosis Dsc   Description 80 alphanumeric 0
Specific Thru Age Years Cnt   Age integer 0.
Entity: Employee
Employee Middle Nm   Middle Name alphanumeric 0
Employee Database User Id   Oracle Internal Object alphanumeric 0
Employee First Nm   First Name alphanumeric 0
Employee Last Nm   Last Name alphanumeric 0
Entity: Group Master
Group Employee Size Type Id   Identifier 5 integer 0.
Parent Group Id   Group New Identifier integer 0.
Region Id   Identifier 5 integer 0.
Entity: Member
Grievance Flg   Flag alphanumeric 0
COB History Flg   Flag alphanumeric 0
Id Card Issue Dt   Date alphanumeric 0
Medicaid Id   Identifier 10 integer 0.
Member Added Dt   Date alphanumeric 0
Org Assignd Employee Nbr   Identifier 10 integer 0.
Student Wvr Thr Dt   Date alphanumeric 0
Case Manager MMI Unit Nbr   Identifier 10 integer 0.
Entity: Place Of Service
Place Of Service Cd PK Code 2 alphanumeric 0
Place Of Service Dsc   Description 30 alphanumeric 0
Entity: Provider Plan Type
Prov Plan Participating Flg   Flag alphanumeric 0
Provider Plan Contract End Dt   Date alphanumeric 0
Provider Plan Contract Start Dt   Date alphanumeric 0
Entity: Service Reason
Service Reason Cd PK Code 3 alphanumeric 0
Service Reason Dsc   Description 30 alphanumeric 0
Entity: Service Type
Service Type Cd PK Code 2 alphanumeric 0
Service Type Dsc   Description 30 alphanumeric 0
Entity: Specific Procedure Code
Procedure Pend For Review Flg   Flag alphanumeric 0
Follow Up Days Cnt   Quantity integer 0.
Pec Auto Pend Flg   Flag alphanumeric 0
Proc Gender Flg   Flag alphanumeric 0
Stop Age Years Cnt   Age integer 0.
Procedure Dsc   Description 50 alphanumeric 0
Start Age Years Cnt   Age integer 0.
Entity: Utilization Nurse
Employee Database User Id I Oracle Internal Object alphanumeric 0
Employee First Nm I First Name alphanumeric 0
Employee Last Nm I Last Name alphanumeric 0
Employee Middle Nm I Middle Name alphanumeric 0
 

 

[ Back ] [ Home ] [ Up ] [ Next ]

Send mail to caseware@cwti.com with questions or comments about this web site.
Copyright © 2000 CASEware Technology Inc.
Last modified: June 13, 2007