Data Dictionary - Aircraft Routing
Table Name Fr_AcRtAd_AcRoute_Main_Adl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
AcRtAd_To_Station	VARCHAR2(18)	NULL	To Station	No	No
AcRtAd_Arr_Datetime	DATETIME	NULL	Arrival Date & time	No	No
AcRtAd_To_Station_Ou	NUMERIC	NULL	To Station OU Instance	No	No
AcRtAd_Utc_Dep_Datetime	DATETIME	NULL	Departure Date & Time In UTC	No	No
ACRTAD_FH	NUMERIC(10)	NULL	Flight Hours	No	No
AcRtAd_Utc_Arr_Datetime	DATETIME	NULL	Arrival Date & Time in UTC	No	No
AcRtAd_AcReg_No	VARCHAR2(18)	NULL	This info is repeated here (though it can be derived from Dtl table) as it will be of use in LMC	No	No
AcRtAd_AcReg_Ou	NUMERIC	NULL	This info is repeated here (though it can be derived from Dtl table) as it will be of use in LMC	No	No
AcRtAd_Turn_Arnd_Durn_InMin	NUMERIC(10)	NULL	Turn Around Duration in minutes	No	No
AcRtAd_Route_No	VARCHAR2(30)	NOT NULL	Route Number	Yes	Yes
AcRtAd_Sch_No	NUMERIC	NOT NULL	Schedule Number	Yes	Yes
AcRtAd_Created_Ouinstance	NUMERIC	NOT NULL	Ou Instance Created	Yes	Yes
AcRtAd_Dep_Datetime	DATETIME	NULL	Departure Date & time	No	No
AcRtAd_From_Station	VARCHAR2(32)	NULL	From Station	No	No
AcRtAd_Flight_No	VARCHAR2(30)	NOT NULL	Flight Number	Yes	No
AcRtAd_From_Station_Ou	NUMERIC	NULL	From Station Ou Instance	No	No
AcRtAd_Leg_No	NUMERIC	NOT NULL	Leg Number	Yes	No
Table Name Fr_AcRtDt_AcRoute_Main_Dtl
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
AcRtDtl_Dest_Station_Ou	NUMERIC	NULL	Destination Station OU Instance	No	No
AcRtDtl_Dest_Station_Code	VARCHAR2(18)	NULL	Destination Station Code	No	No
AcRtDtl_FH	NUMERIC	NULL	Flight Hours accumulated during the Journey for the Aircraft.	No	No
AcRtDtl_Utc_End_Datetime	DATETIME	NULL	Routing End Date & Time in UTC	No	No
AcRtDtl_End_Datetime	DATETIME	NULL	Routing End Date & Time	No	No
AcRtDtl_AcReg_Ou	NUMERIC	NULL	OU Instance	No	No
AcRtDtl_Modified_By	VARCHAR2(18)	NULL	User who modified the Routing Details	No	No
AcRtDtl_Modified_Date	DATETIME	NULL	Modified Date of Aircraft Routing	No	No
AcRtDtl_Turn_Arnd_Durn_InMin	NUMERIC	NULL	Turn Around Duration in minutes	No	No
AcRtDtl_Created_Date	DATETIME	NULL	Creation Date of Routing	No	No
AcRtDtl_Created_By	VARCHAR2(18)	NULL	User who created the Routing Details	No	No
AcRtDtl_Timestamp	NUMERIC	NULL	Timestamp	No	No
AcRtDtl_Sch_No	NUMERIC	NOT NULL	Schedule number is generated for a combination of 1)Route 2)UTCStartDatetime 3)FltAssignment+OU 4) Org-Station+OU	Yes	No
AcRtDtl_Start_Datetime	DATETIME	NULL	Start Date & Time of Aircraft Routing	No	No
AcRtDtl_Utc_Start_Datetime	DATETIME	NOT NULL	Start Date & Time in UTC	No	No
AcRtDtl_Route_No	VARCHAR2(30)	NOT NULL	Route Number	Yes	Yes
AcRtDtl_Created_Ouinstance	NUMERIC	NOT NULL	Created OU Instance	Yes	Yes
AcRtDtl_AcReg_No	VARCHAR2(30)	NULL	Aircraft Registration Number	No	No
AcRtDtl_Org_Station_Ou	NUMERIC	NOT NULL	Organisation Station OU Instance	No	No
AcRtDtl_Org_Station_Code	VARCHAR2(30)	NOT NULL	Organisation Station Code	No	No
AcRtDtl_Flt_Assignment_Ou	NUMERIC	NOT NULL	Flight Assignment OU	No	No
AcRtDtl_Flt_Assignment_No	VARCHAR2(18)	NOT NULL	Flight Assignment Number	No	No
AcRtDtl_No_Of_Legs	NUMERIC	NULL	Number of Legs	No	No
AcRtDtl_First_Flight_No	VARCHAR2(30)	NOT NULL	First Flight Number	No	No
Table Name Fr_AcRtMn_AcRoute_Main_Hdr
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
AcRtMn_Created_Ouinstance	NUMERIC	NOT NULL	Created OU Instance	Yes	No
AcRtMn_Route_No	VARCHAR2(30)	NOT NULL	Route Number	Yes	No
AcRtMn_Route_Desc	VARCHAR2(150)	NULL	Route Description	No	No
AcRtMn_Route_Desc_Up	VARCHAR2(150)	NULL	Route Description in UPPER CASE	No	No
AcRtMn_Route_Status	VARCHAR2(5)	NULL	Route Status	No	No
AcRtMn_Timestamp	NUMERIC	NULL	Timestamp	No	No
AcRtMn_From_Date	DATETIME	NULL	Routing From Date	No	No
AcRtMn_Created_By	VARCHAR2(18)	NULL	User who created the Routing	No	No
AcRtMn_Utc_From_Date	DATETIME	NULL	From Date in UTC	No	No
AcRtMn_Created_Date	DATETIME	NULL	Created Date	No	No
AcRtMn_To_Date	DATETIME	NULL	Routing To Date	No	No
AcRtMn_Utc_To_Date	DATETIME	NULL	Routing To Date in UTC	No	No
AcRtMn_Modified_Date	DATETIME	NULL	Modified Date	No	No
AcRtMn_Modified_By	VARCHAR2(18)	NULL	User who modified the Routing	No	No
Table Name FR_FrOpt_Option_Settings
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FrOpt_Created_Ou	NUMERIC(10)	NOT NULL	Created OU Instance	Yes	No
FrOpt_Routing_Rule	VARCHAR2(18)	NULL	Routing Rule	No	No
FrOpt_Time_Indicator	VARCHAR2(18)	NULL	Time Indicator	No	No
FrOpt_First_AcRouting_Date	DATETIME	NULL	First Aircraft Routing Date	No	No
FrOpt_Created_By	VARCHAR2(30)	NULL	User who created the Routing	No	No
FrOpt_Created_Datetime	DATETIME	NULL	Created Date & Time	No	No
FrOpt_Modified_By	VARCHAR2(30)	NULL	User who modified the Routing	No	No
FrOpt_Modified_Datetime	DATETIME	NULL	Modified Date & Time	No	No
FrOpt_Timestamp	NUMERIC(10)	NULL	Timestamp	No	No
Table Name FR_FrPrm_Parameter_Details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
FrPrm_ComponentName	VARCHAR2(18)	NOT NULL	Component Name	Yes	No
FrPrm_Paramcategory	VARCHAR2(18)	NOT NULL	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc.	Yes	No
FrPrm_Paramtype	VARCHAR2(18)	NOT NULL	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	Yes	No
FrPrm_Paramcode	VARCHAR2(18)	NOT NULL	Param code is the value to be filled in the combo box or guidance text. This is actually the meta data of this component	Yes	No
FrPrm_Paramdesc	VARCHAR2(18)	NULL	Description of the combo value	No	No
FrPrm_Langid	NUMERIC	NULL	Language id. This is the language id of the record.	No	No
FrPrm_CreationDate	DATETIME	NULL	Created date of the record.	No	No
FrPrm_Sort_By	NUMERIC	NULL	The Order of creation of Parameter details	No	No