Overbooking logic table
- lmauro@kiusys.com (Deactivated)
- Pablo Cappelletto (Deactivated)
To manage the overbooking logic, tables are created to later be applied to flights.
System administrator should customize the tables according the the carrier´s intent.
The following entry displays the overbooking logic:
KSMCL
Response:
 NLogic Sub 1 6 2 4 3 3 4 1 5 6 6 5
Â
The column NLogic indicates the table number, the table Sub indicates the amount of sub-index or divisions each table has.
Re-display the table by entering:Â
Â
 KSMCL*
Â
To display each item from the table entry is:Â
KSMCL5 | indicates the entry of the logic number (NLogic) |
---|
Â
Response:
KSMCL5 NLogic: 5 From to Formula % 0 7 5 Y 8 15 12 Y 16 31 15 Y 32 90 25 Y 91 200 50 Y 201 330 80 Y Â
Description:
From column indicates the first day starting with the departure of the flight
To column indicates the days left before flight departure.
Formula column  indicates the overbooking percentage appliedÂ
% column indicates if overbooking applies by percentage or by seats
 When indicator Y is present overbooking applies by percentage. When indicator N is present overbooking by of seats amount apply.Â
Â
For instance, logic #5 says, from departure day until 7 days before flight departure a 5% of over sale will apply.
Then, since 8 days before departure, until 15Â days before flight departure a 12 % off over sale will apply and so on.
Â
Â
Â
Â
Create a logicÂ
Use the following entry to create a new logicÂ
KSMCL7/N
KSMCL | fixed entry |
---|---|
7 | Logic number (cannot repeat number, must be a new) |
/ | Separator |
N | Indicator for New |
Â
Response
KSMCL7/N NLogic : 7 Desde Hasta Formula % ... 0 330 0 Y ...NEW RECORD
Â
By default table starts from 0 to 330 (330 is the maximum days ahead on the system), formula is 0 and % is 0. Consider this is a new item.
 Use the following entry to create the logic itemsÂ
KSMCL/0/1/0/Y
KSMCL | Fixed Command |
---|---|
0 | Days from |
1 | Days to |
0 | Indicator for formula |
Y | Percentage (Y = Yes, N = No) |
Slash is a separator between each indicatorÂ
Response:
KSMCL/0/1/0/Y NLogic : 7 Desde Hasta Formula % ... 0 1 0 Y ...NEW RECORD ... 2 330 0 Y ...NEW RECORD
Â
ExampleÂ
KSMCL/2/7/10/N
Response:
KSMCL/2/7/10/N NLogic : 7 Desde Hasta Formula % ... 0 1 0 Y ...NEW RECORD ... 2 7 10 N ...NEW RECORD ... 8 330 0 Y ...NEW RECORD
Thus, successively, continue to load all necessary items, once process is completed process, save the new table by using the following entry:
KSMCL/S
Response:
OK. ALL DATA SAVE
Â
Modify pre-existent logic
In order to modify a pre-existent table, first use the following entry to display the table:
KSMCL{Número de lógica}
Â
Once displayed, apply changes by use the same entries as for create new logic.
Ejemplo:
Â
KSMCL7 NLogic : 7 Desde Hasta Formula % 0 1 0 Y 2 7 10 N 8 330 0 Y KSMCL/8/21/10/Y NLogic : 7 Desde Hasta Formula % 0 1 0 Y 2 7 10 N ... 8 21 10 Y ...NEW RECORD ... 22 330 0 Y ...NEW RECORD
Once all changes are done save the transaction by using the following entry
KSMCL/S
Respuesta:
OK. ALL DATA SAVE
Once the data is saved, all the records that have been affected by the change are automatically updated.
Â
Ignore changes
To ignore changes, or actions while creating a new item by:Â
KSMCL/I
Response:Â
ALL DATA IGNORED
Â
Â
Â
Logic HistoryÂ
Display the history of all edits done to a logic using the following entry:
KSMCL7*H
KSMCL | Fixed entry |
---|---|
7 | logic's item number |
*H | indicator for history |
Â
It is also possible to recover a logic that has already been displayed by entering KSMCL7, then enter KSMCL*H without specifying an item number as it has already been displayedÂ
Example:Â
KSMCL7*H -- HISTORY OF LOGIC #7 -- X 0/1/0/Y A 0/1/5/Y R BUE.BUEXX-MM 1544/23MAR04 X 0/1/5/Y A 0/1/6/Y R BUE.BUEXX-MM 1552/23MAR04
Description:
X | cancel data |
---|---|
A | Add data |
R | Received from |
Â
Â