Data Dictionary - Reliability Analysis |
|
| |||||
|
|
|
|
|||||
|
Table Name BasRA_ADD_Analyze_Discrepacny_Dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment Details of new ATA,description and other details of Discrepancies are maintained |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
add_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
add_discrepancyNo |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
add_disc_Desc |
varchar(20) |
NULL |
|
No |
No |
|
|
|
add_Disc_ATA |
varchar(20) |
NULL |
|
No |
No |
|
|
|
add_Remidial_Action_Summary |
varchar(20) |
NULL |
|
No |
No |
|
|
|
add_Rel_Ana_Req |
varchar(20) |
NULL |
|
No |
No |
|
|
|
Add_Recurring_Disc |
varchar(20) |
NULL |
|
No |
No |
|
|
|
add_RD_Analysis |
varchar(20) |
NULL |
|
No |
No |
|
|
|
add_Remarks |
varchar(20) |
NULL |
|
No |
No |
|
|
|
add_created_user |
varchar(20) |
NULL |
|
No |
No |
|
|
|
add_createddate |
datetime |
NULL |
|
No |
No |
|
|
|
add_modifieduser |
varchar(20) |
NULL |
|
No |
No |
|
|
|
add_modifieddate |
datetime |
NULL |
|
No |
No |
|
|
|
add_timestamp |
varchar(20) |
NULL |
|
No |
No |
|
|
|
add_Processed_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
add_Processed_date |
datetime |
NULL |
|
No |
No |
|
|
|
|
|
||||||
|
Table Name BasRA_Aircraft_Parameter_dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment Table to store the aircraft parameter details and aircraft information for the particular aircraft, month and year wise details will be stored, Records will be stored at parameter level. |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
raapdtl_Ouinstance |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raapdtl_Fleet_no |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raapdtl_AC_Regno |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raapdtl_Effective_char_Month |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raapdtl_Effective_num_Month |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raapdtl_Effective_char_Year |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raapdtl_Effective_num_Year |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raapdtl_RA_ReqYesno_flag |
varchar(20) |
NULL |
Represents that the particular record is considered for reliability processing.Initially it is stored as "N" and once the processing table has been populated and if the particular record is considered for processing data then it is updated as "Y". |
No |
No |
|
|
|
raapdtl_RA_Trandoc_flag |
Ff |
NULL |
TRANSACTION FLAG like AC - Aircraft |
No |
No |
|
|
|
raapdtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
Reliability Analysis status of that record |
No |
No |
|
|
|
raapdtl_Model |
varchar(20) |
NULL |
Aircraft Model# |
No |
No |
|
|
|
raapdtl_MSN |
char(18) |
NULL |
Manufacturing Serial# |
No |
No |
|
|
|
raapdtl_Induction_Date |
datetime |
NULL |
induction date |
No |
No |
|
|
|
raapdtl_Ac_Group |
char(18) |
NULL |
aircraftgroup |
No |
No |
|
|
|
raapdtl_Engine_Part |
varchar(20) |
NULL |
Engine part.If more than one part exists the these are separated by semicolon (;) |
No |
No |
|
|
|
raapdtl_APU_Part |
varchar(20) |
NULL |
APU part.If more than one part exists the these are separated by semicolon (;) |
No |
No |
|
|
|
raapdtl_Config_class |
char(18) |
NULL |
configuration class |
No |
No |
|
|
|
raapdtl_ETOP_flag |
varchar(20) |
NULL |
-if ETOP is applicable for the corresponding aircraft then "Yes" will be stored.Else "No" will be stored |
No |
No |
|
|
|
raapdtl_Param_Va1 |
char(18) |
NULL |
parameter value for the corresponding month and year |
No |
No |
|
|
|
raapdtl_Param_CumVa1 |
char(18) |
NULL |
cumulative value of the corresponding acreg and parameter (from induction date and upto the corresponding month and year) |
No |
No |
|
|
|
raapdtl_Param_code |
varchar() |
NULL |
parameter code like FH,FC,LC |
No |
No |
|
|
|
raapdtl_Created_date |
datetime |
NULL |
|
No |
No |
|
|
|
raapdtl_Created_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raapdtl_Modified_date |
datetime |
NULL |
|
No |
No |
|
|
|
raapdtl_Modified_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raapdtl_Timestamp |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raapdtl_Operating_Paramval |
char(18) |
NULL |
Parameter Values Updated through Journey Log |
No |
No |
|
|
|
raapdtl_Revenue_Paramval |
char(18) |
NULL |
Parameter Values Updated through Journey Log that are in Revenue. |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_Aircraft_Part_Parameter_dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment Table to capture the Component wise parameter value |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
raaprtpdtl_OuInstance |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Fleet |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Aircraft |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Effective_char_month |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Effective_num_month |
int |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Effective_char_year |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Effective_num_year |
int |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_RA_ReqYesno_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Partno |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Serial |
char(18) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_componentid |
char(18) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_ATAno |
char(18) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Alternate_yesno |
char(18) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Alternate_srcPart |
char(18) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Curr_Aircraft |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Parttype |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_Paramcode |
varchar() |
NULL |
Parameter code like fc,fh etc |
No |
No |
|
|
|
raaprtpdtl_Paramvalue |
char(18) |
NULL |
Parameter value for the parameter code |
No |
No |
|
|
|
raaprtpdtl_RA_Createddate |
datetime |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_RA_Createdby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_RA_Modifieddate |
datetime |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_RA_Modifiedby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raaprtpdtl_RA_Timestamp |
int |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_delay_discrepancy_incident_dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment Table to store the incident,delay,inflightshutdown ,apu start,shopvisist and discrepancy details |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
raddidtl_Ouinstance |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raddidtl_Fleet_no |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raddidtl_AC_Regno |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raddidtl_Effective_num_Month |
varchar(20) |
NOT NULL |
month of the transaction date ( format 1,2 etc ) |
No |
No |
|
|
|
raddidtl_Effective_num_Year |
varchar(20) |
NOT NULL |
Year of the transaction date ( format 2007,2008..) as integer format |
No |
No |
|
|
|
raddidtl_RA_ReqYesno_flag |
varchar(20) |
NOT NULL |
Represents that the particular record is considered for reliability processing |
No |
No |
|
|
|
raddidtl_RA_Trandoc_flag |
varchar(20) |
NULL |
TRANSACTION FLAG like INC - incident details , DLY - Delay , DIS - discrepancy, INFLTSD -Inflightshutdown, Shopvisit - shopvisit, APUSTARTS - APU START DETAILS. |
No |
No |
|
|
|
raddidtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
Reliability Analysis Status |
No |
No |
|
|
|
raddidtl_Effective_char_Month |
varchar(20) |
NULL |
month of the transaction date ( format jan,feb etc) |
No |
No |
|
|
|
raddidtl_Effective_char_Year |
varchar(20) |
NULL |
Year of the transaction date ( format 2007,2008..) |
No |
No |
|
|
|
raddidtl_Tran_Document_no |
varchar(20) |
NULL |
transaction documentno like incident#, delay#, discrepancy#,JourneyLog#,CWO#,RO# |
No |
No |
|
|
|
raddidtl_Tran_Document_lineno |
varchar(20) |
NULL |
Transaction document line# |
No |
No |
|
|
|
raddidtl_Tran_Document_legno |
varchar(20) |
NULL |
Transaction document Legno if applicable |
No |
No |
|
|
|
raddidtl_Tran_date |
datetime |
NULL |
transaction date like dateofoccurrence, discrepancycreateddate, flightdate(delay transactions) |
No |
No |
|
|
|
raddidtl_Tran_Status_flag |
varchar(20) |
NULL |
transaction document statu |
No |
No |
|
|
|
raddidtl_Src_Doc_Type |
varchar(20) |
NULL |
sourcedocumenttype of the transactiondoc# |
No |
No |
|
|
|
raddidtl_Src_Doc_No |
varchar(20) |
NULL |
Sourcedocument# of the transactiondoc# |
No |
No |
|
|
|
raddidtl_Src_Doc_Desc |
varchar(20) |
NULL |
Source Document Description |
No |
No |
|
|
|
raddidtl_Category_Type |
varchar(20) |
NULL |
incident type,delay category,discrepancy type,flightoperationtype |
No |
No |
|
|
|
raddidtl_station_number |
char(18) |
NULL |
Station Number |
No |
No |
|
|
|
raddidtl_ATAno |
varchar(20) |
NULL |
ATA Number |
No |
No |
|
|
|
raddidtl_Delay_Duration |
varchar(20) |
NULL |
Delay Duration in Minutes |
No |
No |
|
|
|
raddidtl_Applicability |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raddidtl_Reported_by |
varchar() |
NULL |
reported by for discrepancy details |
No |
No |
|
|
|
raddidtl_Resolved_date |
datetime |
NULL |
resolved date for discrepancy details |
No |
No |
|
|
|
raddidtl_Transfer_Partno |
char(18) |
NULL |
Transferred Partno of the discrepancy details and part# of issue,return,shopvisit details |
No |
No |
|
|
|
raddidtl_Transfer_serialno |
char(18) |
NULL |
Transferred Serialno of the discrepancy details and partserail# of issue,return,shopvisit details |
No |
No |
|
|
|
raddidtl_Remedial_Act |
varchar(20) |
NULL |
incident - remedial action , delay - actiontaken , discrepancy - remedial action |
No |
No |
|
|
|
raddidtl_Remarks |
varchar(20) |
NULL |
occurrence remarks (incident), delay remarks (delay),discrepancy remarks (discrepancy) |
No |
No |
|
|
|
raddidtl_Description |
varchar(20) |
NULL |
incident desc , delay desc, discrepancy desc |
No |
No |
|
|
|
raddidtl_Reason |
varchar(20) |
NULL |
delay reason,occurrence type |
No |
No |
|
|
|
raddidtl_Discrepancyno |
varchar(20) |
NULL |
Discrepancy Number |
No |
No |
|
|
|
raddidtl_Occurrence_location |
char(18) |
NULL |
occurrence location (incident details) |
No |
No |
|
|
|
raddidtl_Phase_of_Occ |
varchar(20) |
NULL |
phase of operation (incident details) |
No |
No |
|
|
|
raddidtl_delay_on |
varchar(20) |
NULL |
delayon details of the delay transactions(arrival/departure) |
No |
No |
|
|
|
raddidtl_Tran_Created_date |
datetime |
NULL |
created date of the transaction |
No |
No |
|
|
|
raddidtl_Tran_Created_by |
varchar(20) |
NULL |
created by of the transaction |
No |
No |
|
|
|
raddidtl_Tran_Confirmed_date |
datetime |
NULL |
Confirmed date of the transaction |
No |
No |
|
|
|
raddidtl_Tran_Confirmed_By |
varchar(20) |
NULL |
Confirmed by of the transaction |
No |
No |
|
|
|
raddidtl_RA_Created_date |
datetime |
NULL |
|
No |
No |
|
|
|
raddidtl_RA_Created_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raddidtl_RA_Modified_date |
datetime |
NULL |
|
No |
No |
|
|
|
raddidtl_RA_Modified_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raddidtl_Timestamp |
|
NULL |
|
No |
No |
|
|
|
raddidtl_flight_no |
char(18) |
NULL |
Flightnumber |
No |
No |
|
|
|
raddidtl_Pos_code |
varchar(20) |
NULL |
Position code for shopvisit and APU details |
No |
No |
|
|
|
raddidtl_shutdown_datetime |
datetime |
NULL |
showdown time for of the inflightshutdown records are stored |
No |
No |
|
|
|
raddidtl_Restart_datetime |
datetime |
NULL |
restarttime of the inflightshutdown records are stored |
No |
No |
|
|
|
raddidtl_param_code |
varchar() |
NULL |
parameter code of the component is stored |
No |
No |
|
|
|
raddidtl_pos_type |
varchar(20) |
NULL |
position type of the component is stored |
No |
No |
|
|
|
raddidtl_component_id |
char(18) |
NULL |
Componentid |
No |
No |
|
|
|
raddidtl_Param_val |
varchar(20) |
NULL |
parameter value of the APU components of Journey log details are stored against the transaction flag = ’apu starts’ |
No |
No |
|
|
|
raddidtl_levelno |
char(18) |
NULL |
Level no of the component is stored |
No |
No |
|
|
|
raddidtl_Processing_status |
varchar(20) |
NULL |
Discrepancy processing status |
No |
No |
|
|
|
raddidtl_Tracking_status |
varchar(20) |
NULL |
Discrepancy tracking status |
No |
No |
|
|
|
raddidtl_Disc_Category |
varchar(20) |
NULL |
Discrepancy Category |
No |
No |
|
|
|
raddidtl_Lotno |
varchar(20) |
NULL |
Lot# of issue,return,shopvisit details |
No |
No |
|
|
|
raddidtl_quantity |
char(18) |
NULL |
Quantity of the part,serial/lot |
No |
No |
|
|
|
raddidtl_Parttype |
varchar(20) |
NULL |
Part type |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BASRA_Fleet_ACwise_CompProcessing_Dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment Aircraft wise Engine and APU position type components processing information |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
rafaccmpdtl_Ouinstance |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafaccmpdtl_Fleet_no |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafaccmpdtl_Ac_Regno |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafaccmpdtl_Effective_char_Month |
varchar(20) |
NULL |
month for which the processing is done (format jan,feb etc) |
No |
No |
|
|
|
rafaccmpdtl_Effective_num_Month |
varchar(20) |
NOT NULL |
month for which the processing is done (format 1,2 etc) |
No |
No |
|
|
|
rafaccmpdtl_Effective_char_Year |
varchar(20) |
NULL |
year for which the processing is done (foramt 2007,2008 etc) |
No |
No |
|
|
|
rafaccmpdtl_Effective_num_Year |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafaccmpdtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
processing status |
No |
No |
|
|
|
rafaccmpdtl_Comp_flag |
varchar(20) |
NULL |
position type A(APU)/E(ENG) |
No |
No |
|
|
|
rafaccmpdtl_no_of_schremovals |
varchar(20) |
NULL |
no.of.scheduled removals |
No |
No |
|
|
|
rafaccmpdtl_no_of_unschremovals |
varchar(20) |
NULL |
no.of.unscheduled removals |
No |
No |
|
|
|
rafaccmpdtl_no_of_othremovals |
varchar(20) |
NULL |
no.of.otherremovals |
No |
No |
|
|
|
rafaccmpdtl_no_of_PlnShpVst |
varchar(20) |
NULL |
no.of.plannedshopvisits |
No |
No |
|
|
|
rafaccmpdtl_no_of_UnPlnShpVst |
varchar(20) |
NULL |
no.of.unplannedshopvisists |
No |
No |
|
|
|
rafaccmpdtl_RA_Created_date |
datetime |
NULL |
|
No |
No |
|
|
|
rafaccmpdtl_RA_Created_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafaccmpdtl_RA_Modified_date |
datetime |
NULL |
|
No |
No |
|
|
|
rafaccmpdtl_RA_Modified_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafaccmpdtl_Timestamp |
|
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BASRA_Fleet_ACwise_PartProcessing_Dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment Table to capture the fleet,aircraft,part,serial,month and year wise processing details |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
rafacprtpdtl_OuInstance |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Fleet |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Aircraft |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Effective_char_month |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Effective_num_month |
int |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Effective_char_year |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Effective_num_year |
int |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_RA_ReqYesno_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Partno |
char(18) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Serial |
char(18) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_ATAno |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Alternate_yesno |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Alternate_srcPart |
char(18) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_Parttype |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_QtyPerAircraft |
int |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_ScheduleRemovals |
int |
NULL |
Count of scheduled removals for the part-serial |
No |
No |
|
|
|
rafacprtpdtl_UnScheduleRemovals |
int |
NULL |
Count of un scheduled removals for the part-serial |
No |
No |
|
|
|
rafacprtpdtl_OtherRemovals |
int |
NULL |
Count of other removals for the part-serial |
No |
No |
|
|
|
rafacprtpdtl_plnd_Shopvisit |
int |
NULL |
Count of planned shopvisits for the part-serial |
No |
No |
|
|
|
rafacprtpdtl_Unplnd_Shopvisit |
int |
NULL |
Count of unplanned shopvisits for the part-serial |
No |
No |
|
|
|
rafacprtpdtl_NFF |
int |
NULL |
Count of NFF for the part-serial |
No |
No |
|
|
|
rafacprtpdtl_MTBUR |
int |
NULL |
MTBUR value for the partserial.This value will be stored only for part type component. |
No |
No |
|
|
|
rafacprtpdtl_12month_MTBUR |
int |
NULL |
Last 12month MTBUR value for the partserial. This value will be stored only for part type component. |
No |
No |
|
|
|
rafacprtpdtl_Sinceincept_MTBUR |
int |
NULL |
Since inception MTBUR value for part-serial. This value will be stored only for part type component. |
No |
No |
|
|
|
rafacprtpdtl_RA_Createddate |
datetime |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_RA_Createdby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_RA_Modifieddate |
datetime |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_RA_Modifiedby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacprtpdtl_RA_Timestamp |
int |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_Fleet_ACWiseProcessing_dtl |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
rafacpdtl_Ouinstance |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafacpdtl_Fleet_no |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafacpdtl_Ac_Regno |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafacpdtl_Effective_num_Month |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafacpdtl_Effective_num_Year |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafacpdtl_Effective_char_Month |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacpdtl_Effective_char_Year |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacpdtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacpdtl_no_of_aircrafts |
varchar(20) |
NULL |
no.of.aircrafts associated to the corresponding fleet in particular month and year |
No |
No |
|
|
|
rafacpdtl_no_of_calenderdays |
varchar(20) |
NULL |
no.of.calender days of the corresponding month and year (eg jan 2007 - 31 , feb 2008 - 29) |
No |
No |
|
|
|
rafacpdtl_no_of_departures |
varchar(20) |
NULL |
no.of.departures |
No |
No |
|
|
|
rafacpdtl_no_of_ServiceDays |
varchar(20) |
NULL |
no.of.servicedays |
No |
No |
|
|
|
rafacpdtl_no_of_RevenuvDept |
varchar(20) |
NULL |
no.of.revenuedepartures |
No |
No |
|
|
|
rafacpdtl_no_of_NonRevDept |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacpdtl_no_of_incidents |
varchar(20) |
NULL |
no.of.incidents |
No |
No |
|
|
|
rafacpdtl_no_of_Delays |
varchar(20) |
NULL |
no.of.delays |
No |
No |
|
|
|
rafacpdtl_no_of_Substitutions |
varchar(20) |
NULL |
no.of.substitutions |
No |
No |
|
|
|
rafacpdtl_no_of_Cancel |
varchar(20) |
NULL |
no.o.cancellation |
No |
No |
|
|
|
rafacpdtl_no_of_otherinterr |
varchar(20) |
NULL |
no.of.otherinterruptions |
No |
No |
|
|
|
rafacpdtl_no_of_discrepancy |
varchar(20) |
NULL |
no.of.discrepancies |
No |
No |
|
|
|
rafacpdtl_no_of_ADDS |
varchar(20) |
NULL |
no.of.acceptabledeferreddiscrepancies |
No |
No |
|
|
|
rafacpdtl_no_of_MEL |
varchar(20) |
NULL |
no.of.MEL’s |
No |
No |
|
|
|
rafacpdtl_no_of_techDelays |
varchar(20) |
NULL |
no.of.technicaldelays |
No |
No |
|
|
|
rafacpdtl_no_of_techSubstitution |
varchar(20) |
NULL |
no.of.technicalsubstitutions |
No |
No |
|
|
|
rafacpdtl_no_of_techCancel |
varchar(20) |
NULL |
no.of.technicalcancellation |
No |
No |
|
|
|
rafacpdtl_Created_date |
datetime |
NULL |
|
No |
No |
|
|
|
rafacpdtl_Created_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacpdtl_Modified_date |
datetime |
NULL |
|
No |
No |
|
|
|
rafacpdtl_Modified_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacpdtl_Timestamp |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafacpdtl_no_of_ATB |
varchar(20) |
NULL |
no.of.ATB |
No |
No |
|
|
|
rafacpdtl_no_of_GTB |
varchar(20) |
NULL |
no.of.GTB |
No |
No |
|
|
|
rafacpdtl_no_of_Diversions |
varchar(20) |
NULL |
no.of.Diversions |
No |
No |
|
|
|
rafacpdtl_no_of_techATB |
varchar(20) |
NULL |
no.of.technicalATB |
No |
No |
|
|
|
rafacpdtl_no_of_techGTB |
varchar(20) |
NULL |
no.of.technicalGTB |
No |
No |
|
|
|
rafacpdtl_no_of_techDiversion |
varchar(20) |
NULL |
no.of.technicalDiversions |
No |
No |
|
|
|
rafacpdtl_no_of_InFltShutdwn |
varchar(20) |
NULL |
no.of.inflightshutdowns |
No |
No |
|
|
|
rafacpdtl_operating_size |
varchar(20) |
NULL |
always store either 1 or 0 based on whether the particular acreg has flown for an JLog and FH is updated > 0 in that JLog. |
No |
No |
|
|
|
rafacpdtl_no_of_MIREPdiscrepancy |
varchar(20) |
NULL |
no.of.Mechanic reported discrepancy’s |
No |
No |
|
|
|
rafacpdtl_no_of_PIREPdiscrepancy |
varchar(20) |
NULL |
no.of.Pilot reported discrepancy’s |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_Fleet_ATAStationwise_Processing_dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment ATA and Station wise processing information |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
rafatastpdtl_Ouinstance |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafatastpdtl_Fleet_no |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafatastpdtl_ATAstation_no |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafatastpdtl_Effective_num_Month |
varchar(20) |
NOT NULL |
month for which the processing is done ( format 1,2 etc ) |
No |
No |
|
|
|
rafatastpdtl_Effective_num_Year |
varchar(20) |
NOT NULL |
Year for which the processing is done ( format 2007,2008..) as integer format |
No |
No |
|
|
|
rafatastpdtl_Effective_num_week |
varchar(20) |
NOT NULL |
number of the week of the transaction date ( format 1 for 1st week of the month and year , 2 for 2nd week,etc) |
No |
No |
|
|
|
rafatastpdtl_Effective_char_Month |
varchar(20) |
NOT NULL |
month for which the processing is done ( format jan,feb etc) |
No |
No |
|
|
|
rafatastpdtl_ATAstation_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafatastpdtl_Effective_char_Year |
varchar(20) |
NULL |
Year for which the processing is done ( format 2007,2008..) |
No |
No |
|
|
|
rafatastpdtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafatastpdtl_no_of_Delays |
varchar(20) |
NULL |
no.of.delay |
No |
No |
|
|
|
rafatastpdtl_no_of_Substitutions |
varchar(20) |
NULL |
no.of.substitution |
No |
No |
|
|
|
rafatastpdtl_no_of_Cancel |
varchar(20) |
NULL |
no.of.cancellation |
No |
No |
|
|
|
rafatastpdtl_no_of_otherinterr |
varchar(20) |
NULL |
no.of.otherinterruptions |
No |
No |
|
|
|
rafatastpdtl_no_of_PIREPdiscrepancy |
varchar(20) |
NULL |
no.of.PIRepDiscrepancies |
No |
No |
|
|
|
rafatastpdtl_no_of_MIREPdiscrepancy |
varchar(20) |
NULL |
no.of.MIRepDiscrepancies |
No |
No |
|
|
|
rafatastpdtl_Created_date |
datetime |
NULL |
|
No |
No |
|
|
|
rafatastpdtl_Created_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafatastpdtl_Modified_date |
datetime |
NULL |
|
No |
No |
|
|
|
rafatastpdtl_Modified_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafatastpdtl_Timestamp |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafatastpdtl_delay_duration |
varchar(20) |
NULL |
Delay Duration |
No |
No |
|
|
|
rafatastpdtl_no_of_ATB |
varchar(20) |
NULL |
no.of.ATB |
No |
No |
|
|
|
rafatastpdtl_no_of_GTB |
varchar(20) |
NULL |
no.of.GTB |
No |
No |
|
|
|
rafatastpdtl_no_of_Diversions |
varchar(20) |
NULL |
no.of.Diversions |
No |
No |
|
|
|
rafatastpdtl_no_of_dept |
varchar(20) |
NULL |
no.of.departures |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_fleet_Status_dtl |
|
|
|||||
|
|
|
|
|||||
|
Table Comment Table to store the status of the fleet in a month and year wise |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
rafsdtl_Ouinstance |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafsdtl_Fleet_no |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafsdtl_Effective_num_Month |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafsdtl_Effective_num_Year |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rafsdtl_Effective_char_Month |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafsdtl_Effective_char_Year |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafsdtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafsdtl_Gen_date |
datetime |
NULL |
|
No |
No |
|
|
|
rafsdtl_Gen_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafsdtl_Pub_date |
datetime |
NULL |
|
No |
No |
|
|
|
rafsdtl_Pub_By |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rafsdtl_Timestamp |
varchar(20) |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_FltAlert_AlertValue_dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment Alert levels of various fleets are stored in this table |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
fltalertdtl_ATA_ou |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
fltalertdtl_ATA_no |
varchar(20) |
NOT NULL |
ATA # |
Yes |
No |
|
|
|
FltAlert_AtaAnalysis_type |
varchar() |
NOT NULL |
|
Yes |
No |
|
|
|
FltAlert_alter_value |
varchar(20) |
NULL |
Alert value |
No |
No |
|
|
|
FltAlert_Watch_value |
varchar(20) |
NULL |
Watch value |
No |
No |
|
|
|
RaAlert_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
Yes |
|
|
|
fltalertdtl_Alert_seqno |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
Raalert_Fleet_No |
varchar(20) |
NOT NULL |
Fleet # |
Yes |
Yes |
|
|
|
FltAlert_Alert_type |
varchar() |
NOT NULL |
|
Yes |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_FltAlert_AlertValue_Hdr |
|
||||||
|
|
|
|
|||||
|
Table Comment Header level details of fleets are stored in this table |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
fltalerthdr_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
fltalerthdr_fleet_no |
varchar(20) |
NOT NULL |
Fleet # |
Yes |
No |
|
|
|
fltalerthdr_Alert_seqno |
varchar(20) |
NOT NULL |
sequence no |
Yes |
No |
|
|
|
fltalerthdr_eff_from |
datetime |
NOT NULL |
Effective from date |
No |
No |
|
|
|
fltalerhdr_fleet_seqno |
varchar(20) |
NULL |
|
No |
No |
|
|
|
fltalerthdr_eff_to |
datetime |
NULL |
Effective to date |
No |
No |
|
|
|
fltalerthdr_created_date |
datetime |
NULL |
|
No |
No |
|
|
|
fltalerthdr_createdUSer |
varchar(20) |
NULL |
|
No |
No |
|
|
|
fltalerthdr_Modified_date |
datetime |
NULL |
|
No |
No |
|
|
|
fltalerthdr_ModifiedUser |
varchar(20) |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_Journey_Log_dtl |
|
|
|||||
|
|
|
|
|||||
|
Table Comment table to store the journey log leg wise details |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
rajlogdtl_Ouinstance |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rajlogdtl_Fleet_no |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rajlogdtl_AC_Regno |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rajlogdtl_Effective_num_Month |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rajlogdtl_Effective_num_Year |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rajlogdtl_RA_ReqYesno_flag |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
rajlogdtl_RA_Trandoc_flag |
varchar(20) |
NULL |
transaction flag which represents these are journey log details --JLOG |
No |
No |
|
|
|
rajlogdtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rajlogdtl_Effective_char_Month |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rajlogdtl_Effective_char_Year |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rajlogdtl_Tran_Document_no |
varchar(20) |
NULL |
journey log# |
No |
No |
|
|
|
rajlogdtl_Tran_date |
datetime |
NULL |
flight date of the journey log |
No |
No |
|
|
|
rajlogdtl_Tran_Status_flag |
varchar(20) |
NULL |
journey log status |
No |
No |
|
|
|
rajlogdtl_Leg_no |
varchar(20) |
NULL |
journeylog leg# |
No |
No |
|
|
|
rajlogdtl_Line_no |
varchar(20) |
NULL |
journeylog line# |
No |
No |
|
|
|
rajlogdtl_Flight_no |
char(18) |
NULL |
journeylog Flight# |
No |
No |
|
|
|
rajlogdtl_Flight_status |
varchar(20) |
NULL |
journey logflight status |
No |
No |
|
|
|
rajlogdtl_Flight_opstype |
varchar(20) |
NULL |
Flighttype of the journey log |
No |
No |
|
|
|
rajlogdtl_Src_Doc_Type |
varchar(20) |
NULL |
store yes/no flag based on the FH value updated thr’ a particular Jlog.If FH > 0 then ’Y’ else ’N’ |
No |
No |
|
|
|
rajlogdtl_Src_Doc_No |
varchar(20) |
NULL |
leg level departure station is stored |
No |
No |
|
|
|
rajlogdtl_Src_Doc_Desc |
varchar(20) |
NULL |
extra column is added for future requirement |
No |
No |
|
|
|
rajlogdtl_Description |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rajlogdtl_Tran_Created_date |
datetime |
NULL |
created date of the jourmey log |
No |
No |
|
|
|
rajlogdtl_Tran_Created_by |
varchar(20) |
NULL |
created by of the jourmey log |
No |
No |
|
|
|
rajlogdtl_Tran_Confirmed_date |
datetime |
NULL |
confirmed date of the jourmey log |
No |
No |
|
|
|
rajlogdtl_Tran_Confirmed_By |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rajlogdtl_RA_Created_date |
datetime |
NULL |
|
No |
No |
|
|
|
rajlogdtl_RA_Created_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rajlogdtl_RA_Modified_date |
datetime |
NULL |
|
No |
No |
|
|
|
rajlogdtl_RA_Modified_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
rajlogdtl_Timestamp |
varchar(20) |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BASRA_last_Upload_datetime |
|
||||||
|
|
|
|
|||||
|
Table Comment Table to capture upload datetime information against each month and year |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
ralstuplddate_ouinstance |
varchar(20) |
NULL |
|
No |
No |
|
|
|
ralstuplddate_lastuploaddate |
datetime |
NULL |
|
No |
No |
|
|
|
ralstuplddate_inpara_month |
varchar(20) |
NULL |
|
No |
No |
|
|
|
ralstuplddate_inpara_Year |
varchar(20) |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRa_Parameter_details_dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment All the Reliability Component metadatas are stored in this table |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RaDtl_Key_field |
varchar(20) |
NOT NULL |
A unique identifier defined for the set option parameters,Values for this key field entered manually. |
Yes |
No |
|
|
|
RADtl_componentName |
varchar(20) |
NOT NULL |
Name of the Component |
No |
No |
|
|
|
RADtl_ParameterCategory |
varchar() |
NOT NULL |
Parameter Category |
No |
No |
|
|
|
RADtl_ParamType |
varchar() |
NOT NULL |
Parameter type of meta data |
No |
No |
|
|
|
RADtl_ParamCode |
varchar() |
NOT NULL |
Parameter code of meta data |
No |
No |
|
|
|
RADtl_Languid |
varchar(20) |
NOT NULL |
Language id |
No |
No |
|
|
|
RaDtl_ParamDesc |
varchar(20) |
NULL |
Parameter Description of meta data |
No |
No |
|
|
|
RADtl_SortBy |
varchar(20) |
NULL |
Helps to sort parameter values |
No |
No |
|
|
|
RaDtl_CreatedDate |
datetime |
NULL |
Created Date |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_processed_delay_discrepancy_incident_dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment Table to capture the processed discrepancy records |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
raprocdtl_Ouinstance |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raprocdtl_Fleet_no |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raprocdtl_AC_Regno |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raprocdtl_Effective_num_Month |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raprocdtl_Effective_num_Year |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
raprocdtl_RA_Trandoc_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Effective_char_Month |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Effective_char_Year |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Tran_Document_no |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Tran_Document_lineno |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Tran_date |
datetime |
NULL |
|
No |
No |
|
|
|
raprocdtl_Tran_Status_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Src_Doc_Type |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Src_Doc_No |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Src_Doc_Desc |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Category_Type |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_station_number |
char(18) |
NULL |
|
No |
No |
|
|
|
raprocdtl_ATAno |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Delay_Duration |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Applicability |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Reported_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Resolved_date |
datetime |
NULL |
|
No |
No |
|
|
|
raprocdtl_Transfer_Partno |
char(18) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Transfer_serialno |
char(18) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Remedial_Act |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Remarks |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Description |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Reason |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Discrepancyno |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Occurrence_location |
char(18) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Phase_of_Occ |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_delay_on |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Tran_Created_date |
datetime |
NULL |
|
No |
No |
|
|
|
raprocdtl_Tran_Created_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Tran_Confirmed_date |
datetime |
NULL |
|
No |
No |
|
|
|
raprocdtl_Tran_Confirmed_By |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_RA_Created_date |
datetime |
NULL |
|
No |
No |
|
|
|
raprocdtl_RA_Created_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_RA_Modified_date |
datetime |
NULL |
|
No |
No |
|
|
|
raprocdtl_RA_Modified_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Timestamp |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Tran_Document_legno |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_flight_no |
char(18) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Pos_code |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_shutdown_datetime |
datetime |
NULL |
|
No |
No |
|
|
|
raprocdtl_Restart_datetime |
datetime |
NULL |
|
No |
No |
|
|
|
raprocdtl_Processing_status |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Tracking_status |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Disc_Category |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_param_code |
varchar() |
NULL |
|
No |
No |
|
|
|
raprocdtl_pos_type |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_component_id |
char(18) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Param_val |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Lotno |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_quantity |
char(18) |
NULL |
|
No |
No |
|
|
|
raprocdtl_Parttype |
varchar(20) |
NULL |
|
No |
No |
|
|
|
raprocdtl_levelno |
char(18) |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_QC_Quick_codes |
|
|
|||||
|
|
|
|
|||||
|
Table Comment User defined quick codes are stored in this table |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RaQC_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
RaQC_Quick_Code |
varchar(20) |
NOT NULL |
User defined quick code |
Yes |
No |
|
|
|
RaQC_QuickCode_type |
varchar() |
NOT NULL |
Quick code type |
Yes |
No |
|
|
|
RaQC_Quickcode_Desc |
varchar(20) |
NULL |
Description of User defined quick code |
No |
No |
|
|
|
RaQc_QuickCode_Status |
varchar() |
NULL |
Status of quick code |
No |
No |
|
|
|
RaQC_QuickCode_Default |
varchar() |
NULL |
’Yes’ or ’No’ value maintained |
No |
No |
|
|
|
RaQC_Timestamp |
varchar(20) |
NULL |
Time stamp |
No |
No |
|
|
|
RaQC_CreatedBy |
varchar(20) |
NULL |
Created user |
No |
No |
|
|
|
RaQC_CreatedDate |
datetime |
NULL |
Created Date |
No |
No |
|
|
|
RaQC_ModifiedBy |
varchar(20) |
NULL |
Modified User |
No |
No |
|
|
|
RaQC_ModifiedDate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|
RAqc_quickcode_mandatory |
varchar() |
NULL |
’Yes’ or ’No’ value maintained |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_RaConRpt_Config_rpt_dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment Details of Reports associated with fleets are stored in this table |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RaConRpt_CreatedBy |
varchar(20) |
NULL |
Created user |
No |
No |
|
|
|
RaConRpt_Remarks |
varchar(20) |
NULL |
Remarks |
No |
No |
|
|
|
RaConRpt_CreatedDate |
datetime |
NULL |
Created Date |
No |
No |
|
|
|
RaConRpt_ModifiedBy |
varchar(20) |
NULL |
Modified user |
No |
No |
|
|
|
RaconRpt_ModifiedDate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|
RaconRpt_Fleet_No |
varchar(20) |
NOT NULL |
Fleet # |
Yes |
Yes |
|
|
|
RaConRpt_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
Yes |
|
|
|
RaConRpt_Rpt_order |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RaConRpt_report_name |
varchar() |
NOT NULL |
Report name |
Yes |
No |
|
|
|
RaConRpt_Report_Applicable |
varchar() |
NULL |
Applicability |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BASRA_RACRDTL_COMPONENT_REPLACEMENT_DTL |
|
||||||
|
|
|
|
|||||
|
Table Comment Table to capture the component replacement details |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
racrdtl_Ouinstance |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
racrdtl_fleet_no |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
racrdtl_AC_Regno |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
racrdtl_Effective_num_Month |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
racrdtl_Effective_num_Year |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
racrdtl_RA_ReqYesno_flag |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
racrdtl_RA_Trandoc_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
racrdtl_RA_ProcessSts_flag |
varchar(20) |
NULL |
|
No |
No |
|
|
|
racrdtl_Effective_char_Month |
varchar(20) |
NULL |
|
No |
No |
|
|
|
racrdtl_Effective_char_Year |
varchar(20) |
NULL |
|
No |
No |
|
|
|
racrdtl_Tran_Document_no |
varchar(20) |
NULL |
Component Replacement# |
No |
No |
|
|
|
racrdtl_Tran_Status_flag |
varchar(20) |
NULL |
Removalstatus |
No |
No |
|
|
|
racrdtl_Tran_Type |
varchar(20) |
NULL |
(removal type) Schedule/Unschedule/Others |
No |
No |
|
|
|
racrdtl_removed_Compid |
char(18) |
NULL |
removed component id |
No |
No |
|
|
|
racrdtl_attached_Compid |
char(18) |
NULL |
installed component id |
No |
No |
|
|
|
racrdtl_Rem_Partno |
char(18) |
NULL |
Part# of the removed component |
No |
No |
|
|
|
racrdtl_Rem_Serialno |
char(18) |
NULL |
Serial# of the removed component |
No |
No |
|
|
|
racrdtl_Effective_from |
datetime |
NULL |
installed date of the removed component |
No |
No |
|
|
|
racrdtl_Effective_to |
datetime |
NULL |
removed date of the removed component |
No |
No |
|
|
|
racrdtl_Pos_type |
varchar(20) |
NULL |
position type of the removed components |
No |
No |
|
|
|
racrdtl_Pos_code |
char(18) |
NULL |
position code of the removed components |
No |
No |
|
|
|
racrdtl_level_no |
char(18) |
NULL |
level no of the removed components |
No |
No |
|
|
|
racrdtl_level_code |
char(18) |
NULL |
level code of the removed components |
No |
No |
|
|
|
racrdtl_Tran_Created_date |
datetime |
NULL |
created date of the CR |
No |
No |
|
|
|
racrdtl_Tran_Created_by |
varchar(20) |
NULL |
created bv of the CR |
No |
No |
|
|
|
racrdtl_Tran_Confirmed_date |
datetime |
NULL |
Confirmed Date of the CR |
No |
No |
|
|
|
racrdtl_Tran_Confirmed_By |
varchar(20) |
NULL |
Confirmed By of the CR |
No |
No |
|
|
|
racrdtl_RA_Created_date |
datetime |
NULL |
|
No |
No |
|
|
|
racrdtl_RA_Created_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
racrdtl_RA_Modified_date |
datetime |
NULL |
|
No |
No |
|
|
|
racrdtl_RA_Modified_by |
varchar(20) |
NULL |
|
No |
No |
|
|
|
racrdtl_Timestamp |
varchar(20) |
NULL |
|
No |
No |
|
|
|
racrdtl_Reason |
varchar(20) |
NULL |
Reason for Removal |
No |
No |
|
|
|
racrdtl_Rem_Lotno |
varchar(20) |
NULL |
Removed Lot# |
No |
No |
|
|
|
racrdtl_Source_docno |
varchar(20) |
NULL |
Source Doc# of the Removal |
No |
No |
|
|
|
racrdtl_Source_doctype |
varchar(20) |
NULL |
Source Doc type of the Removal.example - HWO,CWO and TLog |
No |
No |
|
|
|
racrdtl_Rem_PartATA |
varchar(20) |
NULL |
ATA# of the removed Part# |
No |
No |
|
|
|
racrdtl_Rem_Parttype |
varchar(20) |
NULL |
Part type of the removed Part# |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_RAFlt_Fleet_Dtl |
|
|
|||||
|
|
|
|
|||||
|
Table Comment Fleet details are stored in this table. |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RaFlt_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
RaFlt_Fleet_No |
varchar(20) |
NOT NULL |
Fleet # |
Yes |
No |
|
|
|
RAFlt_Description |
varchar(20) |
NULL |
Fleet description |
No |
No |
|
|
|
RaFlt_Status |
varchar() |
NULL |
Status |
No |
No |
|
|
|
RaFlt_Reliablity_Rep_Group |
varchar(20) |
NULL |
Reliability report group defined in quick codes |
No |
No |
|
|
|
RaFlt_AnalysisFrom |
datetime |
NULL |
From date |
No |
No |
|
|
|
RaFlt_Rep_Delay_InMin |
varchar(20) |
NULL |
Reportable delay in minutes |
No |
No |
|
|
|
RaFlt_Remarks |
varchar(20) |
NULL |
Remarks |
No |
No |
|
|
|
RaFlt_PublishedDate |
datetime |
NULL |
Published date |
No |
No |
|
|
|
RaFlt_PlannerCode_ou |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RaFlt_PlannerCode |
varchar() |
NULL |
Planner code |
No |
No |
|
|
|
RaFlt_TimeStamp |
varchar(20) |
NULL |
Timestamp |
No |
No |
|
|
|
RaFlt_CreatedBy |
varchar(20) |
NULL |
Created user |
No |
No |
|
|
|
RaFlt_CreatedDate |
datetime |
NULL |
Created date |
No |
No |
|
|
|
RaFlt_Modifiedby |
varchar(20) |
NULL |
Modified user |
No |
No |
|
|
|
RaFlt_ModifiedDate |
datetime |
NULL |
Modified date |
No |
No |
|
|
|
RaFlt_delay_limit |
varchar(20) |
NULL |
Delay limit |
No |
No |
|
|
|
raflt_Target_Despatch |
varchar(20) |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_RaFltAC_Fleet_Aircraft_Dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment Details of aircrafts associated with the fleets are stored in this table |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RaFltAc_CreatedBy |
varchar(20) |
NULL |
Created user |
No |
No |
|
|
|
RaFltAc_Remarks |
varchar(20) |
NULL |
Remarks |
No |
No |
|
|
|
RaFltAc_Effective_To |
datetime |
NULL |
Effective to date of associated aircraft to the fleet |
No |
No |
|
|
|
RaFltAC_Createddate |
datetime |
NULL |
Created date |
No |
No |
|
|
|
RaFltAC_ModifiedBy |
varchar(20) |
NULL |
Modified user |
No |
No |
|
|
|
RaFltAc_ModifiedDate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|
RaFltac_Fleet_No |
varchar(20) |
NOT NULL |
Fleet # |
Yes |
Yes |
|
|
|
RaFltac_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
Yes |
|
|
|
RaFltAc_Aircraft_ou |
varchar(20) |
NULL |
|
No |
Yes |
|
|
|
RaFltAc_Aircraft_Reg_no |
varchar(20) |
NOT NULL |
Aircraft registration # associated to fleet |
Yes |
Yes |
|
|
|
RaFltAc_Effective_From |
datetime |
NOT NULL |
Effective from date of associated aircraft to the fleet |
Yes |
Yes |
|
|
|
|
|
|
|||||
|
Table Name BasRA_RAFltATA_Fleet_ATA_dtl |
|
||||||
|
|
|
|
|||||
|
Table Comment ATA associated with the fleet are stored in this table |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RaFltATA_Remarks |
varchar(20) |
NULL |
Remarks |
No |
No |
|
|
|
RaFltAta_Timestamp |
varchar(20) |
NULL |
TIme stamp |
No |
No |
|
|
|
RAFltATA_Analysis_Required |
varchar() |
NULL |
|
No |
No |
|
|
|
RaFltATA_Major_ATA |
varchar(20) |
NULL |
Major ATA # associated to the fleet |
No |
No |
|
|
|
RaFltATA_ModifiedBy |
varchar(20) |
NULL |
Modified user |
No |
No |
|
|
|
RaFltATA_CreatedBy |
varchar(20) |
NULL |
Created user |
No |
No |
|
|
|
RaFltATA_CreatedDate |
datetime |
NULL |
Created Date |
No |
No |
|
|
|
RaFltATA_ModifiedDate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|
RaFltAta_Fleet_No |
varchar(20) |
NOT NULL |
Fleet # |
Yes |
Yes |
|
|
|
RaFltAta_ATA_no |
varchar(20) |
NOT NULL |
ATA # associated to the fleet |
Yes |
No |
|
|
|
RaFltATA_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
Yes |
|
|
|
RAFltATA_Major_ATA_ou |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RaFltATA_System_ATA_ou |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RaFltATA_ATA_ou |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
RaFltAta_System_ATA |
varchar(20) |
NULL |
System ATA # associated to the fleet |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_RRSD_Reliability_Reports_dtl |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RRSD_Ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
Yes |
|
|
|
RRSD_Fleet_no |
varchar(20) |
NOT NULL |
%AttDef |
Yes |
Yes |
|
|
|
RRSD_Report_For |
datetime |
NOT NULL |
|
Yes |
Yes |
|
|
|
RRSD_ReportName |
char(18) |
NOT NULL |
Name of the report |
Yes |
No |
|
|
|
RRSD_Archive_File |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSD_Rpt_Status |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSD_Rpt_Code |
varchar() |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_RRSH_Reliability_Reports_hdr |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
RRSH_Ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
RRSH_Fleet_no |
varchar(20) |
NOT NULL |
%AttDef |
Yes |
No |
|
|
|
RRSH_Report_For |
datetime |
NOT NULL |
|
Yes |
No |
|
|
|
RRSH_Status |
char(18) |
NULL |
Status |
No |
No |
|
|
|
RRSH_User_Status |
char(18) |
NULL |
|
No |
No |
|
|
|
RRSH_ReportBook |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_Remarks |
varchar(20) |
NULL |
%AttDef |
No |
No |
|
|
|
RRSH_Archive_Reference |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_UploadUser |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_UploadDate |
datetime |
NULL |
|
No |
No |
|
|
|
RRSH_generatedUser |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_generatedDate |
datetime |
NULL |
|
No |
No |
|
|
|
RRSH_ConsolidatedUser |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_ConsolidatedDate |
datetime |
NULL |
|
No |
No |
|
|
|
RRSH_PublishedUser |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_PublishedDate |
datetime |
NULL |
|
No |
No |
|
|
|
RRSH_CreatedUser |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_CreatedDate |
datetime |
NULL |
|
No |
No |
|
|
|
RRSH_Rpt_Group_Fleet_Name |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_Rpt_Group_Opt |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_Upload_initiated_User |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_Upload_initiated_Date |
datetime |
NULL |
|
No |
No |
|
|
|
RRSH_ModifiedUser |
varchar(20) |
NULL |
|
No |
No |
|
|
|
RRSH_ModifiedDate |
datetime |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BasRA_Set_Option_dtl |
|
|
|||||
|
|
|
|
|||||
|
Table Comment Set option multiline details are stored in this table |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
SetOptdtl_Ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
SetOpt_OptKeyCode |
varchar(20) |
NOT NULL |
A unique identifier defined for the set options,Values for this key field entered manually. |
Yes |
Yes |
|
|
|
SetOptdtl_Status |
varchar() |
NULL |
Status |
No |
No |
|
|
|
SetOptdtl_Value |
varchar(20) |
NULL |
|
No |
No |
|
|
|
SetOptDtl_modifiedBy |
varchar(20) |
NULL |
Modified user |
No |
No |
|
|
|
SetOptDtl_modifiedDate |
datetime |
NULL |
Modified Date |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name basra_set_option_hdr |
|
|
|||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
setopthdr_ouinstance |
varchar(20) |
NULL |
|
No |
No |
|
|
|
setopthdr_initiatedate |
datetime |
NULL |
|
No |
No |
|
|
|
setopthdr_timestamp |
varchar(20) |
NULL |
|
No |
No |
|
|
|
setopthdr_createdby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
setopthdr_createddate |
datetime |
NULL |
|
No |
No |
|
|
|
setopthdr_modiifedby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
setopthdr_modifieddate |
datetime |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name basra_set_option_Param_values |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
SetOpt_OptKeyCode |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
SetOpt_Metadata_type |
varchar() |
NULL |
|
No |
No |
|
|
|
SetOpt_paramcode |
varchar() |
NULL |
|
No |
No |
|
|
|
SetOpt_paramDesc |
varchar(20) |
NULL |
|
No |
No |
|
|
|
SetOpt_permittedvalue |
varchar(20) |
NULL |
|
No |
No |
|
|
|
SetOpt_Mandatory_Check |
varchar() |
NULL |
|
No |
No |
|
|
|
SetOpt_Sotrby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
Setopt_createdDate |
datetime |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name Basra_setmtbur_av_dtl |
|
|
|||||
|
|
|
|
|||||
|
Table Comment Table is to capture part #, MTBUR FH for a fleet given |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Raset_av_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
Raset_av_fleetno |
varchar(20) |
NOT NULL |
Fleet # |
Yes |
No |
|
|
|
Raset_av_partno |
char(18) |
NOT NULL |
Part # |
Yes |
No |
|
|
|
Raset_av_alertval |
varchar(20) |
NULL |
MTBUR FH value for a part # |
No |
No |
|
|
|
Raset_av_remarks |
varchar(20) |
NULL |
remarks |
No |
No |
|
|
|
Raset_av_createdby |
varchar(20) |
NULL |
created by |
No |
No |
|
|
|
Raset_av_createddate |
datetime |
NULL |
created date |
No |
No |
|
|
|
Raset_av_lastmodifiedby |
varchar(20) |
NULL |
modified by |
No |
No |
|
|
|
Raset_av_lastmodifieddate |
datetime |
NULL |
modified date |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name Basra_setmtbur_hdr |
|
|
|||||
|
|
|
|
|||||
|
Table Comment Table is to capture no of parts entered in alert value ,watch list and support agreement tab pages for a fleet |
|||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Raset_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
Raset_FleetNo |
varchar(20) |
NOT NULL |
Fleet # |
Yes |
No |
|
|
|
Raset_AV_partcnt |
int |
NULL |
no of parts entered in alert value tab page |
No |
No |
|
|
|
Raset_wl_partcnt |
int |
NULL |
no of parts entered in watch list tab page |
No |
No |
|
|
|
Raset_SA_cnt |
int |
NULL |
no of support agreement type entered in support agreement tab page |
No |
No |
|
|
|
Raset_SA_partcnt |
int |
NULL |
no of parts entered in support agreement tab page |
No |
No |
|
|
|
|
|
|
|||||
|
Table Name Basra_setmtbur_sa_dtl |
|
|
|||||
|
|
|
|
|||||
|
Table Comment Table is to capture informations related to support agreement. |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Raset_SA_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
Raset_SA_FleetNo |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
Raset_SA_PartNo |
char(18) |
NOT NULL |
|
Yes |
No |
|
|
|
Raset_SA_Supcode |
varchar(45) |
NOT NULL |
Supplier code |
Yes |
No |
|
|
|
Raset_SA_Efffrom |
datetime |
NOT NULL |
Effective from date of part with supplier |
Yes |
No |
|
|
|
Raset_SA_Effto |
datetime |
NULL |
Effective to date of part with supplier |
No |
No |
|
|
|
Raset_SA_Satype |
varchar(20) |
NULL |
support agreement type of a part |
No |
No |
|
|
|
Raset_SA_Schval |
varchar(20) |
NULL |
MTBUR FH value |
No |
No |
|
|
|
Raset_SA_Remarks |
varchar(20) |
NULL |
Remarks |
No |
No |
|
|
|
Raset_SA_Createdby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
Raset_SA_Createddate |
datetime |
NULL |
|
No |
No |
|
|
|
Raset_SA_modifiedby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
Raset_SA_modifieddate |
datetime |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name Basra_setmtbur_wl_dtl |
|
|
|||||
|
|
|
|
|||||
|
Table Comment Table is to capture part # and analysis related information for a fleet given |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
Raset_WL_ouinstance |
varchar(20) |
NOT NULL |
|
Yes |
No |
|
|
|
Raset_WL_FleetNo |
varchar(20) |
NOT NULL |
Fleet # |
Yes |
No |
|
|
|
Raset_WL_PartNo |
char(18) |
NOT NULL |
Part # |
Yes |
No |
|
|
|
Raset_WL_Reasonforinl |
varchar(20) |
NULL |
Reason for inclusion |
No |
No |
|
|
|
Raset_WL_Anastatus |
char(18) |
NULL |
Analysis status can contain the values Analyzed or Under analysis |
No |
No |
|
|
|
Raset_WL_Anasdet |
varchar(20) |
NULL |
Analysis details |
No |
No |
|
|
|
Raset_WL_Createdby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
Raset_WL_Createddate |
datetime |
NULL |
|
No |
No |
|
|
|
Raset_WL_modifiedby |
varchar(20) |
NULL |
|
No |
No |
|
|
|
Raset_WL_modifieddate |
datetime |
NULL |
|
No |
No |
|
|
|
|
|
|
|||||
|
Table Name BASRA_UDHDR_Upload_reliability_Data_Hdr |
|
||||||
|
|
|
|
|||||
|
Table Comment Upload Header Information |
|
||||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
|
|
URDHDR_Report_For |
datetime |
NOT NULL |
Upload month and year is stored in Datetime format |
No |
No |
|
|
|
URDHDR_Ouinstance |
varchar(20) |
NOT NULL |
|
No |
No |
|
|
|
URDHDR_Status |
char(18) |
NULL |
Upload Status |
No |
No |
|
|
|
URDHDR_Month |
varchar(20) |
NULL |
Upload Month |
No |
No |
|
|
|
URDHDR_Year |
varchar(20) |
NULL |
Upload Year |
No |
No |
|
|
|
URDHDR_Upload_initiated_User |
varchar(20) |
NULL |
User initiated the Upload task |
No |
No |
|
|
|
URDHDR_Upload_initiated_Date |
datetime |
NULL |
Upload initiated datetime |
No |
No |
|
|
|
URDHDR_Upload_User |
varchar(20) |
NULL |
User Complete the Upload task |
No |
No |
|
|
|
URDHDR_Upload_Date |
datetime |
NULL |
Upload Completed Datetime |
No |
No |
|
|
|
|
|
|
|
|
|
|
|