| View Name: | biz_cal_view |
| View Number: | 9883 |
| Group: | Process Manager |
| Description: | Used to cache biz_cal rows for biz_cal date arithmetic |
| Flags: | VIEW_OPTIMIZED |
| Baseline/Custom: | Baseline |
| View Field Name | Table Name | Field Name | Comment | Generic Field Id |
|---|---|---|---|---|
| objid | biz_cal | objid | Internal record number for biz_cal | 3 (UNIQUE) |
| effective_date | biz_cal | effective_date | Date/time the calendar takes effect at the site | |
| biz_cal_hdr_objid | biz_cal_hdr | objid | Internal record number for biz_cal_hdr | |
| 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 |
|---|---|
| (biz_cal).biz_cal2biz_cal_hdr | (biz_cal_hdr).biz_cal_hdr2biz_cal |
| (biz_cal).biz_cal2wk_work_hr | (wk_work_hr).wk_work_hr2biz_cal |
| biz_cal_view | |||