Time Detail Hours Domain

Owned by DATABASICS, Inc.
Last updated: Mar 13, 2017 by Young White (Deactivated)

This is tied to the timesheet data (header, row and detail). It will display the hours entered per day on the timesheet. Example:

  • Hours Detail Report

The domains consists of the following columns (NOTE: Column names could be renamed so you might see different names based on your side configuration, so the following names are the base names of the system)

Column ID

Column Name (From DBLabels.properties)

Data Type

Description

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

BILL_FLAG
(TM_BILL_FLAG)

Billable flag

String

Billable Flag

DEPT_CODE
(WORK_DEPT_CODE)

Worked Department Code

String

Worked Department Code

WORK_DEPT_NAME

Worked Department

String

Worded Department Name

EMPLY_TYPE_NAME

Employee Type

String

Employee Type Name

FUNCTCODE
(WORK_FUNC_CODE)

Worked Function Code

String

Worked Function Code

FUNCTION_NAME
(WORK_FUNC_NAME)

Worked Function

String

Worked Function Name

HOME_DEPT_NAME

Home Department

String

Home Department Name

HOME_FUNC_NAME

Home Function

String

Home Function Name

HOME_LOC_NAME

Home Location

String

Home Location Name

HOME_OPT_NAME

Home Operating Unit

String

Home Operating Unit Name

LAST_DOC_NUMBER

Document Number

Integer

Document Number

LAST_FIRST

Full Name (Last, First)

String

Employee/User Last Name, First Name

LEVEL1_CODE

Level1 Code

String

WBS Level1 Code

LEVEL1_FLAG

Level1 Flag

String

WBS Level1 Flag

LEVEL1_NAME

Level 1

String

WBS Level1 Name

LEVEL1_TYPE

Level1 Type

String

WBS Level1 Type

LEVEL2_CODE

Level2 Code

String

WBS Level2 Code

LEVEL2_FLAG

Level2 Flag

String

WBS Level2 Flag

LEVEL2_NAME

Level 2

String

WBS Level2 Name

LEVEL2_TYPE

Level2 Type

String

WBS Level2 Type

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

Level 4

String

WBS Level4 name

LOCATION_CODE
(WORK_LOC_CODE)

Worked Location Code

String

Work Location Code

LOCATION_NAME
(WORK_LOC_NAME)

Worked Location

String

Worked Location Name

LOCKED_BY

Locked By

String

Locked by if the timesheet is in Status: Open or Closed

MAIN_WBS_CODE

Main WBS Code

String

WBS Main WBS Code

MAIN_WBS_NAME

Main WBS

String

WBS Main WBS 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

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

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

PROCESS_STATUS
(TM_PROCESS_STATUS)

Process Status

String

Process Status could be one of the following:
*Posted
*Not Posted

SSN

SSN

String

Employee Other id that is mapped to SSN field.

T_LINE_NO

Line ID

Integer

Timesheet Line Id

TIME_IN

Time In

DateTime

First Time In on Timesheet

TIME_IN1

Time In 1

DateTime

Second Time In on Timesheet

TIME_OUT

Time Out

DateTime

First Time Out on Timesheet

TIME_OUT1

Time Out 1

DateTime

Second Time Out on Timesheet

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

VALUE
(HOURS)

Hours

Decimal

Hours

VENDOR_ID

Vendor ID

String

Vendor ID

L1_OPT_CODE

Level1 Operating Unit Code

String

Level 1 Operating Unit Code

L1_OPT_NAME

Level1 Operating Unit

String

Level 1 Operating Unit Name

TODAY_DATE

TODAY_DATE

Date

Today's Date - Used for Scheduling Report

EMP_ACTIVE

Active Employee

String

Employee Active Yes or No

DEPT_CODE
(HOME_DEPT_CODE)

Home Department Code

String

Home Department Code

EMPLY_ID

Employee ID

String

Employee Id

FUNCTCODE
(HOME_FUNC_CODE)

Home Function Code

String

Home Function Code

EMPLY_TYPE

Employee Type Code

String

Employee Type ID

LOCATION_CODE
(HOME_LOC_CODE)

Home Location Code

String

Home Location Code

OPT_CODE
(HOME_OPT_CODE)

Home Operating Unit Code

String

Home Operating Unit Code

L1_END_DATE

Level1 End Date

Date

Level 1 End Date

L1_START_DATE

Level1 Start Date

Date

Level 1 Start Date

L2_END_DATE

Level2 End Date

Date

Level 2 End Date

L2_START_DATE

Level2 Start Date

Date

Level 2 Start Date

L1_CLOSE_DATE

Level1 Close Date

Date

Level 1 Close Date

L1_OPEN_DATE

Level1 Open Date

Date

Level 1 Open Date

L2_CLOSE_DATE

Level2 Close Date

Date

Level 2 Close Date

L2_OPEN_DATE

Level2 Open Date

Date

Level 2 Open Date

EVENT_DATE

Event Date

Date


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

2024 DATABASICS, Inc