Time Status Domain

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

Use this domain to create a status report of timesheets in the application. Examples:
Timesheet Status Report

  • Rejected Timesheet Report
  • Missing timesheet report
  • Approved timesheets
  • Timesheet Status 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

LAST_FIRST

Full Name (Last, First)

String

Employee/User Last Name, First Name

VENDOR_ID

Vendor ID

String

Vendor ID

VENDOR_NAME

Vendor

String

Vendor 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

HOME_OPT_NAME

Home Operating Unit

String

Home Operating Unit Name

FULL_PART_TIME
(FULL_PART)

Full/Part Time

String

Full or Part Time

HDR_STATUS
(TM_STATUS)

Timesheet Status

Note: For missing timesheet you would need to use the Missing Timesheet status

String

Timesheet status:    
On Hold    
Open    
Released    
Closed    
In Approval Status    
Rejected    
Approved 
Missing Timesheet

HDR_WK_END

Period End

Date

Timesheet Period End

HDR_WK_START

Period Start

Date

Timesheet Period Start

PROC_STATUS
(TM_PROCESS_STATUS)

Process Status

String

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

STD_HOURS

Standard Hours

String


TOTAL_HOURS
(TM_TOTAL_HOURS)

Total Hours

Integer

Timesheet Total Hours

REPORTING_TYPE

Reporting Type

String

Reporting 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

DEPT_CODE
(HOME_DEPT_CODE)

Home Department Code

String

Home Department Code

EMPLY_ID

Employee ID

String

Employee Id

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

OPT_CODE
(HOME_OPT_CODE)

Home Operating Unit Code

String

Home Operating Unit Code

FIRST_RELEASED_DATE

First Released date

String

Date Submitted

LAST_APPROVED_DATE

Last Approved Date

String

Last Approval Date

DAYS_TO_APPROVE

Days to Approve

String

Number of day from submitted to approve

2024 DATABASICS, Inc