Versions Compared

Old Version 1

changes.mady.by.user DATABASICS, Inc.

Saved on

compared with

New Version 2

changes.mady.by.user Young White (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

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

ID

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

HDR_WK_END

Period End

Date

Timesheet Period End

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

LOCK_BY

Locked By

String

Locked by

if the timesheet is in Status: Open or Closed

LOCK_DT

Locked Datetime Stamp

Datetime

Locked Datetime

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

TOTAL

LEAVE_HOURS
(TM_TOTAL_

HOURS

Leave)

Total Leave Hours

String

Timesheet Total Leave Hours

LEAVE

NON_BILL_HOURS
(TM_TOTAL_

Leave

NON_BILL)

Total

Leave

Non-Billable Hours

String

Timesheet Total

Leave

Non-Billable Hours

NON_BILL

TOTAL_HOURS
(TM_TOTAL_

NON_BILL

HOURS)

Total

Non-Billable

Hours

String

Timesheet Total

Non-Billable

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


Standard HoursString

HDR_WK_END

Period End

Date

Timesheet Period End

LOCK_DT

Locked Datetime Stamp

Datetime

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