DW_NS_TIMESHEET_F
This fact table contains the header level information of weekly timesheet filed by an employee.
Details
Module:
Key Columns
id
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | Transaction Identifier. | ||
| SOURCE_RECORD_ID | VARCHAR2 | 999 | This column is for Oracle Internal use only. Composite key that consists of all PK values of the transaction. This consists combination of columns that defines the granularity of the table and identifies a row uniquely. | ||||
| allocatedhours | NUMBER | Allocated hours. | |||||
| approvalstatus | NUMBER | 38 | 0 | Transaction approval status identifier. | DW_NS_timeLineApprovalStatus_D | key | |
| employee | NUMBER | 38 | 0 | Employee identifier associated with the transaction. | DW_NS_employee_D | id | |
| enddate | TIMESTAMP | Transaction end date: the date the project is finished. | |||||
| name | VARCHAR2 | 999 | The name of the transaction. | ||||
| plannedhours | NUMBER | Planned hours. | |||||
| rejectedhours | NUMBER | Rejected hours. | |||||
| startdate | TIMESTAMP | Start Date which is used to autofill the related downstream transaction (e.g. If a sales order includes a Start Date and End Date, those dates autofill on the invoice or cash sale when the order is billed ). | |||||
| submittedhours | NUMBER | Submitted hours. | |||||
| subsidiary | NUMBER | 38 | 0 | Subsidiary identifier associated with this transaction. | DW_NS_subsidiary_D | id | |
| totalhours | NUMBER | Total hours. | |||||
| trandate | TIMESTAMP | Posting or occurring date of this transaction. | |||||
| workcalendarhours | NUMBER | Work calendar hours. |