Import Time Data from a File

Owned by DATABASICS, Inc.
Mar 16, 2021
2 min read

 

DATABASICS Time has a standard import, available to all customers. The intent of this import time data from external systems into DATABASICS and create timesheets in DATABASICS.

It is understood that no customer utilize all DATABASICS feature functionality: if a feature is not used the field output value in this specification will be blank.

DATABASICS Consulting may also be engaged to tailor individual variations in this input data to suit customer requirements specifically, e.g. remove unused fields or add customer specific fields.

DATABASICS Standard Time Extract

Technical Specification

File Attribute

Description

File Format

tab delimited, or csv

Level of detail

A Detailed import

All data will be imported and validated before create the timesheets

Timesheet Exists

  • Replace existing timesheets

  • Append to existing Timesheet

Timesheet Status

After import the timesheet make sure change status to

  • Release to approval

  • Draft

  • Closed

Default Notes Purpose Type

Default is O for other.

 

Import Specification

  • Required - Means it must exists in the file

  • Configurable - Means the column could be disabled but a default value needs to be set if it is not included in the load.

  • Optional - The column could be included in the load with no required data.

Column ID

Note

Date Type

Required

EMPLY_ID

Employee ID

Varchar(20)

Required

EVENT_DATE

Date when hours got charged

Date

Required

PAY_CODE

Pay Code id (Default could be set)

Varchar(20)

Configurable

LEVEL1_CODE

WBS Level 1 code

Varchar(20)

Configurable

LEVEL2_CODE

Level2 code

Varchar(20)

Configurable

LEVEL3_CODE

Level3 code

Varchar(20)

Configurable

LEVEL4_CODE

Level 4 code

Varchar(20)

Configurable

LEVEL_N_CODE

level n code

 

Configurable

OPT_CODE

Timesheet's line operating unit/company, or similar

Varchar(20)

Configurable

DEPT_CODE

Timesheet's line department code/cost center, or similar

Varchar(20)

Configurable

FUNCTCODE

Timesheet's line function code/labor category, or similar

Varchar(20)

Configurable

LOCATION_CODE

Timesheet's line location code

Varchar(20)

Configurable

VALUE

Number of hours per worked day

Decimal (16,2)

Required

Notes

Notes

Varchar(255)

Optional

2024 DATABASICS, Inc