Time Summary Hours Domain

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

This is tied to the timesheet data (header, row and detail). It will display the hours summarized by timesheet. Examples:

  • Billable/Non-billable Hours per Period
  • Leave Hours per Period

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

DEPT_CODE
(HOME_DEPT_CODE)

Home Department Code

String

Home Department Code

EMPLY_TYPE

Employee Type Code

String

Employee Type ID

EMPLY_TYPE_NAME

Employee Type

String

Employee Type Name

FUNCTCODE
(HOME_FUNC_CODE)

Home Function Code

String

Home Function Code

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

LOCATION_CODE
(HOME_LOC_CODE)

Home Location Code

String

Home Location Code

LOCKED_BY

Locked By

String

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

OPT_CODE
(HOME_OPT_CODE)

Home Operating Unit Code

String

Home Operating Unit Code

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

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.

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

VENDOR_ID

Vendor ID

String

Vendor ID

BILL_HOURS
(TM_TOTAL_BILL)

Total Billable Hours

String

Timesheet Total Billable Hours

LEAVE_HOURS
(TM_TOTAL_Leave)

Total Leave Hours

String

Timesheet Total Leave Hours

NON_BILL_HOURS
(TM_TOTAL_NON_BILL)

Total Non-Billable Hours

String

Timesheet Total Non-Billable Hours

TOTAL_HOURS
(TM_TOTAL_HOURS)

Total Hours

String

Timesheet Total Hours

TODAY_DATE

TODAY_DATE

Date

Today's Date - Used for Scheduling Report

EMP_ACTIVE

Active Employee

String

Employee Active Yes or No

EMPLY_ID

Employee ID

String

Employee Id

FIRST_RELEASED_DATE

First Released date

String

Submitted Date

LAST_APPROVED_DATE

Last Approved Date

String

Last Approval Date

STD_HOURSStandard HoursStringThe standard working hours for the timesheet period

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