Expense Report Work Flow Domain

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
END_DATE	Report End Date	Date	Expense Report End Date
START_DATE	Report Start Date	Date	Expense Report Start Date
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_STATUS	Report Status	String	Expense report status: On Hold Open Released Closed In Approval Status Rejected Approved
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
COPY_ID	Copy ID	Integer	Id for Internal Tracking
OTHER_EMPLY_ID1	Other Employee ID1	String	Employee Other id1 that is mapped to OTHER_EMPLY_ID1 in the employee table
OTHER_EMPLY_ID2	Other Employee ID2	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		DATE	Used for Scheduling Reports
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
REPORT_TYPE	Report Type ID	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