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.

[Home] [Help]

VIEW: AP.AP_POL_SCHEDULE_PERIODS#

Source

View Text - Preformatted


select SCHEDULE_PERIOD_ID SCHEDULE_PERIOD_ID, POLICY_ID POLICY_ID, SCHEDULE_PERIOD_NAME SCHEDULE_PERIOD_NAME, START_DATE START_DATE, END_DATE END_DATE, RATE_PER_PASSENGER RATE_PER_PASSENGER, MIN_DAYS MIN_DAYS, TOLERANCE TOLERANCE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, MIN_RATE_PER_PERIOD MIN_RATE_PER_PERIOD, MAX_BREAKFAST_DEDUCTION_AMT MAX_BREAKFAST_DEDUCTION_AMT, MAX_LUNCH_DEDUCTION_AMT MAX_LUNCH_DEDUCTION_AMT, MAX_DINNER_DEDUCTION_AMT MAX_DINNER_DEDUCTION_AMT, FIRST_DAY_RATE FIRST_DAY_RATE, LAST_DAY_RATE LAST_DAY_RATE, REIMBURSEMENT_PERCENTAGE REIMBURSEMENT_PERCENTAGE from "AP"."AP_POL_SCHEDULE_PERIODS"

View Text - HTML Formatted

SELECT SCHEDULE_PERIOD_ID SCHEDULE_PERIOD_ID
, POLICY_ID POLICY_ID
, SCHEDULE_PERIOD_NAME SCHEDULE_PERIOD_NAME
, START_DATE START_DATE
, END_DATE END_DATE
, RATE_PER_PASSENGER RATE_PER_PASSENGER
, MIN_DAYS MIN_DAYS
, TOLERANCE TOLERANCE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, MIN_RATE_PER_PERIOD MIN_RATE_PER_PERIOD
, MAX_BREAKFAST_DEDUCTION_AMT MAX_BREAKFAST_DEDUCTION_AMT
, MAX_LUNCH_DEDUCTION_AMT MAX_LUNCH_DEDUCTION_AMT
, MAX_DINNER_DEDUCTION_AMT MAX_DINNER_DEDUCTION_AMT
, FIRST_DAY_RATE FIRST_DAY_RATE
, LAST_DAY_RATE LAST_DAY_RATE
, REIMBURSEMENT_PERCENTAGE REIMBURSEMENT_PERCENTAGE
FROM "AP"."AP_POL_SCHEDULE_PERIODS"