Added Table(s)

[tbl_GDS_AVS_Sked_Segment_OneToRuleThemAll]

Field	Data Type	NULLABLE
[lng_GDS_AVS_Sked_Segment_Id_Nmbr]	BIGINT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[str_Flight_Nmbr]	VARCHAR (10)	NO
[dtm_Flight_Date]	SMALLDATETIME	NO
[str_Airline_Code]	VARCHAR (5)	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[str_Dep_Ident]	CHAR (3)	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[str_Arr_Ident]	CHAR (3)	NO
[lng_Fare_Category_Id_Nmbr]	INT	NO
[str_Fare_Category_Ident]	CHAR (3)	NO
[str_Existing_Status_Code]	VARCHAR (2)	NO
[str_Status_Code]	CHAR (2)	NO
[lng_Availability]	INT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	BIGINT	NO
[str_Message]	VARCHAR (40)	NO
[lng_Times_Processed]	INT	NO
[dtm_Creation_Date]	SMALLDATETIME	NO
[lng_Creation_User_Id_Nmbr]	INT	NO

Field	Data Type	NULLABLE
[lng_Leg_Route_Allocation_Hold_History_Id_Nmbr]	BIGINT	NO
[lng_Leg_Route_Allocation_Hold_Id_Nmbr]	BIGINT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Seat_Allocation_Id_Nmbr]	BIGINT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	BIGINT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	BIGINT	NO
[str_MSG_Guid]	VARCHAR (50)	NO
[lng_Allocation_Adjustment]	INT	NO
[dtm_Allocation_Hold_Expires]	SMALLDATETIME	NO
[lng_Allocation_Hold_Status]	INT	NO
[dtm_Creation_Date]	SMALLDATETIME	YES
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	YES
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field	Data Type	NULLABLE
[lng_Leg_Route_Allocation_Hold_Id_Nmbr]	BIGINT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Seat_Allocation_Id_Nmbr]	BIGINT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	BIGINT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	BIGINT	NO
[lng_Segment_Allocation_Status_Id_Nmbr]	INT	NO
[str_MSG_Guid]	VARCHAR (50)	NO
[lng_Allocation_Adjustment]	INT	NO
[dtm_Allocation_Hold_Expires]	SMALLDATETIME	NO
[lng_Allocation_Hold_Status]	INT	NO
[dtm_Creation_Date]	SMALLDATETIME	YES
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	YES
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field	Data Type	NULLABLE
[lng_Leg_Route_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Seat_Allocation_Id_Nmbr]	BIGINT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	BIGINT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	BIGINT	NO
[lng_Segment_Allocation_Status_Id_Nmbr]	INT	NO
[lng_Segment_Checkin_Status_Id_Nmbr]	INT	NO
[dtm_Creation_Date]	SMALLDATETIME	YES
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	YES
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field	Data Type	NULLABLE
[lng_Segment_Allocation_Status_Id_Nmbr]	INT	NO
[str_Segment_Allocation_Status_Ident]	NVARCHAR (5)	NO
[str_Segment_Allocation_Status_Description]	NVARCHAR (15)	NO
[bit_Count_Allocation]	BIT	NO
[bit_Deleted]	BIT	NO
[dtm_Creation_Date]	SMALLDATETIME	YES
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	YES
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field	Data Type	NULLABLE
[lng_Segment_Checkin_Status_Id_Nmbr]	INT	NO
[str_Segment_Checkin_Status_Ident]	NVARCHAR (5)	NO
[str_Segment_Checkin_Status_Description]	NVARCHAR (15)	NO
[bit_Deleted]	BIT	NO
[dtm_Creation_Date]	SMALLDATETIME	YES
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	YES
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field	Data Type	NULLABLE
[lng_Sked_Segment_Fare_Allocation_Audit_Id_Nmbr]	BIGINT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	BIGINT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	BIGINT	NO
[lng_Fare_Category_Id_Nmbr]	INT	NO
[lng_Allocated_Seats]	INT	NO
[lng_Available_Amount]	INT	NO
[lng_Sold_Amount]	INT	NO
[str_Closed_Flag]	CHAR (1)	NO
[str_Action]	NVARCHAR (50)	NO
[dtm_Creation_Date]	SMALLDATETIME	YES
[lng_Creation_User_Id_Nmbr]	INT	NO

Field	Data Type	NULLABLE
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	BIGINT	NO
[lng_Max_Availability_Display]	INT	NO
[str_GDS_Flag]	CHAR (1)	NO
[str_AVS_Status_Code]	VARCHAR (2)	NO
[dtm_Creation_Date]	SMALLDATETIME	YES
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	YES
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field	Data Type	NULLABLE
[lng_Sked_Segment_Fare_Allocation_Audit_Id_Nmbr]	BIGINT	NO
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	BIGINT	NO
[lng_Max_Availability_Display]	INT	NO
[str_GDS_Flag]	CHAR (1)	NO
[str_AVS_Status_Code]	VARCHAR (2)	NO
[str_Action]	NVARCHAR (50)	NO
[dtm_Creation_Date]	SMALLDATETIME	YES
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	YES
[lng_Last_Mod_User_Id_Nmbr]	INT	NO

Field	Data Type	NULLABLE
[lng_Sked_Segment_Fare_Allocation_Id_Nmbr]	BIGINT	NO
[lng_Sked_Header_Id_Nmbr]	INT	NO
[lng_Dep_Airport_Id_Nmbr]	INT	NO
[lng_Arr_Airport_Id_Nmbr]	INT	NO
[lng_Sked_Segment_Level_of_Service_Id_Nmbr]	BIGINT	NO
[lng_Fare_Category_Id_Nmbr]	INT	NO
[lng_Allocated_Seats]	INT	NO
[lng_Available_Amount]	INT	NO
[lng_Sold_Amount]	INT	NO
[str_Closed_Flag]	CHAR (1)	NO
[dtm_Creation_Date]	SMALLDATETIME	YES
[lng_Creation_User_Id_Nmbr]	INT	NO
[dtm_Last_Mod_Date]	SMALLDATETIME	YES
[lng_Last_Mod_User_Id_Nmbr]	INT	NO