ODBC Driver for Oracle Fusion Cloud Financials

Build 25.0.9434

ExpenseAccommodationsPolicies

Defines accommodations-related expense rules, specifying reimbursement rates, limits, or eligibility for lodging costs.

Columns

Name Type Description
AccommodationsPolicyId [KEY] Long The unique identifier for the accommodation policy within the ExpenseAccommodationsPolicies table, used to reference a specific policy.
PolicyName String The name of the accommodation policy, which describes the general terms and conditions for expense accommodations.
Description String A detailed description of the accommodation policy, providing additional context or rules governing its application.
StatusCode String The code representing the current status of the accommodation policy, such as 'Active' or 'Inactive.'
Status String A textual representation of the accommodation policy's status, reflecting whether it is currently enabled or disabled.
CurrencyOptionCode String A code representing the chosen currency option for the accommodation policy, determining how currency is handled in related transactions.
CurrencyOption String A textual description of the currency option selected for the accommodation policy, such as 'Local' or 'Foreign.'
CurrencyCode String The code of the currency associated with the accommodation policy, typically using ISO 4217 standards (for example, USD).
Currency String The name of the currency used in the accommodation policy, such as USD or EUR.
EnabledSeasonRateFlag Bool A flag indicating whether season-specific rates are enabled for the accommodation policy. When true, season rates are applied.
EnabledRoleFlag Bool A flag that determines if role-based rules are applied within the accommodation policy. If true, different roles may have different accommodation rules.
PolicyRoleCode String A code representing the role-specific rules within the accommodation policy, defining which roles are eligible for specific accommodations.
PolicyRole String A description of the role within the accommodation policy, such as 'Manager' or 'Employee,' which may influence the applicability of the policy.
EnabledLocationFlag Bool A flag indicating whether the accommodation policy is location-specific. If true, the policy applies only to specific locations.
LocationTypeCode String A code identifying the type of location where the accommodation policy is applicable, such as 'Office' or 'Conference Room.'
LocationType String The type of location to which the accommodation policy applies, providing more details about where it is enforced.
ZoneTypeCode String A code representing the type of zone, such as 'Domestic' or 'International,' that is relevant to the accommodation policy.
ZoneType String A textual description of the zone type, categorizing the geographic or operational zones where the accommodation policy is enforced.
PolicyEnforcementCode String A code indicating how the accommodation policy is enforced, such as 'Strict' or 'Flexible,' defining the policy's enforcement rigor.
PolicyEnforcement String A description of how the accommodation policy is enforced, providing more details about the level of compliance expected.
PolicyViolationFlag Bool A flag that indicates whether violations of the accommodation policy are flagged. If true, violations trigger alerts or actions.
WarningTolerance Decimal The threshold for warning users about potential violations of the accommodation policy, expressed as a decimal percentage.
DispWarningToUserFlag Bool A flag indicating whether warnings about policy violations should be displayed to the user during processing.
PreventSubmissionFlag Bool A flag that, when set to true, prevents the submission of a request if it violates the accommodation policy.
ErrorTolerance Decimal The allowable error tolerance for policy violations, specified as a decimal percentage before enforcement actions are triggered.
CreationDate Datetime The date and time when the accommodation policy was created, used for tracking the policy's history.
CreatedBy String The name or identifier of the user who created the accommodation policy, helping track ownership and responsibility.
LastUpdateDate Datetime The date and time when the accommodation policy was last updated, providing insight into the policy's current state.
LastUpdatedBy String The name or identifier of the user who last updated the accommodation policy, helping track who modified the policy.
LastUpdateLogin String The login ID of the user who last updated the accommodation policy, assisting with audit and tracking of changes.
EnabledGenderFlag Bool A flag that indicates whether the accommodation policy includes gender-based rules or allowances. If true, gender-based settings are considered.
Finder String A specific identifier or code used to search for or locate accommodation policies within the system, assisting with query and retrieval.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434