Expense Budget Domain

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

BUDGET_NAMEBudget NameStringBudget Name
BUDGET_TYPEBudget Type IDStringBudget Type ID
BUDGET_TYPE_NAMEBudget Type NameStringBudget Type Name

EMPLY_ID

Employee ID

String

Employee Id

ENTERED_BY

Entered by

String

Employee ID of person who entered the expense

EXP_TYPE_NAME

Expense Type

String

Expense Type Name Charge

GRP_EXP_NAME

Expense Type Group

String

Expense Type Group Name for the charge Expense Type

LAST_FIRST

Full Name (Last, First)

String

Employee/User Last Name, First Name

LEVEL1_CODE

Level1 Code

String

WBS Level1 Code

LEVEL1_NAME

Level 1

String

WBS Level1 Name

LEVEL2_CODE

Level2 Code

String

WBS Level2 Code

LEVEL2_NAME

Level 2

String

WBS Level2 Name

LEVEL3_CODE

Level3 Code

String

WBS Level3 Code

LEVEL3_NAME

Level 3

String

WBS Level3 Name

LEVEL4_CODE

Level4 Code

String

WBS Level4 Code

LEVEL4_NAME

Level 4

String

WBS Level4 name

NOTE

Note

String

Note

REPORTING_TYPE_DESCR

Period Type NameStringReport Period Type Name

REPORTING_TYPE_ID

Period Type IDStringReporting Period Type ID

WORK_DEPT_CODE

Worked Department Code

String

Worked Department Code

WORK_DEPT_NAME

Worked Department

String

Worded Department Name

WORK_OPT_CODE

Worked Operating Unit Code

String

Worked Operating Unit Code

WORK_OPT_NAME

Worked Operating Unit

String

Worked Operating Unit Name

ACTUAL_AMOUNTActual AmountDecimalActual Amount Used
BUDGETED_AMOUNTBudgeted AmountDecimalBudgeted Amount
BUDGET_END_DATEBudget End DateDateBudget End Date
BUDGET_START_DATEBudget Start DateDateBudget Start Date

DTSTAMP

DateTime Stamp

DateTime

DateTime Stamp

PERIOD_END_DATE

Period End Date

Date

Reporting Period Start Date

PERIOD_START_DATEPeriod Start DateDateReporting Period End Date

2024 DATABASICS, Inc