CurrencyHours Expense AmtHours QtyHours Unit Of MeasureLabor Hours Category
| Business Data Model Data Model |
| Description | A record of hours that an employee expends in a defined capacity. For example: Regular Overtime Personal Training |
| Attributes | |
| Currency |
|
| Hours Expense Amt |
|
| Hours Qty |
|
| Hours Unit Of Measure |
|
| Labor Hours Category |
|
| Relationship | |
 Timecard Line_Timecard_FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Attribute Details |
Currency
| Description | The currency that is used as the basis for all monetary amounts. |
| 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 |
Hours Expense Amt
| Description | The labor expense associated with the hours reported. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Currency Amount [DECIMAL(14,2)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Hours Qty
| Description | The number of hours worked for this period. |
| Data Type | Standards - Data Domains.ddm/Data Domains/Quantity Float [FLOAT(15)] |
| Is Part Of PrimaryKey | false |
| Is Required | false |
| Is Derived | false |
| Is Surrogate Key | false |
Hours Unit Of Measure
| Description | The time unit of measure for number of hours worked for this period. |
| 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 |
Labor Hours Category
| Description | Describes the type of hours being reported. For example: Regular Overtime Personal Training |
| 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 |
| Relationship Details |
Timecard Line_Timecard_FK
| Is Identifying Relationship | true |
| Child Table | Timecard Hours |
| 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 | Timecard |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |