[Home] [Help] [Dependency Information]
Object Name: | AP_POL_LINES |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_POL_LINES |
Subobject Name: | |
Status: | VALID |
AP_POL_HEADERS is a Policy Compliance-specific table that contains line level information for a policy schedule. The data in this table is used on the expense report validation to determine whether the report violates a company policy. Rows in this table are automatically generated based on the rules defined for a policy schedule in the table AP_POL_SCHEDULE_OPTIONS. The primary key for this table is POLICY_LINE_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_POL_LINES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | POLICY_LINE_ID |
AP_POL_LINES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | POLICY_ID |
AP_POL_LINES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SCHEDULE_PERIOD_ID |
AP_POL_LINES_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
POLICY_ID
SCHEDULE_PERIOD_ID LOCATION_ID START_OF_SEASON END_OF_SEASON EFFECTIVE_START_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POLICY_LINE_ID | NUMBER | (15) | Yes | Policy schedule line unique identifier. |
POLICY_ID | NUMBER | (15) | Yes | Policy schedule identifier |
SCHEDULE_PERIOD_ID | NUMBER | (15) | Yes | Policy schedule period identifier. |
STATUS | VARCHAR2 | (30) | Status of the policy schedule line. | |
ROLE_ID | NUMBER | (15) | Employee role identifier, can be a link to job, grade, or position. | |
LOCATION_ID | NUMBER | (15) | Location identifier. | |
CURRENCY_CODE | VARCHAR2 | (15) | Policy schedule currency. | |
MEAL_LIMIT | NUMBER | Limit per meal. | ||
RATE | NUMBER | Daily limit. | ||
TOLERANCE | NUMBER | Tolerance for the amounts. | ||
TICKET_CLASS_DOMESTIC | VARCHAR2 | (30) | Airfare domestic ticket class. | |
TICKET_CLASS_INTERNATIONAL | VARCHAR2 | (30) | Airfare international ticket class. | |
VEHICLE_CATEGORY | VARCHAR2 | (30) | Vehicle category. | |
VEHICLE_TYPE | VARCHAR2 | (30) | Vehicle type. | |
FUEL_TYPE | VARCHAR2 | (30) | Fuel type. | |
RANGE_LOW | NUMBER | Threshold low range. | ||
RANGE_HIGH | NUMBER | Threshold high range. | ||
CALCULATION_METHOD | VARCHAR2 | (30) | Calculation method used with the rates. | |
MEALS_DEDUCTION | NUMBER | Meal deduction rate. | ||
BREAKFAST_DEDUCTION | NUMBER | Breakfast deduction rate. | ||
LUNCH_DEDUCTION | NUMBER | Lunch deduction rate. | ||
DINNER_DEDUCTION | NUMBER | Dinner deduction rate. | ||
ACCOMMODATION_ADJUSTMENT | NUMBER | Accommodation deduction rate. | ||
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). |
PARENT_LINE_ID | NUMBER | (15) | Contains policy Id of current modified state of active policy | |
ADDON_MILEAGE_RATE_CODE | VARCHAR2 | (30) | Indicates the additional mileage rate option; example TRAILER, DIRT ROAD. | |
RATE_PER_PASSENGER | NUMBER | This column stores the rate per passenger | ||
RATE_TYPE_CODE | VARCHAR2 | (30) | Indicates if the rate is a standard, first day rate, last day rate, nightly rate | |
ONE_MEAL_DEDUCTION_AMT | NUMBER | Stores the meals deduction amount for single free meal | ||
TWO_MEALS_DEDUCTION_AMT | NUMBER | Stores the meals deduction amount for two free meals | ||
THREE_MEALS_DEDUCTION_AMT | NUMBER | Stores the meals deduction amount for three free meals | ||
NIGHT_RATE_TYPE_CODE | VARCHAR2 | (30) | Stores the night rate type in case of multiple night rates implementation | |
ACCOMMODATION_CALC_METHOD | VARCHAR2 | (30) | Stores the calculation method for accommodations deduction/addition | |
START_OF_SEASON | VARCHAR2 | (5) | Start of Season | |
END_OF_SEASON | VARCHAR2 | (5) | End of Season | |
MAX_LODGING_AMT | NUMBER | Lodging | ||
NO_GOVT_MEALS_AMT | NUMBER | Government Meals | ||
PROP_MEALS_AMT | NUMBER | Proportional Meals | ||
OFF_BASE_INC_AMT | NUMBER | Off Base Incidentals | ||
FOOTNOTE_AMT | NUMBER | Footnote | ||
FOOTNOTE_RATE_AMT | NUMBER | Footnote Rate | ||
MAX_PER_DIEM_AMT | NUMBER | Max Per Diem | ||
EFFECTIVE_START_DATE | DATE | Effective Start Date | ||
EFFECTIVE_END_DATE | DATE | Effective End Date |
Cut, paste (and edit) the following text to query this object:
SELECT POLICY_LINE_ID
, POLICY_ID
, SCHEDULE_PERIOD_ID
, STATUS
, ROLE_ID
, LOCATION_ID
, CURRENCY_CODE
, MEAL_LIMIT
, RATE
, TOLERANCE
, TICKET_CLASS_DOMESTIC
, TICKET_CLASS_INTERNATIONAL
, VEHICLE_CATEGORY
, VEHICLE_TYPE
, FUEL_TYPE
, RANGE_LOW
, RANGE_HIGH
, CALCULATION_METHOD
, MEALS_DEDUCTION
, BREAKFAST_DEDUCTION
, LUNCH_DEDUCTION
, DINNER_DEDUCTION
, ACCOMMODATION_ADJUSTMENT
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PARENT_LINE_ID
, ADDON_MILEAGE_RATE_CODE
, RATE_PER_PASSENGER
, RATE_TYPE_CODE
, ONE_MEAL_DEDUCTION_AMT
, TWO_MEALS_DEDUCTION_AMT
, THREE_MEALS_DEDUCTION_AMT
, NIGHT_RATE_TYPE_CODE
, ACCOMMODATION_CALC_METHOD
, START_OF_SEASON
, END_OF_SEASON
, MAX_LODGING_AMT
, NO_GOVT_MEALS_AMT
, PROP_MEALS_AMT
, OFF_BASE_INC_AMT
, FOOTNOTE_AMT
, FOOTNOTE_RATE_AMT
, MAX_PER_DIEM_AMT
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
FROM AP.AP_POL_LINES;
AP.AP_POL_LINES does not reference any database object
AP.AP_POL_LINES is referenced by following:
|
|
|