| Central
Planning |
|
| Table
Name cpln_cpafb_ac_field_base |
|
|
| Table 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 |
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cpafb_ouinstance |
numeric(10) |
NOT NULL |
Login OUInstance |
Yes |
No |
| cpafb_aircraft_reg_no |
varchar(30) |
NOT NULL |
Aircraft Registration Number |
Yes |
No |
| cpafb_start_date |
datetime |
NOT NULL |
Start date when not entered
store the default value ’01/01/1900’ |
Yes |
No |
| cpafb_aircraft_ou |
numeric(10) |
NULL |
Aircraft Registration OUInstance |
No |
No |
| cpafb_serial_no |
varchar(40) |
NULL |
Manufacturer Serial # of the
Aircraft. |
No |
No |
| cpafb_fieldbase |
varchar(30) |
NULL |
Work Center Code |
No |
No |
| cpafb_fieldbase_ou |
numeric(10) |
NULL |
Work Center OUInstance |
No |
No |
| cpafb_end_date |
datetime |
NULL |
End date |
No |
No |
| cpafb_call_sign |
varchar(30) |
NULL |
Call sign if entered |
No |
No |
| cpafb_contract_no |
varchar(40) |
NULL |
Contract # if entered |
No |
No |
| cpafb_customer_no |
varchar(18) |
NULL |
Customer # if entered |
No |
No |
| cpafb_customer_ou |
numeric(10) |
NULL |
Customer OUInstance if valid
Customer # is entered |
No |
No |
| cpafb_oper_loc |
varchar(30) |
NULL |
Operational Location if entered |
No |
No |
| cpafb_timestamp |
numeric(10) |
NULL |
Timestamp |
No |
No |
| cpafb_created_by |
varchar(30) |
NULL |
Created User id |
No |
No |
| cpafb_created_date |
datetime |
NULL |
Created Date |
No |
No |
| cpafb_modified_by |
varchar(30) |
NULL |
Modified user id |
No |
No |
| cpafb_modified_date |
datetime |
NULL |
Modified date |
No |
No |
|
| Table
Name cpln_cpdfrq_deferral_req |
|
|
| Table
Comment Deferrals created in Central Planning |
|
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cpdfrq_ouinstance |
numeric(10) |
NOT NULL |
Ouinstance |
Yes |
No |
| cpdfrq_def_req_no |
varchar(40) |
NOT NULL |
deferment request number |
Yes |
No |
| cpdfrq_num_type_no |
varchar(5) |
NULL |
Numbering type number |
No |
No |
| cpdfrq_aircraft_reg_no |
varchar(30) |
NULL |
Aircraft Registration Number |
No |
No |
| cpdfrq_job_type |
varchar(5) |
NULL |
Job Type - Aircraft or Component
Removal or On WIng |
No |
No |
| cpdfrq_work_centre |
varchar(30) |
NULL |
Work Centre |
No |
No |
| cpdfrq_component_id |
varchar(90) |
NULL |
Component Id |
No |
No |
| cpdfrq_status |
varchar(5) |
NULL |
Deferment Request Status |
No |
No |
| cpdfrq_requestor_code |
varchar(15) |
NULL |
Reuestor’s employee code |
No |
No |
| cpdfrq_email |
varchar(70) |
NULL |
Email id |
No |
No |
| cpdfrq_phone_no |
varchar(70) |
NULL |
Work Phonw Number |
No |
No |
| cpdfrq_created_by |
varchar(30) |
NULL |
Created By |
No |
No |
| cpdfrq_createddate |
datetime |
NULL |
Created Date |
No |
No |
| cpdfrq_modified_by |
varchar(30) |
NULL |
Last Modified By |
No |
No |
| cpdfrq_modifieddate |
datetime |
NULL |
Last Modified Date |
No |
No |
| cpdfrq_confirmed_by |
varchar(30) |
NULL |
Confirmed By UserId |
No |
No |
| cpdfrq_confirmeddate |
datetime |
NULL |
Confirmed date |
No |
No |
| cpdfrq_timestamp |
numeric(10) |
NULL |
Timestamp |
No |
No |
| cpdfrq_dockey |
varchar(128) |
NULL |
Document key for workflow.
Combination of OUInstance and  deferal request no |
No |
No |
| cpdfrq_stage |
varchar(25) |
NULL |
Stores the workflow states. |
No |
No |
|
| Table
Name cpln_cpdfwu_def_work_units |
|
|
| Table
Comment Deferral Work Unit list. |
|
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cpdfwu_ouinstance |
numeric(10) |
NOT NULL |
Ouinstance |
Yes |
Yes |
| cpdfwu_source |
varchar(25) |
NOT NULL |
Source |
Yes |
No |
| cpdfwu_src_ou |
numeric(10) |
NOT NULL |
Source OU |
Yes |
No |
| cpdfwu_source_doc_no |
varchar(40) |
NOT NULL |
Source Document Number |
Yes |
No |
| cpdfwu_src_doc_rev_no |
varchar(40) |
NOT NULL |
Source document revision number |
Yes |
No |
| cpdfwu_wu_seq_no |
numeric(10) |
NOT NULL |
work unit sequence number |
Yes |
No |
| cpdfwu_def_req_no |
varchar(40) |
NOT NULL |
deferment request number |
Yes |
Yes |
| cpdfwu_seq_no |
numeric(10) |
NOT NULL |
Sequence Number |
Yes |
No |
| cpdfwu_pos_no |
varchar(25) |
NULL |
Position Number |
No |
No |
| cpdfwu_work_unit |
varchar(30) |
NULL |
Work Unit Code |
No |
No |
| cpdfwu_wu_revno |
varchar(40) |
NULL |
WorkUnit Revision no (ie) Task
revision No |
No |
No |
| cpdfwu_workunit_ou |
numeric(10) |
NULL |
WorkUnit OUInstance |
No |
No |
| cpdfwu_wu_type |
varchar(5) |
NULL |
Work Unit Type |
No |
No |
| cpdfwu_sch_date |
datetime |
NULL |
Schedule Date |
No |
No |
| cpdfwu_part_no |
varchar(40) |
NULL |
Part Number |
No |
No |
| cpdfwu_serial_no |
varchar(40) |
NULL |
Serial Number |
No |
No |
| cpdfwu_maintenance_type |
varchar(5) |
NULL |
Maintenance Type |
No |
No |
| cpdfwu_deferral_type |
varchar(5) |
NULL |
Deferral Type |
No |
No |
| cpdfwu_deferral_reason |
varchar(25) |
NULL |
Deferral Reason |
No |
No |
| cpdfwu_action |
varchar(5) |
NULL |
Action |
No |
No |
| cpdfwu_comments |
varchar(255) |
NULL |
Comments |
No |
No |
| cpdfwu_remarks |
varchar(255) |
NULL |
Remarks |
No |
No |
| cpdfwu_reg_authority |
varchar(25) |
NULL |
Regulatory Authority |
No |
No |
| cpdfwu_approval_no |
varchar(30) |
NULL |
Approval Number |
No |
No |
| cpdfwu_approval_date |
datetime |
NULL |
Approval date |
No |
No |
| cpdfwu_deferred_by_in_days |
numeric(28) |
NULL |
Deferred By in Days |
No |
No |
| cpdfwu_alert_value_in_days |
numeric(28) |
NULL |
Alert Date |
No |
No |
| cpdfwu_Deferred_till_date |
datetime |
NULL |
Deferred Till Date |
No |
No |
| cpdfwu_keycomponent_id |
varchar(40) |
NULL |
Key component Id applicable only
for Removal jobs |
No |
No |
| cpdfwu_flag |
varchar(25) |
NULL |
Stores the following values
"CP" - Central planning "CMP" Component Maintenance
Planning |
No |
No |
| cpdfwu_deferred_alert_date |
datetime |
NULL |
Deferred alter date |
No |
No |
|
| Table
Name cpln_cplndc_reason_category |
|
|
| Table
Comment Reason Category Master |
|
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cplndc_ouinstance |
numeric(10) |
NOT NULL |
Ouinstance |
Yes |
No |
| cplndc_reason_category |
varchar(25) |
NOT NULL |
Reason Category |
Yes |
No |
| cplndc_description |
varchar(80) |
NULL |
Reason Category Description |
No |
No |
| cplndc_status |
varchar(5) |
NULL |
Reason Category status - Cane be
A - Active or I - Inactive |
No |
No |
| cplndc_created_by |
varchar(30) |
NULL |
Created By |
No |
No |
| cplndc_createddate |
datetime |
NULL |
Created Date |
No |
No |
| cplndc_modified_by |
varchar(30) |
NULL |
Last Modified By |
No |
No |
| cplndc_modifieddate |
datetime |
NULL |
Last Modified Date |
No |
No |
| cplndc_timestamp |
numeric(10) |
NULL |
Timestamp |
No |
No |
|
| Table
Name cpln_cplnop_options_set |
|
|
| Table
Comment Option Setting  for Central Planning Component is maintained
here |
|
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cplnop_ouinstance |
numeric(10) |
NOT NULL |
Ouinstance |
Yes |
No |
| cplnop_indefinite_def_flag |
varchar(5) |
NULL |
Indefinite Deferral Flag - This
flag indicates if Indefinite Deferral is allowed or not. Valid values are Y -
Yes and N - No |
No |
No |
| cplnop_def_auth_flag_ac_wu |
varchar(5) |
NULL |
Deferment Request Authorisation
for Aircraft Workunits - Valid values are ’By Central
Planner’,’By Visit/Central Planner’, , ’Not
Required’ |
No |
No |
| cplnop_def_auth_flag_com_wu |
varchar(5) |
NULL |
Deferment Request Authorisation
for Component Workunits - Valid values are ’By Central
Planner’,’By Component Planner’, ’By Visit/Central
Planner’,’Not Required’ |
No |
No |
| cplnop_ac_wu_alloc_rev_met |
varchar(5) |
NULL |
Aircraft Workscope : Allocation
Revision Method - Valid Values are ’Direct’,’Modification
Log’ |
No |
No |
| cplnop_com_ws_alloc_rev_met |
varchar(5) |
NULL |
Component  Workscope :
Allocation Revision Method - Valid Values are Direct Modification Log |
No |
No |
| cplnop_time_zone |
varchar(5) |
NULL |
Time Zone - Valid values are
’GMT’,’Local’ |
No |
No |
| cplnop_created_by |
varchar(30) |
NULL |
Created  By |
No |
No |
| cplnop_createddate |
datetime |
NULL |
Created Date |
No |
No |
| cplnop_modified_by |
varchar(30) |
NULL |
Last Modified By |
No |
No |
| cplnop_modifieddate |
datetime |
NULL |
Last Modified date |
No |
No |
| cplnop_timestamp |
numeric(10) |
NULL |
Timestamp |
No |
No |
| cplnop_pre_call_out |
varchar(5) |
NULL |
Auto Preclusion of Call-Outs
Required - "R" Not Required - "NR" |
No |
No |
| cplnop_pre_onwing_job |
varchar(5) |
NULL |
Auto Preclusion of On-Wing Jobs
Required - "R" Not Required - "NR" |
No |
No |
| CPLNOP_PLNHOR_JOBALLOC |
decimal(28,8) |
NULL |
Planning Horizon for Job
Allocation (Days) |
No |
No |
| CPLNOP_AUTOINC_JOBS |
varchar(10) |
NULL |
Auto Inclusion of Jobs based
Alert Date / Value Values will be "GM" -
 Gate Maintenance "TLG" -
 Technical Log "TLGM" -
 Technical Log & Gate
 maintenance |
No |
No |
| CPLNOP_PLNHOR_GATEPLAN |
decimal(28,8) |
NULL |
Planning Horizon for Gate
Planning (Days) |
No |
No |
| CPLNOP_MRCAT |
varchar(25) |
NULL |
MR Category - Quick code values
defined in MR |
No |
No |
| CPLONP_Res_Avl_Aut_Sch |
varchar(5) |
NULL |
Deferment Request Authorisation
for Aircraft Workunits |
No |
No |
| CPLONP_Avg_Pax_Load_Time |
varchar(25) |
NULL |
Average Passenger Loading Time
(Minutes) |
No |
No |
| CPLONP_Avg_Pax_UnLoad_Time |
varchar(25) |
NULL |
Average Passenger UnLoading Time
(Minutes) |
No |
No |
| CPLONP_Aut_Resch_Frz_Dur |
varchar(25) |
NULL |
Auto Resched. Freeze Duration
(Days from current) |
No |
No |
| CPLONP_Resch_Horzn |
varchar(25) |
NULL |
Rescheduling Horizon (Days from
current date) Mandatory field |
No |
No |
| CPLNOP_SUB_FLEET_SECURITY |
varchar(5) |
NULL |
Sub Fleet Security |
No |
No |
|
| Table
Name cpln_cplnvc_visit_category |
|
|
| Table
Comment Visit Category Master |
|
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cplnvc_ouinstance |
numeric(10) |
NOT NULL |
Ouinstance |
Yes |
No |
| cplnvc_visit_category |
varchar(25) |
NOT NULL |
Visit Category  Code |
Yes |
No |
| cplnvc_description |
varchar(255) |
NULL |
Visit Category Description |
No |
No |
| cplnvc_status |
varchar(5) |
NULL |
Status of the Visit category -
Can be A - Active or  I - Inactive |
No |
No |
| cplnvc_created_by |
varchar(30) |
NULL |
Created By |
No |
No |
| cplnvc_createddate |
datetime |
NULL |
Created Date |
No |
No |
| cplnvc_modified_by |
varchar(30) |
NULL |
Last Modified By |
No |
No |
| cplnvc_modifieddate |
datetime |
NULL |
Last Modified Date |
No |
No |
| cplnvc_timestamp |
numeric(10) |
NULL |
Timestamp |
No |
No |
|
| Table
Name cpln_cpmdlg_modification_log |
|
|
| Table
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. |
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cpmdlg_ouinstance |
numeric(10) |
NOT NULL |
OUinstance |
Yes |
Yes |
| cpmdlg_visit_pkg_no |
varchar(40) |
NOT NULL |
Visit Package Number |
Yes |
Yes |
| cpmdlg_rev_no |
varchar |
NOT NULL |
Revision Number |
Yes |
Yes |
| cpmdlg_vp_rev_no |
varchar(40) |
NOT NULL |
Visit Package Revision no |
Yes |
Yes |
| cpmdlg_line_no |
numeric(10) |
NOT NULL |
Key SeqNo |
Yes |
No |
| cpmdlg_source_ou |
numeric(10) |
NULL |
Source OU |
No |
No |
| cpmdlg_src_doc_type |
varchar(5) |
NULL |
Source Document Type |
No |
No |
| cpmdlg_src_doc_no |
varchar(40) |
NULL |
Source Document Number |
No |
No |
| cpmdlg_src_rev_no |
varchar(40) |
NULL |
Source Document Revision Number |
No |
No |
| cpmdlg_wu_Seq_no |
numeric(10) |
NULL |
Work Unit Key Sequence Number |
No |
No |
| cpmdlg_work_unit |
varchar(30) |
NULL |
Work Unit |
No |
No |
| cpmdlg_wu_type |
varchar(5) |
NULL |
Work Unit Type - Can be Task ,
Aircraft Work Package, Component Work Package or Standard Procedure Number |
No |
No |
| cpmdlg_change_desc |
varchar(255) |
NULL |
Change Description - Indicates
if the Work unit has been added or modified |
No |
No |
| cpmdlg_aircraft_regno |
varchar(30) |
NULL |
Aircraft Registration Number |
No |
No |
| cpmdlg_component_id |
varchar(90) |
NULL |
Component Id |
No |
No |
| cpmdlg_srcwu_seq_no |
numeric(10) |
NULL |
Source Seq No |
No |
No |
| cpmdlg_groundingdate |
datetime |
NULL |
Grounding date if chnaged |
No |
No |
| cpmdlg_priorityno |
numeric(10) |
NULL |
Priority Number |
No |
No |
| cpmdlg_pwccode |
varchar(30) |
NULL |
Primary Work Center Code |
No |
No |
| cpmdlg_priorityou |
numeric(10) |
NULL |
Priority OUInstance |
No |
No |
| cpmdlg_maintance_type |
varchar(5) |
NULL |
Maintenance Type |
No |
No |
| cpmdlg_jobtype |
varchar(5) |
NULL |
Job Type - "AC"
Aircraft "ON" - On-Wing "CR" Component Removal |
No |
No |
| cpmdlg_workunit_ou |
numeric(10) |
NULL |
Workunit OUInstance |
No |
No |
| cpmdlg_wu_rev_no |
varchar(40) |
NULL |
WorkUnit Revision No -
Applicable only for Task |
No |
No |
| cpmdlg_part_no |
varchar(40) |
NULL |
Part Number |
No |
No |
| cpmdlg_serial_no |
varchar(40) |
NULL |
Part Serial Number |
No |
No |
| cpmdlg_position_code |
varchar(25) |
NULL |
Position Code to which Component
is attached |
No |
No |
| cpmdlg_work_center |
varchar(30) |
NULL |
Work Unit level Work Center |
No |
No |
| cpmdlg_elapsed_timeuom |
varchar(5) |
NULL |
Elapsed Time UOM |
No |
No |
| cpmdlg_est_elasped_time |
numeric(28,8) |
NULL |
Estimated Elapsed Time |
No |
No |
| cpmdlg_est_man_hrs |
numeric(28,8) |
NULL |
Estimated Man hours |
No |
No |
| cpmdlg_sch_date |
datetime |
NULL |
Schedule date |
No |
No |
| cpmdlg_ata_no |
varchar(16) |
NULL |
ATA Chapter |
No |
No |
|
| Table
Name cpln_cpmlgd_mod_log_hdr |
|
|
| Table
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. |
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cpmlgd_ouinstance |
numeric(10) |
NOT NULL |
OUinstance |
Yes |
No |
| cpmlgd_visit_pkg_no |
varchar(40) |
NOT NULL |
Visit Package Number |
Yes |
No |
| cpmlgd_rev_no |
varchar |
NOT NULL |
Revision Number |
Yes |
No |
| cpmlgd_vp_rev_no |
varchar(40) |
NOT NULL |
Visit package revision number |
Yes |
No |
| cpmlgd_change_count |
numeric(10) |
NULL |
Total number of change
descriptions |
No |
No |
|
| Table
Name cpln_cppsv_param_sch_val |
|
|
| Table
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 |
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cppsv_ouinstance |
numeric(10) |
NOT NULL |
OUInstance |
Yes |
No |
| cppsv_source |
varchar(25) |
NOT NULL |
Source updated from
Forecast/EO/FCD |
Yes |
No |
| cppsv_src_ou |
numeric(10) |
NOT NULL |
Source OUInstance updated from
Forecast/EO/FCD |
Yes |
No |
| cppsv_source_doc_no |
varchar(40) |
NOT NULL |
Source document number updated
from Forecast/EO/FCD |
Yes |
No |
| cppsv_wu_seq_no |
numeric(10) |
NOT NULL |
Source seq number updated from
Forecast/EO/FCD |
Yes |
No |
| cppsv_ac_reg_no |
varchar(30) |
NOT NULL |
Aircraft Registration Number |
Yes |
No |
| cppsv_param_code |
varchar(40) |
NOT NULL |
Parameter Code |
Yes |
No |
| cppsv_wu_lineno |
numeric(10) |
NOT NULL |
WorkUnit LineNo |
Yes |
No |
| cppsv_maint_program_no |
varchar(40) |
NOT NULL |
Maintenance Program Code |
Yes |
No |
| cppsv_mp_rev_no |
varchar(40) |
NOT NULL |
MP Revision Number |
Yes |
No |
| cppsv_src_doc_rev_no |
varchar(40) |
NOT NULL |
Source document revision number
updated from Forecast/EO/FCD |
No |
No |
| cppsv_param_ou |
numeric(10) |
NULL |
Parameter OUInstance |
No |
No |
| cppsv_sch_val |
numeric(28) |
NULL |
Schedule Value for the Parameter
Code |
No |
No |
| cppsv_alert_val |
numeric(28) |
NULL |
Alert Value for the Parameter
Code |
No |
No |
| cppsv_earliest_sch_val |
numeric(28) |
NULL |
Earliest schedule Value |
No |
No |
| cppsv_latest_sch_val |
numeric(28) |
NULL |
Latest Schedule value |
No |
No |
|
| Table
Name cpln_cpsrch_search_id_master |
|
|
| Table
Comment User customized search option master. |
|
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cpsrch_ouinstance |
numeric(10) |
NOT NULL |
Ouinstance |
Yes |
No |
| cpsrch_search_id |
varchar(30) |
NOT NULL |
Search Id. |
Yes |
No |
| cpsrch_user_id |
varchar(30) |
NOT NULL |
User Id who has created the
search id |
Yes |
No |
| cpsrch_remaining_fh |
numeric(28) |
NULL |
Remaining Flight Hours
 Value |
No |
No |
| cpsrch_remaining_fc |
numeric(28) |
NULL |
Remaining Flight Cycles Value |
No |
No |
| cpsrch_ata_no |
varchar(16) |
NULL |
ATA Number |
No |
No |
| cpsrch_zone_code |
varchar(15) |
NULL |
Zone Code |
No |
No |
| cpsrch_component_family |
varchar(25) |
NULL |
Component Family Code |
No |
No |
| cpsrch_part_no |
varchar(40) |
NULL |
Part Number |
No |
No |
| cpsrch_serial_no |
varchar(40) |
NULL |
Serial Number |
No |
No |
| cpsrch_wu_type |
varchar(5) |
NULL |
Work Unit Type |
No |
No |
| cpsrch_position_type |
varchar(5) |
NULL |
Position Type |
No |
No |
| cpsrch_mcr_doc_type |
varchar(15) |
NULL |
MAintenance Change Request
Number |
No |
No |
| cpsrch_position_code |
varchar(25) |
NULL |
Position Code |
No |
No |
| cpsrch_createddate |
datetime |
NULL |
Created Date |
No |
No |
| cpsrch_timestamp |
numeric(10) |
NULL |
Timestamp |
No |
No |
|
| Table
Name cpln_cpwudu_workunits_due |
|
|
| Table
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. |
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cpwudu_ouinstance |
numeric(10) |
NOT NULL |
ouinstance |
Yes |
No |
| cpwudu_source |
varchar(25) |
NOT NULL |
Source can be FCD or EO or
Aircraft Forecast or Component Forecast |
Yes |
No |
| cpwudu_src_ou |
numeric(10) |
NOT NULL |
source ou |
Yes |
No |
| cpwudu_source_doc_no |
varchar(40) |
NOT NULL |
Source Doc number can be FCD or
EO or Aircraft Forecast or Component Forecast number |
Yes |
No |
| cpwudu_src_doc_rev_no |
varchar(40) |
NOT NULL |
Revision number of the source
document number |
Yes |
No |
| cpwudu_workunit |
varchar(30) |
NOT NULL |
Work Unit to be perfomed.Can be
 a Task or a Procedure or a Standard Work Package |
Yes |
No |
| cpwudu_wu_seq_no |
numeric(10) |
NOT NULL |
work unit sequence number |
Yes |
No |
| cpwudu_entity_seq_no |
numeric(10) |
NOT NULL |
entity sequence number. |
Yes |
No |
| cpwudu_wu_type |
varchar(5) |
NULL |
Work Unit Type Can be  a
Task or a Procedure or a Standard Work Package |
No |
No |
| cpwudu_task_rev_no |
varchar(40) |
NULL |
task revision number |
No |
No |
| cpwudu_latest_compl_date |
datetime |
NULL |
Lastest Compliance Date |
No |
No |
| cpwudu_alert_date |
datetime |
NULL |
Alert Date |
No |
No |
| cpwudu_earliest_compl_date |
datetime |
NULL |
earliest compliance date |
No |
No |
| cpwudu_work_center |
varchar(30) |
NULL |
Work Center Code |
No |
No |
| cpwudu_wc_ou |
numeric(10) |
NULL |
work centre ouinstance |
No |
No |
| cpwudu_est_man_hrs |
numeric(28,8) |
NULL |
Estimated Man hours for the Work
Unit |
No |
No |
| cpwudu_est_elasped_time |
numeric(28,8) |
NULL |
Estimated Elasped Time |
No |
No |
| cpwudu_elasped_timeuom |
varchar(5) |
NULL |
Elapsed Time UOM |
No |
No |
| cpwudu_component_id |
varchar(90) |
NULL |
Component Id - This with be
populated if the source is component Forecast |
No |
No |
| cpwudu_part_no |
varchar(40) |
NULL |
Part number of the Component Id |
No |
No |
| cpwudu_serial_no |
varchar(40) |
NULL |
Serial Number of the Part |
No |
No |
| cpwudu_aircraft_reg_no |
varchar(30) |
NOT NULL |
Aircraft Registration Number |
No |
No |
| cpwudu_ac_ou |
numeric(10) |
NULL |
aircraft ou |
No |
No |
| cpwudu_trans_status |
varchar(5) |
NULL |
Deferral Falg - Will be Y - Yes
if deferred else will be ’N’ - No |
No |
No |
| cpwudu_job_status |
varchar(5) |
NULL |
Job Status |
No |
No |
| cpwudu_precluded_status |
varchar(5) |
NULL |
Preclusion Status |
No |
No |
| cpwudu_visit_package_no |
varchar(40) |
NULL |
Visit Package number if
assigned. |
No |
No |
| cpwudu_vp_rev_no |
varchar(40) |
NULL |
visit package revision number |
No |
No |
| cpwudu_vp_ou |
numeric(10) |
NULL |
visit package ou |
No |
No |
| cpwudu_superceded_wu |
varchar(30) |
NULL |
superceeding work unit |
No |
No |
| cpwudu_superceded_wu_seqno |
numeric(10) |
NULL |
superceeding work unit SeqNo |
No |
No |
| cpwudu_superceded_source |
varchar(25) |
NULL |
superceeding source |
No |
No |
| cpwudu_superceded_src_ou |
numeric(10) |
NULL |
superceeding source ou |
No |
No |
| cpwudu_superceded_doc_no |
varchar(40) |
NULL |
superceeding  document
number |
No |
No |
| cpwudu_superceded_doc_revno |
varchar(40) |
NULL |
superceeding Source Document
RevisionNo |
No |
No |
| cpwudu_superceded_wu_type |
varchar(5) |
NULL |
superceeding work unit type |
No |
No |
| cpwudu_superced_vst_pkg_no |
varchar(40) |
NULL |
superceeding visit package
number |
No |
No |
| cpwudu_job_type |
varchar(5) |
NULL |
job type |
No |
No |
| cpwudu_maintenance_type |
varchar(5) |
NULL |
Maitenance Type |
No |
No |
| cpwudu_mp_no |
varchar(30) |
NULL |
Maintenance Program Number |
No |
No |
| cpwudu_mp_rev_no |
varchar(40) |
NULL |
Maintenance Program revision
number |
No |
No |
| cpwudu_mp_ou |
numeric(10) |
NULL |
Maintenance Program OUInstance |
No |
No |
| cpwudu_mp_seq_no |
int |
NULL |
Maintenance Program sequence
number |
No |
No |
| cpwudu_mp_wu_seqno |
numeric(10) |
NULL |
Maintenance Program WorkUnit
SeqNo |
No |
No |
| cpwudu_ata_no |
varchar(16) |
NULL |
ATA Chapter |
No |
No |
| cpwudu_zone_code |
varchar(15) |
NULL |
Zone Code |
No |
No |
| cpwudu_workunit_ou |
numeric(10) |
NULL |
WorkUnit OUInstance |
No |
No |
| cpwudu_turnaround_time |
numeric(28,8) |
NULL |
Turn Around Time Maintenance
Program revision number |
No |
No |
| cpwudu_preperatory_time |
numeric(28,8) |
NULL |
Preparatory Time updated from
Maintenance Forcast |
No |
No |
| cpwudu_supceded_comments |
varchar(255) |
NULL |
Superceded Comments |
No |
No |
| cpwudu_level_code |
varchar(150) |
NULL |
Level Code in the Configuration |
No |
No |
| cpwudu_execution_type |
varchar(5) |
NULL |
Execution Type  Major
and Minor |
No |
No |
| cpwudu_position_code |
varchar(25) |
NULL |
Position Code in the
configuration |
No |
No |
| cpwudu_cycle_no |
varchar(6) |
NULL |
Cycle No updated from
Maintenance Forecast |
No |
No |
| cpwudu_sch_no |
varchar(6) |
NULL |
Schudule No updated from
Maintenance Forecast |
No |
No |
| cpwudu_expense_type |
varchar(5) |
NULL |
Expense type - "REV"
Revenue "CAP" Capital |
No |
No |
| cpwudu_sch_date |
datetime |
NULL |
Schedule Date |
No |
No |
| cpwudu_plan_start_date |
datetime |
NULL |
Plan start date captured in
Allocate workuint page |
No |
No |
| cpwudu_plan_end_date |
datetime |
NULL |
Plan end date captured in
Allocate workuint page |
No |
No |
| cpwudu_hours_per_day |
numeric(28,8) |
NULL |
Hours / Day |
No |
No |
| cpwudu_trigg_parameter |
varchar(40) |
NULL |
Triggering parameter updated
from Forecast/EO/FCD |
No |
No |
| cpwudu_update_sch |
varchar(25) |
NULL |
Update Scheduling -
"Y" - Yes "N" - No |
No |
No |
| cpwudu_incomplete_date |
datetime |
NULL |
Incomplete Date - Date when the
Workunit was first left incomplete. It will be updated finally on completion.
Only applicable for Techlog |
No |
No |
| cpwudu_incomplete_doc_no |
varchar(40) |
NULL |
Techlog No - It will keep
changing as and when the workunit is being processed . Only applicable for
Techlog |
No |
No |
| cpwudu_incomplete_flag |
varchar(5) |
NULL |
Incomplete Flag "N" -
No "Y" - Yes Default "N" |
No |
No |
| CPWUDU_LP_OU |
int |
NULL |
OU on which the Line package has
been created |
No |
No |
| CPWUDU_LINE_PACKAGE |
varchar(40) |
NULL |
Line package Number |
No |
No |
| CPWUDU_LP_LINENO |
decimal(10) |
NULL |
Seq Number for Line package
workunits |
No |
No |
| CPWUDU_PlngSts |
varchar(40) |
NULL |
Planning status |
No |
No |
| CPWUDU_PLAN_BASIS |
varchar(25) |
NULL |
Values will be
"Automatic" , "Must Do" , "On or Before" |
No |
No |
| CPWUDU_GREENTIMESTATUS |
varchar(5) |
NULL |
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 |
No |
| CPWUDU_CAPACITY_CHECK |
varchar(25) |
NULL |
Whether capacity check required
or not YES / NO |
No |
No |
| CPWUDU_REFORECAST_FLAG |
varchar(5) |
NULL |
Reforecast done or not YES / NO |
No |
No |
| CPWUDU_ERROR |
varchar(90) |
NULL |
The scheduler will try to
schedule this Work Unit to the earliest possible slot. If no slot if found,
the same slot will be retained with an error message in the Error Column |
No |
No |
| CPLN_CPWUDU_PLANNING_COMMENTS |
udd_txt255 |
NULL |
Planning comments |
No |
No |
| CPWUDU_EO_NO |
udd_documentno |
NULL |
Engineering document number |
No |
No |
| CPWUDU_EO_TYPE |
udd_flag |
NULL |
Document type |
No |
No |
| CPWUDU_MPD_GROUP |
udd_flag |
NULL |
MPD Group |
No |
No |
| CPWUDU_PROGITEM_TYPE |
udd_designparamcode |
NULL |
Specify Program item type |
No |
No |
| CPWUDU_DEF_EXEPRI |
udd_priority |
NULL |
Default Execution Priority |
No |
No |
| CPWUDU_INIRES_BY |
udd_designparamcode |
NULL |
Initiate Reset by |
No |
No |
| CPWUDU_DUEFH |
udd_numericparamval |
NULL |
Due FH |
No |
No |
| CPWUDU_DUEFC |
udd_numericparamval |
NULL |
Due FC |
No |
No |
| CPWUDU_INTERVAL_FH |
udd_numericparamval |
NULL |
Interval FH |
No |
No |
| CPWUDU_INTERVAL_FC |
udd_numericparamval |
NULL |
Interval FC |
No |
No |
| CPWUDU_EO_REVNO |
udd_revisionno |
NULL |
Eo Revision |
No |
No |
| CPWUDU_AIRCRAFT_MODEL |
udd_model |
NULL |
Aircraft Model |
No |
No |
| CPWUDU_AIRCRAFT_GROUP |
udd_txt2000 |
NULL |
Aircraft Group |
No |
No |
| CPWUDU_SUBFLEET |
udd_txt2000 |
NULL |
Subfleet |
No |
No |
| CPWUDU_FIELD_BASE |
udd_taskcode |
NULL |
Field Base |
No |
No |
| CPWUDU_CUSTOMER |
udd_vendorcode |
NULL |
Customer |
No |
No |
| CPWUDU_PLNR_GROUP |
udd_txt2000 |
NULL |
Planner group |
No |
No |
| CPWUDU_JOB_ID |
numeric |
NULL |
Unique id |
No |
No |
| CPWUDU_INSTANCE_NO |
udd_count |
NULL |
Instance of task(repetitive instance) |
No |
No |
| cpwudu_Parent_item |
udd_txt2000 |
NULL |
Parant task |
No |
No |
| cpwudu_root_task |
udd_taskcode |
NULL |
Root task |
No |
No |
| CPWUDU_DEF_REQ_NO |
udd_documentno |
NULL |
Deferement Request No |
No |
No |
| CPWUDU_REM_DAYS |
udd_numericparamval |
NULL |
Remaining Days |
No |
No |
|
|
|
|
|
|
|
|
|
|
|
| Table
Name cpln_cpwuus_wu_usage_sch |
|
|
| Table
Comment Deferral Limits for the Work Units |
|
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cpwuus_ouinstance |
numeric(10) |
NOT NULL |
Ouinstance |
Yes |
Yes |
| CPDFWU_SOURCE |
varchar(25) |
NOT NULL |
Ouinstance |
Yes |
No |
| cpwuus_source |
varchar(25) |
NOT NULL |
Source |
Yes |
Yes |
| CPDFWU_SRC_OU |
decimal(10) |
NOT NULL |
Source |
Yes |
No |
| cpwuus_src_ou |
numeric(10) |
NOT NULL |
Source OU |
Yes |
Yes |
| cpwuus_source_doc_no |
varchar(40) |
NOT NULL |
Source Document Number |
Yes |
Yes |
| CPDFWU_SOURCE_DOC_NO |
varchar(40) |
NOT NULL |
Source Document Number |
Yes |
No |
| cpwuus_src_doc_rev_no |
varchar(40) |
NOT NULL |
Source document revision number |
Yes |
Yes |
| CPDFWU_WU_SEQ_NO |
varchar(30) |
NOT NULL |
Source document revision number |
Yes |
No |
| cpwuus_wu_seq_no |
numeric(10) |
NOT NULL |
work unit sequence number |
Yes |
Yes |
| cpwuus_def_req_no |
varchar(40) |
NOT NULL |
deferment request number |
Yes |
Yes |
| cpwuus_seq_no |
numeric(10) |
NOT NULL |
Sequence Number |
Yes |
Yes |
| cpwuus_param_code |
varchar(40) |
NOT NULL |
Parameter Code |
Yes |
No |
| cpwuus_alert_value |
numeric(28) |
NULL |
Alert Value |
No |
No |
| cpwuus_deferred_by |
numeric(28) |
NULL |
Deferred By Value |
No |
No |
| cpwuus_Deferred_till |
datetime |
NULL |
Deferred Till Value |
No |
No |
| cpwuus_param_ou |
numeric(10) |
NULL |
Parameter OUInstance |
No |
No |
| CPWUUS_ALERT_DATE |
datetime |
NULL |
Work unit schedule alert Date |
No |
No |
| CPWUUS_SCH_VALUE |
decimal(28) |
NULL |
Shedule’s value |
No |
No |
|
| Table
Name cpln_parameter_details |
|
|
| Table
Comment Meta Data Table for Central Planning |
|
| Table
Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
| cpln_componentname |
varchar(25) |
NOT NULL |
Component Name |
Yes |
No |
| cpln_ParamCategory |
varchar(25) |
NOT NULL |
Parameter Category |
Yes |
No |
| cpln_ParamType |
varchar(25) |
NOT NULL |
Parameter Type |
Yes |
No |
| cpln_ParamCode |
varchar(25) |
NOT NULL |
Parameter Code |
Yes |
No |
| cpln_ParamDesc |
varchar(150) |
NULL |
Parameter Description |
No |
No |
| cpln_Langid |
numeric(10) |
NULL |
Language Id |
No |
No |
| cpln_Creationdate |
datetime |
NULL |
Creation Date |
No |
No |
| cpln_sortby |
numeric(10) |
NULL |
Sort By |
No |
No |
|
|
|
|
|
|