Data Dictionary - 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 aircrafts 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	Organisation unit on whihc the Routing has been created	Yes	No
ACRout_Fight_No	CHAR(18)	NOT NULL	Unique identifier for a flight of an Aircraft Betwen &nbsptwo 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 registeration number	No	No
ACRout_Aircraft_Reg_Ou	CHAR(18)	NOT NULL	Organisation unit on which the Aircraft registeration 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 &nbsparival 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	Organisation 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	Oraganisation 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 alteranate 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 Umit of mesearment	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 &nbsptwo stations	Yes	Yes
AltStn_created_ouinstance	NUMERIC(10,0)	NOT NULL	Organisation unit on which Flight number has been created	Yes	Yes
AltStn_Station_Ou	NUMERIC(10,0)	NOT NULL	Organisation 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	Alternativ station name.	Yes	No
Table Name FPtn_FltCode_FlightCode_Dtl
Table Comment Rpository to store the Flight # , Leg # ,Station and &nbspschedule 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	Organisation 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 Betwen &nbsptwo 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  -- &nbspInoperative OP   -- &nbspOperative	No	No
FltCode_From_Station_OU	NUMERIC(10,0)	NULL	Organisation unit of the station from where the Aircraft starts.	No	No
FltCode_From_Station	VARCHAR2(32)	NULL	The station name from which the sheduled Flight starts.	No	No
FltCode_To_Station_OU	NUMERIC(10,0)	NULL	Organisation unit of the station to which the Aircraft arrives.	No	No
FltCode_To_Station	VARCHAR2(32)	NULL	The station name on which the sheduled 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	RefrenceTime Zone of the login user	No	No
FltCode_Model_Ou	CHAR(18)	NULL	Organisation 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 cabin crew chage has been happened in the &nbspjourney. Values will be Yes / No	No	No
FltCode_Start_Mnt_Event	CHAR(18)	NULL	The maintenanc eventthat need to be done before start of the flight	No	No
FltCode_End_Mnt_Event	CHAR(18)	NULL	The maintenanc 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 organisation 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	Organisation 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. valuse - 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 parametrs need to shorted out	No	No
Table Name FPtn_Schdtl_Schedule_Dtl
Table Comment Stores the aircraft schedule details with leg # , flight # and &nbspDay wise departure time details in a detailed lavel.
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 organisation 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 Betwen &nbsptwo 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