Versions Compared

Old Version 2

changes.mady.by.user Young White

Saved on

compared with

New Version Current

changes.mady.by.user Young White

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Allows you to create reports that reconcile travel authorization requests with the actual expense reports. Examples:

  • Travel Authorization Reconciliation Report

Supported Version

Domain Name

Domain Folder

5.1.x to 5.4.4

Expense Preauthorizations Domain 5.1.x

Domains

5.5 and higher

Expense Preauthorizations

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)

Column ID

Column Name (From DBLabels.properties)

Data Type

Description

DEPT_NAME
(HOME_DEPT_NAME)

Home Department

String

Home Department Name

EMPLY_TYPE_NAME

Employee Type

String

Employee Type Name

OPT_NAME
(HOME_OPT_NAME)

Home Operating Unit

String

Home Operating Unit Name

REPORT_ID
(TA_REPORT_ID)

TA Report ID

Integer

Travel Authorization Report ID

HDR_TITLE
(TA_HDR_TITLE)

TA Report Title

String

Travel Authorization Report Title

TA_STATUS
(TA_XP_REPORT_STATUS)

TA Report Status

String

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

TA_TOTAL
(TA_REPORT_TOTAL)

TA Total Report Amount

Decimal

Travel Authorization Report Total Amount

ER_NO
(REPORT_ID)

Report ID

Integer

Linked Report ID for original Travel Authorization

ER_TITLE
(HDR_TITLE)

Report Title

String

Linked Report Title for original Travel Authorization

ER_STATUS
(XP_REPORT_STATUS)

Report Status

String

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

ER_TOTAL_C
(REPORT_TOTAL)

Total Report Amount

Decimal

Linked Expense Report Total Amount

EMPLY_ID

Employee ID

String

Employee Id

EMPLY_TYPE

Employee Type Code

String

Employee Type ID

RPT_CURR

Report Currency

String

Expense Report Currency Code

VENDOR_ID

Vendor ID

String

Vendor ID that is linked to the report that got requested

VENDOR_NAME

Vendor

String

Vendor Name

ER_PROC_STATUS_STATUS
(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)

TA_CERT_STATUS

TA Certify Status

String

Travel Authorization Certify Status
Require User Certification
No action needed
User Certified The Report

XP_CERT_STATUS

Certify Status

String

Expense Report Certify Status:   
Require Certification   
Certified Already   
No Action (default)   

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.

OPT_CODE
(HOME_OPT_CODE)

Home Operating Unit Code

String

Home Operating Unit Code

EMP_ACTIVE

Active Employee

String

Employee Active Yes or No

DEPT_CODE
(HOME_DEPT_CODE)

Home Department Code

String

Home Department Code

START_DATE

Report Start Date

Date

Expense Report Start Date

END_DATE

Report End Date

Date

Expense Report End Date