ExpenseReportsExpenseExpenseAttendee
Lists attendees or participants for specific expense items, ensuring accurate reimbursements for group-related expenses.
Columns
| Name | Type | Description |
| ExpenseReportsExpenseReportId [KEY] | Long | Unique identifier for the expense report, used to track and reference each specific expense report within the system. |
| ExpenseExpenseId [KEY] | Long | Unique identifier for the expense record, used to reference a specific expense entry within an expense report. |
| Amount | Decimal | The total amount spent on the event attendee, typically representing the cost associated with the attendee's participation in the event. |
| AttendeeType | String | Indicates the type of event attendee. Possible values are 'EMPLOYEE' for company staff or 'NONEMPLOYEE' for external participants. |
| CreatedBy | String | Username of the individual who created the row, used for tracking data origin and accountability. |
| CreationDate | Datetime | Timestamp indicating the date and time when the row was created, providing a record of when the data was first entered into the system. |
| EmployeeFlag | Bool | Boolean value indicating whether the event attendee is an employee of the company (true) or not (false). |
| EmployerAddress | String | The address of the employer associated with the event attendee, typically used to verify the employment relationship for nonemployees. |
| EmployerName | String | The name of the employer associated with the event attendee, relevant for external participants and used in reporting. |
| EmployerPartyId | Long | Unique identifier for the employer party, used to reference the specific employer in relational data models. |
| ExpenseAttendeeId [KEY] | Long | Unique identifier for the event attendee, used to link each expense entry to a specific person attending the event. |
| ExpenseId | Long | Unique identifier for the expense item, used to link specific expenses to the broader expense report. |
| LastUpdateDate | Datetime | Timestamp indicating the last time the row was updated, critical for maintaining data freshness and tracking modifications. |
| LastUpdateLogin | String | Login ID of the user who last updated the row, used for tracking who made the most recent changes. |
| LastUpdatedBy | String | Username of the individual who last updated the row, useful for auditing and ensuring accountability in system changes. |
| Name | String | Full name of the event attendee, either employee or nonemployee, used for identifying the individual within the expense report. |
| TaxIdentifier | String | Tax identification number of the event attendee, required for tax reporting and to differentiate individuals for tax purposes. |
| Title | String | Title (for example, Mr., Mrs., Dr.) of the event attendee, typically used for formal documentation and reporting. |
| AttendeeEmail | String | Email address of the event attendee, enabling communication regarding the event and associated expenses. |
| AttendeePhoneNumber | String | Phone number of the event attendee, used for contacting the individual in relation to event details or expense questions. |
| BusinessUnit | String | The business unit within the organization to which the event attendee is associated, used for internal categorization and reporting. |
| ExpenseReportId | Long | Unique identifier for the expense report to which the expense record belongs, used to group expenses for processing. |
| Finder | String | A search term or identifier used to locate specific records or groupings of data within the system. |
| SysEffectiveDate | String | The system-defined effective date, used to track the point in time from which data or changes are valid. |
| CUReferenceNumber | Int | Reference number used to map child aggregates to parent tables, supporting hierarchical relationships in data. |
| EffectiveDate | Date | The date from which the data is considered effective, typically used in queries to filter records by their relevance to a specific start date. |