Data Dictionary -- Capacity Planning

Srl. No.	Table Name	Comment
1	CPLN_CPAFB_AC_FIELD_BASE	Table which stores the Aircraft to Field Base(Work Center) association. If the start date is Null, then some default value "01/01/1900" is stored, because the combination of OUInstance, Aircraft Reg no and start date are Primary key
2	CPLN_CPDFRQ_DEFERRAL_REQ	Deferrals created in Central Planning
3	cpln_cpdfrq_deferral_req_his	Deferral requirement histroy table
4	CPLN_CPDFWU_DEF_WORK_UNITS	Deferral Work Unit list.
5	cpln_cpdfwu_def_work_units_his	Deferral work unit histroy table
6	CPLN_CPICWU_SUBTSK_SNOFF	Subtask signoff details table
7	CPLN_CPLNDC_REASON_CATEGORY	Reason Category Master
8	CPLN_CPLNOP_OPTIONS_SET	Option Setting for Central Planning Component is maintained here
9	CPLN_CPLNVC_VISIT_CATEGORY	Visit Category Master
10	CPLN_CPMDLG_MODIFICATION_LOG	If the Option setting in this component for " Aircraft / Component Workscope : Allocation Revision Method" is "Modification Log" then work units which are getting assigned to an exisiting Visit Package will be maintained in this table.
11	CPLN_CPMLGD_MOD_LOG_HDR	If the Revision Option in Option setting is Modification Log all changes to the visit package created by the Central Planner will be maintained here.
12	CPLN_CPPLMAH_MAT_REQ_HDR	Material request header table
13	CPLN_CPPMPA_MR_PART_DTL	Material request part details table
14	CPLN_CPPMWU_MR_WUDTL	Materail request workunit details table
15	CPLN_CPPSV_PARAM_SCH_VAL	When the work units of the released Forecast, EO , FCD are maintained in the due table, the corresponding parameter details (ie) schedule details are maintained in this table
16	CPLN_CPPSV_PARAM_SCH_VAL_NEW	When the work units of the released Forecast, EO , FCD are maintained in the due table,The corresponding parameter details (ie) schedule details are maintained in this table
17	CPLN_CPSRCH_SEARCH_ID_MASTER	User customized search option master.
18	CPLN_CPWUDU_WORKUNITS_DUE	Central repository where all work units of the released Forecast, EO , FCD and component on wing jobs and component removal jobs will be maintained.
19	CPLN_CPWUUS_WU_USAGE_SCH	Deferral Limits for the Work Units
20	cpln_cpwuus_wu_usage_sch_his	Work unit usage search histroy table
21	CPLN_DISCMAIN_OPT_SET	Table for option setting changes for Central Planning Discrepancy optioins
22	Cpln_Mnt_Quick_Code	Maintenance quick code details table
23	CPLN_PARAMETER_DETAILS	Meta Data Table for Central Planning

Table Name :	CPLN_CPAFB_AC_FIELD_BASE
Comment :	Table which stores the Aircraft to Field Base(Work Center) association. If the start date is Null, then some default value "01/01/1900" is stored, because the combination of OUInstance, Aircraft Reg no and start date are Primary key

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPAFB_OUINSTANCE	_decimal_10_0	decimal(10)	No	Login OUInstance	Yes
CPAFB_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number	Yes
CPAFB_START_DATE	_datetime_8	datetime(8)	No	Start date when not entered store the default value 01/01/1900	Yes
CPAFB_AIRCRAFT_OU	_decimal_10_0	decimal(10)	Yes	Aircraft Registration OUInstance	No
CPAFB_SERIAL_NO	_varchar_40	varchar(40)	Yes	Manufacturer Serial # of the Aircraft.	No
CPAFB_FIELDBASE	_varchar_30	varchar(30)	Yes	Work Center Code	No
CPAFB_FIELDBASE_OU	_decimal_10_0	decimal(10)	Yes	Work Center OUInstance	No
CPAFB_END_DATE	_datetime_8	datetime(8)	Yes	End date	No
CPAFB_CALL_SIGN	_varchar_30	varchar(30)	Yes	Call sign if entered	No
CPAFB_CONTRACT_NO	_varchar_40	varchar(40)	Yes	Contract # if entered	No
CPAFB_CUSTOMER_NO	_varchar_18	varchar(18)	Yes	Customer # if entered	No
CPAFB_CUSTOMER_OU	_decimal_10_0	decimal(10)	Yes	Customer OUInstance if valid Customer # is entered	No
CPAFB_OPER_LOC	_varchar_30	varchar(30)	Yes	Operational Location if entered	No
CPAFB_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
CPAFB_CREATED_BY	_varchar_30	varchar(30)	Yes	Created User id	No
CPAFB_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created Date	No
CPAFB_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified user id	No
CPAFB_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified date	No

Table Name :	CPLN_CPDFRQ_DEFERRAL_REQ
Comment :	Deferrals created in Central Planning

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPDFRQ_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CPDFRQ_DEF_REQ_NO	_varchar_40	varchar(40)	No	deferment request number	Yes
CPDFRQ_NUM_TYPE_NO	_varchar_5	varchar(5)	Yes	Numbering type number	No
CPDFRQ_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CPDFRQ_JOB_TYPE	_varchar_5	varchar(5)	Yes	Job Type - Aircraft or Component Removal or On WIng	No
CPDFRQ_WORK_CENTRE	_varchar_30	varchar(30)	Yes	Work Centre	No
CPDFRQ_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Component Id	No
CPDFRQ_STATUS	_varchar_5	varchar(5)	Yes	Deferment Request Status	No
CPDFRQ_REQUESTOR_CODE	_varchar_15	varchar(15)	Yes	Reuestors employee code	No
CPDFRQ_EMAIL	_varchar_70	varchar(70)	Yes	Email id	No
CPDFRQ_PHONE_NO	_varchar_70	varchar(70)	Yes	Work Phonw Number	No
CPDFRQ_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
CPDFRQ_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created Date	No
CPDFRQ_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No
CPDFRQ_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
CPDFRQ_CONFIRMED_BY	_varchar_30	varchar(30)	Yes	Confirmed By UserId	No
CPDFRQ_CONFIRMEDDATE	_datetime_8	datetime(8)	Yes	Confirmed date	No
CPDFRQ_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
CPDFRQ_DOCKEY	_varchar_128	varchar(128)	Yes	Document key for workflow. Combination of OUInstance and deferal request no	No
CPDFRQ_STAGE	_varchar_25	Varchar(25)	Yes	Stores the workflow states.	No
CPDFRQ_APPROVED_BY	udd_ctxt_user	varchar(30)	Yes	Approved by	No
CPDFRQ_APPROVED_DATE	_datetime_8	datetime(8)	Yes	Approved date and time	No
CPDFRQ_FILENAME	udd_filename	varchar(50)	Yes	File name	No
CPDFRQ_APPROVAL_NO	udd_documentno	varchar(40)	Yes	Approval Number	No
CPDFRQ_APPROVAL_DATE	_datetime_8	datetime(8)	Yes	Approval date and time	No
CPDFRQ_APPROVAL_COMMENTS	udd_txt255	varchar(255)	Yes	Approval comments	No

Table Name :	cpln_cpdfrq_deferral_req_his
Comment :	Deferral requirement histroy table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cpdfrq_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
cpdfrq_def_req_no	udd_documentno	varchar(40)	Yes	deferment request number	No
cpdfrq_revno	udd_revisionno	varchar(40)	Yes	Revision #	No
cpdfrq_num_type_no	udd_designparamcode	varchar(5)	Yes	Numbering type number	No
cpdfrq_aircraft_reg_no	udd_aircraftnumber	varchar(30)	Yes	Aircraft Registration Number	No
cpdfrq_job_type	udd_designparamcode	varchar(5)	Yes	Job Type - Aircraft or Component Removal or On WIng	No
cpdfrq_work_centre	udd_wccode	varchar(30)	Yes	Work Centre	No
cpdfrq_component_id	udd_componentid	varchar(90)	Yes	Component Id	No
cpdfrq_status	udd_designparamcode	varchar(5)	Yes	Deferment Request Status	No
cpdfrq_requestor_code	udd_docstatus	varchar(15)	Yes	Reuestors employee code	No
cpdfrq_email	udd_communicationid	varchar(70)	Yes	Email id	No
cpdfrq_phone_no	udd_communicationid	varchar(70)	Yes	Work Phonw Number	No
cpdfrq_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
cpdfrq_createddate	_datetime_8	datetime(8)	Yes	Created Date	No
cpdfrq_modified_by	udd_ctxt_user	varchar(30)	Yes	Last Modified By	No
cpdfrq_modifieddate	_datetime_8	datetime(8)	Yes	Last Modified Date	No
cpdfrq_confirmed_by	udd_ctxt_user	varchar(30)	Yes	Confirmed By UserId	No
cpdfrq_confirmeddate	_datetime_8	datetime(8)	Yes	Confirmed date	No
cpdfrq_timestamp	udd_timestamp	int(4)	Yes	Timestamp	No
cpdfrq_dockey	udd_txt150	varchar(150)	Yes	Document key for workflow. Combination of OUInstance and deferal request no	No
cpdfrq_stage	udd_flag	varchar(25)	Yes	Stores the workflow states.	No
cpdfrq_approved_by	udd_ctxt_user	varchar(30)	Yes	Approved by	No
cpdfrq_approved_date	_datetime_8	datetime(8)	Yes	Approved date and time	No
cpdfrq_filename	udd_filename	varchar(50)	Yes	File name	No
cpdfrq_approval_no	udd_documentno	varchar(40)	Yes	Approval number	No
cpdfrq_approval_date	_datetime_8	datetime(8)	Yes	Approval date and time	No
cpdfrq_approval_comments	udd_txt255	varchar(255)	Yes	Approval comments	No

Table Name :	CPLN_CPDFWU_DEF_WORK_UNITS
Comment :	Deferral Work Unit list.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPDFWU_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CPDFWU_SOURCE	udd_flag	varchar(25)	Yes	Source	No
CPDFWU_SRC_OU	udd_ctxt_ouinstance	int(4)	Yes	Source OU	No
CPDFWU_SOURCE_DOC_NO	udd_documentno	varchar(40)	Yes	Source Document Number	No
CPDFWU_SRC_DOC_REV_NO	udd_documentno	varchar(40)	Yes	Source document revision number	No
CPDFWU_WU_SEQ_NO	udd_seqno	int(4)	Yes	work unit sequence number	No
CPDFWU_DEF_REQ_NO	_varchar_40	varchar(40)	No	deferment request number	Yes
CPDFWU_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence Number	Yes
CPDFWU_POS_NO	_varchar_25	Varchar(25)	Yes	Position Number	No
CPDFWU_WORK_UNIT	_varchar_30	varchar(30)	Yes	Work Unit Code	No
CPDFWU_WU_REVNO	_varchar_40	varchar(40)	Yes	WorkUnit Revision no (ie) Task revision No	No
CPDFWU_WORKUNIT_OU	_decimal_10_0	decimal(10)	Yes	WorkUnit OUInstance	No
CPDFWU_WU_TYPE	_varchar_5	varchar(5)	Yes	Work Unit Type	No
CPDFWU_SCH_DATE	_datetime_8	datetime(8)	Yes	Schedule Date	No
CPDFWU_PART_NO	_varchar_40	varchar(40)	Yes	Part Number	No
CPDFWU_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number	No
CPDFWU_MAINTENANCE_TYPE	_varchar_5	varchar(5)	Yes	Maintenance Type	No
CPDFWU_DEFERRAL_TYPE	_varchar_5	varchar(5)	Yes	Deferral Type	No
CPDFWU_DEFERRAL_REASON	_varchar_25	Varchar(25)	Yes	Deferral Reason	No
CPDFWU_ACTION	_varchar_5	varchar(5)	Yes	Action	No
CPDFWU_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CPDFWU_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
CPDFWU_REG_AUTHORITY	_varchar_25	Varchar(25)	Yes	Regulatory Authority	No
CPDFWU_APPROVAL_NO	_varchar_30	varchar(30)	Yes	Approval Number	No
CPDFWU_APPROVAL_DATE	_datetime_8	datetime(8)	Yes	Approval date	No
CPDFWU_DEFERRED_BY_IN_DAYS	_decimal_28_8	decimal(28)	Yes	Deferred By in Days	No
CPDFWU_ALERT_VALUE_IN_DAYS	_decimal_28_8	decimal(28)	Yes	Alert Date	No
CPDFWU_DEFERRED_TILL_DATE	_datetime_8	datetime(8)	Yes	Deferred Till Date	No
CPDFWU_KEYCOMPONENT_ID	_varchar_40	varchar(40)	Yes	Key component Id applicable only for Removal jobs	No
CPDFWU_FLAG	_varchar_25	Varchar(25)	Yes	Stores the following values "CP" - Central planning "CMP" Component Maintenance Planning	No
CPDFWU_DEFERRED_ALERT_DATE	_datetime_8	datetime(8)	Yes	Deferred alter date	No
CPDFWU_JOBTYPE	udd_designparamcode	varchar(5)	Yes	Job type	No
CPDFWU_MODEL	udd_model	varchar(20)	Yes	Model number	No
CPDFWU_PARENTTASK	udd_documentno	varchar(40)	Yes	Parent task number	No
CPDFWU_PACKAGENO	udd_documentno	varchar(40)	Yes	Package number	No
CPDFWU_EO_NO	udd_documentno	varchar(40)	Yes	Engineering order number	No
CPDFWU_JOBID	udd_seqno	int(4)	Yes	Job ID	No
CPDFWU_SCH_RES_BASIS	udd_designparamcode	varchar(5)	Yes	Schedule reset basis	No
CPDFWU_AIRCRAFT_REGNO	udd_aircraftnumber	varchar(30)	Yes	Aircraft registration number	No
CPDFWU_JOB_STATUS	udd_docstatus	varchar(15)	Yes	Job status	No
CPDFWU_NEXT_SCH_DATE	_datetime_8	datetime(8)	Yes	Next scheduled date	No
CPDFWU_SRC_FLAG	udd_designparamcode	varchar(5)	Yes	Source flag	No
CPDFWU_DUEDATE	_datetime_8	datetime(8)	Yes	Due date	No
cpdfwu_complied_flag	udd_designparamcode	varchar(5)	Yes	Complied flag	No
CPDFWU_EXDRP_FLAG	udd_designparamcode	varchar(5)	Yes	Execution drop-out flag	No

Table Name :	cpln_cpdfwu_def_work_units_his
Comment :	Deferral work unit histroy table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cpdfwu_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
cpdfwu_source	udd_flag	varchar(25)	Yes	Source	No
cpdfwu_src_ou	udd_ctxt_ouinstance	int(4)	Yes	Source OU	No
cpdfwu_source_doc_no	udd_documentno	varchar(40)	Yes	Source Document Number	No
cpdfwu_src_doc_rev_no	udd_documentno	varchar(40)	Yes	Source document revision number	No
cpdfwu_wu_seq_no	udd_seqno	int(4)	Yes	work unit sequence number	No
cpdfwu_def_req_no	udd_documentno	varchar(40)	Yes	deferment request number	No
cpdfwu_def_req_revno	udd_revisionno	varchar(40)	Yes	Deferral revision #	No
cpdfwu_seq_no	udd_seqno	int(4)	Yes	Sequence Number	No
cpdfwu_pos_no	udd_flag	varchar(25)	Yes	Position Number	No
cpdfwu_work_unit	udd_documentno	varchar(40)	Yes	Work Unit Code	No
cpdfwu_wu_revno	udd_revisionno	varchar(40)	Yes	WorkUnit Revision no (ie) Task revision No	No
cpdfwu_workunit_ou	udd_ctxt_ouinstance	int(4)	Yes	WorkUnit OUInstance	No
cpdfwu_wu_type	udd_designparamcode	varchar(5)	Yes	Work Unit Type	No
cpdfwu_sch_date	_datetime_8	datetime(8)	Yes	Schedule Date	No
cpdfwu_part_no	udd_documentno	varchar(40)	Yes	Part Number	No
cpdfwu_serial_no	udd_documentno	varchar(40)	Yes	Serial Number	No
cpdfwu_maintenance_type	udd_designparamcode	varchar(5)	Yes	Maintenance Type	No
cpdfwu_deferral_type	udd_designparamcode	varchar(5)	Yes	Deferral Type	No
cpdfwu_deferral_reason	udd_flag	varchar(25)	Yes	Deferral Reason	No
cpdfwu_action	udd_designparamcode	varchar(5)	Yes	Action	No
cpdfwu_comments	udd_txt255	varchar(255)	Yes	Comments	No
cpdfwu_remarks	udd_txt255	varchar(255)	Yes	Remarks	No
cpdfwu_reg_authority	udd_flag	varchar(25)	Yes	Regulatory Authority	No
cpdfwu_approval_no	udd_documentno	varchar(40)	Yes	Approval Number	No
cpdfwu_approval_date	_datetime_8	datetime(8)	Yes	Approval date	No
cpdfwu_deferred_by_in_days	_decimal_28_8	decimal(28)	Yes	Deferred By in Days	No
cpdfwu_alert_value_in_days	_decimal_28_8	decimal(28)	Yes	Alert Date	No
cpdfwu_deferred_till_date	_datetime_8	datetime(8)	Yes	Deferred Till Date	No
cpdfwu_keycomponent_id	udd_documentno	varchar(40)	Yes	Key component Id applicable only for Removal jobs	No
cpdfwu_flag	udd_flag	varchar(25)	Yes	Stores the following values "CP" - Central planning "CMP" Component Maintenance Planning	No
cpdfwu_deferred_alert_date	_datetime_8	datetime(8)	Yes	Deferred alert date	No
cpdfwu_jobtype	udd_designparamcode	varchar(5)	Yes	Job type	No
cpdfwu_model	udd_model	varchar(20)	Yes	Model number	No
cpdfwu_parenttask	udd_documentno	varchar(40)	Yes	Parent task number	No
cpdfwu_packageno	udd_documentno	varchar(40)	Yes	Package number	No
cpdfwu_eo_no	udd_documentno	varchar(40)	Yes	Engineering order number	No
cpdfwu_jobid	udd_seqno	int(4)	Yes	Job ID	No
cpdfwu_sch_res_basis	udd_designparamcode	varchar(5)	Yes	Schedule reset basis	No
cpdfwu_aircraft_regno	udd_aircraftnumber	varchar(30)	Yes	Aircraft registration number	No
cpdfwu_job_status	udd_docstatus	varchar(15)	Yes	Job status	No
cpdfwu_next_sch_date	_datetime_8	datetime(8)	Yes	Next scheduled date	No
cpdfwu_src_flag	udd_designparamcode	varchar(5)	Yes	Source flag	No
cpdfwu_duedate	_datetime_8	datetime(8)	Yes	Due date	No

Table Name :	CPLN_CPICWU_SUBTSK_SNOFF
Comment :	Subtask signoff details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPICWU_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
CPICWU_JOB_ID	udd_seqno	int(4)	Yes	Job ID	No
CPICWU_TASKNO	udd_workunitcode	varchar(30)	Yes	Task number	No
CPICWU_JOB_TYPE	udd_designparamcode	varchar(5)	Yes	Job type	No
CPICWU_SUBTSK_DESC	udd_txt2000	varchar(2000)	Yes	Sub task description	No
CPICWU_SUBTASKSEQ_NO	udd_seqno	int(4)	Yes	Sub task seq number	No
CPICWU_SKILL_CODE	udd_flag	varchar(25)	Yes	Skill code	No
CPICWU_RES_GROUP	udd_flag	varchar(25)	Yes	Resourec group	No
CPICWU_SNOFF_INFO	udd_designparamcode	varchar(5)	Yes	Signoff information	No
CPICWU_EMP_NO	udd_hrempcode	varchar(20)	Yes	Employee number	No
CPICWU_SNOFF_SOURCE	udd_designparamcode	varchar(5)	Yes	Signoff source	No
CPICWU_CREATED_BY	udd_ctxt_user	varchar(30)	Yes	Created by	No
CPICWU_CREATED_DT	_datetime_8	datetime(8)	Yes	Created date	No
CPICWU_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
CPICWU_MODIFIED_DT	_datetime_8	datetime(8)	Yes	Modified date	No

Table Name :	CPLN_CPLNDC_REASON_CATEGORY
Comment :	Reason Category Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPLNDC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CPLNDC_REASON_CATEGORY	_varchar_25	Varchar(25)	No	Reason Category	Yes
CPLNDC_DESCRIPTION	_varchar_80	varchar(80)	Yes	Reason Category Description	No
CPLNDC_STATUS	_varchar_5	varchar(5)	Yes	Reason Category status - Cane be A - Active or I - Inactive	No
CPLNDC_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
CPLNDC_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created Date	No
CPLNDC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No
CPLNDC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
CPLNDC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No

Table Name :	CPLN_CPLNOP_OPTIONS_SET
Comment :	Option Setting for Central Planning Component is maintained here

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPLNOP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CPLNOP_INDEFINITE_DEF_FLAG	_varchar_5	varchar(5)	Yes	Indefinite Deferral Flag - This flag indicates if Indefinite Deferral is allowed or not. Valid values are Y - Yes and N - No	No
CPLNOP_DEF_AUTH_FLAG_AC_WU	_varchar_5	varchar(5)	Yes	Deferment Request Authorisation for Aircraft Workunits - Valid values are By Central Planner,By Visit/Central Planner, Not Required	No
CPLNOP_DEF_AUTH_FLAG_COM_WU	_varchar_5	varchar(5)	Yes	Deferment Request Authorisation for Component Workunits - Valid values are By Central Planner,By Component Planner, By Visit/Central Planner,Not Required	No
CPLNOP_AC_WU_ALLOC_REV_MET	_varchar_5	varchar(5)	Yes	Aircraft Workscope : Allocation Revision Method - Valid Values are Direct,Modification Log	No
CPLNOP_COM_WS_ALLOC_REV_MET	_varchar_5	varchar(5)	Yes	Component Workscope : Allocation Revision Method - Valid Values are Direct Modification Log	No
CPLNOP_TIME_ZONE	_varchar_5	varchar(5)	Yes	Time Zone - Valid values are GMT,Local	No
CPLNOP_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
CPLNOP_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created Date	No
CPLNOP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No
CPLNOP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified date	No
CPLNOP_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
CPLNOP_PRE_CALL_OUT	_varchar_5	varchar(5)	Yes	Auto Preclusion of Call-Outs Required - "R" Not Required - "NR"	No
CPLNOP_PRE_ONWING_JOB	_varchar_5	varchar(5)	Yes	Auto Preclusion of On-Wing Jobs Required - "R" Not Required - "NR"	No
CPLNOP_PLNHOR_JOBALLOC	_decimal_28_8	decimal(28)	Yes	Planning Horizon for Job Allocation (Days)	No
CPLNOP_AUTOINC_JOBS	_varchar_10	varchar(10)	Yes	Auto Inclusion of Jobs based Alert Date / Value Values will be "GM"- Gate Maintenance "TLG"- Technical Log "TLGM"- Technical Log & Gate maintenance	No
CPLNOP_PLNHOR_GATEPLAN	_decimal_28_8	decimal(28)	Yes	Planning Horizon for Gate Planning (Days)	No
CPLNOP_MRCAT	_varchar_25	Varchar(25)	Yes	MR Category - Quick code values defined in MR	No
CPLONP_Res_Avl_Aut_Sch	udd_designparamcode	varchar(5)	Yes	Deferment Request Authorisation for Aircraft Workunits	No
CPLONP_Avg_Pax_Load_Time	udd_leadtimeunits	varchar(25)	Yes	Average Passenger Loading Time (Minutes)	No
CPLONP_Avg_Pax_UnLoad_Time	udd_leadtimeunits	varchar(25)	Yes	Average Passenger UnLoading Time (Minutes)	No
CPLONP_Aut_Resch_Frz_Dur	udd_leadtimeunits	varchar(25)	Yes	Auto Resched. Freeze Duration (Days from current)	No
CPLONP_Resch_Horzn	udd_leadtimeunits	varchar(25)	Yes	Rescheduling Horizon (Days from current date) Mandatory field	No
CPLNOP_SUB_FLEET_SECURITY	udd_designparamcode	varchar(5)	Yes	Sub fleet security	No
CPLNOP_ALLOW_INT_OPT	_varchar_5	varchar(5)	Yes	Allow internal option	No
CPLNOP_SCHRSTBASE	udd_optionsettings	varchar(20)	Yes	Schedule reset basis	No
CPLNOP_ALLB2BDEF	udd_optionsettings	varchar(20)	Yes	Allow back to back deferral	No

Table Name :	CPLN_CPLNVC_VISIT_CATEGORY
Comment :	Visit Category Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPLNVC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CPLNVC_VISIT_CATEGORY	_varchar_25	Varchar(25)	No	Visit Category Code	Yes
CPLNVC_DESCRIPTION	_varchar_255	varchar(255)	Yes	Visit Category Description	No
CPLNVC_STATUS	_varchar_5	varchar(5)	Yes	Status of the Visit category - Can be A - Active or I - Inactive	No
CPLNVC_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
CPLNVC_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created Date	No
CPLNVC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No
CPLNVC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
CPLNVC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No

Table Name :	CPLN_CPMDLG_MODIFICATION_LOG
Comment :	If the Option setting in this component for " Aircraft / Component Workscope : Allocation Revision Method" is "Modification Log" then work units which are getting assigned to an exisiting Visit Package will be maintained in this table.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPMDLG_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUinstance	Yes
CPMDLG_VISIT_PKG_NO	_varchar_30	varchar(30)	No	Visit Package Number	Yes
CPMDLG_VP_REV_NO	_varchar_40	varchar(40)	No	Visit Package Revision no	Yes
CPMDLG_LINE_NO	_decimal_10_0	decimal(10)	No	Key SeqNo	Yes
CPMDLG_SOURCE_OU	_decimal_10_0	decimal(10)	Yes	Source OU	No
CPMDLG_SRC_DOC_TYPE	_varchar_5	varchar(5)	Yes	Source Document Type	No
CPMDLG_SRC_DOC_NO	_varchar_40	varchar(40)	Yes	Source Document Number	No
CPMDLG_SRC_REV_NO	_varchar_40	varchar(40)	Yes	Source Document Revision Number	No
CPMDLG_WU_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Work Unit Key Sequence Number	No
CPMDLG_WORK_UNIT	_varchar_30	varchar(30)	Yes	Work Unit	No
CPMDLG_WU_TYPE	_varchar_5	varchar(5)	Yes	Work Unit Type - Can be Task , Aircraft Work Package, Component Work Package or Standard Procedure Number	No
CPMDLG_CHANGE_DESC	_varchar_255	varchar(255)	Yes	Change Description - Indicates if the Work unit has been added or modified	No
CPMDLG_AIRCRAFT_REGNO	_varchar_30	varchar(30)	Yes	Aircraft Registration Number	No
CPMDLG_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Component Id	No
CPMDLG_SRCWU_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Source Seq No	No
CPMDLG_GROUNDINGDATE	_datetime_8	datetime(8)	Yes	Grounding date if chnaged	No
CPMDLG_PRIORITYNO	_decimal_10_0	decimal(10)	Yes	Priority Number	No
CPMDLG_PWCCODE	_varchar_30	varchar(30)	Yes	Primary Work Center Code	No
CPMDLG_PRIORITYOU	_decimal_10_0	decimal(10)	Yes	Priority OUInstance	No
CPMDLG_MAINTANCE_TYPE	_varchar_5	varchar(5)	Yes	Maintenance Type	No
CPMDLG_JOBTYPE	_varchar_5	varchar(5)	Yes	Job Type - "AC" Aircraft "ON" - On-Wing "CR" Component Removal	No
CPMDLG_WORKUNIT_OU	_decimal_10_0	decimal(10)	Yes	Workunit OUInstance	No
CPMDLG_WU_REV_NO	_varchar_40	varchar(40)	Yes	WorkUnit Revision No - Applicable only for Task	No
CPMDLG_PART_NO	_varchar_40	varchar(40)	Yes	Part Number	No
CPMDLG_SERIAL_NO	_varchar_40	varchar(40)	Yes	Part Serial Number	No
CPMDLG_POSITION_CODE	_varchar_25	Varchar(25)	Yes	Position Code to which Component is attached	No
CPMDLG_WORK_CENTER	_varchar_30	varchar(30)	Yes	Work Unit level Work Center	No
CPMDLG_ELAPSED_TIMEUOM	_varchar_5	varchar(5)	Yes	Elapsed Time UOM	No
CPMDLG_EST_ELASPED_TIME	_decimal_28_8	decimal(28)	Yes	Estimated Elapsed Time	No
CPMDLG_EST_MAN_HRS	_decimal_28_8	decimal(28)	Yes	Estimated Man hours	No
CPMDLG_SCH_DATE	_datetime_8	datetime(8)	Yes	Schedule date	No
CPMDLG_ATA_NO	_varchar_16	varchar(16)	Yes	ATA Chapter	No

Table Name :	CPLN_CPMLGD_MOD_LOG_HDR
Comment :	If the Revision Option in Option setting is Modification Log all changes to the visit package created by the Central Planner will be maintained here.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPMLGD_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUinstance	Yes
CPMLGD_VISIT_PKG_NO	_varchar_40	varchar(40)	No	Visit Package Number	Yes
CPMLGD_VP_REV_NO	_varchar_40	varchar(40)	No	Visit package revision number	Yes
CPMLGD_CHANGE_COUNT	_decimal_10_0	decimal(10)	Yes	Total number of change descriptions	No

Table Name :	CPLN_CPPLMAH_MAT_REQ_HDR
Comment :	Material request header table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPPLMAH_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	No
CPPLMAH_MRNO	_varchar_40	varchar(40)	No	Material request number	No
CPPLMAH_TYPE	_varchar_5	varchar(5)	Yes	Type	No
CPPLMAH_CLASS	_varchar_5	varchar(5)	Yes	Class	No
CPPLMAH_STATUS	_varchar_5	varchar(5)	Yes	Status	No
CPPLMAH_CATEGORY	_varchar_25	Varchar(25)	Yes	Category	No
CPPLMAH_PRIORITY	_varchar_5	varchar(5)	Yes	Priority	No
CPPLMAH_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
CPPLMAH_ACREG_NO	_varchar_30	varchar(30)	Yes	Aircraft registration number	No
CPPLMAH_createddate	_datetime_8	datetime(8)	Yes	Created date	No
CPPLMAH_mrtmp_task_identity	udd_seqno	int(4)	Yes	Task identity number	No

Table Name :	CPLN_CPPMPA_MR_PART_DTL
Comment :	Material request part details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPPMPA_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUinstance	No
CPPMPA_MRNO	_varchar_40	varchar(40)	No	Material request number	No
CPPMPA_LINENO	_decimal_10_0	decimal(10)	No	Material request line number	No
CPPMPA_KEY_SEQNO	_decimal_10_0	decimal(10)	Yes	Key sequence number	No
CPPMPA_PARTOU	_decimal_10_0	decimal(10)	Yes	Part No Ouinstance	No
CPPMPA_PARTNO	_varchar_40	varchar(40)	Yes	Part number	No
CPPMPA_STCK_STS	_varchar_25	Varchar(25)	Yes	Stock status	No
CPPMPA_REQST_QTY	_decimal_28_8	decimal(28)	Yes	Requested quantity	No
CPPMPA_MR_QTY	_decimal_28_8	decimal(28)	Yes	MR quantity	No
CPPMPA_NEEDDT	_datetime_8	datetime(8)	Yes	Need date	No
CPPMPA_WAREHOUSE	_varchar_30	varchar(30)	Yes	Warehouse	No
CPPMPA_PLNHOR	_decimal_28_8	decimal(28)	Yes	Planning Horizon	No
CPPMPA_REMARKS	_varchar_255	varchar(255)	Yes	Remarks	No
CPPMPA_Wrkidenno	udd_seqno	int(4)	Yes	Work identification number	No

Table Name :	CPLN_CPPMWU_MR_WUDTL
Comment :	Materail request workunit details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPPMWU_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUinstance	No
CPPMWU_MRNO	_varchar_40	varchar(40)	No	Material request number	No
CPPMWU_MRNOHIDE	_varchar_40	varchar(40)	Yes	Hidden MR number	No
CPPMWU_KEY_SEQNO	_decimal_10_0	decimal(10)	Yes	Key sequence number	No
CPPMWU_SOURCE	_varchar_25	Varchar(25)	Yes	Source	No
CPPMWU_SRCDOCNO	_varchar_40	varchar(40)	Yes	Source document number	No
CPPMWU_SRCDOCREV	_varchar_40	varchar(40)	Yes	Source document revision number	No
CPPMWU_WUSEQNO	_decimal_10_0	decimal(10)	Yes	workunit sequence number	No
CPPMWU_WUTYPE	_varchar_5	varchar(5)	Yes	workunit type	No
CPPMWU_SWP_NO	_varchar_30	varchar(30)	Yes	swp number	No
CPPMWU_SWP_SEQNO	_decimal_10_0	decimal(10)	Yes	swp sequence number	No
CPPMWU_SP_NO	_varchar_30	varchar(30)	Yes	Stored procedure number	No
CPPMWU_SP_SEQNO	_decimal_10_0	decimal(10)	Yes	Sp sequence number	No
CPPMWU_TASKNO	_varchar_30	varchar(30)	Yes	Task number	No
CPPMWU_MAINTTYPE	_varchar_5	varchar(5)	Yes	Maintenace type	No
CPPMWU_JOBTYPE	_varchar_5	varchar(5)	Yes	Job type	No
CPPMWU_wrkidenno	udd_seqno	int(4)	Yes	work identification number	No
CPPMWU_COMPOU	udd_ctxt_ouinstance	int(4)	Yes	component ouinstance	No
CPPMWU_COMPONENTID	udd_componentid	varchar(90)	Yes	Component id	No
CPPMWU_PACKAGENO	udd_documentno	varchar(40)	Yes	Package number	No

Table Name :	CPLN_CPPSV_PARAM_SCH_VAL
Comment :	When the work units of the released Forecast, EO , FCD are maintained in the due table, the corresponding parameter details (ie) schedule details are maintained in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPPSV_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	Yes
CPPSV_SOURCE	_varchar_25	Varchar(25)	No	Source updated from Forecast/EO/FCD	Yes
CPPSV_SRC_OU	_decimal_10_0	decimal(10)	No	Source OUInstance updated from Forecast/EO/FCD	Yes
CPPSV_SOURCE_DOC_NO	_varchar_40	varchar(40)	No	Source document number updated from Forecast/EO/FCD	Yes
CPPSV_SRC_DOC_REV_NO	_varchar_40	varchar(40)	No	Source document revision number updated from Forecast/EO/FCD	No
CPPSV_WU_SEQ_NO	_decimal_10_0	decimal(10)	No	Source seq number updated from Forecast/EO/FCD	Yes
CPPSV_AC_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number	Yes
CPPSV_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter Code	Yes
CPPSV_WU_LINENO	_decimal_10_0	decimal(10)	No	WorkUnit LineNo	Yes
CPPSV_PARAM_OU	_decimal_10_0	decimal(10)	Yes	Parameter OUInstance	No
CPPSV_MAINT_PROGRAM_NO	_varchar_40	varchar(40)	No	Maintenance Program Code	Yes
CPPSV_MP_REV_NO	_varchar_40	varchar(40)	No	MP Revision Number	Yes
CPPSV_SCH_VAL	_decimal_28_8	decimal(28)	Yes	Schedule Value for the Parameter Code	No
CPPSV_ALERT_VAL	_decimal_28_8	decimal(28)	Yes	Alert Value for the Parameter Code	No
CPPSV_EARLIEST_SCH_VAL	_decimal_28_8	decimal(28)	Yes	Earliest schedule Value	No
CPPSV_LATEST_SCH_VAL	_decimal_28_8	decimal(28)	Yes	Latest Schedule value	No

Table Name :	CPLN_CPPSV_PARAM_SCH_VAL_NEW
Comment :	When the work units of the released Forecast, EO , FCD are maintained in the due table,The corresponding parameter details (ie) schedule details are maintained in this table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPPSV_OUINSTANCE	_decimal_10_0	decimal(10)	No	OUInstance	No
CPPSV_SOURCE	_varchar_25	Varchar(25)	No	Source updated from Forecast/EO/FCD	No
CPPSV_SRC_OU	_decimal_10_0	decimal(10)	No	Source OUInstance updated from Forecast/EO/FCD	No
CPPSV_SOURCE_DOC_NO	_varchar_40	varchar(40)	No	Source document number updated from Forecast/EO/FCD	No
CPPSV_SRC_DOC_REV_NO	_varchar_40	varchar(40)	No	Source document revision number updated from Forecast/EO/FCD	No
CPPSV_WU_SEQ_NO	_decimal_10_0	decimal(10)	No	Source seq number updated from Forecast/EO/FCD	No
CPPSV_AC_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number	No
CPPSV_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter Code	No
CPPSV_WU_LINENO	_decimal_10_0	decimal(10)	No	WorkUnit LineNo	No
CPPSV_PARAM_OU	_decimal_10_0	decimal(10)	Yes	Parameter OUInstance	No
CPPSV_MAINT_PROGRAM_NO	_varchar_40	varchar(40)	No	Maintenance Program Code	No
CPPSV_MP_REV_NO	_varchar_40	varchar(40)	No	MP Revision Number	No
CPPSV_SCH_VAL	_decimal_28_8	decimal(28)	Yes	Schedule Value for the Parameter Code	No
CPPSV_ALERT_VAL	_decimal_28_8	decimal(28)	Yes	Alert Value for the Parameter Code	No
CPPSV_EARLIEST_SCH_VAL	_decimal_28_8	decimal(28)	Yes	Earliest schedule Value	No
CPPSV_LATEST_SCH_VAL	_decimal_28_8	decimal(28)	Yes	Latest Schedule value	No

Table Name :	CPLN_CPSRCH_SEARCH_ID_MASTER
Comment :	User customized search option master.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPSRCH_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CPSRCH_SEARCH_ID	_varchar_30	varchar(30)	No	Search Id.	Yes
CPSRCH_USER_ID	_varchar_30	varchar(30)	No	User Id who has created the search id	Yes
CPSRCH_REMAINING_FH	_decimal_28_8	decimal(28)	Yes	Remaining Flight Hours Value	No
CPSRCH_REMAINING_FC	_decimal_28_8	decimal(28)	Yes	Remaining Flight Cycles Value	No
CPSRCH_ATA_NO	_varchar_16	varchar(16)	Yes	ATA Number	No
CPSRCH_ZONE_CODE	_varchar_15	varchar(15)	Yes	Zone Code	No
CPSRCH_COMPONENT_FAMILY	_varchar_25	Varchar(25)	Yes	Component Family Code	No
CPSRCH_PART_NO	_varchar_40	varchar(40)	Yes	Part Number	No
CPSRCH_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number	No
CPSRCH_WU_TYPE	_varchar_5	varchar(5)	Yes	Work Unit Type	No
CPSRCH_POSITION_TYPE	_varchar_5	varchar(5)	Yes	Position Type	No
CPSRCH_MCR_DOC_TYPE	_varchar_15	varchar(15)	Yes	MAintenance Change Request Number	No
CPSRCH_POSITION_CODE	_varchar_25	Varchar(25)	Yes	Position Code	No
CPSRCH_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created Date	No
CPSRCH_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No

Table Name :	CPLN_CPWUDU_WORKUNITS_DUE
Comment :	Central repository where all work units of the released Forecast, EO , FCD and component on wing jobs and component removal jobs will be maintained.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPWUDU_OUINSTANCE	_decimal_10_0	decimal(10)	No	ouinstance	No
CPWUDU_SOURCE	_varchar_25	Varchar(25)	No	Source can be FCD or EO or Aircraft Forecast or Component Forecast	No
CPWUDU_SRC_OU	_decimal_10_0	decimal(10)	No	source ou	No
CPWUDU_SOURCE_DOC_NO	_varchar_40	varchar(40)	No	Source Doc number can be FCD or EO or Aircraft Forecast or Component Forecast number	No
CPWUDU_SRC_DOC_REV_NO	_varchar_40	varchar(40)	No	Revision number of the source document number	No
CPWUDU_WORKUNIT	_varchar_30	varchar(30)	No	Work Unit to be perfomed.Can be a Task or a Procedure or a Standard Work Package	No
CPWUDU_WU_SEQ_NO	_decimal_10_0	decimal(10)	No	work unit sequence number	No
CPWUDU_ENTITY_SEQ_NO	_decimal_10_0	decimal(10)	No	entity sequence number.	No
CPWUDU_WU_TYPE	_varchar_5	varchar(5)	Yes	Work Unit Type Can be a Task or a Procedure or a Standard Work Package	No
CPWUDU_TASK_REV_NO	_varchar_40	varchar(40)	Yes	task revision number	No
CPWUDU_LATEST_COMPL_DATE	_datetime_8	datetime(8)	Yes	Lastest Compliance Date	No
CPWUDU_ALERT_DATE	_datetime_8	datetime(8)	Yes	Alert Date	No
CPWUDU_EARLIEST_COMPL_DATE	_datetime_8	datetime(8)	Yes	earliest compliance date	No
CPWUDU_WORK_CENTER	_varchar_30	varchar(30)	Yes	Work Center Code	No
CPWUDU_WC_OU	_decimal_10_0	decimal(10)	Yes	work centre ouinstance	No
CPWUDU_EST_MAN_HRS	_decimal_28_8	decimal(28)	Yes	Estimated Man hours for the Work Unit	No
CPWUDU_EST_ELASPED_TIME	_decimal_28_8	decimal(28)	Yes	Estimated Elasped Time	No
CPWUDU_ELASPED_TIMEUOM	_varchar_5	varchar(5)	Yes	Elapsed Time UOM	No
CPWUDU_COMPONENT_ID	_varchar_90	varchar(90)	Yes	Component Id - This with be populated if the source is component Forecast	No
CPWUDU_PART_NO	_varchar_40	varchar(40)	Yes	Part number of the Component Id	No
CPWUDU_SERIAL_NO	_varchar_40	varchar(40)	Yes	Serial Number of the Part	No
CPWUDU_AIRCRAFT_REG_NO	_varchar_30	varchar(30)	No	Aircraft Registration Number	Yes
CPWUDU_AC_OU	_decimal_10_0	decimal(10)	Yes	aircraft ou	No
CPWUDU_TRANS_STATUS	_varchar_5	varchar(5)	Yes	Deferral Falg - Will be Y - Yes if deferred else will be N - No	No
CPWUDU_JOB_STATUS	_varchar_5	varchar(5)	Yes	Job Status	No
CPWUDU_VISIT_PACKAGE_NO	_varchar_40	varchar(40)	Yes	Visit Package number if assigned.	No
CPWUDU_VP_REV_NO	_varchar_40	varchar(40)	Yes	visit package revision number	No
CPWUDU_VP_OU	_decimal_10_0	decimal(10)	Yes	visit package ou	No
CPWUDU_JOB_TYPE	_varchar_5	varchar(5)	Yes	job type	No
CPWUDU_MAINTENANCE_TYPE	_varchar_5	varchar(5)	Yes	Maitenance Type	No
CPWUDU_MP_NO	_varchar_30	varchar(30)	Yes	Maintenance Program Number	No
CPWUDU_MP_REV_NO	_varchar_40	varchar(40)	Yes	Maintenance Program revision number	No
CPWUDU_MP_OU	_decimal_10_0	decimal(10)	Yes	Maintenance Program OUInstance	No
CPWUDU_MP_WU_SEQNO	_decimal_10_0	decimal(10)	Yes	Maintenance Program WorkUnit SeqNo	No
CPWUDU_ATA_NO	_varchar_16	varchar(16)	Yes	ATA Chapter	No
CPWUDU_ZONE_CODE	_varchar_15	varchar(15)	Yes	Zone Code	No
CPWUDU_WORKUNIT_OU	_decimal_10_0	decimal(10)	Yes	WorkUnit OUInstance	No
CPWUDU_TURNAROUND_TIME	_decimal_28_8	decimal(28)	Yes	Turn Around Time Maintenance Program revision number	No
CPWUDU_PREPERATORY_TIME	_decimal_28_8	decimal(28)	Yes	Preparatory Time updated from Maintenance Forcast	No
CPWUDU_LEVEL_CODE	_varchar_150	varchar(150)	Yes	Level Code in the Configuration	No
CPWUDU_EXECUTION_TYPE	_varchar_5	varchar(5)	Yes	Execution Type Major and Minor	No
CPWUDU_POSITION_CODE	_varchar_25	Varchar(25)	Yes	Position Code in the configuration	No
CPWUDU_CYCLE_NO	_varchar_6	varchar(6)	Yes	Cycle No updated from Maintenance Forecast	No
CPWUDU_SCH_NO	_varchar_6	varchar(6)	Yes	Schudule No updated from Maintenance Forecast	No
CPWUDU_EXPENSE_TYPE	_varchar_5	varchar(5)	Yes	Expense type - "REV" Revenue "CAP" Capital	No
CPWUDU_SCH_DATE	_datetime_8	datetime(8)	Yes	Schedule Date	No
CPWUDU_PLAN_START_DATE	_datetime_8	datetime(8)	Yes	Plan start date captured in Allocate workuint page	No
CPWUDU_PLAN_END_DATE	_datetime_8	datetime(8)	Yes	Plan end date captured in Allocate workuint page	No
CPWUDU_HOURS_PER_DAY	_decimal_28_8	decimal(28)	Yes	Hours / Day	No
CPWUDU_TRIGG_PARAMETER	_varchar_40	varchar(40)	Yes	Triggering parameter updated from Forecast/EO/FCD	No
CPWUDU_UPDATE_SCH	_varchar_25	Varchar(25)	Yes	Update Scheduling - "Y" - Yes "N" - No	No
CPWUDU_LP_OU	udd_ctxt_ouinstance	int(4)	Yes	OU on which the Line package has been created	No
CPWUDU_LINE_PACKAGE	udd_documentno	varchar(40)	Yes	Line package Number	No
CPWUDU_LP_LINENO	_decimal_10_0	decimal(10)	Yes	Seq Number for Line package workunits	No
CPWUDU_PlngSts	_varchar_40	varchar(40)	Yes	Planning status	No
CPWUDU_PLAN_BASIS	_varchar_25	Varchar(25)	Yes	Values will be "Automatic" , "Must Do" , "On or Before"	No
CPWUDU_GREENTIMESTATUS	_varchar_5	varchar(5)	Yes	Static values - Pre, Yes or Post. If Planned Start Date is prior to Earliest Scheduled Date - Pre If Planned Start Date is between Earliest Scheduled Date and Alert Date - Yes If Planned Start Date falls after Alert Date - Post	No
CPWUDU_CAPACITY_CHECK	_varchar_25	Varchar(25)	Yes	Whether capacity check required or not YES / NO	No
CPLN_CPWUDU_PLANNING_COMMENTS	udd_txt255	varchar(255)	Yes	Planning comments	No
CPWUDU_EO_NO	udd_documentno	varchar(40)	Yes	Engineering order number	No
CPWUDU_EO_TYPE	udd_flag	varchar(25)	Yes	Engineering order type	No
CPWUDU_MPD_GROUP	udd_flag	varchar(25)	Yes	MPD group number	No
CPWUDU_PROGITEM_TYPE	udd_designparamcode	varchar(5)	Yes	Program type	No
CPWUDU_DEF_EXEPRI	udd_priority	varchar(12)	Yes	Defferal priority	No
CPWUDU_INIRES_BY	udd_designparamcode	varchar(5)	Yes	Initiated by	No
CPWUDU_DUEFH	udd_numericparamval	numeric(13)	Yes	Due flight hours	No
CPWUDU_DUEFC	udd_numericparamval	numeric(13)	Yes	Due flight cycles	No
CPWUDU_INTERVAL_FH	udd_numericparamval	numeric(13)	Yes	Interval flight hour	No
CPWUDU_INTERVAL_FC	udd_numericparamval	numeric(13)	Yes	interval flight cycle	No
CPWUDU_EO_REVNO	udd_revisionno	varchar(40)	Yes	Engineering order revision number	No
CPWUDU_AIRCRAFT_MODEL	udd_model	varchar(20)	Yes	Aircraft model number	No
CPWUDU_AIRCRAFT_GROUP	_varchar_100	varchar(100)	Yes	Aircraft group	No
CPWUDU_SUBFLEET	_varchar_100	varchar(100)	Yes	Subfleet number	No
CPWUDU_FIELD_BASE	udd_taskcode	varchar(30)	Yes	Field base	No
CPWUDU_CUSTOMER	udd_vendorcode	varchar(45)	Yes	Customer	No
CPWUDU_PLNR_GROUP	_varchar_100	varchar(100)	Yes	Planner group	No
CPWUDU_JOB_ID	_numeric_10_0	numeric(10)	No	Job id	Yes
CPWUDU_INSTANCE_NO	udd_count	int(4)	Yes	Instance number	No
cpwudu_Parent_item	_varchar_100	varchar(100)	Yes	Parent item	No
cpwudu_root_task	udd_taskcode	varchar(30)	Yes	Root task number	No
CPWUDU_REM_FC	udd_numericparamval	numeric(13)	Yes	Remaining Flight Cycle	No
CPWUDU_REM_FH	udd_numericparamval	numeric(13)	Yes	Remaining flight hour	No
CPWUDU_ALLOC_DOCTYPE	udd_designparamcode	varchar(5)	Yes	Allocation document type	No
CPWUDU_DEF_REQ_NO	udd_documentno	varchar(40)	Yes	Deferrel request number	No
CPWUDU_REM_DAYS	udd_numericparamval	numeric(13)	Yes	Remaining days	No
Cpwudu_refc_date	_datetime_8	datetime(8)	Yes	Reforcasted date	No
cpwudu_interval_cal	udd_duration	numeric(13)	Yes	Calendar interval	No
cpwudu_interval_uom	udd_designparamcode	varchar(5)	Yes	Interval Unit of measurement	No
CPWUDU_TRGPARRM_REMVALUE	udd_numericparamval	numeric(13)	Yes	Triggering parameter remaining value	No
CPWUDU_TRGPARRM_DUEVALUE	udd_numericparamval	numeric(13)	Yes	Triggering parameter due value	No
CPWUDU_EAR_BLKTASK	udd_workunitcode	varchar(30)	Yes	Block Task	No
CPWUDU_INCOMPLETE_DOCNO	udd_documentno	varchar(40)	Yes	Incomplete document number	No
CPWUDU_INCOMPLETE_FLAG	udd_designparamcode	varchar(5)	Yes	Incomplete flag	No
CPWUDU_INCMPACSTDT	_datetime_8	datetime(8)	Yes	Incomplete date	No
cpwudu_package_type	udd_flag	varchar(25)	Yes	Package type	No

Table Name :	CPLN_CPWUUS_WU_USAGE_SCH
Comment :	Deferral Limits for the Work Units

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPWUUS_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	Yes
CPDFWU_SOURCE	udd_flag	varchar(25)	Yes	Source	No
CPDFWU_SRC_OU	udd_ctxt_ouinstance	int(4)	Yes	Source OU	No
CPDFWU_SOURCE_DOC_NO	udd_documentno	varchar(40)	Yes	Source Document Number	No
CPWUUS_SRC_DOC_REV_NO	udd_documentno	varchar(40)	Yes	Source document revision number	No
CPDFWU_WU_SEQ_NO	udd_seqno	int(4)	Yes	work unit sequence number	No
CPWUUS_DEF_REQ_NO	_varchar_40	varchar(40)	No	deferment request number	Yes
CPWUUS_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence Number	Yes
CPWUUS_PARAM_CODE	_varchar_40	varchar(40)	No	Parameter Code	Yes
CPWUUS_ALERT_VALUE	_decimal_28_8	decimal(28)	Yes	Alert Value	No
CPWUUS_DEFERRED_BY	_decimal_28_8	decimal(28)	Yes	Deferred By Value	No
CPWUUS_DEFERRED_TILL	_datetime_8	datetime(8)	Yes	Deferred Till Value	No
CPWUUS_PARAM_OU	_decimal_10_0	decimal(10)	Yes	Parameter OUInstance	No
CPWUUS_ALERT_DATE	_datetime_8	datetime(8)	Yes	Work unit schedule alert Date	No
CPWUUS_SCH_VALUE	_decimal_28_8	decimal(28)	Yes	Shedules value	No
CPWUUS_REV_DUE_VAL	udd_numericparamval	numeric(13)	Yes	Revision due value	No
CPWUUS_JOB_ID	udd_seqno	int(4)	Yes	Job id	No

Table Name :	cpln_cpwuus_wu_usage_sch_his
Comment :	Work unit usage search histroy table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
cpwuus_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
cpdfwu_source	udd_flag	varchar(25)	Yes	Source	No
cpdfwu_src_ou	udd_ctxt_ouinstance	int(4)	Yes	Source OU	No
cpdfwu_source_doc_no	udd_documentno	varchar(40)	Yes	Source Document Number	No
cpwuus_src_doc_rev_no	udd_documentno	varchar(40)	Yes	Source document revision number	No
cpdfwu_wu_seq_no	udd_seqno	int(4)	Yes	Work unit sequence number	No
cpwuus_def_req_no	udd_documentno	varchar(40)	Yes	Deferment request number	No
cpwuus_def_req_revno	udd_revisionno	varchar(40)	Yes	Deferral request revision #	No
cpwuus_seq_no	udd_seqno	int(4)	Yes	Sequence Number	No
cpwuus_param_code	udd_documentno	varchar(40)	Yes	Parameter Code	No
cpwuus_alert_value	_decimal_28_8	decimal(28)	Yes	Alert Value	No
cpwuus_deferred_by	_decimal_28_8	decimal(28)	Yes	Deferred By Value	No
cpwuus_deferred_till	_datetime_8	datetime(8)	Yes	Deferred Till Value	No
cpwuus_param_ou	udd_ctxt_ouinstance	int(4)	Yes	Parameter OUInstance	No
cpwuus_alert_date	_datetime_8	datetime(8)	Yes	Work unit schedule alert Date	No
cpwuus_sch_value	_decimal_28_8	decimal(28)	Yes	Shedules value	No
cpwuus_rev_due_val	udd_numericparamval	numeric(13)	Yes	Revision due value	No

Table Name :	CPLN_DISCMAIN_OPT_SET
Comment :	Table for option setting changes for Central Planning Discrepancy optioins

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Disc_SetOpt_Desc	_varchar_5	varchar(5)	Yes	Allow Description change?	No
Disc_SetOpt_Ata	_varchar_5	varchar(5)	Yes	Allow ATA number change?	No
Disc_SetOpt_Fault	_varchar_5	varchar(5)	Yes	Allow Fault number change?	No
Disc_SetOpt_Remedy	_varchar_5	varchar(5)	Yes	Allow Remedy change?	No
Disc_SetOpt_Catg	_varchar_5	varchar(5)	Yes	Allow Category change?	No
Disc_SetOpt_TracSta	_varchar_5	varchar(5)	Yes	Allow Allow tracking status change? change?	No
Disc_SetOpt_RptBy	_varchar_5	varchar(5)	Yes	Allow Reported by change?	No
Disc_SetOpt_Rmks	_varchar_5	varchar(5)	Yes	Allow Remarks change?	No
Disc_SetOpt_DefTyp	_varchar_5	varchar(5)	Yes	Allow Deferral type change?	No
Disc_SetOpt_DefItm	_varchar_5	varchar(5)	Yes	Allow Defferal item change?	No
Disc_SetOpt_LogLeaf	_varchar_5	varchar(5)	Yes	Allow Logleaf change?	No
Disc_SetOpt_Created_by	udd_ctxt_user	varchar(30)	Yes	Allow Created by change?	No
Disc_SetOpt_Created_Dt	_datetime_8	datetime(8)	Yes	Allow Created date change?	No
Disc_SetOpt_Modified_by	udd_ctxt_user	varchar(30)	Yes	Allow Modified by change?	No
Disc_SetOpt_Modified_Dt	_datetime_8	datetime(8)	Yes	Allow Modified date change?	No
Disc_SetOpt_Auth_RefNo	udd_designparamcode	varchar(5)	Yes	Allow Auth reference number change?	No
Disc_SetOpt_Reported_Date	udd_designparamcode	varchar(5)	Yes	Allow Reported date change?	No
Disc_SetOpt_Reported_Time	udd_designparamcode	varchar(5)	Yes	Allow Reported time change?	No
Disc_SetOpt_Closed_Date	udd_designparamcode	varchar(5)	Yes	Allow closed date change?	No
Disc_SetOpt_Closed_Time	udd_designparamcode	varchar(5)	Yes	Allow closed time change?	No
Disc_SetOpt_Recurring	udd_designparamcode	varchar(5)	Yes	Allow Recurring flag change?	No
Disc_SetOpt_Action	udd_designparamcode	varchar(5)	Yes	Allow Action flag change?	No
Disc_SetOpt_Casdly	udd_designparamcode	varchar(5)	Yes	Allow cause delay change?	No
Disc_SetOpt_Incrpt	udd_designparamcode	varchar(5)	Yes	Allow incident reported change?	No
Disc_SetOpt_Invfnd	udd_designparamcode	varchar(5)	Yes	Allow investigation findings change?	No
Disc_SetOpt_Invcln	udd_designparamcode	varchar(5)	Yes	Allow investigation conclusion change?	No

Table Name :	Cpln_Mnt_Quick_Code
Comment :	Maintenance quick code details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPLN_OUINSTANCE	_decimal_10_0	decimal(10)	No	Ouinstance	No
CPLN_QCTYPE	_varchar_5	varchar(5)	No	Qctype	No
CPLN_QUICK_CODE	_varchar_25	Varchar(25)	No	Quick code	No
CPLN_DESCRIPTION	_varchar_150	varchar(150)	Yes	Description	No
CPLN_STATUS	_varchar_5	varchar(5)	Yes	Status	No
CPLN_CREATED_BY	_varchar_30	varchar(30)	Yes	Created by	No
CPLN_CREATIONDATE	_datetime_8	datetime(8)	Yes	created date	No
CPLN_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by	No
CPLN_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	modified date	No
CPLN_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No

Table Name :	CPLN_PARAMETER_DETAILS
Comment :	Meta Data Table for Central Planning

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
CPLN_COMPONENTNAME	_varchar_25	Varchar(25)	No	Component Name	Yes
CPLN_PARAMCATEGORY	_varchar_25	Varchar(25)	No	Parameter Category	Yes
CPLN_PARAMTYPE	_varchar_25	Varchar(25)	No	Parameter Type	Yes
CPLN_PARAMCODE	_varchar_25	Varchar(25)	No	Parameter Code	Yes
CPLN_PARAMDESC	_varchar_150	varchar(150)	Yes	Parameter Description	No
CPLN_LANGID	_decimal_10_0	decimal(10)	Yes	Language Id	No
CPLN_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
CPLN_SORTBY	_decimal_10_0	decimal(10)	Yes	Sort By	No