/
19.04 DB Schema Changes

19.04 DB Schema Changes

Owned by Nicolas Maillet (Unlicensed)
Last updated: Apr 26, 2019

[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

Related content

19.10 DB Schema Changes
19.10 DB Schema Changes
InteliSys Service Desk Documentation
More like this
19.06 DB Schema Changes
19.06 DB Schema Changes
InteliSys Service Desk Documentation
More like this
19.12 DB Schema Changes
19.12 DB Schema Changes
InteliSys Service Desk Documentation
More like this
20.09 DB Schema Changes
20.09 DB Schema Changes
InteliSys Service Desk Documentation
More like this
21.11 DB Schema Changes
21.11 DB Schema Changes
InteliSys Service Desk Documentation
More like this
20.08 DB Schema Changes
20.08 DB Schema Changes
InteliSys Service Desk Documentation
More like this