Data Dictionary - Component Maintenance Program |
|||||
|
|
|||||
|
Table Name cmp_ae_aircraft_eff_info |
|
||||
|
|
|||||
|
Table Comment Aircraft Effectivity Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
aei_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
aei_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
aei_aircraft_model |
varchar(20) |
NOT NULL |
Aircraft Model |
Yes |
Yes |
|
aei_config_class |
varchar(30) |
NOT NULL |
Configuration Class |
Yes |
Yes |
|
aei_level_no |
varchar(150) |
NOT NULL |
Level no in the Configuration Class |
Yes |
Yes |
|
aei_pos_code |
varchar(25) |
NOT NULL |
Position Code in the Configuration Class |
Yes |
Yes |
|
aei_workunit_lineno |
char(18) |
NOT NULL |
Part Program Work units Lineno No. This would be internally generated no |
Yes |
Yes |
|
aei_aircraft_regno |
varchar(30) |
NOT NULL |
Aircraft reg No |
Yes |
No |
|
aei_created_date |
datetime |
NULL |
Created Date |
No |
No |
|
aei_created_by |
varchar(30) |
NULL |
Created By |
No |
No |
|
aei_modified_date |
datetime |
NULL |
Modified Date |
No |
No |
|
aei_modified_by |
varchar(30) |
NULL |
Modified By |
No |
No |
|
aei_timestamp |
numeric |
NOT NULL |
Timestamp |
No |
No |
|
aei_aircraft_ou |
numeric |
NULL |
Aircraft OU |
No |
No |
|
|
|||||
|
Table Name CMP_CDH_COMP_DB_HIST |
|
||||
|
|
|||||
|
Table Comment Stores history of date-based schedules for the position code and the part number |
| ||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
CDH_OUINSTANCE |
numeric(28) |
NOT NULL |
Ouinstance |
Yes |
No |
|
CDH_COMPONENT |
varchar(90) |
NOT NULL |
The number identifying the component for which the maintenance program details are to be updated. |
Yes |
No |
|
CDH_PROGRAM_REVISION_NO |
varchar(40) |
NOT NULL |
The revision number of the component maintenance program. This number represents the number of changes the component maintenance program has undergone. This gets displayed on screen launch itself, but if authorized CMP is modified, then new revision gets created. |
Yes |
No |
|
CDH_LAST_PERFORMED_DATE |
datetime |
NOT NULL |
The date on which the work unit was last performed on the component |
Yes |
No |
|
CDH_WORKUNIT_LINENO |
numeric(28) |
NULL |
The line of The task, standard procedure or work package, to be performed as part of the maintenance work. |
No |
No |
|
CDH_SCH_LINENO |
numeric(28) |
NULL |
Line of the schedule line no for a parameter |
No |
No |
|
CDH_SCH_TYPE |
varchar(5) |
NULL |
Date base Or usage based |
No |
No |
|
CDH_NEXT_SCHEDULED_DATE |
datetime |
NULL |
The date on which the next work unit is due for the component |
No |
No |
|
CDH_TIMEUNIT |
varchar(5) |
NULL |
the unit of measurement for the time that is being specified, which could be one of the following: Hours,Minutes, or Days. |
No |
No |
|
CDH_THRESHOLD |
decimal(28,8) |
NULL |
The value of the parameter when the schedule will start |
No |
No |
|
CDH_INTERVAL |
decimal(28,8) |
NULL |
The interval in which the work unit is to be repeated |
No |
No |
|
CDH_ALERTVALUE |
decimal(28,8) |
NULL |
The value of the parameter before the next arising when an alert needs to be given for the impending work unit execution |
No |
No |
|
CDH_POS_TOLERANCE |
decimal(28,8) |
NULL |
The upper limit within which the work unit is to be performed |
No |
No |
|
CDH_NEG_TOLERANCE |
decimal(28,8) |
NULL |
The lower limit within which the work unit is to be performed |
No |
No |
|
CDH_TERMINATING_VALUE |
decimal(28,8) |
NULL |
The value after which maintenance requirement terminates. In other words, the number of days after which maintenance activity need not be performed on the component |
No |
No |
|
CDH_TERMINATING_DATE |
datetime |
NULL |
The date on or after which the maintenance requirements terminates. In other words, the date on or after which maintenance activity need not be performed on the component |
No |
No |
|
CDH_UPD_BASIS |
varchar(5) |
NULL |
the basis of updating the work units of the maintenance program |
No |
No |
|
CDH_ATTACHMENT_DATE |
datetime |
NULL |
The date on which the component was attached on the aircraft. |
No |
No |
|
CDH_UPD_DOCUMENT_NO |
varchar(40) |
NULL |
document No defined in the “Create Reference Document Type” activity of the “Common Master” |
No |
No |
|
CDH_UPD_DOCUMENT_TYPE |
varchar(25) |
NULL |
document Types defined in the “Create Reference Document Type” activity of the “Common Master” |
No |
No |
|
CDH_UPDATED_DATE |
datetime |
NULL |
Date on which program is updated |
No |
No |
|
|
|||||
|
Table Name cmp_cds_comp_db_sch |
|
||||
|
|
|||||
|
Table Comment Component Program Date Based Schedules |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cds_alertvalue |
numeric(28,8) |
NULL |
The value of the parameter before the next arising when an alert needs to be given for the impending work unit execution |
No |
No |
|
cds_pos_tolerance |
numeric(28,8) |
NULL |
The upper limit within which the work unit is to be performed |
No |
No |
|
cds_interval |
numeric(28,8) |
NULL |
The interval in which the work unit is to be repeated |
No |
No |
|
cds_threshold |
numeric(28,8) |
NULL |
The value of the parameter when the schedule will start |
No |
No |
|
cds_upd_basis |
varchar(5) |
NULL |
Updation Basis: LD - Last performed Date ID - Installation Date. |
No |
No |
|
cds_neg_tolerance |
numeric(28,8) |
NULL |
The lower limit within which the work unit is to be performed |
No |
No |
|
CDS_TERMINATING_DATE |
datetime |
NULL |
The date on or after which the maintenance requirements terminates. In other words, the date on or after which maintenance activity need not be performed on the component |
No |
No |
|
CDS_TERMINATING_VALUE |
numeric(28,8) |
NULL |
The value after which maintenance requirement terminates. In other words, the number of days after which maintenance activity need not be performed on the component |
No |
No |
|
CDS_ATTACHMENT_DATE |
datetime |
NULL |
The date on which the component was attached on the aircraft |
No |
No |
|
cds_program_revision_no |
varchar(40) |
NOT NULL |
Component program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
cds_workunit_lineno |
decimal(38) |
NOT NULL |
Component Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
cds_component |
varchar(90) |
NOT NULL |
Component No |
Yes |
Yes |
|
cds_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
cds_timeunit |
varchar(5) |
NULL |
the unit of measurement for the time that is being specified, which could be one of the following: Hours,Minutes, or Days. |
No |
No |
|
cds_next_Scheduled_date |
datetime |
NULL |
The date on which the next work unit is due for the component |
No |
No |
|
cds_sch_lineno |
decimal(38) |
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
cds_last_performed_date |
datetime |
NULL |
The date on which the work unit was last performed on the component |
No |
No |
|
cds_sch_type |
varchar(5) |
NOT NULL |
Schedule Type RC - "Recurring" OT - "OneTime" |
No |
No |
|
|
|||||
|
Table Name cmp_cdsr_comp_db_sch_rev |
|
||||
|
|
|||||
|
Table Comment Component Program Date Based Schedules- Revision Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cdsr_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
cdsr_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
cdsr_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
cdsr_timeunit |
varchar(5) |
NULL |
Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years" |
No |
No |
|
cdsr_next_Scheduled_date |
datetime |
NULL |
Scheduled Date |
No |
No |
|
CDSR_TERMIN_DATE |
datetime |
NULL |
The date after which the maintenance activity cannot be performed on the component |
No |
No |
|
cdsr_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
CDSR_TERMIN_VALUE |
numeric(28,8) |
NULL |
The value after which the maintenance activity cannot be performed on the component |
No |
No |
|
cdsr_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
cdsr_upd_basis |
varchar(5) |
NULL |
Updation Basis : ID - Installation Date LD - Last performed Date |
No |
No |
|
cdsr_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
cphr_part_no |
varchar(40) |
NOT NULL |
Part No |
Yes |
Yes |
|
cdsr_component |
varchar(90) |
NOT NULL |
Component No |
Yes |
Yes |
|
cdsr_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
cdsr_last_performed_date |
datetime |
NULL |
Last Performed Date |
No |
No |
|
cdsr_sch_type |
varchar(5) |
NOT NULL |
Schedule Type RC - Recurring OT - One Time |
No |
No |
|
cdsr_workunit_lineno |
decimal(38) |
NOT NULL |
Component Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
cphr_serialno |
varchar(40) |
NOT NULL |
Serial No |
Yes |
Yes |
|
cdsr_sch_lineno |
decimal(38) |
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
|
|||||
|
Table Name cmp_cmpqc_cmp_quick_code |
|
||||
|
|
|||||
|
Table Comment User Defined Quick Codes |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cmpqc_ouinstance |
numeric |
NOT NULL |
OUinstance |
Yes |
No |
|
cmpqc_quick_code |
varchar(25) |
NOT NULL |
User Defined Quick Code |
Yes |
No |
|
cmpqc_type |
varchar(5) |
NOT NULL |
Quick Code Type. |
Yes |
No |
|
cmpqc_description |
varchar(80) |
NOT NULL |
Quick Code description |
No |
No |
|
cmpqc_status |
varchar(5) |
NOT NULL |
Status of the quick code. Can be A - Active or I - Inactive |
No |
No |
|
cmpqc_created_by |
varchar(30) |
NOT NULL |
Created by user id |
No |
No |
|
cmpqc_modified_by |
varchar(30) |
NOT NULL |
Last Modified By user id |
No |
No |
|
cmpqc_creationdate |
datetime |
NOT NULL |
Creation Date time |
No |
No |
|
cmpqc_modifieddate |
datetime |
NOT NULL |
Last Modified date time |
No |
No |
|
cmpqc_timestamp |
numeric |
NOT NULL |
Timestamp |
No |
No |
|
|
|||||
|
Table Name cmp_coci_comp_opp_chk_info |
|
||||
|
|
|||||
|
Table Comment Opportunity Check Work Unit Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
coci_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
coci_component |
varchar(20) |
NOT NULL |
Component No |
Yes |
Yes |
|
coci_Program_Revision_No |
varchar(40) |
NOT NULL |
Component program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
coci_lineno |
numeric(28) |
NOT NULL |
Line no indicating the unique row in the opportunity check info. System Generated |
Yes |
No |
|
coci_execute_with |
varchar(5) |
NULL |
Execute With O - "Next Overhaul", R - "Next Repair", I - "Next Inspection", S - "Next Shop-Visit" |
No |
No |
|
coci_workunit_type |
varchar(5) |
NULL |
work unit type values T - "Task" S - "Std Procedure" W - "Work Package" |
No |
No |
|
coci_workunit |
varchar(30) |
NULL |
Work Unit , It could be Task, Stored Procedure or Work package |
No |
No |
|
COCI_WU_REV_NO |
varchar(40) |
NULL |
work unit revision number |
No |
No |
|
coci_workunit_ou |
decimal(38) |
NULL |
Work Unit OU Instance - Used to fetch the description |
No |
No |
|
coci_last_performed_date |
datetime |
NULL |
Last Performed Date |
No |
No |
|
coci_wo_no |
varchar(18) |
NULL |
CWO No - Updated by CWO |
No |
No |
|
coci_workcenter |
varchar(30) |
NULL |
WO Execution Work Center - Updated by CWO |
No |
No |
|
coci_executionUnit |
varchar(32) |
NULL |
Execution Unit Updated by CWO |
No |
No |
|
|
|||||
|
Table Name CMP_COCR_COMP_OPP_CHK_REV |
|
||||
|
|
|||||
|
Table Comment Opportunity Check Revision Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
COCR_OUINSTANCE |
numeric |
NOT NULL |
OU Instance |
Yes |
No |
|
COCR_COMPONENT |
varchar(20) |
NOT NULL |
Component ID |
Yes |
No |
|
COCR_PROGRAM_REVISION_NO |
varchar(40) |
NOT NULL |
CMP Revision No |
Yes |
No |
|
COCR_LINENO |
numeric |
NOT NULL |
Work Unit Line No |
Yes |
No |
|
COCR_WU_REV_NO |
varchar(40) |
NULL |
work unit revision number |
No |
No |
|
COCR_EXECUTE_WITH |
varchar(5) |
NULL |
Execute With O - "Next Overhaul", R - "Next Repair", I - "Next Inspection", S - "Next Shop-Visit" |
No |
No |
|
COCR_WORKUNIT_TYPE |
varchar(5) |
NULL |
work unit type values T - "Task" S - "Std Procedure" W - "Work Package" |
No |
No |
|
COCR_WORKUNIT |
varchar(30) |
NULL |
Work Unit , It could be Task, Stored Procedure or Work package |
No |
No |
|
COCR_WORKUNIT_OU |
numeric |
NULL |
Ouinstance |
No |
No |
|
COCR_LAST_PERFORMED_DATE |
datetime |
NULL |
Last Performed Date |
No |
No |
|
COCR_WO_NO |
varchar(18) |
NULL |
CWO No - Updated by CWO |
No |
No |
|
COCR_WORKCENTER |
varchar(30) |
NULL |
WO Execution Work Center - Updated by CWO |
No |
No |
|
COCR_EXECUTIONUNIT |
varchar(32) |
NULL |
Execution Unit Updated by CWO |
No |
No |
|
|
|||||
|
Table Name CMP_COCR_COMP_OPP_CHK_REV |
|
||||
|
|
|||||
|
Table Comment Opportunity Check Revision Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
COCR_OUINSTANCE |
numeric |
NOT NULL |
OU Instance |
Yes |
No |
|
COCR_COMPONENT |
varchar(20) |
NOT NULL |
Component ID |
Yes |
No |
|
COCR_PROGRAM_REVISION_NO |
varchar(40) |
NOT NULL |
CMP Revision No |
Yes |
No |
|
COCR_LINENO |
numeric |
NOT NULL |
Work Unit Line No |
Yes |
No |
|
COCR_WU_REV_NO |
varchar(40) |
NULL |
work unit revision number |
No |
No |
|
COCR_EXECUTE_WITH |
varchar(5) |
NULL |
Execute With O - "Next Overhaul", R - "Next Repair", I - "Next Inspection", S - "Next Shop-Visit" |
No |
No |
|
COCR_WORKUNIT_TYPE |
varchar(5) |
NULL |
work unit type values T - "Task" S - "Std Procedure" W - "Work Package" |
No |
No |
|
COCR_WORKUNIT |
varchar(30) |
NULL |
Work Unit , It could be Task, Stored Procedure or Work package |
No |
No |
|
COCR_WORKUNIT_OU |
numeric |
NULL |
|
No |
No |
|
COCR_LAST_PERFORMED_DATE |
datetime |
NULL |
Last Performed Date |
No |
No |
|
COCR_WO_NO |
varchar(18) |
NULL |
CWO No - Updated by CWO |
No |
No |
|
COCR_WORKCENTER |
varchar(30) |
NULL |
WO Execution Work Center - Updated by CWO |
No |
No |
|
COCR_EXECUTIONUNIT |
varchar(32) |
NULL |
Execution Unit Updated by CWO |
No |
No |
|
|
|||||
|
Table Name Cmp_Comp_option_set |
|
||||
|
|
|||||
|
Table Comment Component Program Option settings Table |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
Comp_OUINSTANCE |
int |
NOT NULL |
Comp_OUINSTANCE |
No |
No |
|
Comp_UPDBASIS |
char(5) |
NULL |
Comp_UPDBASIS |
No |
No |
|
Comp_TIMESTAMP |
int |
NULL |
Comp_TIMESTAMP |
No |
No |
|
Comp_CREATED_BY |
char(30) |
NULL |
Comp_CREATED_BY |
No |
No |
|
Comp_CREATED_DATE |
datetime |
NULL |
Comp_CREATED_DATE |
No |
No |
|
Comp_MODIFIED_BY |
char(30) |
NULL |
Comp_MODIFIED_BY |
No |
No |
|
Comp_MODIFIED_DATE |
datetime |
NULL |
Comp_MODIFIED_DATE |
No |
No |
|
COMP_PLNGRPSEC |
char(5) |
NULL |
COMP_PLNGRPSEC |
No |
No |
|
|
|||||
|
Table Name cmp_cpd_comp_prg_detail |
|
||||
|
|
|||||
|
Table Comment Component Program Work Unit Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cpd_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
cpd_component |
varchar(90) |
NOT NULL |
Component Program Component No |
Yes |
Yes |
|
cpd_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
cpd_workunit_line_no |
decimal(38) |
NOT NULL |
Component Program Work units Serial No. This would be internally generated no |
Yes |
No |
|
cpd_maint_type |
varchar(5) |
NULL |
"Maintenance Type" defined under maintenance type in the common masters. "Overhaul" "Repair" "Inspection" "Others" |
No |
No |
|
cpd_workunit_type |
|
NOT NULL |
work unit type values T - "Task" S - "Std Procedure" W - "Work Package" |
No |
No |
|
cpd_workunit |
varchar(30) |
NOT NULL |
Work Unit , It could be Task, Stored Procedure or Work package |
No |
No |
|
cpd_workunit_revno |
varchar(40) |
NULL |
Work Unit Revision No |
No |
No |
|
cpd_workunit_ou |
decimal(38) |
NULL |
Work Unit OU Instance - Used to fetch the description |
No |
No |
|
cpd_execfacility |
varchar(5) |
NULL |
"Execution Facility" IH - "In-House" OS - "Outsource" |
No |
No |
|
cpd_workcenter |
varchar(30) |
NULL |
work center codes in "Active" status defined in the work center components with which this component is interacting And the  work units have an associated work center # that is currently not in "Active" status |
No |
No |
|
cpd_workcenter_ou |
decimal(38) |
NULL |
Work Center OU |
No |
No |
|
cpd_timeunit |
varchar(5) |
NULL |
Time Unit for Estimated Duration H - Hours D- Days M - Minutes |
No |
No |
|
cpd_turnaroundtime_disp |
numeric(28,8) |
NULL |
Turn Around time in Min |
No |
No |
|
cpd_turnaroundtime_min |
numeric(28,8) |
NULL |
Turnaround time in Min |
No |
No |
|
cpd_est_duration_min |
numeric(28,8) |
NULL |
Estimated Duration in Min |
No |
No |
|
cpd_est_duration_disp |
numeric(28,8) |
NULL |
Estimated Duration in Disp |
No |
No |
|
cpd_onwing |
varchar(5) |
NULL |
On Wing Y/N Y - Yes N - No |
No |
No |
|
cpd_refdoctype |
varchar(25) |
NULL |
Ref Document Type - Values defined in the common master of RefDoctype |
No |
No |
|
cpd_refdocno |
varchar(40) |
NULL |
Reference Document No |
No |
No |
|
cpd_refdoc_details |
varchar(255) |
NULL |
Reference Document Details - User Entered Value |
No |
No |
|
cpd_eo_refdoc_no |
varchar(40) |
NULL |
EO reference Document No |
No |
No |
|
cpd_eo_refdoc_revno |
varchar(40) |
NULL |
EO Ref Docu Revision No |
No |
No |
|
cpd_comments |
varchar(255) |
NULL |
Comments |
No |
No |
|
cpd_linkflag |
varchar(25) |
NULL |
Link Flag P- Part Estimated , R -Resources Estimated, PR - Part and Resources Estimated, PS - Part Estimated and Schedule Defined PRS - Part , Resource Estimated and Schedule Defined |
No |
No |
|
cpd_last_performed_date |
datetime |
NULL |
Last Performed Date |
No |
No |
|
cpd_workunit_status |
varchar(5) |
NULL |
Work Unit Status A- Active I - Inactive |
No |
No |
|
CPD_SHELFLIFE |
varchar(5) |
NULL |
shelflife |
No |
No |
|
CPD_SRCDOC_TYPE |
varchar(5) |
NULL |
Source Document type EO - Engineering Order MR - Maint Report |
No |
No |
|
CPD_DEFREQNO |
varchar(40) |
NULL |
Deferral Sequence no |
No |
No |
|
CPD_DEFRL_SOURCE |
varchar(40) |
NULL |
Deferral Source DP, Maintenance Report |
No |
No |
|
CPD_DEFRAL_VAL |
decimal(28) |
NULL |
Deferral Value |
No |
No |
|
CPD_DEFRAL_DATE |
datetime |
NULL |
Deferral Date |
No |
No |
|
CPD_Expense_Type |
varchar(5) |
NULL |
CAPEX, Revenue |
No |
No |
|
|
|||||
|
Table Name cmp_cpdr_comp_prg_detail_rev |
|
||||
|
|
|||||
|
Table Comment Component Program Work Unit Details - Revision Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cpdr_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
cpdr_component |
varchar(90) |
NOT NULL |
Component Program Component No |
Yes |
Yes |
|
cpdr_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
cpdr_workunit_line_no |
decimal(38) |
NOT NULL |
Component Program Work units Serial No. This would be internally generated no |
Yes |
No |
|
cphr_part_no |
varchar(40) |
NOT NULL |
Part No |
Yes |
Yes |
|
cphr_serialno |
varchar(40) |
NOT NULL |
Serial No |
Yes |
Yes |
|
cpdr_maint_type |
varchar(5) |
NULL |
"Maintenance Type" defined under maintenance type in the common masters. "Overhaul" "Repair" "Inspection" "Others" |
No |
No |
|
cpdr_workunit_type |
varchar(5) |
NULL |
work unit type values T - "Task" S - "Std Procedure" W - "Work Package" |
No |
No |
|
cpdr_workunit |
varchar(30) |
NULL |
Work Unit , It could be Task, Stored Procedure or Work package |
No |
No |
|
cpdr_workunit_revno |
varchar(40) |
NULL |
work unit revision number |
No |
No |
|
cpdr_workunit_ou |
decimal(38) |
NULL |
Work Unit OU Instance - Used to fetch the description |
No |
No |
|
cpdr_execfacility |
varchar(5) |
NULL |
"Execution Facility" IH - "In-House" OS - "Outsource" |
No |
No |
|
cpdr_workcenter |
varchar(30) |
NULL |
work center codes in "Active" status defined in the work center components with which this component is interacting And the  work units have an associated work center # that is currently not in "Active" status |
No |
No |
|
cpdr_workcenter_ou |
decimal(38) |
NULL |
Work Center OU |
No |
No |
|
cpdr_timeunit |
varchar(5) |
NULL |
Time Unit for Estimated Duration H - Hours D- Days M - Minutes |
No |
No |
|
cpdr_turnaroundtime_disp |
numeric(28,8) |
NULL |
Turnaround time in Displayt time unit |
No |
No |
|
cpdr_turnaroundtime_min |
numeric(28,8) |
NULL |
Turn Around time in Min |
No |
No |
|
cpdr_est_duration_min |
numeric(28,8) |
NULL |
estimated Duration in Min |
No |
No |
|
cpdr_est_duration_disp |
numeric(28,8) |
NULL |
Estimated duration in Display timeunit |
No |
No |
|
cpdr_onwing |
varchar(5) |
NULL |
On Wing Y/N Y - Yes N - No |
No |
No |
|
cpdr_refdoctype |
varchar(25) |
NULL |
Ref Document Type - Values defined in the common master of RefDoctype |
No |
No |
|
cpdr_refdocno |
varchar(25) |
NULL |
Reference Document No |
No |
No |
|
cpdr_refdoc_details |
varchar(255) |
NULL |
Reference Document OU |
No |
No |
|
cpdr_eo_refdoc_no |
varchar(40) |
NULL |
EO Reference Document No |
No |
No |
|
cpdr_eo_refdoc_revno |
varchar(40) |
NULL |
EO Ref Document Revision No |
No |
No |
|
cpdr_comments |
varchar(255) |
NULL |
Comments |
No |
No |
|
cpdr_linkflag |
varchar(25) |
NULL |
Link Flag P, R, PR, PS , PRS |
No |
No |
|
cpdr_last_performed_date |
datetime |
NULL |
Last Performed Date |
No |
No |
|
CPDR_WORKUNIT_STATUS |
varchar(5) |
NULL |
work unit status |
No |
No |
|
CPDR_SHELFLIFE |
varchar(5) |
NULL |
Shelf Life Expiry |
No |
No |
|
CPDR_SRCDOC_TYPE |
varchar(5) |
NULL |
Source Document type MR - Maint Report EO - Engineering Order |
No |
No |
|
CPDR_Expense_Type |
varchar(5) |
NULL |
Capital, Revenue |
No |
No |
|
|
|||||
|
Table Name cmp_cpe_comp_part_est |
|
||||
|
|
|||||
|
Table Comment Component Program Part Estimates |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cpe_req_qty_in_stock_uom |
numeric(28,8) |
NULL |
required quantity in stock uom |
No |
No |
|
cpe_required_qty |
numeric(28,8) |
NULL |
Part Required Qty |
No |
No |
|
cpe_est_part_createdou |
decimal(38) |
NOT NULL |
Estimated part Created OU - Used to fetch the Description |
No |
No |
|
cpe_warehouse_ou |
decimal(38) |
NULL |
Warehouse OU |
No |
No |
|
cpe_uom |
varchar(10) |
NULL |
Required Qty UOM |
No |
No |
|
cpe_warehouse |
varchar(10) |
NULL |
Estimated Part Warehouse |
No |
No |
|
cpe_partcost |
numeric(28,8) |
NULL |
Part Cost |
No |
No |
|
cpe_part_lineno |
decimal(38) |
NOT NULL |
Estimated Part Line No - Running serial no for a given Part, Program ou |
Yes |
No |
|
cpe_workunit_lineno |
decimal(38) |
NOT NULL |
Component Program Work units Serial No. This would be internally generated no |
|
Yes |
|
cpe_est_part |
varchar(40) |
NOT NULL |
Estimated Part No |
No |
No |
|
cpe_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
cpe_component |
varchar(90) |
NOT NULL |
Component No |
Yes |
Yes |
|
cpe_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
|
|||||
|
Table Name cmp_cper_comp_part_est_rev |
|
||||
|
|
|||||
|
Table Comment Component Program Part Estimates- Revision Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cper_required_qty |
numeric(28,8) |
NULL |
Part Required Qty |
No |
No |
|
cper_uom |
varchar(10) |
NULL |
Required Qty UOM |
No |
No |
|
cper_est_part_createdou |
decimal(38) |
NOT NULL |
Estimated part Created OU - Used to fetch the Description |
No |
No |
|
cper_est_part |
varchar(40) |
NOT NULL |
Estimated Part No |
No |
No |
|
cper_partcost |
numeric(28,8) |
NULL |
Part Cost |
No |
No |
|
cper_warehouse |
varchar(10) |
NULL |
Estimated Part Warehouse |
No |
No |
|
cper_warehouseou |
decimal(38) |
NULL |
Warehouse OU |
No |
No |
|
CPER_REQ_QTY_IN_STOCK_UOM |
numeric(28,8) |
NULL |
required quantity in stock uom |
No |
No |
|
cper_component |
varchar(90) |
NOT NULL |
Component Program Component No |
Yes |
Yes |
|
cper_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
cper_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
cphr_serialno |
varchar(40) |
NOT NULL |
Serial No |
Yes |
Yes |
|
cper_part_lineno |
decimal(38) |
NOT NULL |
Estimated Part Line No - Running serial no for a given Part, Program ou |
Yes |
No |
|
cphr_part_no |
varchar(40) |
NOT NULL |
Part No |
Yes |
Yes |
|
cper_workunit_lineno |
decimal(38) |
NOT NULL |
Component Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
|
|||||
|
Table Name cmp_cph_comp_prg_hdr |
|
||||
|
|
|||||
|
Table Comment Component Program Header - Fresh and Authorised Status stored |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cph_ouinstance |
numeric(10) |
NOT NULL |
Part Program OU |
Yes |
No |
|
cph_component |
varchar(90) |
NOT NULL |
Component No |
Yes |
No |
|
cph_Program_Revision_No |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
No |
|
cph_latest_flag |
varchar(5) |
NULL |
Latest Revision Flag Y - Yes, N - No |
No |
No |
|
cph_part_no |
varchar(40) |
NULL |
Part No |
No |
No |
|
cph_serialno |
varchar(40) |
NULL |
Serial No |
No |
No |
|
cph_created_part_ou |
numeric(10) |
NULL |
Created part OU used to fetch the description |
No |
No |
|
cph_created_compid_ou |
numeric(10) |
NULL |
Component Created OU used to fetch component details |
No |
No |
|
cph_Program_Status |
varchar(5) |
NULL |
Program Status F - Fresh A - Authorized R - Revised |
No |
No |
|
cph_Program_User_Status |
varchar(25) |
NULL |
User Status - Quick Code |
No |
No |
|
cph_Remarks |
varchar(255) |
NULL |
Part program Remarks |
No |
No |
|
cph_Parent_Removal |
varchar(5) |
NULL |
Parent Removal Required Y - Yes N - No |
No |
No |
|
cph_Parent_PartNo |
varchar(40) |
NULL |
Parent Part No to be Removed |
No |
No |
|
cph_creation_date |
datetime |
NOT NULL |
Record Creation date |
No |
No |
|
cph_created_by |
varchar(30) |
NOT NULL |
Record Created by User Id |
No |
No |
|
cph_modified_date |
datetime |
NULL |
Record last modification date |
No |
No |
|
cph_modified_by |
varchar(30) |
NULL |
Record Last modified By |
No |
No |
|
cph_authorized_By |
|
NULL |
Authorized By - login name |
No |
No |
|
cph_authorization_date |
datetime |
NULL |
Authorization date |
No |
No |
|
cph_timestamp |
numeric |
NOT NULL |
Record Timestamp |
No |
No |
|
|
|||||
|
Table Name cmp_cphr_comp_prg_hdr_rev |
|
||||
|
|
|||||
|
Table Comment Component Program Header - Revision Details. This object consists of Revised Status Details |
|||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cphr_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
No |
|
cphr_component |
varchar(90) |
NOT NULL |
Component No |
Yes |
No |
|
cphr_Program_Revision_No |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
No |
|
cphr_part_no |
|
NOT NULL |
Part No |
Yes |
No |
|
cphr_serialno |
|
NOT NULL |
Serial No |
Yes |
No |
|
cphr_created_part_ou |
decimal(38) |
NULL |
Created part OU used to fetch the description |
No |
No |
|
cphr_Program_Status |
varchar(5) |
NULL |
Program Status R- Revised F- Fresh A- Authorised |
No |
No |
|
cphr_Program_User_Status |
varchar(25) |
NULL |
User Status - Quick Code |
No |
No |
|
cphr_Remarks |
varchar(255) |
NULL |
Part program Remarks |
No |
No |
|
cphr_Parent_Removal |
varchar(5) |
NULL |
Parent Removal Required Y - Yes N - No |
No |
No |
|
cphr_Parent_PartNo |
varchar(40) |
NULL |
Parent Part No to be Removed |
No |
No |
|
cphr_creation_date |
datetime |
NULL |
Record Creation date |
No |
No |
|
cphr_created_by |
varchar(30) |
NULL |
Record Created by User Id |
No |
No |
|
cphr_modified_date |
datetime |
NULL |
Record last modification date |
No |
No |
|
cphr_modified_by |
varchar(30) |
NULL |
Record Last modified By |
No |
No |
|
cphr_authorized_By |
|
NULL |
Authorised By - Login name |
No |
No |
|
cphr_authorization_date |
datetime |
NULL |
Authorization date |
No |
No |
|
cphr_timestamp |
decimal(38) |
NOT NULL |
Record Timestamp |
No |
No |
|
|
|||||
|
Table Name cmp_cre_comp_res_est |
|
||||
|
|
|||||
|
Table Comment Component Program Resource (Skill, Facility) Estimates |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cre_reqduration_display |
numeric(28,8) |
NULL |
Required Duration in Display Time unit |
No |
No |
|
cre_timeunit |
varchar(5) |
NOT NULL |
Time unit D - Days H _ hours M _ Mins |
No |
No |
|
cre_resource_ou |
decimal(38) |
NOT NULL |
Resource OU instance |
No |
No |
|
cre_signoff |
varchar(5) |
NULL |
Sign off Required Y/N Y - Yes N - No Applicable for Skill Resource only. In case of Facilities, Always it is N |
No |
No |
|
cre_reqduration_min |
numeric(28,8) |
NULL |
Required Duration in Min |
No |
No |
|
cre_required_qty |
|
NULL |
Required Qty |
No |
No |
|
cre_resource_cost |
|
NULL |
Resource Cost |
No |
No |
|
cre_resource_lineno |
decimal(38) |
NOT NULL |
Resource Line No |
Yes |
No |
|
cre_component |
varchar(90) |
NOT NULL |
Component No |
Yes |
Yes |
|
cre_workunit_lineno |
decimal(38) |
NOT NULL |
Component Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
cre_restype |
varchar(5) |
NOT NULL |
Resource Type F- Facility S - Skill T - Tools E - Equipments O - Others |
No |
No |
|
cre_resourceno |
varchar(40) |
NOT NULL |
Resource No |
No |
No |
|
cre_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
cre_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
|
|||||
|
Table Name cmp_crer_comp_res_est_rev |
|
||||
|
|
|||||
|
Table Comment Component Program Resource (Skill, Facility) Estimates- Revision Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
crer_timeunit |
varchar(5) |
NOT NULL |
Time unit D - Days H _ hours M _ Mins |
No |
No |
|
crer_reqduration_display |
numeric(28,8) |
NULL |
Required Duration in Display Time unit |
No |
No |
|
crer_resource_ou |
decimal(38) |
NOT NULL |
Resource OU instance |
No |
No |
|
crer_restype |
varchar(5) |
NOT NULL |
Resource Type F- Facility S - Skills T - Tools E - Equipment O - Others |
No |
No |
|
crer_signoff |
|
NULL |
Sign off Required Y/N Y - Yes N - No Applicable for Skill Resource only. In case of Facilities, Always it is N |
No |
No |
|
crer_reqduration_min |
numeric(28,8) |
NULL |
Required Duration in Min |
No |
No |
|
crer_required_qty |
numeric(28,8) |
NULL |
Required Qty |
No |
No |
|
crer_resource_cost |
numeric(28,8) |
NULL |
Resource Cost |
No |
No |
|
crer_resource_lineno |
decimal(38) |
NOT NULL |
Resource Line No |
Yes |
No |
|
crer_component |
varchar(90) |
NOT NULL |
Component No |
Yes |
Yes |
|
crer_workunit_lineno |
decimal(38) |
NOT NULL |
Component Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
crer_resourceno |
varchar(40) |
NOT NULL |
Resource No |
No |
No |
|
cphr_serialno |
varchar(40) |
NOT NULL |
Serial No |
Yes |
Yes |
|
cphr_part_no |
varchar(40) |
NOT NULL |
Part No |
Yes |
Yes |
|
crer_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
crer_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
|
|||||
|
Table Name cmp_cus_comp_ub_sch |
|
||||
|
|
|||||
|
Table Comment Component Program Usage Base Schedule Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cus_next_performed_value |
numeric(28,8) |
NULL |
Next Performed Date |
No |
No |
|
cus_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
cus_last_performed_value |
numeric(28,8) |
NULL |
Last Performed Date - Updated after execution of the Work Order |
No |
No |
|
cus_sch_type |
varchar(5) |
NOT NULL |
Schedule Type OT - "One TIme" RC - "Recurring" |
No |
No |
|
cus_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
cus_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
cus_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
cus_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
CUS_TERMINATING_VALUE |
numeric(28,8) |
NULL |
Terminating Value |
No |
No |
|
cus_component |
varchar(90) |
NOT NULL |
Component No |
Yes |
Yes |
|
cus_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
cus_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
cus_param_uom |
varchar(10) |
NOT NULL |
Parameter UOM |
No |
No |
|
CUS_PARAM_OU |
decimal(38) |
NOT NULL |
parameter Ou instance |
No |
No |
|
cus_workunit_lineno |
|
NOT NULL |
Component Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
cus_parameter |
varchar(40) |
NOT NULL |
Parameter |
No |
No |
|
cus_sch_lineno |
decimal(38) |
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
|
|||||
|
Table Name cmp_cusr_comp_ub_sch_rev |
|
||||
|
|
|||||
|
Table Comment Component Program Usage Base Schedule Information- Revision Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cusr_ouinstance |
decimal(38) |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
cusr_component |
varchar(90) |
NOT NULL |
Component No |
Yes |
Yes |
|
cusr_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
cphr_part_no |
|
NOT NULL |
Part No |
Yes |
Yes |
|
cusr_workunit_lineno |
decimal(38) |
NOT NULL |
Component Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
cusr_sch_lineno |
decimal(38) |
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
cphr_serialno |
varchar(40) |
NOT NULL |
Serial No |
Yes |
Yes |
|
cusr_parameter |
|
NOT NULL |
Parameter |
No |
Yes |
|
CUSR_PARAM_OU |
decimal(38) |
NOT NULL |
parameter Ou instance |
No |
Yes |
|
CUSR_PARAM_UOM |
varchar(10) |
NOT NULL |
parameter unit of measurement |
No |
Yes |
|
cusr_sch_type |
varchar(5) |
NOT NULL |
Schedule Type OT - OneTime RC - Recurring |
No |
Yes |
|
cusr_last_performed_value |
numeric(28,8) |
NULL |
Last Performed Date |
No |
Yes |
|
cusr_next_performed_value |
numeric(28,8) |
NULL |
Next Performed Value |
No |
Yes |
|
cusr_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
Yes |
|
cusr_interval |
numeric(28,8) |
NULL |
Interval |
No |
Yes |
|
cusr_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
Yes |
|
cusr_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
Yes |
|
cusr_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
Yes |
|
CUSR_TERMIN_VALUE |
numeric(28,8) |
NULL |
Terminating value |
No |
Yes |
|
|
|||||
|
Table Name cmp_cwpd_cmp_work_pkg_dtl |
|
||||
|
|
|||||
|
Table Comment Component Work package Details - consists of the Work units like SP’s and Tasks |
| ||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cwpd_ouinstance |
numeric |
NOT NULL |
Component Work package OU |
Yes |
Yes |
|
cwpd_wp_code |
varchar(30) |
NOT NULL |
Component Work package Code |
Yes |
Yes |
|
cwpd_workUnit_line_no |
numeric |
NOT NULL |
Work Unit Line No - Running Serial no generated to identify each line no |
Yes |
No |
|
cwpd_workunit_type |
varchar(5) |
NULL |
Wok Unit Type T-task S-stored procedure |
No |
No |
|
cwpd_workunit |
varchar(30) |
NULL |
Work Unit Task or SP |
No |
No |
|
cwpd_workunit_ou |
numeric |
NULL |
Work Unit Created OU |
No |
No |
|
cwpd_workunit_revno |
varchar(40) |
NULL |
Work Unit revision No |
No |
No |
|
cwpd_work_center |
varchar(30) |
NULL |
Work Center |
No |
No |
|
cwpd_workcenter_ou |
numeric |
NULL |
Work Center Created OU |
No |
No |
|
cwpd_mandatory |
varchar(5) |
NULL |
Mandatory Yes or No |
No |
No |
|
|
|||||
|
Table Name cmp_cwph_cmp_work_pkg_hdr |
|
||||
|
|
|||||
|
Table Comment Component Work package Header Table |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cwph_ouinstance |
numeric |
NOT NULL |
Component Work package OU |
Yes |
No |
|
cwph_wp_code |
varchar(30) |
NOT NULL |
Component Work package ode |
Yes |
No |
|
cwph_wpdesc |
varchar(150) |
NULL |
Component Work package Description |
No |
No |
|
cwph_wpdesc_up |
|
NULL |
Work Package Description in Upper Case |
No |
No |
|
cwph_primarywccode |
varchar(30) |
NULL |
Component Work package Primary Work Center Code |
No |
No |
|
cwph_primarywccode_ou |
numeric |
NULL |
Component Work package Primary Work Center OU |
No |
No |
|
cwph_refdoctype |
varchar(25) |
NULL |
Component Work package Reference Doc Type |
No |
No |
|
cwph_refdocno |
varchar(40) |
NULL |
Component Work package Ref Doc |
No |
No |
|
cwph_refdoc_ou |
numeric |
NULL |
Ref Document OU |
No |
No |
|
cwph_timeunit |
varchar(5) |
NULL |
Estimated Duration Time Unit |
No |
No |
|
CWPH_STATUS |
|
NULL |
work package status A- active I- Inactive |
No |
No |
|
cwph_estimatedduration_disp |
numeric(28,8) |
NULL |
Estimation Duration in Display Time Unit (cwph_timeunit) |
No |
No |
|
cwph_estimatedduration_min |
|
NULL |
Estimated Duration in Min |
No |
No |
|
cwph_turnaroundtime_min |
|
NULL |
Turn Around time in Min |
No |
No |
|
cwph_turnaroundtime_disp |
|
NULL |
Turnaround time in Display Unit |
No |
No |
|
cwph_estmanhrs_min |
char(18) |
NULL |
Estimated Man Hours in Minutes. |
No |
No |
|
cwph_estmanhrs_disp |
|
NULL |
Estimated Man Hours - Display |
No |
No |
|
cwph_work_package_type |
varchar(30) |
NULL |
Work Package Type - User Entered Value |
No |
No |
|
cwph_remarks |
varchar(255) |
NULL |
Remarks |
No |
No |
|
cwph_creationdate |
datetime |
NULL |
Component Work package Creation Date |
No |
No |
|
cwph_createdby |
varchar(30) |
NULL |
Component Work package Created By User ID |
No |
No |
|
cwph_modificationdate |
datetime |
NULL |
Component Work package Last Modification Date |
No |
No |
|
cwph_modifiedby |
varchar(30) |
NULL |
Component Work package Last Modified by user id |
No |
No |
|
cwph_timestamp |
numeric |
NULL |
Component Work package Time stamp |
No |
No |
|
|
|||||
|
Table Name cmp_mpd_maint_process_det |
|
||||
|
|
|||||
|
Table Comment Maintenance Process Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
mpd_ouinstance |
numeric |
NOT NULL |
Maintenance Process OU |
Yes |
No |
|
mpd_part |
varchar(25) |
NOT NULL |
maintenance Process Part no |
Yes |
No |
|
mpd_maintain_process |
varchar(5) |
NOT NULL |
Maintain Process Flag indicating the following values HT - "Hard Time", OC - "On-Condition", CM- "Condition Monitoring" in the same order. |
Yes |
No |
|
mpd_part_created_ou |
numeric |
NULL |
maintenance Process Part Created OU - Used to fetch the desc |
No |
No |
|
mpd_remarks |
varchar(255) |
NULL |
Maintenance process Part - Remarks |
No |
No |
|
mpd_updated_date |
datetime |
NULL |
Maintenance Process Updated Dte |
No |
No |
|
mpd_created_date |
|
NULL |
Created Date |
No |
No |
|
mpd_creted_by |
varchar(30) |
NULL |
Create By User - Login Name |
No |
No |
|
mpd_modified_date |
datetime |
NULL |
last Modification Date |
No |
No |
|
mpd_modified_by |
varchar(30) |
NULL |
Last Modified by |
No |
No |
|
mpd_timestamp |
numeric |
NOT NULL |
Time Stamp |
No |
No |
|
|
|||||
|
Table Name cmp_parameter_details |
|
||||
|
|
|||||
|
Table Comment Compone Program Parameter Table |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
cmp_component_name |
varchar(20) |
NOT NULL |
Component Name - BASCMP |
Yes |
No |
|
cmp_param_code |
varchar(5) |
NOT NULL |
parameter Code |
Yes |
No |
|
cmp_param_type |
varchar(25) |
NOT NULL |
param Type |
Yes |
No |
|
cmp_param_cat |
varchar(15) |
NOT NULL |
param Category |
Yes |
No |
|
cmp_langid |
numeric |
NOT NULL |
language ID |
Yes |
No |
|
cmp_param_desc |
varchar(80) |
NOT NULL |
parameter Desc |
No |
No |
|
cmp_prefix_sort_by |
numeric |
NULL |
Prefix Sorted By |
No |
No |
|
cmp_created_date |
datetime |
NOT NULL |
Created Date |
No |
No |
|
|
|||||
|
Table Name cmp_pdbs_part_db_sch |
|
||||
|
|
|||||
|
Table Comment part Program Date based Schedule |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pdbs_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
pdbs_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
pdbs_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
pdbs_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
pdbs_sch_lineno |
numeric |
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
pdbs_sch_type |
varchar(5) |
NOT NULL |
Schedule Type A - "Actual-Interval" , F- "Fixed-Date" |
No |
No |
|
pdbs_timeunit |
varchar(5) |
NOT NULL |
Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years" |
No |
No |
|
pdbs_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
pdbs_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
pdbs_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
pdbs_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
pdbs_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
pdbs_upd_basis |
char(18) |
NULL |
Updation Basis: LD - Last performed Date ID - Installation Date |
No |
No |
|
|
|||||
|
Table Name cmp_pdsd_pos_db_sch_det |
|
||||
|
|
|||||
|
Table Comment part Program Date based Schedule |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pdsd_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
pdsd_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
pdsd_aircraft_model |
varchar(20) |
NOT NULL |
Aircraft Model |
Yes |
Yes |
|
pdsd_config_class |
varchar(30) |
NOT NULL |
Configuration Class |
Yes |
Yes |
|
pdsd_level_no |
varchar(150) |
NOT NULL |
Level no in the Configuration Class |
Yes |
Yes |
|
pdsd_pos_code |
varchar(25) |
NOT NULL |
Position Code in the Configuration Class |
Yes |
Yes |
|
pdsd_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Lineno No. This would be internally generated no |
Yes |
Yes |
|
pdsd_sch_lineno |
numeric |
NOT NULL |
schedule line number |
Yes |
No |
|
pdsd_sch_type |
varchar(5) |
NULL |
Schedule Type A - "Actual-Interval" , F- "Fixed-Date" |
No |
No |
|
pdsd_timeunit |
varchar(5) |
NULL |
Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years" |
No |
No |
|
pdsd_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
pdsd_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
pdsd_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
pdsd_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
pdsd_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
|
|||||
|
Table Name cmp_pdsh_pos_sch_hdr |
|
||||
|
|
|||||
|
Table Comment Part Position Date Based Schedules header |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pdsh_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
pdsh_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
pdsh_aircraft_model |
varchar(20) |
NOT NULL |
Aircraft Model |
Yes |
No |
|
pdsh_config_class |
varchar(30) |
NOT NULL |
Configuration Class |
Yes |
No |
|
pdsh_level_no |
varchar(150) |
NOT NULL |
Level no in the Configuration Class |
Yes |
No |
|
pdsh_pos_code |
varchar(25) |
NOT NULL |
Position Code in the Configuration Class |
Yes |
No |
|
pdsh_link_flag |
|
NULL |
Link Flag S,R,P,PR,PS,PRS |
No |
No |
|
pdsh_status |
varchar(5) |
NULL |
Part - Position Combination data based schedule status A- Authorized F - Fresh |
No |
No |
|
pdsh_authorized_by |
varchar(30) |
NULL |
Authorized By the User |
No |
No |
|
pdsh_authorized_date |
datetime |
NULL |
Authorization Date |
No |
No |
|
pdsh_created_date |
|
NULL |
Created Date |
No |
No |
|
pdsh_created_by |
varchar(30) |
NULL |
Created By |
No |
No |
|
pdsh_modified_by |
|
NULL |
Modified By |
No |
No |
|
pdsh_modified_date |
datetime |
NULL |
Modified Date |
No |
No |
|
pdsh_timestamp |
numeric |
NULL |
Timestamp |
No |
No |
|
|
|||||
|
Table Name cmp_pdsr_part_db_sch_rev |
|
||||
|
|
|||||
|
Table Comment part Program Date based Schedule |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pdsr_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
pdsr_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
pdsr_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
pdsr_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
pdsr_sch_lineno |
numeric |
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
pdsr_sch_type |
varchar(5) |
NOT NULL |
Schedule Type A - "Actual-Interval" , F- "Fixed-Date" |
No |
No |
|
pdsr_timeunit |
varchar(5) |
NOT NULL |
Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years" |
No |
No |
|
pdsr_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
pdsr_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
pdsr_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
pdsr_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
pdsr_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
pdsr_upd_basis |
char(18) |
NULL |
Updation basis: ID - Installation Date LD - Last Performed Date |
No |
No |
|
|
|||||
|
Table Name cmp_pme_part_material_est |
|
||||
|
|
|||||
|
Table Comment Part Program Parts Estimate |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pme_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
pme_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
pme_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
pme_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
pme_part_line_no |
numeric |
NOT NULL |
Estimated Part Line No - Running serial no for a given Part, Progrm ou |
Yes |
No |
|
pme_est_part |
varchar(40) |
NOT NULL |
Estimated Part No - Required Part |
No |
No |
|
pme_est_part_createdou |
numeric |
NOT NULL |
Estimated part Created OU - Used to fetch the Description |
No |
No |
|
pme_required_qty |
numeric(28,8) |
NULL |
Part Required Qty in Display UOM |
No |
No |
|
pme_uom |
varchar(10) |
NULL |
Required Qty UOM |
No |
No |
|
pme_warehouse |
varchar(10) |
NULL |
Estimated Part Warehouse |
No |
No |
|
pme_warehouse_ou |
numeric |
NULL |
Warehouse OU |
No |
No |
|
pme_part_cost |
numeric(28,8) |
NULL |
Part Cost |
No |
No |
|
pme_req_qty_in_stock_uom |
numeric(28,8) |
NULL |
Required Qty In Stok UOM |
No |
No |
|
|
|||||
|
Table Name cmp_pmer_part_material_est_rev |
|
||||
|
|
|||||
|
Table Comment Part Program Parts Estimate |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pmer_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
pmer_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
pmer_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
pmer_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
pmer_part_line_no |
numeric |
NOT NULL |
Estimated Part Line No - Running serial no for a given Part, Program ou |
Yes |
No |
|
pmer_est_part |
varchar(40) |
NOT NULL |
Estimated Part No - Required Part |
No |
No |
|
pmer_est_part_createdou |
numeric |
NOT NULL |
Estimated part Created OU - Used to fetch the Description |
No |
No |
|
pmer_required_qty |
numeric(28,8) |
NULL |
Part Required Qty |
No |
No |
|
pmer_req_qty_in_stock_uom |
numeric(28,8) |
NULL |
Required Qty In Stock UOM |
No |
No |
|
pmer_uom |
varchar(10) |
NULL |
Required Qty UOM |
No |
No |
|
pmer_warehouse |
varchar(10) |
NULL |
Estimated Part Warehouse |
No |
No |
|
pmer_warehouse_ou |
numeric |
NULL |
Warehouse OU |
No |
No |
|
pmer_part_cost |
numeric(28,8) |
NULL |
Part Cost |
No |
No |
|
|
|||||
|
Table Name cmp_ppd_part_prg_det |
|
||||
|
|
|||||
|
Table Comment Part Program Workunit Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
ppd_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
ppd_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
ppd_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
ppd_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Serial No. This would be internally generated no |
Yes |
No |
|
ppd_maint_type |
varchar(5) |
NULL |
"Maintenance Type" defined under maintenance type in the common masters. "Overhaul" "Repair" "Inspection" "Others" |
No |
No |
|
ppd_workunit_type |
|
NOT NULL |
work unit type values T - "Task" S - "Std Procedure" W - "Work Package" |
No |
No |
|
ppd_workunit |
varchar(30) |
NOT NULL |
Work Unit , It could be Task, Stored Procedure or Work package |
No |
No |
|
ppd_workunit_revno |
varchar(40) |
NULL |
Work Unit Revision No |
No |
No |
|
ppd_workunit_ou |
numeric |
NULL |
Work Unit OU Instance - Used to fetch the description |
No |
No |
|
ppd_exec_facility |
varchar(5) |
NULL |
"Execution Facility" I - "In-House" O - "Outsource" |
No |
No |
|
ppd_work_center |
varchar(30) |
NULL |
work center codes in "Active" status defined in the work center components with which this component is interacting And the work units have an associated work center # that is currently not in "Active" status |
No |
No |
|
ppd_work_center_ou |
numeric |
NULL |
Work Center OU |
No |
No |
|
ppd_timeunit |
varchar(5) |
NULL |
Time Unit for Estimated Duration H - Hours D- Days M - Minutes |
No |
No |
|
ppd_turnaroundtime_disp |
numeric(28,8) |
NULL |
Turn Around time in Display Time Unit |
No |
No |
|
ppd_turnaroundtime_min |
numeric(28,8) |
NULL |
Turnaround time in Min |
No |
No |
|
ppd_est_duration_disp |
numeric(28,8) |
NULL |
Estimated Duration in Display Unit |
No |
No |
|
ppd_est_duration_min |
numeric(28,8) |
NULL |
Estimated Duration in Min |
No |
No |
|
ppd_onwing |
varchar(5) |
NULL |
On Wing Y/N Y - Yes N - No |
No |
No |
|
ppd_refdoctype |
varchar(25) |
NULL |
Ref Document Type - Values defined in the common master of RefDoctype |
No |
No |
|
ppd_refdocno |
varchar(40) |
NULL |
Reference Document No |
No |
No |
|
ppd_refdoc_ou |
numeric |
NULL |
Reference Document OU |
No |
No |
|
ppd_eo_refdoc_no |
varchar(18) |
NULL |
EO Ref Document No |
No |
No |
|
ppd_eo_refdoc_revno |
varchar(40) |
NULL |
EO Ref Document Revision No |
No |
No |
|
ppd_refdoc_details |
varchar(255) |
NULL |
Reference Document Details - User Entered Value |
No |
No |
|
ppd_comments |
|
NULL |
Comments |
No |
No |
|
ppd_link_flag |
varchar(25) |
NULL |
Link Flag P, R, PR, PS , PRS ????????? |
No |
No |
|
ppd_workunit_status |
varchar(5) |
NULL |
Work Unit Status A- Active I - Inactive |
No |
No |
|
|
|||||
|
Table Name cmp_ppdr_part_prg_det_rev |
|
||||
|
|
|||||
|
Table Comment Part Program Workunit Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
ppdr_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
ppdr_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
ppdr_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
ppdr_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Serial No. This would be internally generated no |
Yes |
No |
|
ppdr_maint_type |
varchar(5) |
NULL |
"Maintenance Type" defined under maintenance type in the common masters. "Overhaul" "Repair" "Inspection" "Others" |
No |
No |
|
ppdr_workunit_type |
varchar(5) |
NULL |
work unit type values T - "Task" S - "Std Procedure" W - "Work Package" |
No |
No |
|
ppdr_workunit |
varchar(40) |
NULL |
Work Unit , It could be Task, Stored Procedure or Work package |
No |
No |
|
ppdr_workunit_revno |
varchar(40) |
NULL |
work unit revision number |
No |
No |
|
ppdr_workunit_ou |
numeric |
NULL |
Work Unit OU Instance - Used to fetch the description |
No |
No |
|
ppdr_exec_facility |
varchar(5) |
NULL |
"Execution Facility" I - "In-House" O - "Outsource" |
No |
No |
|
ppdr_work_center |
varchar(30) |
NULL |
work center codes in "Active" status defined in the work center components with which this component is interacting And the  work units have an associated work center # that is currently not in "Active" status |
No |
No |
|
ppdr_work_center_ou |
numeric |
NULL |
Work Center OU |
No |
No |
|
ppdr_timeunit |
varchar(5) |
NULL |
Time Unit for Estimated Duration H - Hours D- Days M - Minutes |
No |
No |
|
ppdr_turnaroundtime_disp |
numeric(28,8) |
NULL |
Turn Around time in Display Time Unit |
No |
No |
|
ppdr_turnaround_time_min |
numeric(28,8) |
NULL |
Turnaround time in min |
No |
No |
|
ppdr_est_duration_min |
numeric(28,8) |
NULL |
Estimated Duration in Min |
No |
No |
|
ppdr_est_duration_disp |
numeric(28,8) |
NULL |
Estimated Duration in Disp |
No |
No |
|
ppdr_onwing |
varchar(5) |
NULL |
On Wing Y/N Y - Yes N - No |
No |
No |
|
ppdr_refdoctype |
varchar(25) |
NULL |
Ref Document Type - Values defined in the common master of RefDoctype |
No |
No |
|
ppdr_refdocno |
varchar(40) |
NULL |
Reference Document No |
No |
No |
|
ppdr_refdoc_ou |
numeric |
NULL |
Reference Document OU |
No |
No |
|
ppdr_refdoc_details |
varchar(255) |
NULL |
Reference Document Details _ User Entered Value |
No |
No |
|
ppdr_eo_refdoc_no |
varchar(18) |
NULL |
Eo Reference Document No |
No |
No |
|
ppdr_eo_refdoc_revno |
varchar(40) |
NULL |
EO Reference Document revision No |
No |
No |
|
ppdr_comments |
varchar(255) |
NULL |
Comments |
No |
No |
|
ppdr_link_flag |
varchar(25) |
NULL |
Link Flag S,P, R, PR, PS , PRS |
No |
No |
|
ppdr_workunit_status |
varchar(5) |
NULL |
Work Unit Status A- Active or I - Inactive |
No |
No |
|
PPDR_TIMESTAMP |
numeric |
NULL |
timestamp |
No |
No |
|
|
|||||
|
Table Name cmp_pph_part_prg_hdr |
|
||||
|
|
|||||
|
Table Comment Part Program Header |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pph_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
No |
|
pph_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
No |
|
pph_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
No |
|
pph_latest_flag |
varchar(5) |
NULL |
Latest Revision Flag Y - Yes, N - No |
No |
No |
|
pph_created_part_ou |
numeric |
NULL |
Created part OU used to fetch the description |
No |
No |
|
pph_Program_Status |
varchar(5) |
NULL |
Program Status F - Fresh A - Authorized |
No |
No |
|
pph_Program_User_Status |
varchar(25) |
NULL |
User Status - Quick Code |
No |
No |
|
pph_Remarks |
varchar(255) |
NULL |
Part program Remarks |
No |
No |
|
pph_Parent_Removal |
varchar(5) |
NULL |
Parent Removal Required Y - Yes N - No |
No |
No |
|
pph_Parent_Part_No |
varchar(16) |
NULL |
Parent Part No to be Removed |
No |
No |
|
pph_creation_date |
datetime |
NOT NULL |
Record Creation date |
No |
No |
|
pph_created_by |
varchar(30) |
NOT NULL |
Record Created by User Id |
No |
No |
|
pph_modified_date |
datetime |
NULL |
Record last modification date |
No |
No |
|
pph_modified_by |
varchar(30) |
NULL |
Record Last modified By |
No |
No |
|
pph_authorized_By |
varchar(30) |
NULL |
Authorized By user name |
No |
No |
|
pph_authorization_Date |
datetime |
NULL |
Authorized date |
No |
No |
|
pph_timestamp |
numeric |
NOT NULL |
Record Timestamp |
No |
No |
|
|
|||||
|
Table Name cmp_pphr_part_prg_hdr_rev |
|
||||
|
|
|||||
|
Table Comment Part Program Header |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pphr_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
No |
|
pphr_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
No |
|
pphr_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
No |
|
pphr_created_part_ou |
numeric |
NULL |
Created part OU used to fetch the description |
No |
No |
|
pphr_Program_Status |
varchar(5) |
NULL |
Program Status F - Fresh A - Authorized |
No |
No |
|
pphr_Program_User_Status |
varchar(25) |
NULL |
User Status - Quick Code |
No |
No |
|
pphr_Remarks |
varchar(255) |
NULL |
Part program Remarks |
No |
No |
|
pphr_Parent_Removal |
varchar(5) |
NULL |
Parent Removal Required Y - Yes N - No |
No |
No |
|
pphr_Parent_Part_No |
varchar(40) |
NULL |
Parent Part No to be Removed |
No |
No |
|
pphr_creation_date |
datetime |
NULL |
Record Creation date |
No |
No |
|
pphr_created_by |
varchar(30) |
NULL |
Record Created by User Id |
No |
No |
|
pphr_modified_date |
datetime |
NULL |
Record last modification date |
No |
No |
|
pphr_modified_by |
varchar(30) |
NULL |
Record Last modified By |
No |
No |
|
pphr_authorized_By |
varchar(30) |
NULL |
Authorised by |
No |
No |
|
pphr_authorization_Date |
datetime |
NULL |
Authorization date |
No |
No |
|
pphr_timestamp |
numeric |
NULL |
Record Timestamp |
No |
No |
|
|
|||||
|
Table Name cmp_pre_part_res_est |
|
||||
|
|
|||||
|
Table Comment Part Program Resource (Skill, Facility) Estimates |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pre_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
pre_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
pre_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
pre_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
pre_resource_lineno |
|
NOT NULL |
Resource Line No |
Yes |
No |
|
pre_resourceno |
varchar(40) |
NOT NULL |
Resource No |
No |
No |
|
pre_restype |
varchar(5) |
NOT NULL |
Resource Type F- Facility S - Skill |
No |
No |
|
pre_resource_ou |
numeric |
NOT NULL |
Resource OU instance |
No |
No |
|
pre_timeunit |
varchar(5) |
NULL |
Time unit D - Days H _ hours M _ Mins |
No |
No |
|
pre_reqduration_display |
numeric(28,8) |
NULL |
Required Duration in Display Time unit |
No |
No |
|
pre_reqduration_min |
numeric(28,8) |
NULL |
Required Duration in Min |
No |
No |
|
pre_reqqty |
numeric(28,8) |
NULL |
Required Qty |
No |
No |
|
pre_signoff |
varchar(5) |
NULL |
Sign off Required Y/N Y - Yes N - No Applicable for Skill Resource only. In case of Facilities, Always it is N |
No |
No |
|
pre_resource_cost |
numeric(28,8) |
NULL |
Resource Cost |
No |
No |
|
|
|||||
|
Table Name cmp_prer_part_res_est_rev |
|
||||
|
|
|||||
|
Table Comment Part Program Resource (Skill, Facility) Estimates |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
prer_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
prer_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
prer_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
prer_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
prer_resource_lineno |
|
NOT NULL |
Resource Line No |
Yes |
No |
|
prer_resourceno |
varchar(40) |
NOT NULL |
Resource No |
No |
No |
|
prer_restype |
varchar(5) |
NOT NULL |
Resource Type F- Facility S - Skill |
No |
No |
|
prer_resource_ou |
numeric |
NOT NULL |
Resource OU instance |
No |
No |
|
prer_timeunit |
varchar(5) |
NULL |
Time unit D - Days H _ hours M _ Mins |
No |
No |
|
prer_reqduration_display |
numeric(28,8) |
NULL |
Required Duration in Display Time unit |
No |
No |
|
prer_reqduration_min |
numeric(28,8) |
NULL |
Required Duration in Min |
No |
No |
|
prer_reqqty |
numeric(28,8) |
NULL |
Required Qty |
No |
No |
|
prer_signoff |
varchar(5) |
NULL |
Sign off Required Y/N Y - Yes N - No Applicable for Skill Resource only. In case of Facilities, Always it is N |
No |
No |
|
prer_resource_cost |
numeric(28,8) |
NULL |
Resource Cost |
No |
No |
|
|
|||||
|
Table Name cmp_pubs_part_ub_sch |
|
||||
|
|
|||||
|
Table Comment Part Program Usage Base Schedule Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pubs_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
pubs_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
pubs_program_revision_no |
|
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
pubs_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
pubs_sch_lineno |
|
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
pubs_parameter |
varchar(40) |
NOT NULL |
Parameter |
No |
No |
|
pubs_param_ou |
numeric |
NOT NULL |
Parameter OU |
No |
No |
|
pubs_param_uom |
varchar(10) |
NULL |
Parameter UOM |
No |
No |
|
pubs_sch_type |
varchar(5) |
NOT NULL |
Schedule Type A - "Actual-Interval" , F- "Fixed-Date" |
No |
No |
|
pubs_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
pubs_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
pubs_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
pubs_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
pubs_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
|
|||||
|
Table Name cmp_pusd_pos_usage_sch_det |
|
||||
|
|
|||||
|
Table Comment Part Program Usage Base Schedule Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pusd_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
pusd_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
pusd_aircraft_model |
varchar(20) |
NOT NULL |
Aircraft Model |
Yes |
Yes |
|
pusd_config_class |
varchar(30) |
NOT NULL |
Configuration Class |
Yes |
Yes |
|
pusd_level_no |
varchar(150) |
NOT NULL |
Level no in the Configuration Class |
Yes |
Yes |
|
pusd_pos_code |
varchar(25) |
NOT NULL |
Position Code in the Configuration Class |
Yes |
Yes |
|
pusd_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Lineno No. This would be internally generated no |
Yes |
Yes |
|
pusd_sch_lineno |
|
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
pusd_parameter |
varchar(40) |
NULL |
Parameter |
No |
No |
|
pusd_parameter_ou |
numeric |
NULL |
Parameter OU |
No |
No |
|
pusd_parameter_uom |
varchar(10) |
NULL |
Parameter UOM |
No |
No |
|
pusd_sch_type |
varchar(5) |
NULL |
Schedule Type A - "Actual-Interval" , F- "Fixed-Date" |
No |
No |
|
pusd_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
pusd_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
pusd_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
pusd_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
pusd_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
|
|||||
|
Table Name cmp_pusr_part_ub_sch_rev |
|
||||
|
|
|||||
|
Table Comment Part Program Usage Base Schedule Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
pusr_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
Yes |
|
pusr_part_no |
varchar(40) |
NOT NULL |
Part No for the Program |
Yes |
Yes |
|
pusr_program_revision_no |
varchar(40) |
NOT NULL |
Part program Revision No. Initial value would be Zero. |
Yes |
Yes |
|
pusr_workunit_lineno |
numeric |
NOT NULL |
Part Program Work units Serial No. This would be internally generated no |
Yes |
Yes |
|
pusr_sch_lineno |
numeric |
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
pusr_parameter |
varchar(40) |
NOT NULL |
Parameter |
No |
No |
|
pusr_param_ou |
numeric |
NOT NULL |
Parameter OU |
No |
No |
|
pusr_param_uom |
varchar(10) |
NULL |
Parameter UOM |
No |
No |
|
pusr_sch_type |
varchar(5) |
NOT NULL |
Schedule Type A - "Actual-Interval" , F- "Fixed-Date" |
No |
No |
|
pusr_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
pusr_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
pusr_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
pusr_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
pusr_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
|
|||||
|
Table Name cmp_rwi_restoration_wu_info |
|
||||
|
|
|||||
|
Table Comment Part Restoration Work unit Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
rwi_ouinstance |
numeric |
NOT NULL |
Part Program OU |
Yes |
No |
|
rwi_part_no |
varchar(25) |
NOT NULL |
Part No |
Yes |
No |
|
rwi_part_created_ou |
numeric |
NULL |
Part Created Ou used to fetch the Description |
No |
No |
|
rwi_workunit_type |
varchar(5) |
NULL |
Work unit Type T - Task S -Standard procedures |
No |
No |
|
rwi_workunit |
varchar(25) |
NULL |
Work Unit No |
No |
No |
|
rwi_workunit_ou |
numeric |
NULL |
Work Unit OU - Used to fetch description |
No |
No |
|
rwi_comments |
varchar(255) |
NULL |
Comments |
No |
No |
|
rwi_created_date |
datetime |
NULL |
Created Date |
No |
No |
|
rwi_created_by |
varchar(30) |
NULL |
Created By |
No |
No |
|
rwi_modified_Date |
datetime |
NULL |
Modification Date |
No |
No |
|
rwi_modified_by |
varchar(30) |
NULL |
Modified By |
No |
No |
|
rwi_timestamp |
numeric |
NOT NULL |
Timestamp |
No |
No |
|
rwi_incoming_part_est |
varchar(25) |
NULL |
Ic Coming Part Estimated Flag Y - Yes N - No |
No |
No |
|
rwi_workunit_revno |
varchar(25) |
NULL |
Work Unit Revision No |
No |
No |
|
|
|||||
|
Table Name cmp_upds_upd_db_sch |
|
||||
|
|
|||||
|
Table Comment part Program Date based Schedule |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
upds_ouinstance |
numeric |
NOT NULL |
ouinstance |
Yes |
Yes |
|
upds_wu_updateno |
varchar(50) |
NOT NULL |
Work unit updation number |
Yes |
Yes |
|
UPDS_SCH_ID |
numeric |
NOT NULL |
schedule id |
Yes |
No |
|
upds_sch_type |
varchar(5) |
NULL |
Schedule Type A - "Actual-Interval" , F- "Fixed-Date" |
No |
No |
|
upds_timeunit |
varchar(5) |
NULL |
Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years" |
No |
No |
|
upds_threshold |
numeric(28,8) |
NULL |
Threshold value |
No |
No |
|
upds_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
upds_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
upds_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
upds_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
|
|||||
|
Table Name cmp_upus_upd_ub_sch |
|
||||
|
|
|||||
|
Table Comment Part Program Usage Base Schedule Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
upus_ouinstance |
numeric |
NOT NULL |
ouinstance |
Yes |
Yes |
|
upus_wu_update_no |
varchar(50) |
NOT NULL |
work unit updation number |
Yes |
Yes |
|
UPUS_SCH_ID |
numeric |
NOT NULL |
schedule id |
Yes |
No |
|
upus_parameter |
varchar(40) |
NULL |
Parameter |
No |
No |
|
UPUS_PARAMETER_OU |
numeric |
NULL |
parameter OU instance |
No |
No |
|
UPUS_PARAM_UOM |
varchar(10) |
NULL |
Parameter unit of measurement |
No |
No |
|
upus_sch_type |
varchar(5) |
NULL |
Schedule Type A - "Actual-Interval" , F- "Fixed-Date" |
No |
No |
|
upus_timeunit |
varchar(5) |
NULL |
Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years" |
No |
No |
|
upus_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
upus_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
upus_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
upus_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
upus_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
|
|||||
|
Table Name cmp_uwip_update_wu_in_prg |
|
||||
|
|
|||||
|
Table Comment Update Work Unit information In Programs |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
uwip_ouinstance |
numeric |
NOT NULL |
ouinstance |
Yes |
No |
|
UWIP_WU_UPDATE_NO |
varchar(18) |
NOT NULL |
work unit update number |
Yes |
No |
|
UWIP_WORKUNIT |
varchar(30) |
NULL |
work unit code |
No |
No |
|
uwip_workunit_type |
varchar(250) |
NULL |
Work Unit Type T-task S-stored procedure W-work package |
No |
No |
|
UWIP_WU_REV_NO |
varchar(40) |
NULL |
Work unit revision number |
No |
No |
|
uwip_maintenance_type |
varchar(5) |
NULL |
Maintenance Type OVH- overhaul REP- repair INS - inspection OTH - others |
No |
No |
|
uwip_ref_doc_type |
varchar(25) |
NULL |
Reference Document Type |
No |
No |
|
uwip_ref_doc_no |
varchar(40) |
NULL |
Reference Doc No |
No |
No |
|
uwip_comments |
varchar(255) |
NULL |
Update Work Unit Comments |
No |
No |
|
uwip_updated_by |
varchar(30) |
NULL |
Updated by the user name - Login User |
No |
No |
|
uwip_updated_date |
datetime |
NULL |
Updated Date |
No |
No |
|
uwip_execution_facility |
varchar(5) |
NULL |
Execution Facility I - Inhouse O - Out Source |
No |
No |
|
uwip_exec_workcenter |
varchar(30) |
NULL |
execution Work Center |
No |
No |
|
uwip_exec_timeunit |
|
NULL |
Execution Time Unit |
No |
No |
|
uwip_est_duration |
numeric(20) |
NULL |
Estimated Duration |
No |
No |
|
uwip_turnaround_time |
|
NULL |
Turn Around Time |
No |
No |
|
uwip_onwing |
varchar(5) |
NULL |
On Wing Y - Yes N - No |
No |
No |
|
UWIP_NUM_TYPE |
varchar(15) |
NULL |
Numbering Type |
No |
No |
|
uwip_upd_status |
varchar(30) |
NULL |
Work Unit Update Status Draft - The WU Change would be in draft status when the transaction created without checking Update Programs Authorized - - The WU Change would be in Authorized status when the transaction created By checking Update Programs Cancelled - - The WU Change would be in Cancelled status when the transaction created without checking Update Programs and later cancelled by cancel update task |
No |
No |
|
uwip_link_flag |
varchar(15) |
NULL |
Link Flag Indicating the Schedules Defined ot Not. DB - Date Based Schedules Only Defined UB - Usage Based Schedules Only Defined DU - Date and Usage Based Schedules Defined |
No |
No |
|
uwip_incorporated |
varchar(1) |
NULL |
Incorporated the changes Y- Yes N - No |
No |
No |
|
UWIP_TIMESTAMP |
numeric |
NULL |
TimeStamp |
No |
No |
|
|
|||||
|
Table Name cmp_uwpd_update_wu_part_det |
|
||||
|
|
|||||
|
Table Comment Update Work Unit Part Details |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
uwpd_ouinstance |
numeric |
NOT NULL |
ouinstance |
Yes |
Yes |
|
uwpd_line_no |
|
NOT NULL |
Unique line no in a WU Update no - used for processing the each line separately |
Yes |
No |
|
uwpd_wu_update_no |
varchar(18) |
NOT NULL |
work unit update number |
Yes |
Yes |
|
uwpd_component_no |
varchar(90) |
NULL |
component of the program in which the WU to be changed |
No |
No |
|
uwpd_serial_no |
varchar(40) |
NULL |
Serialno of the program in which the WU to be changed |
No |
No |
|
uwpd_part_no |
|
NULL |
Part no in which WU to be changed |
No |
No |
|
uwpd_action |
varchar(5) |
NULL |
A -Append or D - delete |
No |
No |
|
uwpd_wu_change_inc |
varchar(1) |
NULL |
WU Change Incorporation at part level Completed Y - Yes N - No |
No |
No |
|
uwpd_db_sch_change_inc |
varchar(1) |
NULL |
Date Based Schedule Changes Completed UY - Yes, N- No |
No |
No |
|
uwpd_ub_sch_change_inc |
varchar(1) |
NULL |
Usage based Schedules Completed Y - Yes, N - No |
No |
No |
|
|
|||||
|
Table Name CMP_WDBS_WP_DATEBASED_SCH |
|
||||
|
|
|||||
|
Table Comment Work package Date based Schedule |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
wdbs_sch_lineno |
numeric |
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
wdbs_ouinstance |
|
NOT NULL |
Component Work package OU |
Yes |
Yes |
|
wdbs_wp_code |
varchar(30) |
NOT NULL |
Component Work package Code |
Yes |
Yes |
|
wdbs_sch_type |
varchar(5) |
NOT NULL |
Schedule Type A - "Actual-Interval" , F- "Fixed-Date" |
No |
No |
|
wdbs_timeunit |
|
NOT NULL |
Time Unit D - "Days", W - "Weeks" M - "Months" Y -"Years" |
No |
No |
|
wdbs_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
wdbs_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
wdbs_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
wdbs_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
wdbs_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
|
|||||
|
Table Name cmp_wme_wp_material_est |
|
||||
|
|
|||||
|
Table Comment Work package Parts Estimate |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
wme_part_line_no |
numeric |
NOT NULL |
Estimated Part Line No - Running serial no for a given Part, Program ou |
Yes |
No |
|
wme_ouinstance |
|
NOT NULL |
Component Work package OU |
Yes |
Yes |
|
wme_wp_code |
varchar(30) |
NOT NULL |
Component Work package Code |
Yes |
Yes |
|
wme_est_part |
varchar(40) |
NOT NULL |
Estimated Part No - Required Part |
No |
No |
|
wme_est_part_createdou |
numeric |
NOT NULL |
Estimated part Created OU - Used to fetch the Description |
No |
No |
|
wme_required_qty |
numeric(28,8) |
NULL |
Part Required Qty |
No |
No |
|
wme_uom |
varchar(10) |
NULL |
Required Qty UOM |
No |
No |
|
wme_warehouse |
varchar(10) |
NULL |
Estimated Part Warehouse |
No |
No |
|
wme_warehouse_ou |
numeric |
NULL |
Warehouse OU |
No |
No |
|
wme_part_cost |
numeric(28,8) |
NULL |
Part Cost |
No |
No |
|
wme_req_qty_in_stock_uom |
numeric(28,8) |
NULL |
Required Qty in Stock UOM |
No |
No |
|
|
|||||
|
Table Name cmp_wpe_wo_part_effectivity |
|
||||
|
|
|||||
|
Table Comment part Effectivity Details for an Work Package |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
wpe_ouinstance |
numeric |
NOT NULL |
Component Work package OU |
Yes |
Yes |
|
wpe_wp_code |
varchar(30) |
NOT NULL |
Component Work package Code |
Yes |
Yes |
|
wpe_part_no |
varchar(40) |
NOT NULL |
Part no |
Yes |
No |
|
wpe_part_created_ou |
numeric |
NULL |
Part Created OU |
No |
No |
|
wpe_part_applicability |
varchar(5) |
NULL |
Part Applicability to the Work package Y - yes N - No |
No |
No |
|
wpe_created_by |
varchar(30) |
NULL |
Created by user id |
No |
No |
|
wpe_created_Date |
datetime |
NULL |
Created Date |
No |
No |
|
wpe_last_modified_by |
varchar(30) |
NULL |
Last modified By |
No |
No |
|
wpe_last_modified_date |
datetime |
NULL |
Last Modified Date |
No |
No |
|
|
|||||
|
Table Name cmp_wre_wp_res_estimate |
|
||||
|
|
|||||
|
Table Comment Work Package Resource (Skill, Facility) Estiamtes |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
wre_resource_lineno |
numeric |
NOT NULL |
Resource Line No |
Yes |
No |
|
wre_ouinstance |
numeric |
NOT NULL |
Component Work package OU |
Yes |
Yes |
|
wre_wp_code |
varchar(30) |
NOT NULL |
Component Work package Code |
Yes |
Yes |
|
wre_resourceno |
varchar(40) |
NOT NULL |
Resource No |
No |
No |
|
wre_restype |
varchar(5) |
NOT NULL |
Resource Type F- Facility S - Skill |
No |
No |
|
wre_resource_ou |
numeric |
NOT NULL |
Resource OU instance |
No |
No |
|
wre_timeunit |
varchar(5) |
NOT NULL |
Time unit D - Days H _ hours M _ Mins |
No |
No |
|
wre_reqduration_display |
numeric(28,8) |
NULL |
Required Duration in Display Time unit |
No |
No |
|
wre_reqduration_min |
numeric(28,8) |
NULL |
Required Duration in Min |
No |
No |
|
wre_reqqty |
numeric(28,8) |
NULL |
Required Qty |
No |
No |
|
wre_resource_cost |
numeric(28,8) |
NULL |
Resource Cost |
No |
No |
|
wre_sign_off |
varchar(5) |
NULL |
Sign Off Required Y - Yes N - No |
No |
No |
|
|
|||||
|
Table Name cmp_wubs_wp_usagebased_sch |
|
||||
|
|
|||||
|
Table Comment Work package Usage Base Schedule Information |
|
||||
|
Table Column Name |
Table Column Datatype |
Table Column Null Option |
Table Column Comment |
Table Column Is PK |
Table Column Is FK |
|
Table Column Name |
numeric |
NOT NULL |
Schedule Line No - System Generated unique no for the given part no, pdbs_wu_serialno |
Yes |
No |
|
wubs_ouinstance |
numeric |
NOT NULL |
Component Work package OU |
Yes |
Yes |
|
wubs_wp_code |
varchar(30) |
NOT NULL |
Component Work package Code |
Yes |
Yes |
|
wubs_parameter |
varchar(40) |
NOT NULL |
Parameter |
No |
No |
|
wubs_param_ou |
numeric |
NOT NULL |
Parameter OU |
No |
No |
|
wubs_param_uom |
varchar(10) |
NOT NULL |
Parameter UOM |
No |
No |
|
wubs_sch_type |
varchar(5) |
NOT NULL |
Schedule Type A - "Actual-Interval" , F- "Fixed-Date" |
No |
No |
|
wubs_threshold |
numeric(28,8) |
NULL |
Threshold |
No |
No |
|
wubs_interval |
numeric(28,8) |
NULL |
Interval |
No |
No |
|
wubs_alertvalue |
numeric(28,8) |
NULL |
Alert value |
No |
No |
|
wubs_pos_tolerance |
numeric(28,8) |
NULL |
Positive Tolerance |
No |
No |
|
wubs_neg_tolerance |
numeric(28,8) |
NULL |
Negative Tolerance |
No |
No |
|
|
|
|
|
|
|