Actual Labor HoursActual Time SpentDelay ReasonFraud Investigation Closed DateFraud Investigation Opened DateFraud Investigation StatusNamePlanned DurationPlanned End DatePlanned ManpowerPlanned Start Date
| Business Data Model Data Model |
| Description | An examination that a health plan organization undertakes with the purpose of detecting deliberate deception. |
| Relationship | |
 Claim Fraud Investigation_Claim Line_FK |
|
| Claim Fraud Investigation_Claim_FK |
|
| Claim Fraud Investigation_Party_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Actual Labor Hours
| Description | Actual number of hours that it took to perform the activity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Small Counter [SHORT] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Actual Time Spent
| Description | The actual time spent performing the activity. This differs from the labor hours by describing the elapsed time over which the labor hours were spread. For example, an activity may involve 4 hours actual work over 3 days. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Delay Reason
| Description | Indicates the cause of any discrepancy between planned and actual end dates. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Fraud Investigation Closed Date
| Description | The upon which all fraud investigation activities were concluded. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Fraud Investigation Opened Date
| Description | The date upon which fraud investigation activities commenced. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Fraud Investigation Status
| Description | Indicates the current state of the claim fraud investigation. For example: Initiated Concluded Fraudulent Concluded No Fraud In Progress |
| Data Type | Standards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Name
| Description | A word or phrase identifying the activity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Name [VARCHAR(30)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Planned Duration
| Description | The time planned for the performing of the activity. This is the total elapsed time over which the activity is expected to be performed and not the planned labor hours. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Planned End Date
| Description | Date upon which the activity is planned to end. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Planned Manpower
| Description | The planned labor hours required for the activity. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Number Decimal Large [DECIMAL(15,6)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Planned Start Date
| Description | Date upon which the activity is planned to start. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Date [DATE] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
| Relationship Details |
Claim Fraud Investigation_Claim Line_FK
| Is Identifying Relationship | false |
| Child Table | Claim Fraud Investigation |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Claim Line |
| Parent Multiplicity | ZERO_TO_MANY |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Claim Fraud Investigation_Claim_FK
| Is Identifying Relationship | false |
| Child Table | Claim Fraud Investigation |
| Child Role Name | is for |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Claim |
| Parent Role Name | is subject of |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Claim Fraud Investigation_Party_FK
| Is Identifying Relationship | false |
| Child Table | Claim Fraud Investigation |
| Child Role Name | is executed by |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Party |
| Parent Role Name | executes |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |