Flight Assignment

Flight Assignment

Table Name FPtn_ACRout_AC_Routing_Dtl

Table Comment Stores the Aircraft routing details along with flight and leg# details. Also stores the information of the aircraft availabily at stations
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
ACRout_Created_Ouinstance	CHAR(18)	NOT NULL	Organization unit on which the Routing has been created	Yes	No
ACRout_Fight_No	CHAR(18)	NOT NULL	Unique identifier for a flight of an Aircraft Between two stations	Yes	No
ACRout_Leg_No	CHAR(18)	NOT NULL	If a journey has multiple segments then each is identified by a different leg# , Under a same flight #	Yes	No
ACRout_Fight_Date	CHAR(18)	NOT NULL	Date of flight	Yes	No
ACRout_Aircraft_Reg_No	CHAR(18)	NOT NULL	Aircraft registration number	No	No
ACRout_Aircraft_Reg_Ou	CHAR(18)	NOT NULL	Organization unit on which the Aircraft registration number has been created.	No	No
ACRout_Utc_SchDept_Date	CHAR(18)	NULL	Schedule departure date in UTC format	No	No
ACRout_Utc_SchDept_Time	CHAR(18)	NULL	Schedule departure time in UTC format	No	No
ACRout_Utc_SchArvl_Date	CHAR(18)	NULL	Schedule arrival date in UTC format	No	No
ACRout_Utc_SchArvl_Time	CHAR(18)	NULL	Schedule arrival time in UTC format	No	No
ACRout_Utc_ActDept_Date	CHAR(18)	NULL	Actual departure date in UTC format	No	No
ACRout_Utc_ActDept_Time	CHAR(18)	NULL	Actual departure time in UTC format	No	No
ACRout_Utc_ActArvl_Date	CHAR(18)	NULL	Actual arrival date in UTC format	No	No
ACRout_Utc_ActArvl_Time	CHAR(18)	NULL	Actual arrival time in UTC format	No	No
ACRout_Schedule_No	CHAR(18)	NULL	Schedule number	No	No
ACRout_Trip_No	CHAR(18)	NULL	Trip number	No	No
ACRout_Ref_Time_Zone	CHAR(18)	NULL	Reference time zone	No	No
ACRout_From_Station_Ou	CHAR(18)	NULL	Organization unit of the Station from which the route starts	No	No
ACRout_From_Station	CHAR(18)	NULL	Station from which the route starts	No	No
ACRout_To_Station_Ou	CHAR(18)	NULL	Organization unit of the Station on which the route ends	No	No
ACRout_To_Station	CHAR(18)	NULL	Station on which the route ends	No	No
ACRout_Terminal	CHAR(18)	NULL	Terminal number	No	No
ACRout_Gate_No	CHAR(18)	NULL	Gate number	No	No
ACRout_Comments	CHAR(18)	NULL	Comments	No	No
ACRout_WorkGroup_No	CHAR(18)	NULL	Work group number	No	No

Table Name FPtn_AltStn_AlterStn_Info

Table Comment Stores alternate station details for a flight #
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
AltStn_Utc_StdArvl_Time	DATETIME	NULL	Standard arrival time in UTC format	No	No
AltStn_StdArvl_Time	DATETIME	NULL	Standard arrival time	No	No
AltStn_Time_Uom	VARCHAR2(10)	NULL	Time Unit of measurement	No	No
AltStn_Est_Travel_Durn	NUMERIC(28,8)	NULL	Estimated Travel duration	No	No
AltStn_Est_Travel_Durn_InMin	NUMERIC(28,8)	NULL	Estimated Travel duration in minutes	No	No
AltStn_Flight_No	VARCHAR2(30)	NOT NULL	Unique identifier for a flight of an Aircraft Between two stations	Yes	Yes
AltStn_created_ouinstance	NUMERIC(10,0)	NOT NULL	Organization unit on which Flight number has been created	Yes	Yes
AltStn_Station_Ou	NUMERIC(10,0)	NOT NULL	Organization unit of the alternate station	Yes	No
AltStn_Leg_No	NUMERIC(10,0)	NOT NULL	If a journey has multiple segments then each is identified by a different leg# , Under a same flight #	Yes	Yes
AltStn_Station_No	VARCHAR2(32)	NOT NULL	Alternative station name.	Yes	No

Table Name FPtn_FltCode_FlightCode_Dtl

Table Comment Repository to store the Flight # , Leg # ,Station and schedule details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FltCode_created_ouinstance	NUMERIC(10,0)	NOT NULL	Organization unit on which Flight number has been created	Yes	No
FltCode_Flight_No	VARCHAR2(30)	NOT NULL	Unique identifier for a flight of an Aircraft Between two stations	Yes	No
FltCode_Leg_No	NUMERIC(10,0)	NOT NULL	If a journey has multiple segments then each is identified by a different leg# , Under a same flight #	Yes	No
FltCode_Status	VARCHAR2(5)	NULL	Status of the flight code. Static values. IOP -- Inoperative OP -- Operative	No	No
FltCode_From_Station_OU	NUMERIC(10,0)	NULL	Organization unit of the station from where the Aircraft starts.	No	No
FltCode_From_Station	VARCHAR2(32)	NULL	The station name from which the scheduled Flight starts.	No	No
FltCode_To_Station_OU	NUMERIC(10,0)	NULL	Organization unit of the station to which the Aircraft arrives.	No	No
FltCode_To_Station	VARCHAR2(32)	NULL	The station name on which the scheduled Flight ends.	No	No
FltCode_StdDept_Time	DATETIME	NULL	Standard departure Time	No	No
FltCode_Time_Uom	VARCHAR2(10)	NULL	Will be minutes or hours	No	No
FltCode_Est_Travel_Durn	NUMERIC(28,8)	NULL	Travel Duration Estimated	No	No
FltCode_Est_Travel_Durn_InMin	NUMERIC(28,8)	NULL	Estimated travel duration in Minutes	No	No
FltCode_created_by	VARCHAR2(30)	NULL	Created By	No	No
FltCode_created_Date	DATETIME	NULL	Created Date	No	No
FltCode_Modified_by	VARCHAR2(30)	NULL	Modified by	No	No
FltCode_Modifed_Date	DATETIME	NULL	Modified date	No	No
FltCode_Timestamp	NUMERIC(10,0)	NULL	Timestamp	No	No
FltCode_Ref_Time_Zone	CHAR(18)	NULL	ReferenceTime Zone of the login user	No	No
FltCode_Model_Ou	CHAR(18)	NULL	Organization unit on which the Model created	No	No
FltCode_Model_No	CHAR(18)	NULL	Aircraft model number	No	No
FltCode_Crew_Change	CHAR(18)	NULL	To specify whether any cabin crew change has happened in the journey. Values will be Yes / No	No	No
FltCode_Start_Mnt_Event	CHAR(18)	NULL	The maintenance event that need to be done before start of the flight	No	No
FltCode_End_Mnt_Event	CHAR(18)	NULL	The maintenance event that need to be done at end of the flight	No	No
FltCode_Std_Dept_Gate	CHAR(18)	NULL	Standard departure gate	No	No
FltCode_Std_Arvl_Gate	CHAR(18)	NULL	Standard arrival gate	No	No
FltCode_Plan_Region	CHAR(18)	NULL	Plan Region	No	No

Table Name FPtn_FltSch_Schedule_Hdr

Table Comment Stores the aircraft schedule details and its attributes at header level.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FltSch_Created_Ouinstance	CHAR(18)	NOT NULL	The organization unit on which the flight schedule has been created	Yes	No
FltSch_Schedule_No	CHAR(18)	NOT NULL	Unique identifier for the flight schedule.	Yes	No
FltSch_From_date	CHAR(18)	NOT NULL	Schedule from date.	Yes	No
FltSch_To_date	CHAR(18)	NOT NULL	Schedule to date.	Yes	No
FltSch_Status	CHAR(18)	NULL	Status of the schedule. Static values. IOP -- Inoperative OP -- Operative	No	No
FltSch_Comments	CHAR(18)	NULL	Schedule comments	No	No
FltSch_Filename	CHAR(18)	NULL	File name	No	No
FltSch_Created_By	CHAR(18)	NULL	Created User name	No	No
FltSch_Created_Date	CHAR(18)	NULL	Created Date	No	No
FltSch_Modified_By	CHAR(18)	NULL	Modified User name	No	No
FltSch_Modified_Date	CHAR(18)	NULL	Modified date	No	No
FltSch_Timestamp	CHAR(18)	NULL	Timestamp	No	No

Table Name FPtn_FpOpt_SetOption_Info

Table Comment Option settings for Flight operations Component
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FpOpt_Ouinstance	CHAR(18)	NOT NULL	Organization unit on which Flight number has been created	Yes	No
FpOpt_Ntype_Fltschno	CHAR(18)	NULL	Numbering type for the facility number	No	No
FpOpt_AcRout_PlanHoriz	CHAR(18)	NULL	Aircraft Routing Planning Horizon	No	No
FpOpt_PlanHoriz_Uom	CHAR(18)	NULL	Unit of measurement for Aircraft Routing Planning Horizon	No	No
FpOpt_Created_By	CHAR(18)	NULL	Created By	No	No
FpOpt_Created_Date	CHAR(18)	NULL	Created date	No	No
FpOpt_Modified_By	CHAR(18)	NULL	Modified by	No	No
FpOpt_Modified_Date	CHAR(18)	NULL	Modified date	No	No

Table Name Fptn_Parameter_Details

Table Comment Meta Data Table for Flight planning
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Fptn_ComponentName	VARCHAR2(80)	NOT NULL	The source component name, static value. values - BasFptn	Yes	No
Fptn_ParamCategory	VARCHAR2(10)	NOT NULL	Category to which the parameter belongs to	Yes	No
Fptn_ParamType	VARCHAR2(25)	NOT NULL	Type of parameter	Yes	No
Fptn_ParamCode	VARCHAR2(5)	NOT NULL	Distinct Code of the parameter.	Yes	No
Fptn_Langid	NUMERIC(10)	NOT NULL	Language id	Yes	No
Fptn_ParamDesc	VARCHAR2(80)	NULL	Detailed description of the parameter	No	No
Fptn_CreationDate	DATETIME	NULL	Created Date	No	No
Fptn_SortBy	NUMBER(10)	NULL	order in which the parameters need to shorted out	No	No

Table Name FPtn_Schdtl_Schedule_Dtl

Table Comment Stores the aircraft schedule details with leg # , flight # and Day wise departure time details in a detailed level.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
Schdtl_Created_Ouinstance	CHAR(18)	NOT NULL	The organization unit on which the flight schedule has been created	Yes	Yes
Schdtl_Schedule_No	CHAR(18)	NOT NULL	Unique identifier for the aircraft schedule.	Yes	Yes
Schdtl_From_date	CHAR(18)	NOT NULL	schedule starts From date	Yes	Yes
Schdtl_To_date	CHAR(18)	NOT NULL	schedule to date	Yes	Yes
Schdtl_Flight_No	CHAR(18)	NOT NULL	Unique identifier for a flight of an Aircraft Between two stations	Yes	No
Schdtl_Leg_No	CHAR(18)	NOT NULL	If a journey has multiple segments then each is identified by a different leg# , Under a same flight #	Yes	No
Schdtl_Sch_Option	CHAR(18)	NULL	Schedule options , static values. A - Alternate D - Daily O - Others	No	No
Schdtl_Sunday	CHAR(18)	NULL	Schedule time on Sunday	No	No
Schdtl_Monday	CHAR(18)	NULL	Schedule time on Monday	No	No
Schdtl_Tuesday	CHAR(18)	NULL	Schedule time on Tuesday	No	No
Schdtl_Wednesday	CHAR(18)	NULL	Schedule time on Wednesday	No	No
Schdtl_Thursday	CHAR(18)	NULL	Schedule time on Thursday	No	No
Schdtl_Friday	CHAR(18)	NULL	Schedule time on Friday	No	No
Schdtl_Saturday	CHAR(18)	NULL	Schedule time on Saturday	No	No
Schdtl_Status	CHAR(18)	NULL	Status of the schedule. Static values. IOP -- Inoperative OP -- Operative	No	No
Schdtl_Trip_No	CHAR(18)	NULL	Trip number	No	No
Schdtl_Remarks	CHAR(18)	NULL	Remarks	No	No
Schdtl_Created_By	CHAR(18)	NULL	Created By	No	No
Schdtl_Created_Date	CHAR(18)	NULL	Created Date	No	No
Schdtl_Modified_By	CHAR(18)	NULL	Modified By	No	No
Schdtl_Modified_Date	CHAR(18)	NULL	Modified Date	No	No