[Home] [Help] [Dependency Information]
Object Name: | AP_POL_SCHEDULE_OPTIONS |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_POL_SCHEDULE_OPTIONS |
Subobject Name: | |
Status: | VALID |
AP_POL_SCHEDULE_OPTIONS is a Policy Compliance-specific table that contains policy schedule-specific rules. The data in this table controls what data is generated for the policy schedule lines. The data that the user defines on this table depends on the rules defined on the AP_POL_HEADER table. The primary key for this table is SCHEDULE_OPTION_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_POL_SCHEDULE_OPTIONS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SCHEDULE_OPTION_ID |
AP_POL_SCHEDULE_OPTIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
POLICY_ID
LOCATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEDULE_OPTION_ID | NUMBER | (15) | Yes | Policy schedule option unique identifier. |
POLICY_ID | NUMBER | (15) | Yes | Policy schedule identifier. |
OPTION_TYPE | VARCHAR2 | (30) | Option type. | |
OPTION_CODE | VARCHAR2 | (30) | Option code. | |
THRESHOLD | NUMBER | Threshold for the option. | ||
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 option currency. | |
END_DATE | DATE | End Date for the policy schedule option. | ||
VEHICLE_TYPE_CODE | VARCHAR2 | (30) | Lookup code to indicate whether vehicle type is required when vehicle category is used. | |
FUEL_TYPE_CODE | VARCHAR2 | (30) | Lookup code to indicate whether fuel type is required when vehicle category is used. | |
STATUS | VARCHAR2 | (30) | Status of the policy schedule option. | |
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). |
RATE_TYPE_CODE | VARCHAR2 | (30) | Indicates if the rate is a standard, first day rate, last day rate. |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEDULE_OPTION_ID
, POLICY_ID
, OPTION_TYPE
, OPTION_CODE
, THRESHOLD
, ROLE_ID
, LOCATION_ID
, CURRENCY_CODE
, END_DATE
, VEHICLE_TYPE_CODE
, FUEL_TYPE_CODE
, STATUS
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, RATE_TYPE_CODE
FROM AP.AP_POL_SCHEDULE_OPTIONS;
AP.AP_POL_SCHEDULE_OPTIONS does not reference any database object
AP.AP_POL_SCHEDULE_OPTIONS is referenced by following:
|
|
|