[tbl_Sked_Flight_Watch_Journey_Log]

Added Field(s)

Field	Datatype	NULLABLE
[str_Eticketable]	CHAR (1)	NO
[str_Operating_Airline_Code]	VARCHAR (3)	NO
[str_Operating_Flight_Nmbr]	VARCHAR (7)	NO

[tbl_Fare_Detail]

Added Field(s)

Field	Datatype	NULLABLE
[lng_Tax_Configuration_Id_Nmbr]	INT	NO

[tbl_Fare_Detail_Audit]

Added Field(s)

Field	Datatype	NULLABLE
[lng_Tax_Configuration_Id_Nmbr]	INT	NO

[tbl_Res_Pax_Group]

Added Field(s)

Field	Datatype	NULLABLE
[lng_Pax_Type_Codes_Id_Nmbr]	INT	NO

[tbl_Res_Pax_Infant]

Field	Datatype	NULLABLE
[lng_Pax_Type_Codes_Id_Nmbr]	INT	NO

[tbl_SSR_Category]

Field	Datatype	NULLABLE
[lng_RFIC_Id]	INT	YES

[tbl_SSR_Definition]

Field	Datatype	NULLABLE
[lng_RFIC_Id]	INT	YES

[tbl_User_Profile]

Field	Datatype	NULLABLE
[lng_Loyalty_Points_Definition_ID]	INT	NO

CREATE TABLE [tbl_EMD_Coupon_Associations]

Field	Datatype	NULLABLE
[lng_EMD_Coupon_Association_Id]	INT	NO
[lng_EMD_Coupon_Id]	INT	NO
[lng_SSR_Res_Leg_Xref_Id_Nmbr]	INT	NO
[str_Association_Status]	CHAR(1)	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	DATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

CREATE TABLE [tbl_EMD_Coupon_Associations_Audit]

Field	Datatype	NULLABLE
[lng_EMD_Coupon_Associations_Audit_Id]	INT	NO
[str_Audit_Type]	CHAR (1)	NO
[lng_EMD_Coupon_Association_Id]	INT	NO
[lng_EMD_Coupon_Id]	INT	NO
[lng_SSR_Res_Leg_Xref_Id_Nmbr]	INT	NO
[str_Association_Status]	CHAR (1)	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	DATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

CREATE TABLE [tbl_EMD_Coupons]

Field	Datatype	NULLABLE
[lng_EMD_Coupon_Id]	INT	NO
[lng_EMD_Id]	INT	NO
[lng_Coupon_Number]	INT	NO
[str_Coupon_Status]	VARCHAR (1)	NO
[lng_RFISC_Id]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	DATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

CREATE TABLE [tbl_EMD_Coupons_Audit]

Field	Datatype	Nullable
[lng_EMD_Coupons_Audit_Id]	INT	NO
[str_Audit_Type]	CHAR (1)	NO
[lng_EMD_Coupon_Id]	INT	NO
[lng_EMD_Id]	INT	NO
[lng_Coupon_Number]	INT	NO
[str_Coupon_Status]	VARCHAR (1)	NO
[lng_RFISC_Id]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	DATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

CREATE TABLE [tbl_EMD_Payments]

Field	Datatype	NULLABLE
[lng_EMD_Payment_Id]	INT	NO
[lng_EMD_Id]	INT	NO
[lng_GL_Payments_Id_Nmbr]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	DATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

CREATE TABLE [tbl_EMDs]

Field	Datatype	NULLABLE
[lng_EMD_Id]	INT	NO
[lng_EMD_AirlineCode]	INT	NO
[lng_EMD_FormCode]	INT	NO
[lng_EMD_SerialNumber]	INT	NO
[str_EMD_Type]	VARCHAR (1)	NO
[str_Tour_Code]	VARCHAR (25)	NO
[lng_RFIC_Id]	INT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	DATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

CREATE TABLE [tbl_FareHeader_GLSurcharge_Currency]

Field	Datatype	NULLABLE
[lng_FareHeader_GLSurcharge_Currency_Id_Nmbr]	INT	NO
[lng_FareHeader_GLSurcharge_Id_Nmbr]	INT	NO
[lng_Currency_Id_Nmbr]	INT	NO
[mny_FareHeader_GLSurcharge_Currency_Amount]	MONEY	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

CREATE TABLE [tbl_Loyalty_Points_Definition]

Field	Datatype	NULLABLE
[lng_Loyalty_Points_Definition_ID]	INT	NO
[str_Description]	VARCHAR (30)	NO
[lng_Points_Start]	INT	NO
[lng_Points_End]	INT	NO
[lng_Rank]	INT	NO
[str_Active]	VARCHAR(1)	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

CREATE TABLE [tbl_Pax_Type_Codes]

Field	Datatype	NULLABLE
[lng_Pax_Type_Codes_Id_Nmbr]	INT	NO
[str_Code]	VARCHAR (5)	NO
[str_Description]	VARCHAR (200)	NO
[str_Age_Type]	CHAR (1)	NO
[str_Gender]	CHAR (1)	NO
[lng_Min_Age]	INT	NO
[lng_Max_Age]	INT	NO
[bit_Age_Restriction]	BIT	NO
[bit_Seat]	BIT	NO
[bit_FrequentFlyer]	BIT	NO
[bit_Group]	BIT	NO
[bit_Standby]	BIT	NO
[bit_Iata]	BIT	NO
[bit_Active]	BIT	NO
[bit_Deleted]	BIT	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

CREATE TABLE [tbl_RFICs]

Field	Datatype	NULLABLE
[lng_RFIC_Id]	INT	NO
[str_Code]	CHAR(1)	NO
[str_Description]	VARCHAR (70)	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	DATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

CREATE TABLE [tbl_RFISCs]

Field	Datatype	NULLABLE
[lng_RFISC_Id]	INT	NO
[lng_RFIC_Id]	INT	NO
[str_Description]	VARCHAR (3)	NO
[tsp_Timestamp]	ROWVERSION	NO
[dtm_Creation_Date]	DATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	NO
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

InteliSys Service Desk Documentation

18.06 DB Schema Changes

[tbl_Sked_Flight_Watch_Journey_Log]

[tbl_Fare_Detail]

[tbl_Fare_Detail_Audit]

[tbl_Res_Pax_Group]

[tbl_Res_Pax_Infant]

[tbl_SSR_Category]

[tbl_SSR_Definition]

[tbl_User_Profile]

CREATE TABLE [tbl_EMD_Coupon_Associations]

CREATE TABLE [tbl_EMD_Coupon_Associations_Audit]

CREATE TABLE [tbl_EMD_Coupons]

CREATE TABLE [tbl_EMD_Coupons_Audit]

CREATE TABLE [tbl_EMD_Payments]

CREATE TABLE [tbl_EMDs]

CREATE TABLE [tbl_FareHeader_GLSurcharge_Currency]

CREATE TABLE [tbl_Loyalty_Points_Definition]

CREATE TABLE [tbl_Pax_Type_Codes]

CREATE TABLE [tbl_RFICs]

CREATE TABLE [tbl_RFISCs]