ExpensesExpenseAttendee
Tracks the individuals associated with an expense, capturing data such as names and roles for cost-sharing analysis.
Columns
| Name | Type | Description |
| ExpensesExpenseId [KEY] | Long | Unique identifier for the expense record, used to track and reference individual expenses in the system. |
| Amount | Decimal | Total amount spent on the event attendee, representing the cost allocated to the individual for event-related expenses. |
| AttendeeType | String | Defines the type of attendee for the event. Possible values are EMPLOYEE for internal staff and NONEMPLOYEE for external individuals. |
| CreatedBy | String | Username of the user who initially created the expense record, providing accountability for record creation. |
| CreationDate | Datetime | Timestamp indicating when the expense record was created, allowing for accurate tracking of the entry's creation time. |
| EmployeeFlag | Bool | Flag indicating whether the event attendee is an employee, differentiating between internal and external participants. |
| EmployerAddress | String | Address of the employer for the event attendee, typically used for tax purposes and documentation of external attendees. |
| EmployerName | String | Name of the employer for the event attendee, used to identify the organization employing the attendee. |
| EmployerPartyId | Long | Unique identifier for the employer associated with the event attendee, linking the individual to their organization. |
| ExpenseAttendeeId [KEY] | Long | Unique identifier for the event attendee, used to track and reference each individual in the expense records. |
| ExpenseId | Long | Unique identifier for the specific expense item, used to link the attendee's expense to the overall expense report. |
| LastUpdateDate | Datetime | Timestamp of the most recent update to the expense record, used for tracking modifications and ensuring data accuracy. |
| LastUpdateLogin | String | Login session associated with the user who last updated the expense record, allowing for accountability in updates. |
| LastUpdatedBy | String | Username of the user who last modified the expense record, providing traceability for changes made to the data. |
| Name | String | Full name of the employee or nonemployee event attendee, used for identifying and referencing the individual in the system. |
| TaxIdentifier | String | Tax Indentification Number (TIN) for the event attendee, either for employees or nonemployees, required for tax and legal purposes. |
| Title | String | Honorific or title of the event attendee, such as Mr., Mrs., or Dr., used for formal identification. |
| AttendeeEmail | String | Email address of the event attendee, used for communication and notifications regarding the event or expenses. |
| AttendeePhoneNumber | String | Phone number of the event attendee, used for contacting the attendee as needed. |
| Finder | String | Search term or identifier used for locating and displaying specific records in the database or reporting system. |
| PersonId | String | Unique identifier assigned to the person associated with the expense, linking the expense to the individual. |
| Request | String | Request identifier associated with the expense, often used to track the process or approval of the expense submission. |
| SysEffectiveDate | String | System-defined effective date, indicating when the record becomes valid and applicable within the system for processing. |
| CUReferenceNumber | Int | Reference number used to map child aggregates to parent tables, maintaining relational integrity in the data structure. |
| EffectiveDate | Date | Date parameter used to fetch resources that are effective as of a specified date, ensuring data is accurate as of a given time. |