Line Planning and Control

Line Planning and Control

Table Name LPC_LpcPrm_Parameter_Dtl

Table Comment Stores Parameter detail information. In this component, this table needs to store only search criteria message Note : This table stores the short form and long description of the static values used in various screens of the Line planning and control component. For e.g. Flight Type values are arrival and departure and short form of these values are ’A’ and ’D’ respectively. For Flight Status values ’On Schedule’, ’Cancelled’ and ’Delayed’ the short forms are ’ONS’,’CAN’ and ’DLY’ respectively.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LpcPrm_ComponentName	varchar(80)	NOT NULL	Component Name for which the parameter details are applicable. Here it will be BasLPC.	Yes	No
LpcPrm_ParamCategory	varchar(10)	NOT NULL	This field will capture the category of the static value. The static values could be to fill up combo, text field, guidance text, combo default etc	Yes	No
LpcPrm_ParamType	varchar(25)	NOT NULL	Normally param type is the name of the control. This will allow us to store all the possible values for a combo in multiple rows.	Yes	No
LpcPrm_ParamCode	varchar(5)	NOT NULL	Param code is the values to be filled in the combo box or guidance text. This is actually the meta data of this component	Yes	No
LpcPrm_Langid	decimal(9)	NOT NULL	Language id. This is the language id of the record. This enables the multiple language display.	Yes	No
LpcPrm_ParamDesc	varchar(80)	NULL	Description of the Param Code	No	No
LpcPrm_SortBy	decimal(9)	NULL	The order in which the values are populated.	No	No
LpcPrm_Createddate	datetime	NULL	Date of Creation of the record.	No	No

Table Name LPC_LpcRdp_Rec_Discrep_Dtl

Table Comment Stores Parameter detail information. In this component, this table needs to store only search criteria message Note : This table stores the short form and long description of the static values used in various screens of the Line planning and control component. For e.g Flight Type values are arrival and departure and short form of these values are ’A’ and ’D’ respectively. For Flight Status values ’On Schedule’, ’Cancelled’ and ’Delayed’ the short forms are ’ONS’,’CAN’ and ’DLY’ respectively.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LpcRdp_Track_Status	varchar(25)	NOT NULL	Tracking status of the discrepancy whether it is tracked or not tracked.	No	No
LpcRdp_Fault_No	varchar(25)	NOT NULL	The number identifying the fault mentioned in the discrepancy description.	No	No
LpcRdp_ATA_No	varchar(16)	NOT NULL	ATA number relevant to the discrepancy description.	No	No
LpcRdp_Discrep_Desc	varchar(80)	NOT NULL	Description of the discrepancy being recorded.	No	No
LpcRdp_Discrep_No	varchar(40)	NOT NULL	Number identifying the discrepancy being recorded.	No	No
LpcRdp_Line_Pack_No	varchar(40)	NOT NULL	Line pack number to which the discrepancy is assigned.	No	No
LpcRdp_Created_Ouinstance	int	NOT NULL	The organisational unit where the discrepancy is being recorded.	No	No
LpcRdp_Discrep_Category	varchar(25)	NULL	Category of discrepancy like pilot reported or mechanic reported.	No	No
LpcRdp_Action	varchar(15)	NULL	The action taken on the discrepancy like pending or no fault found or cancelled or closed.	No	No
LpcRdp_Reported_By	varchar(20)	NULL	The login user who records the discrepancy.	No	No
LpcRdp_Reported_date	datetime	NULL	Discrepancy recorded date.	No	No
LpcRdp_Record_Status	varchar(15)	NULL	The status of the recording of the discrepancy.	No	No
LpcRdp_Discrep_Type	varchar(25)	NULL		No	No

Table Name LPC_LpcRp_Ac_Rout_plan

Table Comment This table is used to store the Line package details and the Update Routing plan details . The update routing plan details are stored here as some of the fields like the workgroup , flight status, journey log , technical log etc., which are dual for a Fltcode on a date ,will require two columns each ,one for arrival and one for departure if stored in Aircraft Routing.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LpcRp_Created_Ouinstance	int	NOT NULL	The organisational unit where the Routing Plan is created.	Yes	No
LpcRp_Flight_No	varchar(30)	NOT NULL	Flight number of the routing plan being updated.	Yes	No
LpcRp_Leg_No	int	NOT NULL	Leg number of the flight number for which the routing plan is being updated.	Yes	No
LpcRp_Utc_Flight_Date	datetime	NOT NULL	Flight Date of the aircraft.	Yes	No
LpcRp_Current_Station	varchar(32)	NOT NULL	Current station where the aircraft is there	Yes	No
LpcRp_Ac_Reg_No	int	NOT NULL	Registration number of aircraft involved.	Yes	No
LpcRp_Ac_Reg_ou	32	NOT NULL	The organisational unit of aircraft.	No	No
LpcRp_From_To_Station_Ou	int	NULL	the organisational unit of the FROM or TO station of the aircraft route with which reference the routing plan is being updated with changes.	No	No
LpcRp_From_To_Station	varchar(32)	NULL	The FROM or TO station of the aircraft route with which reference the routing plan is being updated with changes.	No	No
LpcRp_Flight_Type	varchar(25)	NULL	The type of the flight whether arrival or departure.	No	No
LpcRp_LP_Comments	varchar(2000)	NULL	Any comments regarding routing plan update.	No	No
LpcRp_Flight_Status	varchar(25)	NULL	Status of the flight whether on schedule or delayed or cancelled.	No	No
LpcRp_Line_Pack_No	varchar(40)	NULL	Line package number of the maintenance.	No	No
LpcRp_Journey_Log	varchar(40)	NULL	Journey log of the flight for which the routing plan is being updated.	No	No
LpcRp_Techlog_No	varchar(40)	NULL	Techlog number of the line package.	No	No
LpcRp_Route_Comments	varchar(255)	NULL	The organisational unit of the techlog.	No	No
LpcRp_WorkGroup_No	varchar(25)	NULL	Work group number which is associated with the maintenance.	No	No
LpcRp_Workcenter_no	varchar(25)	NULL	Work center identifying number where the maintenance is going to take place.	No	No
LpcRp_Wgrp_Hrs_Per_Day	numeric(13)	NULL	Hours per day the workgroup is assigned.	No	No
LpcRp_Wgrp_UTC_From_Date	datetime	NULL	The start date of the work group associated to the gate.	No	No
LpcRp_Wgrp_UTC_From_Time	datetime	NULL	The start time of the work group associated to the gate.	No	No
LpcRp_Wgrp_UTC_To_Date	datetime	NULL	The end date of the work group associated to the gate.	No	No
LpcRp_Wgrp_UTC_To_Time	datetime	NULL	The end time of the work group associated to the gate.	No	No
LpcRp_WGrp_Comments	varchar(255)	NULL	Comments regarding routing plan update.	No	No
LpcRp_Lpc_timestamp	int	NULL	Time stamp is used for internal purpose to prevent concurrent modification of the record and to maintain data inconsistency and integrity.	No	No
LpcRp_Created_By	varchar(30)	NULL	The user who updated the routing plan.	No	No
LpcRp_Created_Datetime	datetime	NULL	The date of update of the routing plan.	No	No
LpcRp_Modified_By	varchar(30)	NULL	The user who recently modified the update of the routing plan.	No	No
LpcRp_Modified_Datetime	datetime	NULL	The date of recent modification of update of the routing plan.	No	No

Table Name LPC_LpcWG_WorkGrp_Gate_Dtl

Table Comment This tables stores information on assigning a work group consisting of multiple employees to different gates, to perform certain line maintenance activities. Long-term work group assignments can be created.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LpcWG_Created_Ouinstance	int	NOT NULL	The organisational unit in which the work group was created.	Yes	No
LpcWG_Station	varchar(32)	NOT NULL	Station of the gate.	Yes	No
LPcWG_Gate_WrkG_line_no	char(18)	NOT NULL	The sequential line number in which order the work group is associated to a particular gate.	Yes	No
LpcWG_Terminal	varchar(32)	NOT NULL	Terminal of the Gate.	No	No
LpcWG_Gate_No	varchar(40)	NOT NULL	Gate identifying number.	No	No
LpcWG_WorkGroup_No	varchar(20)	NOT NULL	Work group identifying number.	No	No
LpcWG_UTC_From_Time	datetime	NOT NULL	The start time of the work group associated to the gate.	No	No
LpcWG_UTC_From_Date	datetime	NOT NULL	The start date of the work group associated to the gate.	No	No
LpcWG_Station_Ou	int	NULL	Organization unit of the station to which the gate belongs to.	No	No
LpcWG_UTC_To_Date	datetime	NULL	The end date of the work group associated to the gate.	No	No
LpcWG_UTC_To_Time	datetime	NULL	The end time of the work group associated to the gate.	No	No
LpcWG_Hrs_Per_Day	numeric(13)	NULL	The hours per day the work group is attached to the gate.	No	No
LpcWG_Comments	varchar(255)	NULL	Comments if any for the assignment of the workgroup to the gate.	No	No
LPcWG_Timestamp	int	NULL	Time stamp is used for internal purpose to prevent concurrent modification of the record and to maintain data inconsistency and integrity.	No	No
LpcWG_Created_By	varchar(30)	NULL	User who created the assignment.	No	No
LpcWG_Modified_By	varchar(30)	NULL	User who recently modified the assignment.	No	No
LpcWG_Created_Datetime	datetime	NULL	Date and time of assignment of the work group to the gate.	No	No
LpcWG_Modified_Datetime	datetime	NULL	Recently modified date and time of assignment of the work group to the gate.	No	No

Table Name LPC_LpcWu_Work_unit_Dtl

Table Comment This table stores information on line packages and associated workunits.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LpcWu_Created_Ouinstance	int	NOT NULL	The Organisational Unit from which the line packages is created.	Yes	No
LpcWu_Line_Pack_No	varchar(40)	NOT NULL	Unique identification code for the line package.	Yes	No
LpcWu_WU_Line_no	int	NOT NULL	The sequential line number of workunits as they appear in the multiline control.	Yes	No
LpcWu_Wu_Disp_Line_no	int	NOT NULL	In case of discrepancies, the line number of discrepancies as they appear on the multiline control.	No	No
LpcWu_Work_center	varchar(25)	NULL	The code of work center where the maintenance is planned.	No	No
LpcWu_Workgroup_No	varchar(25)	NULL	Workgroup # which is associated with work units.	No	No
LpcWu_Wgrp_Hrs_Per_Day	numeric(13)	NULL	Workgroup’s hours per day.	No	No
LpcWu_Wgrp_UTC_From_Date	datetime	NULL	Workgroup start date.	No	No
LpcWu_Wgrp_UTC_From_Time	datetime	NULL	Workgroup start time.	No	No
LpcWu_Wgrp_UTC_To_Date	datetime	NULL	Work group to date.	No	No
LpcWu_Wgrp_UTC_To_Time	datetime	NULL	Work group to time.	No	No
LpcWu_WGrp_Comments	varchar(255)	NULL	Comments regarding work group.	No	No
LpcWu_Work_unit	varchar(30)	NULL	Work unit code associated to Line Package.	No	No
LpcWu_Work_Unit_Type	varchar(25)	NULL	Type of work unit i.e. task or standard procedures etc.	No	No
LpcWu_Work_unit_OU	int	NULL	The organisational unit the work unit belongs.	No	No
LpcWu_Task_Revno	varchar(40)	NULL	Work unit’s revision number.	No	No
LpcWu_Job_Type	varchar(35)	NULL	Job type like aircraft or component removal or on wing job.	No	No
LpcWu_Maint_Type	varchar(25)	NULL	Type of maintenance like Inspection or Over hauling or others etc.	No	No
LpcWu_Est_Elapsed_time	numeric(13)	NULL	Estimation of time that will elapse.	No	No
LpcWu_Time_Unit	varchar(10)	NULL	Time unit for elapsed time like hours or day etc.	No	No
LpcWu_Part_no	varchar(40)	NULL	Part # if any which will be required for that particular work unit.	No	No
LpcWu_Serial_no	varchar(40)	NULL	Serial # of the part if any which will be required for that particular work unit.	No	No
LpcWu_Component_id	varchar(90)	NULL	The component # for the part # and serial # combination.	No	No
LpcWu_Component_Ou	int	NULL	The organisational unit to which the component belong to.	No	No
LpcWu_Planning_Comments	varchar(255)	NULL	any comments on planning.	No	No
LpcWu_Src_Doc_type	varchar(25)	NULL	Source document type of the work unit through which the work unit come here. The values like aircraft forecasting etc.	No	No
LpcWu_Src_Doc_no	varchar(40)	NULL	Source document # of the work unit through which the work unit come here.	No	No
LpcWu_Src_doc_ou	int	NULL	Organization unit of the source document # of the work unit through which the work unit come here. The values like aircraft forecasting etc.	No	No
LpcWu_Src_doc_Rev_no	varchar(40)	NULL	Revision # of the source document	No	No
LpcWu_Wu_seq_no	int	NULL	Sequence number of the work units in the order of execution.	No	No
LpcWu_DP_MR_no	varchar(40)	NULL	In case of discrepancies, Maintenance Report number of the discrepancy.	No	No
LpcWu_Dp_MR_OU	int	NULL	In case of discrepancies, Organisational Unit of the Maintenance Report of the discrepancy.	No	No
LpcWu_DP_Doc_Type	char(18)	NULL	It is used to store the type of the DP document can take values DP - Discrepancy MR - Maintenance Report	No	No
LpcWu_Created_Datetime	datetime	NULL	Line Package record created date and time.	No	No
LpcWu_Modified_Datetime		NULL	Line Package record recently modified date and time.	No	No
LpcWu_Created_By	varchar(30)	NULL	The record created user.	No	No
LpcWu_Modified_By	varchar(30)	NULL	Record recently modified user.	No	No
LpcWu_WrkGrp_timestamp	int	NULL	Time stamp is used for internal purpose to prevent concurrent modification of the record and to maintain data inconsistency and integrity.	No	No
LpcWu_Schedule_date	datetime	NULL	The scheduled date of maintenance with reference to the line package.	No	No
LpcWu_Alert_date	datetime	NULL	The date on which the user is alerted that the maintenance with reference to the line package is due on the scheduled date.	No	No

Table Name LPC_LpcWuEmp_Wunit_Emp_Dtl
Table Comment This table stores information about assigning of work group, or selected employees to execute at linepackage level or at work unit level.
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
LpcWuEmp_Created_Ouinstance	int	NOT NULL	The Organisational unit where the employee record created.	Yes	Yes
LpcWuEmp_Line_Pack_No	varchar(40)	NOT NULL	The number identifying the line pack to which the employee is being associated.	Yes	Yes
LpcWuEmp_WU_Line_no	int	NOT NULL	The sequential line number of workunit in the line package.	Yes	Yes
LpcWuEmp_Emp_Line_no	int	NOT NULL	The employee’s sequential line number among the employees assigned to a particular work unit or line package.	Yes	No
LpcWuEmp_Employee_No	varchar(20)	NOT NULL	The number identifying the employee number.	No	No
LpcWuEmp_UTC_From_Date	datetime	NULL	The start date from which the employee is assigned to the work unit or line package.	No	No
LpcWuEmp_UTC_From_Time	datetime	NULL	The start time from which the employee is assigned to the work unit or line package.	No	No
LpcWuEmp_UTC_To_Date	datetime	NULL	The end date upto which the employee is assigned to the work unit or line package.	No	No
LpcWuEmp_UTC_To_Time	datetime	NULL	The end time upto which the employee is assigned to the work unit or line package.	No	No
LpcWuEmp_Hrs_Per_Day	numeric(13)	NULL	The hours per day the employee is assigned to the work unit or line package.	No	No
LpcWuEmp_Asgn_comments	varchar(255)	NULL	Any comments related to the assignment of employee to the work unit or line package.	No	No