19.10 DB Schema Changes

Owned by Steven Parent (Unlicensed)

Last updated: Oct 24, 2019 by Long Tran (Unlicensed)

1 min read

[tbl_Password_Policy]

Added Field(s)

Field	Datatype	NULLABLE
[lng_Initial_Max_Age_Days]	INT	NO

[tbl_GL_Charge_Type_Definition]

Added Field(s)

Field	Datatype	NULLABLE
[str_Refundable]	CHAR(1)	YES
[str_Consumed_At_Issuance]	CHAR(1)	YES

[tbl_GL_SurCharge]

Added Field(s)

Field	Datatype	NULLABLE
[str_Refundable]	CHAR(1)	YES
[str_Consumed_At_Issuance]	CHAR(1)	YES

[tbl_Pax]

Added Field(s)

Field	Datatype	NULLABLE
[lng_Pref_Language_Id_Nmbr]	INT	YES

[tbl_Res_Header]

Added Field(s)

Field	Datatype	NULLABLE
[lng_Pref_Language_Id_Nmbr]	INT	YES

[tbl_User_Profile]

Added Field(s)

Field	Datatype	NULLABLE
[lng_Pref_Language_Id_Nmbr]	INT	YES

[tbl_RAS]

New Table

Field	Datatype	NULLABLE
[lng_RAS_Id_Nmbr]	INT	NO
[str_Airline_Code]	NVARCHAR (3)	NO
[str_Flight_Nmbr]	NVARCHAR (10	NO
[str_Operating_Airline_Code]	NVARCHAR (3)	NO
[str_Operating_Flight_Nmbr]	NVARCHAR (10)	NO
[dtm_Dep_Date_Local]	SMALLDATETIME	NO
[str_Dep_Airport_Ident]	NVARCHAR (5)	NO
[str_Arr_Airport_Ident]	NVARCHAR (5)	NO
[str_Trigger_Reason]	NVARCHAR (20)	NO
[str_Processed]	NVARCHAR (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