Expense Report Work Flow Domain

Owned by DATABASICS, Inc.
Last updated: Mar 13, 2017 by Young White (Deactivated)
2 min read

This domain allows you to create a report that shows the history of the Expense Report. When certain actions were taken and by whom (created, released, rejected, approved, etc.). Examples:

  • Expense Report Audit

Supported Version

Domain Name

Domain Folder

5.1.x to 5.4.4

Expense Work Flow Domain 5.1.x

Domains

5.5 and higher

Expense Report Work Flow

DomainsV55

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)

NOTE: Should be sorted by REPORT_ID and COPY_ID

Column ID

Column Name (From DBLabels.properties)

Data Type

Description

REPORT_ID

Report ID

Integer

Report ID

COPIED_DT

Copied on

DateTime

Report Last Accessed DateTime

EMPLY_ID

Employee ID

String

Employee Id

COPIED_BY

Copied by ID

String

Employee Id of Last Accessed

HDR_TITLE

Report Title

String

Report Tile

LAST_FIRST

Full Name (Last, First)

String

Employee/User Last Name, First Name

XP_CERT_STATUS

Certify Status

String

Certify Status by the user for the expense report.       
Certify Status:    
Require Certification    
Certified Already    
No Action (default)    

COPY_BY_NAME

Copied by Name

String

Name of Employee Last Accessed

COPY_USER_TYPE

Copied User Type

String

User Type of Last Accessed

REPORT_TYPE_NAME

Report Type

String

Report Type Name

FILE_ATTACHMENT

Attachment

String

Attachment

XP_REPORT_STATUS

Report Status

String

Expense report status:    
On Hold    
Open    
Released    
Closed    
In Approval Status    
Rejected    
Approved

XP_REPORT_PREV_STATUS

Report Previous Status

String

On Hold       
Released       
In Approval Status    
Rejected    
Approved

XP_REPORT_PROC_STATUS

Process Status

String

Process Status could be one of the following:
*Fully Paid
*Partially Paid 
*Posted for Payment 
*No action (Default - Not posted)

XP_REPORT_VAILD_STATUS

Report Validation Status

String

Report Validation Status could be one of the following: 
*Incomplete 
*Invalid Charge 
*Passed 
*Passed with warnings 
*No Action

HDR_ID

Copy ID

Integer

Id for Internal Tracking

OTHER_EMPLY_ID1

Other Employee ID 1

String

Employee Other id1 that is mapped to OTHER_EMPLY_ID1 in the employee table

OTHER_EMPLY_ID2

Other Employee ID 2

String

Employee Other id2

SSN

SSN

String

Employee Other id that is mapped to SSN field.

HDR_PLACE_NAME

Cover Page Place Name

String

Expense Report Place Name if existing on the Report Cover Page.

TODAY_DATE

TODAY_DATE

Date

Today's Day - Used for Scheduling Reports

EMP_ACTIVE

Active Employee

String

Employee Active Yes or No

REPORT_TYPE

Report Type Code

String

Report Type ID

XP_CURRENT_REPORT_STATUS

Current Report Status

String

Expense report current status:     
On Hold     
Open     
Released     
Closed     
In Approval Status     
Rejected     
Approved

END_DATE

Report End Date

Date

Expense Report End Date

START_DATE

Report Start Date

Date

Expense Report Start Date

2024 DATABASICS, Inc