| Data Dictionary -- Work Center | ||||||||
| Srl. No. | Table Name | Comment |
| 1 | BAS_WCLOG_WC_LOGICAL_WC_DTL | Work center master information is stored here |
| 2 | BAS_WC_EMP_MOV_HIST | Employee movement histroy |
| 3 | BAS_WC_FAC_FACILITY | Facility Master |
| 4 | BAS_WC_WCCERA_WC_CERT_APPL | Certificate Applicability (model\component) stored for workcenter. |
| 5 | BAS_WC_WCCER_WC_CERTI_DET | Certificate no stored for workcenter. |
| 6 | BAS_WC_WCMTYP_COM_MAINT_TYP | Maintanance type stored for component and workcenter. |
| 7 | BAS_WC_WCOUDT_OU_LEV_WCDET | Certifcate level code for the workcenter. |
| 8 | BAS_WC_WCUSR_WC_USER_MAP | Work center user rights detail |
| 9 | BAS_WC_WCWHM_WH_MAP | This table will store information regarding work center and warehouse mapping (both issue and return warehouse) |
| 10 | BAS_WC_WEMP_EMP_MAP | List of employees associated to the Work Center |
| 11 | BAS_WC_WFAC_WC_FAC_MAP | Facility Association to Work Center |
| 12 | BAS_WC_WFO_FACILITY_OBJECTS | Facility Object Master.This lists the individual units in the facility code identified |
| 13 | BAS_WC_WME_MODEL_EFFECTIVITY | Model Effectivity For the Work Centers |
| 14 | BAS_WC_WMWU_MODEL_WORK_UNIT | List of Work Units associated to the Aircraft Model identified in the Work Center |
| 15 | BAS_WC_WPRT_COMP_PART_MAP | Associated Base Component Part Id Information For the Work Center |
| 16 | BAS_WC_WPWU_PART_WORK_UNIT | Work units associated with the component part id identified in the work center |
| 17 | BAS_WC_WQC_QUICK_CODE | Quick Codes Definition For the Work Center Component |
| 18 | BAS_WC_WRKC_WORK_CENTER | The work center association details are maintained here |
| Table Name : | |
| Comment : | Work center master information is stored here |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WCLOG_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Created OUInstance | Yes |
| WCLOG_WORK_CENTER | _varchar_30 | varchar(30) | No | Created OUInstance Work center | Yes |
| WCLOG_DESCRIPTION | _varchar_150 | varchar(150) | No | This abstract information gets copied to the Mapped OUInstances while associating Wc to OUs in Maintain Org Unit activity or at the time of creation when the associate flag is set to yes | No |
| WCLOG_DESCRIPTION_UP | _varchar_150 | varchar(150) | No | Description Stored in Upper case. | No |
| WCLOG_CATEGORY | _varchar_25 | Varchar(25) | Yes | Category | No |
| WCLOG_WC_TYPE | _varchar_5 | varchar(5) | Yes | It will store the workcenter type "Hangar", "Bay", and "Others". The code for these types will be stored. | No |
| WCLOG_STATUS | _varchar_15 | varchar(15) | Yes | This abstract information gets copied to the Mapped OUInstances while associating Wc to OUs in Maintain Org Unit activity or at the time of creation when the associate flag is set to yes. | No |
| WCLOG_USERID | _varchar_30 | varchar(30) | Yes | Status of the Association. Can either be Active or Inactive | No |
| WCLOG_CREATIONDATE | _datetime_8 | datetime(8) | Yes | Creation Date | No |
| WCLOG_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | Last Modified Date | No |
| WCLOG_MODIFIED_BY | _varchar_30 | varchar(30) | No | Last Modified Userid | No |
| WCLOG_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp | No |
| wclog_wc_class | udd_quickcodes | varchar(25) | Yes | Work center class | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | Employee movement histroy |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| MOV_OUINSTANCE | udd_ctxt_ouinstance | int(4) | No | Ouinstance | No |
| MOV_WORK_CENTER | udd_wccode | varchar(30) | No | Move work center | No |
| MOV_EMPCODE | udd_hrempcode | varchar(20) | No | Employee code | No |
| MOV_FROM_DATE | _datetime_8 | datetime(8) | Yes | From date | No |
| MOV_TO_DATE | _datetime_8 | datetime(8) | Yes | To date | No |
| MOV_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Time stamp | No |
| replication_key | _bigint_8 | Bigint(8) | No | Replication key | Yes |
| Table Name : | |
| Comment : | Facility Master |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| FAC_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance code | Yes |
| FAC_FACILITY_NO | _varchar_40 | varchar(40) | No | Facility number | Yes |
| FAC_TYPE | _varchar_25 | Varchar(25) | No | Facility Type can be Equipment, Tools or Others | Yes |
| FAC_DESCRIPTION | _varchar_150 | varchar(150) | No | Description Of the Facility Code | No |
| FAC_DESCRIPTION_UP | _varchar_150 | varchar(150) | No | Description in Upper case | No |
| FAC_RATE_PER_HOUR | _decimal_28_0 | decimal(28) | Yes | Rate per hour | No |
| FAC_CATEGORY | _varchar_25 | Varchar(25) | Yes | Category of the Facility. Quick codes defined as Facility Category are valid category codes | No |
| FAC_PART_NO | _varchar_40 | varchar(40) | Yes | Part No | No |
| FAC_PART_OU | _decimal_10_0 | decimal(10) | Yes | Ouinstance where part no created. | No |
| FAC_CAPACITY | _varchar_40 | varchar(40) | Yes | Capacity of the Facility | No |
| FAC_STATUS | _varchar_15 | varchar(15) | Yes | Status Of the Facility Code. Can be Active or Inactive | No |
| FAC_CREATIONDATE | _datetime_8 | datetime(8) | No | Creation Date of the Facility Code | No |
| FAC_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | Last Modified Date of the Facility Code | No |
| FAC_USERID | _varchar_30 | varchar(30) | No | Last Modified User Name | No |
| FAC_MODIFIED_BY | _varchar_30 | varchar(30) | No | Last Modified By | No |
| FAC_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | Certificate Applicability (model\component) stored for workcenter. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WCCERA_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Mapped OUInstance | Yes |
| WCCERA_WORK_CENTER | _varchar_30 | varchar(30) | No | Mapped OUInstance Work Center Code | Yes |
| WCCERA_CERTIFICATE_NO | _varchar_40 | varchar(40) | No | certificate number | Yes |
| WCCERA_MODEL_NO | _varchar_20 | varchar(20) | No | model number | Yes |
| WCCERA_PART_OR_PART_GRP | _varchar_40 | varchar(40) | No | Flag to indicate | Yes |
| WCCERA_PARTOU | _decimal_10_0 | decimal(10) | Yes | Part OUinstance | No |
| WCCERA_MODELOU | _decimal_10_0 | decimal(10) | Yes | Model Ouinstance will be stored. | No |
| WCCERA_ASSOCIATE_PART_APPL | _varchar_5 | varchar(5) | Yes | Associate Part Applicability flag. | No |
| WCCERA_MAINTTYPE | _varchar_5 | varchar(5) | No | Maintenance type that can be performed in the work center. | No |
| WCCERA_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks. | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | Certificate no stored for workcenter. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WCCER_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Mapped OUInstance | Yes |
| WCCER_WORK_CENTER | _varchar_30 | varchar(30) | No | Mapped OUInstance Work Center Code | Yes |
| WCCER_CERTIFICATE_NO | _varchar_40 | varchar(40) | No | Certificate No | Yes |
| WCCER_CERT_TITLE | _varchar_80 | varchar(80) | Yes | Certificate title | No |
| WCCER_CERT_AUTHORITY | _varchar_25 | Varchar(25) | No | Certificate Authority | Yes |
| WCCER_CERT_TYPE | _varchar_25 | Varchar(25) | Yes | Certificate type. | No |
| WCCER_CERT_APPLICABILITY | _varchar_5 | varchar(5) | Yes | Certificate Applicability | No |
| WCCER_CERTIFICATE_GRP | _varchar_25 | Varchar(25) | Yes | Certificate group | No |
| WCCER_DATE_OF_ISSUE | _datetime_8 | datetime(8) | Yes | Issue date | No |
| WCCER_VALID_FROM_DATE | _datetime_8 | datetime(8) | Yes | Valid from date | No |
| WCCER_VALID_TO_DATE | _datetime_8 | datetime(8) | Yes | Valid to date | No |
| WCCER_COMMENTS | _varchar_255 | varchar(255) | Yes | Comments | No |
| WCCER_REMARKS | _varchar_255 | varchar(255) | Yes | Remarks | No |
| WCCER_FILE_NAME | _varchar_50 | varchar(50) | Yes | File Name | No |
| WCCER_EFFECT_BASIS | _varchar_5 | varchar(5) | Yes | Effectivity Basis | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | Maintanance type stored for component and workcenter. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WCMTYP_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance | Yes |
| WCMTYP_WORK_CENTER | _varchar_30 | varchar(30) | No | Work Center | Yes |
| WCMTYP_PART_NO | _varchar_40 | varchar(40) | No | Part Number | Yes |
| WCMTYP_MAINT_TYPE | _varchar_15 | varchar(15) | No | Maintanance Type | Yes |
| WCMTYP_CAPABILITY_FLAG | _varchar_15 | varchar(15) | Yes | Capability Flag. | No |
| WCMTYP_ASSOCIATION_COUNT | _decimal_10_0 | decimal(10) | Yes | Number of the Work Units associated with the part.(design purpose) | No |
| Table Name : | |
| Comment : | Certifcate level code for the workcenter. |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WCOUDT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Mapped OUInstance | Yes |
| WCOUDT_WORK_CENTER | _varchar_30 | varchar(30) | No | Mapped OUInstance Work Center Code | Yes |
| WCOUDT_ROTA_SCHEDULE_CODE | _varchar_10 | varchar(10) | Yes | Schdule code which is refferred from HRMP | No |
| WCOUDT_WORK_PHONE | _varchar_70 | varchar(70) | Yes | Work Phone | No |
| WCOUDT_COMMENTS | _varchar_255 | varchar(255) | Yes | Comments | No |
| WCOUDT_ROTA_SCHCODE_OU | _decimal_10_0 | decimal(10) | Yes | Schedule code Ouinstance Will be stored. | No |
| WCOUDT_STATION_CODE | _varchar_25 | Varchar(25) | Yes | Station Code for the Work Center | No |
| WCOUDT_STATION_OU | _decimal_10_0 | decimal(10) | Yes | Station code Ouinstance Will be stored. | No |
| WCOUDT_LUNCH_START_TIME | _datetime_8 | datetime(8) | Yes | Lunch Start Time will be stored if entered. | No |
| WCOUDT_LUNCH_END_TIME | _datetime_8 | datetime(8) | Yes | Lunch End Time will be stored if entered. | No |
| WCOUDT_DINNER_START_TIME | _datetime_8 | datetime(8) | Yes | Dinner Start Time will be stored if entered. | No |
| WCOUDT_DINNER_END_TIME | _datetime_8 | datetime(8) | Yes | Dinner End Time will be stored if entered. | No |
| wcoudt_hangarjob | _varchar_5 | varchar(5) | Yes | Work Center Cabability. Cabable of doing hanger job or not ( Yes/No) | No |
| wcoudt_shopjob | _varchar_5 | varchar(5) | Yes | Work Center Cabability. Cabable of doing Shop job or not ( Yes/No) | No |
| wcoudt_linejob | _varchar_5 | varchar(5) | Yes | Work Center Cabability. Cabable of doing Line job or not ( Yes/No) | No |
| wcoudt_alljob | _varchar_5 | varchar(5) | Yes | Work Center Cabability. Cabable of doing All job or not ( Yes/No) | No |
| wcoudt_cost_center | _varchar_30 | varchar(30) | Yes | Cost Center Associated to the Work center,. | No |
| wcoudt_AutoLineSch | udd_checkyesno | varchar(3) | Yes | Is this work center is applicable for auto line scheduler. | No |
| wcoudt_ref_wc | udd_wccode | varchar(30) | Yes | wcoudt_ref_wc | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | Work center user rights detail |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WCUSR_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Mapped OUInstance | Yes |
| WCUSR_WORK_CENTER | _varchar_30 | varchar(30) | No | Mapped OUInstance Work Center Code | Yes |
| WCUSR_USER_ID | _varchar_30 | varchar(30) | No | User Id | Yes |
| WCUSR_CHILDWC_ALLOW_FLAG | _varchar_25 | Varchar(25) | Yes | Indicates if child workcenter exists | No |
| WCUSR_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | This table will store information regarding work center and warehouse mapping (both issue and return warehouse) |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WCWHM_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Mapped OUInstance | Yes |
| WCWHM_WORK_CENTER | _varchar_30 | varchar(30) | No | Mapped OUInstance Work Center Code | Yes |
| WCWHM_PART_TYPE | _varchar_25 | Varchar(25) | No | Part Type | Yes |
| WCWHM_ISSUE_WH_CODE | _varchar_10 | varchar(10) | Yes | Warehouse code ,type is issue | No |
| WCWHM_ISSUE_WH_OU | _decimal_10_0 | decimal(10) | Yes | Ouinstance where wharehouse created | No |
| WCWHM_RETURN_WH_CODE | _varchar_10 | varchar(10) | Yes | wharehouse code. | No |
| WCWHM_RETURN_WH_OU | _decimal_10_0 | decimal(10) | Yes | Ouinstance Where warehouse created | No |
| WCWHM_RET_CORES_WH_CODE | _varchar_10 | varchar(10) | Yes | Warehouse code | No |
| WCWHM_RET_CORES_WH_OU | _decimal_10_0 | decimal(10) | Yes | Core return warehouse code | No |
| WCWHM_BACKFLUSH_FLAG | _varchar_5 | varchar(5) | Yes | Backflush Yes/No | No |
| WCWHM_AUTORETURN | _varchar_10 | varchar(10) | Yes | Auto Return flag | No |
| WCWHM_CustServShipping_WH_code | udd_warehouse | varchar(10) | Yes | Customer server shipping warehouse code | No |
| WCWHM_CustServShipping_WH_OU | udd_ctxt_ouinstance | int(4) | Yes | Customer server shipping warehouse Ouinstance | No |
| WCWHM_CustUSShipping_WH_code | udd_warehouse | varchar(10) | Yes | Customer US Shipping Warehouse code | No |
| WCWHM_CustUSShipping_WH_OU | udd_ctxt_ouinstance | int(4) | Yes | Customer US Shipping Warehouse Ouinstance | No |
| WCWHM_ExtRepair_WH_code | udd_warehouse | varchar(10) | Yes | External repair warehouse code | No |
| WCWHM_ExtRepair_WH_OU | udd_ctxt_ouinstance | int(4) | Yes | External repair warehouse Ouinstance | No |
| WCWHM_Scrap_WH_code | udd_warehouse | varchar(10) | Yes | Scrap warehouse code | No |
| WCWHM_Scrap_WH_OU | udd_ctxt_ouinstance | int(4) | Yes | Scrap warehouse ouinstance | No |
| WCWHM_USReceiving_WH_code | udd_warehouse | varchar(10) | Yes | USReceiving warehouse code | No |
| WCWHM_USReceiving_WH_OU | udd_ctxt_ouinstance | int(4) | Yes | USReceiving warehouse Ouinstance | No |
| WCWHM_ExServ_ReturnWH_code | udd_warehouse | varchar(10) | Yes | Return warehouse code | No |
| WCWHM_ExServ_ReturnWH_OU | udd_ctxt_ouinstance | int(4) | Yes | Return warehouse ouinstance | No |
| WCWHM_ExcReturn_Policy | udd_designparamcode | varchar(5) | Yes | Exc Return policy | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | List of employees associated to the Work Center |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WEMP_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Mapped OUInstance | Yes |
| WEMP_WRKC_WORK_CENTER | _varchar_30 | varchar(30) | No | Work Center Code. | Yes |
| WEMP_EMP_CODE | _varchar_20 | varchar(20) | No | Employee Code | Yes |
| WEMP_EMP_CODE_OU | _decimal_10_0 | decimal(10) | No | Employee Code Ouinstance. | No |
| WEMP_SKILL_CODE | _varchar_40 | varchar(40) | Yes | Primary Skill Code of the Employee. | No |
| WEMP_SERVICE_AREA | _varchar_25 | Varchar(25) | Yes | Service area where the employee is available | No |
| WEMP_RATE | _decimal_28_0 | decimal(28) | Yes | Rate of the Employee | No |
| WEMP_PRODUCTIVITY_FACTOR | _decimal_28_0 | decimal(28) | Yes | Should be between 0 and 1 | No |
| WEMP_PLANNER_FLAG | _varchar_25 | Varchar(25) | Yes | Can be either Yes or No | No |
| WEMP_CREATIONDATE | _datetime_8 | datetime(8) | Yes | Creation Date | No |
| WEMP_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | Last Modified Date | No |
| WEMP_USERID | _varchar_30 | varchar(30) | Yes | Last Modified User Name | No |
| WEMP_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp | No |
| WEMP_ASSOCIATION_STATUS | _varchar_25 | Varchar(25) | No | Employee association status for the login ou and workcenter. | Yes |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | Facility Association to Work Center |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WFAC_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance | Yes |
| WFAC_TYPE | _varchar_25 | Varchar(25) | No | Type Of the Facility Code | Yes |
| WFAC_FACILITY_CODE | _varchar_40 | varchar(40) | No | Facility Code | Yes |
| WFAC_WORK_CENTER | _varchar_30 | varchar(30) | No | Work Center | Yes |
| WFAC_RATE | _decimal_28_0 | decimal(28) | Yes | Rate of the Facility Code | No |
| WFAC_QUANTITY | _decimal_28_0 | decimal(28) | Yes | Quantity of the Facility Code Required | No |
| WFAC_PART_NO | _varchar_40 | varchar(40) | Yes | Part Numberof the tool if the Facility is of type Tool | No |
| WFAC_SERVICE_AREA | _varchar_5 | varchar(5) | Yes | Service Area is the place where the Facility Object can be utilized. | No |
| WFAC_CREATIONDATE | _datetime_8 | datetime(8) | Yes | Creation Date of the Facility | No |
| WFAC_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | Date on which the Last Modification was done | No |
| WFAC_USERID | _varchar_30 | varchar(30) | Yes | Last Modified User Name | No |
| WFAC_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | Facility Object Master.This lists the individual units in the facility code identified |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WFO_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance | Yes |
| WFO_TYPE | _varchar_25 | Varchar(25) | No | Type of the Facility Code | Yes |
| WFO_FACILITY_CODE | _varchar_40 | varchar(40) | No | Facility code identified for the Work Center | Yes |
| WFO_WORK_CENTER | _varchar_30 | varchar(30) | No | Work Center code | Yes |
| WFO_FACILITY_OBJ | _varchar_40 | varchar(40) | No | Facility Object Name. This is nothing but the individual unit of the Facility code defined. If Lathe is a Facility Code , the individual lathes along with manufacturer serial number will make a facility object | Yes |
| WFO_MFG_SERIAL_NO | _varchar_40 | varchar(40) | Yes | Manifacture Serial Number of the Facility Object | No |
| WFO_MODEL_NO | _varchar_20 | varchar(20) | Yes | Model Number of the Facility Object | No |
| WFO_SERVICE_AREA | _varchar_25 | Varchar(25) | Yes | Service Area is the place where the Facility Object can be utilized | No |
| WFO_RATE_PER_HOUR | _decimal_28_0 | decimal(28) | Yes | Rate per hour for the facility code and facility object ,Faclity type. | No |
| WFO_STATUS | _varchar_15 | varchar(15) | Yes | Status Of the Facility Object. | No |
| WFO_CREATIONDATE | _datetime_8 | datetime(8) | Yes | Creation Date of the Facility Object | No |
| WFO_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | Last Modified Date | No |
| WFO_USERID | _varchar_30 | varchar(30) | Yes | Last Modified User Name | No |
| WFO_ASSET_NO | udd_assetnumber | varchar(18) | Yes | Asset Number of the facicity object. | No |
| WFO_ASSET_TAG | udd_assettagno | int(4) | Yes | Asset Tag of the facicity object. | No |
| WFO_ASSET_MODIFIED_BY | udd_ctxt_user | varchar(30) | Yes | Asset Modified by. | No |
| WFO_ASSET_MODIFIED_DATE | udd_datetime | varchar(30) | Yes | Asset Modified Date. | No |
| WFO_PRODUCTIVITY_FACTOR | udd_value | numeric(13) | Yes | Facility Objects Productivity Factor. | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | Model Effectivity For the Work Centers |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WME_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance | Yes |
| WME_WORK_CENTER | _varchar_30 | varchar(30) | No | Work Center Code | Yes |
| WME_MODEL_NO | _varchar_20 | varchar(20) | No | Model number that is applicable for the Work Center | Yes |
| WME_ASSOCIATION_COUNT | _decimal_10_0 | decimal(10) | Yes | Number of the Models effective in the work center identified. Used for Design purpose | No |
| WME_EO_EXEC_CAP | _varchar_5 | varchar(5) | No | Engineering order execution capability flag (Y/N) storing. | No |
| WME_FCD_EXEC_CAP | _varchar_5 | varchar(5) | No | Fleet Campaign Directive excution capability flag (Y/N) storing. | No |
| WME_MDL_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | OUInstance of the Model identified | No |
| WME_CREATIONDATE | _datetime_8 | datetime(8) | Yes | Creation Date | No |
| WME_MODIFIEDDATE | _datetime_8 | datetime(8) | Yes | Last Modified Date | No |
| WME_USERID | _varchar_30 | varchar(30) | Yes | Last Modified User Name | No |
| WME_ASSOCIATE_PART_APPL | _nvarchar_0 | nvarchar(0) | Yes | Associated Part Applicability of the work center. | No |
| WME_MAINTTYPE | _nvarchar_0 | nvarchar(0) | Yes | Associated Maintenance type | No |
| WME_REMARKS | _nvarchar_0 | nvarchar(0) | Yes | Remarks. | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | List of Work Units associated to the Aircraft Model identified in the Work Center |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WMWU_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance | Yes |
| WMWU_WORK_CENTER | _varchar_30 | varchar(30) | No | Work Center | Yes |
| WMWU_MODEL_NO | _varchar_20 | varchar(20) | No | Aircraft Model | Yes |
| WMWU_WORKUNIT_TYPE | _varchar_25 | Varchar(25) | No | Type of the Work Unit. Can be either Task, Procedure or Standard Work Package | Yes |
| WMWU_WORKUNIT_CODE | _varchar_30 | varchar(30) | No | Work Unit Code | Yes |
| WMWU_WU_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | OUInstance of the Work Unit | No |
| WMWU_CREATIONDATE | _datetime_8 | datetime(8) | Yes | Creation Date | No |
| WMWU_MODIFIEDATE | _datetime_8 | datetime(8) | Yes | Last Modified Date | No |
| WMWU_USERID | _varchar_30 | varchar(30) | Yes | Last Modified User Name | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | Associated Base Component Part Id Information For the Work Center |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WPRT_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance | Yes |
| WPRT_WORK_CENTER | _varchar_30 | varchar(30) | No | Work Center | Yes |
| WPRT_PART_NO | _varchar_40 | varchar(40) | No | Part Number | Yes |
| WPRT_PART_OU | _decimal_10_0 | decimal(10) | Yes | Part/group Ouinstance. | No |
| WPRT_ASSOCIATION_COUNT | _decimal_10_0 | decimal(10) | Yes | Number of the Maintanance typeis associated with the part.(design purpose) | No |
| WPRT_ASSOCIATE_PART_APPL | _nvarchar_0 | nvarchar(0) | Yes | Associated Part Applicabily of the Work Center. | No |
| WPRT_MAINTTYPE | _nvarchar_0 | nvarchar(0) | No | Associated Maintenance Type. | No |
| WPRT_REMARKS | _nvarchar_0 | nvarchar(0) | Yes | Remarks. | No |
| created_area_code | varchar | Char(10) | Yes | Area Code | No |
| Table Name : | |
| Comment : | Work units associated with the component part id identified in the work center |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WPWU_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUInstance | Yes |
| WPWU_WORK_CENTER | _varchar_30 | varchar(30) | No | Work Center | Yes |
| WPWU_PART_NO | _varchar_40 | varchar(40) | No | Part Number | Yes |
| WPWU_WORKUNIT_TYPE | _varchar_25 | Varchar(25) | No | Work Unit type . Can be Task,Procedures or Standard Work Package | Yes |
| WPWU_WORKUNIT_CODE | _varchar_30 | varchar(30) | No | Work Unit Code | Yes |
| WPWU_WU_OUINSTANCE | _decimal_10_0 | decimal(10) | Yes | OUInstance of the Work Unit code | No |
| WPWU_MAINT_TYPE | _varchar_5 | varchar(5) | No | Maintanace type can be inspection ,repair ,overhaul. | Yes |
| WPWU_CREATIONDATE | _datetime_8 | datetime(8) | Yes | Creation Date | No |
| WPWU_MODIFIEDATE | _datetime_8 | datetime(8) | Yes | WPWU_MODIFIEDATE | No |
| WPWU_USERID | _varchar_30 | varchar(30) | Yes | user id | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| Table Name : | |
| Comment : | Quick Codes Definition For the Work Center Component |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WQC_OUINSTANCE | _decimal_10_0 | decimal(10) | No | OUinstance | Yes |
| WQC_QUICK_CODE | _varchar_25 | Varchar(25) | No | User Defined quick code | Yes |
| WQC_TYPE | _varchar_25 | Varchar(25) | No | Type of the Quick Code.Can be Facility or Work Center Category. | Yes |
| WQC_DESCRIPTION | _varchar_80 | varchar(80) | No | Description of the quick code | No |
| WQC_STATUS | _varchar_15 | varchar(15) | No | Status of the Quick Code. Can be Active or Inactive. | No |
| WQC_USERID | _varchar_30 | varchar(30) | No | Last Modified User name | No |
| WQC_CREATIONDATE | _datetime_8 | datetime(8) | No | Creation date of the Quick Code | No |
| WQC_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Last modified date of the Quick Code | No |
| WQC_MODIFIED_BY | _varchar_30 | varchar(30) | No | Modified user name. | No |
| WQC_TIMESTAMP | _decimal_10_0 | decimal(10) | No | Timestamp | No |
| created_area_code | varchar | Char(10) | No | Area code | No |
| Table Name : | |
| Comment : | The work center association details are maintained here |
| Column Name | UDD | Data Type | Is NULL? | Comment | Is PK? |
| WRKC_OUINSTANCE | _decimal_10_0 | decimal(10) | No | Mapped OUInstance | Yes |
| WRKC_WORK_CENTER | _varchar_30 | varchar(30) | No | Mapped OUInstance Work Center Code | Yes |
| WRKC_PARENT_WORK_CENTER | _varchar_30 | varchar(30) | Yes | Parent Work Center if any | No |
| WRKC_CREATED_OU | _decimal_10_0 | decimal(10) | Yes | This is the OUInstance in which WCenter is CREATED - i.e. Created OUInstance | No |
| WRKC_DESCRIPTION | _varchar_150 | varchar(150) | No | This gets copied from the Created OUInstance Wc Desc | No |
| WRKC_DESCRIPTION_UP | _varchar_150 | varchar(150) | No | Desription values stored in Upper case. | No |
| WRKC_CATEGORY | _varchar_25 | Varchar(25) | Yes | Category of the Work center. The valid entries are quick codes(work center type) defined in quick code master This gets copied from the Created OUInstance Wc Category | No |
| WRKC_WC_TYPE | _varchar_5 | varchar(5) | Yes | It will store the workcenter type "Hangar", "Bay", and "Others". The code for these types will be stored. | No |
| WRKC_STATUS | _varchar_15 | varchar(15) | No | Status of the Work Center. Can be Active or Inactive This gets copied from the Created OUInstance Wc Status | No |
| WRKC_LEVEL_NO | _decimal_10_0 | decimal(10) | Yes | Level code of the Work Center.This is level in the Work center hierarchy | No |
| WRKC_SEQNO | _decimal_10_0 | decimal(10) | Yes | Sequence Number | No |
| WRKC_EMPCOUNT | _decimal_10_0 | decimal(10) | Yes | Number of the employees applicable for this work center. Design purpose | No |
| WRKC_MODEL_COUNT | _decimal_10_0 | decimal(10) | Yes | Number of the models effective. Design purpose. | No |
| WRKC_COMPONENT_COUNT | _decimal_10_0 | decimal(10) | Yes | Number of the components applicable. Used for Design purpose | No |
| WRKC_COMP_CAB_BASIS | _varchar_5 | varchar(5) | Yes | Capability Basis | No |
| WRKC_USERID | _varchar_30 | varchar(30) | No | Last Modified User Name | No |
| WRKC_CREATIONDATE | _datetime_8 | datetime(8) | No | Creation Date | No |
| WRKC_MODIFIEDDATE | _datetime_8 | datetime(8) | No | Last Modified Date | No |
| WRKC_MODIFIED_BY | _varchar_30 | varchar(30) | No | Last Modified By | No |
| WRKC_TIMESTAMP | _decimal_10_0 | decimal(10) | Yes | Timestamp | No |
| WRKC_HANGERBAY_FLAG | _varchar_5 | varchar(5) | Yes | Indicates if the workcenter defined is a hangar or a bay | No |
| wrkc_class | udd_quickcodes | varchar(25) | Yes | wrkc_class | No |
| created_area_code | varchar | Char(10) | Yes | Area code | No |
| WRKC_Mode_of_Usage | udd_designparamcode | varchar(5) | Yes | Mode of usage | No |