Data Dictionary -- Flight Operations Setup

Srl. No.	Table Name	Comment
1	fos_activitycode_mst	Activity code master
2	fos_activitycrew_map_dtl	Activity crew mapping detail
3	fos_bh_map_act_dtl	Billing head map activity detail
4	fos_bh_map_exp_dtl	Billing head map expense usage detail
5	fos_billhead_mst	Billing head master
6	fos_dutycrew_map_dtl	Duty crew map details
7	fos_duty_type_mst	Duty type master

Table Name :	fos_activitycode_mst
Comment :	Activity code master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ac_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
ac_reporting_lvl	fin_designparamcode	Char(5)	Yes	Reporting level	No
ac_activity_code	fin_activity	Char(40)	No	Activity code	Yes
ac_description	fin_txt255	Char(255)	Yes	Activity Description	No
ac_unit	fin_activity	Char(40)	Yes	Activity unit	No
ac_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
ac_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
ac_created_date	fin_date	Date(11)	Yes	Created date	No
ac_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
ac_modified_date	fin_date	Date(11)	Yes	Modified date	No

Table Name :	fos_activitycrew_map_dtl
Comment :	Activity crew mapping detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
acm_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
acm_activity_code	fin_activity	Char(40)	No	Activity code	Yes
acm_crew_type	fin_quickcodes	Char(25)	No	Crew type	Yes
acm_status	fin_status	Char(25)	Yes	Crew mapping status	No
acm_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
acm_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
acm_created_date	fin_date	Date(11)	Yes	Created date	No
acm_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
acm_modified_date	fin_date	Date(11)	Yes	Modified date	No

Table Name :	fos_bh_map_act_dtl
Comment :	Billing head map activity detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bh_map_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
bh_map_billhead	fin_billhead	Char(100)	No	Billing head	Yes
bh_map_activity_ops_cde	fin_activity	Char(40)	No	Activity ops code	Yes
bh_map_status	fin_status	Char(25)	Yes	Billing head map status	No
bh_map_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
bh_map_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
bh_map_created_date	fin_date	Date(11)	Yes	Created date	No
bh_map_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
bh_map_modified_date	fin_date	Date(11)	Yes	Modified date	No

Table Name :	fos_bh_map_exp_dtl
Comment :	Billing head map expense usage detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bh_map_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Billing head map ouinstance	Yes
bh_map_billhead	fin_billhead	Char(100)	No	Billing head	Yes
bh_map_expse_acc_usge	fin_ccusage	Char(20)	No	Billing head expence account usage	Yes
bh_map_status	fin_status	Char(25)	Yes	Billing head map status	No
bh_map_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
bh_map_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
bh_map_created_date	fin_date	Date(11)	Yes	Created date	No
bh_map_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
bh_map_modified_date	fin_date	Date(11)	Yes	Modified date	No

Table Name :	fos_billhead_mst
Comment :	Billing head master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
bh_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Billing head ouinstance	Yes
bh_invoice_element	fin_designparamcode	Char(5)	Yes	Billing head invoice element	No
bh_charge_for	fin_designparamcode	Char(5)	Yes	Billing head charge for	No
bh_billhead	fin_billhead	Char(100)	No	Billing head	Yes
bh_description	fin_comments	Char(255)	Yes	Billing head Description	No
bh_charge_type	fin_designparamcode	Char(5)	Yes	Billing head charge type	No
bh_billing_units	fin_unit	Char(100)	Yes	Billing head units	No
bh_flight_ops_type	fin_quickcodes	Char(25)	Yes	Billing head Flight ops type	No
bh_flight_ctgy	fin_quickcodes	Char(25)	Yes	Billing head flight category	No
bh_status	fin_status	Char(25)	Yes	Billing head status	No
bh_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
bh_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
bh_created_date	fin_date	Date(11)	Yes	Created date	No
bh_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
bh_modified_date	fin_date	Date(11)	Yes	Modified date	No

Table Name :	fos_dutycrew_map_dtl
Comment :	Duty crew map details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
dcm_ouinstance	fin_ctxt_ouinstance	Int(4)	No	ouinstance	Yes
dcm_duty_type	fin_activity	Char(40)	No	Crew map duty type	Yes
dcm_crew_type	fin_quickcodes	Char(25)	No	Crew type	Yes
dcm_status	fin_status	Char(25)	Yes	Crew map status	No
dcm_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
dcm_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
dcm_created_date	fin_date	Date(11)	Yes	Created date	No
dcm_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
dcm_modified_date	fin_date	Date(11)	Yes	Modified date	No

Table Name :	fos_duty_type_mst
Comment :	Duty type master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
dt_ouinstance	fin_ctxt_ouinstance	Int(4)	No	Ouinstance	Yes
dt_duty_type	fin_activity	Char(40)	No	Duty type	Yes
dt_description	fin_txt255	Char(255)	Yes	Duty type description	No
dt_unit	fin_unit	Char(100)	Yes	Duty type unit	No
dt_timestamp	fin_timestamp	Int(4)	Yes	Timestamp	No
dt_createdby	fin_ctxt_user	Char(30)	Yes	Created by	No
dt_created_date	fin_date	Date(11)	Yes	Created date	No
dt_modifiedby	fin_ctxt_user	Char(30)	Yes	Modified by	No
dt_modified_date	fin_date	Date(11)	Yes	Modified date	No