Data Dictionary -- Maintenance Task

Srl. No.	Table Name	Comment
1	BAS_APTSK_APTRSO_RES_SIGNOFF	Res Sign Off
2	BAS_TSKRS_REPSCHEME_HIR_RELSHIP	To hold the entire hierarchy of repair scheme.
3	BAS_TSK_APM_ACCESS_PANELS	Access panel master
4	BAS_TSK_APRVP_REVISE_PART	To store revise part information
5	BAS_TSK_APRVR_REVISE_RES	To store task revising resource information
6	BAS_TSK_APRVT_REVISE_ELAPT	To maintain task revised elapsed time information
7	BAS_TSK_APTME_MDL_EFFECT	Model Effectivity for Access Panel Task
8	BAS_TSK_APTP_APT_PARTS	Part Requirements for the access panel task
9	BAS_TSK_APTRT_RESOURCE_TYPE	Resource types mapped to access panel
10	BAS_TSK_APTR_APT_RESOURCE	Resource Requirements for access panel task
11	BAS_TSK_APTS_APT_SUBTASKS	Subtasks for access panel task
12	BAS_TSK_APT_AP_TASK	Access panel task details
13	BAS_TSK_DSCL_DEP_SYSTEM	DSC Dependency Details
14	BAS_TSK_DSC_CODES	Dependent System Component codes master
15	BAS_TSK_MODEFF_MLT	To store the Task-Mod Effectivity
16	BAS_TSK_RVP_REVISE_PART	To store revise part information for tasks.
17	BAS_TSK_RVR_REVISE_RES	To maintain revised resource details
18	BAS_TSK_RVT_REVISE_ELAPT	To store revised elapsed time details for the tasks.
19	BAS_TSK_SPAC_AC_EFFECTIVITY	Aircraft Effectivity Details for Standard Procedure
20	BAS_TSK_SPCE_CMP_EFFECT	Component Effectivity For Standard Procedure
21	BAS_TSK_SPD_STD_PROC_DTL	Task List For Standard Procedure
22	BAS_TSK_SPME_MDL_EFFECT	Model Effectivity Definition for Standard Procedure
23	BAS_TSK_SPP_SPARE_PARTS	Spare Part List For Standard Procedure
24	BAS_TSK_SPR_RESOURCE	Resource Specification For Standard Procedure
25	BAS_TSK_SPTR_TASK_RELATION	Task Relationship within Standard Procedure
26	BAS_TSK_SRCD_SEARCH_ID_DET	Source document search id detail
27	BAS_TSK_SRCH_SEARCH_ID_HDR	To maintain task search id header information
28	BAS_TSK_STP_STD_PROC	Standard Procedure Master
29	bas_tsk_task_exec_relationship	To store the hierarchy of execution related tasks
30	BAS_TSK_TFAD_TASK_FILEATTACHMENT_DTL	BAS_TSK_TFAD_TASK_FILEATTACHMENT_DTL
31	BAS_TSK_TPE_PART_EFFECT	To store task part effectivity details
32	BAS_TSK_TQC_QUICK_CODE	User defined Quick Codes
33	BAS_TSK_TRES_TASK_RESOURCE	Resource Requirement for Tasks
34	BAS_TSK_TRSO_RES_SIGNOFF	To store values of Task Resource Sign Off.
35	BAS_TSK_TSKAE_AC_EFFECT	Aircraft Effectivity For Task
36	BAS_TSK_TSKAP_ACCESS_PANEL	Access Panel List For Task
37	BAS_TSK_TSKCE_CMP_EFFECT	Component Effectivity For Task
38	BAS_TSK_TSKD_TASK_DETAILS	Subtask Details For Task
39	BAS_TSK_TSKME_MDL_EFFECT	Model Effectivity for Task
40	BAS_TSK_TSKNOT_TASK_NOTES	Notes Definition For Task
41	BAS_TSK_TSKNRT_NR_TSK	Non Routine Task Master
42	bas_tsk_tskoe_oprtr_effect	Operator Effectivity for Task
43	BAS_TSK_TSKPP_PRM_PRDICITY	Periodicity Definition For Task Parameter
44	BAS_TSK_TSKP_SPARE_PART	Spare Part List For Task
45	bas_tsk_tskrl_task_relationship	To store the hierarchy of tasks
46	BAS_TSK_TSKRS_REPSCHEME_DTL	To store the additional information of task in a Repair scheme
47	BAS_TSK_TSKRS_REPSCHEME_HDR	To capture the definiton of a repair scheme
48	BAS_TSK_TSKRT_RESOURCE_TYPE	Resource Type For Task
49	BAS_TSK_TSKR_REF_DETAILS	Task Reference details will be maintaining
50	BAS_TSK_TSKTP_TASK_PRDICITY	Periodicity Definition For Task
51	BAS_TSK_TSKWZ_TSK_WRK_AREA	Work Area Definition For Task
52	BAS_TSK_TSK_TASK_MASTER	Task Master
53	BAS_TSK_WKA_WORK_AREA	Work Area Master
54	TSK_PARAMETER_DETAILS	Parameter details for BasTask component.
55	TSK_TSKLOG_STATUS_LOG	Task Status history is maintaining
56	tsk_tskmsq_seq_cntrl_hdr	Manage Unified Task Sequence
57	TSK_TSKOPSET_OPTION_SETTING	Option Setting table
58	TSK_TSKOPSET_OPTION_SETTING_DTL	To capture the option settings
59	tsk_tskosq_seq_cntrl_ops_seq	To capture the task sequencing
60	tsk_tskprm_cond_param_readings	To store task Conditional parameter readings.
61	TSK_TSKPRM_PARAM_READINGS	To store task parameter readings.
62	tsk_tskpsq_seq_cntrl_part_list	To capture the list of parts used in Sequencing.
63	tsk_tsktsq_seq_cntrl_rep_scheme_list	To capture the list of Repair Schemes used in Sequencing.

Table Name :	BAS_APTSK_APTRSO_RES_SIGNOFF
Comment :	Res Sign Off

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APTRSO_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	PCR_OUINSTANCE	No
APTRSO_TASK_NO	udd_workunitcode	varchar(30)	No	PCR_PROC_REF_NO	No
APTRSO_BASE_MODEL_NO	udd_model	varchar(20)	Yes	PCR_PROC_REF_STATUS	No
APTRSO_RES_TYPE	udd_flag	varchar(25)	Yes	PCR_CR_NO	No
APTRSO_RESOURCE_OU	udd_ctxt_ouinstance	int(4)	Yes	APTRSO_RESOURCE_OU	No
APTRSO_RESOURCE_CODE	udd_resourcecode	varchar(40)	Yes	APTRSO_RESOURCE_CODE	No
APTRSO_ST_SEQNO	udd_seqno	int(4)	Yes	APTRSO_ST_SEQNO	No
APTRSO_RES_GROUP	udd_flag	varchar(25)	Yes	APTRSO_RES_GROUP	No
APTRSO_SIGN_OFF_FLAG	udd_flag	varchar(25)	Yes	APTRSO_SIGN_OFF_FLAG	No
APTRSO_SUB_TASK	varchar	Char(10)	Yes	APTRSO_SUB_TASK	No

Table Name :	BAS_TSKRS_REPSCHEME_HIR_RELSHIP
Comment :	To hold the entire hierarchy of repair scheme.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKRS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Organization Unit	No
TSKRS_ROOT_KEYNO	udd_seqno	int(4)	Yes	Root Task key number	No
TSKRS_PAR_KEYNO	udd_seqno	int(4)	Yes	Parent Task key number	No
TSKRS_REL_KEYNO	udd_seqno	int(4)	Yes	Related Task key number	No
tskrs_child_prt_no	udd_partno	varchar(40)	Yes	Child Part on which the task has to be performed.	No
tskrs_child_mfg_prtno	udd_partno	varchar(40)	Yes	Child Manufacturer Part on which the task has to be performed.	No
tskrs_mfg_no	udd_vendorcode	varchar(45)	Yes	Manufacturer Number	No
tskrs_child_pos_no	udd_positioncode	varchar(25)	Yes	Position number on which task has to be performed	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_APM_ACCESS_PANELS
Comment :	Access panel master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APM_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
APM_ACCESSPANEL_NO	_varchar_15	varchar(15)	No	Access Panel Number	Yes
APM_MODEL_NO	_varchar_20	varchar(20)	No	Model no for the Aircraft	Yes
APM_ZONE_NO	_varchar_15	varchar(15)	Yes	Zone Code	No
APM_MODEL_OU	_decimal_10_0	decimal(10)	Yes	Model Ouinstance	No
APM_ZONE_OU	_decimal_10_0	decimal(10)	Yes	Zone Ouinstance	No
APM_OPEN_TASK_NO	_varchar_30	varchar(30)	Yes	Open Task for the Access Panel	No
APM_CLOSE_TASK_NO	_varchar_30	varchar(30)	Yes	Close Task for the Access Panel	No
APM_DESCRIPTION	_varchar_150	varchar(150)	Yes	Description of the Access Panel	No
APM_DESCRIPTION_UP	_varchar_150	varchar(150)	Yes	Description in Upper case	No
APM_STATUS	_varchar_15	varchar(15)	Yes	Status of the Access Panel A - Active I - InActive	No
APM_COMMENTS	_varchar_255	varchar(255)	Yes	Comments during Access Panel Modification	No
APM_CREATED_BY	_varchar_30	varchar(30)	No	First created user	No
APM_CREATIONDATE	_datetime_8	datetime(8)	No	Creation date	No
APM_MODIFIEDDATE	_datetime_8	datetime(8)	No	Modified date	No
APM_MODIFIED_BY	_varchar_30	varchar(30)	No	Last modified user	No
APM_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp	No

Table Name :	BAS_TSK_APRVP_REVISE_PART
Comment :	To store revise part information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APRVP_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU	Yes
APRVP_TASK_NO	_varchar_30	varchar(30)	No	Task number	Yes
APRVP_BASE_MODEL_NO	_varchar_20	varchar(20)	Yes	Base model number	No
APRVP_PART_NO	_varchar_40	varchar(40)	No	Part number	Yes
APRVP_PART_OU	_decimal_10_0	decimal(10)	Yes	Part ou	No
APRVP_TOTALQTY_CONSUMED	_decimal_28_8	decimal(28)	Yes	Total Quantity consumed	No
APRVP_TOTAL_OCCURENCES	_decimal_10_0	decimal(10)	Yes	Total occurances	No
APRVP_REVISED_DATE	_datetime_8	datetime(8)	Yes	Revised Date	No
APRVP_REVISED_BY	_varchar_30	varchar(30)	Yes	Revisor id	No

Table Name :	BAS_TSK_APRVR_REVISE_RES
Comment :	To store task revising resource information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APRVR_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU	Yes
APRVR_TASK_NO	_varchar_30	varchar(30)	No	Task number	Yes
APRVR_BASE_MODEL_NO	_varchar_20	varchar(20)	Yes	Base Model number	No
APRVR_RESOURCE_CODE	_varchar_40	varchar(40)	No	Resource code	Yes
APRVR_RESOURCE_TYPE	_varchar_25	Varchar(25)	No	Resource type	Yes
APRVR_ELAPSEDTIME_MIN	_decimal_28_8	decimal(28)	Yes	Elapsed time	No
APRVR_TOTAL_OCCURENCES	_decimal_10_0	decimal(10)	Yes	Total occurances	No
APRVR_REVISED_DATE	_datetime_8	datetime(8)	Yes	Revised on	No
APRVR_REVISED_BY	_varchar_30	varchar(30)	Yes	Revisor id	No

Table Name :	BAS_TSK_APRVT_REVISE_ELAPT
Comment :	To maintain task revised elapsed time information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APRVT_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
APRVT_TASK_NO	_varchar_30	varchar(30)	No	Task number	Yes
APRVT_BASE_MODEL_NO	_varchar_20	varchar(20)	Yes	Base Model number	No
APRVT_ELAPSEDTIME_MIN	_decimal_28_8	decimal(28)	Yes	Elapsedtime	No
APRVT_TOTAL_OCCURENCES	_decimal_10_0	decimal(10)	Yes	Total occurances	No
APRVT_REVISED_DATE	_datetime_8	datetime(8)	Yes	Revised on	No
APRVT_REVISED_BY	_varchar_30	varchar(30)	Yes	Revisor id	No

Table Name :	BAS_TSK_APTME_MDL_EFFECT
Comment :	Model Effectivity for Access Panel Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APTME_OUINSTANCE	_decimal_10_0	decimal(10)	No	Access Panel Task OUInstance	Yes
APTME_AP_TASK_NO	_varchar_30	varchar(30)	No	Access Panel Task Number	Yes
APTME_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Base Model Number	Yes
APTME_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
APTME_MODEL_OU	_decimal_10_0	decimal(10)	Yes	Model OU	No

Table Name :	BAS_TSK_APTP_APT_PARTS
Comment :	Part Requirements for the access panel task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APTP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
APTP_AP_TASK_NO	_varchar_30	varchar(30)	No	Access Panel Task Number	Yes
APTP_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
APTP_PART_NO	_varchar_40	varchar(40)	No	Part identified for performing the Access Panel Task	Yes
APTP_PART_OU	_decimal_10_0	decimal(10)	Yes	Part OU	No
APTP_UOM	_varchar_10	varchar(10)	Yes	unit of measure of the part	No
APTP_QTY	_decimal_28_8	decimal(28)	Yes	Quantity of the part required to perform the access panel task	No
APTP_CREATED_BY	_varchar_30	varchar(30)	Yes	First created user	No
APTP_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation date.	No
APTP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified date.	No
APTP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified By	No

Table Name :	BAS_TSK_APTRT_RESOURCE_TYPE
Comment :	Resource types mapped to access panel

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APTRT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
APTRT_AP_TASK_NO	_varchar_30	varchar(30)	No	Access Panel Task Number	Yes
APTRT_RES_TYPE	_varchar_25	Varchar(25)	No	Resource type - can take values "Skill", "Equipment", "Tool" or "Others" S - Skill E - Equipment T - Tool O- Others	Yes
APTRT_UPD_RES_ACT_FLAG	_varchar_25	Varchar(25)	Yes	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
APTRT_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes

Table Name :	BAS_TSK_APTR_APT_RESOURCE
Comment :	Resource Requirements for access panel task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APTR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
APTR_AP_TASK_NO	_varchar_30	varchar(30)	No	Access Panel Task Number	Yes
APTR_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
APTR_RESOURCE_CODE	_varchar_40	varchar(40)	No	Resource required to perform the Access Panel Task	Yes
APTR_RES_TYPE	_varchar_25	Varchar(25)	No	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
APTR_RESOURCE_OU	_decimal_10_0	decimal(10)	No	Estimated Time for resource requirement	No
APTR_EST_ELAPSED_TIME	_decimal_28_8	decimal(28)	Yes	Estimated elapsed time of access panel task interms of minute.	No
APTR_EST_ELAPSED_TIME_DISP	_decimal_28_8	decimal(28)	Yes	Estimated elapsed time of access panel task - display	No
APTR_EST_ELAPSED_TUOM	_varchar_10	varchar(10)	Yes	Unit of measure for the elapsed time.	No
APTR_ESTIMATED_NOS	_decimal_28_8	decimal(28)	Yes	Estimated numbers of the resource required for the Access Panel Task	No
APTR_SIGN_OFF_FLAG	_varchar_25	Varchar(25)	Yes	Can take value "Yes" or "No". Indicates if sign off is required or not Y - Yes N- No	No
APTR_APP_REQD_FLAG	_varchar_25	Varchar(25)	Yes	Can take either a "Yes" or a "No" Indicates if approval is required or not. Y - Yes N- No	No
APTR_CREATED_BY	_varchar_30	varchar(30)	Yes	Last modified user	No
APTR_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation date	No
APTR_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified date	No
APTR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by	No

Table Name :	BAS_TSK_APTS_APT_SUBTASKS
Comment :	Subtasks for access panel task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APTS_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
APTS_AP_TASK_NO	_varchar_30	varchar(30)	No	Access Panel Number	Yes
APTS_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
APTS_SEQ_NO	_decimal_10_0	decimal(10)	No	sequence number of the guideline	Yes
APTS_SUBTASK	_varchar_2000	varchar(2000)	Yes	Subtask for performing the Access Panel Task	No
APTS_RESOURCEGROUP	_varchar_5	varchar(5)	Yes	Resuorce group has mechanic,inspector,Ins and mec MEC - Mechanic INS - Inspector BO - Insp and Mech	No
APTS_REFDOCNO	_varchar_40	varchar(40)	Yes	Reference Document No	No
APTS_PATH	_varchar_50	varchar(50)	Yes	Document Path	No
APTS_CREATED_BY	_varchar_30	varchar(30)	Yes	first created user	No
APTS_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation date	No
APTS_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified date	No
APTS_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last modified user	No
APTS_AMMCMM_ITEMNO	_varchar_40	varchar(40)	Yes	AMM\CMM Item Number	No
APTS_DSCLCODE	_varchar_15	varchar(15)	Yes	Dependent System Code	No

Table Name :	BAS_TSK_APT_AP_TASK
Comment :	Access panel task details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
APT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
APT_AP_TASK_NO	_varchar_30	varchar(30)	No	Access Panel Task Number	Yes
APT_DSC_NO	_varchar_15	varchar(15)	Yes	Dependent System Number for the Access Panel Task	No
APT_DESCRIPTION	_varchar_150	varchar(150)	Yes	Description of the Access Panel Task	No
APT_DESCRIPTION_UP	_varchar_150	varchar(150)	Yes	Description in upper case	No
APT_STATUS	_varchar_15	varchar(15)	Yes	Status Of the Access Panel Task. Can be "Active" or "Inactive" A - Active I - Inactive	No
APT_TYPE	_varchar_25	Varchar(25)	Yes	Type of the Access Panel Task. Can be either "Open" or "Close" O -Open C - Close	No
APT_EST_DUR	_decimal_28_8	decimal(28)	Yes	Estimated duration for performing the Access Panel Task	No
APT_EST_DUR_DISP	_decimal_28_8	decimal(28)	Yes	Estimated duration display	No
APT_EST_DUR_TUOM	_varchar_10	varchar(10)	Yes	Uom of the Estimated Duration	No
APT_ESTMAN_HRS	_decimal_28_8	decimal(28)	Yes	Sum of the resource hours required for the Access Panel Task	No
APT_UPD_PART_ACT_FLAG	_varchar_25	Varchar(25)	Yes	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
APT_COMMENTS	_varchar_255	varchar(255)	Yes	comments given during modification of the Access Panel task	No
APT_AMMCMMITEMNO	_varchar_40	varchar(40)	Yes	Item no	No
APT_CREATED_BY	_varchar_30	varchar(30)	Yes	Created user	No
APT_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation date	No
APT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified date	No
APT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last modified user	No
APT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
APT_LONG_DESCRIPTION	_varchar_2000	varchar(2000)	Yes	Long description	No
APT_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
APT_BASE_MODEL_OU	_decimal_10_0	decimal(10)	Yes	Model Ouinstance	No
APT_SYSTEM_REF_NO	_varchar_30	varchar(30)	Yes	System reference Number	No

Table Name :	BAS_TSK_DSCL_DEP_SYSTEM
Comment :	DSC Dependency Details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DSCL_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
DSCL_DSCCODE	_varchar_15	varchar(15)	No	Dependent System Code	Yes
DSCL_DISP_POS_NO	_decimal_10_0	decimal(10)	No	Dependent System position number	Yes
DSCL_DEPENDENT_SYSTEM	_varchar_255	varchar(255)	Yes	Dependent System	No
DSCL_CONDITION	_varchar_15	varchar(15)	Yes	The condition of the dependent System. This field is user defined.	No
DSCL_CREATED_BY	_varchar_30	varchar(30)	Yes	Last Modified user	No
DSCL_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
DSCL_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
DSCL_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by	No

Table Name :	BAS_TSK_DSC_CODES
Comment :	Dependent System Component codes master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
DSC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
DSC_DSC_NO	_varchar_15	varchar(15)	No	Dependent System code	Yes
DSC_DESCRIPTION	_varchar_150	varchar(150)	Yes	Brief description about the Dependent System	No
DSC_DESCRIPTION_UP	_varchar_150	varchar(150)	Yes	description in upper case	No
DSC_REF_DOC1	_varchar_40	varchar(40)	Yes	Reference document one for the Dependent	No
DSC_REF_DOC2	_varchar_40	varchar(40)	Yes	Reference document two for the dependent system	No
DSC_DOC1PATH	_varchar_50	varchar(50)	Yes	Path where the reference document one is available.	No
DSC_DOC2PATH	_varchar_50	varchar(50)	Yes	path where the reference document two is available	No
DSC_COMMENTS	_varchar_255	varchar(255)	Yes	comments during dependent system modification	No
DSC_STATUS	_varchar_15	varchar(15)	Yes	status of the Dependent System. Can be "Active" or "Inactive" A - Active I - InActive	No
DSC_CREATED_BY	_varchar_30	varchar(30)	Yes	Created user	No
DSC_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation date	No
DSC_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified date	No
DSC_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last modified user	No
DSC_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
DSC_EXTERNAL_FLAG	_varchar_20	varchar(20)	Yes	External flag Null can be no	No
DSC_REFERENCE_NO	_varchar_255	varchar(255)	Yes	Reference no	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_MODEFF_MLT
Comment :	To store the Task-Mod Effectivity

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKMD_OUINSTANCE	_decimal_18_0	decimal(18)	Yes	Organization Unit	No
TSKMD_TASK_NO	_varchar_30	varchar(30)	Yes	Task no	No
TSKMD_REVISION_NO	_varchar_40	varchar(40)	Yes	Task Revision no	No
TSKMD_AIRCRAFT_MODEL_NO	_varchar_30	varchar(30)	Yes	Aircraft model no	No
TSKMD_BASE_MODEL_NO	_varchar_30	varchar(30)	Yes	Aircraft base model no	No
TSKMD_MOD_NO	_varchar_40	varchar(40)	No	Mod no defined for the aircraft	No
TSKMD_TASK_APPLICABILITY	_varchar_25	Varchar(25)	Yes	Task applicability	No
TSKMD_REMARKS	_varchar_150	varchar(150)	Yes	Remarks	No
TSKMD_TIMESTAMP	_decimal_18_0	decimal(18)	Yes	Timestamp	No
TSKMD_CREATED_BY	_varchar_30	varchar(30)	Yes	Created user	No
TSKMD_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation date	No
TSKMD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by the user	No
TSKMD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified date	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_RVP_REVISE_PART
Comment :	To store revise part information for tasks.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RVP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
RVP_TASK_NO	_varchar_30	varchar(30)	No	Task number	Yes
RVP_REVISION_NO	_varchar_40	varchar(40)	No	Revision number	Yes
RVP_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Base Model number	Yes
RVP_PART_NO	_varchar_40	varchar(40)	No	Part number	Yes
RVP_PART_OU	_decimal_10_0	decimal(10)	Yes	Part OU	No
RVP_TOTALQTY_CONSUMED	_decimal_28_8	decimal(28)	Yes	Total quantity consumed	No
RVP_TOTAL_OCCURENCES	_decimal_10_0	decimal(10)	Yes	Total occurances	No
RVP_REVISED_DATE	_datetime_8	datetime(8)	Yes	Revised on	No
RVP_REVISED_BY	_varchar_30	varchar(30)	Yes	Revisor id	No

Table Name :	BAS_TSK_RVR_REVISE_RES
Comment :	To maintain revised resource details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RVR_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
RVR_TASK_NO	_varchar_30	varchar(30)	No	Task number	Yes
RVR_REVISION_NO	_varchar_40	varchar(40)	No	Revision number	Yes
RVR_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Base model number	Yes
RVR_RESOURCE_CODE	_varchar_40	varchar(40)	No	Resource code	Yes
RVR_RESOURCE_TYPE	_varchar_25	Varchar(25)	No	Resource Type	Yes
RVR_ELAPSEDTIME_MIN	_decimal_28_8	decimal(28)	Yes	Elapsed time in minutes	No
RVR_TOTAL_OCCURENCES	_decimal_10_0	decimal(10)	Yes	total occurances	No
RVR_REVISED_DATE	_datetime_8	datetime(8)	Yes	Revised date	No
RVR_REVISED_BY	_varchar_30	varchar(30)	Yes	Reviser code	No

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

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
RVT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	No
RVT_TASK_NO	_varchar_30	varchar(30)	No	Task nubmer	Yes
RVT_REVISION_NO	_varchar_40	varchar(40)	No	Revision number	Yes
RVT_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Base model number	Yes
RVT_ELAPSEDTIME_MIN	_decimal_28_8	decimal(28)	Yes	Elasped time	No
RVT_TOTAL_OCCURENCES	_decimal_10_0	decimal(10)	Yes	Total occurances	No
RVT_REVISED_DATE	_datetime_8	datetime(8)	Yes	Revised on	No
RVT_REVISED_BY	_varchar_30	varchar(30)	Yes	Revisor id	No

Table Name :	BAS_TSK_SPAC_AC_EFFECTIVITY
Comment :	Aircraft Effectivity Details for Standard Procedure

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPAC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
SPAC_PROC_NO	_varchar_30	varchar(30)	No	Standard Procedure code	Yes
SPAC_MODEL_NO	_varchar_20	varchar(20)	No	Model No for Aircraft effectivity	Yes
SPAC_FROMTAB_NO	_varchar_30	varchar(30)	No	From Aircraft no	Yes
SPAC_TOTAB_NO	_varchar_30	varchar(30)	Yes	To aircraft no	No
SPAC_TAB_PREFIX	_varchar_30	varchar(30)	Yes	Tab Prefix	No
SPAC_TAB_FROM_SUFFIX	_varchar_30	varchar(30)	Yes	Tab From Suffix	No
SPAC_TAB_TO_SUFFIX	_varchar_30	varchar(30)	Yes	Tab To Suffix	No
SPAC_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes

Table Name :	BAS_TSK_SPCE_CMP_EFFECT
Comment :	Component Effectivity For Standard Procedure

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPCE_STP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
SPCE_STP_PROC_NO	_varchar_30	varchar(30)	No	Standard Procedure Number	Yes
SPCE_PART_NO	_varchar_40	varchar(40)	No	Part number (Component Number) where this Standard Procedure is Applicable	Yes
SPCE_PART_OU	_decimal_10_0	decimal(10)	No	It is storing Ouinstance where part created	No
SPCE_MOD_PART_APP_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if all or Restricted models are applicable for the part	No
SPCE_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
SPCE_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
SPCE_CREATED_BY	_varchar_30	varchar(30)	Yes	First created user	No
SPCE_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last modified user	No
SPCE_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes

Table Name :	BAS_TSK_SPD_STD_PROC_DTL
Comment :	Task List For Standard Procedure

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
SPD_PROC_NO	_varchar_30	varchar(30)	No	Standard Procedure Code	Yes
SPD_POS_NO	_decimal_10_0	decimal(10)	No	Position Number of the Task	Yes
SPD_TASK_NO	_varchar_30	varchar(30)	No	Task Number	Yes
SPD_DISPLAY_SEQ_NO	_decimal_10_0	decimal(10)	Yes	Display Sequence Number of the Task	No
SPD_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
SPD_STARTDAY	udd_count	int(4)	Yes	start date	No

Table Name :	BAS_TSK_SPME_MDL_EFFECT
Comment :	Model Effectivity Definition for Standard Procedure

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPME_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
SPME_PROC_NO	_varchar_30	varchar(30)	No	Standard Procedure Number	Yes
SPME_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
SPME_MODEL_OU	_decimal_10_0	decimal(10)	No	model created ou	No
SPME_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Base model no of the aircraft	Yes

Table Name :	BAS_TSK_SPP_SPARE_PARTS
Comment :	Spare Part List For Standard Procedure

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
SPP_PROC_NO	_varchar_30	varchar(30)	No	Standard Procedure Number	Yes
SPP_PART_NO	_varchar_40	varchar(40)	No	Part number indentified to perform the standard procedure	Yes
SPP_PART_OU	_decimal_10_0	decimal(10)	No	Part Ouinstance	No
SPP_QUANTITY	_decimal_28_8	decimal(28)	Yes	estimated quantity of the part number	No
SPP_PART_UOM	_varchar_10	varchar(10)	Yes	unit of measure of the part number identified	No
SPP_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
SPP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
SPP_CREATED_BY	_varchar_30	varchar(30)	Yes	First created user	No
SPP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
SPP_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Base model no of the aircraft	Yes

Table Name :	BAS_TSK_SPR_RESOURCE
Comment :	Resource Specification For Standard Procedure

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
SPR_PROC_NO	_varchar_30	varchar(30)	No	Standard Procedure Number	Yes
SPR_RES_TYPE	_varchar_25	Varchar(25)	No	Resource Type. Can be Skill Equipment or Tool S - Skill E - Equipment T - Tool	Yes
SPR_RESOURCE_CODE	_varchar_40	varchar(40)	No	Resource Code	Yes
SPR_RESOURCE_OU	_decimal_10_0	decimal(10)	No	It is storing organization unit where resource created	No
SPR_EST_ELAPSED_TUOM	_varchar_10	varchar(10)	Yes	Elaspsed time unit of measurement	No
SPR_EST_ELAPSED_TIME	_decimal_28_8	decimal(28)	Yes	Elapsed Time in terms of minutes.	No
SPR_ESTIMATED_NOS	_decimal_28_8	decimal(28)	Yes	Estimated number of the resource	No
SPR_APP_REQD_FLAG	_varchar_25	Varchar(25)	Yes	Indicate if the Resource requires approval. Can be Yes or No Y - Yes N - No	No
SPR_SIGN_OFF_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if the Resource requires a Sign off. Values can be either Yes or No Y - Yes N - No	No
SPR_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
SPR_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
SPR_CREATED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
SPR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified user.	No
SPR_EST_ELAPSED_TIME_DISP	_decimal_28_8	decimal(28)	Yes	Elapsed Time	No
SPR_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes

Table Name :	BAS_TSK_SPTR_TASK_RELATION
Comment :	Task Relationship within Standard Procedure

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SPTR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
SPTR_PROC_NO	_varchar_30	varchar(30)	No	Procedure Number	Yes
SPTR_FROM_TASK_NO	_varchar_30	varchar(30)	No	From Task Number	Yes
SPTR_FROM_POS_NO	_decimal_10_0	decimal(10)	No	From position number of the Task	Yes
SPTR_TO_TASK_NO	_varchar_30	varchar(30)	No	To Task Number	Yes
SPTR_TO_POS_NO	_decimal_10_0	decimal(10)	No	To Position Number of the Task	Yes
SPTR_RELATION_TYPE	_varchar_25	Varchar(25)	Yes	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
SPTR_LAG_TIME	_decimal_28_8	decimal(28)	Yes	Time Lag	No
SPTR_LAG_TUOM	_varchar_10	varchar(10)	Yes	Lag unit of measure	No
SPTR_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
SPTR_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
SPTR_CREATED_BY	_varchar_30	varchar(30)	Yes	first created user	No
SPTR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified user	No
SPTR_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes

Table Name :	BAS_TSK_SRCD_SEARCH_ID_DET
Comment :	Source document search id detail

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SRCD_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
SRCD_SEARCH_ID	_varchar_30	varchar(30)	No	Search ID	Yes
SRCD_PARAM_CODE	_varchar_40	varchar(40)	No	Param Code	Yes
SRCD_VALUE_TYPE	_varchar_25	Varchar(25)	No	Value Type	Yes
SRCD_OPERATOR	_varchar_25	Varchar(25)	Yes	Operator	No
SRCD_VALUE	_varchar_32	varchar(32)	Yes	Value	No
SRCD_FROM_VALUE	_varchar_32	varchar(32)	Yes	From Value	No
SRCD_TO_VALUE	_varchar_32	varchar(32)	Yes	To value	No
SRCD_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
SRCD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
SRCD_CREATED_BY	_varchar_30	varchar(30)	Yes	Creator id	No
SRCD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	modifier id	No

Table Name :	BAS_TSK_SRCH_SEARCH_ID_HDR
Comment :	To maintain task search id header information

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SRCH_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU Instance	Yes
SRCH_SEARCH_ID	_varchar_30	varchar(30)	No	Search ID	Yes
SRCH_SCH_TYPE	_varchar_25	Varchar(25)	Yes	Schedule Type	No
SRCH_THRESHOLD_DAYS_OP	_varchar_25	Varchar(25)	Yes	Threshold Days opertion	No
SRCH_THRESHOLD_DAYS_VAL	_varchar_32	varchar(32)	Yes	Threshold Days value	No
SRCH_REPEAT_INT_OP	_varchar_25	Varchar(25)	Yes	Repeat interval operation	No
SRCH_REPEAT_INT_VAL	_varchar_32	varchar(32)	Yes	Repeat interval value	No
SRCH_THRESHOLD_FROM_VALUE	_varchar_32	varchar(32)	Yes	Threshold from value	No
SRCH_THRESHOLD_TO_VALUE	_varchar_32	varchar(32)	Yes	Threshold to value	No
SRCH_REPEAT_FROM_VALUE	_varchar_32	varchar(32)	Yes	Repeat from value	No
SRCH_REPEAT_TO_VALUE	_varchar_32	varchar(32)	Yes	Repeat To value	No
SRCH_CREATIONDATE	_datetime_8	datetime(8)	Yes	Created on	No
SRCH_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified on	No
SRCH_CREATED_BY	_varchar_30	varchar(30)	Yes	Creator Id	No
SRCH_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modifier ID	No
SRCH_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No

Table Name :	BAS_TSK_STP_STD_PROC
Comment :	Standard Procedure Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
STP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
STP_PROC_NO	_varchar_30	varchar(30)	No	Standard Procedure code	Yes
STP_PROC_DESC	_varchar_150	varchar(150)	No	Description of the Standard Procedure	No
STP_PROC_DESC_UP	_varchar_150	varchar(150)	No	standard procedure description in upper case	No
STP_EST_ELAPSED_TIME	_decimal_28_8	decimal(28)	No	Estimated duration to perform the standard procedure in terms of minutes.	No
STP_EST_ELAPSED_TUOM	_varchar_10	varchar(10)	No	unit of measure for the estimated duration (elapsed time) H - Hours M - Minutes D - Days	No
STP_EST_MAN_HRS	_decimal_28_8	decimal(28)	No	Sum of the resource hours required to carry out the Standard Procedure	No
STP_MODEL_COUNT	_decimal_10_0	decimal(10)	Yes	Number of model where the Standard Procedure is applicable	No
STP_LINK_FLAG	_varchar_25	Varchar(25)	Yes	Link flag indicates if Parts or Resources or Notes have been defined for the standard procedure.P-R-N denotes all three have been indentified	No
STP_APPLICABILITY	_varchar_25	Varchar(25)	Yes	Applicability of the Standard Procedure. Can be "Aircraft","Engine" or "Component" A - Aircraft E - Engine C - Component	No
STP_SP_TYPE	_varchar_30	varchar(30)	Yes	Type of the Standard Procedure.This is user defined	No
STP_STATUS	_varchar_25	Varchar(25)	Yes	Status of the Standard Procedure. Can either be Active or Inactive A - Active I - Inactive	No
STP_COMMENTS	_varchar_255	varchar(255)	Yes	Comments during the Modification of the standard procedure	No
STP_CREATED_BY	_varchar_30	varchar(30)	No	Last Modified User	No
STP_CREATIONDATE	_datetime_8	datetime(8)	No	Creation Date	No
STP_MODIFIEDDATE	_datetime_8	datetime(8)	No	Modified Date	No
STP_MODIFIED_BY	_varchar_30	varchar(30)	No	Modified by the user	No
STP_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp	No
STP_ATANO	_varchar_16	varchar(16)	Yes	ATA No	No
STP_ATAOU	_decimal_38_0	decimal(38)	Yes	Aircraft Ou where Ata No created.	No
STP_EST_ELAPSED_TIME_DISP	_decimal_28_8	decimal(28)	Yes	Estimated duration to perform the standard procedure for display	No
STP_PROC_LONG_DESC	_varchar_2000	varchar(2000)	Yes	Long Decription for Standard Procedure	No
STP_REF_DOCNO1	_varchar_40	varchar(40)	Yes	Reference Document Number1	No
STP_REF_DOCNO2	_varchar_40	varchar(40)	Yes	Reference Document Number2	No
STP_FILENAME1	_varchar_50	varchar(50)	Yes	FileName1	No
STP_FILENAME2	_varchar_50	varchar(50)	Yes	FileName2	No
STP_COMPONENT_COUNT	_decimal_38_0	decimal(38)	Yes	Component Count	No
STP_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
STP_MODEL_OU	_decimal_10_0	decimal(10)	Yes	Model Ouinstance	No
STP_OPERATIONAL_TYPE	_varchar_25	Varchar(25)	Yes	Operational Type	No
STP_WCCODE	_varchar_30	varchar(30)	Yes	Work Center Code	No
STP_WCCODE_OU	_decimal_10_0	decimal(10)	Yes	Work Center OU	No
STP_REVISION_NO	_varchar_40	varchar(40)	Yes	Revision Number	No
STP_REVISION_COMMENTS	_varchar_255	varchar(255)	Yes	Revision Comments	No
STP_REVISION_DATE	_datetime_8	datetime(8)	Yes	Revision Date	No
STP_REVISION_IND	_varchar_5	varchar(5)	Yes	STP_REVISION_IND	No
STP_WRENCH_TIME	_numeric_28_8	numeric(28)	Yes	Wrench Time	No
STP_IDEAL_TIME	_numeric_28_8	numeric(28)	Yes	Ideal Time	No
STP_MPD_ITEMNO	_varchar_40	varchar(40)	Yes	MPD Item number	No

Table Name :	bas_tsk_task_exec_relationship
Comment :	To store the hierarchy of execution related tasks

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Tsk_Ou	udd_ctxt_ouinstance	int(4)	Yes	task ouinstance	No
Tsk_Root_Task	udd_taskcode	varchar(30)	Yes	Root task no	No
Tsk_Par_Task	udd_taskcode	varchar(30)	Yes	Parent Task number	No
Tsk_Rel_Task	udd_taskcode	varchar(30)	Yes	Related task number for the main task	No
Tsk_Rel_Catg	udd_category	varchar(15)	Yes	Related Task Category	No
Tsk_Rel_flag	udd_designparamcode	varchar(5)	Yes	Relationship Flag.	No
Tsk_RootTsk_model	udd_model	varchar(20)	Yes	Root Tasks model	No
Tsk_ParTsk_model	udd_model	varchar(20)	Yes	Parent Tasks model	No
Tsk_RelTsk_model	udd_model	varchar(20)	Yes	Related Tasks model	No
Tsk_aircraft_Model	udd_model	varchar(20)	Yes	aircraft Model no	No
Tsk_airecraftno	udd_aircraftnumber	varchar(30)	Yes	Aircraft effective for the task	No
Tsk_Partno	udd_documentno	varchar(40)	Yes	Part effective for the Task	No
Tsk_applicability	udd_designparamcode	varchar(5)	Yes	Appplicability of the task	No
Tsk_Hierarchy	_hierarchyid_0	hierarchyid(0)	Yes	Task Hierarchy level id	No
Tsk_createdby	udd_ctxt_user	varchar(30)	Yes	Created by	No
Tsk_created_date	_datetime_8	datetime(8)	Yes	Created date	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TFAD_TASK_FILEATTACHMENT_DTL
Comment :	BAS_TSK_TFAD_TASK_FILEATTACHMENT_DTL

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?

Table Name :	BAS_TSK_TPE_PART_EFFECT
Comment :	To store task part effectivity details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TPE_OUINSTANCE	_decimal_10_0	decimal(10)	No	OU instance	Yes
TPE_TASK_NO	_varchar_30	varchar(30)	No	Task number	Yes
TPE_REVISION_NO	_varchar_40	varchar(40)	No	Revision number	Yes
TPE_PART_NO	_varchar_40	varchar(40)	No	Part number	Yes
TPE_PART_OU	_decimal_10_0	decimal(10)	No	Part OU	No
TPE_EFFECT_FLAG	_varchar_25	Varchar(25)	Yes	Effectivity Flag	No

Table Name :	BAS_TSK_TQC_QUICK_CODE
Comment :	User defined Quick Codes

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TQC_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TQC_QUICK_CODE	_varchar_25	Varchar(25)	No	quick code	Yes
TQC_TYPE	_varchar_25	Varchar(25)	No	quick code type	Yes
TQC_DESCRIPTION	_varchar_80	varchar(80)	No	description of the quick code	No
TQC_STATUS	_varchar_15	varchar(15)	No	Status of the quick code. Can be Active or Inactive A - Active I - Inactive	No
TQC_COMMENTS	_varchar_255	varchar(255)	Yes	Comments	No
TQC_CREATED_BY	_varchar_30	varchar(30)	No	Created user	No
TQC_CREATIONDATE	_datetime_8	datetime(8)	No	Creation Date	No
TQC_MODIFIED_BY	_varchar_30	varchar(30)	No	Last Modified user.	No
TQC_MODIFIEDDATE	_datetime_8	datetime(8)	No	Modified Date	No
TQC_TIMESTAMP	_decimal_10_0	decimal(10)	No	Timestamp	No
TQC_EXTERNAL_FLAG	_varchar_25	Varchar(25)	Yes	External Flag	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TRES_TASK_RESOURCE
Comment :	Resource Requirement for Tasks

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKR_TASK_NO	_varchar_30	varchar(30)	No	Task number	Yes
TSKR_REVISION_NO	_varchar_40	varchar(40)	No	Revision number of the Task	Yes
TSKR_RESOURCE_CODE	_varchar_40	varchar(40)	No	Resource code identified for the Task.	Yes
TSKR_RESOURCE_OU	_decimal_10_0	decimal(10)	Yes	Resource OU	No
TSKR_RES_TYPE	_varchar_25	Varchar(25)	No	Resource type - can take values "Skill", "Equipment", "Tool" or "Others" S - Skills E - Equipment T - Tools O - Others	Yes
TSKR_ESTIMATED_NOS	_decimal_28_8	decimal(28)	Yes	Estimated number of the resource required	No
TSKR_EST_ELAPSED_TIME	_decimal_28_8	decimal(28)	No	Estimated time duration of the resource	No
TSKR_EST_ELAPSED_TUOM	_varchar_10	varchar(10)	Yes	unit of measure of the estimated time duration H - Hours M - Minutes D - Days	No
TSKR_APP_REQD_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if approval of the resource is required or not Y - Yes N- No	No
TSKR_SIGN_OFF_FLAG	_varchar_25	Varchar(25)	Yes	Indicates if sign off is required once the resource utlization is complete Y - Yes N - No	No
TSKR_CREATIONDATE	_datetime_8	datetime(8)	No	Creation Date	No
TSKR_MODIFIEDDATE	_datetime_8	datetime(8)	No	Modified Date	No
TSKR_CREATED_BY	_varchar_30	varchar(30)	Yes	creted user	No
TSKR_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
TSKR_EST_ELAPSED_TIME_DISP	_decimal_28_8	decimal(28)	Yes	Estimated elasped time for display	No
TSKR_BASE_MODEL_NO	_varchar_30	varchar(30)	No	Base Model Number	Yes
TSKR_UTI	udd_text255	varchar(255)	Yes	Task Resource Unique ID	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TRSO_RES_SIGNOFF
Comment :	To store values of Task Resource Sign Off.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TRSO_OUINSTANCE	_numeric_10_0	numeric(10)	Yes	OU Instance	No
TRSO_TASK_NO	_varchar_30	varchar(30)	Yes	Task Number	No
TRSO_REVISION_NO	_varchar_40	varchar(40)	Yes	Revision number	No
TRSO_BASE_MODEL_NO	_varchar_30	varchar(30)	Yes	Base Model number	No
TRSO_RES_TYPE	_varchar_25	Varchar(25)	Yes	Resource type	No
TRSO_RESOURCE_OU	_numeric_10_0	numeric(10)	Yes	Resource OU	No
TRSO_RESOURCE_CODE	_varchar_40	varchar(40)	Yes	Resource Code	No
TRSO_ST_SEQNO	_numeric_10_0	numeric(10)	Yes	Sub task sequnce number	No
TRSO_RES_GROUP	_varchar_25	Varchar(25)	Yes	Resource Group	No
TRSO_SIGN_OFF_FLAG	_varchar_25	Varchar(25)	Yes	Sign off flag	No
TRSO_SUB_TASK	_varchar_2000	varchar(2000)	Yes	Name of the Subtask	No
TRSO_UTI	udd_text255	varchar(255)	Yes	Task Signoff Unique ID	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKAE_AC_EFFECT
Comment :	Aircraft Effectivity For Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKAE_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Organization Unit	No
TSKAE_TASK_NO	_varchar_30	varchar(30)	No	Task Number	No
TSKAE_REVISION_NO	_varchar_40	varchar(40)	No	Revision number of the Task	No
TSKAE_MODEL_NO	_varchar_30	varchar(30)	Yes	Model associated with the task	No
TSKAE_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	No
TSKAE_CREATIONDATE	_datetime_8	datetime(8)	Yes	Created date	No
TSKAE_CREATED_BY	_varchar_30	varchar(30)	Yes	created by	No
TSKAE_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified date	No
TSKAE_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by	No
TSKAE_COMMENTS	_varchar_2000	varchar(2000)	Yes	comments during modification of the task effectivity	No
TSKAE_UTI	udd_text255	varchar(255)	Yes	Aircraft Effectivity Unique id	No
TSKAE_AIRCRAFT_REG_NO	udd_aircraftnumber	varchar(30)	Yes	Aircraft Registration no	No
TSKAE_AIRCRAFT_OU	udd_ctxt_ouinstance	int(4)	Yes	Aircraft ouinstance	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKAP_ACCESS_PANEL
Comment :	Access Panel List For Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKAP_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence number of the Access Panel	Yes
TSKAP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKAP_TASK_NO	_varchar_30	varchar(30)	No	Task Number	Yes
TSKAP_REVISION_NO	_varchar_40	varchar(40)	No	Revision Number of the Task	Yes
TSKAP_MODEL_NO	_varchar_20	varchar(20)	No	Aircraft model number	Yes
TSKAP_ACCESSPANEL_NO	_varchar_15	varchar(15)	Yes	Access Panel number associated with the task	No
TSKAP_MODEL_OU	_decimal_10_0	decimal(10)	Yes	Model OU	No
TSKAP_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
tskap_uti	udd_text255	varchar(255)	Yes	tskap_uti	No

Table Name :	BAS_TSK_TSKCE_CMP_EFFECT
Comment :	Component Effectivity For Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKCE_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKCE_TASK_NO	_varchar_30	varchar(30)	No	Task Number	Yes
TSKCE_REVISION_NO	_varchar_40	varchar(40)	No	Revision Number of the Task	Yes
TSKCE_PART_NO	_varchar_40	varchar(40)	No	component number (part) where this task is applicable	Yes
TSKCE_PART_OU	_decimal_10_0	decimal(10)	No	Partadmin Organistion unit where Part created.	No
TSKCE_MOD_PART_APP_FLAG	_varchar_25	Varchar(25)	Yes	Modified Part Applicability	No
TSKCE_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
TSKCE_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
TSKCE_CREATED_BY	_varchar_30	varchar(30)	Yes	Created User	No
TSKCE_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
TSKCE_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
TSKCE_COMMENTS	_varchar_2000	varchar(2000)	Yes	comments	No
TSKCE_UTI	udd_text255	varchar(255)	Yes	Component Effectivity Unique id	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKD_TASK_DETAILS
Comment :	Subtask Details For Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKD_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKD_TASK_NO	_varchar_30	varchar(30)	No	Task Number	Yes
TSKD_REVISION_NO	_varchar_40	varchar(40)	No	Revision Number of the Task	Yes
TSKD_BASE_MODEL_NO	_varchar_30	varchar(30)	No	Model Number	Yes
TSKD_SEQ_NO	_decimal_10_0	decimal(10)	No	Sequence number of the Sub Task	Yes
TSKD_SUB_TASK	_varchar_2000	varchar(2000)	Yes	Sub Task Number	No
TSKD_RESOURCE_GRP	_varchar_25	Varchar(25)	Yes	Resource group of the Sub Task. Can be "Inspector", "Mechanic" or "Both" INS - Inspector MEC - Mechanic BO - Inspector and Mechanic	No
TSKD_DOCUMENTNO	_varchar_40	varchar(40)	Yes	Document Number	No
TSKD_PATH	_varchar_50	varchar(50)	Yes	Path	No
TSKD_SUBTASK_ROW_NO	_decimal_10_0	decimal(10)	No	Running seq no	Yes
TSKD_AMMCMM_ITEMNO	_varchar_40	varchar(40)	Yes	AMM\CMM Item Number	No
TSKD_DSCLCODE	_varchar_30	varchar(30)	Yes	Dependent System Code	No
TSKD_MPD_ITEMNO	_varchar_40	varchar(40)	Yes	Item number	No
TSKD_CREATED_BY	_varchar_30	varchar(30)	Yes	Login id of the user who created the task	No
TSKD_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Login id of the user who modified the task	No
TSKD_CREATIONDATE	_datetime_8	datetime(8)	Yes	Date on which the sub-task details are created	No
TSKD_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Date on which the sub-task details are modified	No
tskd_uti	udd_text255	varchar(255)	Yes	Sub task unique id	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKME_MDL_EFFECT
Comment :	Model Effectivity for Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKME_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKME_TASK_NO	_varchar_30	varchar(30)	No	Task Number	Yes
TSKME_REVISION_NO	_varchar_40	varchar(40)	No	Revision Number of the Task	Yes
TSKME_MODEL_NO	_varchar_20	varchar(20)	No	Model number for which this task is applicable	Yes
TSKME_MODEL_OU	_decimal_10_0	decimal(10)	No	Model Created Ouinstance	No
TSKME_AIRCRAFT_COUNT	_decimal_10_0	decimal(10)	Yes	number of aircrafts which have been associated with the model	No
TSKME_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
TSKME_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation date	No
TSKME_CREATED_BY	_varchar_30	varchar(30)	Yes	Created by	No
TSKME_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified date	No
TSKME_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Modified by	No
TSKME_COMMENTS	_varchar_2000	varchar(2000)	Yes	Comments	No
TSKME_UTI	udd_text255	varchar(255)	Yes	Unique ID	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKNOT_TASK_NOTES
Comment :	Notes Definition For Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKNOT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKNOT_TASK_NO	_varchar_30	varchar(30)	No	Task Number	Yes
TSKNOT_REVISION_NO	_varchar_40	varchar(40)	No	Revision number of the Task	Yes
TSKNOT_NOTES	_varchar_2000	varchar(2000)	Yes	Notes for the Task	No
TSKNOT_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
TSK_LINK_FLAG	_varchar_25	Varchar(25)	Yes	Flag indicating whether Parts, Resources and Notes have been defined for the Task. P-R-N indicates all three have been defined	No
TSK_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User who has modified the task	No
TSK_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified on	No
Tsknot_task_uti	udd_text255	varchar(255)	Yes	Unique ID	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKNRT_NR_TSK
Comment :	Non Routine Task Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKNRT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKNRT_NON_ROUTINE_TASK_NO	_varchar_30	varchar(30)	No	Non routine task number created at the time of work order generation	Yes
TSKNRT_DESCRIPTION_UP	_varchar_150	varchar(150)	Yes	Description in upper case	No
TSKNRT_DESCRIPTION	_varchar_150	varchar(150)	Yes	Description of the non routine task number	No
TSKNRT_TYPE	_varchar_25	Varchar(25)	Yes	Task type	No
TSKNRT_ATA_NO	_varchar_16	varchar(16)	Yes	Ata number	No
TSKNRT_STATUS	_varchar_15	varchar(15)	Yes	Status of the Non routine task. Can be either "Active" or "Inactive" A - Active I - Inactive	No
TSKNRT_NO_OF_OCCURENCES	_decimal_10_0	decimal(10)	Yes	No. of occurences of the Non routine task in the work orders	No
TSKNRT_CREATED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
TSKNRT_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
TSKNRT_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
TSKNRT_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified user.	No
TSKNRT_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
TSKNRT_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Base Model number	No

Table Name :	bas_tsk_tskoe_oprtr_effect
Comment :	Operator Effectivity for Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tskoe_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Organization Unit	No
tskoe_task_no	_varchar_30	varchar(30)	Yes	task no	No
tskoe_revision_no	_varchar_40	varchar(40)	Yes	revisionno	No
tskoe_base_model_no	_varchar_20	varchar(20)	Yes	Base model no of the aircraft	No
tskoe_creationdate	_datetime_8	datetime(8)	Yes	creationdate	No
tskoe_created_by	_varchar_30	varchar(30)	Yes	created_by	No
tskoe_modifieddate	_datetime_8	datetime(8)	Yes	modifieddate	No
tskoe_modified_by	_varchar_30	varchar(30)	Yes	modified_by	No
tskoe_comments	_varchar_2000	varchar(2000)	Yes	comments	No
tskoe_uti	udd_text255	varchar(255)	Yes	Unique ID	No
tskoe_operator_code	udd_charparamval	varchar(32)	Yes	operator code	No
tskoe_operator_ou	udd_ctxt_ouinstance	int(4)	Yes	operator ouinstance	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKPP_PRM_PRDICITY
Comment :	Periodicity Definition For Task Parameter

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKPP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKPP_TASK_NO	_varchar_30	varchar(30)	No	Task Number	Yes
TSKPP_REVISION_NO	_varchar_40	varchar(40)	No	Revision Number of the Task	Yes
TSKPP_PARAM_CODE	_varchar_40	varchar(40)	No	Name of the Parameter	Yes
TSKPP_SCH_TYPE	_varchar_25	Varchar(25)	No	Schedule type of the parameter. Can be either "recurring" or "One Time" R - Recuring O - One Time	Yes
TSKPP_REPEAT_DAYS	_decimal_28_8	decimal(28)	Yes	Number of days after which the task has to be repeated	No
TSKPP_THRESHOLD_DAYS	_decimal_28_8	decimal(28)	Yes	threshold limit in days	No
TSKPP_TERMINATING_VAL	_decimal_28_8	decimal(28)	Yes	Terminating value.	No
TSKPP_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
TSKPP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
TSKPP_CREATED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
TSKPP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last modified user.	No
TSKPP_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
TSKPP_UPD_TEMPL	udd_designparamcode	varchar(5)	Yes	Update to Template. It can have Yes or No.	No
TSKPP_UPD_PROGM	udd_designparamcode	varchar(5)	Yes	Update to Program. It can have Yes or No.	No
TSKPP_UTI	udd_text255	varchar(255)	Yes	Unique ID	No
TSKPP_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKP_SPARE_PART
Comment :	Spare Part List For Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKP_TASK_NO	_varchar_30	varchar(30)	No	Task Number	Yes
TSKP_REVISION_NO	_varchar_40	varchar(40)	No	Revision number of the Task	Yes
TSKP_PART_NO	_varchar_40	varchar(40)	No	part number required to perform the task	Yes
TSKP_PART_OU	_decimal_10_0	decimal(10)	No	Part Admin Ou where part created.	No
TSKP_PART_UOM	_varchar_10	varchar(10)	Yes	unit of measure of the part required	No
TSKP_QUANTITY	_decimal_28_8	decimal(28)	Yes	quantity of the part required	No
TSKP_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
TSKP_MODIFIEDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
TSKP_CREATED_BY	_varchar_30	varchar(30)	Yes	First created User	No
TSKP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
TSKP_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
TSKP_NEED_FRQ	udd_designparamcode	varchar(5)	Yes	Need frequency	No
TSKP_REMARKS	udd_txt255	varchar(255)	Yes	Remarks	No
TSKP_UTI	udd_text255	varchar(255)	Yes	Unique ID	No
TSKP_PROBABILITY	udd_numericparamval	numeric(13)	Yes	Task Probability	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	bas_tsk_tskrl_task_relationship
Comment :	To store the hierarchy of tasks

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Tsk_Ou	udd_ctxt_ouinstance	int(4)	Yes	Organization Unit	No
Tsk_Task	udd_taskcode	varchar(30)	Yes	Task Number	No
Tsk_Rel_Task	udd_taskcode	varchar(30)	Yes	Related task number for the main task	No
Tsk_Rel_Catg	udd_category	varchar(15)	Yes	Related Task Category	No
Tsk_Rel_flag	udd_designparamcode	varchar(5)	Yes	Related Task Flag	No
Tsk_dep_Relid	udd_number	int(4)	Yes	Relationship ID	No
Tsk_Parent_Relid	udd_number	int(4)	Yes	Parent Relationship ID	No
Tsk_def_der_flag	udd_designparamcode	varchar(5)	Yes	Deferment Flag	No
Tsk_Rel_Remarks	udd_txt150	varchar(150)	Yes	Remarks	No
Tsk_Followup_Inst	udd_txt150	varchar(150)	Yes	Follow-up Instructions	No
Tsk_Seqno	udd_taskseqno	int(4)	Yes	Task sequence no	No
Tsk_st_day	udd_number	int(4)	Yes	Tsk_st_day	No
Tsk_Sch_Rel	udd_designparamcode	varchar(5)	Yes	Task Schedule Relationship Flag	No
Tsk_lag	udd_number	int(4)	Yes	Tsk_lag	No
Tsk_primary_model	udd_model	varchar(20)	Yes	Primary model of the main task	No
Tsk_RelTsk_model	udd_model	varchar(20)	Yes	Model of the relatied task	No
Tsk_RevComments	udd_txt150	varchar(150)	Yes	Revision Comments	No
Tsk_createdby	udd_ctxt_user	varchar(30)	Yes	Person who created the relationship	No
Tsk_created_date	_datetime_8	datetime(8)	Yes	Date on which the relationship is defined	No
Tsk_Modifiedby	udd_ctxt_user	varchar(30)	Yes	Name of the user who modified the relationship	No
Tsk_Modified_date	_datetime_8	datetime(8)	Yes	Date on which the relationship is modified	No
task_timestamp	udd_timestamp	int(4)	Yes	Timestamp	No
TSK_REPAIRFLAG	udd_designparamcode	varchar(5)	Yes	Repair Flag to identify whether the relationship is defined from Repair Scheme	No
created_area_code	varchar	Char(10)	Yes	Null	No
Tsk_ID	_numeric_9_0	numeric(9)	No	Task ID	Yes

Table Name :	BAS_TSK_TSKRS_REPSCHEME_DTL
Comment :	To store the additional information of task in a Repair scheme

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKRS_KEYNO	udd_seqno	int(4)	Yes	Repair Scheme Unique #	No
TSKRS_TASK_SEQNO	udd_seqno	int(4)	Yes	Line number of the Related Task in Repair Scheme definition	No
TSKRS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	Yes	Organization Unit	No
TSKRS_TASK_CTRLNO	udd_seqno	int(4)	Yes	Sequence number of the Related Task in Repair Scheme definition	No
TSKRS_RELATED_TSKNO	udd_workunitcode	varchar(30)	Yes	Related task no	No
TSKRS_PARENT_TSKNO	udd_workunitcode	varchar(30)	Yes	Parent Task for which Repair Scheme is defined	No
TSKRS_REL_TYPE	udd_workunitcode	varchar(30)	Yes	Relationship type	No
TSKRS_REL_CATG	udd_designparamcode	varchar(5)	Yes	Relationship category	No
TSKRS_RELTYPEFLAG	udd_designparamcode	varchar(5)	Yes	Relationship Flag.	No
TSKRS_CHILD_POSNO	udd_positioncode	varchar(25)	Yes	Child position on which the task to be performed	No
TSKRS_CHILD_PARTNO	udd_partno	varchar(40)	Yes	Child part number on which the task to be performed	No
TSKRS_CHILD_MFR_PRTNO	udd_partno	varchar(40)	Yes	manufacturer partnumber	No
TSKRS_MANUFAC_NO	udd_vendorcode	varchar(45)	Yes	Manufacturer no	No
TSKRS_MNT_TYPE	udd_quickcodes	varchar(25)	Yes	Maintanence type	No
TSKRS_EXEC_FACILITY	udd_designparamcode	varchar(5)	Yes	Execution facility	No
TSKRS_WORKCENTER_NO	udd_wccode	varchar(30)	Yes	Work center no	No
TSKRS_REPAGENCY_NO	udd_vendorcode	varchar(45)	Yes	Repair agency no	No
TSKRS_STD_DISPOS	udd_quickcodes	varchar(25)	Yes	Standard disposition	No
TSKRS_REPAIR_CLASSIFY	udd_quickcodes	varchar(25)	Yes	Repair classification	No
TSKRS_MANDATORY	udd_designparamcode	varchar(5)	Yes	Mandatory. It can be Yes or No	No
TSKRS_ROUTING_REQ	udd_designparamcode	varchar(5)	Yes	Routing Required. It can be Yes or No	No
TSKRS_REPAIRFLAG	udd_designparamcode	varchar(5)	Yes	Repair Flag to identify whether the relationship is defined from Repair Scheme	No
TSKRS_BASE_MODEL	udd_model	varchar(20)	Yes	Task Base Model	No
TSKRS_SOURCE_FLAG	udd_designparamcode	varchar(5)	Yes	Source flag	No
TSKRS_DEL_FLAG	_bit_1	Bit(1)	Yes	Deleted flag	No
TSKRS_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created by	No
TSKRS_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created date	No
TSKRS_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
TSKRS_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified date	No
tskrs_orig_rep_seqno	udd_seqno	int(4)	Yes	Original Seq #	No
TSKRS_HIERARCHY	_hierarchyid_0	hierarchyid(0)	Yes	Task hierarchy id	No
tskrs_instance_id	udd_seqno	int(4)	Yes	Repair Scheme Unique number	No
tskrs_auto_gen	UDD_BIT	bit(1)	Yes	Auto generation flag	No
TSKRS_EXECDOCTYPE	_Varchar_5	varchar(5)	Yes	Execution Document Type	No
TSKRS_JOBTYPE	_Varchar_5	varchar(5)	Yes	Job type	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKRS_REPSCHEME_HDR
Comment :	To capture the definiton of a repair scheme

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKRS_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Organization Unit	Yes
TSKRS_REPAIR_TSKNO	udd_workunitcode	varchar(30)	Yes	Repair Task #	No
TSKRS_BASE_MODEL	udd_model	varchar(20)	Yes	Base Model # of the Repair Task	No
TSKRS_EFF_CONTROL	udd_designparamcode	varchar(5)	Yes	Effectivity Control	No
TSKRS_MAINT_OBJ_TYP	udd_designparamcode	varchar(5)	Yes	Maintenance object type	No
TSKRS_MAINT_OBJECT	udd_partno	varchar(40)	Yes	Maintenance Object. It can Part / Aircraft.	No
TSKRS_OPERATORCODE	udd_vendorcode	varchar(45)	Yes	Operator code	No
TSKRS_WORKCENTER_NO	udd_wccode	varchar(30)	Yes	work center no	No
TSKRS_REPAGENCY_NO	udd_vendorcode	varchar(45)	Yes	Repai agency no	No
TSKRS_REPAIR_BASIS	udd_designparamcode	varchar(5)	Yes	Repair basis	No
TSKRS_REPAIR_CLASSIFY	udd_quickcodes	varchar(25)	Yes	Repair classsification	No
TSKRS_MNT_TYPE	udd_quickcodes	varchar(25)	Yes	Maintenance type	No
TSKRS_TAT_DAYS	udd_numericparamval	numeric(13)	Yes	TAT Days	No
TSKRS_REMARKS	udd_notes	varchar(2000)	Yes	Remarks	No
TSKRS_TIMESTAMP	udd_seqno	int(4)	Yes	Time stamp	No
TSKRS_CREATEDBY	udd_ctxt_user	varchar(30)	Yes	Created by	No
TSKRS_CREATED_DATE	_datetime_8	datetime(8)	Yes	Created date	No
TSKRS_MODIFIED_BY	udd_ctxt_user	varchar(30)	Yes	Modified by	No
TSKRS_MODIFIED_DATE	_datetime_8	datetime(8)	Yes	Modified date	No
tskrs_auto_gen	UDD_BIT	bit(1)	Yes	Auto generation flag	No
TSKRS_KEYNO	_udd_seqno_4	udd_seqno(4)	No	Key sequence number	Yes

Table Name :	BAS_TSK_TSKRT_RESOURCE_TYPE
Comment :	Resource Type For Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKRT_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKRT_TASK_NO	_varchar_30	varchar(30)	No	Task Number	Yes
TSKRT_REVISION_NO	_varchar_40	varchar(40)	No	Revision number of the task	Yes
TSKRT_RES_TYPE	_varchar_25	Varchar(25)	No	Resource type - can take values "Skill", "Equipment", "Tool" or "Others" S - Skills E - Equipments T - Tools O- Others	Yes
TSKRT_UPD_RES_ACT_FLAG	_varchar_25	Varchar(25)	Yes	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. Y - Yes N - No	No
TSKRT_CREATIONDATE	_datetime_8	datetime(8)	No	Creation Date	No
TSKRT_MODIFIEDDATE	_datetime_8	datetime(8)	No	Modified Date	No
TSKRT_CREATED_BY	_varchar_30	varchar(30)	No	Last Modified User	No
TSKRT_MODIFIED_BY	_varchar_30	varchar(30)	No	Modifiedby	No
TSKRT_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
Tskrt_uti	udd_text255	varchar(255)	Yes	Unique ID	No

Table Name :	BAS_TSK_TSKR_REF_DETAILS
Comment :	Task Reference details will be maintaining

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKR_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKR_TASK_NO	_varchar_30	varchar(30)	No	Task number	Yes
TSKR_SUBTASK_ROW_NO	_decimal_10_0	decimal(10)	No	Row no	Yes
TSKR_REVISION_NO	_varchar_40	varchar(40)	No	Revision number of the Task	Yes
TSKR_REF_DOC	_varchar_40	varchar(40)	No	Reference Document	Yes
TSKR_DOC_ID	_varchar_40	varchar(40)	No	Document Id	Yes
TSKR_REF_PATH	_varchar_50	varchar(50)	Yes	Reference Path	No
TSKR_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Base Model Number	Yes
TSKR_REF_DOC_REVNO	udd_revisionno	varchar(40)	Yes	Refernce Document Revision Number	No
TSKR_UTI	udd_text255	varchar(255)	Yes	Unique ID	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKTP_TASK_PRDICITY
Comment :	Periodicity Definition For Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKTP_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	No
TSKTP_TASK_NO	_varchar_30	varchar(30)	No	Task Number	No
TSKTP_REVISION_NO	_varchar_40	varchar(40)	No	Revision Number of the Task	No
TSKTP_SCH_TYPE	_varchar_25	Varchar(25)	No	Schedule Type of the Task. Can be either "Recurring" or "One Time" R - Recurring O - One Time	No
TSKTP_THRESHOLD_DAYS	_decimal_28_8	decimal(28)	Yes	Threshold limit in days	No
TSKTP_REPEAT_DAYS	_decimal_28_8	decimal(28)	Yes	Number of days after which the task has to be repeated	No
TSKTP_FREQENCY_NOTES	_varchar_2000	varchar(2000)	Yes	Notes on frequency of the task	No
TSKTP_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
TSKTP_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
TSKTP_CREATED_BY	_varchar_30	varchar(30)	Yes	first created user	No
TSKTP_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
TSKTP_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	No
TSKTP_TERMINATING_VAL_DAYS	_decimal_10_0	decimal(10)	Yes	Terminating value in days	No
TSKTP_PRD_REVNO	udd_revisionno	varchar(40)	Yes	periodicity revision number of the task	No
TSKTP_PRD_REVDATE	_datetime_8	datetime(8)	Yes	periodicity revision date of the task	No
TSKTP_PRD_STATUS	udd_flag	varchar(25)	Yes	periodicity status of the task	No
TSKTP_LMT_BASIS	udd_flag	varchar(25)	Yes	Limit Basis of the schedules which is loaded with (WE/WL) WE - Whichever is Earlier WL - Whichever is Later	No
TSKTP_FAIL_EFF	udd_desc40	varchar(40)	Yes	failure effect notes	No
TSKTP_FAILEFF_DES	udd_txt255	varchar(255)	Yes	failure effect notes description	No
TSKTP_ACS_NOTES	udd_notes	varchar(2000)	Yes	Access Notes	No
TSKTP_ACFT_NOTES	udd_notes	varchar(2000)	Yes	Aircraft notes	No
TSKTP_ENG_NOTES	udd_notes	varchar(2000)	Yes	Engine Notes	No
TSKTP_INT_NOTES	udd_notes	varchar(2000)	Yes	Interval Notes	No
TSKTP_UPD_TEMPL	udd_designparamcode	varchar(5)	Yes	Update Template.	No
TSKTP_UPD_PROGM	udd_designparamcode	varchar(5)	Yes	Update Program	No
TSKTP_UTI	udd_text255	varchar(255)	Yes	Unique ID	No
TSKTP_REMARKS	udd_txt2000	varchar(2000)	Yes	Remarks	No
TSKTP_TIMEUOM	udd_uomcode	varchar(10)	Yes	Null	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSKWZ_TSK_WRK_AREA
Comment :	Work Area Definition For Task

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKWZ_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKWZ_TASK_NO	_varchar_30	varchar(30)	No	Task Number	Yes
TSKWZ_REVISION_NO	_varchar_40	varchar(40)	No	Revision Number of the Task	Yes
TSKWZ_WZ_FLAG	_varchar_25	Varchar(25)	No	Flag indicating if the code defined is a "work area" or a "zone" W - Work Area Z - Zone	Yes
TSKWZ_CODE	_varchar_15	varchar(15)	No	Work Area or a Zone code	Yes
TSKWZ_MODEL_NO	_varchar_20	varchar(20)	No	Model no storing .due to touch point,It has been added.	Yes
TSKWZ_MODEL_OU	_decimal_38_0	decimal(38)	Yes	Model created ou in Aircraft Component.	No
TSKWZ_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
TSKWZ_UTI	udd_text255	varchar(255)	Yes	Unique ID	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	BAS_TSK_TSK_TASK_MASTER
Comment :	Task Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSK_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Organization Unit	No
TSK_TASK_NO	_varchar_30	varchar(30)	No	Task number	No
TSK_REVISION_NO	_varchar_40	varchar(40)	No	revision number of the task. User defined.	No
TSK_NON_ROUTINE_TASK_NO	_varchar_30	varchar(30)	Yes	Non Routine Task Name based on which the routine task is created	No
TSK_DSC_NO	_varchar_15	varchar(15)	Yes	Dependent System Number for the task	No
TSK_DESCRIPTION	_varchar_150	varchar(150)	Yes	Descritpion of the task	No
TSK_DESCRIPTION_UP	_varchar_150	varchar(150)	Yes	task description in upper case	No
TSK_STATUS	_varchar_15	varchar(15)	Yes	Status of the Task. Can be either "Fresh" or "Active" or "Inactive" F - Fresh A - Active I - Inactive C - Cancel R - Return	No
TSK_REVISION_DATE	_datetime_8	datetime(8)	Yes	Date of revision of the Task	No
TSK_REVISION_TYPE	_varchar_25	Varchar(25)	Yes	Type of revision of the Task. Can be either "Internal" or "External" I - Internal E - External	No
TSK_LATEST_REV_FLAG	_varchar_25	Varchar(25)	Yes	Latest Revision Flag	No
TSK_TYPE	_varchar_25	Varchar(25)	Yes	Type of the Task. These types are user defined and are defaulted from the Quick code master	No
TSK_CATEGORY	_varchar_25	Varchar(25)	Yes	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
TSK_TASK_APPLICABILITY	_varchar_25	Varchar(25)	Yes	Applicability of the Task. Can be either "Aircraft" or "Engine" or "Component" A - Aircraft E - Engine C - Component	No
TSK_RELATED_TASK_NO	_varchar_30	varchar(30)	Yes	Related task number for the main task	No
TSK_AMM_CMM_ITEM	_varchar_40	varchar(40)	Yes	Item mentioned in the Aircraft Maintenance Manual (AMM) & the Component Maintenance Manual (CMM	No
TSK_SRC_DOC	_varchar_40	varchar(40)	Yes	source document name EO - Engineering Order OTH - Others DP - Discrepency Processing HWO - Hanger Work Order TL - Technical Log CO - Component Work Order	No
TSK_OEM_NAME	_varchar_150	varchar(150)	Yes	OEM Name	No
TSK_ATA_NO	_varchar_16	varchar(16)	Yes	ATA chaptor number	No
TSK_ATA_OU	udd_ctxt_ouinstance	int(4)	Yes	ATA OU	No
TSK_EST_ELAPSED_TIME	_decimal_28_8	decimal(28)	Yes	Estimated duration of the Task in terms of minutes	No
TSK_EST_ELAPSED_TUOM	_varchar_10	varchar(10)	Yes	unit of measure for the estimated duration. Can be "minute", hour" or day" M - Minutes H - Hours D - Days	No
TSK_EST_MAN_HRS	_decimal_28_8	decimal(28)	Yes	Total Estimated resource hours for the Task	No
TSK_USER_DEFN1	_varchar_30	varchar(30)	Yes	user defined value one	No
TSK_USER_DEFN2	_varchar_30	varchar(30)	Yes	user defined value two	No
TSK_COMMENTS	_varchar_255	varchar(255)	Yes	comments during modification of the task	No
TSK_MODEL_COUNT	_decimal_10_0	decimal(10)	Yes	Number of Models where this task is applicable	No
TSK_UPD_PART_ACTUALS_FLAG	_varchar_25	Varchar(25)	Yes	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
TSK_LINK_FLAG	_varchar_25	Varchar(25)	Yes	Flag indicating whether Parts, Resources and Notes have been defined for the Task. P-R-N indicates all three have been defined	No
TSK_LAST_MODIFIED_TIME	_datetime_8	datetime(8)	Yes	Last Modified Time	No
TSK_CREATED_BY	_varchar_30	varchar(30)	Yes	User who has created the Task	No
TSK_MODIFIED_BY	_varchar_30	varchar(30)	Yes	User who has modified the task	No
TSK_APPROVED_BY	_varchar_30	varchar(30)	Yes	User who has approved the Task	No
TSK_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
TSK_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified on	No
TSK_APPROVEDDATE	_datetime_8	datetime(8)	Yes	Approved Date	No
TSK_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
TSK_EST_ELAPSED_TIME_DISP	_decimal_28_8	decimal(28)	Yes	Estimated duration of the Task	No
TSK_FILENAME	_varchar_50	varchar(50)	Yes	Task file name.	No
TSK_MANUFACTURERNO	_varchar_45	varchar(45)	Yes	Manufacturer no will be storing, which is referred from Basaircraft Component.	No
TSK_MANUFACTAC_OU	udd_ctxt_ouinstance	int(4)	Yes	Manufacturer no created ou will be storing If it is referred from Aircraft.	No
TSK_MANUFACTSUP_OU	udd_ctxt_ouinstance	int(4)	Yes	Manufacturer no created ou will be storing If it is referred from supplier.	No
TSK_AUTHCOMMENTS	_varchar_255	varchar(255)	Yes	While authorizing,user will give the comments.	No
TSK_LONG_DESCRIPTION	_varchar_2000	varchar(2000)	Yes	Long Description for Task	No
TSK_COMPONENT_COUNT	_decimal_38_0	decimal(38)	Yes	Component Count for Task	No
TSK_SRC_DOC_TYPE	_varchar_20	varchar(20)	Yes	Source document type	No
TSK_BASE_MODEL_NO	_varchar_20	varchar(20)	No	Base Model Number	No
TSK_WORK_LOCATION_REF_NO	_varchar_60	varchar(60)	Yes	Work Location - position reference number	No
TSK_CLASS	_varchar_25	Varchar(25)	Yes	This flag indicates if the task is a standard task or a non routine task STD - Standard NSTD - Non Standard	No
TSK_NO_OF_OCCUR	_varchar_25	Varchar(25)	Yes	Number of Occurences for Task	No
TSK_EXTERNAL_FLAG	_varchar_25	Varchar(25)	Yes	External Flag	No
TSK_BASE_MODEL_OU	udd_ctxt_ouinstance	int(4)	Yes	Base model ouinstance	No
TSK_WF_DOC_KEY	_varchar_128	varchar(128)	Yes	Work flow key	No
TSK_STAGE	_varchar_10	varchar(10)	Yes	TSK_STAGE	No
TSK_OPERATIONAL_TYPE	_varchar_25	Varchar(25)	Yes	Operational type	No
TSK_WCCODE	_varchar_30	varchar(30)	Yes	Work center code	No
TSK_WCCODE_OU	udd_ctxt_ouinstance	int(4)	Yes	Work Center Ou	No
TSK_SRC_DOC_OU	udd_ctxt_ouinstance	int(4)	Yes	Source Document OU	No
TSK_WRENCH_TIME	_numeric_28_8	numeric(28)	Yes	Wrench Time	No
TSK_IDEAL_TIME	_numeric_28_8	numeric(28)	Yes	Ideal Time	No
TSK_EXE_PHASE	udd_flag	varchar(25)	Yes	Execution Phase	No
TSK_MPD_ITEMNO	_varchar_40	varchar(40)	Yes	Item Number	No
TSK_WRENCHTIME_MIN	_numeric_28_8	numeric(28)	Yes	Wrench Time in Minutes	No
tsk_IDEALTIME_MIN	_numeric_28_8	numeric(28)	Yes	IdealTime	No
TSK_UTI	udd_text255	varchar(255)	Yes	Task Master Unique id	No
TSK_AMM	udd_text255	varchar(255)	Yes	AMM Document #	No
TSK_INS_MAN_HRS	udd_duration	numeric(13)	Yes	Inspected Man Hrs	No
TSK_SKILL_CODE	_varchar_250	varchar(250)	Yes	Skill Code	No
TSK_PREREV_FLAG	udd_designparamcode	varchar(5)	Yes	Previous Revision flag	No
tsk_effect_remarks	udd_text255	varchar(255)	Yes	task effect remarks	No
Tsk_Wbscode	udd_quickcodes	varchar(25)	Yes	Wbscode	No
tsk_msq_no	udd_documentno	varchar(40)	Yes	Manage Unified Sequence #	No
created_area_code	varchar	Char(10)	Yes	Null	No
TSK_CRTSOURCENO	udd_documentno	varchar(40)	Yes	TSK_CRTSOURCENO	No
TSK_CRTSOURCEREV	udd_revisionno	varchar(40)	Yes	TSK_CRTSOURCEREV	No
TSK_CRTSOURCETYP	udd_doctype	varchar(40)	Yes	TSK_CRTSOURCETYP	No
tsk_unique_id	_udd_unique_id_8	udd_unique_id(8)	No	Unique ID	Yes

Table Name :	BAS_TSK_WKA_WORK_AREA
Comment :	Work Area Master

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WKA_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
WKA_WORKAREACODE	_varchar_15	varchar(15)	No	Work Area Code	Yes
WKA_MODEL_NO	_varchar_20	varchar(20)	No	Model Number	Yes
WKA_DESCRIPTION	_varchar_150	varchar(150)	Yes	Description of the Work Area	No
WKA_DESCRIPTION_UP	_varchar_150	varchar(150)	Yes	Description in upper case	No
WKA_STATUS	_varchar_15	varchar(15)	Yes	Status of the Work Area.Can be either "Active" or "Inactive" A - Active I - Inactive	No
WKA_COMMENTS	_varchar_255	varchar(255)	Yes	Comments during Work Area modification	No
WKA_CREATED_BY	_varchar_30	varchar(30)	Yes	Created User	No
WKA_CREATIONDATE	_datetime_8	datetime(8)	Yes	Creation Date	No
WKA_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Modified Date	No
WKA_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified User	No
WKA_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
WKA_MODEL_OU	_decimal_10_0	decimal(10)	Yes	Model OU	No

Table Name :	TSK_PARAMETER_DETAILS
Comment :	Parameter details for BasTask component.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
COMPONENTNAME	_varchar_80	varchar(80)	No	Component Name	Yes
PARAMCATEGORY	_varchar_10	varchar(10)	No	Paramater category	Yes
PARAMTYPE	_varchar_25	Varchar(25)	No	Param type	Yes
PARAMCODE	_varchar_40	varchar(40)	No	Paramater Code which is used in all referring table	Yes
PARAMDESC	_varchar_80	varchar(80)	Yes	Paramater Description which is displaing in screen.	No
LANGID	_decimal_10_0	decimal(10)	Yes	Language Id	No
SORTBY	_int_0	int(0)	Yes	Order by	No

Table Name :	TSK_TSKLOG_STATUS_LOG
Comment :	Task Status history is maintaining

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKLOG_OUINSTANCE	_decimal_38_0	decimal(38)	No	Organization Unit	Yes
TSKLOG_TASK_NO	_varchar_30	varchar(30)	No	Task number	Yes
TSKLOG_BASE_MODEL_NO	_varchar_40	varchar(40)	No	Model Number	Yes
TSKLOG_REVISION_NO	_varchar_40	varchar(40)	No	revision number of the task. User defined.	Yes
TSKLOG_STATUS	_varchar_5	varchar(5)	No	Changed Status of task	Yes
TSKLOG_CHANGED_DATE	_datetime_8	datetime(8)	No	Modified date	Yes
TSKLOG_CHANGED_BY	_varchar_30	varchar(30)	Yes	Modified user	No
TSKLOG_COMMENTS	_varchar_255	varchar(255)	Yes	User Comments	No

Table Name :	tsk_tskmsq_seq_cntrl_hdr
Comment :	Manage Unified Task Sequence

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tskmsq_seq_cntrl_no	udd_documentno	varchar(40)	Yes	sequence contorl number	No
tskmsq_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Organization Unit	No
tskmsq_seq_cntrl_desc	udd_txt2000	varchar(2000)	Yes	sequence contorl description	No
tskmsq_status	udd_designparamcode	varchar(5)	Yes	status	No
tskmsq_timestamp	udd_seqno	int(4)	Yes	timestamp	No
tskmsq_created_date	_datetime_8	datetime(8)	Yes	Created date	No
tskmsq_created_by	udd_ctxt_user	varchar(30)	Yes	Creation user	No
tskmsq_modified_date	_datetime_8	datetime(8)	Yes	Modified Date	No
tskmsq_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
tskmsq_mseq_key	_udd_seqno_4	udd_seqno(4)	No	Key sequence number	Yes

Table Name :	TSK_TSKOPSET_OPTION_SETTING
Comment :	Option Setting table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKOPSET_OUINSTANCE	_decimal_10_0	decimal(10)	No	Organization Unit	Yes
TSKOPSET_GEN_NRT_FLAG	_varchar_5	varchar(5)	Yes	Non routine task generation flag	No
TSKOPSET_NRT_NUMTYPE_NO	_varchar_18	varchar(18)	Yes	Non Routine Task Numbering Type Number	No
TSKOPSET_CREATED_BY	_varchar_30	varchar(30)	Yes	Created By	No
TSKOPSET_CREATEDDATE	_datetime_8	datetime(8)	Yes	Created Date	No
TSKOPSET_MODIFIED_BY	_varchar_30	varchar(30)	Yes	Last Modified By	No
TSKOPSET_MODIFIEDDATE	_datetime_8	datetime(8)	Yes	Last Modified Date	No
TSKOPSET_TIMESTAMP	_decimal_10_0	decimal(10)	Yes	Timestamp	No
TSKOPSET_MUL_MODEL_EFF	_varchar_25	Varchar(25)	Yes	Model effectivity flag (A-allowed)	No
TSKOPSET_MP_MOD	udd_quickcodes	varchar(25)	Yes	TSKOPSET_MP_MOD	No
TSKOPSET_SEQ_GEN_MODE	udd_designparamcode	varchar(5)	Yes	Manage Unified Sequence generation mode	No
TSKOPSET_DEF_NUM_TYPE	udd_flag	varchar(25)	Yes	Default numbering type	No
TSKOPSET_MULTI_FACTOR	udd_count	int(4)	Yes	Multiplication factor	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	TSK_TSKOPSET_OPTION_SETTING_DTL
Comment :	To capture the option settings

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tskopset_EXc_Document	udd_ctxt_ouinstance	int(4)	Yes	Execution document detail	No
tskopset_Mechanic	udd_designparamcode	varchar(5)	Yes	Mechanic sign off value y- yes n- no	No
tskopset_Inspector	udd_designparamcode	varchar(5)	Yes	Inspector sign off value y- yes n- no	No
tskopset_both	udd_designparamcode	varchar(5)	Yes	Mechanic and Inspector sign off value y- yes n- no	No
tskopset_notrequired	udd_designparamcode	varchar(5)	Yes	Sign-off not required.	No
tskopset_default	udd_designparamcode	varchar(5)	Yes	default signoff values Mechanic Inspector Inspector and Mechanic Not Required	No
tskopset_skcdreq	udd_designparamcode	varchar(5)	Yes	tskopset_skcdreq	No
tskosq_unique_id	udd_designparamcode	varchar(5)	No	Task Seq Unique id	No
created_area_code	varchar	Char(10)	Yes	Null	No

Table Name :	tsk_tskosq_seq_cntrl_ops_seq
Comment :	To capture the task sequencing

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tskosq_mseq_key	udd_seqno	int(4)	No	sequence number	Yes
tskosq_rpr_key_no	udd_txt2000	varchar(2000)	No	Unique number of MSQ #	Yes
tskosq_ouinstance	udd_seqno	int(4)	Yes	Organization Unit	No
tskosq_rep_seqno	udd_ctxt_ouinstance	int(4)	Yes	repair Key sequence number	No
tskosq_org_seqno	udd_seqno	int(4)	Yes	originating sequence number	No
tskosq_ops_taskno	udd_seqno	int(4)	Yes	operational taskno	No
tskosq_root_taskno	udd_taskcode	varchar(30)	Yes	root taskno	No
tskosq_remarks	udd_taskcode	varchar(30)	Yes	remarks	No
tskosq_notesid	udd_txt255	varchar(255)	Yes	notesid	No
tskosq_seq_control_flag	udd_guid	varchar(40)	Yes	Seq. control flag	No
tskosq_seq_modify_flag	udd_designparamcode	varchar(5)	Yes	Seq. modification flag	No
tskosq_created_date	udd_designparamcode	varchar(5)	Yes	Created Date	No
tskosq_created_by	_datetime_8	datetime(8)	Yes	Created by	No
tskosq_modified_date	udd_ctxt_user	varchar(30)	Yes	Modified date	No
tskosq_modified_by	_datetime_8	datetime(8)	Yes	Modified by	No
tskosq_rpr_seqno	udd_ctxt_user	varchar(30)	Yes	Repair sequence no	No
tsk_tskprm_ou	udd_seqno	int(4)	Yes	task parameter Ouinstance	No
tskosq_operator	udd_vendorcode	varchar(45)	Yes	Operator code	No
tskosq_parent_taskno	udd_vendorcode	varchar(45)	Yes	Parent Task number	No
tskosq_instanceid	udd_seqno	int(4)	Yes	Ou instance	No
tskosq_unique_id	_udd_seqno_4	udd_seqno(4)	No	Unique ID	Yes

Table Name :	tsk_tskprm_cond_param_readings
Comment :	To store task Conditional parameter readings.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tsk_tskprm_taskno	udd_ctxt_ouinstance	int(4)	Yes	tasknumber	No
tsk_tskprm_st_seqno	udd_workunitcode	varchar(30)	Yes	sequence number	No
tsk_tskprm_model	udd_seqno	int(4)	Yes	model number	No
tsk_tskprm_revision	udd_model	varchar(20)	Yes	revision number	No
tsk_tskprm_prm_record	udd_revisionno	varchar(40)	Yes	Condition parameter flag	No
tsk_tskprm_parameter	udd_designparamcode	varchar(5)	Yes	parameter	No
tsk_tskprm_std_value	udd_parameter	varchar(40)	Yes	standard value	No
tsk_tskprm_min_value	udd_charparamval	varchar(32)	Yes	minimum parameter value	No
tsk_tskprm_max_value	udd_numericparamval	numeric(13)	Yes	maximum value of the parameter	No
tsk_followup_act	udd_numericparamval	numeric(13)	Yes	followup action	No
tsk_followup_inst	udd_status	varchar(25)	Yes	followup instruction	No
tsk_related_task	udd_txt150	varchar(150)	Yes	Related task	No
tsk_eval_remarks	udd_workunitcode	varchar(30)	Yes	evaluation remarks	No
tsk_permitvalues	udd_txt150	varchar(150)	Yes	permit values	No
tsk_rltdtsk_model	udd_txt2000	varchar(2000)	Yes	tsk_rltdtsk_model	No
tsk_seqnomlt	udd_model	varchar(20)	Yes	sequence number in the multiline	No
tsk_tskprm_UTI	udd_seqno	int(4)	Yes	Unique id	No
TSKPRM_OU	udd_text255	varchar(255)	Yes	OU instance	No

Table Name :	TSK_TSKPRM_PARAM_READINGS
Comment :	To store task parameter readings.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
TSKPRM_TASKNO	_numeric_4_0	numeric(4)	Yes	Task number	No
TSKPRM_ST_SEQNO	_varchar_30	varchar(30)	Yes	Sub Task Sequence number	No
TSKPRM_MODEL	_numeric_6_0	numeric(6)	Yes	Model	No
TSKPRM_REVISION	_varchar_20	varchar(20)	Yes	Revision	No
TSKPRM_PRM_RECORD	_varchar_40	varchar(40)	Yes	Parameter Record	No
TSKPRM_PARAMETER	_varchar_5	varchar(5)	Yes	Parameter	No
TSKPRM_PARAM_TYPE	_varchar_40	varchar(40)	Yes	Parameter Type	No
TSKPRM_PARAM_UOM	_varchar_25	Varchar(25)	Yes	Parameter Unit of measurement	No
TSKPRM_STANDARD	_varchar_10	varchar(10)	Yes	Parameter Standard	No
TSKPRM_PARAMDESC	_varchar_5	varchar(5)	Yes	Parameter description	No
TSKPRM_STD_VALUE	_varchar_150	varchar(150)	Yes	Standard value	No
TSKPRM_MIN_VALUE	_varchar_32	varchar(32)	Yes	Minimum Value	No
TSKPRM_MAX_VALUE	_numeric_28_8	numeric(28)	Yes	Maximum Value	No
tskprm_permitted_val	_numeric_28_8	numeric(28)	Yes	permitted value	No
tskprm_LineNo	udd_txt2000	varchar(2000)	Yes	LineNo	No
TSKPRM_UTI	udd_seqno	int(4)	Yes	PRM Unique id	No
tskpsq_unique_id	udd_text255	varchar(255)	Yes	Task Parameter Readings Unique id	No

Table Name :	tsk_tskpsq_seq_cntrl_part_list
Comment :	To capture the list of parts used in Sequencing.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tskpsq_mseq_key	udd_seqno	int(4)	No	sequence no	Yes
tskpsq_ouinstance	udd_seqno	int(4)	No	Organization Unit	Yes
tskpsq_partno	udd_ctxt_ouinstance	int(4)	Yes	partno	No
tskpsq_mfr_partno	udd_partno	varchar(40)	Yes	manufacturer partnumber	No
tskpsq_mfr_no	udd_partno	varchar(40)	Yes	manufacturer number	No
tskpsq_remarks	udd_vendorcode	varchar(45)	Yes	remarks	No
tskpsq_notesid	udd_txt255	varchar(255)	Yes	notesid	No
tskpsq_created_date	udd_guid	varchar(40)	Yes	created date	No
tskpsq_created_by	_datetime_8	datetime(8)	Yes	created by	No
tskpsq_modified_date	udd_ctxt_user	varchar(30)	Yes	modified date	No
tskpsq_modified_by	_datetime_8	datetime(8)	Yes	modified by	No
tsktsq_unique_id	udd_ctxt_user	varchar(30)	Yes	Unique ID for Part mapped to MSQ	No
tskpsq_unique_id	_udd_seqno_4	udd_seqno(4)	No	Unique ID	Yes

Table Name :	tsk_tsktsq_seq_cntrl_rep_scheme_list
Comment :	To capture the list of Repair Schemes used in Sequencing.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
tsktsq_mseq_key	udd_seqno	int(4)	No	sequence no	Yes
tsktsq_ouinstance	udd_seqno	int(4)	No	Organization Unit	Yes
tsktsq_task_code	udd_ctxt_ouinstance	int(4)	Yes	task code	No
tsktsq_remarks	udd_taskcode	varchar(30)	Yes	remarks	No
tsktsq_notesid	udd_txt255	varchar(255)	Yes	notesid	No
tsktsq_created_date	udd_guid	varchar(40)	Yes	created date	No
tsktsq_created_by	_datetime_8	datetime(8)	Yes	created by	No
tsktsq_modified_date	udd_ctxt_user	varchar(30)	Yes	modified date	No
tsktsq_modified_by	_datetime_8	datetime(8)	Yes	modified by	No
tsktsq_unique_id	_udd_seqno_4	udd_seqno(4)	No	Unique ID	Yes