Data Dictionary -- Configuration

Srl. No.	Table Name	Comment
1	CFG_CAD_COMP_ATTACH_DTL	Component attachment details is stored here in this table
2	CFG_CBMELD_MDLCFG_MEL_DET	Minimum equipment list for the Baselined Model Configuration is maintained
3	CFG_CFBACD_AC_CONFIG_DTL	Position Codes and their associated parts for a baselined aircraft configuration is maintained here
4	CFG_CFBACN_AC_CONFIG_NOTES	Notes related to the Baselined Aircraft Configuration is maintained
5	CFG_CFBAC_AIRCRAFT_CONFIG	Stores Aircraft-Model-Configuration class Details is maintained here
6	CFG_CFBAIC_CFGAC_INTCHG_RULE	This table maintains the interchangability rules related to the various position codes in the tree for an baselined aircraft configuration
7	CFG_CFBAIX_CFGAC_INTMX_RULE	This table maintains the intermixing rules for an baselined Aircraft Configuration.
8	CFG_CFBATW_CFGAC_ETOP_TWNPS	This table maintains the various etop twin positions for the baselined Aircraft Configuration
9	CFG_CFBCMD_CMP_CONFIG_DTL	This definition of the various position codes and their level for a baselined component configuration are maintained in this table
10	CFG_CFBCMP_COMP_CONFIG	Baselined Component Configuration is maintained here
11	CFG_CFBCNT_CMP_CONFIG_NOTES	Notes for Baselined component Configuration is maintained here
12	CFG_CFBMCD_MDL_CONFIG_CDL	Component Deviation List for Baselined Model Configuration details is get store here
13	CFG_CFBMDL_MODEL_CONFIG	Baselined Model Configuration details get stored here
14	CFG_CFBMDT_MDL_CONFIG_DTL	Position code details for the Baselined Model Configuration is get stored here
15	CFG_CFBMEL_MDL_CONFIG_MEL	Baselined Minimum equipment list for the model configuration
16	CFG_CFBMIC_MDLCFG_INTCHGE_RULE	Interchangable rules for the Model - Baselined versions alone is get stored in this table
17	CFG_CFBMIX_MDLCFG_INTMX_RULE	Intermixing Rules for Model position codes - Baselined versions alone
18	CFG_CFBMLK_MODEL_LINK_INFO	Indicates whether the interchangeability rules, intermixing rules and ETOP twin position rules have been entered for the position. The system displays one of the following options:
19	CFG_CFBMNT_MDLCFG_NOTES	This table maintains the notes for Baselined Model configuration
20	CFG_CFBMTW_MDLCFG_ETOP_TWNPS	ETop Twin positions for Baselined Model Configuration
21	CFG_CFBPNT_PART_NOTES	Baselined Part Configuration - Notes Details
22	CFG_CFBPTT_PART_CONFIG_DTL	Baselined Part Configuration Position code details
23	CFG_CFBPT_PART_CONFIG	Baselined Part Configuration details is get stored here
24	CFG_CFGACD_AC_CONFIG_DTL	Position Codes and their associated parts for a aircraft configuration is maintained here. Readiness log details like component Id and serial number details for all the parts in the aircraft are also maintained here
25	CFG_CFGACD_COMP	Component associated Aircraft in the congiguration process concern details is get stored here
26	CFG_CFGACH_ACHISTORY_LOG	Aircraft History Log data is stored in this table
27	CFG_CFGACN_AC_CONFIG_NOTES	Notes related to the Aircraft Configuration is maintained
28	CFG_CFGAC_AIRCRAFT_CONFIG	Aircraft Configuration Details are maintained here
29	CFG_CFGAC_STATUS_UPDTL	aircraft configyration status updation details
30	CFG_CFGAEO_AC_EO_LIST	Aircraft Registration change option association with Engineering Order Component
31	CFG_CFGAIC_CFGAC_INTCHG_RULE	This table maintains the interchangability rules related to the various position codes in the tree for an aircraft configuration
32	CFG_CFGAIX_CFGAC_INTMX_RULE	This table maintains the intermixing rules for an Aircraft Configuration.
33	CFG_CFGAPS_ACCFG_SPPART_POS	This table maintains the various spare parts for the aircraft configuration
34	CFG_CFGAPS_CFGAC_PERM_SRLNO	Stores aps details for Aircraft model and part
35	CFG_CFGASP_ACCFG_SPARE_PART	List of Spare Parts for the Aircraft Configuration is maintained here
36	CFG_CFGATW_CFGAC_ETOP_TWNPS	This table maintains the various etop twin positions for the Aircraft Configuration
37	CFG_CFGCEO_CMP_EO_LIST	List of EOs which has triggered the COmponent Configuration Changes
38	CFG_CFGCL_CONFIG_CLASS_INFO	This table maintains the various Configuration Class information
39	CFG_CFGCMD_CMP_CONFIG_DTL	This definition of the various position codes and their level are maintained in this table
40	CFG_CFGCMP_COMP_CONFIG	Component Configuration is maintained here
41	CFG_CFGCM_CFGMDL_ASSOCIATION	The mapping of Configuration Class to Models is maintained here
42	CFG_CFGCNT_CMP_CONFIG_NOTES	Notes for component Configuration is maintained here
43	CFG_CFGCPS_CMP_SPPART_POS	Various position codes of the spare part which is tracked is maintained here
44	CFG_CFGCRH_CRHISTORY_LOG	Component History Log Table
45	CFG_CFGCSP_CMPCFG_SPARE_PART	Spare part list for the component configuration
46	CFG_CFGMCD_MDL_CONFIG_CDL	Component Deviation List for Model Configuration
47	CFG_CFGMDL_MODEL_CONFIG	Model Configuration details
48	CFG_CFGMDL_POSTATTRIB_DTL	Stores Details Of Position Attributes
49	CFG_CFGMDT_MDL_CONFIG_DTL	Position code details for the Model Configuration
50	CFG_CFGMELC_MEL_CATEGORY	Minimum Equipment list Category Detailas are get stored here
51	CFG_CFGMELP_MEL_CATG_PARAM	Parameter Deferral limit details for the MEL Category
52	CFG_CFGMEL_MDL_CONFIG_MEL	Minimum equipment list for the model configuration
53	CFG_CFGMEO_MODEL_EO_LIST	List of Engineering Orders that changed model configuration.
54	CFG_CFGMIC_MDLCFG_INTCHGE_RULE	Interchangable rules for the Model
55	CFG_CFGMIX_MDLCFG_INTMX_RULE	Intermixing Rules for Model position codes
56	CFG_CFGMLK_MODEL_LINK_INFO	Model Configuration Link Information
57	CFG_CFGMNT_MDLCFG_NOTES	This table stores Model Configuration Notes , Config Class, Revision Number against each model.
58	CFG_CFGMPS_MDCFG_SPPART_POS	Position Code definition for the trackable spare parts in the model
59	CFG_CFGMSP_MDCFG_SPARE_PART	Spare Part list for Model Configuration
60	CFG_CFGMTW_MDLCFG_ETOP_TWNPS	ETop Twin positions for Model Configuration
61	CFG_CFGPEO_PART_EO_LIST	This Table maintains the list of EOs that trigger the Part revisions
62	CFG_CFGPNT_PART_NOTES	This table maintains the notes for Part Configuration
63	CFG_CFGPPP_CFGPRT_SPPT_POS	Position codes that are tracked in the Spare part
64	CFG_CFGPSP_PRTCFG_SPARE_PART	Spare Part List for part configuration
65	CFG_CFGPTT_PART_CONFIG_DTL	Part Configuration Table
66	CFG_CFGPT_PART_CONFIG	Part Configuration
67	CFG_CFMELD_MDLCFG_MEL_DET	Minimum equipment list for the Model Configuration is maintained
68	CFG_CFPEXP_PART_HIERARCHY	The entire structure for a part that is mapped to a Model configuration is maintained here
69	CFG_MDLOG_MDL_CHG_LOG	Model Configuration Change Log
70	CFG_PARAMETER_DETAILS	The meta data details are get stored here
71	CFG_POSPRT_CHANGE_LOG	The part position change details are get stored here
72	CFG_PRTLOG_CHG_LOG	Part Configuration Change Log table

Table Name :	CFG_CAD_COMP_ATTACH_DTL
Comment :	Component attachment details is stored here in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CAD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CAD_COMPONENT_ID	_varchar_90	varchar(90)	No	The number identifying the child component that is attached to the position code	Yes
CAD_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Register No of the Aircraft to which the component is attached	No
CAD_PARENT_COMP_ID	_varchar_90	varchar(90)	Yes	The Number Identifying the Parent component	No
CAD_ROOT_NODE	_varchar_90	varchar(90)	Yes	Root Node in hierachy	No
CAD_LEVEL_CODE	udd_cnfglvlcd	varchar(150)	Yes	Level code	No
CAD_POSITION_CODE	udd_positioncode	varchar(25)	Yes	Position code	No

Table Name :	CFG_CBMELD_MDLCFG_MEL_DET
Comment :	Minimum equipment list for the Baselined Model Configuration is maintained

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CBMELD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CBMELD_MODEL_NO	_varchar_20	varchar(20)	No	Aircraft Model No associated with the aircraft.	Yes
CBMELD_CONFIG_CLASS	_varchar_30	varchar(30)	No	The configuration class of the aircraft model, from which the configuration details must be copied	No
CBMELD_REVNO	_varchar_40	varchar(40)	No	The revision number of the model configuration	Yes
CBMELD_POS_CODE	_varchar_25	Varchar(25)	No	Position Code In minimum equipment list	No
CBMELD_PART_NO	_varchar_40	varchar(40)	No	The part number that can be fitted in the position code	No
CBMELD_LEVEL_CODE	_varchar_150	varchar(150)	No	Level Code	Yes
CBMELD_CONDITION	udd_txt2000	varchar(2000)	Yes	Condition of the part	No
CBMELD_MAINT_IMPLICATION	_varchar_255	varchar(255)	Yes	Maintenance Implications if any	No
CBMELD_OPER_IMPLICATION	_varchar_255	varchar(255)	Yes	Operational Implications if any	No
CBMELD_CONDITIONAL_FLAG	_varchar_25	Varchar(25)	Yes	Conditional Flag	No
CBMELD_MEL_FLAG	_varchar_25	Varchar(25)	Yes	Minimum Equipment List flag	No
CBMELD_LEVEL_NO	_varchar_150	varchar(150)	Yes	minimum equipment list Level Number	No
CBMELD_NHA_NO	_varchar_40	varchar(40)	Yes	Next Higher Assembly number	No
CBMELD_PLACARD	_varchar_5	varchar(5)	Yes	Placard N- Not Required R- Required	No
CBMELD_PLACARD_INST	_varchar_2000	varchar(2000)	Yes	Placard Instructions	No
CBMELD_MEL_ITEM_CODE	_varchar_30	varchar(30)	No	Minimum Equipment List Item code	Yes
cbmeld_deferral_task	_varchar_30	varchar(30)	Yes	The task type which to be deferred	No
cbmelD_deferral_rev_task	_varchar_40	varchar(40)	Yes	The deferrel revised task type details	No

Table Name :	CFG_CFBACD_AC_CONFIG_DTL
Comment :	Position Codes and their associated parts for a baselined aircraft configuration is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBACD_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	Yes
CFBACD_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration No.	Yes
CFBACD_REVNO	_varchar_40	varchar(40)	No	Revision No.	Yes
CFBACD_POS_CODE	_varchar_25	Varchar(25)	No	Position Code	Yes
CFBACD_POS_PART_NO	_varchar_40	varchar(40)	Yes	Part number associated with the position code	No
CFBACD_POS_STATUS	_varchar_15	varchar(15)	Yes	Position Status. Can be either Active or Inactive.	No
CFBACD_POS_TYPE	_varchar_25	Varchar(25)	Yes	Position Type. Can be either "Engine", "APU", "Landing Gear" or "Others"	No
CFBACD_ROT_MAN_FLAG	_varchar_25	Varchar(25)	Yes	Rotable Mandatory Flag indicates if a rotatable is mandatory or not. Can take values "Yes" or "No"	No
CFBACD_ZONECODE	_varchar_15	varchar(15)	Yes	Zone code. Place where the position is located in the Aircraft	No
CFBACD_ATA_NO	_varchar_16	varchar(16)	Yes	Air Traffic Association Chapter number	No
CFBACD_DRAWING_ID	_varchar_40	varchar(40)	Yes	Drawing Id	No
CFBACD_DOC_PATH	_varchar_50	varchar(50)	Yes	Document Path where the drawing is available	No
CFBACD_LEVEL_NO	_varchar_150	varchar(150)	Yes	This indicates the level in which the position codes exists	No
CFBACD_LEVEL_CODE	_varchar_150	varchar(150)	Yes	System generated code for the various positions in the hierarchy	No
CFBACD_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Component Id associated with the aircraft	No
CFBACD_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number	No
CFBACD_DATE_OF_ATTACH	_datetime_8	datetime(8)	Yes	Date of Attachment	No
CFBACD_TIME_OF_ATTACH	_datetime_8	datetime(8)	Yes	Time of Attachment	No
CFBACD_POS_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Position Part Number	No
CFBACD_COMPONENT_REVNO	_varchar_40	varchar(40)	Yes	Component Revision Number	No
CFBACD_COMP_CONDITION	_varchar_5	varchar(5)	Yes	Component Condition	No
CFBACD_FROM_DATE	_datetime_8	datetime(8)	Yes	From Date	No
CFBACD_BODY_STATION_NO	_varchar_15	varchar(15)	Yes	body station number	No
CFBACD_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Sequence Number	No
CFBACD_CARGO_FLAG	_varchar_5	varchar(5)	Yes	Cargo Flag	No
CFBACD_RVSM_FLAG	_varchar_5	varchar(5)	Yes	reduced vertical seperation maintanance flag	No
CFBACD_LINK_FLAG	_varchar_75	varchar(75)	Yes	Link Flag Info	No
cfbacd_DISP_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Display Sequence Number	No
cfbacd_attach_status	_varchar_5	varchar(5)	Yes	can be of Fresh,Active,Cancel,inactive	No
CFBACD_REMARKS	udd_notes	varchar(2000)	Yes	remarks	No
CFBACD_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Id	No

Table Name :	CFG_CFBACN_AC_CONFIG_NOTES
Comment :	Notes related to the Baselined Aircraft Configuration is maintained

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBACN_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBACN_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration No.	Yes
CFBACN_REVNO	_varchar_40	varchar(40)	No	Revision No.	Yes
CFBACN_NOTES	_varchar_2000	varchar(2000)	Yes	Notes	No

Table Name :	CFG_CFBAC_AIRCRAFT_CONFIG
Comment :	Stores Aircraft-Model-Configuration class Details is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBAC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBAC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	The aircraft model for which the configuration details must be entered	Yes
CFBAC_REVNO	_varchar_40	varchar(40)	No	The revision number of the model configuration.	Yes
CFBAC_CONFIG_CLASS	_varchar_30	varchar(30)	No	The configuration class of the aircraft model	No
CFBAC_MODEL_OU	_decimal_10_0	decimal(10)	Yes	Model ouinstance	No
CFBAC_MODEL_NO	_varchar_20	varchar(20)	Yes	The aircraft model, the configuration details of which are to be copied into the model configuration	No
CFBAC_STATUS	_varchar_15	varchar(15)	No	can be of Fresh,Active,Cancel,inactive	No
CFBAC_CREATED_BY	_varchar_30	varchar(30)	Yes	name of the person who created the act user	No
CFBAC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by the user	No
CFBAC_APPROVED_BY	_varchar_30	varchar(30)	Yes	Approved by the user	No
CFBAC_APPROVEDDATE	_datetime_8	datetime(8)	Yes	Approved Date	No
CFBAC_CREATIONDATE	_datetime_8	datetime(8)	Yes	created date of the config process	No
CFBAC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	modified date of the config process	No

Table Name :	CFG_CFBAIC_CFGAC_INTCHG_RULE
Comment :	This table maintains the interchangability rules related to the various position codes in the tree for an baselined aircraft configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBAIC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBAIC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration No.	Yes
CFBAIC_REVNO	_varchar_40	varchar(40)	No	The revision number of the model configuration	Yes
CFBAIC_LEVEL_CODE	_varchar_150	varchar(150)	No	Level Code	Yes
CFBAIC_POS_CODE	_varchar_25	Varchar(25)	No	The code identifying the position in the component displayed in the "Component Details"	Yes
CFBAIC_POS_PART_NO	_varchar_40	varchar(40)	No	Position Part Number	Yes
CFBAIC_INTERCHANGE_PART	_varchar_40	varchar(40)	No	Part number that can be an alternative to the part number defined for the position	Yes
CFBAIC_CONFIG_CLASS	_varchar_30	varchar(30)	Yes	Configuration Class	No
CFBAIC_ORDER_OF_PREF	_decimal_10_0	decimal(10)	Yes	Order of preference of the interchangable part	No
CFBAIC_MOD_STATUS	_varchar_15	varchar(15)	Yes	Mod Status gives the document number which has authorized the interchange	No
CFBAIC_REMARKS	udd_notes	varchar(2000)	Yes	remarks	No
CFBAIC_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Id	No

Table Name :	CFG_CFBAIX_CFGAC_INTMX_RULE
Comment :	This table maintains the intermixing rules for an baselined Aircraft Configuration.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBAIX_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBAIX_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration No.	Yes
CFBAIX_REVNO	_varchar_40	varchar(40)	No	The revision number of the component configuration	Yes
CFBAIX_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class	Yes
CFBAIX_LEVEL_CODE	_varchar_150	varchar(150)	No	Level Code	Yes
CFBAIX_POS_CODE	_varchar_25	Varchar(25)	No	The code identifying the position in the component	Yes
CFBAIX_POS_PART_NO	_varchar_40	varchar(40)	No	Position Part Number	Yes
CFBAIX_DEP_POS_CODE	_varchar_25	Varchar(25)	No	Dependent Position Code	No
CFBAIX_DEP_LEVEL_CODE	_varchar_150	varchar(150)	No	Dependent Level Code	Yes
CFBAIX_LEVEL_NO	_varchar_150	varchar(150)	Yes	Level Number	No
CFBAIX_DEP_PART_NO	_varchar_40	varchar(40)	Yes	Part number associated with the dependent position code	No
CFBAIX_REV_FLAG	_varchar_25	Varchar(25)	Yes	Reversible Flag. Can be either "Yes" or "No"	No
CFBAIX_REMARKS	udd_notes	varchar(2000)	Yes	remarks	No
CFBAIX_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Id	No

Table Name :	CFG_CFBATW_CFGAC_ETOP_TWNPS
Comment :	This table maintains the various etop twin positions for the baselined Aircraft Configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBATW_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBATW_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration No	Yes
CFBATW_REVNO	_varchar_40	varchar(40)	No	Revison no of the component Configuration	Yes
CFBATW_LEVEL_CODE	_varchar_150	varchar(150)	No	Etop Level Code	Yes
CFBATW_POS_CODE	_varchar_25	Varchar(25)	No	The code identifying the position in the component	Yes
CFBATW_POS_PART_NO	_varchar_40	varchar(40)	No	Position Part Number	Yes
CFBATW_TWIN_POS_CODE	_varchar_25	Varchar(25)	No	Twin position code	No
CFBATW_TWIN_LEVEL_CODE	_varchar_150	varchar(150)	No	Etop Twin Level Code	Yes
CFBATW_CONFIG_CLASS	_varchar_30	varchar(30)	Yes	Configuration Class	No
CFBATW_TWIN_PART_NO	_varchar_40	varchar(40)	Yes	Part number associated with the twin position code	No

Table Name :	CFG_CFBCMD_CMP_CONFIG_DTL
Comment :	This definition of the various position codes and their level for a baselined component configuration are maintained in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBCMD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBCMD_COMPONENTID	_varchar_90	varchar(90)	No	Component Id associated with the aircraft	Yes
CFBCMD_REVNO	_varchar_40	varchar(40)	No	Revison No.	Yes
CFBCMD_POS_CODE	_varchar_25	Varchar(25)	No	Position code associated with the component	Yes
CFBCMD_POS_PART_NO	_varchar_40	varchar(40)	Yes	part associated to the position code	No
CFBCMD_POS_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Position Part Number	No
CFBCMD_ROOT_NODE	_varchar_90	varchar(90)	No	Root Node	Yes
CFBCMD_NHA	_varchar_40	varchar(40)	Yes	Next Higher Assembly	No
CFBCMD_NHA_REVNO	_varchar_40	varchar(40)	Yes	NHA Revision Number	No
CFBCMD_ROT_MAN_FLAG	_varchar_25	Varchar(25)	Yes	This flag indicates if a rotable should always exists in the position code	No
CFBCMD_POS_TYPE	_varchar_25	Varchar(25)	Yes	Type of the position code. Can be "Engine", "APU", "Landing Gear" or "Others"	No
CFBCMD_DRAWING_ID	_varchar_40	varchar(40)	Yes	Drawing Id	No
CFBCMD_DOC_PATH	_varchar_50	varchar(50)	Yes	Path in which the Drawing exists	No
CFBCMD_LEVEL_CODE	_varchar_150	varchar(150)	Yes	Unique identifier for each node in the configuration	No
CFBCMD_LEVEL_NO	_varchar_150	varchar(150)	Yes	level number of the node	No
CFBCMD_ZONECODE	_varchar_15	varchar(15)	Yes	zone code	No
CFBCMD_ATA_NO	_varchar_30	varchar(30)	Yes	ATA Chapter number	No
CFBCMD_ROT_COMP	_varchar_90	varchar(90)	Yes	Rotable Component number	No
CFBCMD_ROT_REVNO	_varchar_40	varchar(40)	Yes	Rotable Revision Number	No
CFBCMD_ROT_SERIAL_NO	_varchar_40	varchar(40)	Yes	Rotable Serial Number	No
CFBCMD_DATE_OF_ATTACH	_datetime_8	datetime(8)	Yes	Date of Attachment	No
CFBCMD_TIME_OF_ATTACH	_datetime_8	datetime(8)	Yes	Time of Attachment	No
CFBCMD_CHILD_EXISTS_FLAG	_varchar_25	Varchar(25)	Yes	Flag for the existance of child level	No
CFBCMD_ROOT_REVNO	_varchar_40	varchar(40)	No	Root Revision Number	Yes
CFBCMD_POS_STATUS	_varchar_15	varchar(15)	Yes	can be of Active A or inactive I	No
CFBCMD_COMP_CONDITION	_varchar_5	varchar(5)	Yes	Component Condition	No
CFBCMD_FROM_DATE	_datetime_8	datetime(8)	Yes	Component Effective From Date	No
CFBCMD_DISP_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Display Sequence Number	No
cfbcmd_attach_status	_varchar_5	varchar(5)	Yes	can be of Fresh,Active,Cancel,inactive .maximum null value is maintained in the table	No
CFBCMD_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFBCMD_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks ID	No
CFBCMD_REMARKSID	udd_guid	varchar(40)	Yes	Remarks_ID	No

Table Name :	CFG_CFBCMP_COMP_CONFIG
Comment :	Baselined Component Configuration is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBCMP_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUIstance	Yes
CFBCMP_COMPONENTID	_varchar_90	varchar(90)	No	Component Id associated with the aircraft	Yes
CFBCMP_REVNO	_varchar_40	varchar(40)	No	Revision number of the component configuration	Yes
CFBCMP_APPROVEDDATE	_datetime_8	datetime(8)	Yes	Approval Date	No
CFBCMP_CREATED_BY	_varchar_30	varchar(30)	Yes	name of the person who created the act	No
CFBCMP_COMPONENTID_STATUS	_varchar_15	varchar(15)	Yes	Status of the Component ID	No
CFBCMP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By-name of the person	No
CFBCMP_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CFBCMP_APPROVED_BY	_varchar_30	varchar(30)	Yes	Approved By-name of the person	No
CFBCMP_CREATIONDATE	_datetime_8	datetime(8)	Yes	Configuration Creation Date	No
CFBCMP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last modified date of the config process	No
CFBCMP_STATUS	_varchar_15	varchar(15)	No	Status of the Configuration. Can be either "Fresh", "Active", "Revised" or "Cancelled"	No

Table Name :	CFG_CFBCNT_CMP_CONFIG_NOTES
Comment :	Notes for Baselined component Configuration is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBCNT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBCNT_COMPONENTID	_varchar_90	varchar(90)	No	Component Id associated with the aircraft	Yes
CFBCNT_REVNO	_varchar_40	varchar(40)	No	Revison No.	Yes
CFBCNT_NOTES	_varchar_2000	varchar(2000)	Yes	Notes related to the act	No
CFBCNT_NOTES_ID	udd_guid	varchar(40)	Yes	Notes Identification number	No

Table Name :	CFG_CFBMCD_MDL_CONFIG_CDL
Comment :	Component Deviation List for Baselined Model Configuration details is get store here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBMCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBMCD_MODEL_NO	_varchar_20	varchar(20)	No	Model No associated with the aircraft	Yes
CFBMCD_CONFIG_CLASS	_varchar_30	varchar(30)	No	Congiuration class-user defined	Yes
CFBMCD_REVNO	_varchar_40	varchar(40)	No	Revision NO	Yes
CFBMCD_PART_NO	_varchar_40	varchar(40)	Yes	Part Number which is a CDL	No
CFBMCD_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Part Number	No
CFBMCD_MAINT_IMPLICATION	_varchar_255	varchar(255)	Yes	Maintenance Implications if any	No
CFBMCD_OPER_IMPLICATION	_varchar_255	varchar(255)	Yes	Operational Implications if any	No
CFBMCD_CDL_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
CFBMCD_CDL_ITEM_CODE	_varchar_30	varchar(30)	No	Configuration deviation list code	Yes
CFBMCD_CDL_ITEM_DESC	_varchar_150	varchar(150)	Yes	Configuration deviation list Item Description	No
CFBMCD_CDL_QTY	_decimal_28_8	decimal(28)	Yes	Configuration deviation list in quantity Quantity	No
CFBMCD_CDL_MIN_QTY	_decimal_28_8	decimal(28)	Yes	Configuration deviation list Minimum Quantity	No
CFBMCD_CDL_ITEM_STATUS	_varchar_15	varchar(15)	Yes	Configuration deviation list Item Status	No
CFBMCD_PLACARD	_varchar_5	varchar(5)	Yes	Placard R-Required N-NotRequired	No
CFBMCD_PLACARD_INST	_varchar_2000	varchar(2000)	Yes	Placard Instructions	No
cfbmcd_deferral_task	_varchar_30	varchar(30)	Yes	Defferal Task code	No
cfbmcd_deferral_rev_task	_varchar_40	varchar(40)	Yes	deferrel revised task data	No
CFBMCD_DEF_CATEGORY	udd_melcategory	varchar(30)	Yes	Defeault catergory mostly null value	No

Table Name :	CFG_CFBMDL_MODEL_CONFIG
Comment :	Baselined Model Configuration details get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBMDL_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
CFBMDL_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class Name	Yes
CFBMDL_MODEL_NO	_varchar_20	varchar(20)	No	Model No associated with the aircraft	Yes
CFBMDL_REVNO	_varchar_40	varchar(40)	No	revision number	Yes
CFBMDL_MODEL_OU	_decimal_10_0	decimal(10)	Yes	OU of the Model	No
CFBMDL_STATUS	_varchar_15	varchar(15)	Yes	Status of the configuration. Can be active or fresh or revised or cancelled	No
CFBMDL_APPROVEDDATE	_datetime_8	datetime(8)	Yes	Approved Date	No
CFBMDL_APPROVED_BY	_varchar_30	varchar(30)	Yes	Approved By-name of the person	No
CFBMDL_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By-name of the person-name of the person	No
CFBMDL_CREATED_BY	_varchar_30	varchar(30)	Yes	name of the person who created the act	No
CFBMDL_CREATIONDATE	_datetime_8	datetime(8)	Yes	creation date	No
CFBMDL_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last modified date of the config process	No
CFBMDL_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No

Table Name :	CFG_CFBMDT_MDL_CONFIG_DTL
Comment :	Position code details for the Baselined Model Configuration is get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBMDT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBMDT_MODEL_NO	_varchar_20	varchar(20)	No	Model No associated with the aircraft	Yes
CFBMDT_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration class	Yes
CFBMDT_REVNO	_varchar_40	varchar(40)	No	Revision number	Yes
CFBMDT_POS_CODE	_varchar_25	Varchar(25)	No	Postion Code	Yes
CFBMDT_POS_PART_NO	_varchar_40	varchar(40)	Yes	Part number associated with the position code	No
CFBMDT_POS_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Position Part Number	No
CFBMDT_POS_STATUS	_varchar_15	varchar(15)	Yes	Status of the position code. Can be Active or Inactive	No
CFBMDT_POS_TYPE	_varchar_5	varchar(5)	Yes	Position Code type . Can be "Engine", "APU", "Landing Gear" or "Others"	No
CFBMDT_ROT_MAN_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if a rotable is mandatory in the position code defined.	No
CFBMDT_CARGO_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if the configuration is applicable for cargo planes	No
CFBMDT_RVSM_FLAG	_varchar_25	Varchar(25)	Yes	reduced vertical seperation maintanance Flag	No
CFBMDT_ZONECODE	_varchar_15	varchar(15)	Yes	Zone no	No
CFBMDT_BODY_STATION_NO	_varchar_15	varchar(15)	Yes	Body Station no	No
CFBMDT_ATA_NO	_varchar_16	varchar(16)	Yes	ATA chaptor no	No
CFBMDT_DRAWING_NO	_varchar_40	varchar(40)	Yes	Drawing no	No
CFBMDT_DOC_PATH	_varchar_50	varchar(50)	Yes	path where the document is available.	No
CFBMDT_LEVEL_NO	_varchar_150	varchar(150)	Yes	level number of the position code	No
CFBMDT_LEVEL_CODE	_varchar_150	varchar(150)	Yes	unique identifier for the position code in the structure of configuration	No
CFBMDT_NO_OF_ENG	_decimal_10_0	decimal(10)	Yes	no of engines	No
CFBMDT_NO_OF_APUS	_decimal_10_0	decimal(10)	Yes	no of auxillury power units	No
CFBMDT_POS_PART_REVNO	_varchar_40	varchar(40)	Yes	Position Part Revision Number	No
CFBMDT_MEL_FLAG	_varchar_25	Varchar(25)	Yes	minimum equipment list flag	No
CFBMDT_SEQ_NO	_decimal_10_0	decimal(10)	Yes	sequence no	No
CFBMDT_LINK_INFO	_varchar_25	Varchar(25)	Yes	Link info	No
CFBMDT_DISP_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Display sequence No.	No
CFBMDT_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFBMDT_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks identification number	No

Table Name :	CFG_CFBMEL_MDL_CONFIG_MEL
Comment :	Baselined Minimum equipment list for the model configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBMEL_OUINSTANCE	_decimal_10_0	decimal(10)	No	OuInstance	Yes
CFBMEL_MODEL_NO	_varchar_20	varchar(20)	No	Model number of the aircraft	Yes
CFBMEL_CONFIG_CLASS	_varchar_30	varchar(30)	No	configuration Class to which the Aircraft belongs	Yes
CFBMEL_REVNO	_varchar_40	varchar(40)	No	Revision number	Yes
CFBMEL_PART_NO	_varchar_40	varchar(40)	Yes	part number	No
CFBMEL_CONDITION_FLAG	_varchar_25	Varchar(25)	Yes	Sets Y or N for denoting conditions if any	No
CFBMEL_CONDITIONS	udd_txt2000	varchar(2000)	Yes	coniditions if any	No
CFBMEL_MEL_QTY	_decimal_28_8	decimal(28)	Yes	minimum equipment list quantity	No
CFBMEL_MAINT_IMPLICATION	_varchar_255	varchar(255)	Yes	Maintenance Implications if any	No
CFBMEL_OPER_IMPLICATION	_varchar_255	varchar(255)	Yes	Operational Implications if any	No
CFBMEL_POS_BASED_FLAG	_varchar_25	Varchar(25)	Yes	Position Based Flag	No
CFBMEL_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Part Number	No
CFBMEL_MEL_ITEM_CODE	_varchar_30	varchar(30)	No	The number identifying the minimum equipment list item for which the position details must be defined.	Yes
CFBMEL_MEL_ITEM_DESC	_varchar_150	varchar(150)	Yes	minimum equipment list Item Description	No
CFBMEL_CATEGORY	_varchar_30	varchar(30)	Yes	minimum equipment list Category	No
CFBMEL_MIN_MEL_QTY	_decimal_28_8	decimal(28)	Yes	Minimum equipment list Quantity	No
CFBMEL_MEL_ITEM_STATUS	_varchar_5	varchar(5)	Yes	minimum equipment list Item Status	No
CFBMEL_PLACARD	_varchar_5	varchar(5)	Yes	Placard N- Not Required R- Required	No
CFBMEL_PLACARD_INST	_varchar_2000	varchar(2000)	Yes	Placard Instructions	No
cfbmel_deferral_task	_varchar_30	varchar(30)	Yes	Deferral Task	No
cfbmel_deferral_rev_task	_varchar_40	varchar(40)	Yes	Deferrel revised task number	No

Table Name :	CFG_CFBMIC_MDLCFG_INTCHGE_RULE
Comment :	Interchangable rules for the Model - Baselined versions alone is get stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBMIC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBMIC_MODEL_NO	_varchar_20	varchar(20)	No	Model No associated with the aircraft	Yes
CFBMIC_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class	Yes
CFBMIC_REVNO	_varchar_40	varchar(40)	No	Revison No.	Yes
CFBMIC_LEVEL_CODE	_varchar_150	varchar(150)	No	Level Code	Yes
CFBMIC_POS_CODE	_varchar_25	Varchar(25)	No	Position Code	Yes
CFBMIC_POS_PART_NO	_varchar_40	varchar(40)	No	Position Part Number	Yes
CFBMIC_INTERCHANGE_PART	_varchar_40	varchar(40)	No	Interchangable part for the position	Yes
CFBMIC_ORDER_OF_PREF	_decimal_10_0	decimal(10)	Yes	Order of preference	No
CFBMIC_MOD_STATUS	_varchar_15	varchar(15)	Yes	document number which authorizes the interhchangability	No
CFBMIC_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFBMIC_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identification number	No

Table Name :	CFG_CFBMIX_MDLCFG_INTMX_RULE
Comment :	Intermixing Rules for Model position codes - Baselined versions alone

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBMIX_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBMIX_MODEL_NO	_varchar_20	varchar(20)	No	Model_no	Yes
CFBMIX_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class	Yes
CFBMIX_REVNO	_varchar_40	varchar(40)	No	Revison no	Yes
CFBMIX_LEVEL_CODE	_varchar_150	varchar(150)	No	Level Code	Yes
CFBMIX_POS_CODE	_varchar_25	Varchar(25)	No	Position code	Yes
CFBMIX_POS_PART_NO	_varchar_40	varchar(40)	No	Position Part Number	Yes
CFBMIX_DEP_POS_CODE	_varchar_25	Varchar(25)	No	Dependent position code	No
CFBMIX_DEP_PART_NO	_varchar_40	varchar(40)	Yes	Part number attached to the dependent position code	No
CFBMIX_REV_FLAG	_varchar_25	Varchar(25)	Yes	Reversible Flag sets N or Y	No
CFBMIX_DEP_LEVEL_CODE	_varchar_150	varchar(150)	No	Dependent Level Code	Yes
CFBMIX_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFBMIX_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identification number	No

Table Name :	CFG_CFBMLK_MODEL_LINK_INFO
Comment :	Indicates whether the interchangeability rules, intermixing rules and ETOP twin position rules have been entered for the position. The system displays one of the following options:

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBMLK_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBMLK_MODEL_NO	_varchar_20	varchar(20)	No	Aircraft Model No.	Yes
CFBMLK_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration class	Yes
CFBMLK_REV_NO	_varchar_40	varchar(40)	No	configuration Revion No.	Yes
CFBMLK_LEVEL_CODE	_varchar_150	varchar(150)	No	Level code	Yes
CFBMLK_POS_CODE	_varchar_25	Varchar(25)	No	Position code	No
CFBMLK_PART_NO	_varchar_40	varchar(40)	No	Part No.	No
CFBMLK_CHILD_LEVEL_NO	_decimal_10_0	decimal(10)	No	Child Level No.	No
CFBMLK_ZONE_CODE	_varchar_15	varchar(15)	Yes	The zone associated to the position code	No
CFBMLK_ATA_NO	_varchar_16	varchar(16)	Yes	The ATA chapter for which the position code details are to be retrieved	No
CFBMLK_BODY_STATION	_varchar_15	varchar(15)	Yes	Body Station	No
CFBMLK_CARGO_FLAG	_varchar_25	Varchar(25)	Yes	the position code is in the cargo aircraft	No
CFBMLK_RVSM_FLAG	_varchar_15	varchar(15)	Yes	reduced vertical separation minimum l list flag	No
CFBMLK_LINK_FLAG	_varchar_15	varchar(15)	Yes	Link flag	No
CFBMLK_NHA	_varchar_40	varchar(40)	Yes	Next higher Assembly	No

Table Name :	CFG_CFBMNT_MDLCFG_NOTES
Comment :	This table maintains the notes for Baselined Model configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBMNT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBMNT_MODEL_NO	_varchar_20	varchar(20)	No	Model No associated with the aircraft.	Yes
CFBMNT_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class	Yes
CFBMNT_REVNO	_varchar_40	varchar(40)	No	Revison No.	Yes
CFBMNT_NOTES	_varchar_2000	varchar(2000)	Yes	Notes related to the act	No

Table Name :	CFG_CFBMTW_MDLCFG_ETOP_TWNPS
Comment :	ETop Twin positions for Baselined Model Configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBMTW_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFBMTW_MODEL_NO	_varchar_20	varchar(20)	No	model number of the Ac or part	Yes
CFBMTW_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration class	Yes
CFBMTW_REVNO	_varchar_40	varchar(40)	No	Revison Number	Yes
CFBMTW_LEVEL_CODE	_varchar_150	varchar(150)	No	Level Code	Yes
CFBMTW_POS_CODE	_varchar_25	Varchar(25)	No	Positon code	Yes
CFBMTW_POS_PART_NO	_varchar_40	varchar(40)	No	Position Part Number	Yes
CFBMTW_TWIN_POS_CODE	_varchar_25	Varchar(25)	No	Twin Position Code	No
CFBMTW_TWIN_PART_NO	_varchar_40	varchar(40)	Yes	Part Number associated with the twin position code	No
CFBMTW_TWIN_LEVEL_CODE	_varchar_150	varchar(150)	No	Etop Twin Level Code	Yes

Table Name :	CFG_CFBPNT_PART_NOTES
Comment :	Baselined Part Configuration - Notes Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBPNT_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CFBPNT_PART_NO	_varchar_40	varchar(40)	No	Baselined Part No	Yes
CFBPNT_REV_NO	_varchar_40	varchar(40)	No	Revision No	Yes
CFBPNT_NOTES	_varchar_2000	varchar(2000)	Yes	Notes related to the act	No
CFBPNT_NOTES_ID	udd_guid	varchar(40)	Yes	Notes Identity number	No
cfbpnt_operator_code	udd_operatorcode	varchar(32)	No	Operator code	Yes

Table Name :	CFG_CFBPTT_PART_CONFIG_DTL
Comment :	Baselined Part Configuration Position code details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBPTT_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	No
CFBPTT_PART_NO	_varchar_40	varchar(40)	No	Part No	No
CFBPTT_REV_NO	_varchar_40	varchar(40)	No	Revion No	No
CFBPTT_POS_CODE	_varchar_25	Varchar(25)	No	Positon Code	No
CFBPTT_POS_PART_NO	_varchar_40	varchar(40)	No	associated part number	No
CFBPTT_POS_STATUS	_varchar_15	varchar(15)	Yes	can be of Active A or inactive I	No
CFBPTT_POS_TYPE	_varchar_25	Varchar(25)	Yes	position type.Can be "Engine", "APU", "Landing Gear" or "Others"	No
CFBPTT_RVSM_FLAG	_varchar_25	Varchar(25)	Yes	reduced vertical seperation maintanance Flag - Yes or No	No
CFBPTT_CARGO_FLAG	_varchar_25	Varchar(25)	Yes	Cargo Flag Yes or No	No
CFBPTT_ATA_NO	_varchar_16	varchar(16)	Yes	ATA Chapter Number	No
CFBPTT_DRAWING_NO	_varchar_40	varchar(40)	Yes	Drawing Number	No
CFBPTT_DOC_PATH	_varchar_50	varchar(50)	Yes	Document Path	No
CFBPTT_CHILD_EXISTS_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if the node has children	No
CFBPTT_ROT_MAN_FLAG	_varchar_25	Varchar(25)	Yes	Rotable Mandatory flag	No
CFBPTT_POS_REV_NO	_varchar_40	varchar(40)	Yes	Revision Number of the Position part number	No
CFBPTT_POS_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	OUInstance of the position part number	No
CFBPTT_ZONECODE	_varchar_10	varchar(10)	Yes	Zone code	No
CFBPTT_PART_SEQNO	_decimal_10_0	decimal(10)	Yes	Sequence Number	No
CFBPTT_DISP_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Display sequence No.	No
CFBPTT_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFBPTT_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identification number	No
cfbptt_operator_code	udd_operatorcode	varchar(32)	No	Operator code	No
cfbptt_unique_id	udd_unique_id	bigint(8)	No	Unique id	Yes

Table Name :	CFG_CFBPT_PART_CONFIG
Comment :	Baselined Part Configuration details is get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFBPT_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OUInstance	No
CFBPT_PART_NO	_varchar_40	varchar(40)	No	Part Number	No
CFBPT_REV_NO	_varchar_40	varchar(40)	No	Revision Number	No
CFBPT_STATUS	_varchar_15	varchar(15)	Yes	Status of Part COnfiguration	No
CFBPT_NO_OF_ENGINES	_decimal_10_0	decimal(10)	Yes	Number of Engines	No
CFBPT_NO_OF_APUS	_decimal_10_0	decimal(10)	Yes	Number of APUs	No
CFBPT_CREATED_BY	_varchar_30	varchar(30)	Yes	name of the person who created the act	No
CFBPT_CREATEDDATE	_datetime_8	datetime(8)	Yes	created date of the config process	No
CFBPT_APPROVED_BY	_varchar_30	varchar(30)	Yes	Approved By-name of the person	No
CFBPT_APPROVEDDATE	_datetime_8	datetime(8)	Yes	Approved Date	No
CFBPT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By-name of the person	No
CFBPT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last modified date of the config process	No
CFBPT_AC_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	OUInstance of Aircraft Part Number	No
CFBPT_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CFBPT_BASELINED_FLAG	_varchar_25	Varchar(25)	Yes	BaseLined Flag	No
CFBPT_INHERIT_CHGS_FLAG	_varchar_25	Varchar(25)	Yes	Inherit Change Flag	No
cfbpt_operator_code	udd_operatorcode	varchar(32)	No	Operator code	No
cfbpt_unique_id	udd_unique_id	bigint(8)	No	Unique ID	Yes

Table Name :	CFG_CFGACD_AC_CONFIG_DTL
Comment :	Position Codes and their associated parts for a aircraft configuration is maintained here. Readiness log details like component Id and serial number details for all the parts in the aircraft are also maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGACD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGACD_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number	Yes
CFGACD_REVNO	_varchar_40	varchar(40)	No	Revision number	Yes
CFGACD_POS_CODE	_varchar_25	Varchar(25)	No	Position Code	Yes
CFGACD_POS_PART_NO	_varchar_40	varchar(40)	Yes	Part number associated with the position code	No
CFGACD_POS_STATUS	_varchar_15	varchar(15)	Yes	Position Status. Can be either Active or Inactive.	No
CFGACD_POS_TYPE	_varchar_25	Varchar(25)	Yes	Position Type. Can be either "Engine", "APU", "Landing Gear" or "Others"	No
CFGACD_ROT_MAN_FLAG	_varchar_25	Varchar(25)	Yes	Rotable Mandatory Flag indicates if a rotatable is mandatory or not. Can take values "Yes" or "No"	No
CFGACD_ZONECODE	_varchar_15	varchar(15)	Yes	Zone code. Place where the position is located in the Aircraft	No
CFGACD_ATA_NO	_varchar_30	varchar(30)	Yes	Air Traffic Association Chapter number	No
CFGACD_DRAWING_ID	_varchar_40	varchar(40)	Yes	Drawing Id	No
CFGACD_DOC_PATH	_varchar_50	varchar(50)	Yes	Document Path where the drawing is available	No
CFGACD_LEVEL_NO	_varchar_150	varchar(150)	Yes	This indicates the level in which the position codes exists	No
CFGACD_LEVEL_CODE	_varchar_150	varchar(150)	Yes	System generated code for the various positions in the hierarchy	No
CFGACD_DATE_OF_ATTACH	_datetime_8	datetime(8)	Yes	Date of Attachment	No
CFGACD_TIME_OF_ATTACH	_datetime_8	datetime(8)	Yes	Time of Attachment	No
CFGACD_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Component Id associated with the aircraft	No
CFGACD_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number	No
CFGACD_POS_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Position Part Number	No
CFGACD_COMP_CONDITION	_varchar_5	varchar(5)	Yes	Component Condition	No
CFGACD_FROM_DATE	_datetime_8	datetime(8)	Yes	Component Effective From Date	No
CFGACD_BODY_STATION_NO	_varchar_15	varchar(15)	Yes	Body Station	No
CFGACD_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Sequence No	No
CFGACD_CARGO_FLAG	_varchar_5	varchar(5)	Yes	Cargo Flag	No
CFGACD_RVSM_FLAG	_varchar_5	varchar(5)	Yes	reduced vertical seperation maintanance Flag	No
CFGACD_LINK_FLAG	_varchar_75	varchar(75)	Yes	Link Flag Information	No
CFGACD_INDUCTION_DATE	_datetime_8	datetime(8)	Yes	induction date	No
CFGACD_OPERATION_DATE	_datetime_8	datetime(8)	Yes	operation date	No
CFGACD_ATTACH_ROT_FLAG	_varchar_25	Varchar(25)	Yes	rotable attachment flag	No
CFGACD_COMP_PART_NO	_varchar_40	varchar(40)	Yes	Part No of the attached component.	No
CFGACD_COMP_PART_OU	_decimal_10_2	decimal(10)	Yes	Ou intance of the part no of the attached component.	No
CFGACD_DISP_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Display Sequence Number	No
cfgacd_attach_status	_varchar_5	varchar(5)	Yes	Attachemnet Status	No
CFGACD_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFGACD_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identification number	No

Table Name :	CFG_CFGACD_COMP
Comment :	Component associated Aircraft in the congiguration process concern details is get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGACD_LVL1_GUID	_varchar_40	varchar(40)	Yes	Guid	No
CFGACD_LVL1_ACREGNO	_varchar_40	varchar(40)	Yes	Aircraft register number	No
CFGACD_LVL1_CODE	_varchar_150	varchar(150)	Yes	Level code	No
CFGACD_LVL1_POSCODE	_varchar_40	varchar(40)	Yes	Position code	No
CFGACD_LVL1_COMPID	_varchar_90	varchar(90)	Yes	Component Id associated with the aircraft	No
CFGACD_LVL1_NHA	_varchar_90	varchar(90)	Yes	Next higher level Part	No
CFGACD_CURLVL1_CODE	_varchar_150	varchar(150)	Yes	Level_code	No
CFGACD_LVL1_NO	_decimal_10_0	decimal(10)	Yes	Level number	No

Table Name :	CFG_CFGACH_ACHISTORY_LOG
Comment :	Aircraft History Log data is stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGACH_OUINSTANCE	_numeric_28_0	numeric(28)	No	OUInstance	Yes
CFGACH_COMPONENT_ID	_varchar_90	varchar(90)	No	Component Id associated with the aircraft	Yes
CFGACH_EFF_FROM_DATE	_datetime_8	datetime(8)	No	Effective Attachment date	Yes
CFGACH_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Component	No
CFGACH_AIRCRAFT_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Aircraft reg No.	No
CFGACH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Reg No	No
CFGACH_POS_CODE	_varchar_25	Varchar(25)	Yes	Position Code	No
CFGACH_POS_TYPE	_varchar_5	varchar(5)	Yes	position type.Can be "Engine", "APU", "Landing Gear" or "Others"	No
CFGACH_PARENT_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the parent component ID	No
CFGACH_PARENT_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Parent Component Id associated with the aircraft	No
CFGACH_EFF_TO_DATE	_datetime_8	datetime(8)	Yes	Effective Removal Date	No
CFGACH_LEVEL_CODE	_varchar_150	varchar(150)	Yes	Level Code	No
CFGACH_LEVEL_NO	_numeric_28_0	numeric(28)	Yes	Level No	No
CFGACH_CREATEDBY	_varchar_30	varchar(30)	Yes	Created User name	No
CFGACH_CREATEDDATE	_datetime_8	datetime(8)	Yes	created date of the config process	No

Table Name :	CFG_CFGACN_AC_CONFIG_NOTES
Comment :	Notes related to the Aircraft Configuration is maintained

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGACN_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU instance	Yes
CFGACN_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration number	Yes
CFGACN_REVNO	_varchar_40	varchar(40)	No	Revision Number	Yes
CFGACN_NOTES	_varchar_2000	varchar(2000)	Yes	Notes	No

Table Name :	CFG_CFGAC_AIRCRAFT_CONFIG
Comment :	Aircraft Configuration Details are maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGAC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGAC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number	Yes
CFGAC_REVNO	_varchar_40	varchar(40)	No	Revision Number of the configuration	Yes
CFGAC_AIRCRAFT_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of Aircraft registration Number	No
CFGAC_MODEL_NO	_varchar_20	varchar(20)	Yes	Model No associated with the aircraft	No
CFGAC_CONFIG_CLASS	_varchar_30	varchar(30)	Yes	Configuration Class	No
CFGAC_STATUS	_varchar_15	varchar(15)	No	Status of the Configuration. Can be either "Fresh", "Active", "Revised" or "Cancelled"	Yes
CFGAC_CREATED_BY	_varchar_30	varchar(30)	Yes	name of the person who created the act	No
CFGAC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By-name of the person	No
CFGAC_APPROVED_BY	_varchar_30	varchar(30)	Yes	Approved By-name of the person	No
CFGAC_APPROVEDDATE	_datetime_8	datetime(8)	Yes	Approved Date	No
CFGAC_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
CFGAC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp of the current record	No
CFGAC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last modified date of the config process	No
CFGAC_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CFGAC_BASELINED_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if the current Model configuration revision has been baselined or not.Holds yes or no value	No
CFGAC_MISMATCH_FLAG	_varchar_25	Varchar(25)	Yes	Sets Y or N for denoting mismatch	No
CFGAC_FILE_NAME	_varchar_50	varchar(50)	Yes	File Name	No
CFGAC_INIT_FILENAME	_varchar_50	varchar(50)	Yes	Initial file name	No
CFGAC_CFGCTRL_BASIS	udd_designparamcode	varchar(5)	Yes	Control basis	No

Table Name :	CFG_CFGAC_STATUS_UPDTL
Comment :	aircraft configyration status updation details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGAC_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
CFGAC_AIRCRAFT_CODE	udd_aircraftnumber	varchar(30)	Yes	Aircraft code	No
CFGAC_CMPID_CODE	udd_componentid	varchar(90)	Yes	Component Id associated with the aircraft	No
CFGAC_GUID	udd_guid	varchar(40)	No	Guid	No
CFGAC_PARTNO	_varchar_40	varchar(40)	Yes	Part number	No
CFGAC_SERIALNO	_varchar_40	varchar(40)	Yes	Serial number	No

Table Name :	CFG_CFGAEO_AC_EO_LIST
Comment :	Aircraft Registration change option association with Engineering Order Component

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGAEO_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
CFGAEO_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number	Yes
CFGAEO_REV_NO	_varchar_40	varchar(40)	No	Revision Number	Yes
CFGAEO_EO_NO	_varchar_40	varchar(40)	No	Engineering Order Number	Yes
CFGAEO_RELEASED_DATE	_datetime_8	datetime(8)	Yes	Released Date	No
CFGAEO_COMPLIED_DATE	_datetime_8	datetime(8)	Yes	Compiled Date	No

Table Name :	CFG_CFGAIC_CFGAC_INTCHG_RULE
Comment :	This table maintains the interchangability rules related to the various position codes in the tree for an aircraft configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGAIC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGAIC_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration No.	Yes
CFGAIC_REVNO	_varchar_40	varchar(40)	No	Revison No.	Yes
CFGAIC_LEVEL_CODE	_varchar_150	varchar(150)	No	Level Code	Yes
CFGAIC_POS_CODE	_varchar_25	Varchar(25)	No	The position code retrieved by the system	Yes
CFGAIC_POS_PART_NO	_varchar_40	varchar(40)	No	Position Part Number	Yes
CFGAIC_INTERCHANGE_PART	_varchar_40	varchar(40)	No	Part number that can be an alternative to the part number defined for the position	Yes
CFGAIC_ORDER_OF_PREF	_decimal_10_0	decimal(10)	Yes	Order of preference of the interchangable part	No
CFGAIC_MOD_STATUS	_varchar_15	varchar(15)	Yes	Mod Status gives the document number which has authorized the interchange	No
CFGAIC_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFGAIC_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identity number	No

Table Name :	CFG_CFGAIX_CFGAC_INTMX_RULE
Comment :	This table maintains the intermixing rules for an Aircraft Configuration.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGAIX_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGAIX_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration No.	Yes
CFGAIX_REVNO	_varchar_40	varchar(40)	No	The revision number of the aircraft configuration	Yes
CFGAIX_LEVEL_CODE	_varchar_150	varchar(150)	No	Level Code	Yes
CFGAIX_POS_CODE	_varchar_25	Varchar(25)	No	The position code for which the configuration rules must be defined	Yes
CFGAIX_POS_PART_NO	_varchar_40	varchar(40)	No	Position Part Number	Yes
CFGAIX_DEP_LEVEL_CODE	_varchar_150	varchar(150)	No	Dependent Level Code	Yes
CFGAIX_DEP_POS_CODE	_varchar_25	Varchar(25)	No	Dependent Position Code	No
CFGAIX_DEP_PART_NO	_varchar_40	varchar(40)	Yes	Part number associated with the dependent position code	No
CFGAIX_REV_FLAG	_varchar_25	Varchar(25)	Yes	Reversible Flag. Can be either "Yes" or "No"	No
CFGAIX_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFGAIX_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identity number	No

Table Name :	CFG_CFGAPS_ACCFG_SPPART_POS
Comment :	This table maintains the various spare parts for the aircraft configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGAPS_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
CFGAPS_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Register Number	Yes
CFGAPS_REVNO	_varchar_40	varchar(40)	No	Revision Number	Yes
CFGAPS_PART_NO	_varchar_40	varchar(40)	No	Part number	Yes
CFGAPS_POS_CODE	_varchar_25	Varchar(25)	No	Position Code which needs to be tracked in the spare part	Yes
CFGAPS_POS_STATUS	_varchar_15	varchar(15)	Yes	Status of the position code. Can be either "Active" or "Inactive"	No
CFGAPS_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number	No
CFGAPS_LOT_NO	_varchar_18	varchar(18)	Yes	Lot Number	No
CFGAPS_DATE_OF_ATT	_datetime_8	datetime(8)	Yes	Date of Attachment	No
CFGAPS_WO_NO	_varchar_18	varchar(18)	Yes	Work Order Number	No
CFGAPS_WO_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Work Order Number	No

Table Name :	CFG_CFGAPS_CFGAC_PERM_SRLNO
Comment :	Stores aps details for Aircraft model and part

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGAPS_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
CFGAPS_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Register Number	Yes
CFGAPS_REVNO	_varchar_40	varchar(40)	No	Revision Number	Yes
CFGAPS_LEVEL_CODE	_varchar_150	varchar(150)	No	Level code	Yes
CFGAPS_POS_CODE	_varchar_25	Varchar(25)	No	Position Code which needs to be tracked in the spare part	Yes
CFGAPS_POS_PART_NO	_varchar_40	varchar(40)	No	Position Part No	Yes
CFGAPS_INTERCHANGE_PART	_varchar_40	varchar(40)	No	Interchangale Part No.	Yes
CFGAPS_FROM_MSN_NO	_varchar_40	varchar(40)	No	Manufacturer Serial No.	Yes
CFGAPS_RESTRICT_TYPE	_varchar_5	varchar(5)	Yes	Restrict type	No
CFGAPS_INTERCHANGE_PART_OU	_decimal_10_0	decimal(10)	Yes	ouinstance	No
CFGAPS_TO_MSN_NO	_varchar_40	varchar(40)	Yes	To maufacture serial no	No
CFGAPS_FROM_MSN_PRFX	_varchar_40	varchar(40)	Yes	Manufactrer Serial number Prefix	No
CFGAPS_FROM_MSN_SFX	_decimal_10_0	decimal(10)	Yes	Manufactrer Serial number SUFFIX	No
CFGAPS_TO_MSN_PRFX	_varchar_40	varchar(40)	Yes	TO Manufactrer Serial number Prefix	No
CFGAPS_TO_MSN_SFX	_decimal_10_0	decimal(10)	Yes	To Manufactrer Serial number Suffix	No
CFGAPS_TIMESTAMP	_decimal_28_0	decimal(28)	Yes	Timestamp of the current record	No

Table Name :	CFG_CFGASP_ACCFG_SPARE_PART
Comment :	List of Spare Parts for the Aircraft Configuration is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGASP_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUinstance	Yes
CFGASP_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft register number	Yes
CFGASP_REVNO	_varchar_40	varchar(40)	No	Revision No.	Yes
CFGASP_SPARE_PART	_varchar_40	varchar(40)	No	Spare Part Number	Yes
CFGASP_SPARE_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the spare part number	No
CFGASP_QUANTITY	udd_count	int(4)	Yes	Quantity of the Spare part in the Aircraft Configuration	No
CFGASP_TRACKABLE_FLAG	_varchar_25	Varchar(25)	Yes	This flag (Yes or No) indicates if the spare part need to be tracked or not.	No
CFGASP_POS_PREFIX	_varchar_6	varchar(6)	Yes	Prefix for generating the position codes	No
CFGASP_ZONE	_varchar_15	varchar(15)	Yes	Zone Code	No

Table Name :	CFG_CFGATW_CFGAC_ETOP_TWNPS
Comment :	This table maintains the various etop twin positions for the Aircraft Configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGATW_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGATW_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration No.	Yes
CFGATW_REVNO	_varchar_40	varchar(40)	No	Revion Number	Yes
CFGATW_LEVEL_CODE	_varchar_150	varchar(150)	No	Level Code	Yes
CFGATW_POS_CODE	_varchar_25	Varchar(25)	No	Positon Code	Yes
CFGATW_POS_PART_NO	_varchar_40	varchar(40)	No	Position Part Number	Yes
CFGATW_TWIN_LEVEL_CODE	_varchar_150	varchar(150)	No	Twin Position Level Code	Yes
CFGATW_TWIN_POS_CODE	_varchar_25	Varchar(25)	No	Twin position code	No
CFGATW_TWIN_PART_NO	_varchar_40	varchar(40)	Yes	Part number associated with the twin position code	No

Table Name :	CFG_CFGCEO_CMP_EO_LIST
Comment :	List of EOs which has triggered the COmponent Configuration Changes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGCEO_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGCEO_COMPONENTID	_varchar_90	varchar(90)	No	Component Id	Yes
CFGCEO_REVNO	_varchar_40	varchar(40)	No	Configuration Revion No	Yes
CFGCEO_EO_NO	_varchar_40	varchar(40)	No	Engineering Order Number	Yes
CFGCEO_RELEASED_DATE	_datetime_8	datetime(8)	No	Released Date	No
CFGCEO_COMPLIED_DATE	_datetime_8	datetime(8)	No	Compliance date	No

Table Name :	CFG_CFGCL_CONFIG_CLASS_INFO
Comment :	This table maintains the various Configuration Class information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGCL_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
CFGCL_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class Name	Yes
CFGCL_DESCRIPTION	_varchar_150	varchar(150)	No	Description Of the Configuration Class	No
CFGCL_STATUS	_varchar_15	varchar(15)	Yes	Status of the Configuration Class. Can be Active or Inactive	No
CFGCL_ETOP_FLAG	_varchar_25	Varchar(25)	No	This flag indicates if the class is for ETOP or not. This can take value "Yes" or "No"	No
CFGCL_NO_OF_ENGINES	_decimal_10_0	decimal(10)	Yes	No of engines that will be available for this configuration class	No
CFGCL_NO_OF_APUS	_decimal_10_0	decimal(10)	Yes	No of Auxillury Power Units	No
CFGCL_USER_DEF_1	_varchar_30	varchar(30)	Yes	User Defined Value	No
CFGCL_USER_DEF_2	_varchar_30	varchar(30)	Yes	Second User defined value	No
CFGCL_AC_GROUP	_varchar_25	Varchar(25)	Yes	Aircraft Group for which the configuration class is applicable - Quick Codes	No
CFGCL_AC_TYPE	_varchar_25	Varchar(25)	Yes	Aircraft Type for which the configuration class is applicable - Quick Codes	No
CFGCL_USAGE_TYPE	_varchar_25	Varchar(25)	Yes	Usage Type for which the configuration class is applicable - Quick Codes	No
CFGCL_LANDING_GEAR_TYPE	_varchar_25	Varchar(25)	Yes	Landing gear type can be "Bogie Beam", "Tri-Cycle"	No
CFGCL_MODEL_EFF_FLAG	_varchar_25	Varchar(25)	Yes	A indicates this configuration Class is associated with all the models and R indicates it is mapped to restricted models only	No
CFGCL_CREATED_BY	_varchar_30	varchar(30)	Yes	Created User name	No
CFGCL_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
CFGCL_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified User Id	No
CFGCL_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last modified date of the config process	No
CFGCL_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp of the current record	No

Table Name :	CFG_CFGCMD_CMP_CONFIG_DTL
Comment :	This definition of the various position codes and their level are maintained in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGCMD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGCMD_COMPONENTID	_varchar_90	varchar(90)	No	The component for which the configuration details must be define	Yes
CFGCMD_REVNO	_varchar_40	varchar(40)	No	The number identifying the revision of the component configurat	Yes
CFGCMD_POS_CODE	_varchar_25	Varchar(25)	No	Position code associated with the component	Yes
CFGCMD_POS_PART_NO	_varchar_40	varchar(40)	Yes	part associated to the position code	No
CFGCMD_POS_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Part Number	No
CFGCMD_NHA	_varchar_90	varchar(90)	Yes	Next Higher Assembly	No
CFGCMD_ROOT_NODE	_varchar_90	varchar(90)	Yes	Root Node	No
CFGCMD_ROOT_REVNO	_varchar_40	varchar(40)	Yes	Root revision No	No
CFGCMD_ROT_MAN_FLAG	_varchar_25	Varchar(25)	Yes	This flag indicates if a rotable should always exists in the position code	No
CFGCMD_POS_TYPE	_varchar_25	Varchar(25)	Yes	Type of the position code. Can be "Engine", "APU", "Landing Gear" or "Others"	No
CFGCMD_DRAWING_ID	_varchar_40	varchar(40)	Yes	Drawing Id	No
CFGCMD_DOC_PATH	_varchar_50	varchar(50)	Yes	Path in which the Drawing exists	No
CFGCMD_LEVEL_CODE	_varchar_150	varchar(150)	Yes	Unique identifier for each node in the configuration	No
CFGCMD_LEVEL_NO	_varchar_150	varchar(150)	Yes	level number of the node	No
CFGCMD_ZONECODE	_varchar_15	varchar(15)	Yes	zone code	No
CFGCMD_ATA_NO	_varchar_30	varchar(30)	Yes	ATA CHaptor number	No
CFGCMD_ROT_COMP	_varchar_90	varchar(90)	Yes	Rotable Component Id associated with the aircraft	No
CFGCMD_ROT_SERIAL_NO	_varchar_40	varchar(40)	Yes	Rotable Serial Number	No
CFGCMD_DATE_OF_ATTACH	_datetime_8	datetime(8)	Yes	Date of Attachment	No
CFGCMD_TIME_OF_ATTACH	_datetime_8	datetime(8)	Yes	Time of Attachment	No
CFGCMD_POS_STATUS	_varchar_15	varchar(15)	Yes	can be of Active A or inactive I	No
CFGCMD_CHILD_EXISTS_FLAG	_varchar_25	Varchar(25)	Yes	Flag for the existance of Child level -Y- YES -N- NO	No
CFGCMD_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Sequence Number - Building the level Code	No
CFGCMD_COMP_CONDITION	_varchar_5	varchar(5)	Yes	Component Condition	No
CFGCMD_FROM_DATE	_datetime_8	datetime(8)	Yes	Component Effective from date	No
CFGCMD_CARGO_FLAG	_varchar_5	varchar(5)	Yes	Cargo Flag	No
CFGCMD_RVSM_FLAG	_varchar_5	varchar(5)	Yes	reduced vertical seperation maintanance Flag	No
CFGCMD_BODY_STATION_NO	_varchar_15	varchar(15)	Yes	Body Station	No
CFGCMD_LINK_FLAG	_varchar_75	varchar(75)	Yes	Link Flag Information	No
CFGCMD_INDUCTION_DATE	_datetime_8	datetime(8)	Yes	induction date	No
CFGCMD_OPERATION_DATE	_datetime_8	datetime(8)	Yes	operation date	No
CFGCMD_ATTACH_ROT_FLAG	_varchar_25	Varchar(25)	Yes	rotable attachment flag	No
CFGCMD_ROT_COMP_PART_NO	_varchar_40	varchar(40)	Yes	Part No of the attached component.	No
CFGCMD_ROT_COMP_PART_OU	_decimal_10_0	decimal(10)	Yes	Ou instance of the part no of the attached component.	No
CFGCMD_DISP_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Display Sequnce Number	No
cfgcmd_attach_status	_varchar_5	varchar(5)	Yes	can be of Fresh,Active,Cancel,inactive	No
CFGCMD_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFGCMD_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identity number	No

Table Name :	CFG_CFGCMP_COMP_CONFIG
Comment :	Component Configuration is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGCMP_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUIstance	Yes
CFGCMP_COMPONENTID	_varchar_90	varchar(90)	No	Component Id associated with the aircraft	Yes
CFGCMP_REVNO	_varchar_40	varchar(40)	No	Revision number of the component configuration	Yes
CFGCMP_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of Component Id associated with the aircraft	No
CFGCMP_STATUS	_varchar_15	varchar(15)	No	Status of the Configuration. Can be either "Fresh", "Active", "Revised" or "Cancelled"	Yes
CFGCMP_APPROVEDDATE	_datetime_8	datetime(8)	Yes	Approval Date	No
CFGCMP_CREATED_BY	_varchar_30	varchar(30)	Yes	name of the person who created the act	No
CFGCMP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By-name of the person	No
CFGCMP_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp of the current record	No
CFGCMP_APPROVED_BY	_varchar_30	varchar(30)	Yes	Approved By-name of the person	No
CFGCMP_BASELINED_FLAG	_varchar_25	Varchar(25)	Yes	Base Lined Flag	No
CFGCMP_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CFGCMP_CREATIONDATE	_datetime_8	datetime(8)	Yes	Configuration Creation Date	No
CFGCMP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last modified date of the config process	No
CFGCMP_FILE_NAME	_varchar_50	varchar(50)	Yes	File name	No
CFGCMP_NO_OF_ATTACHMNT	_decimal_10_0	decimal(10)	Yes	Number of Attachments	No
CFGCMP_NO_OF_POSCODE	_decimal_10_0	decimal(10)	Yes	Number of position codes	No
CFGCMP_INIT_FILENAME	_varchar_50	varchar(50)	Yes	Init Filname	No

Table Name :	CFG_CFGCM_CFGMDL_ASSOCIATION
Comment :	The mapping of Configuration Class to Models is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGCM_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGCM_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class	Yes
CFGCM_MODEL_NO	_varchar_20	varchar(20)	No	Model associated to the Configuration class	Yes
CFGCM_MODEL_OU	_decimal_10_0	decimal(10)	No	OUInstance of the Model	No

Table Name :	CFG_CFGCNT_CMP_CONFIG_NOTES
Comment :	Notes for component Configuration is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGCNT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGCNT_COMPONENTID	_varchar_90	varchar(90)	No	The number identifying the component	Yes
CFGCNT_CONFIG_REVNO	_varchar_40	varchar(40)	No	The number identifying the revision of the component configuration with respect to the component configuration status.	Yes
CFGCNT_NOTES	_varchar_2000	varchar(2000)	Yes	Notes related to the act	No
CFGCNT_NOTES_ID	udd_guid	varchar(40)	Yes	Noted identity number	No

Table Name :	CFG_CFGCPS_CMP_SPPART_POS
Comment :	Various position codes of the spare part which is tracked is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGCPS_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGCPS_COMPONENTID	_varchar_90	varchar(90)	No	The number identifying the component.	Yes
CFGCPS_REVNO	_varchar_40	varchar(40)	No	The number identifying the revision of the component configuration with respect to the component configuration status.	Yes
CFGCPS_SPARE_PART_NO	_varchar_40	varchar(40)	No	Spare part Number	Yes
CFGCPS_POS_CODE	_varchar_25	Varchar(25)	No	Position code	Yes
CFGCPS_POS_STATUS	_varchar_15	varchar(15)	Yes	Status of the position code	No
CFGCPS_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number	No
CFGCPS_LOT_NO	_varchar_18	varchar(18)	Yes	Lot Number	No
CFGCPS_DATE_OF_ATTACH	_datetime_8	datetime(8)	Yes	Date of Attachment	No
CFGCPS_WO_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Work Order Number	No
CFGCPS_WO_NO	_varchar_18	varchar(18)	Yes	Work Order Number	No

Table Name :	CFG_CFGCRH_CRHISTORY_LOG
Comment :	Component History Log Table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGCRH_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
CFGCRH_COMPONENT_ID	_varchar_90	varchar(90)	No	Component Id associated with the aircraft	Yes
CFGCRH_EFF_FROM_DATE	_datetime_8	datetime(8)	No	Effective Attachment Date	Yes
CFGCRH_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Component Id associated with the aircraft	No
CFGCRH_AIRCRAFT_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Aircraft reg No	No
CFGCRH_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration No	No
CFGCRH_REV_NO	_varchar_40	varchar(40)	Yes	Revision Number	No
CFGCRH_POS_CODE	_varchar_25	Varchar(25)	Yes	Position Code	No
CFGCRH_POS_TYPE	_varchar_5	varchar(5)	Yes	can be of others or engine or APU	No
CFGCRH_POS_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the part in the Position.	No
CFGCRH_POS_PART_NO	_varchar_40	varchar(40)	Yes	Part in the Position.	No
CFGCRH_PARENT_COMPONENT_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the parent Component Id associated with the aircraft	No
CFGCRH_PARENT_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Parent Component Id associated with the aircraft	No
CFGCRH_PART_SERIAL_NO	_varchar_40	varchar(40)	Yes	Part Serial Number	No
CFGCRH_EFF_TO_DATE	_datetime_8	datetime(8)	Yes	Effective removal date	No
CFGCRH_IN_STATUS	_varchar_25	Varchar(25)	Yes	In Coming Status	No
CFGCRH_OUT_STATUS	_varchar_25	Varchar(25)	Yes	Out Going Status	No
CFGCRH_EO_NO	_varchar_40	varchar(40)	Yes	Engineering Document No	No
CFGCRH_ATA_NO	_varchar_16	varchar(16)	Yes	ATA Number	No
CFGCRH_ATTACH_TRAN_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Attachment transaction No	No
CFGCRH_ATTACH_TRAN_NO	_varchar_40	varchar(40)	Yes	Attachment transaction Number	No
CFGCRH_REMOVAL_TRAN_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Removal transaction No	No
CFGCRH_REMOVAL_TRAN_NO	_varchar_40	varchar(40)	Yes	Removal transaction Number	No
CFGCRH_LEVEL_CODE	_varchar_150	varchar(150)	Yes	Level Code	No
CFGCRH_LEVEL_NO	_decimal_10_0	decimal(10)	Yes	Level Number	No
CFGCRH_PRM1_IN_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 1 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM1_OUT_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 1 identified in Aircraft at the time of Removing the Component.	No
CFGCRH_PRM1_IN_SO	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value of the Parameter 1 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM1_OUT_SO	_decimal_28_8	decimal(28)	Yes	Since OverHaul Value of the Parameter 1 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM2_IN_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 2 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM2_OUT_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 2 identified in Aircraft at the time of Removing the Component.	No
CFGCRH_PRM2_IN_SO	_decimal_28_8	decimal(28)	Yes	Since OverHaul Value of the Parameter 2 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM2_OUT_SO	_decimal_28_8	decimal(28)	Yes	Since OverHaul Value of the Parameter 2 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM3_IN_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 3 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM3_OUT_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 3 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM3_IN_SO	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value of the Parameter 3 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM3_OUT_SO	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value of the Parameter 3 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM4_IN_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 4 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM4_OUT_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 4 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM4_IN_SO	_decimal_28_8	decimal(28)	Yes	Since OverHaul Value of the Parameter 4 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM4_OUT_SO	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value of the Parameter 4 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM5_IN_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 5 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM5_OUT_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 5 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM5_IN_SO	_decimal_28_8	decimal(28)	Yes	Since OverHaul Value of the Parameter 5 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM5_OUT_SO	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value of the Parameter 5 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM6_IN_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 6 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM6_OUT_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 6 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM6_IN_SO	_decimal_28_8	decimal(28)	Yes	Since OverHaul Value of the Parameter 6 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM6_OUT_SO	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value of the Parameter 6 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM7_IN_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 7 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM7_OUT_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 7 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM7_IN_SO	_decimal_28_8	decimal(28)	Yes	Since OverHaul Value of the Parameter 7 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM7_OUT_SO	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value of the Parameter 7 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM8_IN_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 8 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM8_OUT_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 8 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM8_IN_SO	_decimal_28_8	decimal(28)	Yes	Since OverHaul Value of the Parameter 8 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM8_OUT_SO	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value of the Parameter 8 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM9_IN_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 9 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM9_OUT_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 9 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM9_IN_SO	_decimal_28_8	decimal(28)	Yes	Since OverHaul Value of the Parameter 9 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM9_OUT_SO	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value of the Parameter 9 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM10_IN_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 10 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM10_OUT_SN	_decimal_28_8	decimal(28)	Yes	Since New Value of the Parameter 10 identified in Aircraft at the time of removing the Component.	No
CFGCRH_PRM10_IN_SO	_decimal_28_8	decimal(28)	Yes	Since OverHaul Value of the Parameter 10 identified in Aircraft at the time of Attaching the Component.	No
CFGCRH_PRM10_OUT_SO	_decimal_28_8	decimal(28)	Yes	Since Overhaul Value of the Parameter 10 identified in Aircraft at the time of removing the Component.	No
CFGCRH_CREATEDBY	_varchar_30	varchar(30)	Yes	Created User name	No
CFGCRH_CREATEDDATE	_datetime_8	datetime(8)	Yes	created date of the config process	No
CFGCRH_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
cfgcrh_ini_attach_sts	_varchar_5	varchar(5)	Yes	can be of Fresh,Active,Cancel,inactive	No
cfgcrh_ini_attach_date	_datetime_8	datetime(8)	Yes	Attachment Date	No
cfgcrh_ini_attach_by	_varchar_30	varchar(30)	Yes	Name of the person who done the attachment	No

Table Name :	CFG_CFGCSP_CMPCFG_SPARE_PART
Comment :	Spare part list for the component configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGCSP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGCSP_COMPONENTID	_varchar_90	varchar(90)	No	Component Id associated with the aircraft	Yes
CFGCSP_REVNO	_varchar_40	varchar(40)	No	The number identifying the revision of the component configuration with respect to the component configuration status.	Yes
CFGCSP_SPARE_PART_NO	_varchar_40	varchar(40)	No	spare part number	Yes
CFGCSP_SPARE_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Spare Part Number	No
CFGCSP_QUANTITY	udd_count	int(4)	Yes	quanity of the spare part which needs to be tracked	No
CFGCSP_TRACKABLE_FLAG	_varchar_25	Varchar(25)	Yes	trackable flag . Holds value "Yes" or "No"	No
CFGCSP_POS_PREFIX	_varchar_25	Varchar(25)	Yes	Prefix to generate the positon codes	No
created_area_code	_varchar_40	varchar(40)	Yes	Created area code	No
CFGCSP_KEY_SEQNO	udd_count	int(4)	No	Key sequence number	Yes
CFGCSP_DISP_SEQNO	udd_count	int(4)	No	Display sequence number	No
CFGCSP_POS_CODE	_varchar_25	Varchar(25)	Yes	Spare part Position code	No
CFGCSP_POS_DESC	_varchar_255	varchar(255)	Yes	Spare part Position description	No
CFGCSP_POS_STATUS	udd_designparamcode	varchar(5)	No	Spare part position status	No
CFGCSP_EXSTING_PART_NO	_varchar_40	varchar(40)	Yes	Existing part number	No
CFGCSP_EXSTING_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	Existing part number Ouinstance	No
CFGCSP_EXSTING_MF_PARTNO	_varchar_40	varchar(40)	Yes	Existing part manufacturer number	No
CFGCSP_EXSTING_PART_MFNO	_varchar_45	varchar(45)	Yes	Existing manufacturer part number	No
CFGCSP_EXIST_QTY	udd_count	int(4)	Yes	Existing part quantity	No
CFGCSP_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks entered by user	No
CFGCSP_REFDOC	udd_txt2000	varchar(2000)	Yes	Reference document number	No
CFGCSP_CREATEDBY	udd_ctxt_user	varchar(30)	No	created user	No
CFGCSP_CREATEDDATE	_datetime_8	datetime(8)	No	created date	No
CFGCSP_MODIFIEDBY	udd_ctxt_user	varchar(30)	No	Modified user	No
CFGCSP_MODIFIEDDATE	_datetime_8	datetime(8)	No	Modified date	No
CFGCSP_TIMESTAMP	udd_count	int(4)	No	Timestamp	No
CFGCSP_POSTYPE	_varchar_80	varchar(80)	Yes	Position type	No
CFGCSP_PARTDESC	_varchar_150	varchar(150)	Yes	Part description	No
CFGCSP_PARTUOM	_varchar_10	varchar(10)	Yes	Part unit of measurement	No

Table Name :	CFG_CFGMCD_MDL_CONFIG_CDL
Comment :	Component Deviation List for Model Configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMCD_MODEL_NO	_varchar_20	varchar(20)	No	The model associated to the aircraft for which the configuration details are to be entered	Yes
CFGMCD_CONFIG_CLASS	_varchar_30	varchar(30)	No	The system retrieves the aircraft that are associated to the configuration class entered here.	Yes
CFGMCD_REVNO	_varchar_40	varchar(40)	No	The revision number of the configuration class.	Yes
CFGMCD_PART_NO	_varchar_40	varchar(40)	Yes	Part Number included in cofiguration deviation list	No
CFGMCD_MAINT_IMPLICATION	_varchar_255	varchar(255)	Yes	Maintenance Implications if any	No
CFGMCD_OPER_IMPLICATION	_varchar_255	varchar(255)	Yes	Operational Implications if any	No
CFGMCD_CDL_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
CFGMCD_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Part Number	No
CFGMCD_CDL_ITEM_CODE	_varchar_150	varchar(150)	No	Cofiguration deviation list Item Code	Yes
CFGMCD_CDL_ITEM_DESC	_varchar_255	varchar(255)	Yes	Cofiguration deviation list Item Description	No
CFGMCD_CDL_QTY	_decimal_28_8	decimal(28)	Yes	Cofiguration deviation list Quantity	No
CFGMCD_CDL_MIN_QTY	_decimal_28_8	decimal(28)	Yes	Cofiguration deviation list Minimum Quantity	No
CFGMCD_CDL_ITEM_STATUS	_varchar_15	varchar(15)	Yes	Status of the CDL Item Number	No
CFGMCD_PLACARD	_varchar_5	varchar(5)	Yes	Placard R - Required N - Not Requrired	No
CFGMCD_PLACARD_INST	_varchar_2000	varchar(2000)	Yes	Placard Instructions	No
CFGMCD_FILE_NAME	_varchar_50	varchar(50)	Yes	File name	No
cfgmcd_deferral_task	_varchar_30	varchar(30)	Yes	defferal Task	No
cfgmcd_deferral_rev_task	_varchar_40	varchar(40)	Yes	Defferel Revised task detail	No
CFGMCD_DEF_CATEGORY	udd_melcategory	varchar(30)	Yes	Default catergory	No

Table Name :	CFG_CFGMDL_MODEL_CONFIG
Comment :	Model Configuration details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMDL_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinsatnce	Yes
CFGMDL_MODEL_NO	_varchar_20	varchar(20)	No	Model No associated with the aircraft	Yes
CFGMDL_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration class	Yes
CFGMDL_REVNO	_varchar_40	varchar(40)	No	revision number	Yes
CFGMDL_MODEL_OU	_decimal_10_0	decimal(10)	Yes	OU of the Model	No
CFGMDL_STATUS	_varchar_15	varchar(15)	No	Status of the configuration. Can be active or fresh or revised or cancelled	No
CFGMDL_CREATED_BY	_varchar_30	varchar(30)	Yes	name of the person who created the act	No
CFGMDL_CREATIONDATE	_datetime_8	datetime(8)	Yes	creation date	No
CFGMDL_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last modified date of the config process	No
CFGMDL_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By-name of the person	No
CFGMDL_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp of the current record	No
CFGMDL_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CFGMDL_INHERIT_CHANGES	_varchar_25	Varchar(25)	Yes	Inherit Changes Flag	No
CFGMDL_APPROVEDDATE	_datetime_8	datetime(8)	Yes	Approved Date	No
CFGMDL_APPROVED_BY	_varchar_30	varchar(30)	Yes	Approved By-name of the person	No
CFGMDL_BASELINED_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if the current Model configuration revision has been baselined or not.Holds yes or no value	No
CFGMDL_MISMATCH_FLAG	_varchar_25	Varchar(25)	Yes	Sets Y or N for denoting mismatch	No
CFGMDL_FILE_NAME	_varchar_50	varchar(50)	Yes	Model File Name	No
CFGMDL_MEL_FILE_NAME	_varchar_50	varchar(50)	Yes	Minimum Equipment List file name.	No
CFGMDL_CDL_FILE_NAME	_varchar_50	varchar(50)	Yes	Configuration Deviation List Filename	No
CFGMDL_CFGCTRL_BASIS	udd_designparamcode	varchar(5)	Yes	control basis	No

Table Name :	CFG_CFGMDL_POSTATTRIB_DTL
Comment :	Stores Details Of Position Attributes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMDL_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ou Instance	Yes
CFGMDL_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	The aircraft registration number	Yes
CFGMDL_AIRCRAFT_REV_NO	_varchar_40	varchar(40)	Yes	The revision number of the model configuration.	No
CFGMDL_MODEL_NO	_varchar_20	varchar(20)	No	Aircraft model number	No
CFGMDL_CONFIG_CLASS	_varchar_30	varchar(30)	Yes	Configuration class	No
CFGMDL_REVNO	_varchar_40	varchar(40)	Yes	revision number	No
CFGMDL_POS_CODE	_varchar_25	Varchar(25)	No	The position code for which the configuration rules must be defined	Yes
CFGMDL_POS_PART_NO	_varchar_40	varchar(40)	No	The part number for which the position code details are to be retrieved	Yes
CFGMDL_POS_PART_OU	_decimal_10_0	decimal(10)	Yes	Part Ouinstance	No
CFGMDL_ZONECODE	_varchar_40	varchar(40)	Yes	The zone associated to the position code	No
CFGMDL_BODY_STATION_NO	_varchar_15	varchar(15)	Yes	Station Associated With the Body	No
CFGMDL_ATA_NO	_varchar_16	varchar(16)	Yes	The ATA chapter number associated to the position code	No
CFGMDL_LINK_INFO	_varchar_25	Varchar(25)	Yes	Indicates whether the interchangeability rules, intermixing rules and ETOP twin position rules have been entered for the position.	No
CFGMDL_PARENT_PART_NO	_varchar_40	varchar(40)	Yes	Parent part info	No
CFGMDL_LEVEL_CODE	_varchar_150	varchar(150)	No	The level code corresponding to the position code	Yes
CFGMDL_LEVEL_NO	_varchar_150	varchar(150)	No	The level number of the position code and its associated part number.	No
CFGMDL_CARGO_FLAG	_varchar_25	Varchar(25)	Yes	indicate that the position code is in the cargo aircraft.	No
CFGMDL_RVSM_FLAG	_varchar_25	Varchar(25)	Yes	to indicate that the position code is in the aircraft, which fly in the reduced vertical separation minimum limit.	No

Table Name :	CFG_CFGMDT_MDL_CONFIG_DTL
Comment :	Position code details for the Model Configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMDT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMDT_MODEL_NO	_varchar_20	varchar(20)	No	Model No associated with the aircraft	Yes
CFGMDT_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration class	Yes
CFGMDT_REVNO	_varchar_40	varchar(40)	No	Revision number	Yes
CFGMDT_POS_CODE	_varchar_25	Varchar(25)	No	Postion Code	Yes
CFGMDT_POS_PART_NO	_varchar_40	varchar(40)	Yes	Part number associated with the position code	No
CFGMDT_POS_STATUS	_varchar_15	varchar(15)	Yes	Status of the position code. Can be Active or Inactive	No
CFGMDT_POS_TYPE	_varchar_25	Varchar(25)	Yes	Position Code type . Can be "Engine", "APU", "Landing Gear" or "Others"	No
CFGMDT_ROT_MAN_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if a rotable is mandatory in the position code defined.	No
CFGMDT_CARGO_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if the configuration is applicable for cargo planes	No
CFGMDT_RVSM_FLAG	_varchar_25	Varchar(25)	Yes	reduced vertical seperation maintanance Flag	No
CFGMDT_MEL_FLAG	_varchar_25	Varchar(25)	Yes	minimum equipment list Flag	No
CFGMDT_ZONECODE	_varchar_15	varchar(15)	Yes	Zone Code	No
CFGMDT_BODY_STATION_NO	_varchar_15	varchar(15)	Yes	Body Station no	No
CFGMDT_ATA_NO	_varchar_16	varchar(16)	Yes	ATA chaptor no	No
CFGMDT_DRAWING_NO	_varchar_40	varchar(40)	Yes	Drawing no	No
CFGMDT_DOC_PATH	_varchar_50	varchar(50)	Yes	path where the document is available.	No
CFGMDT_LEVEL_NO	_decimal_10_0	decimal(10)	Yes	level number of the position code	No
CFGMDT_LEVEL_CODE	_varchar_150	varchar(150)	Yes	unique identifier for the position code in the structure of configuration	No
CFGMDT_NO_OF_ENG	_decimal_10_0	decimal(10)	Yes	no of engines	No
CFGMDT_NO_OF_APUS	_decimal_10_0	decimal(10)	Yes	no of auxillury power units	No
CFGMDT_POS_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the part number	No
CFGMDT_CHANGE_TYPE_FLAG	_varchar_25	Varchar(25)	Yes	This flag indicates whether the change is insertion or modification	No
CFGMDT_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Sequence Number	No
CFGMDT_LINK_INFO	_varchar_75	varchar(75)	Yes	Link Flag Information	No
CFGMDT_DISP_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Display Sequence Number	No
CFGMDT_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFGMDT_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identity number	No

Table Name :	CFG_CFGMELC_MEL_CATEGORY
Comment :	Minimum Equipment list Category Detailas are get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMELC_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
CFGMELC_MEL_CATEGORY	_varchar_30	varchar(30)	No	The code identifying minimum equipment list category that you wish to modify	Yes
CFGMELC_DESCRIPTION	_varchar_150	varchar(150)	Yes	The textual description of the minimum equipment list category.	No
CFGMELC_DEFERRAL_TYPE	_varchar_5	varchar(5)	Yes	Deferral Type, Time based Deferal, Usage Based Deferal	No
CFGMELC_LIMIT_BASIS	_varchar_5	varchar(5)	Yes	Limit Basis Time and Usage Limited" in the "Limit Type" field.	No
CFGMELC_DEFERRAL_DUR	_decimal_20_0	decimal(20)	Yes	The duration or period for which the minimum equipment list item number can be deferred	No
CFGMELC_DUR_UOM	_varchar_5	varchar(5)	Yes	The unit of measurement for the parameter Hours, Days	No
CFGMELC_STATUS	_varchar_5	varchar(5)	Yes	minimum equipment list Category Status Active, InActive	No
CFGMELC_REMARKS	_varchar_255	varchar(255)	Yes	Any remark or comment pertaining the minimum equipment list category	No
CFGMELC_CREATED_BY	_varchar_30	varchar(30)	Yes	Created User name	No
CFGMELC_CREATEDDATE	_datetime_8	datetime(8)	Yes	created date of the config process	No
CFGMELC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified User	No
CFGMELC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	modified date of the config process	No
CFGMELC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp of the current record	No

Table Name :	CFG_CFGMELP_MEL_CATG_PARAM
Comment :	Parameter Deferral limit details for the MEL Category

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMELP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMELP_MEL_CATEGORY	_varchar_30	varchar(30)	No	The minimum equipment list category code	Yes
CFGMELP_PARAM_CODE	_varchar_40	varchar(40)	No	The unique code identifying the parameter, as defined in the Aircraft business comp	Yes
CFGMELP_DEFERRAL_LIMIT	_decimal_20_0	decimal(20)	Yes	The value of the parameter based on which the minimum equipment list item number is deferred	No

Table Name :	CFG_CFGMEL_MDL_CONFIG_MEL
Comment :	Minimum equipment list for the model configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMEL_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMEL_MODEL_NO	_varchar_20	varchar(20)	No	The aircraft model for which the minimum equipment list is displayed	Yes
CFGMEL_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration class	Yes
CFGMEL_REVNO	_varchar_40	varchar(40)	No	Revision number	Yes
CFGMEL_PART_NO	_varchar_40	varchar(40)	Yes	The part number to which the component belongs	No
CFGMEL_CONDITION_FLAG	_varchar_25	Varchar(25)	Yes	Indicates that the usage of the part in an unserviceable state is based on certain cond	No
CFGMEL_CONDITIONS	udd_txt2000	varchar(2000)	Yes	The conditions or the factors governing the usage of the part in an unserviceable state	No
CFGMEL_MEL_QTY	_decimal_28_8	decimal(28)	Yes	quantity of the part to be included in the MEL	No
CFGMEL_MAINT_IMPLICATION	_varchar_255	varchar(255)	Yes	The maintenance implications of flying the aircraft with the part in an unserviceable state	No
CFGMEL_OPER_IMPLICATION	_varchar_255	varchar(255)	Yes	The operational implications of flying the aircraft with the part in an unserviceable state.	No
CFGMEL_POS_BASED_FLAG	_varchar_25	Varchar(25)	Yes	This flag is true if the no of qty per aircraft and the minimum equipment list quantity given matches	No
CFGMEL_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Part Number	No
CFGMEL_MEL_ITEM_CODE	_varchar_150	varchar(150)	No	The number identifying the minimum equipment list item	Yes
CFGMEL_MEL_ITEM_DESC	_varchar_255	varchar(255)	Yes	The textual description of the minimum equipment list item	No
CFGMEL_CATEGORY	_varchar_25	Varchar(25)	Yes	The minimum equipment list category to which the minimum equipment list item belongs	No
CFGMEL_MIN_MEL_QTY	_decimal_28_8	decimal(28)	Yes	The minimum quantity of the part to be included in the MEL	No
CFGMEL_MEL_ITEM_STATUS	_varchar_15	varchar(15)	Yes	The status of the minimum equipment list item.	No
CFGMEL_PLACARD	_varchar_5	varchar(5)	Yes	Placard N- Not Required R- Required	No
CFGMEL_PLACARD_INST	_varchar_2000	varchar(2000)	Yes	Placard Instructions	No
CFGMEL_FILE_NAME	_varchar_50	varchar(50)	Yes	minimum equipment list File Name	No
cfgmel_deferral_task	_varchar_30	varchar(30)	Yes	The task performed during the first scheduled maintenance to rectify a deferred discrepancy, which would have occurred during a maintenance activity.	No
cfgmel_deferral_rev_task	_varchar_30	varchar(30)	Yes	cfgmel_deferral_rev_task	No
CFGMEL_DeferalType	_varchar_5	varchar(5)	Yes	The deferrel Type	No

Table Name :	CFG_CFGMEO_MODEL_EO_LIST
Comment :	List of Engineering Orders that changed model configuration.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMEO_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMEO_MODEL_NO	_varchar_20	varchar(20)	No	Model No associated with the aircraft	Yes
CFGMEO_CONFIG_CLASS	_varchar_30	varchar(30)	No	The configuration class associated to the aircraft.	Yes
CFGMEO_REV_NO	_varchar_40	varchar(40)	No	The revision number of the aircraft configuration.	Yes
CFGMEO_EO_NO	_varchar_40	varchar(40)	No	The number identifying the engineering order due to which the model configuration was revised	Yes
CFGMEO_RELEASED_DATE	_datetime_8	datetime(8)	Yes	The date on which the engineering order was issued.	No
CFGMEO_COMPLIED_DATE	_datetime_8	datetime(8)	Yes	The date on which the changes were made in the aircraft configuration.	No

Table Name :	CFG_CFGMIC_MDLCFG_INTCHGE_RULE
Comment :	Interchangable rules for the Model

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMIC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMIC_MODEL_NO	_varchar_20	varchar(20)	No	The aircraft model for which the part interchangeability rule details must be defined.	Yes
CFGMIC_CONFIG_CLASS	_varchar_30	varchar(30)	No	The configuration class to which the aircraft model is associated	Yes
CFGMIC_REVNO	_varchar_40	varchar(40)	No	The revision number of the model configuration	Yes
CFGMIC_POS_CODE	_varchar_25	Varchar(25)	No	The position code for which the list of interchangeable parts must be defined	Yes
CFGMIC_POS_PART_NO	_varchar_40	varchar(40)	No	The part associated to the position code, for which the list of interchangeable parts must be defined	Yes
CFGMIC_INTERCHANGE_PART	_varchar_40	varchar(40)	No	The part that can be fitted in place of the reference part number, in the reference position code	Yes
CFGMIC_LEVEL_CODE	_varchar_150	varchar(150)	No	The level at which the reference position code occurs in model configuration hierarchy	Yes
CFGMIC_ORDER_OF_PREF	_decimal_10_0	decimal(10)	Yes	The preferred order in which the interchangeable part must be considered for fitting in the reference position code	No
CFGMIC_MOD_STATUS	_varchar_15	varchar(15)	Yes	document number which authorizes the interhchangability	No
CFGMIC_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFGMIC_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identity number	No
cfgmic_Change_flag	udd_status	varchar(25)	Yes	Change Flag	No

Table Name :	CFG_CFGMIX_MDLCFG_INTMX_RULE
Comment :	Intermixing Rules for Model position codes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMIX_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMIX_MODEL_NO	_varchar_20	varchar(20)	No	The aircraft model for which the intermixing rule details must be defined	Yes
CFGMIX_CONFIG_CLASS	_varchar_30	varchar(30)	No	The configuration class to which the aircraft model is associated.	Yes
CFGMIX_REVNO	_varchar_40	varchar(40)	No	The revision number of the model configuration.	Yes
CFGMIX_LEVEL_CODE	_varchar_150	varchar(150)	No	The level code of the reference part number.	Yes
CFGMIX_POS_CODE	_varchar_25	Varchar(25)	No	The position code selected for which the dependent position codes must be entered.	Yes
CFGMIX_POS_PART_NO	_varchar_40	varchar(40)	No	select the part associated to the position code, for which the dependent position codes must be entered.	Yes
CFGMIX_DEP_LEVEL_CODE	_varchar_150	varchar(150)	No	The level at which the dependent position code and part number occurs in the model configuration hierarchy.	Yes
CFGMIX_DEP_POS_CODE	_varchar_25	Varchar(25)	No	The position code that is dependent on the reference position code and the reference part number	No
CFGMIX_DEP_PART_NO	_varchar_40	varchar(40)	No	The part number that must be fitted in the dependent position code, when the reference part number is fitted in the reference position code	No
CFGMIX_REV_FLAG	_varchar_25	Varchar(25)	Yes	Reversible Flag, Yes , No	No
CFGMIX_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFGMIX_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identity number	No
cfgmix_Change_flag	udd_status	varchar(25)	Yes	Sets Inactive I or Active A	No

Table Name :	CFG_CFGMLK_MODEL_LINK_INFO
Comment :	Model Configuration Link Information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMLK_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMLK_MODEL_NO	_varchar_20	varchar(20)	No	The model to which the aircraft is associated	Yes
CFGMLK_CONFIG_CLASS	_varchar_30	varchar(30)	No	that are associated to the selected aircraft model	Yes
CFGMLK_REV_NO	_varchar_40	varchar(40)	No	The revision number of the aircraft configuration	Yes
CFGMLK_LEVEL_CODE	_varchar_150	varchar(150)	No	The level code corresponding to the position code	Yes
CFGMLK_POS_CODE	_varchar_25	Varchar(25)	No	The position code for which the configuration rules must be defined	No
CFGMLK_PART_NO	_varchar_40	varchar(40)	No	The part number for which the position code details are to be retrieved	No
CFGMLK_CHILD_LEVEL_NO	_decimal_10_0	decimal(10)	No	child Level Number	No
CFGMLK_ZONE_CODE	_varchar_15	varchar(15)	Yes	The zone to be associated to the position code	No
CFGMLK_ATA_NO	_varchar_16	varchar(16)	Yes	The ATA chapter to be associated to the position code	No
CFGMLK_BODY_STATION	_varchar_15	varchar(15)	Yes	Station which is associated with the body of the aircraft	No
CFGMLK_CARGO_FLAG	_varchar_25	Varchar(25)	Yes	that the position code is in the cargo aircraft. The system provides the options "Yes" and "No".	No
CFGMLK_RVSM_FLAG	_varchar_15	varchar(15)	Yes	indicate that the position code is in the aircraft, which fly in the reduced vertical separation minimum limit. The system provides the options "Yes" and "No".	No
CFGMLK_LINK_FLAG	_varchar_15	varchar(15)	Yes	Indicates whether the interchangeability rules, intermixing rules and ETOP twin position rules have been entered for the position IC,IM,ETOP	No
CFGMLK_NHA	_varchar_40	varchar(40)	Yes	Next Higher Assembly	No

Table Name :	CFG_CFGMNT_MDLCFG_NOTES
Comment :	This table stores Model Configuration Notes , Config Class, Revision Number against each model.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMNT_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
CFGMNT_MODEL_NO	_varchar_20	varchar(20)	No	Configuration Model No associated with the aircraft	Yes
CFGMNT_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class	Yes
CFGMNT_REVNO	_varchar_40	varchar(40)	No	Revision Number	Yes
CFGMNT_NOTES	_varchar_2000	varchar(2000)	Yes	Notes related to the act	No

Table Name :	CFG_CFGMPS_MDCFG_SPPART_POS
Comment :	Position Code definition for the trackable spare parts in the model

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMPS_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMPS_MODEL_NO	_varchar_20	varchar(20)	No	The aircraft model associated with aircraft	Yes
CFGMPS_CONFIG_CLASS	_varchar_30	varchar(30)	No	The configuration class to which the aircraft model is associated	Yes
CFGMPS_REVNO	_varchar_40	varchar(40)	No	The revision number of the model configuration	Yes
CFGMPS_SPARE_PART	_varchar_40	varchar(40)	No	The spare part to be associated to the aircraft configuration	Yes
CFGMPS_POS_CODE	_varchar_25	Varchar(25)	No	The position code to which the spare part must be fitted	Yes
CFGMPS_POS_STATUS	_varchar_15	varchar(15)	Yes	Status of the position code .Can be either active or Inactive.	No
CFGMPS_POS_COUNT	_decimal_10_0	decimal(10)	Yes	Position Count (seq no)	No

Table Name :	CFG_CFGMSP_MDCFG_SPARE_PART
Comment :	Spare Part list for Model Configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMSP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMSP_MODEL_NO	_varchar_20	varchar(20)	No	The model to which the aircraft is associated.	Yes
CFGMSP_CONFIG_CLASS	_varchar_30	varchar(30)	No	The configuration class to which the aircraft is associated.	Yes
CFGMSP_REVNO	_varchar_40	varchar(40)	No	The revision number of the aircraft configuration.	Yes
CFGMSP_SPARE_PART	_varchar_40	varchar(40)	No	Spare Part Number	Yes
CFGMSP_QUANTITY	udd_count	int(4)	Yes	Quantity of the Spare Part that needs to be tracked	No
CFGMSP_TRACKABLE_FLAG	_varchar_25	Varchar(25)	Yes	Trackable Flag	No
CFGMSP_POS_PREFIX	_varchar_6	varchar(6)	Yes	Prefix for the position code generation	No
CFGMSP_SPARE_PART_OU	_decimal_10_0	decimal(10)	Yes	OUInstance of the Spare Part Number	No
CFGMSP_ZONE	_varchar_15	varchar(15)	Yes	Zone Code	No

Table Name :	CFG_CFGMTW_MDLCFG_ETOP_TWNPS
Comment :	ETop Twin positions for Model Configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGMTW_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGMTW_MODEL_NO	_varchar_20	varchar(20)	No	The aircraft model associated with aircraft	Yes
CFGMTW_CONFIG_CLASS	_varchar_30	varchar(30)	No	The configuration class to which the aircraft model is associated.	Yes
CFGMTW_REVNO	_varchar_40	varchar(40)	No	The revision number of the model configuration.	Yes
CFGMTW_LEVEL_CODE	_varchar_150	varchar(150)	No	the level at which the reference position code occurs in the model configuration hierarchy.	Yes
CFGMTW_POS_CODE	_varchar_25	Varchar(25)	No	position code, for which the twin position code must be defined.	Yes
CFGMTW_POS_PART_NO	_varchar_40	varchar(40)	No	The part associated to the reference position code.	Yes
CFGMTW_TWIN_LEVEL_CODE	_varchar_150	varchar(150)	No	The level at which the twin position code and part number occurs in the model configuration hierarchy.	Yes
CFGMTW_TWIN_POS_CODE	_varchar_25	Varchar(25)	No	The position code that is parallel to the reference position code displayed in the "Ref. Position Code" field	No
CFGMTW_TWIN_PART_NO	_varchar_40	varchar(40)	No	Part Number associated with the twin position code	No
cfgmtw_Change_flag	udd_status	varchar(25)	Yes	Model change flag	No

Table Name :	CFG_CFGPEO_PART_EO_LIST
Comment :	This Table maintains the list of EOs that trigger the Part revisions

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGPEO_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFGPEO_PART_NO	_varchar_40	varchar(40)	No	Part no which triggers the Eo	Yes
CFGPEO_REV_NO	_varchar_40	varchar(40)	No	Revion no of the configuration	Yes
CFGPEO_EO_NO	_varchar_40	varchar(40)	No	Engineering Order Number	Yes
CFGPEO_RELEASED_DATE	_datetime_8	datetime(8)	Yes	Released Date	No
CFGPEO_COMPLIED_DATE	_datetime_8	datetime(8)	Yes	Compliance Date	No

Table Name :	CFG_CFGPNT_PART_NOTES
Comment :	This table maintains the notes for Part Configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGPNT_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CFGPNT_PART_NO	_varchar_40	varchar(40)	No	Part No.	Yes
CFGPNT_REV_NO	_varchar_40	varchar(40)	No	Revion No	Yes
CFGPNT_NOTES	_varchar_2000	varchar(2000)	Yes	Notes related to the act	No
CFGPNT_NOTES_ID	udd_guid	varchar(40)	Yes	Notes Identity number	No
cfgpnt_operator_code	udd_operatorcode	varchar(32)	No	Operator number associated to the part configuration	Yes

Table Name :	CFG_CFGPPP_CFGPRT_SPPT_POS
Comment :	Position codes that are tracked in the Spare part

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGPPP_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CFGPPP_PART_NO	_varchar_40	varchar(40)	No	part to be associated to the aircraft configuration	Yes
CFGPPP_REV_NO	_varchar_40	varchar(40)	No	The revision number of the configuration	Yes
CFGPPP_SPARE_PART	_varchar_40	varchar(40)	No	The spare part to be associated to the aircraft	Yes
CFGPPP_POS_CODE	_varchar_25	Varchar(25)	No	The position code to which the spare part must be fitted	Yes
CFGPPP_POS_STATUS	_varchar_15	varchar(15)	Yes	Status of the Position Code. Can be Active or Inactive	No
cfgppp_operator_code	udd_operatorcode	varchar(32)	No	Operator code	Yes

Table Name :	CFG_CFGPSP_PRTCFG_SPARE_PART
Comment :	Spare Part List for part configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGPSP_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
CFGPSP_PART_NO	_varchar_40	varchar(40)	No	Part number	Yes
CFGPSP_REV_NO	_varchar_40	varchar(40)	No	Revision number	Yes
CFGPSP_SPARE_PART_NO	_varchar_40	varchar(40)	No	Spare Part Number	Yes
CFGPSP_QUANTITY	udd_count	int(4)	Yes	Quantity of the Spare part which has to be tracked	No
CFGPSP_TRACKABLE_FLAG	_varchar_25	Varchar(25)	Yes	Trackable Falg - Can be Yes or No	No
CFGPSP_POS_PREFIX	_varchar_6	varchar(6)	Yes	Prefx for generating the position codes	No
CFGPSP_SPARE_PART_OU	udd_ctxt_ouinstance	int(4)	No	OUInstance of the Spare Part	No
cfgpsp_operator_code	udd_operatorcode	varchar(32)	No	Operator code	Yes
cfgpsp_Change_Flag	udd_designparamcode	varchar(5)	Yes	Change Flag	No
CFGPSP_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created by user name	No
CFGPSP_CREATEDDATE	udd_datetime1	datetime(8)	Yes	created date	No
CFGPSP_DISP_SEQNO	udd_seqno	int(4)	No	seq number available in the screen	No
CFGPSP_KEY_SEQNO	udd_seqno	int(4)	No	Key Seq Number	No
CFGPSP_MODIFIEDBY	udd_ctxt_user	varchar(30)	Yes	Modified user Name	No
CFGPSP_MODIFIEDDATE	udd_datetime1	datetime(8)	Yes	Modified date	No
CFGPSP_PARTUOM	_varchar_10	varchar(10)	Yes	Unit of mesurement	No
CFGPSP_POS_CODE	udd_positioncode	varchar(25)	Yes	Position part Number	No
CFGPSP_POS_DESC	udd_txt255	varchar(255)	Yes	Description on the available position	No
CFGPSP_POS_STATUS	udd_designparamcode	varchar(5)	Yes	Position Status	No
CFGPSP_POS_TYPE	udd_quickcode	varchar(25)	Yes	Position Type	No
CFGPSP_REFDOC_NO	udd_txt255	varchar(255)	Yes	Document Number	No
CFGPSP_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks	No
CFGPSP_TIMESTAMP	udd_timestamp	int(4)	No	Time Stamp	No

Table Name :	CFG_CFGPTT_PART_CONFIG_DTL
Comment :	Part Configuration Table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGPTT_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	No
CFGPTT_PART_NO	_varchar_40	varchar(40)	No	Part no	No
CFGPTT_REV_NO	_varchar_40	varchar(40)	No	Revision No.	No
CFGPTT_POS_CODE	_varchar_25	Varchar(25)	No	Positon Code	No
CFGPTT_POS_PART_NO	_varchar_40	varchar(40)	No	associated part number	No
CFGPTT_POS_STATUS	_varchar_15	varchar(15)	Yes	can be of Active A or inactive I	No
CFGPTT_POS_TYPE	_varchar_25	Varchar(25)	Yes	position type.Can be "Engine", "APU", "Landing Gear" or "Others"	No
CFGPTT_RVSM_FLAG	_varchar_25	Varchar(25)	Yes	reduced vertical seperation maintanance Flag - Yes or No	No
CFGPTT_CARGO_FLAG	_varchar_25	Varchar(25)	Yes	Cargo Flag Yes or No	No
CFGPTT_ATA_NO	_varchar_16	varchar(16)	Yes	ATA Chapter Number	No
CFGPTT_DRAWING_NO	_varchar_40	varchar(40)	Yes	Drawing Number	No
CFGPTT_DOC_PATH	_varchar_50	varchar(50)	Yes	Document Path	No
CFGPTT_CHILD_EXISTS_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if the node has children	No
CFGPTT_CHANGE_TYPE_FLAG	_varchar_25	Varchar(25)	Yes	Change Type Flag	No
CFGPTT_ROT_MAN_FLAG	_varchar_25	Varchar(25)	Yes	Rotatable Mandatory flag - Holds flag "Yes" or "No"	No
CFGPTT_ZONECODE	_varchar_15	varchar(15)	Yes	Zone Code	No
CFGPTT_POS_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	OUInstance of the Position Part Number	No
CFGPTT_PART_SEQNO	_decimal_10_0	decimal(10)	Yes	Sequence Number	No
CFGPTT_DISP_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Display sequence No.	No
CFGPTT_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
CFGPTT_REMARKS_ID	udd_guid	varchar(40)	Yes	Remarks Identity number	No
cfgptt_operator_code	udd_operatorcode	varchar(32)	No	Operator code	No
cfgptt_unique_id	udd_unique_id	bigint(8)	No	Unique ID of part config DTL	Yes

Table Name :	CFG_CFGPT_PART_CONFIG
Comment :	Part Configuration

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFGPT_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OUInstance	No
CFGPT_PART_NO	_varchar_40	varchar(40)	No	Part Number	No
CFGPT_REV_NO	_varchar_40	varchar(40)	No	Revision Number	No
CFGPT_AC_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	This is the Aircraft Ou which has inherited the Inventory defined part	No
CFGPT_STATUS	_varchar_15	varchar(15)	Yes	Status of Part COnfiguration	No
CFGPT_NO_OF_ENGINES	_decimal_10_0	decimal(10)	Yes	Number of Engines	No
CFGPT_NO_OF_APUS	_decimal_10_0	decimal(10)	Yes	Number of Auxillary Power units	No
CFGPT_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CFGPT_CREATED_BY	_varchar_30	varchar(30)	Yes	name of the person who created the act	No
CFGPT_CREATEDDATE	_datetime_8	datetime(8)	Yes	created date of the config process	No
CFGPT_APPROVED_BY	_varchar_30	varchar(30)	Yes	Approved By-name of the person	No
CFGPT_APPROVEDDATE	_datetime_8	datetime(8)	Yes	Approved Date	No
CFGPT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By-name of the person	No
CFGPT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last modified date of the config process	No
CFGPT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp of the current record	No
CFGPT_BASELINED_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if the current Model configuration revision has been baselined or not.Holds yes or no value	No
CFGPT_MISMATCH_FLAG	_varchar_25	Varchar(25)	Yes	Sets Y or N for denoting mismatch	No
CFGPT_INHERIT_CHGS_FLAG	_varchar_25	Varchar(25)	Yes	Inherit Changes Flag	No
CFGPT_FILE_NAME	_varchar_50	varchar(50)	Yes	filename	No
cfgpt_operator_code	udd_operatorcode	varchar(32)	No	operator code	No
cfgpt_unique_id	udd_unique_id	bigint(8)	No	Unique ID	Yes

Table Name :	CFG_CFMELD_MDLCFG_MEL_DET
Comment :	Minimum equipment list for the Model Configuration is maintained

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFMELD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CFMELD_MODEL_NO	_varchar_20	varchar(20)	No	The model to which the aircraft is associated	Yes
CFMELD_CONFIG_CLASS	_varchar_30	varchar(30)	No	The configuration class to which the aircraft model is associated.	No
CFMELD_REVNO	_varchar_40	varchar(40)	No	The revision number of the configuration	Yes
CFMELD_POS_CODE	_varchar_25	Varchar(25)	No	Position Code which is a cdl	No
CFMELD_PART_NO	_varchar_40	varchar(40)	No	Part number	No
CFMELD_LEVEL_CODE	_varchar_150	varchar(150)	No	The level at which the part is associated to this position code in the model configuration hierarchy	Yes
CFMELD_CONDITION	udd_txt2000	varchar(2000)	Yes	Condition of the part	No
CFMELD_MAINT_IMPLICATION	_varchar_255	varchar(255)	Yes	Maintenance Implications if any	No
CFMELD_OPER_IMPLICATION	_varchar_255	varchar(255)	Yes	Operational Implications if any	No
CFMELD_CONDITIONAL_FLAG	_varchar_25	Varchar(25)	Yes	Conditional Flag - Y -"YES" , N - "NO"	No
CFMELD_MEL_FLAG	_varchar_25	Varchar(25)	Yes	Takes value "Yes" or "No"	No
CFMELD_NHA_NO	_varchar_40	varchar(40)	Yes	Next Higher Assembly	No
CFMELD_PLACARD	_varchar_5	varchar(5)	Yes	Placard R- Required N- Not Required	No
CFMELD_PLACARD_INST	_varchar_2000	varchar(2000)	Yes	Placard Instructions	No
CFMELD_MEL_ITEM_CODE	_varchar_30	varchar(30)	No	the number identifying the minimum equipment list item that must be included in the minimum equipment list	Yes
cfmeld_deferral_task	_varchar_30	varchar(30)	Yes	Deferral Task	No
cfmelD_deferral_rev_task	_varchar_30	varchar(30)	Yes	Deferral Task Revision	No

Table Name :	CFG_CFPEXP_PART_HIERARCHY
Comment :	The entire structure for a part that is mapped to a Model configuration is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFPEXP_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	OUinstance	Yes
CFPEXP_CNFG_PART_NO	_varchar_40	varchar(40)	No	Part number for which explosion is performed	Yes
CFPEXP_PART_NO	_varchar_40	varchar(40)	No	Part number attached to the position code in the exploded hierarchy of the cnfg_part_no	No
CFPEXP_PARENT_PART_NO	_varchar_40	varchar(40)	Yes	Immediate Parent of the Part number	No
CFPEXP_PARENT_REV_NO	_varchar_40	varchar(40)	Yes	Parent revision Number	No
CFPEXP_REV_NO	_varchar_40	varchar(40)	Yes	Revision Number	No
CFPEXP_POS_CODE	_varchar_25	Varchar(25)	Yes	Position code where the part gets attached	No
CFPEXP_POS_TYPE	_varchar_25	Varchar(25)	Yes	position type.Can be "Engine", "APU", "Landing Gear" or "Others"	No
CFPEXP_LEVEL_NO	_varchar_150	varchar(150)	Yes	Level number	No
CFPEXP_LEVEL_CODE	_varchar_150	varchar(150)	No	level code.System generated identifier	Yes
CFPEXP_PART_OU	udd_ctxt_ouinstance	int(4)	Yes	OUInstance of the Part Number	No
CFPEXP_ATA_NO	_varchar_16	varchar(16)	Yes	Ata Number	No
CFPEXP_ZONE_NO	_varchar_15	varchar(15)	Yes	Zone Code	No
CFPEXP_ASSEMBLY_FLAG	_varchar_25	Varchar(25)	Yes	Assembly Flag	No
cfpexp_operator_code	udd_operatorcode	varchar(32)	No	Opertaor code	Yes

Table Name :	CFG_MDLOG_MDL_CHG_LOG
Comment :	Model Configuration Change Log

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MDLOG_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
MDLOG_MODEL_NO	_varchar_20	varchar(20)	No	Model No associated with the aircraft	Yes
MDLOG_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class	Yes
MDLOG_STATUS	_varchar_15	varchar(15)	Yes	Status of the Model Configuration	No
MDLOG_LEVEL_CODE	_varchar_150	varchar(150)	No	Level Code	Yes
MDLOG_REV_NO	_varchar_40	varchar(40)	No	Revision Number	Yes
MDLOG_POS_CODE	_varchar_25	Varchar(25)	Yes	Position Code	No
MDLOG_POS_STATUS	_varchar_15	varchar(15)	Yes	can be of Active A or inactive I	No
MDLOG_PARTNO_OLD	_varchar_40	varchar(40)	Yes	Old Part Number	No
MDLOG_PARTNO_NEW	_varchar_40	varchar(40)	Yes	New Part Number	No
MDLOG_UPDMODE	_varchar_25	Varchar(25)	Yes	Update Mode New Part "I" Part Change "U"	No
MDLOG_EO_NO	udd_documentno	varchar(40)	No	Engineering Document No	Yes
MDLOG_CHG_DATE	_datetime_8	datetime(8)	No	Model Configuration Changed Date	Yes

Table Name :	CFG_PARAMETER_DETAILS
Comment :	The meta data details are get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	_varchar_80	varchar(80)	No	Component Id associated with the aircraft	Yes
PARAMCATEGORY	_varchar_10	varchar(10)	No	Parameter category like "MULTILINE , COMBO etc.	Yes
PARAMTYPE	_varchar_25	Varchar(25)	No	Parameter Type will be the Column name for which values need to be defined Eg. Preference Option	Yes
PARAMCODE	_varchar_5	varchar(5)	No	Value set for the parameter type. Eg. DA,CSA,ASS,AWH etc..	Yes
PARAMDESC	_varchar_80	varchar(80)	No	Parameter description	No
LANGID	_decimal_10_0	decimal(10)	No	Language id	No
CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation date	No
SORTBY	_decimal_10_0	decimal(10)	Yes	Order by value	No

Table Name :	CFG_POSPRT_CHANGE_LOG
Comment :	The part position change details are get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
POSPRT_OBJECT_TYPE	udd_designparamcode	varchar(5)	Yes	The type of Object	No
POSPRT_OBJECT	udd_componentid	varchar(90)	Yes	Object code	No
POSPRT_OU	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
POSPRT_CONFIG_CLASS	udd_configid	varchar(30)	Yes	Configuration Class	No
POSPRT_REV_NO	udd_revisionno	varchar(40)	Yes	Revision number	No
POSPRT_POS_CODE	udd_positioncode	varchar(25)	Yes	Position code	No
POSPRT_OLD_POS_PART	udd_partno	varchar(40)	Yes	Old Position Part number	No
POSPRT_NEW_POS_PART	udd_partno	varchar(40)	Yes	New Position part number	No
POSPRT_EO_NO	udd_documentno	varchar(40)	Yes	Eng.Order number	No
POSPRT_EO_REV_NO	udd_revisionno	varchar(40)	Yes	Eng.Order revision number	No
POSPRT_CHNGE_DT	_datetime_8	datetime(8)	Yes	Changed date	No
posprt_operator_code	udd_operatorcode	varchar(32)	No	Opertaor code	No

Table Name :	CFG_PRTLOG_CHG_LOG
Comment :	Part Configuration Change Log table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRTLOG_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
PRTLOG_PARTNO	_varchar_40	varchar(40)	No	Part Number	Yes
PRTLOG_STATUS	_varchar_15	varchar(15)	Yes	Status	No
PRTLOG_REV_NO	_varchar_40	varchar(40)	No	Revision Number	Yes
PRTLOG_POS_CODE	_varchar_25	Varchar(25)	No	Position Code	Yes
PRTLOG_POS_STATUS	_varchar_15	varchar(15)	Yes	Position Status	No
PRTLOG_PARTNO_OLD	_varchar_40	varchar(40)	Yes	Old Part Number	No
PRTLOG_PARTNO_NEW	_varchar_40	varchar(40)	Yes	New Part Number	No
PRTLOG_UPDMODE	_varchar_25	Varchar(25)	Yes	Update Mode New (I) or Update (U)	No
PRTLOG_EO_NO	udd_documentno	varchar(40)	No	Engineering Order Number	Yes
PRTLOG_CHG_DATE	_datetime_8	datetime(8)	No	Changed Date	Yes