CT_CORE_HR_TL_RPTDTIME_COMMNTS
Purpose of Query
Timesheet w & w/o comments - Query returns employee timesheet entries with and without associated comments.
Folder
TL
Tables
A.CTW_TL_RPTDTIME - Time/Labor Reported Time Rpt
B.CTW_TLTR_COMMTS - TL TR Comments Rpt
C.CTW_EMPLOYEE_VW - Employee Information View
Prompts
Department like (%) – (Wildcard enabled)
Employee ID like (%) – (Wildcard enabled)
Rpt Dt From / Rpt Dt To - (Between criteria)
TRC like (%) – (Wildcard enabled)
Sample Results
Please note, due to page size limitations, sample results may be incomplete.
Criteria
C.EFFDT - Effective Date <= :4( Rptd Dt To Prompt)
Note: Runtime prompts are included as criteria.
Fields
Col / Record.Fieldname / Format / Ord / XLAT / Agg / Heading Text1 / A.EMPLID - EmplID / Char11 / ID
2 / A.EMPL_RCD - Empl Rcd Nbr / Num3.0 / Empl Rcd#
3 / A.NAME - Name / Char50 / Name
4 / C.LOCATION - Location Code / Char10 / Location
5 / A.DEPTID - Department / Char10 / DeptID
6 / A.ACCT_CD - Account Code / Char25 / Acct Code
7 / A.DUR - Date Under Report / Date / Rpt Dt
8 / A.OPRID - User ID / Char30 / User
9 / A.OPRID_LAST_UPDT - Last User to Update / Char30 / Updated By
10 / A.DTTM_CREATED - Datetime Created / DateTm / Datetime
11 / A.OVERRIDE_RSN_CD - Override Reason Code / Char5 / Override Rsn Cd
12 / A.CT_SHIFT_TL_OVR - Override Employee Shift / Char10 / OVR Emp Shift
13 / A.TRC - Time Reporting Code / Char5 / TRC
14 / A.TL_QUANTITY - Quantity / SNm14.6 / Quantity
15 / A.OVERRIDE_RATE - Override Rate / SNm14.6 / OvrdRate
16 / A.USER_FIELD_4 - User Field 4 / Char20 / User_4
17 / B.CT_COMMENT_KEY_TYP - CT Comment Key Type / Char1 / Key Type
18 / B.CT_COMMENT_SOURCE - Source for Comment / Char3 / Source
19 / B.COMMENTS254 - Comments / Char254 / Comment