19.04 DB Schema Changes

[tbl_Level_of_Service]

Added Field(s)

FieldDatatypeNULLABLE
[lng_Level_of_Service_Rank]INTNO

[tbl_FareHeader_GLSurcharge_Connecting_XRef]

New Table

FieldDatatypeNULLABLE
[lng_FareHeader_GLSurcharge_Connecting_Id_Nmbr]INTNO
[lng_FareHeader_GLSurcharge_Id_Nmbr]INTNO
[lng_Airport_Id_Nmbr]INTNO
[tsp_Timestamp]ROWVERSIONNO
[dtm_Creation_Date]SMALLDATETIMEYES
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMEYES
[lng_Last_Mod_User_Id_Nmbr]INTNO

[tbl_FareHeader_GLSurcharge_Non_Applicable_XRef]

New Table

FieldDatatypeNULLABLE
[lng_FareHeader_GLSurcharge_Non_Applicable_XRef_Id_Nmbr]INTNO
[lng_FareHeader_GLSurcharge_Id_Nmbr]INTNO
[lng_Fare_Class_Id_Nmbr]INTNO
[tsp_Timestamp]ROWVERSIONNO
[dtm_Creation_Date]SMALLDATETIMEYES
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMEYES
[lng_Last_Mod_User_Id_Nmbr]INTNO

[tbl_User_Settings]

New Table

FieldDatatypeNULLABLE
[lng_User_Setting_Id_Nmbr]INTNO
[lng_User_Id_Nmbr]INTNO
[str_Setting_Category]VARCHAR (50)NO
[str_Setting_Name]VARCHAR (100)NO
[str_Setting_Value]VARCHAR (50)NO
[tsp_Timestamp]ROWVERSIONNO
[dtm_Creation_Date]SMALLDATETIMEYES
[lng_Creation_User_Id_Nmbr]INTNO
[dtm_Last_Mod_Date]SMALLDATETIMEYES
[lng_Last_Mod_User_Id_Nmbr]INTNO