Versions Compared

Old Version 1

changes.mady.by.user DATABASICS, Inc.

Saved on

compared with

New Version 2

changes.mady.by.user Young White

Saved on

Key

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

Use this domain to create a missing timesheet 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

HOME_DEPT_NAME

Vendor Name

Home Department

String

Vendor

Home Department Name

FIRST_LAST

Full Name (Last, First)

String

Employee/User Last Name, First Name

HOME_DEPT_NAME

Home Department

String

Home Department

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

EMPLY_TYPE_NAME

Employee Type

String

Employee Type

Name

FULL_PART_TIME 
(FULL_PART)

Full/Part Time

String

Full or Part Time

HDR_WK_END

Period End

Date

Timesheet Period End

HDR_WK_START

Period Start

Date

Timesheet Period Start

STD_HOURS

Standard Hours

String

 


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

EMPLY_TYPE

Employee Type ID

String

Employee Type ID

OPT

LOCATION_CODE 
(HOME_

OPT

LOC_CODE)

Home

Operating Unit

Location Code

String

Home

Operating Unit

Location Code

LOCATION

OPT_CODE 
(HOME_

LOC

OPT_CODE)

Home

Location

Operating Unit Code

String

Home

Location

Operating Unit Code

EMP_

TERM

HIRE_DATE

Employee

Termination

Hire Date

Date

Employee

Termination

Start Date

EMP_

HIRE

TERM_DATE

Employee

Hire

Termination Date

Date

Employee

Start Date

EMP_TIME_ZONE

Employee Time Zone

String

Employee Time Zone

LANG_NAME

Language

String

Language

Termination Date