| DOCUMENT_ID |
Integer |
38 |
PK |
| TRACKING_NUMBER |
Varchar |
255 |
The character id of the document, visible to the typical user |
| DOCUMENT_STATUS |
varchar |
255 |
Its current state |
| CURRENT_ACTIVITY_ID |
Number |
38 |
id of current activity. activities are the nodes of work-flow, and documents are routed from node to node. |
| ENTERED_CURRENT_ACTIVITY_DATE |
date |
|
The date the item entered the queue, a queue holds items for an activity, waiting to be checked out. |
| CHANGE_TIMESTAMP |
date |
|
|
| ACTIVITY_OWNER_ID |
Integer |
38 |
Current activity user |
| HAS_EXCEPTIONS |
Number |
5 |
1 if there are any exceptions, ie business rule violations |
| HAS_OVERRIDES |
Number |
5 |
1 if there are any overrides, ie the approved amount for an expense is less than the submitted amount |
| CREATE_DATE |
Date |
|
Doc Created date |
| CREATER_OWNER_ID |
Number |
38 |
Owner id |
| CREATER_USER_ID |
Number |
38 |
User id |
| AUDIT_INDICATOR |
Varchar |
255 |
customer specific audit attributes |
| TITLE |
Varchar |
255 |
document title, usually a range of dates |
| PERIOD_START_DATE |
Date |
|
start of time period this document describes |
| PERIOD_END_DATE |
Date |
|
end of time period this document describes |
| SUBMITED_DATE |
Date |
|
date user submitted document |
| APPROVED_DATE |
Date |
|
date manger approved document |
| TOTAL_HOURS |
Number |
14,4 |
Total hours seen by reviewer |
| WORK_SCHEDULE_HOURS |
Number |
14,4 |
Work schedule hours |
| HOLIDAY_SCHEDULE |
Varchar |
255 |
The holiday schedule for the user, when the timesheet document is created. |
| LABOR_STATUS |
Varchar |
255 |
describes labor status at time of creation |
| EMPLOYMENT_STATUS |
Varchar |
255 |
give employment status at time of filing |
| BILLABLE_RATE |
Number |
28,10 |
default billabe rate for this timesheet |
| BILLABLE_RATE_CURRENCY |
Varchar |
3 |
Currency of billable rate |
| OVERTIME_HOURS |
Number |
7,2 |
Total over time hours |
| DOUBLE_HOURS |
Number |
7,2 |
Double hours |
| TRIPLE_HOURS |
Number |
7,2 |
Triple hours |
| REGULAR_HOURS |
Number |
7,2 |
Regular hours |
| CREATE_LOCATION_ID |
Number |
38 |
The bob id of the location where the timesheet is created. |
| JOB_CLASSIFICATION |
Varchar |
100 |
Job classification of the creator when timesheet is created. |
| CREATOR_CLIENT_TYPE |
Number |
38 |
the client that created the document (1=HTML, 2=Mobile, 3=Voice, 4=DocumentImportBkg) |