The Note Domain is used to create a report that shows the notes attached to a timesheet. The hours displayed are for hours entered for that Note. Examples:

Timesheet Detail Notes Report

The domains consists of the following columns

NOTE: Column names are the default names of the system, these can be renamed. You might see different names based on your site configuration.

Column ID	Column Name (From DBLabels.properties)	Data Type	Description
LAST_FIRST	Full Name (Last, First)	String	Employee/User Last Name, First Name
LEVEL1_CODE	Level1 Code	String	WBS Level1 Code
LEVEL1_NAME	Level 1	String	WBS Level1 Name
LEVEL2_CODE	Level2 Code	String	WBS Level2 Code
LEVEL2_NAME	Level 2	String	WBS Level2 Name
LEVEL3_CODE	Level3 Code	String	WBS Level3 Code
LEVEL3_NAME	Level 3	String	WBS Level3 Name
LEVEL4_CODE	Level4 Code	String	WBS Level4 Code
LEVEL4_NAME	Level4	String	WBS Level4 name
LOCKED_BY	Locked By	String	Locked by if the timesheet is in Status: Open or Closed
T_LINE_NO	Line ID	Integer	Timesheet Line Id
PAY_CODE (TC_CODE)	Time Code	String	Time Code
PC_NAME (TC_NAME)	Time Code Name	String	Time Code Name
PREV_STATUS (TM_PREV_STATUS)	Timesheet Previous Status	String	Previous Status could be one of the following: On Hold Released In Approval Status Rejected Approved
TM_STATUS	Timesheet Status	String	Timesheet status: On Hold Open Released Closed In Approval Status Rejected Approved
TM_VALID_STATUS	Timesheet Validation Status	String	Timesheet Validation Status could be one of the following: Failed Warnings Passed No Action
HOME_OPT_NAME	Home Operating Unit	String	Home Operating Unit Name
HOME_DEPT_NAME	Home Department	String	Home Department Name
EMPLY_TYPE_NAME	Employee Type	String	Employee Type Name
HOME_FUNC_NAME	Home Function	String	Home Function Name
HOME_LOC_NAME	Home Location	String	Home Location Name
OPT_CODE (WORK_OPT_CODE)	Worked Operating Unit Code	String	Worked Operating Unit Code
OPT_NAME (WORK_OPT_NAME)	Worked Operating Unit	String	Worked Operating Unit Name
DEPT_CODE (WORK_DEPT_CODE)	Worked Department Code	String	Worked Department Code
DEPT_NAME (WORK_DEPT_NAME)	Worked Department	String	Worded Department Name
FUNCTCODE (WORK_FUNC_CODE)	Worked Function Code	String	Worked Function Code
FUNCTION_NAME (WORK_FUNC_NAME)	Worked Function	String	Worked Function Name
LOCATION_CODE (WORK_LOC_CODE)	Worked Location Code	String	Work Location Code
LOCATION_NAME (WORK_LOC_NAME)	Worked Location	String	Worked Location Name
BILL_FLAG (TM_BILL_FLAG)	Billable flag	String	Billable Flag
LAST_DOC_NUMBER	Document Number	Integer	Document Number
PROCESS_STATUS (TM_PROCESS_STATUS)	Process Status	String	Process Status could be one of the following: Posted Not Posted
VENDOR_ID	Vendor ID	String	Vendor ID
BATCH_TYPE_1	Databasics Extract Batch Type	String	Databasics Extract Batch Type
BATCH_TYPE_2	DATABASICS ACH	String	DATABASICS ACH
BATCH_TYPE_3	Batch type 3	String	Used for additional batch types
BATCH_TYPE_4	Batch type 4	String	Used for additional batch types
BATCH_TYPE_5	Batch type 5	String	Used for additional batch types
ENTERED_BY	Entered by	String	Timesheet Modified by Employee id
NOTE	Note	String	Note
NOTE_TYPE	Note Type	String
START_DATE (NOTE_START_DATE)	Note Start date	Date	Note Start Date
END_DATE (NOTE_END_DATE)	Note End date	Date	Note End Date
NOTE_SORT	Note Sort	String
LEVEL1_FLAG	Level1 Flag	String	WBS Level1 Flag
LEVEL1_TYPE	Level1 Type	String	WBS Level1 Type
MAIN_WBS_CODE	Main WBS Code	String	WBS Main WBS Code
MAIN_WBS_NAME	Main WBS	String	WBS Main WBS Name
LEVEL2_FLAG	Level2 Flag	String	WBS Level2 Flag
LEVEL2_TYPE	Level2 Type	String	WBS Level2 Type
OTHER_EMPLY_ID1	Other Employee ID1	String	Employee Other id1 that is mapped to OTHER_EMPLY_ID1 in the employee table
OTHER_EMPLY_ID2	Other Employee ID2	String	Employee Other id2
SSN	SSN	String	Employee Other id that is mapped to SSN field.
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
EMPLY_ID	Employee ID	String	Employee Id
OPT_CODE (HOME_OPT_CODE)	Home Operating Unit Code	String	Home Operating Unit Code
DEPT_CODE (HOME_DEPT_CODE)	Home Department Code	String	Home Department Code
EMPLY_TYPE	Employee Type Code	String	Employee Type ID
FUNCTCODE (HOME_FUNC_CODE)	Home Function Code	String	Home Function Code
LOCATION_CODE (HOME_LOC_CODE)	Home Location Code	String	Home Location Code
APPLY_ON (NOTES_APPLY_ON)	Note Apply on	String	Displays Line/Columns with Notes -No Notes -Row
HOURS	Hours	Decimal	Hours
HDR_WK_END	Period End	Date	Timesheet Period End
LOCKED_DT	Locked Datetime Stamp	Datetime	Locked Datetime if the timesheet is in Status: Open or Closed

Browser not supported