eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AP.AP_POL_HEADERS

Object Details

Object Name:	AP_POL_HEADERS
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_POL_HEADERS
Subobject Name:
Status:	VALID

AP_POL_HEADERS is a Policy Compliance-specific table that contains header information for a policy schedule. The data in this table controls which rules are used to generate the policy lines. The primary key for this table is POLICY_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_POL_HEADERS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	POLICY_ID
AP_POL_HEADERS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CATEGORY_CODE POLICY_ID
AP_POL_HEADERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	END_DATE
AP_POL_HEADERS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	POLICY_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
POLICY_ID	NUMBER	(15)	Yes	Policy schedule unique identifier.
CATEGORY_CODE	VARCHAR2	(30)	Yes	Category associated with the policy schedule.
POLICY_NAME	VARCHAR2	(60)	Yes	Policy schedule name.
DESCRIPTION	VARCHAR2	(240)		Policy schedule description.
CURRENCY_CODE	VARCHAR2	(15)		Policy schedule currency.
BUSINESS_GROUP_ID	NUMBER	(15)		Business group identifier that associates an employee role to a business group.
JOB_GROUP_ID	NUMBER	(15)		Job group identifier that associates an employee role to a job group.
ROLE_CODE	VARCHAR2	(30)		Identifies employee role type.
DISTANCE_UOM	VARCHAR2	(30)		Distance unit used for the policy schedule.
CURRENCY_PREFERENCE	VARCHAR2	(30)		Currency preference used to control which policy schedule rules are used.
ALLOW_RATE_CONVERSION_CODE	VARCHAR2	(30)		Determines whether rate conversion is allowed.
DAILY_LIMITS_CODE	VARCHAR2	(30)		Determines whether meal rates are defined based on individual meal, daily sum, or both.
START_DATE	DATE			Start Date for the policy schedule.
END_DATE	DATE			End Date for the policy schedule.
DISTANCE_THRESHOLDS_FLAG	VARCHAR2	(1)		Determines whether a distance threshold is used on the policy schedule.
VEHICLE_CATEGORY_FLAG	VARCHAR2	(1)		Determines whether a vehicle category is used on the policy schedule.
VEHICLE_TYPE_FLAG	VARCHAR2	(1)		Determines whether a vehicle type is used on the policy schedule.
FUEL_TYPE_FLAG	VARCHAR2	(1)		Determines whether a fuel type is used on the policy schedule.
PASSENGERS_FLAG	VARCHAR2	(1)		Determines whether rate per passenger is used on the policy schedule.
EMPLOYEE_ROLE_FLAG	VARCHAR2	(1)		Determines whether an employee role is used on the policy schedule.
TIME_BASED_ENTRY_FLAG	VARCHAR2	(1)		Determines whether a time threshold is used on the policy schedule.
FREE_MEALS_FLAG	VARCHAR2	(1)		Determines whether a free meal is used on the policy schedule.
FREE_ACCOMMODATIONS_FLAG	VARCHAR2	(1)		Determines whether a free accommodation is used on the policy schedule.
TOLERANCE_LIMITS_FLAG	VARCHAR2	(1)		Determines whether tolerance limits are used on the policy schedule.
DAILY_LIMITS_FLAG	VARCHAR2	(1)		Determines whether a daily limit is used on the policy schedule.
LOCATION_FLAG	VARCHAR2	(1)		Determines whether a location is used on the policy schedule.
TOLERANCE_LIMIT_CODE	VARCHAR2	(30)		Determines whether tolerance limits are defined for specific lines or for the entire schedule.
FREE_MEALS_CODE	VARCHAR2	(30)		Determines whether free meal is defined for a specific meal or as a daily sum.
FREE_ACCOMMODATIONS_CODE	VARCHAR2	(30)		Determines whether free accommodation is defined as a deduction or an addition.
DAY_PERIOD_CODE	VARCHAR2	(30)		Determines how a day is defined for a policy schedule.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ADDON_MILEAGE_RATES_FLAG	VARCHAR2	(1)		Indicates if additional mileage rate options has been enabled
SCHEDULE_TYPE_CODE	VARCHAR2	(30)		Flag to indicate if a policy is an allowance (ALLOWANCE) or a per diem (PER_DIEM)
MIN_TRIP_DURATION	NUMBER			Minimum trip duration for per diem eligibility in hours
SAME_DAY_RATE_CODE	VARCHAR2	(30)		Indicates if same day rates have been defined or implements no reimbursement
NIGHT_RATES_CODE	VARCHAR2	(30)		Indicates if night rates have been enabled for the policy
NIGHT_RATE_ELIGIBILITY	NUMBER			Minimum night period required in hours for night rate eligibility
NIGHT_RATE_START_TIME	NUMBER			Stores the night rate eligibility start time in minutes.
NIGHT_RATE_END_TIME	NUMBER			Stores the night rate eligibility end time in minutes.
MULTI_DEST_RULE_CODE	VARCHAR2	(30)		Indicates the reimbursement rule when multiple destinations is enabled
MULTI_DEST_START_TIME	NUMBER			Start time in minutes used to determine the location of longest stay for multiple destinations
MULTI_DEST_END_TIME	NUMBER			End time in minutes used to determine the location of longest stay for multiple destinations
RATE_PERIOD_TYPE_CODE	VARCHAR2	(30)		Indicates if schedule implements standards rate periods or standard, first and last periods
SOURCE	VARCHAR2	(30)		Indicates if the schedule was based on CONUS/OCONUS upload or manual
PER_DIEM_TYPE_CODE	VARCHAR2	(30)		Indicates the type of expenses (meals/accommodations/others) that the per diem rate covers
MEALS_TYPE_CODE	VARCHAR2	(30)		Indicates the type of meals rate (local meals/proportional meals) that the meals schedule covers
ALLOWANCE_TIME_RULE_CODE	VARCHAR2	(30)		Indicates the time period rule used to determine allowance eligibility.
BREAKFAST_START_TIME	NUMBER	(15)		Start time in minutes used to determine eligibility for breakfast allowance.
BREAKFAST_END_TIME	NUMBER	(15)		End time in minutes used to determine eligibility for breakfast allowance.
LUNCH_START_TIME	NUMBER	(15)		Start time in minutes used to determine eligibility for lunch allowance.
LUNCH_END_TIME	NUMBER	(15)		End time in minutes used to determine eligibility for lunch allowance.
DINNER_START_TIME	NUMBER	(15)		Start time in minutes used to determine eligibility for dinner allowance.
DINNER_END_TIME	NUMBER	(15)		End time in minutes used to determine eligibility for dinner allowance.
USE_MAX_DEST_RATE_FLAG	VARCHAR2	(1)		Use the highest rate, when equal time spent in more than one location.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT POLICY_ID
,      CATEGORY_CODE
,      POLICY_NAME
,      DESCRIPTION
,      CURRENCY_CODE
,      BUSINESS_GROUP_ID
,      JOB_GROUP_ID
,      ROLE_CODE
,      DISTANCE_UOM
,      CURRENCY_PREFERENCE
,      ALLOW_RATE_CONVERSION_CODE
,      DAILY_LIMITS_CODE
,      START_DATE
,      END_DATE
,      DISTANCE_THRESHOLDS_FLAG
,      VEHICLE_CATEGORY_FLAG
,      VEHICLE_TYPE_FLAG
,      FUEL_TYPE_FLAG
,      PASSENGERS_FLAG
,      EMPLOYEE_ROLE_FLAG
,      TIME_BASED_ENTRY_FLAG
,      FREE_MEALS_FLAG
,      FREE_ACCOMMODATIONS_FLAG
,      TOLERANCE_LIMITS_FLAG
,      DAILY_LIMITS_FLAG
,      LOCATION_FLAG
,      TOLERANCE_LIMIT_CODE
,      FREE_MEALS_CODE
,      FREE_ACCOMMODATIONS_CODE
,      DAY_PERIOD_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ADDON_MILEAGE_RATES_FLAG
,      SCHEDULE_TYPE_CODE
,      MIN_TRIP_DURATION
,      SAME_DAY_RATE_CODE
,      NIGHT_RATES_CODE
,      NIGHT_RATE_ELIGIBILITY
,      NIGHT_RATE_START_TIME
,      NIGHT_RATE_END_TIME
,      MULTI_DEST_RULE_CODE
,      MULTI_DEST_START_TIME
,      MULTI_DEST_END_TIME
,      RATE_PERIOD_TYPE_CODE
,      SOURCE
,      PER_DIEM_TYPE_CODE
,      MEALS_TYPE_CODE
,      ALLOWANCE_TIME_RULE_CODE
,      BREAKFAST_START_TIME
,      BREAKFAST_END_TIME
,      LUNCH_START_TIME
,      LUNCH_END_TIME
,      DINNER_START_TIME
,      DINNER_END_TIME
,      USE_MAX_DEST_RATE_FLAG
FROM AP.AP_POL_HEADERS;

Dependencies

[top of page]

AP.AP_POL_HEADERS does not reference any database object

AP.AP_POL_HEADERS is referenced by following:

APPS: AP_POL_HEADERS