Data Dictionary - Maintenance Task

Table Name BAS_APTSK_APTRSO_RES_SIGNOFF

Table Comment To store task resource signoff details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

APTRSO_OUINSTANCE

int

NOT NULL

OU

No

No

APTRSO_TASK_NO

char(30)

NOT NULL

Task number

No

No

APTRSO_BASE_MODEL_NO

char(20)

NOT NULL

Base Model number

No

No

APTRSO_RES_TYPE

char(25)

NOT NULL

Resource type

No

No

APTRSO_RESOURCE_OU

int

NULL

Resource OU

No

No

APTRSO_RESOURCE_CODE

char(40)

NOT NULL

Resource code

No

No

APTRSO_ST_SEQNO

int

NOT NULL

Subtask sequence number

No

No

APTRSO_RES_GROUP

char(25)

NULL

Resource Group

No

No

APTRSO_SIGN_OFF_FLAG

char(25)

NULL

Sign off flag

No

No

APTRSO_SUB_TASK

varchar(2000)

NULL

Sub task

No

No

Table Name BAS_STD_PROC_REV_HIST

Table Comment To maintain standard procedure revision history information

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

STP_REV_OUINSTANCE

numeric(5)

NOT NULL

OU

No

No

STP_REV_APPLICABILITY

varchar(25)

NULL

Revision applicability

No

No

STP_REV_BASE_MODEL_NO

varchar(20)

NOT NULL

Base model number

No

No

STP_REV_PROC_NO

varchar(40)

NOT NULL

Revision Procedure number

No

No

STP_REV_PROC_DESC

varchar(255)

NULL

Revision Procedure description

No

No

STP_REV_REVISION_IND

varchar(5)

NULL

Revision index

No

No

STP_REV_REViSION_NO

varchar(40)

NULL

revision number

No

No

STP_REV_REVISION_DATE

datetime

NULL

Revised on

No

No

STP_REV_STATUS

varchar(25)

NULL

Revision Status

No

No

STP_REV_COMMENTS

varchar(255)

NULL

Revision Comments

No

No

STP_REV_REVISED_ON

datetime

NULL

Revised on

No

No

STP_REV_REVISED_BY

varchar(30)

NULL

Revisor ID

No

No

STP_REV_EMPLOYEE

varchar(50)

NULL

Employee

No

No

Table Name bas_tsk_apm_access_panels

Table Comment Access panel master

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

apm_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

apm_accesspanel_no

varchar(15)

NOT NULL

Access Panel Number

Yes

No

APM_MODEL_NO

varchar(20)

NOT NULL

Model Number

Yes

No

APM_ZONE_NO

varchar(15)

NULL

Zone Code

No

No

APM_MODEL_OU

numeric(10)

NULL

Model Ouinstance

No

No

APM_ZONE_OU

numeric(10)

NULL

Zone Ouinstance

No

No

apm_open_task_no

varchar(30)

NULL

Open Task for the Access Panel

No

Yes

apm_close_task_no

varchar(30)

NULL

Close Task for the Access Panel

No

Yes

apm_description

varchar(150)

NULL

Description of the Access Panel

No

No

APM_DESCRIPTION_UP

varchar(150)

NULL

Description in Upper case

No

No

apm_status

varchar(15)

NULL

Status of the Access Panel A - Active I - InActive

No

No

apm_comments

varchar(255)

NULL

Comments during Access Panel Modification

No

No

apm_created_by

varchar(30)

NOT NULL

First created user

No

No

apm_creationdate

datetime

NOT NULL

Creation date

No

No

apm_modifieddate

datetime

NOT NULL

Modified date

No

No

apm_modified_by

varchar(30)

NOT NULL

Last modified user

No

No

apm_timestamp

numeric(10)

NOT NULL

Timestamp

No

No

apt_base_model_no

varchar()

NULL

Model Number

No

Yes

Table Name BAS_TSK_APRVP_REVISE_PART

Table Comment To store revise part information

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

APRVP_OUINSTANCE

decimal(10)

NOT NULL

OU

No

No

APRVP_TASK_NO

varchar(30)

NOT NULL

Task number

No

No

APRVP_BASE_MODEL_NO

varchar(20)

NULL

Base model number

No

No

APRVP_PART_NO

varchar(40)

NOT NULL

Part number

No

No

APRVP_PART_OU

decimal(10)

NULL

Part ou

No

No

APRVP_TOTALQTY_CONSUMED

decimal(28,8)

NULL

Total Quantity consumed

No

No

APRVP_TOTAL_OCCURENCES

decimal(10)

NULL

Total occurrences

No

No

APRVP_REVISED_DATE

datetime

NULL

Revised Date

No

No

APRVP_REVISED_BY

varchar(30)

NULL

Revisor id

No

No

Table Name BAS_TSK_APRVR_REVISE_RES

Table Comment To store task revising resource information

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

APRVR_OUINSTANCE

decimal(10)

NOT NULL

OU

No

No

APRVR_TASK_NO

varchar(30)

NOT NULL

Task number

No

No

APRVR_BASE_MODEL_NO

varchar(20)

NULL

Base Model number

No

No

APRVR_RESOURCE_CODE

varchar(40)

NOT NULL

Resource code

No

No

APRVR_RESOURCE_TYPE

varchar(25)

NOT NULL

Resource type

No

No

APRVR_ELAPSEDTIME_MIN

decimal(28,8)

NULL

Elapsed time

No

No

APRVR_TOTAL_OCCURENCES

decimal(10)

NULL

Total occurrences

No

No

APRVR_REVISED_DATE

datetime

NULL

Revised on

No

No

APRVR_REVISED_BY

varchar(30)

NULL

Revisor id

No

No

Table Name BAS_TSK_APRVT_REVISE_ELAPT

Table Comment To maintain task revised elapsed time information

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

APRVT_OUINSTANCE

decimal(10)

NOT NULL

OU Instance

No

No

APRVT_TASK_NO

varchar(30)

NOT NULL

Task number

No

No

APRVT_BASE_MODEL_NO

varchar(20)

NULL

Base Model number

No

No

APRVT_ELAPSEDTIME_MIN

decimal(28,8)

NULL

Elapsed time

No

No

APRVT_TOTAL_OCCURENCES

decimal(10)

NULL

Total occurrences

No

No

APRVT_REVISED_DATE

datetime

NULL

Revised on

No

No

APRVT_REVISED_BY

varchar(30)

NULL

Revisor id

No

No

Table Name bas_tsk_apt_ap_task

Table Comment Access panel task details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

apt_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

apt_ap_task_no

varchar(30)

NOT NULL

Access Panel Task Number

Yes

No

apt_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

No

apt_base_model_ou

int

NULL

Model Ouinstance

No

No

apt_dsc_no

varchar(15)

NULL

Dependent SystemNumber for the Access Panel Task

No

Yes

apt_description

varchar(150)

NULL

Description of the Access Panel Task

No

No

APT_DESCRIPTION_UP

varchar(150)

NULL

Description in upper case

No

No

apt_status

varchar(15)

NULL

Status Of the Access Panel Task. Can be ’Active’ or ’Inactive’ A - Active I - Inactive

No

No

apt_type

varchar(25)

NULL

Type of the Access Panel Task. Can be either ’Open’ or ’Close’ O -Open C - Close

No

No

apt_est_dur

numeric(28,8)

NULL

Estimated duration for performing the Access Panel Task

No

No

APT_EST_DUR_DISP

numeric(28,8)

NULL

Estimated duration display

No

No

apt_est_dur_tuom

varchar(10)

NULL

Uom of the Estimated Duration

No

No

apt_estman_hrs

numeric(28,8)

NULL

Sum of the resource hours required for the Access Panel Task

No

No

apt_upd_part_act_flag

varchar(25)

NULL

This flag indicates if the part utilization actuals for the task have to be updated if the sum of the actual quantity utilized is greater than the estimated.

No

No

apt_comments

varchar(255)

NULL

comments given during modification of the Access Panel task

No

No

apt_created_by

varchar(30)

NULL

Created user

No

No

apt_creationdate

datetime

NULL

Creation date

No

No

apt_modifieddate

datetime

NULL

Modified date

No

No

apt_modified_by

varchar(30)

NULL

Last modified user

No

No

apt_timestamp

numeric(10)

NULL

Timestamp

No

No

apt_long_description

varchar(255)

NULL

Long description

No

No

apt_system_ref_no

varchar(30)

NULL

System reference Number

No

No

Table Name bas_tsk_aptme_mdl_effect

Table Comment Model Effectivity for Access Panel Task

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

aptme_ouinstance

numeric(10)

NOT NULL

Access Panel Task OUInstance

Yes

No

aptme_ap_task_no

varchar(30)

NOT NULL

Access Panel Task Number

Yes

No

aptme_base_model_no

varchar(20)

NOT NULL

Base Model Number

Yes

No

aptme_model_no

varchar(20)

NOT NULL

Model Number

Yes

No

aptme_model_ou

numeric(10)

NULL

Model OU

No

No

Table Name bas_tsk_aptp_apt_parts

Table Comment Part Requirements for the access panel task

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

aptp_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

aptp_ap_task_no

varchar(30)

NOT NULL

Access Panel Task Number

Yes

Yes

aptp_part_no

varchar(40)

NOT NULL

Part identified for performing the Access Panel Task

Yes

No

aptp_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

aptp_part_ou

numeric(10)

NULL

Part OU

No

No

aptp_uom

varchar(10)

NULL

unit of measure of the part

No

No

aptp_qty

numeric(28,8)

NULL

Quantity of the part required to perform the access panel task

No

No

aptp_created_by

varchar(30)

NULL

First created user

No

No

aptp_creationdate

datetime

NULL

Creation date.

No

No

aptp_modifieddate

datetime

NULL

Modified date.

No

No

aptp_modified_by

varchar(30)

NULL

Modified By

No

No

Table Name bas_tsk_aptr_apt_resource

Table Comment Resource Requirements for access panel task

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

aptr_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

aptr_ap_task_no

varchar(30)

NOT NULL

Access Panel Task Number

Yes

Yes

aptr_resource_code

varchar(40)

NOT NULL

Resource required to perform the Access Panel Task

Yes

No

aptr_res_type

varchar(25)

NOT NULL

Type of the Resource required to perform the Access Panel Task. Resource Type can be ’Skill’, ’Tool’, ’Equipment’ or ’Others’ S - Skill T - Tool E - Equipment O - Others

Yes

Yes

aptr_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

aptr_resource_ou

numeric(10)

NULL

Estimated Time for resource requirement

No

No

aptr_est_elapsed_time

numeric(28,8)

NULL

Estimated elapsed time of access panel task interms of minute.

No

No

aptr_est_elapsed_time_disp

numeric(28,8)

NULL

Estimated elapsed time of access panel task - display

No

No

aptr_est_elapsed_tuom

varchar(10)

NULL

Unit of measure for the elapsed time.

No

No

aptr_estimated_nos

numeric(28,8)

NULL

Estimated numbers of the resource required for the Access Panel Task

No

No

aptr_sign_off_flag

varchar(25)

NULL

Can take value ’Yes’ or ’No’. Indicates if sign off is required or not Y - Yes N- No

No

No

aptr_app_reqd_flag

varchar(25)

NULL

Can take either a ’Yes’ or a ’No’ Indicates if approval is required or not. Y - Yes N- No

No

No

aptr_created_by

varchar(30)

NULL

Last modified user

No

No

aptr_creationdate

datetime

NULL

Creation date

No

No

aptr_modifieddate

datetime

NULL

Modified date

No

No

aptr_modified_by

varchar(30)

NULL

Last modified user

No

No

Table Name bas_tsk_aptrt_resource_type

Table Comment Resource types mapped to access panel

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

aptrt_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

aptrt_ap_task_no

varchar(30)

NOT NULL

Access Panel Task Number

Yes

Yes

aptrt_res_type

varchar(25)

NOT NULL

Resource type - can take values ’Skill’, ’Equipment’, ’Tool’ or ’Others’ S - Skill E - Equipment T - Tool O- Others

Yes

No

aptrt_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

aptrt_upd_res_act_flag

varchar(25)

NULL

This flag indicates if the resource utilization actuals for the task have to be updated if the sum of the actual quantity utilized is greater than the estimated.

No

No

Table Name bas_tsk_apts_apt_subtasks

Table Comment Subtasks for access panel task

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

apts_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

apts_ap_task_no

varchar(30)

NOT NULL

Access Panel Number

Yes

Yes

apts_seq_no

numeric(10)

NOT NULL

sequence number of the guideline

Yes

No

apts_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

apts_subtask

varchar(2000)

NULL

Subtask for performing the Access Panel Task

No

No

apts_ResourceGroup

varchar(5)

NULL

Resource group has mechanic,inspector,Ins and mec MEC - Mechanic INS - Inspector BO - Insp and Mech

No

No

apts_RefDocNo

varchar(40)

NULL

Reference Document No

No

No

apts_Path

varchar(50)

NULL

Document Path

No

No

apts_created_by

varchar(30)

NULL

first created user

No

No

apts_creationdate

datetime

NULL

Creation date

No

No

apts_modifieddate

datetime

NULL

Modified date

No

No

apts_modified_by

varchar(30)

NULL

Last modified user

No

No

apts_ammcmm_itemno

varchar(40)

NULL

AMM\CMM Item Number

No

No

apts_dsclcode

varchar(15)

NULL

Dependent System Code

No

No

Table Name bas_tsk_dsc_codes

Table Comment Dependent System Component codes master

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

dsc_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

No

dsc_dsc_no

varchar(15)

NOT NULL

Dependent System code

Yes

No

dsc_description

varchar(150)

NULL

Brief description about the Dependent System

No

No

DSC_DESCRIPTION_UP

varchar(150)

NULL

description in upper case

No

No

dsc_ref_doc1

varchar(40)

NULL

Reference document one for the Dependent

No

No

dsc_ref_doc2

varchar(40)

NULL

Reference document two for the dependent system

No

No

dsc_doc1path

varchar(50)

NULL

Path where the reference document one is available.

No

No

dsc_doc2path

varchar(50)

NULL

path where the reference document two is available

No

No

dsc_comments

varchar(255)

NULL

comments during dependent system modification

No

No

dsc_status

varchar(15)

NULL

status of the Dependent System. Can be ’Active’ or ’Inactive’ A - Active I - InActive

No

No

dsc_created_by

varchar(30)

NULL

Created user

No

No

dsc_creationdate

datetime

NULL

Creation date

No

No

dsc_modifieddate

datetime

NULL

Modified date

No

No

dsc_modified_by

varchar(30)

NULL

Last modified user

No

No

dsc_timestamp

numeric(10)

NULL

Timestamp

No

No

dsc_external_flag

varchar(20)

NULL

External flag Null can be no

No

No

Table Name bas_tsk_dscl_dep_system

Table Comment DSC Dependency Details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

dscl_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

dscl_dsccode

varchar(15)

NOT NULL

Dependent System Code

Yes

Yes

dscl_disp_pos_no

numeric(10)

NOT NULL

Dependent System position number

Yes

No

dscl_dependent_system

varchar(255)

NULL

Dependent System

No

No

dscl_condition

varchar(15)

NULL

The condition of the dependent System. This field is user defined.

No

No

dscl_created_by

varchar(30)

NULL

Last Modified user

No

No

dscl_creationdate

datetime

NULL

Creation Date

No

No

dscl_modifieddate

datetime

NULL

Modified Date

No

No

dscl_modified_by

varchar(30)

NULL

Last Modified user

No

No

Table Name BAS_TSK_RVP_REVISE_PART

Table Comment To store revise part information for tasks.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RVP_OUINSTANCE

decimal(10)

NOT NULL

OU

No

No

RVP_TASK_NO

varchar(30)

NOT NULL

Task number

No

No

RVP_REVISION_NO

varchar(40)

NOT NULL

Revision number

No

No

RVP_BASE_MODEL_NO

varchar(20)

NOT NULL

Base Model number

No

No

RVP_PART_NO

varchar(40)

NOT NULL

Part number

No

No

RVP_PART_OU

decimal(10)

NULL

Part OU

No

No

RVP_TOTALQTY_CONSUMED

decimal(28,8)

NULL

Total quantity consumed

No

No

RVP_TOTAL_OCCURENCES

decimal(10)

NULL

Total occurrences

No

No

RVP_REVISED_DATE

datetime

NULL

Revised on

No

No

RVP_REVISED_BY

varchar(30)

NULL

Revisor id

No

No

Table Name BAS_TSK_RVR_REVISE_RES

Table Comment To maintain revised resource details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RVR_OUINSTANCE

decimal(10)

NOT NULL

OU Instance

No

No

RVR_TASK_NO

varchar(30)

NOT NULL

Task number

No

No

RVR_REVISION_NO

varchar(40)

NOT NULL

Revision number

No

No

RVR_BASE_MODEL_NO

varchar(20)

NOT NULL

Base model number

No

No

RVR_RESOURCE_CODE

varchar(40)

NOT NULL

Resource code

No

No

RVR_RESOURCE_TYPE

varchar(25)

NOT NULL

Resource Type

No

No

RVR_ELAPSEDTIME_MIN

decimal(28,8)

NULL

Elapsed time in minutes

No

No

RVR_TOTAL_OCCURENCES

decimal(10)

NULL

total occurrences

No

No

RVR_REVISED_DATE

datetime

NULL

Revised date

No

No

RVR_REVISED_BY

varchar(30)

NULL

Reviser code

No

No

Table Name BAS_TSK_RVT_REVISE_ELAPT

Table Comment To store revised elapsed time details for the tasks.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

RVT_OUINSTANCE

decimal(10)

NOT NULL

OU

No

No

RVT_TASK_NO

varchar(30)

NOT NULL

Task number

No

No

RVT_REVISION_NO

varchar(40)

NOT NULL

Revision number

No

No

RVT_BASE_MODEL_NO

varchar(20)

NOT NULL

Base model number

No

No

RVT_ELAPSEDTIME_MIN

decimal(28,8)

NULL

Elapsed time

No

No

RVT_TOTAL_OCCURENCES

decimal(10)

NULL

Total occurrences

No

No

RVT_REVISED_DATE

datetime

NULL

Revised on

No

No

RVT_REVISED_BY

varchar(30)

NULL

Revisor id

No

No

Table Name bas_tsk_spac_ac_effectivity

Table Comment Aircraft Effectivity Details for Standard Procedure

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

spac_totab_no

varchar(30)

NULL

To aircraft no

No

No

spac_fromtab_no

varchar(30)

NOT NULL

From Aircraft no

No

No

SPAC_TAB_PREFIX

varchar(30)

NULL

Tab Prefix

No

No

SPAC_TAB_FROM_SUFFIX

varchar(30)

NULL

Tab From Suffix

No

No

SPAC_TAB_TO_SUFFIX

varchar(30)

NULL

Tab To Suffix

No

No

spac_ouinstance

numeric(10)

NULL

Ouinstance

Yes

Yes

spac_base_model_no

varchar(20)

NULL

Model Number

Yes

Yes

spac_proc_no

varchar(30)

NULL

Standard Procedure code

Yes

Yes

spac_model_no

varchar(20)

NULL

Model No for Aircraft effectivity

Yes

No

Table Name bas_tsk_spce_Cmp_effect

Table Comment Component Effectivity For Standard Procedure

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

spce_creationdate

datetime

NULL

Creation Date

No

No

spce_mod_part_app_flag

varchar(25)

NULL

Indicates if all or Restricted models are applicable for the part

No

No

spce_modifieddate

datetime

NULL

Modified Date

No

No

spce_created_by

varchar(30)

NULL

First created user

No

No

spce_modified_by

varchar(30)

NULL

Last modified user

No

No

spce_stp_proc_no

varchar(30)

NOT NULL

Standard Procedure Number

Yes

Yes

spce_stp_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

Yes

spce_part_ou

numeric(10)

NOT NULL

It is storing Ouinstance where part created

No

No

spce_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

spce_part_no

varchar(40)

NOT NULL

Part number (Component Number) where this Standard Procedure is Applicable

Yes

No

Table Name bas_tsk_spd_std_proc_dtl

Table Comment Task List For Standard Procedure

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

spd_display_seq_no

numeric(10)

NULL

Display Sequence Number of the Task

No

No

spd_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

spd_revision_no

varchar(40)

NULL

revision number of the task

No

Yes

SPD_STARTDAY

int

NULL

No

No

tsk_base_model_no

varchar(20)

NULL

Model Number

No

Yes

spd_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

Yes

spd_task_no

varchar(30)

NOT NULL

Task Number

Yes

Yes

spd_proc_no

varchar(30)

NOT NULL

Standard Procedure Code

Yes

Yes

spd_pos_no

numeric(10)

NOT NULL

Position Number of the Task

Yes

No

Table Name bas_tsk_spme_mdl_effect

Table Comment Model Effectivity Definition for Standard Procedure

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

spme_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

spme_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

spme_proc_no

varchar(30)

NOT NULL

Standard Procedure Number

Yes

Yes

spme_model_no

varchar(20)

NOT NULL

Model Number

Yes

No

spme_model_ou

numeric(10)

NOT NULL

model created ou

No

No

Table Name bas_tsk_spp_spare_parts

Table Comment Spare Part List For Standard Procedure

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

spp_modifieddate

datetime

NULL

Modified Date

No

No

spp_creationdate

datetime

NULL

Creation Date

No

No

spp_part_uom

varchar(10)

NULL

unit of measure of the part number identified

No

No

spp_created_by

varchar(30)

NULL

First created user

No

No

spp_modified_by

varchar(30)

NULL

Last Modified User

No

No

SPP_BASE_MODEL_NO

varchar(20)

NOT NULL

No

No

spp_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

stp_base_model_no

varchar()

NOT NULL

Model Number

Yes

Yes

spp_quantity

numeric(28,8)

NULL

estimated quantity of the part number

No

No

spp_part_ou

numeric(10)

NOT NULL

Part OU

No

No

spp_proc_no

varchar(30)

NOT NULL

Standard Procedure Number

Yes

Yes

spp_part_no

varchar(40)

NOT NULL

Part number identified to perform the standard procedure

Yes

No

Table Name bas_tsk_spr_resource

Table Comment Resource Specification For Standard Procedure

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

spr_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

spr_proc_no

varchar(30)

NOT NULL

Standard Procedure Number

Yes

Yes

spr_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

spr_res_type

varchar(25)

NOT NULL

Resource Type. Can be Skill Equipment or Tool S - Skill E - Equipment T - Tool

Yes

No

spr_resource_code

varchar(40)

NOT NULL

Resource Code

Yes

No

spr_resource_ou

numeric(10)

NULL

It is storing organization unit where resource created

No

No

spr_est_elapsed_tuom

varchar(10)

NULL

Elapsed Time unit of measure H - Hours M - Minutes D - Days

No

No

spr_est_elapsed_time

numeric(28,8)

NULL

Elapsed Time in terms of minutes.

No

No

spr_est_elapsed_time_disp

numeric(28,8)

NULL

Elapsed Time

No

No

spr_estimated_nos

numeric(28,8)

NULL

Estimated number of the resource

No

No

spr_app_reqd_flag

varchar(25)

NULL

Indicate if the Resource requires approval. Can be Yes or No Y - Yes N - No

No

No

spr_sign_off_flag

varchar(25)

NULL

Indicates if the Resource requires a Sign off. Values can be either Yes or No Y - Yes N - No

No

No

spr_creationdate

datetime

NULL

Creation Date

No

No

spr_modifieddate

datetime

NULL

Modified Date

No

No

spr_created_by

varchar(30)

NULL

Last Modified User

No

No

spr_modified_by

varchar(30)

NULL

Last Modified user.

No

No

Table Name bas_tsk_sptr_task_relation

Table Comment Task Relationship within Standard Procedure

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

sptr_lag_tuom

varchar(10)

NULL

Lag unit of measure

No

No

sptr_lag_time

numeric(28,8)

NULL

Time Lag

No

No

sptr_relation_type

varchar(25)

NULL

Relation type. Can be Start to Start, Finish To Start, Finish to Finish or Start to Finish. SS - Start - Start FS - Finish - Start FF - Finish - Finish SF - Start - Finish

No

No

sptr_created_by

varchar(30)

NULL

first created user

No

No

sptr_creationdate

datetime

NULL

Creation Date

No

No

sptr_modifieddate

datetime

NULL

Modified Date

No

No

sptr_modified_by

varchar(30)

NULL

Last Modified user

No

No

sptr_proc_no

varchar(30)

NOT NULL

Procedure Number

Yes

Yes

sptr_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

sptr_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

Yes

sptr_to_task_no

varchar(30)

NOT NULL

To Task Number

Yes

Yes

sptr_to_pos_no

numeric(10)

NOT NULL

To Position Number of the Task

Yes

Yes

sptr_from_pos_no

numeric(10)

NOT NULL

From position number of the Task

Yes

Yes

sptr_from_task_no

varchar(30)

NOT NULL

From Task Number

Yes

Yes

Table Name BAS_TSK_SRCD_SEARCH_ID_DET

Table Comment Source document search id detail

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SRCD_OUINSTANCE

decimal(10)

NOT NULL

OU Instance

No

No

SRCD_SEARCH_ID

varchar(30)

NOT NULL

Search ID

No

No

SRCD_PARAM_CODE

varchar(40)

NOT NULL

Param Code

No

No

SRCD_VALUE_TYPE

varchar(25)

NOT NULL

Value Type

No

No

SRCD_OPERATOR

varchar(25)

NULL

Operator

No

No

SRCD_VALUE

varchar(32)

NULL

Value

No

No

SRCD_FROM_VALUE

varchar(32)

NULL

From Value

No

No

SRCD_TO_VALUE

varchar(32)

NULL

To value

No

No

SRCD_CREATIONDATE

datetime

NULL

Creation Date

No

No

SRCD_MODIFIEDDATE

datetime

NULL

Modified Date

No

No

SRCD_CREATED_BY

varchar(30)

NULL

Creator id

No

No

SRCD_MODIFIED_BY

varchar(30)

NULL

modifier id

No

No

Table Name BAS_TSK_SRCH_SEARCH_ID_HDR

Table Comment To maintain task search id header information

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

SRCH_OUINSTANCE

decimal(10)

NOT NULL

OU Instance

No

No

SRCH_SEARCH_ID

varchar(30)

NOT NULL

Search ID

No

No

SRCH_SCH_TYPE

varchar(25)

NULL

Schedule Type

No

No

SRCH_THRESHOLD_DAYS_OP

varchar(25)

NULL

Threshold Days operation

No

No

SRCH_THRESHOLD_DAYS_VAL

varchar(32)

NULL

Threshold Days value

No

No

SRCH_REPEAT_INT_OP

varchar(25)

NULL

Repeat interval operation

No

No

SRCH_REPEAT_INT_VAL

varchar(32)

NULL

Repeat interval value

No

No

SRCH_THRESHOLD_FROM_VALUE

varchar(32)

NULL

Threshold from value

No

No

SRCH_THRESHOLD_TO_VALUE

varchar(32)

NULL

Threshold to value

No

No

SRCH_REPEAT_FROM_VALUE

varchar(32)

NULL

Repeat from value

No

No

SRCH_REPEAT_TO_VALUE

varchar(32)

NULL

Repeat To value

No

No

SRCH_CREATIONDATE

datetime

NULL

Created on

No

No

SRCH_MODIFIEDDATE

datetime

NULL

Modified on

No

No

SRCH_CREATED_BY

varchar(30)

NULL

Creator Id

No

No

SRCH_MODIFIED_BY

varchar(30)

NULL

Modifier ID

No

No

SRCH_TIMESTAMP

decimal(10)

NULL

Timestamp

No

No

Table Name bas_tsk_stp_std_proc

Table Comment Standard Procedure Master

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

stp_ouinstance

numeric(10)

NOT NULL

Ouinstance

Yes

No

stp_proc_no

varchar(30)

NOT NULL

Standard Procedure code

Yes

No

stp_base_model_no

varchar()

NOT NULL

Model Number

Yes

No

stp_proc_desc

varchar(150)

NOT NULL

Description of the Standard Procedure

No

No

STP_PROC_DESC_UP

varchar(150)

NOT NULL

standard procedure description in upper case

No

No

stp_est_elapsed_time

numeric(28,8)

NULL

Estimated duration to perform the standard procedure in terms of minutes.

No

No

stp_est_elapsed_tuom

varchar(10)

NOT NULL

unit of measure for the estimated duration (elapsed time) H - Hours M - Minutes D - Days

No

No

stp_est_man_hrs

numeric(28,8)

NOT NULL

Sum of the resource hours required to carry out the Standard Procedure

No

No

stp_model_count

numeric(10)

NULL

Number of model where the Standard Procedure is applicable

No

No

stp_link_flag

varchar(25)

NULL

Link flag indicates if Parts or Resources or Notes have been defined for the standard procedure.P-R-N denotes all three have been identified

No

No

stp_applicability

varchar(25)

NULL

Applicability of the Standard Procedure. Can be  "Aircraft","Engine" or "Component" A - Aircraft E - Engine C - Component

No

No

stp_sp_type

varchar(30)

NULL

Type of the Standard Procedure. This is user defined

No

No

stp_status

varchar(25)

NULL

Status of the Standard Procedure. Can either be Active or Inactive A - Active I - Inactive

No

No

stp_comments

varchar(255)

NULL

Comments during the Modification of the standard procedure

No

No

stp_created_by

varchar(30)

NULL

Last Modified User

No

No

stp_creationdate

datetime

NULL

Creation Date

No

No

stp_modifieddate

NULL

Modified Date

No

No

stp_modified_by

varchar(30)

NULL

Last Modified user

No

No

stp_timestamp

numeric(10)

NULL

Timestamp

No

No

stp_atano

varchar(16)

NULL

ATA No

No

No

stp_ataou

int

NULL

Aircraft Ou where Ata No created.

No

No

stp_est_elapsed_time_disp

numeric(28,8)

NULL

Estimated duration to perform the standard procedure for display

No

No

stp_proc_long_desc

varchar(2000)

NULL

Long Decription for Standard Procedure

No

No

stp_ref_docno1

varchar(40)

NULL

Reference Document Number1

No

No

stp_ref_docno2

varchar(40)

NULL

Reference Document Number2

No

No

stp_filename1

varchar(50)

NULL

FileName1

No

No

stp_filename2

varchar(50)

NULL

FileName2

No

No

stp_component_count

decimal(38)

NULL

Component Count

No

No

stp_model_ou

numeric(10)

NULL

Model Ouinstance

No

No

STP_OPERATIONAL_TYPE

varchar(25)

NULL

Operational Type F145 - FAR-145 F135 - FAR-135

No

No

STP_WCCODE

varchar(30)

NULL

Work Center Code

No

No

STP_WCCODE_OU

numeric(10)

NULL

Work Center OU

No

No

STP_REVISION_NO

varchar(40)

NULL

Revision Number

No

No

STP_REVISION_COMMENTS

varchar(255)

NULL

Revision Comments

No

No

STP_REVISION_DATE

datetime

NULL

Revision Date

No

No

STP_REVISION_IND

varchar(5)

NULL

No

No

STP_WRENCH_TIME

numeric(28,8)

NULL

Wrench Time

No

No

STP_IDEAL_TIME

numeric(28,8)

NULL

Ideal Time

No

No

STP_MPD_ITEMNO

varchar(40)

NULL

MPD Item number

No

No

Table Name BAS_TSK_TPE_PART_EFFECT

Table Comment To store task part effectivity details

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

TPE_OUINSTANCE

decimal(10)

NOT NULL

OU instance

No

No

TPE_TASK_NO

varchar(30)

NOT NULL

Task number

No

No

TPE_REVISION_NO

varchar(40)

NOT NULL

Revision number

No

No

TPE_PART_NO

varchar(40)

NOT NULL

Part number

No

No

TPE_PART_OU

decimal(10)

NOT NULL

Part OU

No

No

TPE_EFFECT_FLAG

varchar(25)

NULL

Effectivity Flag

No

No

Table Name bas_tsk_tqc_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

tqc_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

No

tqc_quick_code

varchar(25)

NOT NULL

quick code

Yes

No

tqc_type

varchar(25)

NOT NULL

quick code type

Yes

No

tqc_description

varchar(80)

NOT NULL

description of the quick code

No

No

tqc_status

varchar(15)

NOT NULL

Status of the quick code. Can be Active or Inactive A - Active I - Inactive

No

No

tqc_comments

varchar(255)

NULL

Comments

No

No

tqc_created_by

varchar(30)

NOT NULL

Created user

No

No

tqc_creationdate

datetime

NOT NULL

Creation Date

No

No

tqc_modifieddate

datetime

NOT NULL

Modified Date

No

No

tqc_modified_by

varchar(30)

NOT NULL

Last Modified user.

No

No

tqc_timestamp

numeric(10)

NOT NULL

Timestamp

No

No

tqc_external_flag

varchar(25)

NULL

External Flag

No

No

Table Name bas_tsk_tres_task_resource

Table Comment Resource Requirement for Tasks

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

tskr_sign_off_flag

varchar(25)

NULL

Indicates if sign off is required once the resource utilization is complete Y - Yes N - No

No

No

tskr_creationdate

datetime

NOT NULL

Creation Date

No

No

tskr_app_reqd_flag

varchar(25)

NULL

Indicates if approval of the resource is required or not Y - Yes N- No

No

No

tskr_est_elapsed_tuom

varchar(10)

NULL

unit of measure of the estimated time duration H - Hours M - Minutes D - Days

No

No

tskr_est_elapsed_time_disp

numeric(28,8)

NULL

Estimated Elapsed time for display

No

No

tskr_modifieddate

datetime

NOT NULL

Modified Date

No

No

tskr_modified_by

varchar(30)

NULL

Last Modified User

No

No

tskr_created_by

varchar(30)

NULL

created user

No

No

TSKR_BASE_MODEL_NO

varchar(30)

NOT NULL

Base Model Number

No

No

tskr_task_no

varchar(30)

NOT NULL

Task Number

Yes

Yes

tskr_revision_no

varchar(40)

NOT NULL

Revision number of the Task

Yes

Yes

tskr_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

Yes

tskrt_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

tskr_est_elapsed_time

numeric(28,8)

NULL

Estimated time duration of the resource

No

No

tskr_estimated_nos

numeric(28,8)

NULL

Estimated number of the resource required

No

No

tskr_resource_code

varchar(40)

NOT NULL

Resource code identified for the Task.

Yes

No

tskr_resource_ou

numeric(10)

NULL

Resource OU

No

No

tskr_res_type

varchar(25)

NOT NULL

Resource type - can take values ’Skill’, ’Equipment’, ’Tool’ or ’Others’ S - Skills E - Equipment T - Tools O - Others

Yes

Yes

Table Name BAS_TSK_TRSO_RES_SIGNOFF

Table Comment To store values of Task Resource Sign Off.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

TRSO_OUINSTANCE

numeric(10)

NOT NULL

OU Instance

No

No

TRSO_TASK_NO

varchar(30)

NOT NULL

Task Number

No

No

TRSO_REVISION_NO

varchar(40)

NOT NULL

Revision number

No

No

TRSO_BASE_MODEL_NO

varchar(30)

NOT NULL

Base Model number

No

No

TRSO_RES_TYPE

varchar(25)

NULL

Resource type

No

No

TRSO_RESOURCE_OU

numeric(10)

NULL

Resource OU

No

No

TRSO_RESOURCE_CODE

varchar(40)

NOT NULL

Resource Code

No

No

TRSO_ST_SEQNO

numeric(10)

NOT NULL

Sub task sequence number

No

No

TRSO_RES_GROUP

varchar(25)

NULL

Resource Group

No

No

TRSO_SIGN_OFF_FLAG

varchar(25)

NULL

Sign off flag

No

No

TRSO_SUB_TASK

varchar(2000)

NULL

Name of the Subtask

No

No

Table Name bas_tsk_tsk_task_master

Table Comment Task Master

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

tsk_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

Yes

tsk_task_no

varchar(30)

NOT NULL

Task number

Yes

No

tsk_revision_no

varchar(40)

NOT NULL

revision number of the task. User defined.

Yes

No

tsk_base_model_no

varchar(20)

NOT NULL

Base Model Number

Yes

No

tsk_non_routine_task_no

varchar(30)

NULL

Non Routine Task Name based on which the routine task is created

No

Yes

tsk_model_ou

numeric(10)

NULL

Model Ouinstance

No

No

tsk_dsc_no

varchar(15)

NULL

Dependent System Number for the task

No

Yes

tsk_description

varchar(150)

NULL

Description of the task

No

No

TSK_DESCRIPTION_UP

varchar(150)

NULL

task description in upper case

No

No

tsk_status

varchar(15)

NULL

Status of the Task. Can be either ’Fresh’ or ’Active’ or ’Inactive’ F - Fresh A - Active I - Inactive C - Cancel R - Return

No

No

tsk_revision_date

datetime

NULL

Date of revision of the Task

No

No

tsk_revision_type

varchar(25)

NULL

Type of revision of the Task. Can be either ’Internal’ or ’External’ I - Internal E - External

No

No

tsk_latest_rev_flag

varchar(25)

NULL

Latest Revision Flag

No

No

tsk_type

varchar(25)

NULL

Type of the Task. These types are user defined and are defaulted from the Quick code master

No

No

tsk_category

varchar(25)

NULL

Category of the Task. Can take values  "MPD","CMM","MOD","Non Routine" or "Others CMM - CMM MPD - MPD MOD - MOD AIR - Non Routine O - Others

No

No

tsk_task_applicability

varchar(25)

NULL

Applicability of the Task. Can be either  "Aircraft" or "Engine" or "Component" A - Aircraft E - Engine C - Component

No

No

tsk_related_task_no

varchar(30)

NULL

Related task number for the main task

No

No

tsk_amm_cmm_item

varchar(40)

NULL

Item mentioned in the Aircraft Maintenance Manual (AMM) & the Component Maintenance Manual (CMM

No

No

tsk_src_doc

varchar(40)

NULL

source document name EO - Engineering Order OTH - Others DP - Discrepancy Processing HWO - Hanger Work Order TL - Technical Log CO - Component Work Order

No

No

TSK_OEM_NAME

varchar(150)

NULL

OEM Name

No

No

tsk_ata_no

varchar(16)

NULL

ATA chapter number

No

No

tsk_ata_ou

numeric(10)

NULL

ATA OU

No

No

tsk_est_elapsed_time

numeric(28,8)

NULL

Estimated duration of the Task in terms of minutes

No

No

tsk_est_elapsed_tuom

varchar(10)

NULL

unit of measure for the estimated duration. Can be ’minute’, hour’ or day’ M - Minutes H - Hours D - Days

No

No

tsk_est_man_hrs

numeric(28,8)

NULL

Total Estimated resource hours for the Task

No

No

tsk_user_defn1

varchar(30)

NULL

user defined value one

No

No

tsk_user_defn2

NULL

user defined value two

No

No

tsk_comments

varchar(255)

NULL

comments during modification of the task

No

No

tsk_model_count

numeric(10)

NULL

Number of Models where this task is applicable

No

No

tsk_upd_part_actuals_flag

varchar(25)

NULL

This flag indicates if the part utilization actuals for the task have to be updated if the sum of the actual quantity utilized is greater than the estimated. Y - Yes N - No

No

No

tsk_link_flag

varchar(25)

NULL

Flag indicating whether Parts, Resources and Notes have been defined for the Task. P-R-N indicates all three have been defined

No

No

tsk_last_modified_time

datetime

NULL

Last Modified Time

No

No

tsk_created_by

varchar(30)

NULL

User who has created the Task

No

No

tsk_modified_by

varchar(30)

NULL

User who has modified the task

No

No

tsk_approved_by

varchar(30)

NULL

User who has approved the Task

No

No

tsk_creationdate

datetime

NULL

Creation Date

No

No

tsk_modifieddate

datetime

NULL

Modified Date

No

No

tsk_approveddate

datetime

NULL

Approved Date

No

No

tsk_timestamp

numeric(10)

NULL

Timestamp

No

No

tsk_est_elapsed_time_disp

numeric(28,8)

NULL

Estimated duration of the Task

No

No

tsk_filename

varchar(50)

NULL

Task file name.

No

No

tsk_manufacturerno

varchar(45)

NULL

Manufacturer no will be storing, which is referred from Basaircraft Component.

No

No

tsk_manufactac_ou

int

NULL

Manufacturer no created ou will be storing If it is referred from Aircraft.

No

No

tsk_manufactsup_ou

int

NULL

Manufacturer no created ou will be storing If it is referred from supplier.

No

No

tsk_authcomments

varchar(255)

NULL

While authorizing,user will give the comments.

No

No

tsk_long_description

varchar(2000)

NULL

Long Description for Task

No

No

tsk_component_count

decimal(38)

NULL

Component Count for Task

No

No

tsk_src_doc_type

varchar(20)

NULL

Source document type

No

No

tsk_work_location_ref_no

varchar(60)

NULL

Work Location - position reference number

No

No

tsk_class

varchar(25)

NULL

This flag indicates if the task is a standard task or a non routine task STD  - Standard NSTD - Non Standard

No

No

tsk_no_of_occur

varchar(25)

NULL

Number of Occurrences for Task

No

No

tsk_external_flag

varchar(25)

NULL

External Flag

No

No

TSK_BASE_MODEL_OU

numeric(10)

NULL

Base Model OU

No

No

TSK_WF_DOC_KEY

varchar(128)

NULL

Work Flow Doc Key

No

No

TSK_STAGE

varchar(10)

NULL

Task Stage A - Activate C- Cancel

No

No

TSK_OPERATIONAL_TYPE

varchar(25)

NULL

Operational Type F145 - FAR-145 F135 -FAR-135

No

No

TSK_WCCODE

varchar(30)

NULL

Work Center Code

No

No

TSK_WCCODE_OU

numeric(10)

NULL

Work Center Ou

No

No

TSK_SRC_DOC_OU

numeric(10)

NULL

Source Document OU

No

No

TSK_WRENCH_TIME

numeric(28,8)

NULL

Wrench Time

No

No

TSK_IDEAL_TIME

numeric(28,8)

NULL

Ideal Time

No

No

TSK_EXE_PHASE

char(25)

NULL

Execution Phase

No

No

TSK_MPD_ITEMNO

varchar(40)

NULL

Item Number

No

No

TSK_WRENCHTIME_MIN

numeric(28,8)

NULL

Wrench Time

No

No

tsk_IDEALTIME_MIN

numeric(28,8)

NULL

IdealTime

No

No

Table Name bas_tsk_tskae_ac_effect

Table Comment Aircraft Effectivity For Task

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

TSKAE_TAB_TO_SUFFIX

varchar(30)

NULL

To suffix

No

No

TSKAE_CREATIONDATE

datetime

NULL

Creation Date

No

No

TSKAE_TAB_FROM_SUFFIX

varchar(30)

NULL

From Suffix

No

No

TSKAE_TAB_PREFIX

varchar(30)

NULL

Tab prefix

No

No

TSKAE_MODIFIED_BY

char(30)

NULL

Modified By

No

No

TSKAE_CREATED_BY

char(30)

NULL

Created By

No

No

TSKAE_MODIFIEDDATE

datetime

NULL

Modified Date

No

No

TSKAE_COMMENTS

char(255)

NULL

Comments

No

No

tskae_task_no

varchar(30)

NOT NULL

Task Number

Yes

Yes

tskae_revision_no

varchar(40)

NOT NULL

Revision number of the Task

Yes

Yes

tskae_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

Yes

tskae_to_tab_no

varchar(30)

NOT NULL

Tab number till which the Model is associated

No

No

tskae_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

tskae_Model_no

varchar(20)

NOT NULL

Model associated with the task

Yes

Yes

tskae_from_tab_no

varchar(30)

NOT NULL

Tab number from which the Model is associated

Yes

No

Table Name bas_tsk_tskap_access_panel

Table Comment Access Panel List For Task

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

TSKAP_MODEL_NO

varchar(20)

NOT NULL

No

No

tskap_base_model_no

varchar(20)

NULL

Model Number

Yes

Yes

tskap_accesspanel_no

varchar(15)

NOT NULL

Access Panel number associated with the task

No

Yes

TSKAP_MODEL_OU

numeric(10)

NULL

Model OU

No

No

tskap_seq_no

numeric(10)

NOT NULL

Sequence number of the Access Panel

Yes

No

tskap_revision_no

varchar(40)

NOT NULL

Revision Number of the Task

Yes

Yes

tskap_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

Yes

tskap_task_no

varchar(30)

NOT NULL

Task Number

Yes

Yes

Table Name bas_tsk_tskce_cmp_effect

Table Comment Component Effectivity For Task

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

tskce_modifieddate

datetime

NULL

Modified Date

No

No

tskce_creationdate

datetime

NULL

Creation Date

No

No

tskce_mod_part_app_flag

varchar(25)

NULL

Modified Part Applicability

No

No

tskce_created_by

varchar(30)

NULL

Created User

No

No

tskce_modified_by

varchar(30)

NULL

Last Modified User

No

No

TSKCE_COMMENTS

char(255)

NULL

No

No

tskce_task_no

varchar(30)

NOT NULL

Task Number

Yes

Yes

tskce_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

Yes

tskce_part_ou

numeric(10)

NULL

Partadmin Organization unit where Part created.

No

No

tskce_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

tskce_revision_no

varchar(40)

NOT NULL

Revision Number of the Task

Yes

Yes

tskce_part_no

varchar(40)

NOT NULL

component number (part) where this task is applicable

Yes

No

Table Name bas_tsk_tskd_task_details

Table Comment Subtask Details For Task

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

tskd_ammcmm_itemno

varchar(40)

NULL

AMM\CMM Item Number

No

No

tskd_dsclcode

varchar(15)

NULL

Dependent System Code

No

No

tskd_subtask_row_no

decimal(10)

NOT NULL

Running seq no

No

No

tskd_Path

varchar(50)

NULL

Path

No

No

TSKD_CREATIONDATE

varchar(30)

NULL

task created date

No

No

TSKD_MPD_ITEMNO

varchar(40)

NULL

Item number

No

No

TSKD_MODIFIED_BY

varchar(30)

NULL

Login id of the user who modified the task

No

No

TSKD_CREATED_BY

varchar(30)

NULL

Login id of the user who created the task

No

No

TSKD_MODIFIEDDATE

varchar(30)

NULL

task modified date

No

No

tskd_task_no

varchar(30)

NOT NULL

Task Number

Yes

Yes

tskd_revision_no

varchar(40)

NOT NULL

Revision Number of the Task

Yes

Yes

tskd_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

Yes

tskd_documentno

varchar(40)

NULL

Document Number

No

No

tskd_resource_grp

varchar(25)

NULL

Resource group of the Sub Task. Can be ’Inspector’, ’Mechanic’ or ’Both’ INS - Inspector MEC - Mechanic BO - Inspector and Mechanic

No

No

tskd_seq_no

numeric(10)

NOT NULL

Sequence number of the Sub Task

Yes

No

tskd_sub_task

varchar(2000)

NULL

Sub Task Number

No

No

tskd_base_model_no

varchar(30)

NOT NULL

Model Number

No

Yes

Table Name bas_tsk_tskme_mdl_effect

Table Comment Model Effectivity for Task

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

TSKME_CREATED_BY

char(30)

NULL

No

No

TSKME_CREATIONDATE

datetime

NULL

No

No

tskme_aircraft_count

numeric(10)

NULL

number of aircraft which have been associated with the model

No

No

TSKME_MODIFIEDDATE

datetime

NULL

No

No

TSKME_MODIFIED_BY

char(30)

NULL

No

No

TSKME_COMMENTS

char(255)

NULL

No

No

tskme_task_no

varchar(30)

NOT NULL

Task Number

Yes

Yes

tskme_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

Yes

tskme_model_ou

numeric(10)

NOT NULL

Model Created Ouinstance

No

No

tskme_model_no

varchar(20)

NOT NULL

Model number for which this task is applicable

Yes

No

tskme_revision_no

varchar(40)

NOT NULL

Revision Number of the Task

Yes

Yes

tskme_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

Table Name bas_tsk_tsknot_task_notes

Table Comment Notes Definition For Task

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

TSK_LINK_FLAG

varchar(25)

NULL

Link Flag

No

No

tsknot_notes

varchar(2000)

NULL

Notes for the Task

No

No

TSK_MODIFIED_BY

varchar(30)

NULL

Modified user

No

No

TSK_MODIFIEDDATE

datetime

NULL

Modified on

No

No

tsknot_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

Yes

tsknot_base_model_no

varchar(20)

NOT NULL

Model Number

Yes

Yes

tsknot_task_no

varchar(30)

NOT NULL

Task Number

Yes

Yes

tsknot_revision_no

varchar(40)

NOT NULL

Revision number of the Task

Yes

Yes

Table Name bas_tsk_tsknrt_nr_tsk

Table Comment Non Routine Task Master

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

tsknrt_ouinstance

numeric(10)

NOT NULL

OUInstance

Yes

No

tsknrt_non_routine_task_no

varchar(30)

NOT NULL

Non routine task number created at the time of work order generation

Yes

No

TSKNRT_DESCRIPTION_UP

varchar(150)

NULL

Description in upper case

No

No

tsknrt_description

varchar(150)

NULL

Description of the non routine task number

No

No

tsknrt_type

varchar(25)

NULL

Task type

No

No

tsknrt_ata_no

varchar(16)

NULL

Ata number

No

No

tsknrt_status

varchar(15)

NULL

Status of the Non routine task. Can be either ’Active’ or ’Inactive’ A - Active I - Inactive

No

No

tsknrt_no_of_occurences

numeric(10)

NULL

No. of occurrences of the Non routine task in the work orders

No

No

tsknrt_created_by

varchar(30)

NULL

Last Modified User

No

No

tsknrt_creationdate