Data Dictionary -- Technical Record

Srl. No.	Table Name	Comment
1	CFG_BP_AC_COMP_Batch_Dtl	Technical Records Configuration offline process table
2	Cfg_Cr_Error_Id_Desc	Technical Records Error description table
3	CFG_DFT_AC_COMP_Draft_DTL	Technical Records Configuration Draft detail table
4	Cfg_DFT_AC_COMP_Draft_Hdr	Technical Records configuration draft header table
5	CFG_PRG_AC_COMP_Batch_Dtl	Technical Records program offline process table
6	CFG_TechRec_OffLine_Dtl	Technical Records validation check table
7	CFG_TECH_PARAM_DTL	Technical Records metadata table
8	CFG_Tech_State_Dtl	Technical Records state table
9	cmp_cpddel_comp_prg_delhis_det	Technical Records program delete history table
10	mp_mpdft_maint_program_hdr	Technical Records program draft header table
11	TRD_MP_ErrorId_Des	Technical Records program error description table
12	TRD_Tab_visb_option	Technical Records tab visibility setting table

Table Name :	CFG_BP_AC_COMP_Batch_Dtl
Comment :	Technical Records Configuration offline process table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFG_DFT_OU	udd_ctxt_ouinstance	int(4)	No	The Organization unit at which user has logged in the system.	No
CFG_DFT_Guid	udd_guid	varchar(40)	No	This field holds the required Guid id.	No
CFG_DFT_Batch_Status	udd_status	varchar(25)	No	This field holds the batch status.	No
CFG_DFT_Build_Flag	udd_designparamcode	varchar(5)	No	This field holds the build flag.	No
CFG_DFT_Validate_Flag	udd_designparamcode	varchar(5)	No	This field holds the validate flag.	No
CFG_DFT_RowNo	udd_rowno	int(4)	No	This field holds the row number.	No
CFG_DFT_Aircraft	udd_aircraftnumber	varchar(30)	No	This field holds the aircraft number.	No
CFG_DFT_NHA_Component	udd_componentid	varchar(90)	No	This field holds the nha component number.	No
CFG_DFT_Ori_PositionCode	udd_positioncode	varchar(25)	No	This field holds the position code.	No
CFG_DFT_Level_No	udd_level	int(4)	No	This field holds the level number.	No
CFG_DFT_Level_Code	udd_cnfglvlcd	varchar(150)	No	This field holds the level code.	No
CFG_DFT_Config_Created_By	udd_ctxt_user	varchar(30)	No	This field holds the user details who created the draft record.	No
CFG_DFT_Config_Created_Date	udd_datetime	varchar(30)	No	This field holds the Date on which the draft record was created.	No
CFG_DFT_Config_Flag	udd_designparamcode	varchar(5)	No	This field holds the tracking Flag.	No
CFG_DFT_CR_Flag	udd_designparamcode	varchar(5)	No	This field holds the cr flag.	No
CFG_DFT_nhaPart	udd_partno	varchar(40)	No	This field holds the nha part number.	No
CFG_DFT_nhaserial	UDD_SERIALNO	varchar(40)	No	This field holds the nha serial number.	No

Table Name :	Cfg_Cr_Error_Id_Desc
Comment :	Technical Records Error description table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Cfg_Cr_Error_Id	varchar	Char(10)	Yes	This Field holds the CR error id.	No
Cfg_Cr_Error_Cat	udd_category	varchar(15)	Yes	This Field holds the CR error category.	No
Cfg_Cr_Error_Desc	udd_err_errordesc	varchar(4000)	Yes	This Field holds the CR error Description.	No

Table Name :	CFG_DFT_AC_COMP_Draft_DTL
Comment :	Technical Records Configuration Draft detail table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFG_DFT_OU	udd_ctxt_ouinstance	int(4)	Yes	The Organization unit at which user has logged in the system, and created the Draft Details.	No
CFG_DFT_Aircraft	udd_aircraftnumber	varchar(30)	Yes	This Field holds the Aircraft number for the corresponding draft details.	No
CFG_DFT_NHA_Component	udd_componentid	varchar(90)	Yes	This Field holds the NHA_component.	No
CFG_DFT_NHA_Part	udd_partno	varchar(40)	Yes	This Field holds the NHA_part.	No
CFG_DFT_NHA_Serial	udd_partserialnumber	varchar(40)	Yes	This Field holds the NHA_serial.	No
CFG_DFT_Ori_Position_Code	udd_positioncode	varchar(25)	Yes	This Field holds the Position_code.	No
CFG_DFT_NHA_EMPTY_POS	udd_partno	varchar(40)	Yes	This Field holds the EMPTY_pos.	No
CFG_DFT_Level_No	udd_level	int(4)	Yes	This Field holds the Level_no.	No
CFG_DFT_Level_Code	udd_cnfglvlcd	varchar(150)	Yes	This Field holds the Level_code.	No
CFG_DFT_ReNumber_Flag	udd_designparamcode	varchar(5)	Yes	This Field holds the ReNumber_flag.	No
CFG_DFT_Config_Change_Flag	udd_designparamcode	varchar(5)	Yes	This Field holds the Change_flag.	No
CFG_DFT_CR_Flag	udd_designparamcode	varchar(5)	Yes	This Field holds the CR_flag.	No
CFG_DFT_Error_Msg	_Varchar_6000	Varchar(6000)	Yes	This Field holds the Error_msg.	No
CFG_DFT_Display_Seq	_Int_4	Int(4)	Yes	This Field holds the Display_seq.	No
CFG_DFT_Position_Code	udd_positioncode	varchar(25)	Yes	This Field holds the Position code.	No
CFG_DFT_Position_Status	udd_status	varchar(25)	Yes	This Field holds the Position_status.	No
CFG_DFT_Ori_Position_Part	udd_partno	varchar(40)	Yes	This Field holds the Position_part.	No
CFG_DFT_Position_Part	udd_partno	varchar(40)	Yes	This Field holds the Position_part no.	No
CFG_DFT_Position_Part_Desc	udd_txt150	varchar(150)	Yes	This Field holds the Part_desc.	No
CFG_DFT_Position_Type	udd_designparamcode	varchar(5)	Yes	This Field holds the Position_type.	No
CFG_DFT_Comp_Mandatory	udd_designparamcode	varchar(5)	Yes	This Field holds the Comp_mandatory.	No
CFG_DFT_Zone	udd_workarea	varchar(15)	Yes	This Field holds the Zone.	No
CFG_DFT_ATA	udd_atanumber	varchar(16)	Yes	This Field holds the ATA.	No
CFG_DFT_Position_Formula	udd_formulaid	varchar(20)	Yes	This Field holds the Position_formula.	No
CFG_DFT_Template_Part	udd_partno	varchar(40)	Yes	This Field holds the Template_part.	No
CFG_DFT_Installed_Part	udd_partno	varchar(40)	Yes	This Field holds the Installed_part.	No
CFG_DFT_Installed_Serial	udd_partserialnumber	varchar(40)	Yes	This Field holds the Installed_serial.	No
CFG_DFT_Installed_MSN	udd_partserialnumber	varchar(40)	Yes	This Field holds the Installed_msn.	No
CFG_DFT_Installed_Component	udd_componentid	varchar(90)	Yes	This Field holds the Installed_component.	No
CFG_DFT_Replacement_DateTime	udd_datetime	varchar(30)	Yes	This Field holds the Replacement_datetime.	No
CFG_DFT_Induction_DateTime	datetime	Datetime(8)	Yes	This Field holds the Induction_datetime.	No
CFG_DFT_Mfr_DateTime	udd_datetime	varchar(30)	Yes	This Field holds the Mfr_datetime.	No
CFG_DFT_Installed_Condition	udd_designparamcode	varchar(5)	Yes	This Field holds the Installed_condition.	No
CFG_DFT_Attached_Status	udd_status	varchar(25)	Yes	This Field holds the Attached_status.	No
CFG_DFT_Removed_Condition	udd_designparamcode	varchar(5)	Yes	This Field holds the Removed_condition.	No
CFG_DFT_Removed_Type	udd_removaltype	varchar(25)	Yes	This Field holds the Removed_type.	No
CFG_DFT_Station	udd_flag	varchar(25)	Yes	This Field holds the Station.	No
CFG_DFT_Reason	udd_description	varchar(40)	Yes	This Field holds the Reason.	No
CFG_DFT_Recorded_By	udd_ctxt_user	varchar(30)	Yes	This Field holds the Recorded_by.	No
CFG_DFT_Ref_Document	udd_refdocno	varchar(40)	Yes	This Field holds the Ref_document.	No
CFG_DFT_Accept_Reference	udd_txt255	varchar(255)	Yes	This Field holds the Accept_reference.	No
CFG_DFT_TSN	udd_numericparamval	numeric(13)	Yes	This Field holds the Time sinc New.	No
CFG_DFT_CSN	udd_numericparamval	numeric(13)	Yes	This Field holds the Cycle Sinc New.	No
CFG_DFT_Drawing	udd_desc40	varchar(40)	Yes	This Field holds the Drawing.	No
CFG_DFT_FileName	udd_txt150	varchar(150)	Yes	This Field holds the FileName.	No
CFG_DFT_Remarks	udd_txt2000	varchar(2000)	Yes	This Field holds the Remarks.	No
CFG_DFT_Config_Created_By	udd_ctxt_user	varchar(30)	Yes	This Field holds the Created_by.	No
CFG_DFT_Config_Created_Date	udd_datetime	varchar(30)	Yes	This Field holds the Created_date.	No
CFG_DFT_Config_Modified_By	udd_ctxt_user	varchar(30)	Yes	This Field holds the Modified_by.	No
CFG_DFT_Config_Modified_Date	udd_datetime	varchar(30)	Yes	This Field holds the Modified_date.	No
CFG_DFT_Config_TimeStamp	udd_timestamp	int(4)	Yes	This Field holds the Config_timestamp.	No
CFG_DFT_replacement_type	UDD_TXT	varchar(40)	Yes	This Field holds the replacement_type.	No
CFG_DFT_removedby	ctxt_user	Char(30)	Yes	This Field holds the removedby.	No
CFG_DFT_Configstatus	udd_status	varchar(25)	Yes	This Field holds the Configstatus.	No
CFG_DFT_Config_Revision	udd_numrevno	int(4)	Yes	This Field holds the Config_revision.	No
CFG_DFT_Ownership	designparamcode	varchar(5)	Yes	This Field holds the Ownership.	No
CFG_DFT_Owningagency	udd_txt80	varchar(80)	Yes	This Field holds the Owningagency.	No
CFG_DFT_StockStatus	partstatus	Char(40)	Yes	This Field holds the StockStatus.	No
CFG_DFT_Certificate_Type	UDD_TXT	varchar(40)	Yes	This Field holds the Certificate_type.	No
CFG_DFT_Certificate_No	udd_refdocno	varchar(40)	Yes	This Field holds the Certificate_no.	No
CFG_DFT_Certificate_Date	udd_date2	varchar(11)	Yes	This Field holds the Certificate_date.	No
CFG_DFT_Interchang_Rule	designparamcode	varchar(5)	Yes	This Field holds the Interchang_rule.	No
CFG_DFT_Parent_Id	udd_txt2000	varchar(2000)	Yes	This Field holds the Parent_id.	No
CFG_DFT_Base_Part	udd_partno	varchar(40)	Yes	This Field holds the Base_part.	No
CFG_DFT_CR	udd_txt255	varchar(255)	Yes	This Field holds the CR.	No
CFG_DFT_Part_Category	udd_taxcat	varchar(25)	Yes	This Field holds the Part_category.	No
CFG_DFT_EIPN_Part	udd_partno	varchar(40)	Yes	This Field holds the end item part no_part.	No
CFG_DFT_EIPN_Serial	udd_partserialnumber	varchar(40)	Yes	This Field holds the end item part no_serial number.	No
CFG_DFT_EIPN_Comp	udd_componentid	varchar(90)	Yes	This Field holds the the end item part no_component no.	No
CFG_DFT_Parameter_Init	udd_designparamcode	varchar(5)	Yes	This Field holds the Parameter_init.	No
CFG_DFT_Cnfg_Flag	udd_designparamcode	varchar(5)	No	This Field holds the Configuration_flag.	No
CFG_DFT_Attached_Part	udd_partno	varchar(40)	Yes	This Field holds the Attached_part number.	No
CFG_DFT_Attached_serial	udd_partserialnumber	varchar(40)	Yes	This Field holds the Attached_serial number.	No

Table Name :	Cfg_DFT_AC_COMP_Draft_Hdr
Comment :	Technical Records configuration draft header table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFG_DFT_OU	udd_ctxt_ouinstance	int(4)	Yes	The Organization unit at which user has logged in the system.	No
CFG_DFT_Aircraft	udd_aircraftnumber	varchar(30)	Yes	This field holds the Aircraft number.	No
CFG_DFT_Component	udd_componentid	varchar(90)	Yes	This field holds the Component.	No
CFG_DFT_Config_Class	udd_configid	varchar(30)	Yes	This field holds the Class.	No
CFG_DFT_Config_Rule	udd_designparamcode	varchar(5)	Yes	This field holds the Rule.	No
CFG_DFT_Config_Created_By	udd_ctxt_user	varchar(30)	Yes	This field holds the user details by whom it was created.	No
CFG_DFT_Config_Created_Date	udd_datetime	varchar(30)	Yes	This field holds the created Date.	No
CFG_DFT_Config_Modified_By	udd_ctxt_user	varchar(30)	Yes	This field holds the user details by whom it was modified.	No
CFG_DFT_Config_Modified_Date	udd_datetime	varchar(30)	Yes	This field holds the Modified Date.	No
CFG_DFT_Config_TimeStamp	udd_timestamp	int(4)	Yes	This field holds the TimeStamp.	No

Table Name :	CFG_PRG_AC_COMP_Batch_Dtl
Comment :	Technical Records program offline process table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cfg_prg_ou	udd_ctxt_ouinstance	int(4)	Yes	The Organization unit at which user has logged in the system.	No
cfg_prg_guid	udd_guid	varchar(40)	Yes	This field holds the guid.	No
cfg_prg_batch_status	udd_status	varchar(25)	Yes	This field holds the batch_status.	No
cfg_prg_build_flag	udd_designparamcode	varchar(5)	Yes	This field holds the build_flag.	No
cfg_prg_validate_flag	udd_designparamcode	varchar(5)	Yes	This field holds the validate_flag.	No
cfg_prg_rowno	udd_rowno	int(4)	Yes	This field holds the rowno.	No
cfg_prg_aircraft	udd_aircraftnumber	varchar(30)	Yes	This field holds the aircraft number.	No
cfg_prg_component	udd_componentid	varchar(90)	Yes	This field holds the component number.	No
cfg_prg_program	udd_documentno	varchar(40)	Yes	This field holds the program.	No
cfg_prg_program_rev	udd_revisionno	varchar(40)	Yes	This field holds the program revision.	No

Table Name :	CFG_TechRec_OffLine_Dtl
Comment :	Technical Records validation check table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFG_BE_OU	udd_ctxt_ouinstance	int(4)	Yes	The Organization unit at which user has logged in the system.	No
CFG_BE_Tab	varchar	Char(10)	Yes	This Field holds the tab name.	No
CFG_BE_Task	udd_txt150	varchar(150)	Yes	This Field holds the task name.	No
CFG_BE_Count	int	int(4)	Yes	This Field holds the count.	No

Table Name :	CFG_TECH_PARAM_DTL
Comment :	Technical Records metadata table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFG_COMPONENTNAME	udd_compname	varchar(40)	No	This Field holds the componentname	Yes
CFG_PARAMCATEGORY	udd_paramcategory	varchar(10)	No	This Field holds the parameter category.	Yes
CFG_PARAMTYPE	udd_paramtype	varchar(25)	No	This Field holds the Parameter type.	Yes
CFG_PARAMCODE	udd_paramcode	varchar(30)	No	This Field holds the Parameter code.	Yes
CFG_PARAMDESC	udd_txt150	varchar(150)	Yes	This Field holds the Parameter description..	No
CFG_LANGID	udd_ctxt_language	int(4)	No	This Field holds the Language id.	Yes
CFG_SORTBY	udd_seqno	int(4)	Yes	This Field holds the Sort By Condition.	No
REPLICATION_KEY	uniqueidentifier	Varchar(160)	Yes	This Field holds the Replication key.	No

Table Name :	CFG_Tech_State_Dtl
Comment :	Technical Records state table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CFG_Tech_Source_comp	udd_ctxt_component	varchar(20)	Yes	This Field Holds the Source_comp.	No
CFG_Tech_Maint_object	udd_designparamcode	varchar(5)	Yes	This Field Holds the Main_object.	No
CFG_Tech_View_option	udd_designparamcode	varchar(5)	Yes	This Field Holds the View_option.	No
CFG_Tech_Tab_name	udd_activity_name	varchar(40)	Yes	This Field Holds the Tab__name.	No
CFG_Tech_Task_type	udd_designparamcode	varchar(5)	Yes	This Field Holds the Task_type.	No
CFG_Tech_SearchOption	udd_designparamcode	varchar(5)	Yes	This Field Holds the Search Option	No
CFG_Tech_State_id	UDD_TXT60	varchar(60)	Yes	This Field Holds the State_id.	No
CFG_Tech_Unique_id	bigint	Bigint(8)	No	This Field Holds the Unique_id.	Yes
CFG_Tech_Treeclk	udd_designparamcode	varchar(5)	Yes	This Field Holds the Tech_Tree_Treeclk.	No
CFG_Tech_Offline	udd_designparamcode	varchar(5)	Yes	This Field Holds the Tech_Offl_Offline.	No
CFG_Tech_Prgm_Avail	udd_designparamcode	varchar(5)	Yes	This Field Holds the Program Available.	No
CFG_Tech_Function	udd_designparamcode	varchar(5)	Yes	This Field Holds the Tech_Func_Function.	No
CFG_Tech_SrchCategory	udd_designparamcode	varchar(5)	Yes	This Field Holds the Search Category.	No

Table Name :	cmp_cpddel_comp_prg_delhis_det
Comment :	Technical Records program delete history table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cpddel_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	This Field holds the ouintance.	No
cpddel_component	udd_component	varchar(16)	Yes	This Field holds the component.	No
cpddel_program_revision_no	udd_count	int(4)	Yes	This Field holds the program revision no.	No
cpddel_workunit_line_no	udd_seqno	int(4)	Yes	This Field holds the workunit line no.	No
cpddel_maint_type	udd_designparamcode	varchar(5)	Yes	This Field holds the main type.	No
cpddel_workunit_type	udd_designparamcode	varchar(5)	Yes	This Field holds the work type.	No
cpddel_workunit	udd_taskcode	varchar(30)	Yes	This Field holds the workunit.	No
cpddel_workunit_revno	udd_revisionno	varchar(40)	Yes	This Field holds the work revno.	No
cpddel_workunit_ou	udd_ctxt_ouinstance	int(4)	Yes	This Field holds the workunit ou.	No
cpddel_execfacility	udd_designparamcode	varchar(5)	Yes	This Field holds the execfacility.	No
cpddel_workcenter	udd_wccode	varchar(30)	Yes	This Field holds the workcenter.	No
cpddel_workcenter_ou	udd_ctxt_ouinstance	int(4)	Yes	This Field holds the workcentre ou.	No
cpddel_timeunit	udd_designparamcode	varchar(5)	Yes	This Field holds the timeunit.	No
cpddel_turnaroundtime_disp	udd_numericparamval	numeric(13)	Yes	This Field holds the turn disp.	No
cpddel_turnaroundtime_min	udd_numericparamval	numeric(13)	Yes	This Field holds the turn min.	No
cpddel_est_duration_min	udd_numericparamval	numeric(13)	Yes	This Field holds the est duration min.	No
cpddel_est_duration_disp	udd_numericparamval	numeric(13)	Yes	This Field holds the est duration disp.	No
cpddel_onwing	udd_designparamcode	varchar(5)	Yes	This Field holds the onwing.	No
cpddel_refdoctype	udd_designparamcode	varchar(5)	Yes	This Field holds the refdoctype.	No
cpddel_refdocno	udd_documentno	varchar(40)	Yes	This Field holds the refdocno.	No
cpddel_refdoc_details	udd_txt2000	varchar(2000)	Yes	This Field holds the refd details.	No
cpddel_eo_refdoc_no	udd_documentno	varchar(40)	Yes	This Field holds the eo refdoc no.	No
cpddel_eo_refdoc_revno	udd_count	int(4)	Yes	This Field holds the eo refdoc revno.	No
cpddel_comments	udd_txt255	varchar(255)	Yes	This Field holds the comments.	No
cpddel_linkflag	udd_flag	varchar(25)	Yes	This Field holds the linkflag.	No
cpddel_last_performed_date	udd_time	datetime(8)	Yes	This Field holds the last performed date.	No
cpddel_workunit_status	udd_designparamcode	varchar(5)	Yes	This Field holds the work status.	No
cpddel_shelflife	udd_designparamcode	varchar(5)	Yes	This Field holds the shelflife.	No
cpddel_srcdoc_type	udd_designparamcode	varchar(5)	Yes	This Field holds the srcd type.	No
cpddel_defreqno	udd_documentno	varchar(40)	Yes	This Field holds the defreqno.	No
cpddel_defrl_source	udd_designparamcode	varchar(5)	Yes	This Field holds the defr source.	No
cpddel_defral_val	udd_numericparamval	numeric(13)	Yes	This Field holds the defr val.	No
cpddel_defral_date	udd_time	datetime(8)	Yes	This Field holds the defr date.	No
cpddel_expense_type	udd_designparamcode	varchar(5)	Yes	This Field holds the expe type.	No
cpddel_prg_group	udd_flag	varchar(25)	Yes	This Field holds the prg_ group.	No
cpddel_item_type	udd_designparamcode	varchar(5)	Yes	This Field holds the item type.	No
cpddel_initrst_by	udd_designparamcode	varchar(5)	Yes	This Field holds the init by.	No
cpddel_defexe_pri	udd_priorityno	int(4)	Yes	This Field holds the defe pri.	No
cpddel_modified_by	udd_ctxt_user	varchar(30)	Yes	This Field holds the modi by.	No
cpddel_modified_date	udd_time	datetime(8)	Yes	This Field holds the modi date.	No
cpddel_engdoctype	udd_quickcode	varchar(25)	Yes	This Field holds the engdoctype.	No
cpddel_sch_flag	udd_designparamcode	varchar(5)	Yes	This Field holds the sch_ flag.	No
cpddel_schexec_rule	udd_designparamcode	varchar(5)	Yes	This Field holds the sche rule.	No
cpddel_package_type	udd_doctype	varchar(40)	Yes	This Field holds the pack type.	No
created_area_code	udd_documentno	varchar(40)	Yes	This Field holds the area code.	No
cpddel_reset_on_attach	udd_designparamcode	varchar(5)	Yes	This Field holds the reset on attach.	No
cpddel_cmp_parent_seq_no	udd_count	int(4)	Yes	This Field holds the cmp parent seq no.	No

Table Name :	mp_mpdft_maint_program_hdr
Comment :	Technical Records program draft header table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
mpdft_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	This Field holds the ouinstance.	No
mpdft_program_no	udd_documentno	varchar(40)	Yes	This Field holds the program_no.	No
mpdft_revision_no	udd_count	int(4)	Yes	This Field holds the revision_no.	No
mpdft_description	udd_txt150	varchar(150)	Yes	This Field holds the description.	No
mpdft_description_up	udd_txt150	varchar(150)	Yes	This Field holds the description_up.	No
mpdft_primary_model	udd_model	varchar(20)	Yes	This Field holds the primary_model.	No
mpdft_model_ou	udd_ctxt_ouinstance	int(4)	Yes	This Field holds the model_ou.	No
mpdft_config_class	udd_documentno	varchar(40)	Yes	This Field holds the config_class.	No
mpdft_config_class_ou	udd_ctxt_ouinstance	int(4)	Yes	This Field holds the config_class_ou.	No
mpdft_status	udd_designparamcode	varchar(5)	Yes	This Field holds the status.	No
mpdft_category	udd_flag	varchar(25)	Yes	This Field holds the category.	No
mpdft_comments	udd_txt255	varchar(255)	Yes	This Field holds the comments.	No

Table Name :	TRD_MP_ErrorId_Des
Comment :	Technical Records program error description table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TRD_MP_Error_Id	udd_seqno	int(4)	Yes	This Field holds the Error_id.	No
TRD_MP_Error_Cat	udd_category	varchar(15)	Yes	This field holds the Error_Cat.	No
TRD_MP_Error_Desc	udd_err_errordesc	varchar(4000)	Yes	This Field holds the Error Description.	No

Table Name :	TRD_Tab_visb_option
Comment :	Technical Records tab visibility setting table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Trd_Customer	udd_documentno	varchar(40)	Yes	This Field holds the customer name.	No
Trd_Alltabvisb	udd_designparamcode	varchar(5)	Yes	This Field holds the all tab visibility.	No