Overbooking logic table

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: 

KSMCL5indicates 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
KSMCLfixed entry
7

Logic number (cannot repeat number, must be a new)

/Separator
NIndicator 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
KSMCLFixed Command
0

Days from

1Days to
0Indicator 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

7logic's item number
*Hindicator 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:

Xcancel data
AAdd data
R

Received from

 

 

Related pages