| View Name: | work_hr_view |
| View Number: | 9884 |
| Group: | Process Manager |
| Description: | Used to cache wk_work_hr and work_hour rows for biz_cal date arithmetic |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | work_hr | objid | Internal record number for work_hr | 3 (UNIQUE) |
| start_time | work_hr | start_time | Start time of the business hour period expressed in elapsed seconds from 12:00 AM midnight on Sunday | |
| end_time | work_hr | end_time | End time of the business hour period expressed in elapsed seconds from 12:00 AM midnight on Sunday | |
| wk_work_hr_objid | wk_work_hr | objid | Internal record number for wk_work_hr | |
| total_hour | wk_work_hr | total_hour | Total hours in the business calendar for each work week |
| Join From | Join To |
|---|---|
| (work_hr).work_hr2wk_work_hr | (wk_work_hr).wk_work_hr2work_hr |
| work_hr_view | |||