21.11 DB Schema Changes

Added table(s)

[tbl_Res_Pax_Gds_Name_Group]

Field

Data Type

NULLABLE

[lng_Res_Pax_Group_Id_Nmbr]INTNO
[lng_Group]INT

NO

[lng_Position]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_Fare_Allocation]

Field

Data Type

NULLABLE

[str_GDS_Flag]CHAR (1)YES
[str_Avs_Status_Code]VARCHAR (2)

YES

[lng_Max_Availability_Display]INTYES

[tbl_Sked_Segment_Fare_Allocation]

Field

Data Type

NULLABLE

[lng_Max_Availability_Display]INTYES
[str_GDS_Flag]CHAR (1)

YES

[str_AVS_Status_Code]VARCHAR (2)YES

[tbl_Sked_Segment_Fare_Allocation_Audit]

Field

Data Type

NULLABLE

[lng_Max_Availability_Display]INTYES
[str_GDS_Flag]CHAR (1)

YES

[str_AVS_Status_Code]VARCHAR (2)YES