Documentation

Calculate occupancy supplements and discounts

Once we have the base price and the board supplement or discount applied, then we have to process the occupancy supplements and discounts informed at CNSU structure. 

There are three different types:

1.   Child supplement or discount

Determine the final type of pax for the service

2.  Infant supplement or discount

Applied only for passengers with a lower age than specified in Minimum child age in the contract

3.   Additional bed

Applied only for the passenger exceeding the standard capacity

4.   Room for single use

Applied only for passengers not exceeding the standard capacity

 

General restrictions:

  • The [CNSU.Is per pax] value is always true
  • One passenger can only have one record to apply
  • The [CNSU.Order] is not relevant due to are the first in the application order
  • The [CNSU.Is cumulative] is not relevant, will be always false

The price calculated after this process will be the base price on which apply the rest of the supplements and discounts. 

(*) For calculating the final price using the new pricing structure, match the fields: Net price, Price and Amount on CNCT and CNSU structure 


Child supplement or discount

A child supplement or discount is defined when the [CNSU.Type] value is N

At this stage we will obtain the passenger type: adult, child or infant, depending on the contract information. 

A passenger is considered an infant when his age is younger than [CCON.Minimum child age]. 

Also when you cannot apply a child supplement or discount but only because of the age rules does not applies due to the passenger age is younger than the minimum age in the child supplement or discount record and there is no more record for this passenger age.

An infant will not be considered in the valuation process and the price is 0. 

A passenger is considered a child pax when a child supplement or discount applies. It is very common child discounts of 100% from 0 to 2 years old. Then, a 1 years old pax will be considered a child pax with price 0, but not an infant. 

A passenger is considered an adult pax when is not an infant or child. 

You have to process record by record and check if it applies for all the days and passenger. As the child supplement or discount is the first you have to apply the order is not relevant. 

The validation record check is:

  • Dates
  • Rate
  • Room type
  • Room characteristic
  • Board
  • Passenger’s age
  • Operation days 

If more than one record is valid, then the filtering order is:

  1. Rate
  2. Room type
  3. Room characteristic
  4. Board 

The child supplement and discount has two more fields that we have to validate:

  • Order [CNSU.Pax order]: The child order. It could appear different supplements or discounts for the first child and the second one in the same booking.
  • Adults [CNSU.Adults]: The minimum adults that may have in the booking in order to apply the record. 

(*) For calculating the final price using the new pricing structure, match the fields: Net price, Price and Amount on CNCT and CNSU structure. 

Example:

Child supplements and discount records for a contract where:

  • [CCON.Minimum child age] value is 0

 

#

Pax order

Adults

Minimum-maximum age

Percentage

A

1

2

0-2

100%

B

1

2

3-12

100%

C

2

2

0-2

100%

D

2

2

3-12

50%

 

Availability

Pax

Age

Supplement or Discount

Order

Description

2 AD

AD

30

-

 

There is no pax with child supplement/discount

AD

30

-

 

1AD + 1CH

AD

30

-

 

There is not enough adults to apply the child supplement/discount

CH

2

-

 

2AD + 1CH

AD

30

-

 

The A child supplement/discount applies

AD

30

-

 

CH

2

A

1

2AD + 1CH

AD

30

-

 

The B child supplement/discount applies

AD

30

-

 

CH

8

B

1

1AD + 2CH

AD

30

-

 

The A child supplement/discount applies. There is enough adults because one requested child is considered adult

CH

2

A

1

AD

8

-

 

2AD + 2CH

AD

30

-

 

The A child supplement/discount applies for the first child.

The D child supplement/discount applies for the second child

AD

30

-

 

CH

2

A

1

CH

8

D

2

1AD + 3CH

AD

30

-

 

The B child supplement/discount applies for the first child.

The C child supplement/discount applies for the second child. There is enough adults because one requested child is considered adult

CH

8

B

1

CH

8

D

2

AD

8

-

 

2AD + 3CH

AD

30

-

 

The B child supplement/discount applies for the first child.

The D child supplement/discount applies for the second child.

No more child supplement/discount applies because there is no more Pax Order informed.

AD

30

-

 

CH

8

B

1

CH

8

D

2

AD

8

-

 

Child supplement/discount valuation example

 

The children must be ordered by age in order to apply Children supplements and discounts.

If you have 2 AD + 3CH with 2, 3 and 7 years old, then you must apply de Children supplements in the following order:

2 years old

3 years old

7 years old 

Example:

Child supplements and discount records for a contract where:

  • [CCON.Minimum child age] value is 3 

#

Pax order

Adults

Minimum-maximum age

Percentage

A

1

2

3-12

100%

B

2

2

3-12

50%

 

Availability

Pax

Age

Supplement or Discount

Order

Description

2 AD

AD

30

-

 

There is no pax with child supplement/discount

AD

30

-

 

1AD + 1CH

AD

30

-

 

There are not enough adults to apply the child supplement/discount. The child is considered infant because is younger than 3

INF

2

-

 

2AD + 1CH

AD

30

-

 

There is no pax with child supplement/discount. The child is considered infant because is younger than 3

AD

30

-

 

INF

2

-

 

2AD + 1CH

AD

30

-

 

The A child supplement/discount applies

AD

30

-

 

CH

8

A

1

1AD + 2CH

AD

30

-

 

There are not enough adults to apply the child supplement/discount. The child is considered infant because is younger than 3

INF

2

-

 

AD

8

-

 

2AD + 2CH

AD

30

-

 

The A child supplement/discount applies for the second child. The first child is considered infant because is younger than 3

AD

30

-

 

INF

2

-

 

CH

8

A

1

1AD + 3CH

AD

30

-

 

The A child supplement/discount applies for the first child.

The B child supplement/discount applies for the second child.

There are enough adults due to the third child is considered adult.

CH

8

A

1

CH

8

B

2

AD

8

-

 

2AD + 3CH

AD

30

-

 

The A child supplement/discount applies for the first child.

The B child supplement/discount applies for the second child.

No more child supplement/discount applies because there is no more Pax Order informed.

AD

30

-

 

CH

8

A

1

CH

8

B

2

AD

8

-

 

Child supplement/discount valuation example 

 

Example:

Child supplements and discount records for a contract where:

  • [CCON.Minimum child age] value is 0

 

#

Pax order

Adults

Minimum-maximum age

Percentage

A

1

2

3-12

100%

B

2

2

3-12

50%

 

Availability

Pax

Age

Supplement or Discount

Order

Description

2 AD

AD

30

-

 

There is no pax with child supplement/discount

AD

30

-

 

1AD + 1CH

AD

30

-

 

There are not enough adults to apply the child supplement/discount. The child is considered infant because there is no record to apply

AD

2

-

 

2AD + 1CH

AD

30

-

 

The child is considered as price 0 because there are child supplement/discount which not applies due to the passenger ages is younger

AD

30

-

 

CH

2

-

1

2AD + 1CH

AD

30

-

 

The A child supplement/discount applies

AD

30

-

 

CH

8

A

1

1AD + 2CH

AD

30

-

 

The child is considered as price 0 because there are child supplement/discount which not applies due to the passenger ages is younger

CH

2

-

1

AD

8

-

 

2AD + 2CH

AD

30

-

 

The child is considered as price 0 because there are child supplement/discount which not applies due to the passenger ages is younger.

The B child supplement/discount applies for the second pax with order 2

AD

30

-

 

CH

2

-

1

CH

8

B

2

1AD + 3CH

AD

30

-

 

The A child supplement/discount applies for the first pax.

The B child supplement/discount applies for the second pax

CH

8

A

1

CH

8

B

2

AD

8

-

 

2AD + 3CH

AD

30

-

 

The A child supplement/discount applies for the first pax.

The B child supplement/discount applies for the second pax.

No more child supplement/discount applies because there is no more Pax Order informed.

AD

30

-

 

CH

8

A

1

CH

8

B

2

AD

8

-

 

Child supplement/discount valuation example 

 

Once you have the record to apply, the price calculation is detailed in the next section. 

Infant supplement or discount

An infant supplement or discount is defined when the [CNSU.Type] value is F

Remember that a passenger is considered an infant when his age is younger than [CCON.Minimum child age]. 

All the infant supplements or discounts will have the [CNSU.Minimum age] and [CNSU.Maximum age] informed. Furthermore, the [CNSU.Maximum age] will be equal or lower than [CCON.Minimum child age

The validation record check is:

  • Dates
  • Rate
  • Room type
  • Room characteristic
  • Board
  • Passenger’s age
  • Operation days 

If more than one record is valid, then the filtering order is:

  1. Rate
  2. Room type
  3. Room characteristic
  4. Board 

The infant supplement and discount has two more fields that we have to validate:

  • Order [CNSU.Pax order]: The infant order. It could appear different supplements or discounts for the first child and the second one in the same booking.
  • Adults [CNSU.Adults]: The minimum adults that may have in the booking in order to apply the record. 

Additional bed

An additional bed supplement or discount is defined when the [CNSU.Type] value is C

These records must be processed just afterwards the child supplement and discounts. 

The additional bed only applies for the adult passengers which exceed the standard capacity of the room. And also you have to check:

  • Dates
  • Rate
  • Room type
  • Room characteristic
  • Board
  • Passenger’s age
  • Operation days 

If more than one record is valid, then the filtering order is:

  1. Rate
  2. Room type
  3. Room characteristic
  4. Board 

You have to consider the order [CNSU.Pax order]. It could appear different supplements or discounts for the first adult and the second one in the same booking 

Example:

Additional bed supplements and discount records for a contract where:

  • Standard capacity value is 2 

#

Order

Percentage

A

3

-50%

B

4

-30%

 

Availability

Pax

Age

Supplement or Discount

Order

Description

1AD

AD

30

-

-

Not enough passengers to apply

2AD

AD

30

-

-

Not enough passengers to apply

AD

30

-

-

3AD

AD

30

-

-

The A supplement/discount to the third passenger.

AD

30

-

-

AD

30

A

3

4AD

AD

30

-

-

The A supplement/discount to the third passenger.

The B supplement/discount to the fourth passenger

AD

30

-

-

AD

30

A

3

AD

30

B

4

2AD+

1CH

AD

30

-

-

The third passenger has the child supplement/discount applied so the additional bed supplement/discount does not apply

AD

30

-

-

CH

8

-

-

2AD+

1CH

AD

30

-

-

The A supplement/discount applies to third adult. The child is considered adult because no child supplement or discount applied

AD

30

-

-

AD

8

A

3

Additional bed supplement/discount valuation example 

 

Once you have the record to apply, the price calculation is detailed in the next section. 

Room for single use

A room for single use supplement or discount is defined when the [CNSU.Type] value is I

The application order is just after the additional bed. Note that the additional bed and single use supplement and discount can only apply one of them to the same passenger. The reason is because the room for a single use applies only to adults not covering the standard capacity. 

And also you have to check:

  • Dates
  • Rate
  • Room type
  • Room characteristic
  • Board
  • Passenger’s age
  • Operation days 

If more than one record is valid, then the filtering order is:

  1. Rate
  2. Room type
  3. Room characteristic
  4. Board 

The [CNSU.Pax order] restriction is mandatory. It could appear different supplements or discounts for the first adult and the second one in the same booking. 

Example:

Additional bed supplements and discount records for a contract where:

  • Standard capacity value is 2 

#

Order

Percentage

A

1

-50%

 

Availability

Pax

Age

Supplement or Discount

Order

Description

1AD

AD

30

A

1

The A supplement/discount applies to the first passenger.

2AD

AD

30

-

-

Too much passengers to apply the single use supplement/discount

AD

30

-

-

Additional bed supplement/discount valuation example

 

Once you have the record to apply, the price calculation is detailed in the next section. 

IMPORTANT NOTE: In order to do the calculation for this pax not exceeding the standard capacity, it is necessary to divide to the standard capacity of the room to get the price for one pax and apply the supplement accordingly. The final price would be the price for just one pax plus the supplement.

Occupancy supplements and discounts price calculation 

Different rules for the application type [CNSU.Application type]: 

Application type

Rule description

B

Applies to the base price

R

Applies to the board supplement

N

Applies to the price per night

A

Overwrite the base price

U

Applies to the first night price

T

Applies to the first night price. The application dates must be between the travel start date 

M

Overwrite the base price, but it is necessary to add the board amount to this price

Occupancy supplement/discount application types

 

The next table have all the different scenarios and the calculated price. 

Example:

Supplements and discounts price calculation

Standard capacity for the room is 2 and number of paxes in the room is 3 

Base price [CNCT]

Board supplement and discount [CNSR]

Supplement and discount [CNSU]

Price

Is per pax

Price

Is per pax

Application type

Amount

Price per pax

100

Y

20

N

B

-30

(100-(30/3))+20/3=96.67

Y

(100-(30/3))+20=110

N

R

-30

100+(20/3-(30/3))=96.67

Y

100+(20-(30/3))=110

N

N

-30

(100-(30/3))+20/3=96.67

Y

(100-(30/3))+20=110

N

A

30

30/3=10

Y

30/3=10

N

M

30

(30/3)+20/3=16.67

Y

(30/3)+20=30

100

N

20

N

B

-30

(100/2)-(30/3)+(20/3)=46.67

Y

(100/2)-(30/3)+20=60

N

R

-30

(100/2)+((20/3)-(30/3))=46.67

Y

(100/2)+(20-(30/3)))=60

N

N

 -30

(100/2)-(30/3)+(20/3)=46.67

Y

(100/2)-(30/3)+20=60

N

A

30

30/3=10

Y

30/3=10

N

M

30

(30/3)+20/2=20 (*)

Y

(30/3)+20=30

100

Y

20

N

B

-30%

(100-30%100)+(20/3)=76.67

Y

(100-30%100)+20=90

N

R

-30%

100+((20/3)-30%20/3))=104.67

Y

100+(20-30%20)=114

N

N

-30%

(100-30%100)+(20/3-30%20/3)=74.67

Y

(100-30%100)+(20-30%20)=84

100

N

20

N

B

-30%

(100/2-30%100/2)+(20/3)=41.67

Y

(100/2-30%100/2)+20=55

N

R

-30%

100/2+((20/3)-30%20/3))=54.67

Y

100/2+(20-30%20)=64

N

N

 -30%

(100/2-30%100/2)+

(20/3-30%20/3)=39.67

Y

(100/2-30%100/2)+(20-30%20)=49

Supplement/discount valuation example

The application types U and T are the same than N, but only for the first night. The application types A and M are only possible with amounts, not percentages.

(*) If the board price is per room and there is a M discount, it is necessary to divide the board to the standard capacity in order to get the price for 1 pax and add the absolute amount for this supplement.