Data Dictionary - 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 |
Requester’s employee code |
No | No |
|
cpdfrq_email |
varchar(70) |
NULL |
Email id |
No | No |
|
cpdfrq_phone_no |
varchar(70) |
NULL |
Work Phone 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 deferral 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 Authorization 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 Authorization 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 |
ComponentWorkscope : 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 Authorization 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 Rescheduled. 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 existing 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 changed |
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 performed 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 Flag - 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 |
superseding work unit |
No | No |
|
cpwudu_superceded_wu_seqno |
numeric(10) |
NULL |
superseding work unit SeqNo |
No | No |
|
cpwudu_superceded_source |
varchar(25) |
NULL |
superseding source |
No | No |
|
cpwudu_superceded_src_ou |
numeric(10) |
NULL |
superseding source ou |
No | No |
|
cpwudu_superceded_doc_no |
varchar(40) |
NULL |
superseding document number |
No | No |
|
cpwudu_superceded_doc_revno |
varchar(40) |
NULL |
superseding Source Document RevisionNo |
No | No |
|
cpwudu_superceded_wu_type |
varchar(5) |
NULL |
superseding work unit type |
No | No |
|
cpwudu_superced_vst_pkg_no |
varchar(40) |
NULL |
superseding visit package number |
No | No |
|
cpwudu_job_type |
varchar(5) |
NULL |
job type |
No | No |
|
cpwudu_maintenance_type |
varchar(5) |
NULL |
Maintenance 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 Forecast |
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 |
Schedule 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_COM |
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_designparam |
NULL |
Specify Program item type |
No | No |
|
CPWUDU_DEF_EXEPRI |
udd_priority |
NULL |
Default Execution Priority |
No | No |
|
CPWUDU_INIRES_BY |
udd_designparam |
NULL |
Initiate Reset by |
No | No |
|
CPWUDU_DUEFH |
udd_numericpara |
NULL |
Due FH |
No | No |
|
CPWUDU_DUEFC |
udd_numericpara |
NULL |
Due FC |
No | No |
|
CPWUDU_INTERVAL_FH |
udd_numericpara |
NULL |
Interval FH |
No | No |
|
CPWUDU_INTERVAL_FC |
udd_numericpara |
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 |
Parent task |
No | No |
|
cpwudu_root_task |
udd_taskcode |
NULL |
Root task |
No | No |
|
CPWUDU_DEF_REQ_NO |
udd_documentno |
NULL |
Deferment Request No |
No | No |
|
CPWUDU_REM_DAYS |
udd_numericpara |
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 |
Schedule’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 |
|
|
|
|
|
|
|