Data Dictionary -- Component Maintenance Program

Srl. No.	Table Name	Comment
1	CMP_CDH_COMP_DB_HIST	Stores history of date-based schedules for the position code and the part number
2	CMP_CDSR_COMP_DB_SCH_REV	Component Program Date Based Schedules- Revision Details
3	CMP_CDS_COMP_DB_SCH	Component Program Date Based Schedules
4	CMP_CMPQC_CMP_QUICK_CODE	User Defined Quick Codes details are get stored in this table
5	Cmp_Comp_option_set	Component compilance option informations is getting stored in this table
6	CMP_CPDR_COMP_PRG_DETAIL_REV	Compoennt Program Work Unit Details - Revision Details
7	CMP_CPD_COMP_PRG_DETAIL	Compoennt Program Work Unit Details infomation are get stored here
8	CMP_CPER_COMP_PART_EST_REV	Component Program Part Estimates- Revision Details
9	CMP_CPE_COMP_PART_EST	Component Program Part Estimatation details stored here
10	CMP_CPHR_COMP_PRG_HDR_REV	Component Program Header - Revision Details. This object consists of Revised Status Details
11	CMP_CPH_COMP_PRG_HDR	Component Program Header - Fresh and Authorised Status stored
12	CMP_CRER_COMP_RES_EST_REV	Component Program Resource (Skill, Facility) Estimates- Revision Details
13	CMP_CRE_COMP_RES_EST	Component Program Resource (Skill, Facility) Estimates
14	CMP_CUH_COMP_UB_HIST	Component program usage based schedule detais - History
15	CMP_CUSR_COMP_UB_SCH_REV	Component Program Usage Base Schedule Information- Revision Details
16	CMP_CUS_COMP_UB_SCH	Component Program Usage Base Schedule Information
17	CMP_MPD_MAINT_PROCESS_DET	Maintenance Process Details information
18	CMP_PARAMETER_DETAILS	The meta data for the objects in the component maintanance program get maintained in this table
19	CMP_PDBS_PART_DB_SCH	Operational details of theparts on date based schedule were getting stored in this table
20	CMP_PDSD_POS_DB_SCH_DET	Operational details of the part postions on date based schedule were getting stored in this table
21	CMP_PDSH_POS_SCH_HDR	Part Position Date Based Schedules header details are get stored here
22	CMP_PDSR_PART_DB_SCH_REV	Part Program Date based Schedule details - Revision details
23	CMP_PMER_PART_MATERIAL_EST_REV	The estimation of the materials needed are stored here-revision details
24	CMP_PME_PART_MATERIAL_EST	The estimation of the materials needed are stored here
25	CMP_PPDR_PART_PRG_DET_REV	The Part program details - Revision details are get stored
26	CMP_PPD_PART_PRG_DET	Part Program Workunit Details
27	CMP_PPHR_PART_PRG_HDR_REV	Part Program Header - Revision details
28	CMP_PPH_PART_PRG_HDR	Part Program Header details
29	CMP_PRER_PART_RES_EST_REV	Resource estimate - revision details
30	CMP_PRE_PART_RES_EST	Part Program Resource (Skill, Facility) Estiamtations are get stored here
31	CMP_PUBS_PART_UB_SCH	Part Program Usage Base Schedule Information are get store here
32	CMP_PUSD_POS_USAGE_SCH_DET	Position based schedule Information are get stored here
33	CMP_PUSR_PART_UB_SCH_REV	Part Program Usage Base Schedule Information - Revision details
34	CMP_Record_status_Logtable	Component program Status log info is stored here
35	CMP_RWI_RESTORATION_WU_INFO	Part Restoration Work unit Details
36	CMP_UPDS_UPD_DB_SCH	Component program date based schedule
37	CMP_UPUS_UPD_UB_SCH	Component program usage based schedule
38	CMP_UWIP_UPDATE_WU_IN_PRG	Update Work Unit information In Programs
39	CMP_UWPD_UPDATE_WU_PART_DET	Update Work Unit Part Details

Table Name :	CMP_CDH_COMP_DB_HIST
Comment :	Stores history of date-based schedules for the position code and the part number

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CDH_OUINSTANCE	_numeric_28_0	numeric(28)	Yes	Ouinstance	No
CDH_COMPONENT	_varchar_90	varchar(90)	Yes	The number identifying the component for which the maintenance program details are to be updated.	No
CDH_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	Yes	The revision number of the component maintenance program. This number represents the number of changes the component maintenance program has undergone. This gets displayed on screen launch itself, but if authorized CMP is modified, then new revision	No
CDH_WORKUNIT_LINENO	_numeric_28_0	numeric(28)	Yes	The line of The task, standard procedure or work package, to be performed as part of the maintenance work.	No
CDH_SCH_LINENO	_numeric_28_0	numeric(28)	Yes	Line of the schedule onle line no for a parameter	No
CDH_SCH_TYPE	_varchar_5	varchar(5)	Yes	Date base Or useage based	No
CDH_LAST_PERFORMED_DATE	_datetime_8	datetime(8)	Yes	The date on which the work unit was last performed on the component	No
CDH_NEXT_SCHEDULED_DATE	_datetime_8	datetime(8)	Yes	The date on which the next work unit is due for the component	No
CDH_TIMEUNIT	_varchar_5	varchar(5)	Yes	the unit of measurement for the time that is being specified, which could be one of the following: Hours,Minutes, or Days.	No
CDH_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The value of the parameter when the schedule will start	No
CDH_INTERVAL	_decimal_28_8	decimal(28)	Yes	The interval in which the work unit is to be repeated	No
CDH_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	The value of the parameter before the next arising when an alert needs to be given for the impending work unit execution	No
CDH_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The upper limit within which the work unit is to be performed	No
CDH_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The lower limit within which the work unit is to be performed	No
CDH_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	The value after which maintenance requirement terminates. In other words, the number of days after which maintenance activity need not be performed on the component	No
CDH_TERMINATING_DATE	_datetime_8	datetime(8)	Yes	The date on or after which the maintenance requirements terminates. In other words, the date on or after which maintenance activity need not be performed on the component	No
CDH_UPD_BASIS	_varchar_5	varchar(5)	Yes	The basis of updating the work units of the maintenance program	No
CDH_ATTACHMENT_DATE	_datetime_8	datetime(8)	Yes	The date on which the component was attached on the aircraft.	No
CDH_UPD_DOCUMENT_NO	_varchar_40	varchar(40)	Yes	Document No defined in the "Create Reference Document Type" activity of the "Common Master"	No
CDH_UPD_DOCUMENT_TYPE	_varchar_25	Varchar(25)	Yes	Document Types defined in the "Create Reference Document Type" activity of the "Common Master"	No
CDH_UPDATED_DATE	_datetime_8	datetime(8)	Yes	Date on which program is updated	No
CDH_REMARKS	txt2000	varchar(2000)	Yes	Remarks	No
cdh_remarksid	udd_guid	varchar(40)	No	Remarks id	No
replication_key	_bigint_8	Bigint(8)	No	Replication key	Yes
created_area_code	_varchar_40	varchar(40)	No	Area code	No
CDH_PBS_flag	udd_designparamcode	varchar(5)	No	PBS Flag	No

Table Name :	CMP_CDSR_COMP_DB_SCH_REV
Comment :	Component Program Date Based Schedules- Revision Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CDSR_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CDSR_COMPONENT	_varchar_90	varchar(90)	No	Component No	Yes
CDSR_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CDSR_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Component Program Work units Serial No. This would be internally generated no	Yes
CDSR_SCH_LINENO	_decimal_38_0	decimal(38)	No	Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno	Yes
CDSR_SCH_TYPE	_varchar_5	varchar(5)	No	Scehdule Type RC - Recurring OT - One Time	No
CDSR_LAST_PERFORMED_DATE	_datetime_8	datetime(8)	Yes	Last Performed Date	No
CDSR_NEXT_SCHEDULED_DATE	_datetime_8	datetime(8)	Yes	Scheduled Date	No
CDSR_TIMEUNIT	_varchar_5	varchar(5)	Yes	Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years"	No
CDSR_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
CDSR_INTERVAL	_decimal_28_8	decimal(28)	Yes	date based schedule interval	No
CDSR_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
CDSR_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
CDSR_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed	No
CDSR_TERMIN_VALUE	_decimal_28_8	decimal(28)	Yes	The value after which the maintenance activity cannot be performed on the component	No
CDSR_TERMIN_DATE	_datetime_8	datetime(8)	Yes	The date after which the maintenance activity cannot be performed on the component	No
CDSR_UPD_BASIS	_varchar_5	varchar(5)	Yes	Updation Basis : ID - Installation Date LD - Last performed Date	No
CDSR_REMARKS	txt2000	varchar(2000)	Yes	Remarks	No
CDSR_REMARKSID	udd_guid	varchar(40)	Yes	Remark id	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_CDS_COMP_DB_SCH
Comment :	Component Program Date Based Schedules

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CDS_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CDS_COMPONENT	_varchar_90	varchar(90)	No	Component No	Yes
CDS_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Component program Revision No. Initial value would be Zero.	Yes
CDS_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Component Program Work units Serial No. This would be internally generated no	Yes
CDS_SCH_LINENO	_decimal_38_0	decimal(38)	No	Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno	Yes
CDS_SCH_TYPE	_varchar_5	varchar(5)	No	Scehdule Type RC - "Recurring" OT - "OneTime"	No
CDS_LAST_PERFORMED_DATE	_datetime_8	datetime(8)	Yes	The date on which the work unit was last performed on the component	No
CDS_NEXT_SCHEDULED_DATE	_datetime_8	datetime(8)	Yes	The date on which the next work unit is due for the component	No
CDS_TIMEUNIT	_varchar_5	varchar(5)	Yes	the unit of measurement for the time that is being specified, which could be one of the following: Hours,Minutes, or Days.	No
CDS_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The value of the parameter when the schedule will start	No
CDS_INTERVAL	_decimal_28_8	decimal(28)	Yes	The interval in which the work unit is to be repeated	No
CDS_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	The value of the parameter before the next arising when an alert needs to be given for the impending work unit execution	No
CDS_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The upper limit within which the work unit is to be performed	No
CDS_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The lower limit within which the work unit is to be performed	No
CDS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	The value after which maintenance requirement terminates. In other words, the number of days after which maintenance activity need not be performed on the component	No
CDS_TERMINATING_DATE	_datetime_8	datetime(8)	Yes	The date on or after which the maintenance requirements terminates. In other words, the date on or after which maintenance activity need not be performed on the component	No
CDS_UPD_BASIS	_varchar_5	varchar(5)	Yes	Updation Basis: LD - Last performed Date ID - Installation Date.	No
CDS_ATTACHMENT_DATE	_datetime_8	datetime(8)	Yes	The date on which the component was attached on the aircraft	No
CDS_REMARKS	txt2000	varchar(2000)	Yes	Remarks	No
CDS_REMARKSID	udd_guid	varchar(40)	Yes	Remark id	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No
CDS_PBS_flag	udd_designparamcode	varchar(5)	Yes	PbsFlag	No
cds_nsd_comp_ref_basis	udd_flag	varchar(25)	Yes	On what basis NSD got computed {Induction Date, Operation Date, Time Window, Schedule, RTC}	No
cds_nsd_comp_ref_date	datetime	Datetime(8)	Yes	Reference date with which NSD computed	No
cds_org_schedule_date	datetime	Datetime(8)	Yes	NSD prior to last compliance	No
cds_prev_defer_sch_option	_udd_flag_25	udd_flag(25)	Yes	Deferment option set	No
cds_nsd_upd_flag	_udd_flag_25	udd_flag(25)	Yes	NSD is Corrected or Baselined	No
cds_lpd_upd_flag	_udd_flag_25	udd_flag(25)	Yes	LPD is Corrected or Baselined	No
cds_lpd_upd_source	_udd_flag_25	udd_flag(25)	Yes	Screen code from which LPD modified	No
cds_nsd_upd_source	_udd_flag_25	udd_flag(25)	Yes	Screen code from which NSD modified	No
cds_change_type	_udd_flag_25	udd_flag(25)	Yes	User selected change type at the time of NSD / LPD modification	No
cds_instance_no	_udd_flag_25	udd_flag(25)	Yes	Instance No	No
cds_nsd_instance_id	udd_guid	varchar(40)	Yes	Guid	No
cds_lpd_instance_id	udd_guid	varchar(40)	Yes	Unique Guid	No

Table Name :	CMP_CMPQC_CMP_QUICK_CODE
Comment :	User Defined Quick Codes details are get stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMPQC_OUINSTANCE	_decimal_38_0	decimal(38)	No	OUinstance	Yes
CMPQC_QUICK_CODE	_varchar_25	Varchar(25)	No	User Defined Quick Code	Yes
CMPQC_TYPE	_varchar_5	varchar(5)	No	Quick Code Type.	Yes
CMPQC_DESCRIPTION	_varchar_80	varchar(80)	No	Quick Code description	No
CMPQC_STATUS	_varchar_5	varchar(5)	No	Status of the quick code. Can be A - Active or I - Inactive	No
CMPQC_CREATED_BY	_varchar_30	varchar(30)	No	Created by user id	No
CMPQC_MODIFIED_BY	_varchar_30	varchar(30)	No	Last Modified By user id	No
CMPQC_CREATIONDATE	_datetime_8	datetime(8)	No	Creation Date time	No
CMPQC_MODIFIEDDATE	_datetime_8	datetime(8)	No	Last Modified date time	No
CMPQC_TIMESTAMP	_decimal_38_0	decimal(38)	No	Timestamp of the current record	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	Cmp_Comp_option_set
Comment :	Component compilance option informations is getting stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Comp_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	ouinstance	No
Comp_UPDBASIS	udd_designparamcode	varchar(5)	Yes	Update basis	No
Comp_TIMESTAMP	udd_timestampint	int(4)	Yes	Time stamp	No
Comp_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	Created by the user	No
Comp_CREATED_DATE	udd_datetime1	datetime(8)	Yes	created date	No
Comp_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Modified By User	No
Comp_MODIFIED_DATE	udd_datetime1	datetime(8)	Yes	Modified date	No
COMP_PLNGRPSEC	udd_designparamcode	varchar(5)	Yes	Plan group details get stored here	No
comp_poschg	udd_designparamcode	varchar(5)	Yes	componnet position detais	No
replication_key	_bigint_8	Bigint(8)	No	Replication key	Yes
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_CPDR_COMP_PRG_DETAIL_REV
Comment :	Compoennt Program Work Unit Details - Revision Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPDR_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CPDR_COMPONENT	_varchar_90	varchar(90)	No	Component Program Component No	Yes
CPDR_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CPDR_WORKUNIT_LINE_NO	_decimal_38_0	decimal(38)	No	Component Program Work units Serial No. This would be internally generated no	Yes
CPDR_MAINT_TYPE	_varchar_5	varchar(5)	Yes	"Maintenance Type" defined under maintenance type in the common masters. "Overhaul" "Repair" "Inspection" "Others"	No
CPDR_WORKUNIT_TYPE	_varchar_5	varchar(5)	Yes	Work unit type values T - "Task" S - "Std Procedure" W - "Work Package"	No
CPDR_WORKUNIT	_varchar_30	varchar(30)	Yes	Work Unit , It could be Task, Stored Procedure or Work package	No
CPDR_WORKUNIT_REVNO	_varchar_40	varchar(40)	Yes	Work unit revision number	No
CPDR_WORKUNIT_OU	_decimal_38_0	decimal(38)	Yes	Work Unit OU Instance - Used to fetch the description	No
CPDR_EXECFACILITY	_varchar_5	varchar(5)	Yes	"Execution Facility" IH - "In-House" OS - "Outsource"	No
CPDR_WORKCENTER	_varchar_30	varchar(30)	Yes	work center codes in "Active" status defined in the work center components with which this component is interacting And the work units have an associated work center # that is currently not in "Active" status	No
CPDR_WORKCENTER_OU	_decimal_38_0	decimal(38)	Yes	Work Center OU	No
CPDR_TIMEUNIT	_varchar_5	varchar(5)	Yes	Time Unit for Estimated Duration H - Hource D- Days M - Minutes	No
CPDR_TURNAROUNDTIME_DISP	_decimal_28_8	decimal(28)	Yes	Turn around time in Display time unit	No
CPDR_TURNAROUNDTIME_MIN	_decimal_28_8	decimal(28)	Yes	Turn Around time in Min	No
CPDR_EST_DURATION_MIN	_decimal_28_8	decimal(28)	Yes	Estimated Duration in Min	No
CPDR_EST_DURATION_DISP	_decimal_28_8	decimal(28)	Yes	Estimated duration in Display timeunit	No
CPDR_ONWING	_varchar_5	varchar(5)	Yes	On Wing Y/N Y - Yes N - No	No
CPDR_REFDOCTYPE	_varchar_25	Varchar(25)	Yes	Ref Document Type - Values defined in the common master of RefDoctype	No
CPDR_REFDOCNO	udd_documentno	varchar(40)	Yes	Reference Document No	No
CPDR_REFDOC_DETAILS	_varchar_255	varchar(255)	Yes	Reference Document OU	No
CPDR_EO_REFDOC_NO	_varchar_40	varchar(40)	Yes	EO Reference Document No	No
CPDR_EO_REFDOC_REVNO	_varchar_40	varchar(40)	Yes	EO Ref Document Revision No	No
CPDR_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CPDR_LINKFLAG	_varchar_25	Varchar(25)	Yes	Link Flag P, R, PR, PS , PRS	No
CPDR_LAST_PERFORMED_DATE	_datetime_8	datetime(8)	Yes	Last Performed Date	No
CPDR_WORKUNIT_STATUS	_varchar_5	varchar(5)	Yes	Work unit status	No
CPDR_SHELFLIFE	_varchar_5	varchar(5)	Yes	The value after which the component cant be used in the MP	No
CPDR_SRCDOC_TYPE	_varchar_5	varchar(5)	Yes	Source Document type MR - Maint Report EO - Engineering Order	No
CPDR_Expense_Type	_varchar_5	varchar(5)	Yes	Capital, Revenue	No
CPDR_PRG_GROUP	udd_flag	varchar(25)	Yes	Progarm group	No
CPDR_ITEM_TYPE	udd_designparamcode	varchar(5)	Yes	Item type	No
CPDR_INITRST_BY	udd_designparamcode	varchar(5)	Yes	Can be of self compliance or RTC	No
CPDR_DEFEXE_PRI	udd_priorityno	int(4)	Yes	Default execution priority	No
CPDR_ENGDOCTYPE	udd_quickcode	varchar(25)	Yes	Eng document type	No
cpdr_modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
cpdr_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
CPDR_PACKAGE_TYPE	udd_doctype	varchar(40)	Yes	Package type	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_CPD_COMP_PRG_DETAIL
Comment :	Compoennt Program Work Unit Details infomation are get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPD_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CPD_COMPONENT	_varchar_90	varchar(90)	No	Component Program Component No	Yes
CPD_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CPD_WORKUNIT_LINE_NO	_decimal_38_0	decimal(38)	No	Component Program Work units Serial No. This would be internally generated no	Yes
CPD_MAINT_TYPE	_varchar_5	varchar(5)	Yes	Maintenance Type defined under maintenance type in the common masters. "Overhaul" "Repair" "Inspection" "Others"	No
CPD_WORKUNIT_TYPE	_varchar_5	varchar(5)	No	work unit type values T - "Task" S - "Std Procedure" W - "Work Package"	No
CPD_WORKUNIT	_varchar_30	varchar(30)	No	Work Unit , It could be Task, Stored Procedure or Work package	No
CPD_WORKUNIT_REVNO	_varchar_40	varchar(40)	Yes	Work Unit Revision No	No
CPD_WORKUNIT_OU	_decimal_38_0	decimal(38)	Yes	Work Unit OU Instance - Used to fetch the description	No
CPD_EXECFACILITY	_varchar_5	varchar(5)	Yes	"Execution Facility" IH - "In-House" OS - "Outsource"	No
CPD_WORKCENTER	_varchar_30	varchar(30)	Yes	work center codes in "Active" status defined in the work center components with which this component is interacting And the work units have an associated work center # that is currently not in "Active" status	No
CPD_WORKCENTER_OU	_decimal_38_0	decimal(38)	Yes	Work Center OU	No
CPD_TIMEUNIT	_varchar_5	varchar(5)	Yes	Time Unit for Estimated Duration H - Hource D- Days M - Minutes	No
CPD_TURNAROUNDTIME_DISP	_decimal_28_8	decimal(28)	Yes	Turn Around time in Min	No
CPD_TURNAROUNDTIME_MIN	_decimal_28_8	decimal(28)	Yes	turnaround time	No
CPD_EST_DURATION_MIN	_decimal_28_8	decimal(28)	Yes	Estimated Duration in Min	No
CPD_EST_DURATION_DISP	_decimal_28_8	decimal(28)	Yes	Estimated Duration in Displat time unit	No
CPD_ONWING	_varchar_5	varchar(5)	Yes	On Wing Y/N Y - Yes N - No	No
CPD_REFDOCTYPE	_varchar_25	Varchar(25)	Yes	Ref Document Type - Values defined in the common master of RefDoctype	No
CPD_REFDOCNO	_varchar_40	varchar(40)	Yes	Reference Document No	No
CPD_REFDOC_DETAILS	_varchar_255	varchar(255)	Yes	Reference Document Details - User Entered Value	No
CPD_EO_REFDOC_NO	_varchar_40	varchar(40)	Yes	EO reference Document No	No
CPD_EO_REFDOC_REVNO	_varchar_40	varchar(40)	Yes	EO Ref Docu Revision No	No
CPD_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CPD_LINKFLAG	_varchar_25	Varchar(25)	Yes	Link Flag P- Part Estimated , R -Resources Estimated, PR - Part and Resources Estimated, PS - Part Estimated and Schedule Defined PRS - Part , Resource Estimated and Schedule Defined	No
CPD_LAST_PERFORMED_DATE	_datetime_8	datetime(8)	Yes	Last Performed Date	No
CPD_WORKUNIT_STATUS	_varchar_5	varchar(5)	Yes	Work Unit Status A- Active I - Inactive	No
CPD_SHELFLIFE	_varchar_5	varchar(5)	Yes	The value after which the MP cant be used for the component	No
CPD_SRCDOC_TYPE	_varchar_5	varchar(5)	Yes	Source Document type EO - Engineering Order MR - Maint Report	No
CPD_DEFREQNO	_varchar_40	varchar(40)	Yes	Deferal Sequence no	No
CPD_DEFRL_SOURCE	_varchar_40	varchar(40)	Yes	Defaral Source DP, Maintance Report	No
CPD_DEFRAL_VAL	_decimal_28_8	decimal(28)	Yes	Defaral Value	No
CPD_DEFRAL_DATE	_datetime_8	datetime(8)	Yes	Defarl Date	No
CPD_Expense_Type	_varchar_5	varchar(5)	Yes	Can be of Capital, Revenue	No
CPD_PRG_GROUP	udd_flag	varchar(25)	Yes	program group based of component requirements	No
CPD_ITEM_TYPE	udd_designparamcode	varchar(5)	Yes	Item type	No
CPD_INITRST_BY	udd_designparamcode	varchar(5)	Yes	Can be of self compliance or RTC	No
CPD_DEFEXE_PRI	udd_priorityno	int(4)	Yes	Default execution priority	No
CPD_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Modified By User	No
CPD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified date	No
CPD_ENGDOCTYPE	udd_quickcode	varchar(25)	Yes	Eng document type	No
cpd_sch_flag	udd_designparamcode	varchar(5)	Yes	Schedule flag	No
CPD_PACKAGE_TYPE	_Varchar_40	varchar(40)	Yes	Pakage Type	No
cpd_Schexec_rule	_Varchar_5	varchar(5)	Yes	schedule Excution Rule Earlier/Latest	No
created_area_code	_Varchar_40	varchar(40)	Yes	Area code	No
cmp_parent_seq_no	udd_count	int(4)	No	For an RTC task, stores the parent task seq #	No

Table Name :	CMP_CPER_COMP_PART_EST_REV
Comment :	Component Program Part Estimates- Revision Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPER_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CPER_COMPONENT	_varchar_90	varchar(90)	No	Component Program Component No	Yes
CPER_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CPER_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Component Program Work units Serial No. This would be internally generated no	Yes
CPER_PART_LINENO	_decimal_38_0	decimal(38)	No	Estimated Part Line No - Running serial no for a given Part, Progrm ou	Yes
CPER_EST_PART	_varchar_40	varchar(40)	No	Estimated Part No	No
CPER_EST_PART_CREATEDOU	_decimal_38_0	decimal(38)	No	Estimated part Created OU - Used to fetch the Description	No
CPER_REQUIRED_QTY	_decimal_28_8	decimal(28)	Yes	Part Required Qty	No
CPER_UOM	_varchar_10	varchar(10)	Yes	Required Qty UOM	No
CPER_WAREHOUSE	_varchar_10	varchar(10)	Yes	Estimated Part Warehouse	No
CPER_WAREHOUSEOU	_decimal_38_0	decimal(38)	Yes	Warehouse OU	No
CPER_PARTCOST	_decimal_28_8	decimal(28)	Yes	Part Cost	No
CPER_REQ_QTY_IN_STOCK_UOM	_decimal_28_8	decimal(28)	Yes	required quantity in stock uom	No
created_area_code	_varchar_40	varchar(40)	No	Area code	No

Table Name :	CMP_CPE_COMP_PART_EST
Comment :	Component Program Part Estimatation details stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPE_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CPE_COMPONENT	_varchar_90	varchar(90)	No	Component No	Yes
CPE_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CPE_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Component Program Work units Serial No. This would be internally generated no	Yes
CPE_PART_LINENO	_decimal_38_0	decimal(38)	No	Estimated Part Line No - Running serial no for a given Part, Progrm ou	Yes
CPE_EST_PART	_varchar_40	varchar(40)	No	Estimated Part No	No
CPE_EST_PART_CREATEDOU	_decimal_38_0	decimal(38)	No	Estimated part Created OU - Used to fetch the Description	No
CPE_REQUIRED_QTY	_decimal_28_8	decimal(28)	Yes	Part Required Qty	No
CPE_UOM	_varchar_10	varchar(10)	Yes	Required Qty UOM	No
CPE_WAREHOUSE	_varchar_10	varchar(10)	Yes	Estimated Part Warehouse	No
CPE_WAREHOUSE_OU	_decimal_38_0	decimal(38)	Yes	Warehouse OU	No
CPE_PARTCOST	_decimal_28_8	decimal(28)	Yes	Part Cost	No
CPE_REQ_QTY_IN_STOCK_UOM	_decimal_28_8	decimal(28)	Yes	required quantity in stock uom	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_CPHR_COMP_PRG_HDR_REV
Comment :	Component Program Header - Revision Details. This object consists of Revised Status Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPHR_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CPHR_COMPONENT	_varchar_90	varchar(90)	No	Component No	Yes
CPHR_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CPHR_PART_NO	_varchar_40	varchar(40)	No	Part No	Yes
CPHR_SERIALNO	_varchar_40	varchar(40)	No	Serial No	Yes
CPHR_CREATED_PART_OU	_decimal_38_0	decimal(38)	Yes	Created part OU used to fetch the description	No
CPHR_PROGRAM_STATUS	_varchar_5	varchar(5)	Yes	Program Status R- Revised F- Fresh A- Authorised	No
CPHR_PROGRAM_USER_STATUS	_varchar_25	Varchar(25)	Yes	User Status - Quick Code	No
CPHR_REMARKS	_varchar_255	varchar(255)	Yes	Part program Remarks	No
CPHR_PARENT_REMOVAL	_varchar_5	varchar(5)	Yes	Parent Removal Required Y - Yes N - No	No
CPHR_PARENT_PARTNO	_varchar_40	varchar(40)	Yes	Parent Part No to be Removed	No
CPHR_CREATION_DATE	_datetime_8	datetime(8)	Yes	Record Creation date	No
CPHR_CREATED_BY	_varchar_30	varchar(30)	Yes	Record Created by User Id	No
CPHR_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Record last modification date	No
CPHR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Record Last modified By	No
CPHR_AUTHORIZED_BY	_varchar_30	varchar(30)	Yes	Authorised By - Login name	No
CPHR_AUTHORIZATION_DATE	_datetime_8	datetime(8)	Yes	Authorization date	No
CPHR_TIMESTAMP	_decimal_38_0	decimal(38)	No	Record Timestamp	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_CPH_COMP_PRG_HDR
Comment :	Component Program Header - Fresh and Authorised Status stored

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPH_OUINSTANCE	_decimal_10_0	decimal(10)	No	Part Program OU	Yes
CPH_COMPONENT	_varchar_90	varchar(90)	No	Component No	Yes
CPH_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CPH_CREATED_COMPID_OU	_decimal_10_0	decimal(10)	Yes	Component Created OU used to fetch component details	No
CPH_LATEST_FLAG	_varchar_5	varchar(5)	Yes	Latest Revision Flag Y - Yes, N - No	No
CPH_PART_NO	_varchar_40	varchar(40)	No	Part No	Yes
CPH_SERIALNO	_varchar_40	varchar(40)	No	Serial No	Yes
CPH_CREATED_PART_OU	_decimal_10_0	decimal(10)	Yes	Created part OU used to fetch the description	No
CPH_PROGRAM_STATUS	_varchar_5	varchar(5)	Yes	Program Status F - Fresh A - Authorized R - Revised	No
CPH_PROGRAM_USER_STATUS	_varchar_25	Varchar(25)	Yes	User Status - Quick Code	No
CPH_REMARKS	_varchar_255	varchar(255)	Yes	Part program Remarks	No
CPH_PARENT_REMOVAL	_varchar_5	varchar(5)	Yes	Parent Removal Required Y - Yes N - No	No
CPH_PARENT_PARTNO	_varchar_40	varchar(40)	Yes	Parent Part No to be Removed	No
CPH_CREATION_DATE	_datetime_8	datetime(8)	No	Record Creation date	No
CPH_CREATED_BY	_varchar_30	varchar(30)	No	Record Created by User Id	No
CPH_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Record last modification date	No
CPH_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Record Last modified By	No
CPH_AUTHORIZED_BY	_varchar_30	varchar(30)	Yes	Authorized By - login name	No
CPH_AUTHORIZATION_DATE	_datetime_8	datetime(8)	Yes	Authorization date	No
CPH_TIMESTAMP	_decimal_38_0	decimal(38)	No	Record Timestamp	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_CRER_COMP_RES_EST_REV
Comment :	Component Program Resource (Skill, Facility) Estimates- Revision Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CRER_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CRER_COMPONENT	_varchar_90	varchar(90)	No	Component No	Yes
CRER_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CRER_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Component Program Work units Serial No. This would be internally generated no	Yes
CRER_RESOURCE_LINENO	_decimal_38_0	decimal(38)	No	Resource Line No	Yes
CRER_RESOURCENO	_varchar_40	varchar(40)	No	Resource No	No
CRER_RESTYPE	_varchar_5	varchar(5)	No	Resource Type F- Facility S - Skills T - Tools E - Equipment O - Others	No
CRER_RESOURCE_OU	_decimal_38_0	decimal(38)	No	Resource OU instance	No
CRER_TIMEUNIT	_varchar_5	varchar(5)	No	Time unit D - Days H _ hours M _ Mins	No
CRER_REQDURATION_DISPLAY	_decimal_28_8	decimal(28)	Yes	Required Duration in Display Time unit	No
CRER_REQDURATION_MIN	_decimal_28_8	decimal(28)	Yes	Required Duration in Min	No
CRER_REQUIRED_QTY	_decimal_28_8	decimal(28)	Yes	Required Qty	No
CRER_SIGNOFF	_varchar_5	varchar(5)	Yes	Sign off Required Y/N Y - Yes N - No Applicable for Skill Resource only. In case of Facilities, Always it is N	No
CRER_RESOURCE_COST	_decimal_28_8	decimal(28)	Yes	Resource Cost	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_CRE_COMP_RES_EST
Comment :	Component Program Resource (Skill, Facility) Estimates

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CRE_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CRE_COMPONENT	_varchar_90	varchar(90)	No	Component No	Yes
CRE_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CRE_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Component Program Work units Serial No. This would be internally generated no	Yes
CRE_RESOURCE_LINENO	_decimal_38_0	decimal(38)	No	Resource Line No	Yes
CRE_RESOURCENO	_varchar_40	varchar(40)	No	Resource No	No
CRE_RESTYPE	_varchar_5	varchar(5)	No	Resource Type F- Facility S - Skill T - Tools E - Equipments O - Others	No
CRE_RESOURCE_OU	_decimal_38_0	decimal(38)	No	Resource OU instance	No
CRE_TIMEUNIT	_varchar_5	varchar(5)	No	Time unit D - Days H _ hours M _ Mins	No
CRE_REQDURATION_DISPLAY	_decimal_28_8	decimal(28)	Yes	Required Duration in Display Time unit	No
CRE_REQDURATION_MIN	_decimal_28_8	decimal(28)	Yes	Required Duration in Min	No
CRE_REQUIRED_QTY	_decimal_28_8	decimal(28)	Yes	Required Qty	No
CRE_SIGNOFF	_varchar_5	varchar(5)	Yes	Sign off Required Y/N Y - Yes N - No Applicable for Skill Resource only. In case of Facilities, Always it is N	No
CRE_RESOURCE_COST	_decimal_28_8	decimal(28)	Yes	Resource Cost	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_CUH_COMP_UB_HIST
Comment :	Component program usage based schedule detais - History

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CUH_OUINSTANCE	_numeric_28_0	numeric(28)	Yes	ouinstance	No
CUH_COMPONENT	_varchar_90	varchar(90)	Yes	component id	No
CUH_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	Yes	Program revision no	No
CUH_WORKUNIT_LINENO	_numeric_28_0	numeric(28)	Yes	task line no	No
CUH_SCH_LINENO	_numeric_28_0	numeric(28)	Yes	Schedule line no	No
CUH_PARAMETER	_varchar_40	varchar(40)	Yes	Parameter	No
CUH_PARAM_OU	_numeric_28_0	numeric(28)	Yes	Parameter ouinstance	No
CUH_PARAM_UOM	_varchar_10	varchar(10)	Yes	parameter unit of measurement	No
CUH_SCH_TYPE	_varchar_5	varchar(5)	Yes	Schedule type	No
CUH_LAST_PERFORMED_VALUE	_decimal_28_8	decimal(28)	Yes	Last Performed date	No
CUH_NEXT_PERFORMED_VALUE	_decimal_28_8	decimal(28)	Yes	Next Performed value	No
CUH_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
CUH_INTERVAL	_decimal_28_8	decimal(28)	Yes	Interval	No
CUH_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
CUH_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed tolerance	No
CUH_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed tolerance	No
CUH_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	Terminating Value	No
CUH_UPD_DOCUMENT_NO	_varchar_40	varchar(40)	Yes	updated document no	No
CUH_UPD_DOCUMENT_TYPE	_varchar_25	Varchar(25)	Yes	Updated document type	No
CUH_UPDATED_DATE	_datetime_8	datetime(8)	Yes	updated date	No
CUH_REMARKS	txt2000	varchar(2000)	Yes	Remarks	No
cuh_remarksid	udd_guid	varchar(40)	Yes	Remarks id	No
replication_key	_BIGINT_8	Bigint(8)	No	Replication key	Yes
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No
CUH_PBS_flag	udd_designparamcode	varchar(5)	Yes	Pbs Flag	No

Table Name :	CMP_CUSR_COMP_UB_SCH_REV
Comment :	Component Program Usage Base Schedule Information- Revision Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CUSR_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CUSR_COMPONENT	_varchar_90	varchar(90)	No	Component No	Yes
CUSR_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CUSR_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Component Program Work units Serial No. This would be internally generated no	Yes
CUSR_SCH_LINENO	_decimal_38_0	decimal(38)	No	Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno	Yes
CUSR_PARAMETER	_varchar_40	varchar(40)	No	Parameter	No
CUSR_PARAM_OU	_decimal_38_0	decimal(38)	No	parameter Ou instance	No
CUSR_PARAM_UOM	_varchar_10	varchar(10)	No	parameter unit of measurement	No
CUSR_SCH_TYPE	_varchar_5	varchar(5)	No	Scehdule Type OT - OneTime RC - Recurring	No
CUSR_LAST_PERFORMED_VALUE	_decimal_28_8	decimal(28)	Yes	Last Performed Date	No
CUSR_NEXT_PERFORMED_VALUE	_decimal_28_8	decimal(28)	Yes	Next Performed Value	No
CUSR_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
CUSR_INTERVAL	_decimal_28_8	decimal(28)	Yes	Interval	No
CUSR_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
CUSR_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed Tolerance	No
CUSR_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance	No
CUSR_TERMIN_VALUE	_decimal_28_8	decimal(28)	Yes	Terminating value	No
CUSR_REMARKS	txt2000	varchar(2000)	Yes	Remarks	No
CUSR_REMARKSID	udd_guid	varchar(40)	Yes	Remarks ID	No
created_area_code	_Varchar_40	varchar(40)	Yes	area code	No

Table Name :	CMP_CUS_COMP_UB_SCH
Comment :	Component Program Usage Base Schedule Information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CUS_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
CUS_COMPONENT	_varchar_90	varchar(90)	No	Component No	Yes
CUS_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
CUS_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Component Program Work units Serial No. This would be internally generated no	Yes
CUS_SCH_LINENO	_decimal_38_0	decimal(38)	No	Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno	Yes
CUS_PARAMETER	_varchar_40	varchar(40)	No	Parameter	No
CUS_PARAM_OU	_decimal_38_0	decimal(38)	No	parameter Ou instance	No
CUS_PARAM_UOM	_varchar_10	varchar(10)	No	Parameter UOM	No
CUS_SCH_TYPE	_varchar_5	varchar(5)	No	Scehdule Type OT - "One TIme" RC - "Recurring"	No
CUS_LAST_PERFORMED_VALUE	_decimal_28_8	decimal(28)	Yes	Last Performed Date - Updated after execution of the Work Order	No
CUS_NEXT_PERFORMED_VALUE	_decimal_28_8	decimal(28)	Yes	Next Performed Date	No
CUS_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
CUS_INTERVAL	_decimal_28_8	decimal(28)	Yes	Interval	No
CUS_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
CUS_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed Tolerance	No
CUS_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance	No
CUS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	Terminating Value	No
CUS_REMARKS	txt2000	varchar(2000)	Yes	Remarks	No
CUS_REMARKSID	udd_guid	varchar(40)	Yes	Remarks id	No
created_area_code	_varchar_40	varchar(40)	Yes	area code	No
CUS_PBS_flag	udd_designparamcode	varchar(5)	Yes	Pbs flag	No
cus_nsv_comp_ref_basis	udd_flag	varchar(25)	Yes	On what basis NSV got computed {Induction Date, Operation Date, Time Window, Schedule, RTC}	No
cus_nsv_comp_ref_value	udd_numericparamval	numeric(13)	Yes	Reference value with which NSV computed	No
cus_org_schedule_value	udd_numericparamval	numeric(13)	Yes	NSV prior to last compliance	No
cus_pre_defer_sch_option	udd_flag	varchar(25)	Yes	Deferment option set	No
cus_lpv_nsv_upd_flag	udd_flag	varchar(25)	Yes	LPV is Corrected or Baselined	No
cus_nsv_nsv_upd_flag	udd_flag	varchar(25)	Yes	NSV is Corrected or Baselined	No
cus_lpv_upd_source	udd_flag	varchar(25)	Yes	Screen code from which LPV modified	No
cus_nsv_upd_source	udd_flag	varchar(25)	Yes	Screen code from which NSV modified	No
cus_Instance_no	udd_flag	varchar(25)	Yes	guid	No
cus_change_type	udd_flag	varchar(25)	Yes	change type at the time of NSV / LPV modification	No
cus_lpv_instance_id	udd_guid	varchar(40)	Yes	Instance id for lpv	No
cus_nsv_instance_id	udd_guid	varchar(40)	Yes	Instance id for nsv	No

Table Name :	CMP_MPD_MAINT_PROCESS_DET
Comment :	Maintenance Process Details information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
MPD_OUINSTANCE	_decimal_38_0	decimal(38)	No	Maintenance Process OU	Yes
MPD_PART	_varchar_40	varchar(40)	No	maintenance Process Part no	Yes
MPD_MAINTAIN_PROCESS	_varchar_5	varchar(5)	No	Maintain Process Flag indicating the following values HT - "Hard Time", OC - "On-Condition", CM- "Condition Monitoring" in the same order.	Yes
MPD_PART_CREATED_OU	_decimal_38_0	decimal(38)	Yes	maintenance Process Part Created OU - Used to fetch the desc	No
MPD_REMARKS	_varchar_255	varchar(255)	Yes	Maintenance process Part - Remarks	No
MPD_UPDATED_DATE	_datetime_8	datetime(8)	Yes	Maintenance Process Updated Dte	No
MPD_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created Date	No
MPD_CRETED_BY	_varchar_30	varchar(30)	Yes	Create By User - Login Name	No
MPD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	last Modification Date	No
MPD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified by	No
MPD_TIMESTAMP	_decimal_38_0	decimal(38)	No	Time Stamp	No
created_area_code	varchar	Char(10)	No	Area code	No

Table Name :	CMP_PARAMETER_DETAILS
Comment :	The meta data for the objects in the component maintanance program get maintained in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMP_COMPONENT_NAME	_varchar_20	varchar(20)	No	Component Name - BASCMP	Yes
CMP_PARAM_CAT	_varchar_15	varchar(15)	No	param Category	Yes
CMP_PARAM_TYPE	_varchar_25	Varchar(25)	No	param Type	Yes
CMP_PARAM_CODE	_varchar_5	varchar(5)	No	parameter Code	Yes
CMP_PARAM_DESC	_varchar_80	varchar(80)	No	parameter Desc	No
CMP_LANGID	_decimal_38_0	decimal(38)	No	language ID	Yes
CMP_CREATED_DATE	_datetime_8	datetime(8)	No	Created Date	No
CMP_PREFIX_SORT_BY	_decimal_38_0	decimal(38)	Yes	Prefix Sorted By	No

Table Name :	CMP_PDBS_PART_DB_SCH
Comment :	Operational details of theparts on date based schedule were getting stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PDBS_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PDBS_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PDBS_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PDBS_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Serial No. This would be internally generated no	Yes
PDBS_SCH_LINENO	_decimal_38_0	decimal(38)	No	Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno	Yes
PDBS_SCH_TYPE	_varchar_5	varchar(5)	No	Scehdule Type A - "Actual-Interval" , F- "Fixed-Date"	No
PDBS_TIMEUNIT	_varchar_5	varchar(5)	No	Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years"	No
PDBS_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
PDBS_INTERVAL	_decimal_28_8	decimal(28)	Yes	Interval	No
PDBS_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
PDBS_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed Tolerance	No
PDBS_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance	No
PDBS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	Terminating value	No
PDBS_TERMIN_DATE	_datetime_8	datetime(8)	Yes	Terminating date	No
PDBS_UPD_BASIS	_varchar_5	varchar(5)	Yes	Updation Basis: LD - Last performed Date ID - Installation Date	No
PDBS_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks	No
PDBS_REMARKSID	udd_guid	varchar(40)	Yes	Remarks id	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_PDSD_POS_DB_SCH_DET
Comment :	Operational details of the part postions on date based schedule were getting stored in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PDSD_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PDSD_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PDSD_AIRCRAFT_MODEL	_varchar_20	varchar(20)	No	Aircraft Model	Yes
PDSD_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class	Yes
PDSD_LEVEL_NO	_varchar_150	varchar(150)	Yes	Level no in the Configuration Class	No
PDSD_POS_CODE	_varchar_25	Varchar(25)	No	Position Code in the Configuration Class	Yes
PDSD_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Lineno No. This would be internally generated no	Yes
PDSD_SCH_LINENO	_decimal_38_0	decimal(38)	No	schedule line number	Yes
PDSD_SCH_TYPE	_varchar_5	varchar(5)	Yes	Scehdule Type A - "Actual-Interval" , F- "Fixed-Date"	No
PDSD_TIMEUNIT	_varchar_5	varchar(5)	Yes	Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years"	No
PDSD_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
PDSD_INTERVAL	_decimal_28_8	decimal(28)	Yes	Interval	No
PDSD_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
PDSD_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
PDSD_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed	No
created_area_code	varchar	Char(10)	Yes	Area code	No

Table Name :	CMP_PDSH_POS_SCH_HDR
Comment :	Part Position Date Based Schedules header details are get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PDSH_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PDSH_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PDSH_AIRCRAFT_MODEL	_varchar_20	varchar(20)	No	Aircraft Model	Yes
PDSH_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class	Yes
PDSH_LEVEL_NO	_varchar_150	varchar(150)	Yes	Level no in the Configuration Class	No
PDSH_POS_CODE	_varchar_25	Varchar(25)	No	Position Code in the Configuration Class	Yes
PDSH_LINK_FLAG	_varchar_25	Varchar(25)	Yes	Link Flag S,R,P,PR,PS,PRS	No
PDSH_STATUS	_varchar_5	varchar(5)	Yes	Part - Position Combination data based schedule status A- Authorized F - Fresh	No
PDSH_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created Date	No
PDSH_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
PDSH_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified By	No
PDSH_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified Date	No
PDSH_AUTHORIZED_BY	_varchar_30	varchar(30)	Yes	Authorized By the User	No
PDSH_AUTHORIZED_DATE	_datetime_8	datetime(8)	Yes	Authorization Date	No
PDSH_TIMESTAMP	_decimal_38_0	decimal(38)	Yes	Timestamp of the current record	No

Table Name :	CMP_PDSR_PART_DB_SCH_REV
Comment :	Part Program Date based Schedule details - Revision details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PDSR_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PDSR_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PDSR_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PDSR_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Serial No. This would be internally generated no	Yes
PDSR_SCH_LINENO	_decimal_38_0	decimal(38)	No	Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno	Yes
PDSR_SCH_TYPE	_varchar_5	varchar(5)	No	Scehdule Type A - "Actual-Interval" , F- "Fixed-Date"	No
PDSR_TIMEUNIT	_varchar_5	varchar(5)	No	Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years"	No
PDSR_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
PDSR_INTERVAL	_decimal_28_8	decimal(28)	Yes	The interval set for the NSV and LSV	No
PDSR_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
PDSR_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
PDSR_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed	No
PDSR_TERMIN_VALUE	_decimal_28_8	decimal(28)	Yes	Based on NSD and LPV and the interval this value get store on FH,FC considerations	No
PDSR_TERMIN_DATE	_datetime_8	datetime(8)	Yes	The date after which maintenance requirement terminates. In other words, the number of days after which maintenance activity need not be performed on the component	No
PDSR_UPD_BASIS	_varchar_5	varchar(5)	Yes	Updation basis: ID - Installation Date LD - Last Performed Date	No
PDSR_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks	No
PDSR_REMARKSID	udd_guid	varchar(40)	Yes	Remark id	No
created_area_code	varchar	Char(10)	Yes	Area code	No

Table Name :	CMP_PMER_PART_MATERIAL_EST_REV
Comment :	The estimation of the materials needed are stored here-revision details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PMER_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PMER_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PMER_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PMER_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Serial No. This would be internally generated no	Yes
PMER_PART_LINE_NO	_decimal_38_0	decimal(38)	No	Estimated Part Line No - Running serial no for a given Part, Progrm ou	Yes
PMER_EST_PART	_varchar_40	varchar(40)	No	Estimated Part No - Required Part	No
PMER_EST_PART_CREATEDOU	_decimal_38_0	decimal(38)	No	Estimated part Created OU - Used to fetch the Description	No
PMER_REQUIRED_QTY	_decimal_28_8	decimal(28)	Yes	Part Required Qty	No
PMER_REQ_QTY_IN_STOCK_UOM	_decimal_28_8	decimal(28)	Yes	Required Qty In Stock UOM	No
PMER_UOM	_varchar_10	varchar(10)	Yes	Required Qty UOM	No
PMER_WAREHOUSE	_varchar_10	varchar(10)	Yes	Estimated Part Warehouse	No
PMER_WAREHOUSE_OU	_decimal_38_0	decimal(38)	Yes	Warehouse OU	No
PMER_PART_COST	_decimal_28_8	decimal(28)	Yes	Part Cost	No
created_area_code	varchar	Char(10)	Yes	Area code	No

Table Name :	CMP_PME_PART_MATERIAL_EST
Comment :	The estimation of the materials needed are stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PME_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PME_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PME_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PME_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Serial No. This would be internally generated no	Yes
PME_PART_LINE_NO	_decimal_38_0	decimal(38)	No	Estimated Part Line No - Running serial no for a given Part, Progrm ou	Yes
PME_EST_PART	_varchar_40	varchar(40)	No	Estimated Part No - Required Part	No
PME_EST_PART_CREATEDOU	_decimal_38_0	decimal(38)	No	Estimated part Created OU - Used to fetch the Description	No
PME_REQUIRED_QTY	_decimal_28_8	decimal(28)	Yes	Part Required Qty in Display UOM	No
PME_UOM	_varchar_10	varchar(10)	Yes	Required Qty UOM	No
PME_WAREHOUSE	_varchar_10	varchar(10)	Yes	Estimated Part Warehouse	No
PME_WAREHOUSE_OU	_decimal_38_0	decimal(38)	Yes	Warehouse OU	No
PME_PART_COST	_decimal_28_8	decimal(28)	Yes	Part Cost	No
PME_REQ_QTY_IN_STOCK_UOM	_decimal_28_8	decimal(28)	Yes	Required Qty In Stok UOM	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_PPDR_PART_PRG_DET_REV
Comment :	The Part program details - Revision details are get stored

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PPDR_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PPDR_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PPDR_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PPDR_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Serial No. This would be internally generated no	Yes
PPDR_MAINT_TYPE	_varchar_5	varchar(5)	Yes	"Maintenance Type" defined under maintenance type in the common masters. "Overhaul" "Repair" "Inspection" "Others"	No
PPDR_WORKUNIT_TYPE	_varchar_5	varchar(5)	Yes	work unit type values T - "Task" S - "Std Procedure" W - "Work Package"	No
PPDR_WORKUNIT	_varchar_40	varchar(40)	Yes	Work Unit , It could be Task, Stored Procedure or Work package	No
PPDR_WORKUNIT_REVNO	_varchar_40	varchar(40)	Yes	work unit revision number	No
PPDR_WORKUNIT_OU	_decimal_38_0	decimal(38)	Yes	Work Unit OU Instance - Used to fetch the description	No
PPDR_EXEC_FACILITY	_varchar_5	varchar(5)	Yes	"Execution Facility" I - "In-House" O - "Outsource"	No
PPDR_WORK_CENTER	_varchar_30	varchar(30)	Yes	work center codes in "Active" status defined in the work center components with which this component is interacting And the work units have an associated work center # that is currently not in "Active" status	No
PPDR_WORK_CENTER_OU	_decimal_38_0	decimal(38)	Yes	Work Center OU	No
PPDR_TIMEUNIT	_varchar_5	varchar(5)	Yes	Time Unit for Estimated Duration H - Hource D- Days M - Minutes	No
PPDR_TURNAROUNDTIME_DISP	_decimal_28_8	decimal(28)	Yes	Turn Around time in Display Time Unit	No
PPDR_TURNAROUND_TIME_MIN	_decimal_28_8	decimal(28)	Yes	Turn around time in min	No
PPDR_EST_DURATION_MIN	_decimal_28_8	decimal(28)	Yes	Estimated Duration in Min	No
PPDR_EST_DURATION_DISP	_decimal_28_8	decimal(28)	Yes	Estimated Duration in Display timeunit	No
PPDR_ONWING	_varchar_5	varchar(5)	Yes	On Wing Y/N Y - Yes N - No	No
PPDR_REFDOCTYPE	_varchar_25	Varchar(25)	Yes	Ref Document Type - Values defined in the common master of RefDoctype	No
PPDR_REFDOCNO	_varchar_40	varchar(40)	Yes	Reference Document No	No
PPDR_REFDOC_OU	_decimal_38_0	decimal(38)	Yes	Reference Document OU	No
PPDR_REFDOC_DETAILS	_varchar_255	varchar(255)	Yes	Reference Document Details _ User Entered Value	No
PPDR_EO_REFDOC_NO	_varchar_40	varchar(40)	Yes	Eo Reference Document No	No
PPDR_EO_REFDOC_REVNO	_varchar_40	varchar(40)	Yes	EO Reference Document revision No	No
PPDR_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
PPDR_LINK_FLAG	_varchar_25	Varchar(25)	Yes	Link Flag S,P, R, PR, PS , PRS	No
PPDR_WORKUNIT_STATUS	_varchar_5	varchar(5)	Yes	Work Unit Status A- Active or I - Inactive	No
PPDR_TIMESTAMP	_decimal_38_0	decimal(38)	Yes	Timestamp of the current record	No
PPDR_SHELFLIFE	_varchar_5	varchar(5)	Yes	shelfed life time	No
ppdr_EXPENSETYPE	_varchar_5	varchar(5)	Yes	Expense type	No
PPDR_PRG_GROUP	udd_flag	varchar(25)	Yes	part program group may be of comp.requirements and soon	No
PPDR_ITEM_TYPE	udd_designparamcode	varchar(5)	Yes	Item type	No
PPDR_INITRST_BY	udd_designparamcode	varchar(5)	Yes	Can be of self compliance or RTC	No
PPDR_DEFEXE_PRI	udd_priorityno	int(4)	Yes	Default Priority	No
ppdr_modified_date	_datetime_8	datetime(8)	Yes	Modified date	No
ppdr_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
PPDR_PACKAGE_TYPE	udd_doctype	varchar(40)	Yes	Package type	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_PPD_PART_PRG_DET
Comment :	Part Program Workunit Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PPD_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PPD_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PPD_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PPD_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Serial No. This would be internally generated no	Yes
PPD_MAINT_TYPE	_varchar_5	varchar(5)	Yes	"Maintenance Type" defined under maintenance type in the common masters. "Overhaul" "Repair" "Inspection" "Others"	No
PPD_WORKUNIT_TYPE	_varchar_5	varchar(5)	No	work unit type values T - "Task" S - "Std Procedure" W - "Work Package"	No
PPD_WORKUNIT	_varchar_30	varchar(30)	No	Work Unit , It could be Task, Stored Procedure or Work package	No
PPD_WORKUNIT_REVNO	_varchar_40	varchar(40)	Yes	Work Unit Revision No	No
PPD_WORKUNIT_OU	_decimal_38_0	decimal(38)	Yes	Work Unit OU Instance - Used to fetch the description	No
PPD_EXEC_FACILITY	_varchar_5	varchar(5)	Yes	"Execution Facility" I - "In-House" O - "Outsource"	No
PPD_WORK_CENTER	_varchar_30	varchar(30)	Yes	work center codes in "Active" status defined in the work center components with which this component is interacting And the work units have an associated work center # that is currently not in "Active" status	No
PPD_WORK_CENTER_OU	_decimal_38_0	decimal(38)	Yes	Work Center OU	No
PPD_TIMEUNIT	_varchar_5	varchar(5)	Yes	Time Unit for Estimated Duration H - Hource D- Days M - Minutes	No
PPD_TURNAROUNDTIME_DISP	_decimal_28_8	decimal(28)	Yes	Turn Around time in Display Time Unit	No
PPD_TURNAROUNDTIME_MIN	_decimal_28_8	decimal(28)	Yes	Turn around time in Min	No
PPD_EST_DURATION_DISP	_decimal_28_8	decimal(28)	Yes	Estimated Duration in Display Unit	No
PPD_EST_DURATION_MIN	_decimal_28_8	decimal(28)	Yes	Estimated Duration in Min	No
PPD_ONWING	_varchar_5	varchar(5)	Yes	On Wing Y/N Y - Yes N - No	No
PPD_REFDOCTYPE	_varchar_25	Varchar(25)	Yes	Ref Document Type - Values defined in the common master of RefDoctype	No
PPD_REFDOCNO	_varchar_40	varchar(40)	Yes	Reference Document No	No
PPD_REFDOC_OU	_decimal_38_0	decimal(38)	Yes	Reference Document OU	No
PPD_REFDOC_DETAILS	_varchar_255	varchar(255)	Yes	Reference Document Details - User Entered Value	No
PPD_EO_REFDOC_NO	_varchar_40	varchar(40)	Yes	EO Ref Document No	No
PPD_EO_REFDOC_REVNO	_varchar_40	varchar(40)	Yes	EO Ref Document Revision No	No
PPD_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
PPD_LINK_FLAG	_varchar_25	Varchar(25)	Yes	Link Flag P, R, PR, PS , PRS ?????????	No
PPD_WORKUNIT_STATUS	_varchar_5	varchar(5)	Yes	Work Unit Status A- Active I - Inactive	No
PPD_SHELFLIFE	_varchar_5	varchar(5)	Yes	Shelfed life time	No
PPD_Expense_Type	_varchar_5	varchar(5)	Yes	Expense type	No
PPD_PRG_GROUP	udd_flag	varchar(25)	Yes	part program group may be of comp.requirements and soon	No
PPD_ITEM_TYPE	udd_designparamcode	varchar(5)	Yes	Item type	No
PPD_INITRST_BY	udd_designparamcode	varchar(5)	Yes	Can be of self compliance or RTC	No
PPD_DEFEXE_PRI	udd_priorityno	int(4)	Yes	default Priority	No
PPD_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
PPD_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified date	No
PPD_ENGDOCTYPE	udd_quickcode	varchar(25)	Yes	Eng documenty type	No
PPD_PACKAGE_TYPE	udd_doctype	varchar(40)	Yes	Package type	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_PPHR_PART_PRG_HDR_REV
Comment :	Part Program Header - Revision details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PPHR_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PPHR_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PPHR_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PPHR_CREATED_PART_OU	_decimal_38_0	decimal(38)	Yes	Created part OU used to fetch the description	No
PPHR_PROGRAM_STATUS	_varchar_5	varchar(5)	Yes	Program Status F - Fresh A - Authorized	No
PPHR_PROGRAM_USER_STATUS	_varchar_25	Varchar(25)	Yes	User Status - Quick Code	No
PPHR_REMARKS	_varchar_255	varchar(255)	Yes	Part program Remarks	No
PPHR_PARENT_REMOVAL	_varchar_5	varchar(5)	Yes	Parent Removal Required Y - Yes N - No	No
PPHR_PARENT_PART_NO	_varchar_40	varchar(40)	Yes	Parent Part No to be Removed	No
PPHR_CREATION_DATE	_datetime_8	datetime(8)	Yes	Record Creation date	No
PPHR_CREATED_BY	_varchar_30	varchar(30)	Yes	Record Created by User Id	No
PPHR_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Record last modification date	No
PPHR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Record Last modified By	No
PPHR_AUTHORIZED_BY	_varchar_30	varchar(30)	Yes	Authorised by	No
PPHR_AUTHORIZATION_DATE	_datetime_8	datetime(8)	Yes	Authorization date	No
PPHR_TIMESTAMP	_decimal_38_0	decimal(38)	Yes	Record Timestamp	No
created_area_code	_varchar_40	varchar(40)	Yes	area code	No

Table Name :	CMP_PPH_PART_PRG_HDR
Comment :	Part Program Header details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PPH_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PPH_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PPH_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PPH_LATEST_FLAG	_varchar_5	varchar(5)	Yes	Latest Revision Flag Y - Yes, N - No	No
PPH_CREATED_PART_OU	_decimal_38_0	decimal(38)	Yes	Created part OU used to fetch the description	No
PPH_PROGRAM_STATUS	_varchar_5	varchar(5)	Yes	Program Status F - Fresh A - Authorized	No
PPH_PROGRAM_USER_STATUS	_varchar_25	Varchar(25)	Yes	User Status - Quick Code	No
PPH_REMARKS	_varchar_255	varchar(255)	Yes	Part program Remarks	No
PPH_PARENT_REMOVAL	_varchar_5	varchar(5)	Yes	Parent Removal Required Y - Yes N - No	No
PPH_PARENT_PART_NO	_varchar_16	varchar(16)	Yes	Parent Part No to be Removed	No
PPH_CREATION_DATE	_datetime_8	datetime(8)	No	Record Creation date	No
PPH_CREATED_BY	_varchar_30	varchar(30)	No	Record Created by User Id	No
PPH_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Record last modification date	No
PPH_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Record Last modified By	No
PPH_AUTHORIZED_BY	_varchar_30	varchar(30)	Yes	Authorized By user name	No
PPH_AUTHORIZATION_DATE	_datetime_8	datetime(8)	Yes	Authorizzed date	No
PPH_TIMESTAMP	_decimal_38_0	decimal(38)	No	Record Timestamp	No
created_area_code	_varchar_40	varchar(40)	No	Area code	No

Table Name :	CMP_PRER_PART_RES_EST_REV
Comment :	Resource estimate - revision details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRER_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PRER_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PRER_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PRER_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Serial No. This would be internally generated no	Yes
PRER_RESOURCE_LINENO	_decimal_38_0	decimal(38)	No	Resource Line No	Yes
PRER_RESOURCENO	_varchar_40	varchar(40)	No	Resource No	No
PRER_RESTYPE	_varchar_5	varchar(5)	No	Resource Type F- Facility S - Skill	No
PRER_RESOURCE_OU	_decimal_38_0	decimal(38)	No	Resource OU instance	No
PRER_TIMEUNIT	_varchar_5	varchar(5)	Yes	Time unit D - Days H _ hours M _ Mins	No
PRER_REQDURATION_DISPLAY	_decimal_28_8	decimal(28)	Yes	Required Duration in Display Time unit	No
PRER_REQDURATION_MIN	_decimal_28_8	decimal(28)	Yes	Required Duration in Min	No
PRER_REQQTY	_decimal_28_8	decimal(28)	Yes	Required Qty	No
PRER_SIGNOFF	_varchar_5	varchar(5)	Yes	Sign off Required Y/N Y - Yes N - No Applicable for Skill Resource only. In case of Facilities, Always it is N	No
PRER_RESOURCE_COST	_decimal_28_8	decimal(28)	Yes	Resource Cost	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_PRE_PART_RES_EST
Comment :	Part Program Resource (Skill, Facility) Estiamtations are get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PRE_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PRE_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PRE_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PRE_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Serial No. This would be internally generated no	Yes
PRE_RESOURCE_LINENO	_decimal_38_0	decimal(38)	No	Resource Line No	Yes
PRE_RESOURCENO	_varchar_40	varchar(40)	No	Resource No	No
PRE_RESTYPE	_varchar_5	varchar(5)	No	Resource Type F- Facility S - Skill	No
PRE_RESOURCE_OU	_decimal_38_0	decimal(38)	No	Resource OU instance	No
PRE_TIMEUNIT	_varchar_5	varchar(5)	Yes	Time unit D - Days H _ hours M _ Mins	No
PRE_REQDURATION_DISPLAY	_decimal_28_8	decimal(28)	Yes	Required Duration in Display Time unit	No
PRE_REQDURATION_MIN	_decimal_28_8	decimal(28)	Yes	Required Duration in Min	No
PRE_REQQTY	_decimal_28_8	decimal(28)	Yes	Required Qty	No
PRE_SIGNOFF	_varchar_5	varchar(5)	Yes	Sign off Required Y/N Y - Yes N - No Applicable for Skill Resource only. In case of Facilities, Always it is N	No
PRE_RESOURCE_COST	_decimal_28_8	decimal(28)	Yes	Resource Cost	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_PUBS_PART_UB_SCH
Comment :	Part Program Usage Base Schedule Information are get store here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PUBS_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PUBS_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PUBS_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PUBS_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Serial No. This would be internally generated no	Yes
PUBS_SCH_LINENO	_decimal_38_0	decimal(38)	No	Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno	Yes
PUBS_PARAMETER	_varchar_40	varchar(40)	No	Parameter	No
PUBS_PARAM_OU	_decimal_38_0	decimal(38)	No	Parameter OU	No
PUBS_PARAM_UOM	_varchar_10	varchar(10)	Yes	Parameter UOM	No
PUBS_SCH_TYPE	_varchar_5	varchar(5)	No	Scehdule Type A - "Actual-Interval" , F- "Fixed-Date"	No
PUBS_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
PUBS_INTERVAL	_decimal_28_8	decimal(28)	Yes	Interval	No
PUBS_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
PUBS_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed Tolerance	No
PUBS_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance	No
PUBS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	Termoinating value	No
PUBS_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks	No
PUBS_REMARKSID	udd_guid	varchar(40)	Yes	Remarks id	No

Table Name :	CMP_PUSD_POS_USAGE_SCH_DET
Comment :	Position based schedule Information are get stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PUSD_SCH_LINENO	_decimal_38_0	decimal(38)	No	Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno	Yes
PUSD_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PUSD_AIRCRAFT_MODEL	_varchar_20	varchar(20)	No	Aircraft Model	Yes
PUSD_CONFIG_CLASS	_varchar_30	varchar(30)	No	Configuration Class	Yes
PUSD_LEVEL_NO	_varchar_150	varchar(150)	Yes	Level no in the Configuration Class	No
PUSD_POS_CODE	_varchar_25	Varchar(25)	No	Position Code in the Configuration Class	Yes
PUSD_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PUSD_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Lineno No. This would be internally generated no	Yes
PUSD_PARAMETER	_varchar_40	varchar(40)	Yes	Parameter	No
PUSD_PARAMETER_UOM	_varchar_10	varchar(10)	Yes	Parameter UOM	No
PUSD_PARAMETER_OU	_decimal_38_0	decimal(38)	Yes	Parameter OU	No
PUSD_SCH_TYPE	_varchar_5	varchar(5)	Yes	Scehdule Type A - "Actual-Interval" , F- "Fixed-Date"	No
PUSD_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
PUSD_INTERVAL	_decimal_28_8	decimal(28)	Yes	Interval	No
PUSD_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
PUSD_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed Tolerance	No
PUSD_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance	No
PUBS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	terminating value	No
PUBS_REMARKS	udd_txt2000	varchar(2000)	Yes	remarks	No
PUBS_REMARKSID	udd_guid	varchar(40)	Yes	remarks id	No
created_area_code	_varchar_40	varchar(40)	Yes	area code	No

Table Name :	CMP_PUSR_PART_UB_SCH_REV
Comment :	Part Program Usage Base Schedule Information - Revision details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PUSR_OUINSTANCE	_decimal_38_0	decimal(38)	No	Part Program OU	Yes
PUSR_PART_NO	_varchar_40	varchar(40)	No	Part No for the Program	Yes
PUSR_PROGRAM_REVISION_NO	_varchar_40	varchar(40)	No	Part program Revision No. Initial value would be Zero.	Yes
PUSR_WORKUNIT_LINENO	_decimal_38_0	decimal(38)	No	Part Program Work units Serial No. This would be internally generated no	Yes
PUSR_SCH_LINENO	_decimal_38_0	decimal(38)	No	Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno	Yes
PUSR_PARAMETER	_varchar_40	varchar(40)	No	Parameter	No
PUSR_PARAM_OU	_decimal_38_0	decimal(38)	No	Parameter OU	No
PUSR_PARAM_UOM	_varchar_10	varchar(10)	Yes	Parameter UOM	No
PUSR_SCH_TYPE	_varchar_5	varchar(5)	No	Scehdule Type A - "Actual-Interval" , F- "Fixed-Date"	No
PUSR_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
PUSR_INTERVAL	_decimal_28_8	decimal(28)	Yes	Interval	No
PUSR_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
PUSR_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed Tolerance	No
PUSR_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance	No
PUSR_TERMIN_VALUE	_decimal_28_8	decimal(28)	Yes	Terminating value	No
PUSR_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks	No
PUSR_REMARKSID	udd_guid	varchar(40)	Yes	Remarks id	No
created_area_code	_varchar_40	varchar(40)	Yes	area code	No

Table Name :	CMP_Record_status_Logtable
Comment :	Component program Status log info is stored here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CMP_keyno	udd_count	int(4)	No	Key seq no	No
CMP_OUInstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
CMP_ProgramNo	udd_documentno	varchar(40)	Yes	Program no	No
CMP_RevisionNo	udd_count	int(4)	Yes	Revision no	No
CMP_SeqNo	udd_seqno	int(4)	Yes	Seq no	No
CMP_ComponentNo	udd_componentid	varchar(90)	Yes	component id	No
CMP_PART	udd_partno	varchar(40)	Yes	Part no	No
CMP_Entity	udd_txt150	varchar(150)	Yes	Entity	No
CMP_ParamCode	udd_parameter	varchar(40)	Yes	ParamCode	No
CMP_Fromval	udd_documentno	varchar(40)	Yes	From value	No
CMP_Toval	udd_documentno	varchar(40)	Yes	To value	No
CMP_SourceComp	udd_ctxt_component	varchar(20)	Yes	Source Component	No
CMP_ModifiedBy	udd_ctxt_user	varchar(30)	Yes	Modified By	No
CMP_ModifiedDate	udd_datetime1	datetime(8)	Yes	Modified Date	No
CMP_Transcation_no	udd_documentno	varchar(40)	Yes	Transcation no	No
CMP_Taskno	udd_workunitcode	varchar(30)	Yes	taskno	No
CMP_Task_revno	udd_revisionno	varchar(40)	Yes	task revision no	No
CMP_Service	udd_ctxt_service	varchar(32)	Yes	service	No
CMP_Threshold	udd_numericparamval	numeric(13)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
CMP_Interval	udd_numericparamval	numeric(13)	Yes	interval	No
CMP_Terminatingvalue	udd_numericparamval	numeric(13)	Yes	terminating value	No
CMP_NSD	datetime	Datetime(8)	Yes	next shcedule date	No
CMP_NSV	udd_numericparamval	numeric(13)	Yes	next shcedule value	No
CMP_LPD	datetime	Datetime(8)	Yes	last performed date	No
CMP_LPV	udd_numericparamval	numeric(13)	Yes	last performed value	No
created_area_code	_varchar_40	varchar(40)	Yes	Area code	No

Table Name :	CMP_RWI_RESTORATION_WU_INFO
Comment :	Part Restoration Work unit Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RWI_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Part Program OU	Yes
RWI_PART_NO	udd_partno	varchar(40)	No	Part No	Yes
RWI_PART_CREATED_OU	udd_ctxt_ouinstance	int(4)	Yes	Part Created Ou used to fetch the Description	No
RWI_WORKUNIT_TYPE	_varchar_5	varchar(5)	Yes	Work unit Type T - Task S -Standard procedures	No
RWI_WORKUNIT	_varchar_30	varchar(30)	Yes	Work Unit No	No
RWI_WORKUNIT_REVNO	_varchar_25	Varchar(25)	Yes	Work Unit Revision No	No
RWI_WORKUNIT_OU	udd_ctxt_ouinstance	int(4)	Yes	Work Unit OU - Used to fetch description	No
RWI_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
RWI_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created Date	No
RWI_CREATED_BY	_varchar_30	varchar(30)	Yes	Creted By	No
RWI_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modification Date	No
RWI_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified By	No
RWI_TIMESTAMP	udd_timestampint	int(4)	Yes	Timestamp of the current record	No
RWI_INCOMING_PART_EST	_varchar_25	Varchar(25)	Yes	InComing Part Estimated Flag Y - Yes N - No	No
created_area_code	_varchar_40	varchar(40)	Yes	area code	No

Table Name :	CMP_UPDS_UPD_DB_SCH
Comment :	Component program date based schedule

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
UPDS_OUINSTANCE	_decimal_38_0	decimal(38)	No	ouinstance	Yes
UPDS_WU_UPDATENO	_varchar_50	varchar(50)	No	Work unit updation number	Yes
UPDS_SCH_TYPE	_varchar_5	varchar(5)	Yes	Scehdule Type A - "Actual-Interval" , F- "Fixed-Date"	No
UPDS_SCH_ID	_decimal_38_0	decimal(38)	No	schedule id	Yes
UPDS_TIMEUNIT	_varchar_5	varchar(5)	Yes	Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years"	No
UPDS_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
UPDS_INTERVAL	_decimal_28_8	decimal(28)	Yes	The interval set for the NSV and LSV	No
UPDS_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
UPDS_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed	No
UPDS_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed	No
UPDS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	The value after which the maintenance activity cannot be performed on the component	No
UPDS_TERMINATING_DATE	_datetime_8	datetime(8)	Yes	The date after which the maintenance activity cannot be performed on the component	No

Table Name :	CMP_UPUS_UPD_UB_SCH
Comment :	Component program usage based schedule

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
UPUS_OUINSTANCE	_decimal_38_0	decimal(38)	No	ouinstance	Yes
UPUS_WU_UPDATE_NO	_varchar_50	varchar(50)	No	work unit updation number	Yes
UPUS_PARAMETER	_varchar_40	varchar(40)	Yes	Parameter	No
UPUS_PARAMETER_OU	_decimal_38_0	decimal(38)	Yes	parameter OU instance	No
UPUS_PARAM_UOM	_varchar_10	varchar(10)	Yes	Parameter unit of measurement	No
UPUS_SCH_TYPE	_varchar_5	varchar(5)	Yes	Scehdule Type A - "Actual-Interval" , F- "Fixed-Date"	No
UPUS_SCH_ID	_decimal_38_0	decimal(38)	No	schedule id	Yes
UPUS_TIMEUNIT	_varchar_5	varchar(5)	Yes	Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years"	No
UPUS_THRESHOLD	_decimal_28_8	decimal(28)	Yes	The parameter value at which the task must be performed for the very first time on the aircraft/part/component.	No
UPUS_INTERVAL	_decimal_28_8	decimal(28)	Yes	Interval	No
UPUS_ALERTVALUE	_decimal_28_8	decimal(28)	Yes	Alert value	No
UPUS_POS_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period subsequent to the next schedule date, within which the work unit must be performed Tolerance	No
UPUS_NEG_TOLERANCE	_decimal_28_8	decimal(28)	Yes	The maximum time period ahead of the next schedule date, within which the work unit could be performed Tolerance	No
UPUS_TERMINATING_VALUE	_decimal_28_8	decimal(28)	Yes	Terminating value	No

Table Name :	CMP_UWIP_UPDATE_WU_IN_PRG
Comment :	Update Work Unit information In Programs

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
UWIP_OUINSTANCE	_decimal_38_0	decimal(38)	No	ouinstance	Yes
UWIP_WU_UPDATE_NO	_varchar_18	varchar(18)	No	Work unit update number	Yes
UWIP_WORKUNIT	_varchar_30	varchar(30)	Yes	Work unit code	No
UWIP_WORKUNIT_TYPE	_varchar_250	varchar(250)	Yes	Work Unit Type T-task S-stored procedure W-work package	No
UWIP_WU_REV_NO	_varchar_40	varchar(40)	Yes	Revision Number	No
UWIP_maintenance_TYPE	_varchar_5	varchar(5)	Yes	Maintenance Type OVH- overhaul REP- repair INS - inspection OTH - others	No
UWIP_REF_DOC_TYPE	_varchar_25	Varchar(25)	Yes	Reference Document Type	No
UWIP_REF_DOC_NO	_varchar_40	varchar(40)	Yes	Reference Doc No	No
UWIP_COMMENTS	_varchar_255	varchar(255)	Yes	Update Work Unit Comments	No
UWIP_UPDATED_BY	_varchar_30	varchar(30)	Yes	Updated by the user name - Login User	No
UWIP_UPDATED_DATE	_datetime_8	datetime(8)	Yes	Updated Date	No
UWIP_EXECUTION_FACILITY	_varchar_5	varchar(5)	Yes	Execution Facility I - Inhouse O - Out Source	No
UWIP_EXEC_WORKCENTER	_varchar_30	varchar(30)	Yes	execution Work Center	No
UWIP_EXEC_TIMEUNIT	_varchar_30	varchar(30)	Yes	Execution Time Unit	No
UWIP_EST_DURATION	_decimal_20_0	decimal(20)	Yes	Estiamted Duration	No
UWIP_TURNAROUND_TIME	_decimal_20_0	decimal(20)	Yes	Turn Around Time	No
UWIP_ONWING	_varchar_5	varchar(5)	Yes	On Wing Y - Yes N - No	No
UWIP_TIMESTAMP	_decimal_38_0	decimal(38)	Yes	TimeStamp	No
UWIP_NUM_TYPE	_varchar_15	varchar(15)	Yes	Numbering Type	No
UWIP_UPD_STATUS	_varchar_30	varchar(30)	Yes	Work Unit Update Status Draft - The WU Change would be in draft status when the transaction created without checking Update Programs Authorized - - The WU Change would be in Authorized status when the transaction created By checking Update Program	No
UWIP_LINK_FLAG	_varchar_15	varchar(15)	Yes	Link Flag Indicating the Schedules Defined ot Not. DB - Date Based Schedules Only Defined UB - Usage Based Schedules Only Defined DU - Date and Usage Based Schedules Defined	No
UWIP_INCORPORATED	_varchar_1	varchar(1)	Yes	Incorporated the changes Y- Yes N - No	No
UWIP_SHELFLIFE	_varchar_5	varchar(5)	Yes	Shelfed life time	No
UWIP_EXPENSETYPE	_varchar_5	varchar(5)	Yes	Expense type	No
UWIP_START_DAY	_int_0	int(0)	Yes	Start date	No
UWIP_PRG_GROUP	udd_flag	varchar(25)	Yes	part program group may be of comp.requirements and soon	No
UWIP_ITEM_TYPE	udd_designparamcode	varchar(5)	Yes	Item type	No
UWIP_INITRST_BY	udd_designparamcode	varchar(5)	Yes	Can be of self compliance or RTC	No
UWIP_DEFEXE_PRI	udd_priorityno	int(4)	Yes	Default Priority	No
UWIP_PACKAGE_TYPE	udd_doctype	varchar(40)	Yes	Package type	No

Table Name :	CMP_UWPD_UPDATE_WU_PART_DET
Comment :	Update Work Unit Part Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
UWPD_OUINSTANCE	_decimal_38_0	decimal(38)	No	ouinstance	Yes
UWPD_WU_UPDATE_NO	_varchar_18	varchar(18)	No	work unit update number	Yes
UWPD_LINE_NO	_decimal_38_0	decimal(38)	No	Unique line no in a WU Update no - used for processing the each line separately	Yes
UWPD_COMPONENT_NO	_varchar_90	varchar(90)	Yes	component of the program in whcih the WU to be changed	No
UWPD_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serialno of the program in whcih the WU to be changed	No
UWPD_PART_NO	_varchar_40	varchar(40)	Yes	Part no in whcih WU to be changed	No
UWPD_ACTION	_varchar_5	varchar(5)	Yes	A -Append or D - delete	No
UWPD_WU_CHANGE_INC	_varchar_1	varchar(1)	Yes	WU Change Incorporation at part level Completed Y - Yes N - No	No
UWPD_DB_SCH_CHANGE_INC	_varchar_1	varchar(1)	Yes	Date Based Schedule Changes Completed UY - Yes, N- No	No
UWPD_UB_SCH_CHANGE_INC	_varchar_1	varchar(1)	Yes	Usage based Schedules Completed Y - Yes, N - No	No