Data Dictionary -- Reliability Analysis

Srl. No.	Table Name	Comment
1	BasRA_ADD_Analyze_Discrepacny_Dtl	Additional Analyze discrepancy details table
2	BasRA_Aircraft_Parameter_dtl	BasRA parameter details table
3	BasRA_Aircraft_Parameter_dtl_2009_his	Parameter details histroy 2009 table
4	BasRA_Aircraft_Part_Parameter_dtl	Part parameter details table
5	BasRA_Aircraft_Part_Parameter_dtl_2009_his	Part parameter histroy 2009 table
6	BasRA_delay_discrepancy_incident_dtl	Delay discrepancy incident details table
7	BasRA_delay_discrepancy_incident_dtl_2009_his	Delay discrepancy incident 2009 histroy table
8	BASRA_ERROR_LOG_TABLE	Error log table
9	BasRa_ExeclRpt_Version	Excel report version table
10	BasRA_Fleet_ACWiseProcessing_dtl	Aircraft wise processing details table
11	BasRA_Fleet_ACWiseProcessing_dtl_2009_his	Aircraft wise processing details histroy 2009 table
12	BASRA_Fleet_ACwise_CompProcessing_Dtl	Aircraft wise component processing details table
13	BASRA_Fleet_ACwise_CompProcessing_Dtl_2009_his	Aircraft wise component processing details 2009 histroy table
14	BASRA_Fleet_ACwise_PartProcessing_Dtl	Aircraft wise Part processing details table
15	BASRA_Fleet_ACwise_PartProcessing_Dtl_2009_his	Aircraft wise Part processing details histroy 2009 table
16	BasRA_Fleet_ATAStationwise_Processing_dtl	Aircraft wise ATA processing details table
17	BasRA_Fleet_ATAStationwise_Processing_dtl_2009_his	Aircraft wise ATA processing details histroy 2009 table
18	BasRA_fleet_Status_dtl	Fleet status details table
19	BasRA_Fleet_SysATA_Processing_dtl	System ATA processing details table
20	BasRA_Fleet_SysATA_Processing_dtl_2009_his	System ATA processing details 2009 histroy table
21	basra_fltalert_alertvalue_dtl	Flight alert value details table
22	basra_fltalert_alertvalue_hdr	Flight alert value header table
23	BASRA_Graph_DelayMjrSysATA	Graph delay major system ATA table
24	BASRA_Graph_DelaySysATA	Graph delay system ATA table
25	BASRA_Graph_OtherThnDelCan	Graph other than delay table
26	BasRA_Journey_Log_dtl	Journey log details table
27	BasRA_Journey_Log_dtl_2009_his	Journey log details histroy table 2009
28	BASRA_last_Upload_datetime	Last upload datetime
29	basra_parameter_details_dtl	Parameter details table
30	BasRA_processed_delay_discrepancy_incident_dtl	Processed delay discrepancyincident details table
31	BasRA_processed_delay_discrepancy_incident_dtl_2009_his	Processed delay discrepancyincident details histroy 2009 table
32	Basra_Process_Scheduler	Process scheduler table
33	basra_qc_quick_codes	Quick code details table
34	basra_raconrpt_config_rpt_dtl	Configuration report details table
35	BASRA_RACRDTL_COMPONENT_REPLACEMENT_DTL	Component replacement details table
36	basra_rafltac_fleet_aircraft_dtl	Fleet aircraft details table
37	basra_rafltata_fleet_ata_dtl	Fleet aircraft ATA details table
38	basra_raflt_fleet_dtl	Fleet details table
39	BASRA_raipd_Inquire_PrtHis_Dtl	Rapid inquire part histroy table
40	BasRa_Rel_Graph	Release graph
41	BASRA_RRSD_Reliability_Reports_Dtl	Reliability report details table
42	BASRA_RRSH_Reliability_Reports_Hdr	Reliability reports header table
43	basra_set_option_dtl	Set option details table
44	basra_set_option_hdr	Set option header table
45	basra_set_option_param_values	Set option parameter values
46	BASRA_SET_OPTION_PERMIT_VALUES	Set option param values table
47	BASRA_UDHDR_Upload_reliability_Data_Hdr	Upload reliability data header table
48	Basra_Upload_Scheduler	Upload scheduler table

Table Name :	BasRA_ADD_Analyze_Discrepacny_Dtl
Comment :	Additional Analyze discrepancy details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
add_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
add_discrepancyNo	udd_documentno	varchar(40)	No	discrepancyNo	Yes
add_disc_Desc	udd_txt255	varchar(255)	Yes	discrepancy Description	No
add_Disc_ATA	udd_atanumber	varchar(16)	Yes	discrepancy ATA Number	No
add_Remidial_Action_Summary	udd_txt2000	varchar(2000)	Yes	Remidial Action Summary	No
add_Rel_Ana_Req	udd_flag2	varchar(25)	Yes	Rel Ana Req	No
Add_Recurring_Disc	udd_flag2	varchar(25)	Yes	Recurring discrepancy	No
add_RD_Analysis	udd_flag2	varchar(25)	Yes	RD Analysis	No
add_Remarks	udd_txt255	varchar(255)	Yes	Remarks	No
add_created_user	udd_ctxt_user	varchar(30)	Yes	created user	No
add_createddate	_datetime_8	datetime(8)	Yes	created date	No
add_modifieduser	udd_ctxt_user	varchar(30)	Yes	modified user	No
add_modifieddate	_datetime_8	datetime(8)	Yes	modified date	No
add_timestamp	udd_timestamp	int(4)	Yes	timestamp	No
add_Processed_by	udd_ctxt_user	varchar(30)	Yes	Processed by	No
add_Processed_date	_datetime_8	datetime(8)	Yes	Processed date	No
add_rec_corrective_action	udd_designparamcode	varchar(5)	Yes	rec corrective action	No

Table Name :	BasRA_Aircraft_Parameter_dtl
Comment :	BasRA parameter details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
raapdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance CODE	No
raapdtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
raapdtl_AC_Regno	udd_aircraftnumber	varchar(30)	Yes	Aircraft Regno	No
raapdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
raapdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective number Month	No
raapdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
raapdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective number Year	No
raapdtl_RA_Trandoc_flag	udd_flag2	varchar(25)	Yes	RA Trandoc flag	No
raapdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
raapdtl_RA_ReqYesno_flag	udd_designparamcode	varchar(5)	Yes	RA ReqYesno flag	No
raapdtl_Model	udd_model	varchar(20)	Yes	Model number	No
raapdtl_MSN	UDD_Manufacturerserialnum	varchar(40)	Yes	MSN number	No
raapdtl_Induction_Date	_datetime_8	datetime(8)	Yes	Induction Date	No
raapdtl_Ac_Group	udd_groupid	varchar(20)	Yes	Aircraft Group	No
raapdtl_Engine_Part	udd_txt255	varchar(255)	Yes	Engine Part number	No
raapdtl_APU_Part	udd_txt255	varchar(255)	Yes	APU Part part	No
raapdtl_Config_class	udd_configid	varchar(30)	Yes	Config class	No
raapdtl_ETOP_flag	udd_designparamcode	varchar(5)	Yes	ETOP flag	No
raapdtl_Param_Va1	udd_numericparamval	numeric(13)	Yes	Param Va1	No
raapdtl_Param_CumVa1	udd_numericparamval	numeric(13)	Yes	Param CumVa1	No
raapdtl_Param_code	udd_parameter	varchar(40)	Yes	Param code	No
raapdtl_Created_date	_datetime_8	datetime(8)	Yes	Created date	No
raapdtl_Created_by	udd_ctxt_user	varchar(30)	Yes	Created by	No
raapdtl_Modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
raapdtl_Modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
raapdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
raapdtl_Operating_Paramval	udd_numericparamval	numeric(13)	Yes	Operating Paramval	No
raapdtl_Revenue_Paramval	udd_numericparamval	numeric(13)	Yes	Revenue Paramval	No
raapdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_Aircraft_Parameter_dtl_2009_his
Comment :	Parameter details histroy 2009 table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
raapdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance ID	No
raapdtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
raapdtl_AC_Regno	udd_aircraftnumber	varchar(30)	Yes	AC Regno	No
raapdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
raapdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
raapdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
raapdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
raapdtl_RA_Trandoc_flag	udd_flag2	varchar(25)	Yes	RA Trandoc flag	No
raapdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
raapdtl_RA_ReqYesno_flag	udd_designparamcode	varchar(5)	Yes	RA ReqYesno flag	No
raapdtl_Model	udd_model	varchar(20)	Yes	Model	No
raapdtl_MSN	UDD_Manufacturerserialnum	varchar(40)	Yes	MSN	No
raapdtl_Induction_Date	_datetime_8	datetime(8)	Yes	Induction Date	No
raapdtl_Ac_Group	udd_groupid	varchar(20)	Yes	Ac Group	No
raapdtl_Engine_Part	udd_txt255	varchar(255)	Yes	Engine Part	No
raapdtl_APU_Part	udd_txt255	varchar(255)	Yes	APU Part	No
raapdtl_Config_class	udd_configid	varchar(30)	Yes	Config class	No
raapdtl_ETOP_flag	udd_designparamcode	varchar(5)	Yes	ETOP flag	No
raapdtl_Param_Va1	udd_numericparamval	numeric(13)	Yes	Param Va1	No
raapdtl_Param_CumVa1	udd_numericparamval	numeric(13)	Yes	Param CumVa1	No
raapdtl_Param_code	udd_parameter	varchar(40)	Yes	Param code	No
raapdtl_Created_date	_datetime_8	datetime(8)	Yes	Created date	No
raapdtl_Created_by	udd_ctxt_user	varchar(30)	Yes	Created by	No
raapdtl_Modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
raapdtl_Modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
raapdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
raapdtl_Operating_Paramval	udd_numericparamval	numeric(13)	Yes	Operating Paramval	No
raapdtl_Revenue_Paramval	udd_numericparamval	numeric(13)	Yes	Revenue Paramval	No
raapdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_Aircraft_Part_Parameter_dtl
Comment :	Part parameter details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
raaprtpdtl_OuInstance	udd_ctxt_ouinstance	int(4)	Yes	OuInstance no	No
raaprtpdtl_Fleet	udd_model	varchar(20)	Yes	Fleet	No
raaprtpdtl_Aircraft	udd_aircraftnumber	varchar(30)	Yes	Aircraft	No
raaprtpdtl_Effective_char_month	udd_flag2	varchar(25)	Yes	Effective char month	No
raaprtpdtl_Effective_num_month	udd_count	int(4)	Yes	Effective num month	No
raaprtpdtl_Effective_char_year	udd_flag2	varchar(25)	Yes	Effective char year	No
raaprtpdtl_Effective_num_year	udd_count	int(4)	Yes	Effective num year	No
raaprtpdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
raaprtpdtl_RA_ReqYesno_flag	udd_flag2	varchar(25)	Yes	RA ReqYesno flag	No
raaprtpdtl_Partno	udd_partno	varchar(40)	Yes	Partno	No
raaprtpdtl_Serial	UDD_Manufacturerserialnum	varchar(40)	Yes	Serial	No
raaprtpdtl_componentid	udd_componentid	varchar(90)	Yes	componentid	No
raaprtpdtl_ATAno	udd_atanumber	varchar(16)	Yes	ATAno	No
raaprtpdtl_Alternate_yesno	udd_designparamcode	varchar(5)	Yes	Alternate yesno	No
raaprtpdtl_Alternate_srcPart	udd_partno	varchar(40)	Yes	Alternate srcPart	No
raaprtpdtl_Curr_Aircraft	udd_aircraftnumber	varchar(30)	Yes	Curr Aircraft	No
raaprtpdtl_Parttype	udd_designparamcode	varchar(5)	Yes	Parttype	No
raaprtpdtl_Paramcode	udd_parameter	varchar(40)	Yes	Paramcode	No
raaprtpdtl_Paramvalue	udd_numericparamval	numeric(13)	Yes	Paramvalue	No
raaprtpdtl_RA_Createddate	_datetime_8	datetime(8)	Yes	RA Createddate	No
raaprtpdtl_RA_Createdby	udd_ctxt_user	varchar(30)	Yes	RA Createdby	No
raaprtpdtl_RA_Modifieddate	_datetime_8	datetime(8)	Yes	RA Modifieddate	No
raaprtpdtl_RA_Modifiedby	udd_ctxt_user	varchar(30)	Yes	RA Modifiedby	No
raaprtpdtl_RA_Timestamp	udd_count	int(4)	Yes	RA Timestamp	No
raaprtpdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_Aircraft_Part_Parameter_dtl_2009_his
Comment :	Part parameter histroy 2009 table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
raaprtpdtl_OuInstance	udd_ctxt_ouinstance	int(4)	Yes	Ou Instance	No
raaprtpdtl_Fleet	udd_model	varchar(20)	Yes	Fleet	No
raaprtpdtl_Aircraft	udd_aircraftnumber	varchar(30)	Yes	Aircraft	No
raaprtpdtl_Effective_char_month	udd_flag2	varchar(25)	Yes	Effective char month	No
raaprtpdtl_Effective_num_month	udd_count	int(4)	Yes	Effective num month	No
raaprtpdtl_Effective_char_year	udd_flag2	varchar(25)	Yes	Effective char year	No
raaprtpdtl_Effective_num_year	udd_count	int(4)	Yes	Effective num year	No
raaprtpdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
raaprtpdtl_RA_ReqYesno_flag	udd_flag2	varchar(25)	Yes	RA ReqYesno flag	No
raaprtpdtl_Partno	udd_partno	varchar(40)	Yes	Part Number	No
raaprtpdtl_Serial	UDD_Manufacturerserialnum	varchar(40)	Yes	Serial number	No
raaprtpdtl_componentid	udd_componentid	varchar(90)	Yes	componentid	No
raaprtpdtl_ATAno	udd_atanumber	varchar(16)	Yes	ATAno	No
raaprtpdtl_Alternate_yesno	udd_designparamcode	varchar(5)	Yes	Alternate Yes or No	No
raaprtpdtl_Alternate_srcPart	udd_partno	varchar(40)	Yes	Alternate part number	No
raaprtpdtl_Curr_Aircraft	udd_aircraftnumber	varchar(30)	Yes	Current Aircraft number	No
raaprtpdtl_Parttype	udd_designparamcode	varchar(5)	Yes	Part type	No
raaprtpdtl_Paramcode	udd_parameter	varchar(40)	Yes	Parameter code	No
raaprtpdtl_Paramvalue	udd_numericparamval	numeric(13)	Yes	Parameter value	No
raaprtpdtl_RA_Createddate	_datetime_8	datetime(8)	Yes	RA Createddate	No
raaprtpdtl_RA_Createdby	udd_ctxt_user	varchar(30)	Yes	RA Createdby	No
raaprtpdtl_RA_Modifieddate	_datetime_8	datetime(8)	Yes	RA Modifieddate	No
raaprtpdtl_RA_Modifiedby	udd_ctxt_user	varchar(30)	Yes	RA Modifiedby	No
raaprtpdtl_RA_Timestamp	udd_count	int(4)	Yes	RA Timestamp	No
raaprtpdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_delay_discrepancy_incident_dtl
Comment :	Delay discrepancy incident details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
raddidtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ou instance	No
raddidtl_RA_Trandoc_flag	udd_flag2	varchar(25)	Yes	RA Trandoc flag	No
raddidtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
raddidtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
raddidtl_AC_Regno	udd_aircraftnumber	varchar(30)	Yes	AC Regno	No
raddidtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
raddidtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
raddidtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
raddidtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
raddidtl_RA_ReqYesno_flag	udd_designparamcode	varchar(5)	Yes	RA ReqYesno flag	No
raddidtl_Tran_Document_no	udd_documentno	varchar(40)	Yes	Tran Document no	No
raddidtl_Tran_Document_lineno	udd_count	int(4)	Yes	Tran Document lineno	No
raddidtl_Tran_Document_legno	udd_count	int(4)	Yes	Tran Document legno	No
raddidtl_Tran_date	_datetime_8	datetime(8)	Yes	Tran date	No
raddidtl_Tran_Status_flag	udd_flag2	varchar(25)	Yes	Tran Status flag	No
raddidtl_Src_Doc_Type	udd_designparamcode	varchar(5)	Yes	Src Doc Type	No
raddidtl_Src_Doc_No	udd_documentno	varchar(40)	Yes	Src Doc No	No
raddidtl_Src_Doc_Desc	udd_txt2000	varchar(2000)	Yes	Src Doc Desc	No
raddidtl_Category_Type	udd_quickcodes	varchar(25)	Yes	Category Type	No
raddidtl_station_number	udd_wccode	varchar(30)	Yes	station number	No
raddidtl_ATAno	udd_atanumber	varchar(16)	Yes	ATAno	No
raddidtl_Delay_Duration	udd_duration	numeric(13)	Yes	Delay Duration	No
raddidtl_Applicability	udd_flag	varchar(25)	Yes	Applicability	No
raddidtl_Reported_by	udd_hrempcode	varchar(20)	Yes	Reported by	No
raddidtl_Resolved_date	_datetime_8	datetime(8)	Yes	Resolved date	No
raddidtl_Transfer_Partno	udd_partno	varchar(40)	Yes	Transfer Partno	No
raddidtl_Transfer_serialno	UDD_Manufacturerserialnum	varchar(40)	Yes	Transfer serialno	No
raddidtl_Remedial_Act	udd_txt2000	varchar(2000)	Yes	Remedial Act	No
raddidtl_Remarks	udd_txt2000	varchar(2000)	Yes	Remarks	No
raddidtl_Description	udd_txt2000	varchar(2000)	Yes	Description	No
raddidtl_Reason	udd_txt2000	varchar(2000)	Yes	Reason	No
raddidtl_Discrepancyno	udd_documentno	varchar(40)	Yes	Discrepancyno	No
raddidtl_Occurrence_location	udd_location	varchar(16)	Yes	Occurrence location	No
raddidtl_Phase_of_Occ	udd_flag2	varchar(25)	Yes	Phase of Occ	No
raddidtl_delay_on	udd_flag2	varchar(25)	Yes	delay on	No
raddidtl_Tran_Created_date	_datetime_8	datetime(8)	Yes	Tran Created date	No
raddidtl_Tran_Created_by	udd_ctxt_user	varchar(30)	Yes	Tran Created by	No
raddidtl_Tran_Confirmed_date	_datetime_8	datetime(8)	Yes	Tran Confirmed date	No
raddidtl_Tran_Confirmed_By	udd_ctxt_user	varchar(30)	Yes	Tran Confirmed By	No
raddidtl_RA_Created_date	_datetime_8	datetime(8)	Yes	RA Created date	No
raddidtl_RA_Created_by	udd_ctxt_user	varchar(30)	Yes	RA Created by	No
raddidtl_RA_Modified_date	_datetime_8	datetime(8)	Yes	RA Modified date	No
raddidtl_RA_Modified_by	udd_ctxt_user	varchar(30)	Yes	RA Modified by	No
raddidtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
raddidtl_flight_no	udd_fltno	varchar(30)	Yes	flight no	No
raddidtl_Pos_code	udd_flag2	varchar(25)	Yes	Pos code	No
raddidtl_shutdown_datetime	_datetime_8	datetime(8)	Yes	shutdown datetime	No
raddidtl_Restart_datetime	_datetime_8	datetime(8)	Yes	Restart datetime	No
raddidtl_param_code	udd_paramcode	varchar(30)	Yes	Parameter code	No
raddidtl_pos_type	udd_designparamcode	varchar(5)	Yes	Position type	No
raddidtl_component_id	udd_componentid	varchar(90)	Yes	component id	No
raddidtl_Param_val	udd_flag2	varchar(25)	Yes	Parameter valure	No
raddidtl_levelno	udd_quantity	numeric(13)	Yes	Level number	No
raddidtl_Processing_status	udd_flag2	varchar(25)	Yes	Processing status	No
raddidtl_Tracking_status	udd_flag2	varchar(25)	Yes	Tracking status	No
raddidtl_Disc_Category	udd_flag2	varchar(25)	Yes	Disc Category	No
raddidtl_Lotno	udd_lotno	varchar(18)	Yes	Lot number	No
raddidtl_quantity	udd_quantity	numeric(13)	Yes	quantity	No
raddidtl_Parttype	udd_designparamcode	varchar(5)	Yes	Part type	No
raddidtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_delay_discrepancy_incident_dtl_2009_his
Comment :	Delay discrepancy incident 2009 histroy table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
raddidtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ou instance no	No
raddidtl_RA_Trandoc_flag	udd_flag2	varchar(25)	Yes	RA Trandoc flag	No
raddidtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
raddidtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
raddidtl_AC_Regno	udd_aircraftnumber	varchar(30)	Yes	AC Regno	No
raddidtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
raddidtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
raddidtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
raddidtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
raddidtl_RA_ReqYesno_flag	udd_designparamcode	varchar(5)	Yes	RA ReqYesno flag	No
raddidtl_Tran_Document_no	udd_documentno	varchar(40)	Yes	Tran Document no	No
raddidtl_Tran_Document_lineno	udd_count	int(4)	Yes	Tran Document lineno	No
raddidtl_Tran_Document_legno	udd_count	int(4)	Yes	Tran Document legno	No
raddidtl_Tran_date	_datetime_8	datetime(8)	Yes	Tran date	No
raddidtl_Tran_Status_flag	udd_flag2	varchar(25)	Yes	Tran Status flag	No
raddidtl_Src_Doc_Type	udd_designparamcode	varchar(5)	Yes	Source document type	No
raddidtl_Src_Doc_No	udd_documentno	varchar(40)	Yes	Source document number	No
raddidtl_Src_Doc_Desc	udd_txt2000	varchar(2000)	Yes	Source document description	No
raddidtl_Category_Type	udd_quickcodes	varchar(25)	Yes	Category Type	No
raddidtl_station_number	udd_wccode	varchar(30)	Yes	station number	No
raddidtl_ATAno	udd_atanumber	varchar(16)	Yes	ATA number	No
raddidtl_Delay_Duration	udd_duration	numeric(13)	Yes	Delay Duration	No
raddidtl_Applicability	udd_flag	varchar(25)	Yes	Applicability	No
raddidtl_Reported_by	udd_hrempcode	varchar(20)	Yes	Reported by	No
raddidtl_Resolved_date	_datetime_8	datetime(8)	Yes	Resolved date	No
raddidtl_Transfer_Partno	udd_partno	varchar(40)	Yes	Transfer Partno	No
raddidtl_Transfer_serialno	UDD_Manufacturerserialnum	varchar(40)	Yes	Transfer serialno	No
raddidtl_Remedial_Act	udd_txt2000	varchar(2000)	Yes	Remedial Act	No
raddidtl_Remarks	udd_txt2000	varchar(2000)	Yes	Remarks	No
raddidtl_Description	udd_txt2000	varchar(2000)	Yes	Description	No
raddidtl_Reason	udd_txt2000	varchar(2000)	Yes	Reason	No
raddidtl_Discrepancyno	udd_documentno	varchar(40)	Yes	Discrepancyno	No
raddidtl_Occurrence_location	udd_location	varchar(16)	Yes	Occurrence location	No
raddidtl_Phase_of_Occ	udd_flag2	varchar(25)	Yes	Phase of Occ	No
raddidtl_delay_on	udd_flag2	varchar(25)	Yes	delay on	No
raddidtl_Tran_Created_date	_datetime_8	datetime(8)	Yes	Tran Created date	No
raddidtl_Tran_Created_by	udd_ctxt_user	varchar(30)	Yes	Tran Created by	No
raddidtl_Tran_Confirmed_date	_datetime_8	datetime(8)	Yes	Tran Confirmed date	No
raddidtl_Tran_Confirmed_By	udd_ctxt_user	varchar(30)	Yes	Tran Confirmed By	No
raddidtl_RA_Created_date	_datetime_8	datetime(8)	Yes	RA Created date	No
raddidtl_RA_Created_by	udd_ctxt_user	varchar(30)	Yes	RA Created by	No
raddidtl_RA_Modified_date	_datetime_8	datetime(8)	Yes	RA Modified date	No
raddidtl_RA_Modified_by	udd_ctxt_user	varchar(30)	Yes	RA Modified by	No
raddidtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
raddidtl_flight_no	udd_fltno	varchar(30)	Yes	Flight number	No
raddidtl_Pos_code	udd_flag2	varchar(25)	Yes	Position code	No
raddidtl_shutdown_datetime	_datetime_8	datetime(8)	Yes	shutdown datetime	No
raddidtl_Restart_datetime	_datetime_8	datetime(8)	Yes	Restart datetime	No
raddidtl_param_code	udd_paramcode	varchar(30)	Yes	Parameter code	No
raddidtl_pos_type	udd_designparamcode	varchar(5)	Yes	Position type	No
raddidtl_component_id	udd_componentid	varchar(90)	Yes	component id	No
raddidtl_Param_val	udd_flag2	varchar(25)	Yes	Paramater value	No
raddidtl_levelno	udd_quantity	numeric(13)	Yes	Level number	No
raddidtl_Processing_status	udd_flag2	varchar(25)	Yes	Processing status	No
raddidtl_Tracking_status	udd_flag2	varchar(25)	Yes	Tracking status	No
raddidtl_Disc_Category	udd_flag2	varchar(25)	Yes	Disc Category	No
raddidtl_Lotno	udd_lotno	varchar(18)	Yes	Lot #	No
raddidtl_quantity	udd_quantity	numeric(13)	Yes	quantity	No
raddidtl_Parttype	udd_designparamcode	varchar(5)	Yes	Part type	No
raddidtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BASRA_ERROR_LOG_TABLE
Comment :	Error log table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	OU INSTANCE id	No
MONTH_RPT	udd_flag	varchar(25)	Yes	Month report	No
YEAR_RPT	udd_flag	varchar(25)	Yes	Year report	No
RPT_NAME	udd_txt2000	varchar(2000)	Yes	Peprot Name	No
ERRONO	udd_count	int(4)	Yes	Error Number	No
ERRODESC	udd_txt2000	varchar(2000)	Yes	Error Description	No
GeneratedBy	udd_ctxt_user	varchar(30)	Yes	Generated By	No
GenratedDate	_datetime_8	datetime(8)	Yes	Genrated Date	No

Table Name :	BasRa_ExeclRpt_Version
Comment :	Excel report version table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ERV_ReportName	udd_txt150	varchar(150)	Yes	ERV Report Name	No
ERV_TemplateName	udd_txt150	varchar(150)	Yes	ERV Template Name	No
ERV_VersionNo	udd_seqno	int(4)	Yes	ERV Version No	No
ERV_ModifiedDate	_datetime_8	datetime(8)	Yes	ERV Modified Date	No

Table Name :	BasRA_Fleet_ACWiseProcessing_dtl
Comment :	Aircraft wise processing details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafacpdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ou instance number	No
rafacpdtl_Fleet_no	udd_model	varchar(20)	No	Fleet no	No
rafacpdtl_Ac_Regno	udd_aircraftnumber	varchar(30)	No	Ac Regno	No
rafacpdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
rafacpdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
rafacpdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
rafacpdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
rafacpdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rafacpdtl_no_of_aircrafts	udd_count	int(4)	Yes	Number Of aircrafts	No
rafacpdtl_no_of_calenderdays	udd_count	int(4)	Yes	Number Of calenderdays	No
rafacpdtl_no_of_departures	udd_count	int(4)	Yes	Number Of departures	No
rafacpdtl_no_of_ServiceDays	udd_count	int(4)	Yes	Number Of ServiceDays	No
rafacpdtl_no_of_RevenuvDept	udd_count	int(4)	Yes	Number Of RevenuvDept	No
rafacpdtl_no_of_NonRevDept	udd_count	int(4)	Yes	Number Of NonRevDept	No
rafacpdtl_no_of_incidents	udd_count	int(4)	Yes	Number Of incidents	No
rafacpdtl_no_of_Delays	udd_count	int(4)	Yes	Number Of Delays	No
rafacpdtl_no_of_Substitutions	udd_count	int(4)	Yes	Number Of Substitutions	No
rafacpdtl_no_of_Cancel	udd_count	int(4)	Yes	Number Of Cancel	No
rafacpdtl_no_of_otherinterr	udd_count	int(4)	Yes	Number Of otherinterr	No
rafacpdtl_no_of_discrepancy	udd_count	int(4)	Yes	Number Of discrepancy	No
rafacpdtl_no_of_ADDS	udd_count	int(4)	Yes	Number Of ADDS	No
rafacpdtl_no_of_MEL	udd_count	int(4)	Yes	Number Of MEL	No
rafacpdtl_no_of_techDelays	udd_count	int(4)	Yes	Number Of techDelays	No
rafacpdtl_no_of_techSubstitution	udd_count	int(4)	Yes	Number Of techSubstitution	No
rafacpdtl_no_of_techCancel	udd_count	int(4)	Yes	Number Of techCancel	No
rafacpdtl_Created_date	_datetime_8	datetime(8)	Yes	Created date	No
rafacpdtl_Created_by	udd_ctxt_user	varchar(30)	Yes	Created by	No
rafacpdtl_Modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
rafacpdtl_Modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
rafacpdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
rafacpdtl_no_of_ATB	udd_count	int(4)	Yes	Number Of ATB	No
rafacpdtl_no_of_GTB	udd_count	int(4)	Yes	Number Of GTB	No
rafacpdtl_no_of_Diversions	udd_count	int(4)	Yes	Number Of Diversions	No
rafacpdtl_no_of_techATB	udd_count	int(4)	Yes	Number Of techATB	No
rafacpdtl_no_of_techGTB	udd_count	int(4)	Yes	Number Of techGTB	No
rafacpdtl_no_of_techDiversion	udd_count	int(4)	Yes	Number Of techDiversion	No
rafacpdtl_no_of_InFltShutdwn	udd_count	int(4)	Yes	Number Of InFltShutdwn	No
rafacpdtl_operating_size	udd_count	int(4)	Yes	operating size	No
rafacpdtl_no_of_MIREPdiscrepancy	udd_count	int(4)	Yes	Number Of MIREPdiscrepancy	No
rafacpdtl_no_of_PIREPdiscrepancy	udd_count	int(4)	Yes	Number Of PIREPdiscrepancy	No
rafacpdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_Fleet_ACWiseProcessing_dtl_2009_his
Comment :	Aircraft wise processing details histroy 2009 table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafacpdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance2	No
rafacpdtl_Fleet_no	udd_model	varchar(20)	No	Fleet no	No
rafacpdtl_Ac_Regno	udd_aircraftnumber	varchar(30)	No	Ac Regno	No
rafacpdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
rafacpdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
rafacpdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
rafacpdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
rafacpdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rafacpdtl_no_of_aircrafts	udd_count	int(4)	Yes	Number Of aircrafts	No
rafacpdtl_no_of_calenderdays	udd_count	int(4)	Yes	Number Of calenderdays	No
rafacpdtl_no_of_departures	udd_count	int(4)	Yes	Number Of departures	No
rafacpdtl_no_of_ServiceDays	udd_count	int(4)	Yes	Number Of ServiceDays	No
rafacpdtl_no_of_RevenuvDept	udd_count	int(4)	Yes	Number Of RevenuvDept	No
rafacpdtl_no_of_NonRevDept	udd_count	int(4)	Yes	Number Of NonRevDept	No
rafacpdtl_no_of_incidents	udd_count	int(4)	Yes	Number Of incidents	No
rafacpdtl_no_of_Delays	udd_count	int(4)	Yes	Number Of Delays	No
rafacpdtl_no_of_Substitutions	udd_count	int(4)	Yes	Number Of Substitutions	No
rafacpdtl_no_of_Cancel	udd_count	int(4)	Yes	Number Of Cancel	No
rafacpdtl_no_of_otherinterr	udd_count	int(4)	Yes	Number Of otherinterr	No
rafacpdtl_no_of_discrepancy	udd_count	int(4)	Yes	Number Of discrepancy	No
rafacpdtl_no_of_ADDS	udd_count	int(4)	Yes	Number Of ADDS	No
rafacpdtl_no_of_MEL	udd_count	int(4)	Yes	Number Of MEL	No
rafacpdtl_no_of_techDelays	udd_count	int(4)	Yes	Number Of techDelays	No
rafacpdtl_no_of_techSubstitution	udd_count	int(4)	Yes	Number Of techSubstitution	No
rafacpdtl_no_of_techCancel	udd_count	int(4)	Yes	Number Of techCancel	No
rafacpdtl_Created_date	_datetime_8	datetime(8)	Yes	Created date	No
rafacpdtl_Created_by	udd_ctxt_user	varchar(30)	Yes	Created by	No
rafacpdtl_Modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
rafacpdtl_Modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
rafacpdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
rafacpdtl_no_of_ATB	udd_count	int(4)	Yes	Number Of ATB	No
rafacpdtl_no_of_GTB	udd_count	int(4)	Yes	Number Of GTB	No
rafacpdtl_no_of_Diversions	udd_count	int(4)	Yes	Number Of Diversions	No
rafacpdtl_no_of_techATB	udd_count	int(4)	Yes	Number Of techATB	No
rafacpdtl_no_of_techGTB	udd_count	int(4)	Yes	Number Of techGTB	No
rafacpdtl_no_of_techDiversion	udd_count	int(4)	Yes	Number Of techDiversion	No
rafacpdtl_no_of_InFltShutdwn	udd_count	int(4)	Yes	Number Of InFltShutdwn	No
rafacpdtl_operating_size	udd_count	int(4)	Yes	operating size	No
rafacpdtl_no_of_MIREPdiscrepancy	udd_count	int(4)	Yes	Number Of MIREPdiscrepancy	No
rafacpdtl_no_of_PIREPdiscrepancy	udd_count	int(4)	Yes	Number Of PIREPdiscrepancy	No
rafacpdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BASRA_Fleet_ACwise_CompProcessing_Dtl
Comment :	Aircraft wise component processing details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafaccmpdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance3	No
rafaccmpdtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
rafaccmpdtl_Ac_Regno	udd_aircraftnumber	varchar(30)	Yes	Ac Regno	No
rafaccmpdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
rafaccmpdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
rafaccmpdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
rafaccmpdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
rafaccmpdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rafaccmpdtl_Comp_flag	udd_flag2	varchar(25)	Yes	Comp flag	No
rafaccmpdtl_no_of_schremovals	udd_count	int(4)	Yes	Number Of schremovals	No
rafaccmpdtl_no_of_unschremovals	udd_count	int(4)	Yes	Number Of unschremovals	No
rafaccmpdtl_no_of_othremovals	udd_count	int(4)	Yes	Number Of othremovals	No
rafaccmpdtl_no_of_PlnShpVst	udd_count	int(4)	Yes	Number Of PlnShpVst	No
rafaccmpdtl_no_of_UnPlnShpVst	udd_count	int(4)	Yes	Number Of UnPlnShpVst	No
rafaccmpdtl_RA_Created_date	_datetime_8	datetime(8)	Yes	RA Created date	No
rafaccmpdtl_RA_Created_by	udd_ctxt_user	varchar(30)	Yes	RA Created by	No
rafaccmpdtl_RA_Modified_date	_datetime_8	datetime(8)	Yes	RA Modified date	No
rafaccmpdtl_RA_Modified_by	udd_ctxt_user	varchar(30)	Yes	RA Modified by	No
rafaccmpdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
rafaccmpdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BASRA_Fleet_ACwise_CompProcessing_Dtl_2009_his
Comment :	Aircraft wise component processing details 2009 histroy table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafaccmpdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance4	No
rafaccmpdtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
rafaccmpdtl_Ac_Regno	udd_aircraftnumber	varchar(30)	Yes	Aircraft registration number	No
rafaccmpdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
rafaccmpdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
rafaccmpdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
rafaccmpdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
rafaccmpdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rafaccmpdtl_Comp_flag	udd_flag2	varchar(25)	Yes	Comp flag	No
rafaccmpdtl_no_of_schremovals	udd_count	int(4)	Yes	Number Of schremovals	No
rafaccmpdtl_no_of_unschremovals	udd_count	int(4)	Yes	Number Of unschremovals	No
rafaccmpdtl_no_of_othremovals	udd_count	int(4)	Yes	Number Of othremovals	No
rafaccmpdtl_no_of_PlnShpVst	udd_count	int(4)	Yes	Number Of PlnShpVst	No
rafaccmpdtl_no_of_UnPlnShpVst	udd_count	int(4)	Yes	Number Of UnPlnShpVst	No
rafaccmpdtl_RA_Created_date	_datetime_8	datetime(8)	Yes	RA Created date	No
rafaccmpdtl_RA_Created_by	udd_ctxt_user	varchar(30)	Yes	RA Created by	No
rafaccmpdtl_RA_Modified_date	_datetime_8	datetime(8)	Yes	RA Modified date	No
rafaccmpdtl_RA_Modified_by	udd_ctxt_user	varchar(30)	Yes	RA Modified by	No
rafaccmpdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
rafaccmpdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BASRA_Fleet_ACwise_PartProcessing_Dtl
Comment :	Aircraft wise Part processing details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafacprtpdtl_OuInstance	udd_ctxt_ouinstance	int(4)	Yes	OuInstanceid	No
rafacprtpdtl_Fleet	udd_model	varchar(20)	Yes	Fleet	No
rafacprtpdtl_Aircraft	udd_aircraftnumber	varchar(30)	Yes	Aircraft	No
rafacprtpdtl_Effective_char_month	udd_flag2	varchar(25)	Yes	Effective char month	No
rafacprtpdtl_Effective_num_month	udd_count	int(4)	Yes	Effective num month	No
rafacprtpdtl_Effective_char_year	udd_flag2	varchar(25)	Yes	Effective char year	No
rafacprtpdtl_Effective_num_year	udd_count	int(4)	Yes	Effective num year	No
rafacprtpdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rafacprtpdtl_RA_ReqYesno_flag	udd_flag2	varchar(25)	Yes	RA ReqYesno flag	No
rafacprtpdtl_Partno	udd_partno	varchar(40)	Yes	Partno	No
rafacprtpdtl_Serial	UDD_Manufacturerserialnum	varchar(40)	Yes	Serial	No
rafacprtpdtl_ATAno	udd_atanumber	varchar(16)	Yes	ATA number	No
rafacprtpdtl_Alternate_yesno	udd_designparamcode	varchar(5)	Yes	Alternate yesno	No
rafacprtpdtl_Alternate_srcPart	udd_partno	varchar(40)	Yes	Alternate srcPart	No
rafacprtpdtl_Parttype	udd_designparamcode	varchar(5)	Yes	Parttype	No
rafacprtpdtl_QtyPerAircraft	udd_count	int(4)	Yes	QtyPerAircraft	No
rafacprtpdtl_ScheduleRemovals	udd_count	int(4)	Yes	ScheduleRemovals	No
rafacprtpdtl_UnScheduleRemovals	udd_count	int(4)	Yes	UnScheduleRemovals	No
rafacprtpdtl_OtherRemovals	udd_count	int(4)	Yes	OtherRemovals	No
rafacprtpdtl_plnd_Shopvisit	udd_count	int(4)	Yes	plnd Shopvisit	No
rafacprtpdtl_Unplnd_Shopvisit	udd_count	int(4)	Yes	Unplnd Shopvisit	No
rafacprtpdtl_MTBUR	udd_numericparamval	numeric(13)	Yes	MTBUR	No
rafacprtpdtl_12month_MTBUR	udd_numericparamval	numeric(13)	Yes	12month MTBUR	No
rafacprtpdtl_Sinceincept_MTBUR	udd_numericparamval	numeric(13)	Yes	Sinceincept MTBUR	No
rafacprtpdtl_NFF	udd_count	int(4)	Yes	NFF	No
rafacprtpdtl_RA_Createddate	_datetime_8	datetime(8)	Yes	RA Createddate	No
rafacprtpdtl_RA_Createdby	udd_ctxt_user	varchar(30)	Yes	RA Createdby	No
rafacprtpdtl_RA_Modifieddate	_datetime_8	datetime(8)	Yes	RA Modifieddate	No
rafacprtpdtl_RA_Modifiedby	udd_ctxt_user	varchar(30)	Yes	RA Modifiedby	No
rafacprtpdtl_RA_Timestamp	udd_count	int(4)	Yes	RA Timestamp	No
rafacprtpdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BASRA_Fleet_ACwise_PartProcessing_Dtl_2009_his
Comment :	Aircraft wise Part processing details histroy 2009 table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafacprtpdtl_OuInstance	udd_ctxt_ouinstance	int(4)	Yes	OuInstancecode	No
rafacprtpdtl_Fleet	udd_model	varchar(20)	Yes	Fleet	No
rafacprtpdtl_Aircraft	udd_aircraftnumber	varchar(30)	Yes	Aircraft	No
rafacprtpdtl_Effective_char_month	udd_flag2	varchar(25)	Yes	Effective char month	No
rafacprtpdtl_Effective_num_month	udd_count	int(4)	Yes	Effective num month	No
rafacprtpdtl_Effective_char_year	udd_flag2	varchar(25)	Yes	Effective char year	No
rafacprtpdtl_Effective_num_year	udd_count	int(4)	Yes	Effective num year	No
rafacprtpdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rafacprtpdtl_RA_ReqYesno_flag	udd_flag2	varchar(25)	Yes	RA ReqYesno flag	No
rafacprtpdtl_Partno	udd_partno	varchar(40)	Yes	Part number	No
rafacprtpdtl_Serial	UDD_Manufacturerserialnum	varchar(40)	Yes	Serial number	No
rafacprtpdtl_ATAno	udd_atanumber	varchar(16)	Yes	ATAno	No
rafacprtpdtl_Alternate_yesno	udd_designparamcode	varchar(5)	Yes	Alternate yesno	No
rafacprtpdtl_Alternate_srcPart	udd_partno	varchar(40)	Yes	Alternate srcPart	No
rafacprtpdtl_Parttype	udd_designparamcode	varchar(5)	Yes	Part type	No
rafacprtpdtl_QtyPerAircraft	udd_count	int(4)	Yes	Quantity per Aircraft	No
rafacprtpdtl_ScheduleRemovals	udd_count	int(4)	Yes	Schedule Removals	No
rafacprtpdtl_UnScheduleRemovals	udd_count	int(4)	Yes	UnSchedule Removals	No
rafacprtpdtl_OtherRemovals	udd_count	int(4)	Yes	Other Removals	No
rafacprtpdtl_plnd_Shopvisit	udd_count	int(4)	Yes	Planned shop visit	No
rafacprtpdtl_Unplnd_Shopvisit	udd_count	int(4)	Yes	Unplanned shop visit	No
rafacprtpdtl_MTBUR	udd_numericparamval	numeric(13)	Yes	MTBUR	No
rafacprtpdtl_12month_MTBUR	udd_numericparamval	numeric(13)	Yes	12month MTBUR	No
rafacprtpdtl_Sinceincept_MTBUR	udd_numericparamval	numeric(13)	Yes	Sinceincept MTBUR	No
rafacprtpdtl_NFF	udd_count	int(4)	Yes	NFF	No
rafacprtpdtl_RA_Createddate	_datetime_8	datetime(8)	Yes	RA Created date	No
rafacprtpdtl_RA_Createdby	udd_ctxt_user	varchar(30)	Yes	RA Created by	No
rafacprtpdtl_RA_Modifieddate	_datetime_8	datetime(8)	Yes	RA Modified date	No
rafacprtpdtl_RA_Modifiedby	udd_ctxt_user	varchar(30)	Yes	RA Modified by	No
rafacprtpdtl_RA_Timestamp	udd_count	int(4)	Yes	RA Timestamp	No
rafacprtpdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_Fleet_ATAStationwise_Processing_dtl
Comment :	Aircraft wise ATA processing details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafatastpdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstanceid	No
rafatastpdtl_Fleet_no	udd_model	varchar(20)	No	Fleet no	No
rafatastpdtl_ATAstation_no	udd_atanumber	varchar(16)	No	ATAstation no	No
rafatastpdtl_ATAstation_flag	udd_designparamcode	varchar(5)	No	ATAstation flag	No
rafatastpdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
rafatastpdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
rafatastpdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
rafatastpdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
rafatastpdtl_Effective_num_week	udd_count	int(4)	Yes	Effective num week	No
rafatastpdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rafatastpdtl_no_of_Delays	udd_count	int(4)	Yes	no of Delays	No
rafatastpdtl_no_of_Substitutions	udd_count	int(4)	Yes	no of Substitutions	No
rafatastpdtl_no_of_Cancel	udd_count	int(4)	Yes	no of Cancel	No
rafatastpdtl_no_of_otherinterr	udd_count	int(4)	Yes	no of otherinterr	No
rafatastpdtl_no_of_PIREPdiscrepancy	udd_count	int(4)	Yes	no of PIREPdiscrepancy	No
rafatastpdtl_no_of_MIREPdiscrepancy	udd_count	int(4)	Yes	no of MIREPdiscrepancy	No
rafatastpdtl_Created_date	_datetime_8	datetime(8)	Yes	Created date	No
rafatastpdtl_Created_by	udd_ctxt_user	varchar(30)	Yes	Created by	No
rafatastpdtl_Modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
rafatastpdtl_Modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
rafatastpdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
rafatastpdtl_delay_duration	udd_duration	numeric(13)	Yes	delay duration	No
rafatastpdtl_no_of_ATB	udd_count	int(4)	Yes	no of ATB	No
rafatastpdtl_no_of_GTB	udd_count	int(4)	Yes	no of GTB	No
rafatastpdtl_no_of_Diversions	udd_count	int(4)	Yes	no of Diversions	No
rafatastpdtl_no_of_dept	udd_count	int(4)	Yes	no of dept	No
rafatastpdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_Fleet_ATAStationwise_Processing_dtl_2009_his
Comment :	Aircraft wise ATA processing details histroy 2009 table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafatastpdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	No
rafatastpdtl_Fleet_no	udd_model	varchar(20)	No	Fleet no	No
rafatastpdtl_ATAstation_no	udd_atanumber	varchar(16)	No	ATAstation no	No
rafatastpdtl_ATAstation_flag	udd_designparamcode	varchar(5)	No	ATAstation flag	No
rafatastpdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
rafatastpdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
rafatastpdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
rafatastpdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
rafatastpdtl_Effective_num_week	udd_count	int(4)	Yes	Effective num week	No
rafatastpdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rafatastpdtl_no_of_Delays	udd_count	int(4)	Yes	no of Delays	No
rafatastpdtl_no_of_Substitutions	udd_count	int(4)	Yes	no of Substitutions	No
rafatastpdtl_no_of_Cancel	udd_count	int(4)	Yes	no of Cancel	No
rafatastpdtl_no_of_otherinterr	udd_count	int(4)	Yes	no of otherinterr	No
rafatastpdtl_no_of_PIREPdiscrepancy	udd_count	int(4)	Yes	no of PIREPdiscrepancy	No
rafatastpdtl_no_of_MIREPdiscrepancy	udd_count	int(4)	Yes	no of MIREPdiscrepancy	No
rafatastpdtl_Created_date	_datetime_8	datetime(8)	Yes	Created date	No
rafatastpdtl_Created_by	udd_ctxt_user	varchar(30)	Yes	Created by	No
rafatastpdtl_Modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
rafatastpdtl_Modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
rafatastpdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
rafatastpdtl_delay_duration	udd_duration	numeric(13)	Yes	delay duration	No
rafatastpdtl_no_of_ATB	udd_count	int(4)	Yes	no of ATB	No
rafatastpdtl_no_of_GTB	udd_count	int(4)	Yes	no of GTB	No
rafatastpdtl_no_of_Diversions	udd_count	int(4)	Yes	no of Diversions	No
rafatastpdtl_no_of_dept	udd_count	int(4)	Yes	no of dept	No
rafatastpdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_fleet_Status_dtl
Comment :	Fleet status details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafsdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	No
rafsdtl_Fleet_no	udd_model	varchar(20)	No	Fleet no	No
rafsdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
rafsdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
rafsdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
rafsdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
rafsdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rafsdtl_Gen_date	_datetime_8	datetime(8)	Yes	Generated date	No
rafsdtl_Gen_by	udd_ctxt_user	varchar(30)	Yes	Generated by	No
rafsdtl_Pub_date	_datetime_8	datetime(8)	Yes	Published date	No
rafsdtl_Pub_By	udd_ctxt_user	varchar(30)	Yes	Published by	No
rafsdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
rafsdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_Fleet_SysATA_Processing_dtl
Comment :	System ATA processing details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafsysatadtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
rafsysatadtl_RA_ProSts_flag	udd_designparamcode	varchar(5)	Yes	RA ProSts flag	No
rafsysatadtl_Char_month	udd_flag2	varchar(25)	Yes	Char month	No
rafsysatadtl_Char_year	udd_flag2	varchar(25)	Yes	Char year	No
rafsysatadtl_Int_month	udd_count	int(4)	Yes	Int month	No
rafsysatadtl_Int_year	udd_count	int(4)	Yes	Int year	No
rafsysatadtl_Report_For	_datetime_8	datetime(8)	Yes	Report For	No
rafsysatadtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
rafsysatadtl_ATAFlag	udd_designparamcode	varchar(5)	Yes	ATAFlag	No
rafsysatadtl_Sys_ata	udd_atanumber	varchar(16)	Yes	System ATA number	No
rafsysatadtl_Sys_ata_desc	udd_txt150	varchar(150)	Yes	ATA description	No
rafsysatadtl_Val_id	udd_count	int(4)	Yes	Valid id	No
rafsysatadtl_Dcnt	udd_count	int(4)	Yes	Dcnt	No
rafsysatadtl_Ccnt	udd_count	int(4)	Yes	Ccnt	No
rafsysatadtl_Scnt	udd_count	int(4)	Yes	Scnt	No
rafsysatadtl_Drate	udd_numericparamval	numeric(13)	Yes	Drate	No
rafsysatadtl_Crate	udd_numericparamval	numeric(13)	Yes	Crate	No
rafsysatadtl_Srate	udd_numericparamval	numeric(13)	Yes	Srate	No
rafsysatadtl_DCrate	udd_numericparamval	numeric(13)	Yes	DCrate	No
rafsysatadtl_DCSrate	udd_numericparamval	numeric(13)	Yes	DCSrate	No
rafsysatadtl_Created_date	_datetime_8	datetime(8)	Yes	Created date	No
rafsysatadtl_Created_by	udd_ctxt_user	varchar(30)	Yes	Created by	No
rafsysatadtl_Modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
rafsysatadtl_Modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
rafsysatadtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No

Table Name :	BasRA_Fleet_SysATA_Processing_dtl_2009_his
Comment :	System ATA processing details 2009 histroy table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafsysatadtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
rafsysatadtl_RA_ProSts_flag	udd_designparamcode	varchar(5)	Yes	RA ProSts flag	No
rafsysatadtl_Char_month	udd_flag2	varchar(25)	Yes	Char month	No
rafsysatadtl_Char_year	udd_flag2	varchar(25)	Yes	Char year	No
rafsysatadtl_Int_month	udd_count	int(4)	Yes	Int month	No
rafsysatadtl_Int_year	udd_count	int(4)	Yes	Int year	No
rafsysatadtl_Report_For	_datetime_8	datetime(8)	Yes	Report For	No
rafsysatadtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
rafsysatadtl_ATAFlag	udd_designparamcode	varchar(5)	Yes	ATA flag	No
rafsysatadtl_Sys_ata	udd_atanumber	varchar(16)	Yes	ATA number	No
rafsysatadtl_Sys_ata_desc	udd_txt150	varchar(150)	Yes	ATA description	No
rafsysatadtl_Val_id	udd_count	int(4)	Yes	Validity id	No
rafsysatadtl_Dcnt	udd_count	int(4)	Yes	Dcnt	No
rafsysatadtl_Ccnt	udd_count	int(4)	Yes	Ccnt	No
rafsysatadtl_Scnt	udd_count	int(4)	Yes	Scnt	No
rafsysatadtl_Drate	udd_numericparamval	numeric(13)	Yes	Drate	No
rafsysatadtl_Crate	udd_numericparamval	numeric(13)	Yes	Crate	No
rafsysatadtl_Srate	udd_numericparamval	numeric(13)	Yes	Srate	No
rafsysatadtl_DCrate	udd_numericparamval	numeric(13)	Yes	DCrate	No
rafsysatadtl_DCSrate	udd_numericparamval	numeric(13)	Yes	DCSrate	No
rafsysatadtl_Created_date	_datetime_8	datetime(8)	Yes	Created date	No
rafsysatadtl_Created_by	udd_ctxt_user	varchar(30)	Yes	Created by	No
rafsysatadtl_Modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
rafsysatadtl_Modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
rafsysatadtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No

Table Name :	basra_fltalert_alertvalue_dtl
Comment :	Flight alert value details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fltalertdtl_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
fltalertdtl_fleet_no	udd_model	varchar(20)	No	fleet no	Yes
fltalertdtl_Alert_seqno	udd_seqno	int(4)	No	Alert seqno	Yes
fltalertdtl_alert_type	udd_paramcode	varchar(30)	No	alert type	Yes
fltalertdtl_ATA_ou	udd_ctxt_ouinstance	int(4)	No	ATA ou	Yes
fltalertdtl_ATA_no	udd_atanumber	varchar(16)	No	ATA no	Yes
fltalertdtl_ataanalysis_type	udd_paramcode	varchar(30)	No	ataanalysis type	Yes
fltalertdtl_alert_value	udd_value	numeric(13)	Yes	alert value	No
fltalertdtl_watch_value	udd_value	numeric(13)	Yes	watch value	No

Table Name :	basra_fltalert_alertvalue_hdr
Comment :	Flight alert value header table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
fltalerthdr_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
fltalerthdr_fleet_no	udd_model	varchar(20)	No	fleet no	Yes
fltalerthdr_Alert_seqno	udd_seqno	int(4)	No	Alert seqno	Yes
fltalerthdr_eff_from	_datetime_8	datetime(8)	Yes	Effective from	No
fltalerthdr_eff_to	_datetime_8	datetime(8)	Yes	Effective To	No
fltalerthdr_created_date	_datetime_8	datetime(8)	Yes	created date	No
fltalerthdr_createdUSer	ctxt_user	varchar(30)	Yes	created USer	No
fltalerthdr_Modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
fltalerthdr_ModifiedUser	ctxt_user	varchar(30)	Yes	ModifiedUser	No

Table Name :	BASRA_Graph_DelayMjrSysATA
Comment :	Graph delay major system ATA table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GDMS_Ou_Tmp	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
GDMS_Guid_Tmp	udd_guid	varchar(40)	Yes	Guid	No
GDMS_Srlno_Tmp	_int_0	int(0)	Yes	Serial number	No
GDMS_MjrSysAta	udd_documentno	varchar(40)	Yes	ATA number	No
GDMS_NoDelays	udd_numericparamval	numeric(13)	Yes	NO of delays	No
GDMS_AccDelDurat	udd_numericparamval	numeric(13)	Yes	Delay duration	No
GDMS_DurPerDelay	udd_numericparamval	numeric(13)	Yes	Duration per delay	No

Table Name :	BASRA_Graph_DelaySysATA
Comment :	Graph delay system ATA table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GDS_Ou_Tmp	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
GDS_Guid_Tmp	udd_guid	varchar(40)	Yes	Guid	No
GDS_Srlno_Tmp	_int_0	int(0)	Yes	Serial number	No
GDS_SysAta	udd_documentno	varchar(40)	Yes	ATA number	No
GDS_NoDelays	udd_numericparamval	numeric(13)	Yes	No of delays	No
GDS_AccDelDurat	udd_numericparamval	numeric(13)	Yes	Delay duration	No
GDS_DurPerDelay	udd_numericparamval	numeric(13)	Yes	Duration per delay	No

Table Name :	BASRA_Graph_OtherThnDelCan
Comment :	Graph other than delay table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
GOTDC_Ou_Tmp	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
GOTDC_Guid_Tmp	udd_guid	varchar(40)	Yes	Guid	No
GOTDC_Srlno_Tmp	_int_0	int(0)	Yes	Serial number	No
GOTDC_SysAta	udd_documentno	varchar(40)	Yes	ATA number	No
GOTDC_SysAtaDesc	udd_txt150	varchar(150)	Yes	ATA description	No
GOTDC_MjrSysAta	udd_documentno	varchar(40)	Yes	ATA #	No
GOTDC_MjrSysAtaDesc	udd_txt150	varchar(150)	Yes	ATA descriptions	No
GOTDC_Oper_IntType	udd_documentno	varchar(40)	Yes	Operation int type	No
GOTDC_DelCanCount	udd_count	int(4)	Yes	Delay calendar count	No
GOTDC_MonInt	udd_count	int(4)	Yes	Month	No
GOTDC_MonChar	udd_flag	varchar(25)	Yes	Month char	No
GOTDC_YearInt	udd_count	int(4)	Yes	Year Int	No
GOTDC_YearChar	udd_flag	varchar(25)	Yes	Year Char	No
GOTDC_Month_Res	udd_flag	varchar(25)	Yes	Month Res	No
GOTDC_MonthRes	udd_flag	varchar(25)	Yes	MonthRes	No
GOTDC_YearRes	udd_flag	varchar(25)	Yes	YearRes	No

Table Name :	BasRA_Journey_Log_dtl
Comment :	Journey log details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rajlogdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
rajlogdtl_RA_Trandoc_flag	udd_flag2	varchar(25)	Yes	RA Trandoc flag	No
rajlogdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rajlogdtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
rajlogdtl_AC_Regno	udd_aircraftnumber	varchar(30)	Yes	AC Regno	No
rajlogdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
rajlogdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
rajlogdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
rajlogdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
rajlogdtl_RA_ReqYesno_flag	udd_designparamcode	varchar(5)	Yes	RA ReqYesno flag	No
rajlogdtl_Tran_Document_no	udd_documentno	varchar(40)	Yes	Tran Document no	No
rajlogdtl_Tran_date	_datetime_8	datetime(8)	Yes	Tran date	No
rajlogdtl_Tran_Status_flag	udd_flag2	varchar(25)	Yes	Tran Status flag	No
rajlogdtl_Leg_no	udd_count	int(4)	Yes	Leg no	No
rajlogdtl_Line_no	udd_count	int(4)	Yes	Line no	No
rajlogdtl_Flight_no	udd_fltno	varchar(30)	Yes	Flight no	No
rajlogdtl_Flight_status	udd_flag2	varchar(25)	Yes	Flight status	No
rajlogdtl_Flight_opstype	udd_quickcodes	varchar(25)	Yes	Flight opstype	No
rajlogdtl_Src_Doc_Type	udd_designparamcode	varchar(5)	Yes	Src Doc Type	No
rajlogdtl_Src_Doc_No	udd_documentno	varchar(40)	Yes	Src Doc No	No
rajlogdtl_Src_Doc_Desc	udd_txt255	varchar(255)	Yes	Src Doc Desc	No
rajlogdtl_Description	udd_txt255	varchar(255)	Yes	Description	No
rajlogdtl_Tran_Created_date	_datetime_8	datetime(8)	Yes	Tran Created date	No
rajlogdtl_Tran_Created_by	udd_ctxt_user	varchar(30)	Yes	Tran Created by	No
rajlogdtl_Tran_Confirmed_date	_datetime_8	datetime(8)	Yes	Tran Confirmed date	No
rajlogdtl_Tran_Confirmed_By	udd_ctxt_user	varchar(30)	Yes	Tran Confirmed By	No
rajlogdtl_RA_Created_date	_datetime_8	datetime(8)	Yes	RA Created date	No
rajlogdtl_RA_Created_by	udd_ctxt_user	varchar(30)	Yes	RA Created by	No
rajlogdtl_RA_Modified_date	_datetime_8	datetime(8)	Yes	RA Modified date	No
rajlogdtl_RA_Modified_by	udd_ctxt_user	varchar(30)	Yes	RA Modified by	No
rajlogdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
rajlogdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_Journey_Log_dtl_2009_his
Comment :	Journey log details histroy table 2009

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rajlogdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
rajlogdtl_RA_Trandoc_flag	udd_flag2	varchar(25)	Yes	RA Trandoc flag	No
rajlogdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
rajlogdtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
rajlogdtl_AC_Regno	udd_aircraftnumber	varchar(30)	Yes	AC Regno	No
rajlogdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
rajlogdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
rajlogdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
rajlogdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
rajlogdtl_RA_ReqYesno_flag	udd_designparamcode	varchar(5)	Yes	RA ReqYesno flag	No
rajlogdtl_Tran_Document_no	udd_documentno	varchar(40)	Yes	Tran Document no	No
rajlogdtl_Tran_date	_datetime_8	datetime(8)	Yes	Tran date	No
rajlogdtl_Tran_Status_flag	udd_flag2	varchar(25)	Yes	Tran Status flag	No
rajlogdtl_Leg_no	udd_count	int(4)	Yes	Leg no	No
rajlogdtl_Line_no	udd_count	int(4)	Yes	Line no	No
rajlogdtl_Flight_no	udd_fltno	varchar(30)	Yes	Flight no	No
rajlogdtl_Flight_status	udd_flag2	varchar(25)	Yes	Flight status	No
rajlogdtl_Flight_opstype	udd_quickcodes	varchar(25)	Yes	Flight opstype	No
rajlogdtl_Src_Doc_Type	udd_designparamcode	varchar(5)	Yes	Src Doc Type	No
rajlogdtl_Src_Doc_No	udd_documentno	varchar(40)	Yes	Src Doc No	No
rajlogdtl_Src_Doc_Desc	udd_txt255	varchar(255)	Yes	Src Doc Desc	No
rajlogdtl_Description	udd_txt255	varchar(255)	Yes	Description	No
rajlogdtl_Tran_Created_date	_datetime_8	datetime(8)	Yes	Tran Created date	No
rajlogdtl_Tran_Created_by	udd_ctxt_user	varchar(30)	Yes	Tran Created by	No
rajlogdtl_Tran_Confirmed_date	_datetime_8	datetime(8)	Yes	Tran Confirmed date	No
rajlogdtl_Tran_Confirmed_By	udd_ctxt_user	varchar(30)	Yes	Tran Confirmed By	No
rajlogdtl_RA_Created_date	_datetime_8	datetime(8)	Yes	RA Created date	No
rajlogdtl_RA_Created_by	udd_ctxt_user	varchar(30)	Yes	RA Created by	No
rajlogdtl_RA_Modified_date	_datetime_8	datetime(8)	Yes	RA Modified date	No
rajlogdtl_RA_Modified_by	udd_ctxt_user	varchar(30)	Yes	RA Modified by	No
rajlogdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
rajlogdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BASRA_last_Upload_datetime
Comment :	Last upload datetime

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ralstuplddate_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	ouinstance	No
ralstuplddate_lastuploaddate	_datetime_8	datetime(8)	Yes	lastuploaddate	No
ralstuplddate_inpara_month	udd_count	int(4)	Yes	inpara month	No
ralstuplddate_inpara_Year	udd_count	int(4)	Yes	inpara Year	No
ralstuplddate_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	basra_parameter_details_dtl
Comment :	Parameter details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
radtl_componentname	udd_compname	varchar(40)	Yes	Component Name	No
radtl_parametercategory	udd_paramcategory	varchar(10)	Yes	Parameter categoty	No
radtl_paramtype	udd_paramtype	varchar(25)	Yes	Parameter type	No
radtl_paramcode	udd_paramcode	varchar(30)	Yes	Parameter code	No
radtl_langid	udd_timestamp	int(4)	Yes	Languate ID	No
radtl_paramdesc	udd_txt150	varchar(150)	Yes	Parameter description	No
radtl_sortby	udd_seqno	int(4)	Yes	Sort by order	No
radtl_createddate	_datetime_8	datetime(8)	Yes	Created date	No

Table Name :	BasRA_processed_delay_discrepancy_incident_dtl
Comment :	Processed delay discrepancyincident details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
raprocdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
raprocdtl_RA_Trandoc_flag	udd_flag2	varchar(25)	Yes	RA Trandoc flag	No
raprocdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
raprocdtl_Fleet_no	udd_model	varchar(20)	Yes	Fleet no	No
raprocdtl_AC_Regno	udd_aircraftnumber	varchar(30)	Yes	AC Regno	No
raprocdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
raprocdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
raprocdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
raprocdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
raprocdtl_Tran_Document_no	udd_documentno	varchar(40)	Yes	Tran Document no	No
raprocdtl_Tran_Document_lineno	udd_count	int(4)	Yes	Tran Document lineno	No
raprocdtl_Tran_date	_datetime_8	datetime(8)	Yes	Tran date	No
raprocdtl_Tran_Status_flag	udd_flag2	varchar(25)	Yes	Tran Status flag	No
raprocdtl_Src_Doc_Type	udd_designparamcode	varchar(5)	Yes	Src Doc Type	No
raprocdtl_Src_Doc_No	udd_documentno	varchar(40)	Yes	Src Doc No	No
raprocdtl_Src_Doc_Desc	udd_txt2000	varchar(2000)	Yes	Src Doc Desc	No
raprocdtl_Category_Type	udd_quickcodes	varchar(25)	Yes	Category Type	No
raprocdtl_station_number	udd_wccode	varchar(30)	Yes	station number	No
raprocdtl_ATAno	udd_atanumber	varchar(16)	Yes	ATAno	No
raprocdtl_Delay_Duration	udd_duration	numeric(13)	Yes	Delay Duration	No
raprocdtl_Applicability	udd_flag	varchar(25)	Yes	Applicability	No
raprocdtl_Reported_by	udd_hrempcode	varchar(20)	Yes	Reported by	No
raprocdtl_Resolved_date	_datetime_8	datetime(8)	Yes	Resolved date	No
raprocdtl_Transfer_Partno	udd_partno	varchar(40)	Yes	Transfer Partno	No
raprocdtl_Transfer_serialno	UDD_Manufacturerserialnum	varchar(40)	Yes	Transfer serialno	No
raprocdtl_Remedial_Act	udd_txt2000	varchar(2000)	Yes	Remedial Act	No
raprocdtl_Remarks	udd_txt2000	varchar(2000)	Yes	Remarks	No
raprocdtl_Description	udd_txt2000	varchar(2000)	Yes	Description	No
raprocdtl_Reason	udd_txt2000	varchar(2000)	Yes	Reason	No
raprocdtl_Discrepancyno	udd_documentno	varchar(40)	Yes	Discrepancyno	No
raprocdtl_Occurrence_location	udd_location	varchar(16)	Yes	Occurrence location	No
raprocdtl_Phase_of_Occ	udd_flag2	varchar(25)	Yes	Phase of Occ	No
raprocdtl_delay_on	udd_flag2	varchar(25)	Yes	delay on	No
raprocdtl_Tran_Created_date	_datetime_8	datetime(8)	Yes	Tran Created date	No
raprocdtl_Tran_Created_by	udd_ctxt_user	varchar(30)	Yes	Tran Created by	No
raprocdtl_Tran_Confirmed_date	_datetime_8	datetime(8)	Yes	Tran Confirmed date	No
raprocdtl_Tran_Confirmed_By	udd_ctxt_user	varchar(30)	Yes	Tran Confirmed By	No
raprocdtl_RA_Created_date	_datetime_8	datetime(8)	Yes	RA Created date	No
raprocdtl_RA_Created_by	udd_ctxt_user	varchar(30)	Yes	RA Created by	No
raprocdtl_RA_Modified_date	_datetime_8	datetime(8)	Yes	RA Modified date	No
raprocdtl_RA_Modified_by	udd_ctxt_user	varchar(30)	Yes	RA Modified by	No
raprocdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
raprocdtl_Tran_Document_legno	udd_count	int(4)	Yes	Tran Document legno	No
raprocdtl_flight_no	udd_fltno	varchar(30)	Yes	flight no	No
raprocdtl_Pos_code	udd_flag2	varchar(25)	Yes	Position code	No
raprocdtl_shutdown_datetime	_datetime_8	datetime(8)	Yes	shutdown datetime	No
raprocdtl_Restart_datetime	_datetime_8	datetime(8)	Yes	Restart datetime	No
raprocdtl_Processing_status	udd_flag2	varchar(25)	Yes	Processing status	No
raprocdtl_Tracking_status	udd_flag2	varchar(25)	Yes	Tracking status	No
raprocdtl_Disc_Category	udd_flag2	varchar(25)	Yes	Discrepancy Category	No
raprocdtl_param_code	udd_paramcode	varchar(30)	Yes	Parameter code	No
raprocdtl_pos_type	udd_designparamcode	varchar(5)	Yes	Position type	No
raprocdtl_component_id	udd_componentid	varchar(90)	Yes	component id	No
raprocdtl_Param_val	udd_flag2	varchar(25)	Yes	Parameter value	No
raprocdtl_Lotno	udd_lotno	varchar(18)	Yes	Lot number	No
raprocdtl_quantity	udd_quantity	numeric(13)	Yes	quantity	No
raprocdtl_Parttype	udd_designparamcode	varchar(5)	Yes	Part tye	No
raprocdtl_levelno	udd_quantity	numeric(13)	Yes	Level number	No
raprocdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	BasRA_processed_delay_discrepancy_incident_dtl_200
Comment :	Processed delay discrepancyincident details histroy 2009 table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	Basra_Process_Scheduler
Comment :	Process scheduler table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Basraps_OUinstance	udd_ctxt_ouinstance	int(4)	Yes	OUinstance	No
Basraps_Language	udd_ctxt_language	int(4)	Yes	Language	No
Basraps_User	udd_ctxt_user	varchar(30)	Yes	User	No
Basraps_Reportfor	_datetime_8	datetime(8)	Yes	Reportfor	No
Basraps_Reportformonth	udd_flag2	varchar(25)	Yes	Reportformonth	No
Basraps_Reportforyear	udd_flag2	varchar(25)	Yes	Reportforyear	No
Basraps_fleet	udd_model	varchar(20)	Yes	fleet	No
Basraps_Processid	udd_count	int(4)	Yes	Processid	No
Basraps_Completedflag	udd_flag2	varchar(25)	Yes	Completedflag	No
Basraps_Schedular	udd_flag2	varchar(25)	Yes	Schedular	No
Basraps_Createddate	_datetime_8	datetime(8)	Yes	Createddate	No
Basraps_Modifieddate	_datetime_8	datetime(8)	Yes	Modifieddate	No

Table Name :	basra_qc_quick_codes
Comment :	Quick code details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RAqc_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
RAqc_quick_code	udd_quickcode	varchar(25)	No	quick code	Yes
RAqc_quickcode_type	udd_paramtype	varchar(25)	No	quickcode type	Yes
RAqc_quickcode_desc	udd_txt255	varchar(255)	Yes	quickcode desc	No
RAqc_quickcode_status	udd_paramcode	varchar(30)	Yes	quickcode status	No
RAqc_quickcode_default	udd_paramcode	varchar(30)	Yes	quickcode default	No
RAqc_timestamp	udd_timestamp	int(4)	Yes	timestamp	No
RAqc_createdby	udd_ctxt_user	varchar(30)	Yes	createdby	No
RAqc_createddate	_datetime_8	datetime(8)	Yes	createddate	No
RAqc_modifiedby	udd_ctxt_user	varchar(30)	Yes	modifiedby	No
RAqc_modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No
RAqc_quickcode_mandatory	udd_paramcode	varchar(30)	Yes	mandatory	No

Table Name :	basra_raconrpt_config_rpt_dtl
Comment :	Configuration report details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
raconrpt_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
raconrpt_fleet_no	udd_model	varchar(20)	No	fleet no	Yes
raconrpt_report_name	udd_paramcode	varchar(30)	No	report name	Yes
raconrpt_report_applicable	udd_paramcode	varchar(30)	Yes	report applicable	No
raconrpt_rpt_order	udd_seqno	int(4)	Yes	rpt order	No
raconrpt_remarks	udd_txt255	varchar(255)	Yes	remarks	No
raconrpt_createdby	udd_ctxt_user	varchar(30)	Yes	createdby	No
raconrpt_createddate	_datetime_8	datetime(8)	Yes	createddate	No
raconrpt_modifiedby	udd_ctxt_user	varchar(30)	Yes	modifiedby	No
raconrpt_modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No

Table Name :	BASRA_RACRDTL_COMPONENT_REPLACEMENT_DTL
Comment :	Component replacement details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
racrdtl_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
racrdtl_fleet_no	udd_model	varchar(20)	Yes	fleet no	No
racrdtl_RA_Trandoc_flag	udd_flag2	varchar(25)	Yes	RA Trandoc flag	No
racrdtl_RA_ProcessSts_flag	udd_flag2	varchar(25)	Yes	RA ProcessSts flag	No
racrdtl_AC_Regno	udd_aircraftnumber	varchar(30)	Yes	AC Regno	No
racrdtl_Effective_char_Month	udd_flag2	varchar(25)	Yes	Effective char Month	No
racrdtl_Effective_num_Month	udd_count	int(4)	Yes	Effective num Month	No
racrdtl_Effective_char_Year	udd_flag2	varchar(25)	Yes	Effective char Year	No
racrdtl_Effective_num_Year	udd_count	int(4)	Yes	Effective num Year	No
racrdtl_RA_ReqYesno_flag	udd_designparamcode	varchar(5)	Yes	RA ReqYesno flag	No
racrdtl_Tran_Document_no	udd_documentno	varchar(40)	Yes	Tran Document no	No
racrdtl_Tran_Status_flag	udd_flag	varchar(25)	Yes	Tran Status flag	No
racrdtl_Tran_Type	udd_designparamcode	varchar(5)	Yes	Tran Type	No
racrdtl_removed_Compid	udd_componentid	varchar(90)	Yes	removed Compid	No
racrdtl_attached_Compid	udd_componentid	varchar(90)	Yes	attached Compid	No
racrdtl_Rem_Partno	udd_partno	varchar(40)	Yes	Rem Partno	No
racrdtl_Rem_Serialno	UDD_Manufacturerserialnum	varchar(40)	Yes	Rem Serialno	No
racrdtl_Effective_from	_datetime_8	datetime(8)	Yes	Effective from	No
racrdtl_Effective_to	_datetime_8	datetime(8)	Yes	Effective to	No
racrdtl_Pos_type	udd_designparamcode	varchar(5)	Yes	Pos type	No
racrdtl_Pos_code	udd_positioncode	varchar(25)	Yes	Pos code	No
racrdtl_level_no	udd_cnfglvlcd	varchar(150)	Yes	level no	No
racrdtl_level_code	udd_cnfglvlcd	varchar(150)	Yes	level code	No
racrdtl_Tran_Created_date	_datetime_8	datetime(8)	Yes	Tran Created date	No
racrdtl_Tran_Created_by	udd_ctxt_user	varchar(30)	Yes	Tran Created by	No
racrdtl_Tran_Confirmed_date	_datetime_8	datetime(8)	Yes	Tran Confirmed date	No
racrdtl_Tran_Confirmed_By	udd_ctxt_user	varchar(30)	Yes	Tran Confirmed By	No
racrdtl_RA_Created_date	_datetime_8	datetime(8)	Yes	RA Created date	No
racrdtl_RA_Created_by	udd_ctxt_user	varchar(30)	Yes	RA Created by	No
racrdtl_RA_Modified_date	_datetime_8	datetime(8)	Yes	RA Modified date	No
racrdtl_RA_Modified_by	udd_ctxt_user	varchar(30)	Yes	RA Modified by	No
racrdtl_Timestamp	udd_count	int(4)	Yes	Timestamp	No
racrdtl_Reason	udd_flag2	varchar(25)	Yes	Reason	No
racrdtl_Rem_Lotno	udd_lotno	varchar(18)	Yes	Rem Lotno	No
racrdtl_Source_docno	udd_documentno	varchar(40)	Yes	Source docno	No
racrdtl_Source_doctype	udd_designparamcode	varchar(5)	Yes	Source doctype	No
racrdtl_Rem_PartATA	udd_atanumber	varchar(16)	Yes	Rem PartATA	No
racrdtl_Rem_Parttype	udd_designparamcode	varchar(5)	Yes	Rem Parttype	No
racrdtl_Report_for	_datetime_8	datetime(8)	Yes	Report for	No

Table Name :	basra_rafltac_fleet_aircraft_dtl
Comment :	Fleet aircraft details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafltac_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
rafltac_fleet_no	udd_model	varchar(20)	No	fleet no	Yes
rafltac_aircraft_reg_no	udd_aircraftnumber	varchar(30)	No	aircraft reg no	Yes
rafltac_effective_from	_datetime_8	datetime(8)	No	effective from	Yes
rafltac_aircraft_ou	udd_ctxt_ouinstance	int(4)	Yes	aircraft ou	No
rafltac_effective_to	_datetime_8	datetime(8)	Yes	effective to	No
rafltac_remarks	udd_txt255	varchar(255)	Yes	remarks	No
rafltac_createdby	udd_ctxt_user	varchar(30)	Yes	createdby	No
rafltac_createddate	_datetime_8	datetime(8)	Yes	createddate	No
rafltac_modifiedby	udd_ctxt_user	varchar(30)	Yes	modifiedby	No
rafltac_modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No

Table Name :	basra_rafltata_fleet_ata_dtl
Comment :	Fleet aircraft ATA details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
rafltata_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
rafltata_fleet_no	udd_model	varchar(20)	No	fleet no	Yes
rafltata_ata_no	udd_atanumber	varchar(16)	No	ata no	Yes
rafltata_ata_ou	udd_ctxt_ouinstance	int(4)	No	ata ou	Yes
rafltata_system_ata	udd_atanumber	varchar(16)	Yes	system ata	No
rafltata_system_ata_ou	udd_ctxt_ouinstance	int(4)	Yes	system ata ou	No
rafltata_major_ata_ou	udd_ctxt_ouinstance	int(4)	Yes	major ata ou	No
rafltata_major_ata	udd_atanumber	varchar(16)	Yes	major ata	No
rafltata_analysis_required	udd_paramcode	varchar(30)	Yes	analysis required	No
rafltata_remarks	udd_txt255	varchar(255)	Yes	remarks	No
rafltata_createdby	udd_ctxt_user	varchar(30)	Yes	createdby	No
rafltata_createddate	_datetime_8	datetime(8)	Yes	createddate	No
rafltata_modifiedby	udd_ctxt_user	varchar(30)	Yes	modifiedby	No
rafltata_modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No

Table Name :	basra_raflt_fleet_dtl
Comment :	Fleet details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
raflt_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
raflt_fleet_no	udd_model	varchar(20)	No	fleet no	Yes
raflt_description	udd_txt150	varchar(150)	Yes	description	No
raflt_status	udd_paramcode	varchar(30)	Yes	status	No
raflt_reliablity_rep_group	udd_quickcode	varchar(25)	Yes	reliablity rep group	No
raflt_analysisfrom	_datetime_8	datetime(8)	Yes	analysisfrom	No
raflt_rep_delay_inmin	udd_duration	numeric(13)	Yes	rep delay inmin	No
raflt_remarks	udd_txt255	varchar(255)	Yes	remarks	No
raflt_publisheddate	_datetime_8	datetime(8)	Yes	publisheddate	No
raflt_plannercode_ou	udd_ctxt_ouinstance	int(4)	Yes	plannercode ou	No
raflt_plannercode	udd_hrempcode	varchar(20)	Yes	plannercode	No
raflt_timestamp	udd_timestamp	int(4)	Yes	timestamp	No
raflt_createdby	udd_ctxt_user	varchar(30)	Yes	createdby	No
raflt_createddate	_datetime_8	datetime(8)	Yes	createddate	No
raflt_modifiedby	udd_ctxt_user	varchar(30)	Yes	modifiedby	No
raflt_modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No
raflt_delay_limit	udd_duration	numeric(13)	Yes	delay limit	No
raflt_Target_Despatch	udd_duration	numeric(13)	Yes	Target Despatch	No

Table Name :	BASRA_raipd_Inquire_PrtHis_Dtl
Comment :	Rapid inquire part histroy table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
raipd_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	No
raipd_RA_Trandoc_flag	udd_flag2	varchar(25)	No	RA Trandoc flag	No
raipd_AC_Regno	udd_aircraftnumber	varchar(30)	Yes	AC Regno	No
raipd_ACRegno_flag	udd_designparamcode	varchar(5)	Yes	ACRegno flag	No
raipd_Tran_Doc_no	udd_documentno	varchar(40)	Yes	Tran Doc no	No
raipd_Tran_Doc_lineno	udd_count	int(4)	Yes	Tran Doc lineno	No
raipd_Tran_Startdate	_datetime_8	datetime(8)	No	Tran Startdate	No
raipd_Tran_Enddate	_datetime_8	datetime(8)	Yes	Tran Enddate	No
raipd_Tran_Sts_flag	udd_flag2	varchar(25)	Yes	Tran Sts flag	No
raipd_Tran_Doc_type	udd_flag2	varchar(25)	Yes	Tran Doc type	No
raipd_Partno	udd_partno	varchar(40)	No	Partno	No
raipd_Serialno	UDD_Manufacturerserialnum	varchar(40)	No	Serialno	No
raipd_lotno	udd_lotno	varchar(18)	Yes	lotno	No
raipd_comp_id	udd_componentid	varchar(90)	Yes	comp id	No
raipd_ATAno	udd_atanumber	varchar(16)	Yes	ATAno	No
raipd_Parttype	udd_designparamcode	varchar(5)	Yes	Parttype	No
raipd_BERFlag	udd_designparamcode	varchar(5)	Yes	BERFlag	No
raipd_Tran_Created_date	_datetime_8	datetime(8)	Yes	Tran Created date	No
raipd_Tran_Created_by	udd_ctxt_user	varchar(30)	Yes	Tran Created by	No
raipd_Tran_Confirmed_date	_datetime_8	datetime(8)	Yes	Tran Confirmed date	No
raipd_Tran_Confirmed_By	udd_ctxt_user	varchar(30)	Yes	Tran Confirmed By	No
raipd_RA_Created_date	_datetime_8	datetime(8)	Yes	RA Created date	No
raipd_RA_Created_by	udd_ctxt_user	varchar(30)	Yes	RA Created by	No
raipd_RA_Modified_date	_datetime_8	datetime(8)	Yes	RA Modified date	No
raipd_RA_Modified_by	udd_ctxt_user	varchar(30)	Yes	RA Modified by	No
raipd_Timestamp	udd_count	int(4)	Yes	Timestamp	No
raipd_Tran_type	udd_txt80	varchar(80)	Yes	Tran type	No
raipd_Old_Partno	udd_partno	varchar(40)	Yes	Old Partno	No
raipd_Old_Serialno	UDD_Manufacturerserialnum	varchar(40)	Yes	Old Serialno	No
raipd_attachedby	udd_ctxt_user	varchar(30)	Yes	attachedby	No
raipd_att_workorderno	udd_documentno	varchar(40)	Yes	att workorderno	No
raipd_removedby	udd_ctxt_user	varchar(30)	Yes	removedby	No
raipd_rem_workorderno	udd_documentno	varchar(40)	Yes	rem workorderno	No
raipd_reason	udd_flag2	varchar(25)	Yes	reason	No
raipd_Current_Partno	udd_partno	varchar(40)	Yes	Current Partno	No
raipd_Current_Serialno	UDD_Manufacturerserialnum	varchar(40)	Yes	Current Serialno	No

Table Name :	BasRa_Rel_Graph
Comment :	Release graph

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Guid	udd_guid	varchar(40)	Yes	Guid	No
OuIns	udd_ctxt_ouinstance	int(4)	Yes	OuIns	No
ATA	udd_atanumber	varchar(16)	Yes	ATA	No
Months	udd_flag2	varchar(25)	Yes	Months	No
FH_Dep	udd_numericparamval	numeric(13)	Yes	FH Dep	No
AlertValue	udd_value	numeric(13)	Yes	AlertValue	No
Month_Int	_int_0	int(0)	Yes	Month Int	No
Year_Int	_int_0	int(0)	Yes	Year Int	No
monthres	udd_flag	varchar(25)	Yes	monthres	No
CharYear	udd_flag	varchar(25)	Yes	CharYear	No
CharMonth	udd_flag	varchar(25)	Yes	CharMonth	No
seqno	_int_0	int(0)	Yes	seqno	No
TweMthCnt	_int_0	int(0)	Yes	TweMthCnt	No
Paramvalue	udd_numericparamval	numeric(13)	Yes	Paramvalue	No

Table Name :	BASRA_RRSD_Reliability_Reports_Dtl
Comment :	Reliability report details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRSD_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
RRSD_Fleet_no	udd_model	varchar(20)	No	Fleet no	Yes
RRSD_Report_For	_datetime_8	datetime(8)	No	Report For	Yes
RRSD_ReportName	udd_txt150	varchar(150)	No	ReportName	Yes
RRSD_Rpt_Status	udd_designparamcode	varchar(5)	Yes	Rpt Status	No
RRSD_Rpt_Code	udd_paramcode	varchar(30)	Yes	Rpt Code	No
RRSD_Archive_File	udd_filename	varchar(50)	Yes	Archive File	No

Table Name :	BASRA_RRSH_Reliability_Reports_Hdr
Comment :	Reliability reports header table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RRSH_Ouinstance	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
RRSH_Rpt_Group_Fleet_Name	udd_txt150	varchar(150)	Yes	Rpt Group Fleet Name	No
RRSH_Rpt_Group_Opt	udd_flag1	varchar(25)	Yes	Rpt Group Opt	No
RRSH_Fleet_no	udd_model	varchar(20)	No	Fleet no	Yes
RRSH_Report_For	_datetime_8	datetime(8)	No	Report For	Yes
RRSH_Status	udd_status	varchar(25)	Yes	Status	No
RRSH_User_Status	udd_status	varchar(25)	Yes	User Status	No
RRSH_ReportBook	udd_filename	varchar(50)	Yes	ReportBook	No
RRSH_Remarks	udd_txt255	varchar(255)	Yes	Remarks	No
RRSH_Archive_Reference	udd_filename	varchar(50)	Yes	Archive Reference	No
RRSH_Upload_initiated_User	udd_ctxt_user	varchar(30)	Yes	Upload initiated User	No
RRSH_Upload_initiated_Date	_datetime_8	datetime(8)	Yes	Upload initiated Date	No
RRSH_UploadUser	udd_ctxt_user	varchar(30)	Yes	UploadUser	No
RRSH_UploadDate	_datetime_8	datetime(8)	Yes	UploadDate	No
RRSH_generatedUser	udd_ctxt_user	varchar(30)	Yes	generatedUser	No
RRSH_generatedDate	_datetime_8	datetime(8)	Yes	generatedDate	No
RRSH_ConsolidatedUser	udd_ctxt_user	varchar(30)	Yes	ConsolidatedUser	No
RRSH_ConsolidatedDate	_datetime_8	datetime(8)	Yes	ConsolidatedDate	No
RRSH_PublishedUser	udd_ctxt_user	varchar(30)	Yes	PublishedUser	No
RRSH_PublishedDate	_datetime_8	datetime(8)	Yes	PublishedDate	No
RRSH_CreatedUser	udd_ctxt_user	varchar(30)	Yes	CreatedUser	No
RRSH_CreatedDate	_datetime_8	datetime(8)	Yes	CreatedDate	No
RRSH_ModifiedUser	udd_ctxt_user	varchar(30)	Yes	ModifiedUser	No
RRSH_ModifiedDate	_datetime_8	datetime(8)	Yes	ModifiedDate	No
RRSH_FHFCFactor	udd_numericparamval	numeric(13)	Yes	FHFCFactor	No
RRSH_NoOfDep	udd_numericparamval	numeric(13)	Yes	NoOfDep	No
RRSH_RateDelay	udd_count	int(4)	Yes	RateDelay	No
RRSH_Sch_Flag	udd_designparamcode	varchar(5)	Yes	Sch Flag	No

Table Name :	basra_set_option_dtl
Comment :	Set option details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
setoptdtl_ouinstance	udd_ctxt_ouinstance	int(4)	No	ouinstance	Yes
SetOptdtl_OptKeyCode	udd_documentno	varchar(40)	No	OptKeyCode	Yes
setoptdtl_status	udd_paramcode	varchar(30)	Yes	status	No
setoptdtl_value	udd_groupno	int(4)	Yes	value	No
setoptdtl_modiifedby	udd_ctxt_user	varchar(30)	Yes	modiifed by	No
setoptdtl_modifieddate	_datetime_8	datetime(8)	Yes	modified date	No

Table Name :	basra_set_option_hdr
Comment :	Set option header table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
setopthdr_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	ouinstance	No
setopthdr_initiatedate	_datetime_8	datetime(8)	Yes	initiate date	No
setopthdr_timestamp	udd_timestamp	int(4)	Yes	timestamp	No
setopthdr_createdby	udd_ctxt_user	varchar(30)	Yes	created by	No
setopthdr_createddate	_datetime_8	datetime(8)	Yes	created date	No
setopthdr_modiifedby	udd_ctxt_user	varchar(30)	Yes	modiifed by	No
setopthdr_modifieddate	_datetime_8	datetime(8)	Yes	modified date	No
SCHEDULER_FLAG	udd_flag	varchar(25)	Yes	Scheduler flag	No

Table Name :	basra_set_option_param_values
Comment :	Set option parameter values

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
setopt_optkeycode	udd_documentno	varchar(40)	No	optkeycode	Yes
setopt_metadata_type	udd_paramcode	varchar(30)	Yes	metadata type	No
setopt_paramcode	udd_paramcode	varchar(30)	Yes	paramcode	No
setopt_paramdesc	udd_txt255	varchar(255)	Yes	paramdesc	No
setopt_permittedvalue	udd_txt255	varchar(255)	Yes	permittedvalue	No
setopt_mandatory_check	udd_paramcode	varchar(30)	Yes	mandatory check	No
setopt_sotrby	udd_seqno	int(4)	Yes	sotr by	No
setopt_createddate	_datetime_8	datetime(8)	Yes	createddate	No

Table Name :	BASRA_SET_OPTION_PERMIT_VALUES
Comment :	Set option param values table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SetOpt_OptKeyCode	_varchar_40	varchar(40)	Yes	OptKeyCode	No
SetOpt_permittedvalue	_varchar_150	varchar(150)	Yes	permittedvalue	No
Setopt_Remarks	_varchar_255	varchar(255)	Yes	Remarks	No

Table Name :	BASRA_UDHDR_Upload_reliability_Data_Hdr
Comment :	Upload reliability data header table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
URDHDR_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
URDHDR_Report_For	_datetime_8	datetime(8)	Yes	Report For	No
URDHDR_Status	udd_status	varchar(25)	Yes	Status	No
URDHDR_Month	udd_designparamcode	varchar(5)	Yes	Month	No
URDHDR_Year	udd_designparamcode	varchar(5)	Yes	Year	No
URDHDR_Upload_initiated_User	udd_ctxt_user	varchar(30)	Yes	Upload initiated User	No
URDHDR_Upload_initiated_Date	_datetime_8	datetime(8)	Yes	Upload initiated Date	No
URDHDR_Upload_User	udd_ctxt_user	varchar(30)	Yes	Upload User	No
URDHDR_Upload_Date	_datetime_8	datetime(8)	Yes	Upload Date	No

Table Name :	Basra_Upload_Scheduler
Comment :	Upload scheduler table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Basraus_OUinstance	udd_ctxt_ouinstance	int(4)	Yes	OUinstance	No
Basraus_Language	udd_ctxt_language	int(4)	Yes	Language	No
Basraus_User	udd_ctxt_user	varchar(30)	Yes	User	No
Basraus_Reportformonth	udd_flag2	varchar(25)	Yes	Report for month	No
Basraus_Reportforyear	udd_flag2	varchar(25)	Yes	Report for year	No
Basraus_Processid	udd_count	int(4)	Yes	Process id	No
Basraus_Completedflag	udd_flag2	varchar(25)	Yes	Completed flag	No
Basraus_Schedular	udd_flag2	varchar(25)	Yes	Schedular	No
Basraus_Createddate	_datetime_8	datetime(8)	Yes	Created date	No
Basraus_Modifieddate	_datetime_8	datetime(8)	Yes	Modified date	No