DATABASICS Standard Time Extract
DATABASICS Time has a standard extract, available to all customers. The intent of this extract is to make all data collected in the time reporting process available in a batched solution dependent on a defined workflow.
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.
Customer may take this raw data and process further to meet their internal needs. DATABASICS Consulting may also be engaged to tailor individual variations in this output 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 xml |
What to include | All fully approved timesheets’ data that that has not previously been extracted |
Level of detail | A Detailed Extract All data will be extracted as entered on the timesheet. There will be an export time record created for every distributed line entered in DATABASICS Time. |
Batch Type | TM |
Extract Specification
Column ID | Note |
EMPLY_ID | Employee ID |
OTHER_EMPLY_ID | Other ID on employee profile |
NAME | Employee Name |
CURRENCY | Employee currency |
HDR_WK_END | Reporting period end |
DOC_NO | Counter on the to track adjustments |
DOC_STATUS | Either N or C; linked to timesheet adjustment and version |
T_LINE_NO | Timesheet line number |
PAY_CODE | Time code |
BILLABLE_FLAG | Timesheet's line billable flag |
LEVEL1_CODE | Level 1 code |
LEVEL2_CODE | Level2 code |
LEVEL3_CODE | Level3 code |
LEVEL4_CODE | Level 4 code |
LEVEL_N_CODE | level n code |
LEVEL_INDEX | Level n index |
OPT_CODE | Timesheet's line operating unit/company, or similar |
DEPT_CODE | Timesheet's line department code/cost center, or similar |
FUNCTCODE | Timesheet's line function code/labor category, or similar |
LOCATION_CODE | Timesheet's line location code |
FUNCTION_NAME | Timesheet's line function name |
VALUE | Number of hours |
EVENT_DATE | Date when hours got charged |
POST_DTL_STATUS | Batch type |
POST_DT | Post date |
RUN_TYPE | It is an argument from the profile; by default it is F |
BATCH_ID | Batch id |
2021 DATABASICS, Inc