20.11 DB Schema Changes

Owned by Thao Nguyen
Nov 21, 2020
1 min read

Added Table(s)

[tbl_Cancellation_Charges_Fare_Class_Xref]

Field

Data Type

NULLABLE

[lng_Cancellation_Charges_Fare_Class_Xref_Id_Nmbr]INTNO
[lng_Fare_Class_Id_Nmbr]INTNO
[lng_Cancellation_Charges_Id_Nmbr]INTNO
[dtm_Creation_Date]SMALLDATETIMEYES
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMEYES
[lng_Last_Mod_User_Id_Nmbr]INTNO

[tbl_Coupon_Status_Mapping]

Field

Data Type

NULLABLE

[lng_Coupon_Status_Mapping_Id_Nmbr]INTNO
[str_Coupon_Status]VARCHAR (2)NO
[str_Status_Substitution]VARCHAR (15)NO
[dtm_Creation_Date]DATETIMENO
[str_Creation_User]NVARCHAR (63)NO
[dtm_Last_Mod_Date]DATETIMENO
[str_Last_Mod_User]NVARCHAR (63)NO

[tbl_Leg_Status_Mapping]

Field

Data Type

NULLABLE

[lng_Leg_Status_Mapping_Id_Nmbr]INTNO
[str_Leg_Status]CHAR (1)NO
[str_Status_Substitution]VARCHAR (15)NO
[dtm_Creation_Date]DATETIMENO
[str_Creation_User]NVARCHAR (63)NO
[dtm_Last_Mod_Date]DATETIMENO
[str_Last_Mod_User]NVARCHAR (63)NO

[tbl_Standard_Weight_Gender_Prefix_XRef]

Field

Data Type

NULLABLE

[lng_Standard_Weight_Gender_Prefix_XRef_Id_Nmbr]INTNO
[lng_Standard_Weight_Id_Nmbr]INTNO
[lng_Gender_Prefix_Id_Nmbr]INTNO
[dtm_Creation_Date]SMALLDATETIMEYES
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMEYES
[lng_Last_Mod_User_Id_Nmbr]INTNO

Deleted Column(s)

[tbl_GL_CreditCard_Payment]

Field

Data Type

NULLABLE

[str_CardMask_FirstSix]VARCHAR (6)NO
[str_CardMask_LastFour]VARCHAR (4)NO

[tbl_Predefined_Weight_Definition]

Field

Data Type

NULLABLE

[mny_Undefined_Weight]MONEYNO

[tbl_Res_Pax_Group]

Field

Data Type

NULLABLE

[str_Endorsement]VARCHAR (49)NO