Import Time Data from a File
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 |
|
Timesheet Status | After import the timesheet make sure change status to
|
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 |
2021 DATABASICS, Inc