Expense Pre-authorization Domain

5.1.x to 5.4.4

Expense Preauthorizations Domain 5.1.x

Domains

5.5 and higher

Expense Preauthorizations

DomainsV55

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