Data Dictionary -- Aircraft Maintenance Planning

Srl. No.	Table Name	Comment
1	AMPLN_Parameter_Details	Parameter details table
2	AMPL_AMPLSetOpt_SetOPt	Set option details table
3	Ampl_comp_id	Component details for A/c Reg # change
4	ampl_levelcode	Level code details for A/c Reg # change
5	Ampl_Login_user_info	Log in information details
6	Ampl_wcload_res_avl_dtl	Available resources in a particular work center
7	ampl_wcload_res_Load_dtl	ampl_wcload_res_Load_dtl
8	AMPL_WSD_WC_SLOT_DTL	Work center slot details table
9	AMP_PCWU_PRECLUD_WUNIT_DET	Preclude task details

Table Name :	AMPLN_Parameter_Details
Comment :	Parameter details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AMPL_ComponentName	udd_compname	varchar(40)	Yes	Component Name	No
AMPL_ParamCategory	udd_category	varchar(15)	Yes	Parameter Category	No
AMPL_ParamType	udd_paramtype	varchar(25)	Yes	Parameter Type	No
AMPL_ParamCode	udd_paramcode	varchar(30)	Yes	Parameter Code	No
AMPL_ParamDesc	udd_desc40	varchar(40)	Yes	Parameter Description	No
AMPL_Langid	udd_languageid	int(4)	Yes	Language id	No
AMPL_SortBy	udd_sortby	numeric(9)	Yes	Sort by order	No
AMPL_CreationDate	_datetime_8	datetime(8)	Yes	Creation date	No

Table Name :	AMPL_AMPLSetOpt_SetOPt
Comment :	Set option details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
AMPL_SetOpt_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
AMPL_SetOpt_NumTypeTL	udd_flag2	varchar(25)	Yes	Numbering type Techlog	No
AMPL_SetOpt_NumTypeVP	udd_notypeno	varchar(5)	Yes	Numbering type visit package	No
AMPL_SetOpt_EnforceSFPGSecurity	udd_flag2	varchar(25)	Yes	Enforce Sub Fleet / Planner Group Security for Planning	No
AMPL_SetOpt_WCLoadingBasis	udd_captions1	varchar(15)	Yes	Work center loading basis	No
AMPL_SetOpt_TimeZoneAcPlan	udd_description	varchar(40)	Yes	Time Zone Aircraft plan	No
AMPL_SetOpt_Created_by	udd_ctxt_user	varchar(30)	Yes	Created by	No
AMPL_SetOpt_Created_Dt	_datetime_8	datetime(8)	Yes	Created date	No
AMPL_SetOpt_Modified_by	udd_ctxt_user	varchar(30)	Yes	Modified by	No
AMPL_SetOpt_Modified_Dt	_datetime_8	datetime(8)	Yes	Modified date	No
AMPL_SETOPT_NUMTYPEHWO	udd_notypeno	varchar(5)	Yes	Numbeing type hanger work order	No
AMPL_AMPLSETOPT_SHTERM	udd_seqno	int(4)	Yes	Short Term Horizon for Work center loading	No
AMPL_AMPLSETOPT_LNGTERM	udd_seqno	int(4)	Yes	Long Term Horizon for Work center loading	No
AMPL_AMPLSETOPT_REVWSHTERM	udd_paramcategory	varchar(10)	Yes	Review Unit for Short Term	No
AMPL_AMPLSETOPT_REVWLNGTERM	udd_paramcategory	varchar(10)	Yes	Review Unit for Long Term	No
AMPL_AMPLSETOPT_CMPTLOADBASD	udd_documentno	varchar(40)	Yes	Compute Load based on?	No
AMPL_SetOpt_DEF_HORIZON	udd_duration	numeric(13)	Yes	Set option def. Horizon	No

Table Name :	Ampl_comp_id
Comment :	Component details for A/c Reg # change

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ampl_wu_aircraft_reg_no_lvl	_varchar_30	varchar(30)	Yes	Aircraft registration number	No
Ampl_wu_level_code_lvl	_varchar_150	varchar(150)	Yes	Level code	No
Ampl_comp_id	_varchar_90	varchar(90)	Yes	Component ID	No
Ampl_guid	udd_guid	varchar(40)	Yes	Guid	No

Table Name :	ampl_levelcode
Comment :	Level code details for A/c Reg # change

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
ampl_wu_aircraft_reg_no_lvl	_varchar_30	varchar(30)	Yes	Aircraft registration number	No
ampl_wu_level_code_lvl	_varchar_150	varchar(150)	Yes	Level code	No
ampl_level_guid	udd_guid	varchar(40)	Yes	Guid	No

Table Name :	Ampl_Login_user_info
Comment :	Log in information details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Username	udd_ctxt_user	varchar(30)	Yes	User Name	No
Guid	udd_guid	varchar(40)	Yes	Guid	No
Inserted_time	_datetime_8	datetime(8)	Yes	Data inserted time	No
Latest_flag	udd_designparamcode	varchar(5)	Yes	Latest record?	No
arr_station	_varchar_32	varchar(32)	Yes	Arrival station	No

Table Name :	Ampl_wcload_res_avl_dtl
Comment :	Available resources in a particular work center

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Ampl_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ouinstance	No
Ampl_reviewunit	udd_flag	varchar(25)	No	Review uint	No
Ampl_fromdatetime	_datetime_8	datetime(8)	No	From date	No
Ampl_todatetime	_datetime_8	datetime(8)	No	To Date	No
Ampl_workcentreno	udd_documentno	varchar(40)	No	Work center code	No
Ampl_shiftno	udd_documentno	varchar(40)	Yes	Shift number	No
Ampl_slotno	udd_documentno	varchar(40)	Yes	Slot number	No
Ampl_resourcetype	udd_documentno	varchar(40)	Yes	Resource type	No
Ampl_skillcode	udd_documentno	varchar(40)	Yes	Skill code	No
Ampl_skillavialhrs	udd_quantity	numeric(13)	Yes	Skill available per hours	No
Ampl_planninghorizon	udd_designparamcode	varchar(5)	Yes	Planning horizon	No
Ampl_workingtype	udd_documentno	varchar(40)	Yes	Working type	No

Table Name :	ampl_wcload_res_Load_dtl
Comment :	ampl_wcload_res_Load_dtl

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
Ampl_wcload_Ouinstance	udd_ctxt_ouinstance	int(4)	Yes	Ou Instance	No
Ampl_wcload_fromdatetime	_datetime_8	datetime(8)	Yes	From date and time	No
Ampl_wcload_Todatetime	_datetime_8	datetime(8)	Yes	To date and time	No
Ampl_wcload_WorkCenter	udd_documentno	varchar(40)	Yes	Work center code	No
Ampl_wcload_Shiftno	udd_documentno	varchar(40)	Yes	Shift number	No
Ampl_wcload_Slotno	udd_documentno	varchar(40)	Yes	Slot number	No
Ampl_wcload_Restype	udd_designparamcode	varchar(5)	Yes	Resource type	No
Ampl_wcload_Skillno	udd_documentno	varchar(40)	Yes	Skill code	No
Ampl_wcload_Aircraftou	udd_ctxt_ouinstance	int(4)	Yes	Ou Instance of A/c Reg #	No
Ampl_wcload_Aircraftregno	udd_aircraftnumber	varchar(30)	Yes	Aircraft registration number	No
Ampl_wcload_Componentou	udd_ctxt_ouinstance	int(4)	Yes	Component Ouinstance	No
Ampl_wcload_Component_id	udd_documentno	varchar(40)	Yes	Component id	No
Ampl_wcload_forecastno	udd_documentno	varchar(40)	Yes	Forecast number	No
Ampl_wcload_Packageno	udd_documentno	varchar(40)	Yes	Package number	No
Ampl_wcload_Taskno	udd_documentno	varchar(40)	Yes	Task Number	No
Ampl_wcload_Taskrevno	udd_flag	varchar(25)	Yes	Task revision number	No
Ampl_wcload_Taskseqno	udd_seqno	int(4)	Yes	Task Seq number	No
Ampl_wcload_Jobid	udd_seqno	int(4)	Yes	Job id	No
Ampl_wcload_Instanceid	udd_seqno	int(4)	Yes	Ampl_wcload_Instanceid	No
Ampl_wcload_AvailHrs	udd_duration	numeric(13)	Yes	Available hours	No
Ampl_wcload_Loadhrs	udd_duration	numeric(13)	Yes	Load hours	No
Ampl_wcload_Task_Status	udd_designparamcode	varchar(5)	Yes	Task status	No
Ampl_wcload_Plan_Flag	udd_designparamcode	varchar(5)	Yes	Plan flag	No
Ampl_wcload_Planhorizon	udd_designparamcode	varchar(5)	Yes	Planning horizon	No
Ampl_wcload_reviewunit	udd_designparamcode	varchar(5)	Yes	Review uint flag	No
Ampl_wcload_Resconstrnt_flag	udd_designparamcode	varchar(5)	Yes	Resconstrant flag	No
Ampl_wcload_loadbasd_Flag	udd_designparamcode	varchar(5)	Yes	load based flag	No

Table Name :	AMPL_WSD_WC_SLOT_DTL
Comment :	Work center slot details table

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
WSD_LINENO	udd_lineno	int(4)	Yes	Line number	No
WSD_WC_OUINSTANCE	udd_ctxt_ouinstance	int(4)	No	Ouinstance	Yes
WSD_WCCODE	udd_wccode	varchar(30)	No	Work center code	Yes
WSD_SLT_NO	udd_documentno	varchar(40)	No	Slot number	Yes
WSD_SLT_STD	_varchar_10	varchar(10)	Yes	Slot standard	No
WSD_SLT_EXTN	_varchar_10	varchar(10)	Yes	Slot Extention	No
WSD_SLT_FRM_DTTIME	_datetime_8	datetime(8)	No	From date	Yes
WSD_SLT_TO_DTTIME	_datetime_8	datetime(8)	Yes	To date	No
WSD_PLN_AC_REG_NO	udd_aircraftnumber	varchar(30)	Yes	Aircraft registration number	No
WSD_PLN_FLT_NO	udd_fltno	varchar(30)	Yes	Flight code	No
WSD_PLN_TASK	udd_workunitcode	varchar(30)	Yes	Task code	No
WSD_PLN_COMMENT	udd_txt2000	varchar(2000)	Yes	Comments	No
WSD_PLN_CONS_COMMENT	udd_txt2000	varchar(2000)	Yes	Consumption comments	No
WSD_SLT_SHORT_DESC	udd_txt2000	varchar(2000)	Yes	Description	No
WSD_SLT_DUR	udd_duration	numeric(13)	Yes	Slot Duration	No

Table Name :	AMP_PCWU_PRECLUD_WUNIT_DET
Comment :	Preclude task details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
PCWU_OUINSTANCE	_decimal_10_0	decimal(10)	Yes	Ouinstance	No
PCWU_PROGRAM_NO	_varchar_40	varchar(40)	Yes	Program number	No
PCWU_REVISION_NO	_varchar_40	varchar(40)	Yes	Revision number	No
PCWU_SUP_WORKUNIT_OU	_decimal_10_0	decimal(10)	Yes	Ou instance	No
PCWU_SUP_WORKUNIT_NO	_varchar_30	varchar(30)	Yes	Work unit number	No
PCWU_SUP_WORKUNIT_REV_NO	_varchar_40	varchar(40)	Yes	Work unit revision number	No
PCWU_SUP_WORKUNIT_TYPE	_varchar_5	varchar(5)	Yes	Work unit type	No
PCWU_SUP_WORKUNIT_SEQ_NO	_decimal_6_0	decimal(6)	Yes	work unit seq number	No
PCWU_PRCL_WORKUNIT_OU	_decimal_10_0	decimal(10)	Yes	Ou-instance	No
PCWU_PRCL_WORKUNIT_NO	_varchar_30	varchar(30)	Yes	work unitnumber	No
PCWU_PRCL_WORKUNIT_REV_NO	_varchar_40	varchar(40)	Yes	Workunit revision number	No
PCWU_PRCL_WORKUNIT_TYPE	_varchar_5	varchar(5)	Yes	Workunit type	No
PCWU_PRCL_WORKUNIT_SEQ_NO	_decimal_6_0	decimal(6)	Yes	workunit seq number	No