Expense Attendee Amount Domain 5.4

This domain contains the actual amount allocated per attendee per line if that functionality is enabled to capture amount per attendee.

Supported Version	Domain Name	Domain Folder
5.1.x to 5.4.4	Expense Attendee Amount Domain 5.1.x	Domains
5.5 and higher	Expense Attendee with Amount Allocation per Attendee	DomainsV55

NOTE: Make sure you select the RPT_CURR for one specific currency so you could sum the totals across all reports

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
ATT_COMPANY	Attendee Company	String	Attendee Company
ATT_EMPLY_ID	Attendee ID	String	Attendee Employee ID if the employee was an attendee or NPI Number if the doctor was selected as an attendee. If the Attendee is not in the DATABASICS system as a shared attendee than the ATT_EMPY_ID is null.
ATT_NAME	Attendee Name	String	Attendee Full Name
ATT_TITLE	Attendee Title	String	Attendee Title
ATT_AMOUNT	Attendee Amount	Decimal	Attendee Allocated Amount
ATT_COUNT	Number of Attendees	Integer	Number of Attendees per expense charge per report.
PERCENTAGE	Percentage	Decimal	% allocated per attendee for a specific charge on the expense report.
HDR_TITLE	Report Title	String	Report Tile
REPORT_ID	Report ID	Integer	Report ID
REPORT_TYPE	Report Type ID	String	Report Type ID
REPORT_TYPE_NAME	Report Type	String	Report Type Name
HDR_STATUS_NAME	Report Status	String	Expense report status: On Hold Open Released Closed In Approval Status Rejected Approved
LOCK_BY	Locked by	String	Locked by if the expense report is in Status: Open or Closed
LOCK_DT	Locked Datetime Stamp	Datetime	Locked Datetime if the expense report is in Status: Open or Closed
NOTE	Note	String	Attendee Line Level Note
LAST_FIRST	Full Name (Last, First)	String	Employee/User Last Name, First Name
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)
HDR_DT	Report Datetime Stamp	Datetime	Expense Report Header Datetime Stamp - Last Modified Datetime.
VENDOR_ID	Vendor ID	String	Vendor ID that is linked to the report that got requested
VENDOR_NAME	Vendor Name	String	Vendor Name
START_DATE	Report Starte Date	Date	Expense Report Start Date
END_DATE	Report End Date	Date	Expense Report End Date
RPT_CURR		String	Expense Report Currency Code
COMP_BALANCE_CC	Due by Company to CC	Decimal	Expense Report - Company Total Amount due to Credit Card for that specific expense line charge
COMP_BALANCE_EMP	Due by Company to Employee	Decimal	Expense Report - Company Total Amount due to Employee for that specific expense line charge
EMP_BALANCE_CC	Due by Employee to CC	Decimal	Expense Report - Employee Total Amount due to Credit Card for that specific expense line charge
EMP_BALANCE_COMP	Due by Employee to Company	Decimal	Expense Report - Employee Total Amount due to Company for that specific expense line charge
TOTAL_AMOUNT (R_TOTAL)	Total Amount in Report Currency	Decimal	Expense Report- Total Amount per line item that contains the attendees on the specific report.
REIMBURSE_ALCOHOL (R_ALC_B)	Business Alcohol Amount in Report Currency	Decimal	Expense Line - Reimbursable/ Business Amount for Alcohol to Employee
REIMBURSE_AMOUNT (R_TOTAL_B)	Total Business Amount in Report Currency	Decimal	Expense Line - Reimbursable/Business Amount
REIMBURSE_TAX (R_TAX1_B)	Business Tax1 Amount in Report Currency	Decimal	Expense Line - Reimbursable/Business Tax 1 Amount
REIMBURSE_TAX2 (R_TAX2_B)	Business Tax2Amount in Report Currency	Decimal	Expense Line - Reimbursable/Business Tax 2 Amount
REIMBURSE_TIP (R_TIP_B)	Business Tip Amount in Report Currency	Decimal	Expense Line - Reimbursable/Business Tip Amount
XP_CERT_STATUS	Certify Status	String	Certify Status by the user for the expense report. Certify Status: Require Certification Certified Already No Action (default)
REF_NUM	Reference Number	String	Expense Line Reference Number
MAIN_GROUP_TITLE	Credit Card Charge Description	String	Contains the itemized main group if there are itemized charges.
GROUP_TITLE	Line Description	String	Contains the default Expense Type name or the Credit Card Description charge.
EXP_TYPE	Expense Type ID	String	Expense Type ID Charge that contains attendees
EXP_TYPE_NAME	Expense Type	String	Expense Type Name Charge that contains attendees
GRP_EXP_ID	Expense Type Group ID	String	Expense Type Group ID for the charged Expense Type
GRP_EXP_NAME	Expense Type Group	String	Expense Type Group Name for the charge Expense Type
TRAVEL_DATE	Travel Date	Date	Expense Charge charge or travel date.
PAY_ID	Payment Type ID	String	Payment Type ID per the expense line
PAY_ID_NAME	Payment Type	String	Payment Type Name per the expense line
ENTERED_BY	Entered By ID	String	Expense Report Modified by Employee id
ENTERED_BY_NAME	Entered By Name	String	Expense Report Modified by Employee Full Name
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.
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
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
EMPLY_ID	Employee ID	String	Employee Id
EMPLY_TYPE	Employee Type ID	String	Employee Type ID
EMPLY_TYPE_NAME	Employee Type	String	Employee Type Name
DEPT_CODE	Home Department Code	String	Home Department Code
HOME_DEPT_NAME	Home Department	String	Home Department Name
OPT_ODE	Home Operating Unit Code	String	Home Operating Unit Code
HOME_OPT_NAME	Home Operating Unit	String	Home Operating Unit Name