Data Dictionary - Flight Log

Table Name BAS_FLOG_JLOG_REPSTN_DTL

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

FLOG_DTL_OUINSTANCE

int

NULL

Ouinstance

No

No

FLOG_DTL_PARAMETER_CODE

varchar(5)

NULL

Storing Parameter Codes for Corresponding Parameters in Set Options.

No

No

FLOG_DTL_VALUES

varchar(5)

NULL

Column For storing Permitted values for Corresponding Parameter in set Options

No

No

FLOG_DTL_LATEST_FLAG

varchar(5)

NULL

Column For maintaining Latest flag for the corresponding parameter in set options

No

No

FLOG_DTL_CREATEDBY

varchar(30)

NULL

Created By For Parameter of the Set Options

No

No

FLOG_DTL_CREATEDDATETIME

datetime

NULL

Created Date and time For Parameter of the Set Options

No

No

FLOG_DTL_MODIFIEDBY

varchar(30)

NULL

Storing Modified username of Set options

No

No

FLOAG_DTL_MODIFIEDDATETIME

datetime

NULL

Modified Date and time for Modified set Options

No

No

Table Name Bas_Flog_jlog_Repstn_Param_lst

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

FLOG_CTAEGORY

varchar(150)

NULL

Column For Storing Metadata values Like "Flight Day Computation Basis"

No

No

FLOG_PARAMETER_CODE

varchar(5)

NULL

Column for Storing Code for Corresponding Parameter of Metadata. (Eg:OS)

No

No

FLOG_PARAMETER_DESC

varchar(150)

NULL

Column displaying Parameter Desc Values. (Eg:Date for Flight Day Update)

No

No

FLOG_PERMITTED_VALUES

varchar(255)

NULL

Column display the Permitted values of Corresponding parameter

No

No

FLOG_LANGUAGEID

int

NULL

Language id

No

No

FLOG_SORTBY

int

NULL

Column for Sorting Parameter needs to displayed.

No

No

Table Name BASFLTLOG_PARAMETER_DETAILS

Table Comment Stores Parameter detail information. In this component, this table needs to store only search criteria message

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

ComponentName

varchar(20)

NOT NULL

Component Name

No

No

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.

No

No

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.

No

No

ParamCode

varchar(5)

NOT NULL

Param code is the value to be filled in the combo box or guidance text. This is actually the meta data of this component

No

No

Langid

decimal(10)

NOT NULL

Language id. This is the language id of the record.

No

No

ParamDesc

varchar(80)

NULL

Description of the combo value

No

No

SortBy

decimal(10)

NULL

The Order of creation of Parameter details

No

No

CreatedDate

datetime

NULL

Created date of the record.

Table Name FL_TLIssRet_Issue_Dtl

Table Comment This table contains the Issued Return Part Information associated with the Techlog no

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

TLIssRet_IssuePart

varchar(40)

NOT NULL

Issue Part Number

Yes

No

TLIssRet_Lot

varchar(18)

NOT NULL

Lot Number

Yes

No

TLIssRet_Serial

varchar(40)

NOT NULL

Serial Number

Yes

No

TLIssRet_SlfSrc_OuInstance

decimal(10)

NOT NULL

Tech Log OUInstance

Yes

Yes

TLIssRet_TechLog_No

varchar(40)

NOT NULL

Tech Log number System generated unique number to identify a Technical Log for a journey.

Yes

Yes

TLIssRet_Key_Seq_No

decimal(10)

NOT NULL

Key Sequence Number

Yes

Yes

TLIssRet_Return_Basis

varchar(10)

NULL

Return Basis EX- Exchange

No

No

TLIssRet_Return_Part

varchar(40)

NULL

Return Part Number

No

No

TLIssRet_Return_Lot

varchar(18)

NULL

Return Lot Number

No

No

TLIssRet_Return_Seria

varchar(40)

NULL

Return Serial Number

No

No

TLIssRet_Return_Quantity

decimal(28,8)

NULL

Return Quantity

No

No

TLIssRet_Return_UOM

varchar(10)

NULL

Return UOM

No

No

TLIssRet_Stock_Status

varchar(15)

NULL

Stock Status ’Accepted’

No

No

TLIssRet_Condition_Returned

varchar(15)

NULL

Condition Returned

No

No

TLIssRet_Expiry_Date

datetime

NULL

Expiry Date

No

No

TLIssRet_Part_Type

varchar(25)

NULL

Part Type ’Component’ ’Consumable’

No

No

TLIssRet_Part_Control_Type

varchar(25)

NULL

Part Control Type ’Lot’ ’Serial’ ’Lot and Serial’

No

No

TLIssRet_Expense_Type

varchar(25)

NULL

The type of expense incurred

No

No

TLIssRet_Value

decimal(28,8)

NULL

Return Value

No

No

TLIssRet_Issued_Quantity

decimal(28,8)

NULL

Issued Quantity

No

No

TLIssRet_Issued_UOM

varchar(10)

NULL

Issued UOM

No

No

TLIssRet_Issue_Warehouse

varchar(10)

NULL

Issue Ware House

No

No

TLIssRet_Account_Usage

varchar(20)

NULL

Account Usage

No

No

TLIssRet_Costing_Usage

varchar(20)

NULL

Costing Usage

No

No

TLIssRet_Line_No

decimal(10)

NULL

Line Number

No

No

TLIssRet_Task_No

varchar(40)

NULL

Task Number

No

No

TLIssRet_Material_Type

varchar(5)

NULL

Material Type ’Main Core’ ’Regular’

No

No

TLIssRet_Issue_No

varchar(40)

NULL

Issue Number

No

No

TLISSRET_CORE_RET_QTY

numeric(28,8)

NULL

Core Return Quantity

No

No

TLISSRET_RECON_QTY

numeric(28,8)

NULL

Reconcile Quantity

No

No

TLISSRET_RET_SYSLNNO

int

NULL

Return line number

No

No

TLISSRET_SRLOT_SEQNO

int

NULL

Issue Serial sequence Number

No

No

TLISSRET_ISSUE_COST

bigint

NULL

Issue Cost

No

No

TLISSRET_ISUID_PRTSYSLNNO

int

NULL

Issue part line number

No

No

TLISSRET_PEND_RET_QTY_CORE

numeric(28,8)

NULL

Pending Return Core Quantity

No

No

TLISSRET_RET_COST

bigint

NULL

Return Cost

No

No

TLISSRET_RET_NO

varchar(18)

NULL

Return document Number

No

No

TLISSRET_TIME_STAMP

int

NULL

Timestamp value

No

No

TLISSRET_ISS_BASIS

varchar(5)

NULL

Issue Basis

No

No

TLISSRET_USED_QTY

numeric(28,8)

NULL

Used Quantity

No

No

TLISSRET_PEND_RET_QTY

numeric(28,8)

NULL

Pending Return quantity

No

No

TLISSRET_RECQTY_EXCESS

numeric(28,8)

NULL

Reconcile Excess Quantity

No

No

TLISSRET_RECREMARKS

varchar(2000)

NULL

Reconcile Remarks

No

No

Table Name Flog_DfDpRsl_Def_Disc_Resol

Table Comment This table contains the Deferred MR Information associated with the Techlog no

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

DfDpRsl_Maint_Report_No

varchar(40)

NOT NULL

Maintenance Report Number

Yes

No

DfDpRsl_Resol_Action

varchar(5)

NULL

Action taken against the Maintenance Report. For e.g: Closed, No Fault Found, Cancel, etc

No

No

DfDpRsL_Task_no

varchar(30)

NULL

Task Number

No

No

DfDpRsl_TechLog_No

varchar(40)

NOT NULL

Tech Log number System generated unique number to identify a Technical Log for a journey.

Yes

Yes

DfDpRsl_Maint_Report_Ou

decimal(10)

NOT NULL

Maint. Report Created OU

Yes

No

DfDpRsl_SlfSrc_OuInstance

decimal(10)

NOT NULL

Tech Log OUInstance

Yes

Yes

Table Name Flog_FLAcDt_Aircraft_Lvl_Dtl

Table Comment Aircraft Level Flight Log information are maintained in this table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

FLAcDt_Aircraft_OUInstance

decimal(10)

NOT NULL

Aircraft OUIstance

No

No

FLAcDt_Aircraft_Reg_No

varchar(30)

NOT NULL

Aircraft Registration Number

No

No

FLAcDt_Last_JrnLog_No

varchar(40)

NULL

Last Journey Log number

No

No

FLAcDt_JL_Last_Reported_DtTme

datetime

NULL

Journey Log Last Reported DateTime

No

No

FLAcDt_Last_TechLog_No

varchar(40)

NULL

LastTech Log Number

No

No

FLAcDt_TL_Last_Reported_DtTme

datetime

NULL

Record Last Reported Time

No

No

Table Name Flog_FLAcDt_Aircraft_Lvl_Dtl

Table Comment Aircraft Level Flight Log information are maintained in this table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

%AttName

decimal(10)

NOT NULL

%AttDef

No

No

FLAcDt_Aircraft_Reg_No

varchar(30)

NOT NULL

Aircraft Registration Number

No

No

FLAcDt_Last_JrnLog_No

varchar(40)

NULL

Last Journey Log number

No

No

FLAcDt_JL_Last_Reported_DtTme

datetime

NULL

Journey Log Last Reported DateTime

No

No

FLAcDt_Last_TechLog_No

varchar(40)

NULL

LastTech Log Number

No

No

FLAcDt_TL_Last_Reported_DtTme

datetime

NULL

Record Last Reported Time

No

No

Table Name Flog_FLAcDt_Aircraft_Lvl_Dtl

Table Comment Aircraft Level Flight Log information are maintained in this table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

%AttName

decimal(10)

NOT NULL

%AttDef

No

No

FLAcDt_Aircraft_Reg_No

varchar(30)

NOT NULL

Aircraft Registration Number

No

No

FLAcDt_Last_JrnLog_No

varchar(40)

NULL

Last Journey Log number

No

No

FLAcDt_JL_Last_Reported_DtTme

datetime

NULL

Journey Log Last Reported DateTime

No

No

FLAcDt_Last_TechLog_No

varchar(40)

NULL

LastTech Log Number

No

No

FLAcDt_TL_Last_Reported_DtTme

datetime

NULL

Record Last Reported Time

No

No

Table Name Flog_FLAcDt_Aircraft_Lvl_Dtl

Table Comment Aircraft Level Flight Log information are maintained in this table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

%AttName

decimal(10)

NOT NULL

%AttDef

No

No

FLAcDt_Aircraft_Reg_No

varchar(30)

NOT NULL

Aircraft Registration Number

No

No

FLAcDt_Last_JrnLog_No

varchar(40)

NULL

Last Journey Log number

No

No

FLAcDt_JL_Last_Reported_DtTme

datetime

NULL

Journey Log Last Reported DateTime

No

No

FLAcDt_Last_TechLog_No

varchar(40)

NULL

LastTech Log Number

No

No

FLAcDt_TL_Last_Reported_DtTme

datetime

NULL

Record Last Reported Time

No

No

Table Name Flog_FLAcDt_Aircraft_Lvl_Dtl

Table Comment Aircraft Level Flight Log information are maintained in this table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

%AttName

decimal(10)

NOT NULL

%AttDef

No

No

FLAcDt_Aircraft_Reg_No

varchar(30)

NOT NULL

Aircraft Registration Number

No

No

FLAcDt_Last_JrnLog_No

varchar(40)

NULL

Last Journey Log number

No

No

FLAcDt_JL_Last_Reported_DtTme

datetime

NULL

Journey Log Last Reported DateTime

No

No

FLAcDt_Last_TechLog_No

varchar(40)

NULL

LastTech Log Number

No

No

FLAcDt_TL_Last_Reported_DtTme

datetime

NULL

Record Last Reported Time

No

No

Table Name Flog_FLAcDt_Aircraft_Lvl_Dtl

Table Comment Aircraft Level Flight Log information are maintained in this table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

%AttName

decimal(10)

NOT NULL

%AttDef

No

No

FLAcDt_Aircraft_Reg_No

varchar(30)

NOT NULL

Aircraft Registration Number

No

No

FLAcDt_Last_JrnLog_No

varchar(40)

NULL

Last Journey Log number

No

No

FLAcDt_JL_Last_Reported_DtTme

datetime

NULL

Journey Log Last Reported DateTime

No

No

FLAcDt_Last_TechLog_No

varchar(40)

NULL

LastTech Log Number

No

No

FLAcDt_TL_Last_Reported_DtTme

datetime

NULL

Record Last Reported Time

No

No

Table Name Flog_FLAcDt_Aircraft_Lvl_Dtl

Table Comment Aircraft Level Flight Log information are maintained in this table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

%AttName

decimal(10)

NOT NULL

%AttDef

No

No

FLAcDt_Aircraft_Reg_No

varchar(30)

NOT NULL

Aircraft Registration Number

No

No

FLAcDt_Last_JrnLog_No

varchar(40)

NULL

Last Journey Log number

No

No

FLAcDt_JL_Last_Reported_DtTme

datetime

NULL

Journey Log Last Reported DateTime

No

No

FLAcDt_Last_TechLog_No

varchar(40)

NULL

LastTech Log Number

No

No

FLAcDt_TL_Last_Reported_DtTme

datetime

NULL

Record Last Reported Time

No

No

Table Name Flog_FlogQc_Quick_Code

Table Comment The Flight Log Quick Code Master table which stores the Quick Codes entered by the user.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

FlogQc_OUInstance

decimal(10)

NOT NULL

Quick Code OUInstance

Yes

No

FLOGQC_SLFSRC_OUINSTANCE

decimal(10)

NOT NULL

Source Ou Instance

No

No

FlogQc_Type

varchar(5)

NOT NULL

Quick Code Type

No

No

FlogQc_Quick_Code

varchar(25)

NOT NULL

Quick code

No

No

FlogQc_Desc

varchar(80)

NULL

Quick Code Description

No

No

FlogQc_Status

varchar(5)

NULL

Quick code Status

No

No

FlogQc_Created_By

varchar(30)

NULL

User who created the Quick Code Details

No

No

FlogQc_CreatedDate

datetime

NULL

Date at which the user created the details

No

No

FlogQc_Modified_By

varchar(30)

NULL

User who modified the Quick Code Details

No

No

FlogQc_ModifiedDate

datetime

NULL

Date at which the user modified the details

No

No

FlogQc_Timestamp

decimal(10)

NULL

TimeStamp for the concurrency check

No

No

Table Name FLOG_FLSYSOP_SYS_OPT_SETTING

Table Comment Contains details about set option set for flight log component

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

FLSYSOP_SLFSRC_OUINSTANCE

decimal(10)

NOT NULL

Source Ou Instance

Yes

No

FLSYSOP_OUINSTANCE

decimal(10)

NOT NULL

Option Setting OU Instance

Yes

No

FLSYSOP_ALLOW_EXTRA_HOUR

varchar(5)

NULL

Allow Extra Hour without authorization ’YES’,’NO’

No

No

FLSYSOP_APU_OIL_PART_NO

varchar(40)

NULL

Part Number Used For APU Oil

No

No

FLSYSOP_APU_OIL_PART_OU

numeric(10)

NULL

APU oil part ou instance

No

No

FLSYSOP_CREATED_BY

varchar(30)

NULL

Created by User

No

No

FLSYSOP_CREATEDDATE

datetime

NULL

Record Created Date

No

No

FLSYSOP_EMP_ARS_VLD

varchar(5)

NULL

Validate for employee presence as per ARS ’YES’,’NO’

No

No

FLSYSOP_ENGINE_OIL_PART_NO

varchar(40)

NULL

Part Number Used For Engine Oil

No

No

FLSYSOP_ENGINE_OIL_PART_OU

numeric(10)

NULL

Engine Oil Part ou instance

No

No

FLSYSOP_FLT_HRS_UPD_BASIS

varchar(5)

NULL

Basis To Update Engine Flight Hours ’Block Hours’,’Flight Hours’

No

No

FLSYSOP_FUEL_PART_NO

varchar(40)

NULL

Part Number Used For Fuel

No

No

FLSYSOP_FUEL_PART_OU

numeric(10)

NULL

Fuel Part OU Instance

No

No

FLSYSOP_HYD_OIL_PART_NO

varchar(40)

NULL

Part Number Used For Hydraulic Oil

No

No

FLSYSOP_HYD_OIL_PART_OU

numeric(10)

NULL

Hydraulic Oil Part OU Instance

No

No

FLSYSOP_MODIFIED_BY

varchar(30)

NULL

Modified By User

No

No

FLSYSOP_MODIFIEDDATE

datetime

NULL

Record last Modified Date

No

No

FLSYSOP_OVERTIME_COMP_BASIS

varchar(5)

NULL

Basis for computing Overtime ’Standard Rate’ or ’Shift Pattern’

No

No

FLSYSOP_CANNIB_REASON

varchar(20)

NULL

Default Reason for Cannibalization

No

No

FLSYSOP_TIME_INDICATOR

varchar(5)

NULL

Time Indicator

No

No

FLSYSOP_TIMESTAMP

numeric(10)

NULL

Time Stamp for Concurrency Check

No

No

FLSYSOP_PIREP_DISC_NUMTYPE

varchar(25)

NULL

Pilot Report Discrepancy Numbering type

No

No

FLSYSOP_MIREP_DISC_NUMTYPE

varchar(25)

NULL

My Report Discrepancy Numbering type

No

No

FLSYSOP_MR_NUMTYPE

varchar(25)

NULL

Maint. Report Numbering Type

No

No

FLSYSOP_UTC_TIMEZONE

varchar(30)

NULL

UTC Time Zone

No

No

FLSYSOP_VLD_LOGLEAF

varchar(5)

NULL

Validate Log Leaf Number ’Yes’,’No’

No

No

FLSYSOP_CR_RPLC_NUM_TYPE

varchar(25)

NULL

Replacement Numbering Type

No

No

FLSYSOP_CR_CANNIB_NUM_TYPE

varchar(25)

NULL

Cannibalization/Swap Numbering Type

No

No

FLSYSOP_DISC_TRNSF_NUM_TYPE

varchar(25)

NULL

Transfer Discrepancy Numbering Type

No

No

FLSYSOP_VLD_BASIS

varchar(5)

NULL

Flight Details Validation Basis

No

No

FLSYSOP_FUEL_OIL_RPT

varchar(5)

NULL

Fuel / Oil Log Reporting ’Mandatory’ ’Non-Mandatory’ ’Based on Journey log Reference’

No

No

FLSYSOP_RPT_DELAY_MOD

varchar(5)

NULL

Reported Delay Modification ’Add New Delays’ ’Fully Modifiable’ ’Not Allowed’

No

No

FLSYSOP_VLD_ENT_DLY_DURN

varchar(5)

NULL

Validate Entered Delay Duration ’With Assigned Values’ ’Entered Values’ ’None’

No

No

FLSYSOP_AUTODPCLS_FLAG

varchar(5)

NULL

Automatic Closing of Discrepancy Number ’NOT ALLOWED’ ’ALLOWED’

No

No

FLSYSOP_AUTOMRCNF_FLAG

varchar(5)

NULL

Automatic Confirmation of Maint. Report ’Required’ ’Not Required’

No

No

FLSYSOP_CRT_OU

numeric(10)

NULL

CRT Ou Instance

No

No

FLSYSOP_ENF_SIGNOFF

varchar(5)

NULL

Enforce Sign-Off? ’Yes’ ’No’

No

No

FLSYSOP_PMTDUAL_SIGNOFF

varchar(5)

NULL

Permit Dual Sign-off by the employee ’Yes’,’No’

No

No

FLSYSOP_ENF_CORERET

varchar(5)

NULL

Enforce Excess/Core Returns ’Yes’,’No’

No

No

FLSYSOP_EFBJLOG_NUMTYPE

varchar(20)

NULL

Default Numbering Type for EFB based Journey Log

No

No

FLSYSOP_EFBFLTSHT_NUMTYPE

varchar(20)

NULL

Default Numbering Type for EFB based Flight Sheet

No

No

FLSYSOP_Com_Reqd

char(18)

NULL

Com required

No

No

FLSYSOP_TM_Upd_Mode

char(18)

NULL

employee time sheet update mode

No

No

FLSYSOP_Compl_RO

char(18)

NULL

Ref. Date for Compliance against Repair Station

No

No

FLSYSOP_Compl_Flt_Opn

char(18)

NULL

Reference Date for Compliance against Flight Operations

No

No

FLSYSOP_signoff_Reqd

char(18)

NULL

Sign-off Reqd. for Deferral of Discrepancy

No

No

FLSYSOP_PMTErrLog_CR

char(18)

NULL

Permit Error Logging of Component Replacement ’Required’ ’Not Required’

No

No

FLSYSOP_AUTH_TIMESHEET

varchar(5)

NULL

Authorization of Timesheet Records ’Required’ ’Not Required’

No

No

FLSYSOP_CONF_TIMESHEET

varchar(5)

NULL

Confirmation of Timesheet Records ’Required’ ’Not Required’

No

No

FLSYSOP_ENF_SEQ_REP

varchar(5)

NULL

Enforce Sequential Reporting

No

No

LOGLEAF_VALID_BASIS

varchar(5)

NULL

Enforce Sequential Reporting

No

No

Table Name Flog_fsact_flight_sht_activity

Table Comment Flight sheet activity details stored in this table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

fsact_activity_code

varchar(40)

NULL

Activity Code

No

No

fsact_seq_no

decimal(10)

NOT NULL

Sequence Number for identifying the activity code for each employee.

Yes

No

fsact_emp_code_ou

decimal(10)

NULL

The employee created ouinstance.

No

No

fsact_duration

varchar(8)

NULL

Duration

No

No

fsact_duration_min

bigint

NULL

Duration in minutes

No

No

fsact_ouinstance

decimal(10)

NOT NULL

Flight sheet created ouinstance.

Yes

Yes

fsact_emp_code

varchar(30)

NOT NULL

The employee code.

Yes

No

fsact_flight_sheet_no

varchar(40)

NOT NULL

Flight sheet number

Yes

Yes

fsact_ammend_no

varchar(40)

NOT NULL

Amendment number

Yes

Yes

Table Name Flog_fsactr_flt_sht_act_rev

Table Comment Flight sheet activity details stored in this table.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

fsactr_activity_code

varchar(40)

NULL

Activity code

No

No

fsactr_seq_no

decimal(10)

NOT NULL

Sequence Number

Yes

No

fsactr_emp_code_ou

decimal(10)

NULL

Employee Code OU

No

No

fsactr_duration

varchar(8)

NULL

Duration

No

No

fsactr_duration_min

bigint

NULL

Duration in Minutes

No

No

fsactr_ouinstance

decimal(40)

NOT NULL

created ouinstance

Yes

Yes

fsactr_emp_code

varchar(30)

NOT NULL

Employee code

Yes

No

fsactr_flight_sheet_no

varchar(40)

NOT NULL

Flight sheet number

Yes

Yes

fsactr_ammend_no

varchar(40)

NOT NULL

Amendment number

Yes

Yes

Table Name Flog_fsdty_flight_sheet_duty

Table Comment Duty details maintained in this table

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

fsdty_duty_code

varchar(40)

NULL

Pilot Pilot Night Unaided Pilot Night Aided Pilot Weather Pilot Hood Co-Pilot Co-Pilot Night Unaided Co-Pilot Night Aided Co-Pilot Weather Instructor Day Instructor Night Dual Day Dual Hood Dual Night

No

No

fsdty_seq_no

decimal(10)

NOT NULL

Sequence number for identifying the duty code.

Yes

No

fsdty_emp_code_ou

NULL

The employee created ouinstance

No

No

fsdty_duration

varchar(18)

NULL

Duration

No

No

fsdty_duration_min

bigint

NULL

duration stored in minutes

No

No

fsdty_ouinstance

decimal(10)

NOT NULL

Flight sheet created ou

Yes

Yes

fsdty_emp_code

varchar(30)

NOT NULL

The code of the employee

Yes

No

fsdty_flight_sheet_no

varchar(40)

NOT NULL

Flight sheet number

Yes

Yes

fsdty_ammend_no

varchar(40)

NOT NULL

Amendment number

Yes

Yes

Table Name Flog_fsdtyr_flt_sheet_duty_rev

Table Comment Duty details maintained in this table

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

fsdtyr_duty_code

varchar(40)

NULL

Pilot Pilot Night Unaided Pilot Night Aided Pilot Weather Pilot Hood Co-Pilot Co-Pilot Night Unaided Co-Pilot Night Aided Co-Pilot Weather Instructor Day Instructor Night Dual Day Dual Hood Dual Night

No

No

fsdtyr_seq_no

decimal(10)

NOT NULL

Sequence Number

Yes

fsdtyr_emp_code_ou

NULL

Employee Code OU

No

fsdtyr_duration

varchar(8)

NULL

Duration

fsdtyr_duration_min

bigint

NULL

Duration in Minutes

fsdtyr_ouinstance

decimal(40)

NOT NULL

created ouinstance

Yes

Yes

fsdtyr_emp_code

varchar(30)

NOT NULL

Employee code

No

fsdtyr_flight_sheet_no

varchar(40)

NOT NULL

Flight sheet number

Yes

fsdtyr_ammend_no

varchar(40)

NOT NULL

Amendment number

Table Name Flog_fshdr_flight_sheet_hdr

Table Comment This table is used to store the Flight sheet header information

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

fshdr_ouinstance

decimal(10)

NOT NULL

Flight sheet created ou

Yes

No

fshdr_flight_sheet_no

varchar(40)

NOT NULL

Flight sheet number

Yes

No

fshdr_ammend_no

varchar(40)

NOT NULL

Amendment number

Yes

No

fshdr_fs_status

varchar(5)

NULL

Flight Sheet status

No

No

fshdr_user_status

varchar(30)

NULL

Flight sheet user status, which is quick code.

No

No

fshdr_aircraft_reg_no

varchar(30)

NULL

Aircraft Registration Number

No

No

fshdr_aircraft_reg_no_ou

decimal(10)

NULL

Aircraft Registration Number created ouinstance

No

No

fshdr_cus_call_sign

varchar(30)

NULL

Customer call Sign

No

No

fshdr_special_flight_no

varchar(30)

NULL

special flight number

No

No

fshdr_flight_code

varchar(5)

NULL

Flight code. It can be INC - Income, NFW  - No Flight Weather, NFR - No Flight Required, NFU - No Flight Unsch. Maint., NFS - No Flight Sch. Maint., NFH  - No Flight Hangar Maint., OPS  - PHI Operations, OPP  - Opns. A/C Positioning, MNT  -  Maintenance Check, EMS  - Emergency Medical Service, CRW  - PHI Crew Change, FRP  - FAA Ferry Permit, SAL  - Sales Promotion, TRN  - Training, TRP - Training A/C Positioning

No

No

fshdr_aircraft_rel

varchar(5)

NULL

Aircraft released. It can be BLK  -  None, QTR - 0.25, HLF  - 0.5,  TQR - 0.75, ONE - 1.

No

No

fshdr_start_date

datetime

NULL

Journey Start date

No

No

fshdr_end_date

datetime

NULL

Journey End Date

No

No

fshdr_outstate_time

varchar(8)

NULL

outstate time

No

No

fshdr_Instate_time

NULL

Instate time

No

No

fshdr_no_pax

decimal(10)

NULL

Number of passenger

No

No

fshdr_fuel_tax_time

varchar(8)

NULL

Fuel tax time

No

No

fshdr_adapt_time

NULL

Adapt time

No

No

fshdr_segment_tax

decimal(10)

NULL

Segment tax

No

No

fshdr_ferry_time

varchar(8)

NULL

Ferry time

No

No

fshdr_aircraft_repl

varchar(30)

NULL

Aircraft registration Number replaced

No

No

fshdr_aircraft_repl_ou

decimal(10)

NULL

Aircraft registration Number created ouinstance

No

No

fshdr_replaced_by

varchar(30)

NULL

Aircraft replaced By

No

No

fshdr_replaced_by_ou

decimal(10)

NULL

Aircraft Registration Number created ouinstance

No

No

fshdr_ron_away

varchar(5)

NULL

Ron Away

No

No

fshdr_act_hrs_rep

varchar(8)

NULL

Actual Hours Replaced

No

No

fshdr_nvg_event

decimal(10)

NULL

Nvg Events

No

No

fshdr_user_def_det1

varchar(30)

NULL

User Defined detail 1

No

No

fshdr_user_def_det2

varchar(30)

NULL

User Defined detail 2

No

No

fshdr_user_def_det3

varchar(30)

NULL

User Defined detail 3

No

No

fshdr_user_def_det4

varchar(30)

NULL

User Defined detail 4

No

No

fshdr_file_name

varchar(150)

NULL

File Name being attached

No

No

fshdr_remarks

varchar(255)

NULL

Remarks if any

No

No

fshdr_start_gmt_date

datetime

NULL

Start date in Gmt

No

No

fshdr_end_gmt_date

datetime

NULL

End date in Gmt

No

No

fshdr_outstate_time_min

bigint

NULL

Outstate time stored in minutes

No

No

fshdr_Instate_time_min

bigint

NULL

In state time stored in minutes

No

No

fshdr_fuel_tax_time_min

bigint

NULL

Fuel tax time in minutes

No

No

fshdr_adapt_time_min

bigint

NULL

Adapt time in minutes

No

No

fshdr_ferry_time_min

bigint

NULL

Ferry Time in minutes

No

No

FSHDR_ACTHRSREP_TIME_MIN

bigint

NULL

Actual Hours Replaced Time in Minutes

No

No

fshdr_created_by

varchar(20)

NULL

The user who created the flight sheet

No

No

fshdr_created_date

datetime

NULL

Record Created date

No

No

fshdr_modified_by

varchar(20)

NULL

The user who modified the flight sheet.

No

No

fshdr_modified_date

datetime

NULL

Record last Modified date

No

No

fshdr_approved_by

varchar(20)

NULL

The user who approved the flight sheet.

No

No

fshdr_approved_date

datetime

NULL

Record Approved date

No

No

fshdr_amended_by

varchar(20)

NULL

the user who amended the flight sheet

No

No

fshdr_amended_date

datetime

NULL

Record Amended date

No

No

fshdr_confirmed_by

varchar(20)

NULL

The user who confirm the flight sheet

No

No

fshdr_confirmed_date

datetime

NULL

Record Confirmed date

No

No

fshdr_amd_remarks

varchar(255)

NULL

amended remarks

No

No

fshdr_timestamp

decimal(10)

NULL

Timestamp for Concurrency Check

No

No

fshdr_latest_flag

varchar(5)

NULL

The latest flag for identifying the latest amendment no for the flight sheet.

No

No

FSHDR_CREW_WEIGHT

decimal(28,8)

NULL

Crew Weight

No

No

Table Name Flog_fshdr_flt_sheet_hdr_rev

Table Comment This table is used to store the Flight sheet header information

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

fshdrr_ouinstance

decimal(40)

NOT NULL

Created Ouinstance

Yes

No

fshdrr_flight_sheet_no

varchar(40)

NOT NULL

Flight sheet number

Yes

No

fshdrr_ammend_no

NOT NULL

Amendment number

Yes

No

fshdrr_fs_status

varchar(5)

NULL

Flight Sheet Status. It can be FRE  - Fresh CFM  - Confirmed APP  - Approved UAM - Under Amendment CAN  - Cancelled

No

No

fshdrr_user_status

varchar(30)

NULL

User Status, which is in quick codes

No

No

fshdrr_aircraft_reg_no

NULL

Aircraft Registration Number

No

No

fshdrr_aircraft_reg_no_ou

decimal(10)

NULL

Aircraft Registration Number created ouinstance

No

No

fshdrr_cus_call_sign

varchar(30)

NULL

Customer call Sign

No

No

fshdrr_special_flight_no

varchar(30)

NULL

special flight number

No

No

fshdrr_flight_code

varchar(5)

NULL

Flight code. It can be INC - Income, NFW - No Flight Weather, NFR- No Flight Required,NFU - No Flight Unsch. Maint., NFS - No Flight Sch. Maint., NFH - No Flight Hangar Maint., OPS  - PHI Operations, OPP  - Opns. A/C Positioning, MNT - Maintenance Check, EMS - Emergency Medical Service, CRW - PHI Crew Change, FRP - FAA Ferry Permit, SAL - Sales Promotion, TRN - Training, TRP - Training A/C Positioning

No

No

fshdrr_aircraft_rel

varchar(5)

NULL

Aircraft released. It can be BLK - None, QTR - 0.25, HLF - 0.5, TQR - 0.75, ONE - 1.

No

No

fshdrr_start_date

datetime

NULL

Journey Start Date

No

No

fshdrr_end_date

datetime

NULL

Journey End Date

No

No

fshdrr_outstate_time

varchar(8)

NULL

Outstate Time

No

No

fshdrr_Instate_time

varchar(8)

NULL

Instate Time

No

No

fshdrr_no_pax

decimal(10)

NULL

Number of passengers

No

No

fshdrr_fuel_tax_time

varchar(8)

NULL

Fuel Tax Time

No

No

fshdrr_adapt_time

varchar(8)

NULL

Adapt Time

No

No

fsrhdrr_segment_tax

decimal(10)

NULL

Segment Tax

No

No

fsrhdrr_ferry_time

varchar(8)

NULL

Ferry Time

No

No

fshdrr_aircraft_repl

varchar(30)

NULL

Aircraft Replaced

No

No

fshdrr_aircraft_repl_ou

decimal(10)

NULL

Aircraft Replaced OU

No

No

fshdrr_replaced_by

varchar(30)

NULL

Aircraft Replaced By user

No

No

fshdrr_replaced_by_ou

decimal(10)

NULL

Aircraft Replaced By OU

No

No

fshdrr_ron_away

varchar(5)

NULL

RON Away. It can be Y - Yes N - No

No

No

fshdrr_act_hrs_rep

varchar(8)

NULL

Actual Hours Replaced

No

No

fshdrr_nvg_event

decimal(10)

NULL

NVG events

No

No

fshdrr_user_def_det1

varchar(30)

NULL

User Defined detail 1

No

No

fshdrr_user_def_det2

varchar(30)

NULL

User Defined detail 2

No

No

fshdrr_user_def_det3

varchar(30)

NULL

User Defined detail 3

No

No

fshdrr_user_def_det4

varchar(30)

NULL

User Defined detail 4

No

No

fshdrr_file_name

varchar(150)

NULL

File Name being attached

No

No

fshdrr_remarks

varchar(255)

NULL

Remarks if any

No

No

fshdrr_start_gmt_date

datetime

NULL

Start Date in GMT

No

No

fshdrr_end_gmt_date

datetime

NULL

End Date in GMT

No

No

fshdrr_outstate_time_min

bigint

NULL

OutState Time in Minutes

No

No

fshdrr_Instate_time_min

bigint

NULL

InState Time in Minutes

No

No

fshdrr_fuel_tax_time_min

bigint

NULL

Fuel Tax time in Minutes

No

No

fshdrr_adapt_time_min

bigint

NULL

Adapt time in Minutes

No

No

fshdrr_ferry_time_min

bigint

NULL

Ferry time in minutes

No

No

fshdrr_created_by

varchar(20)

NULL

Created By user

No

No

fshdrr_created_date

datetime

NULL

Record Created Date

No

No

fshdrr_modified_by

varchar(20)

NULL

Modified By user

No

No

fshdrr_modified_date

datetime

NULL

Record last Modified Date

No

No

fshdrr_approved_by

varchar(20)

NULL

Approved By user

No

No

fshdrr_approved_date

datetime

NULL

Record Approved Date

No

No

fshdrr_confirmed_by

varchar(20)

NULL

Confirmed By user

No

No

fshdrr_confirmed_date

datetime

NULL

Record Confirmed Date

No

No

fshdrr_amended_by

varchar(20)

NULL

Amended By user

No

No

fshdrr_amended_date

datetime

NULL

Record Amended Date

No

No

fshdrr_amd_remarks

varchar(225)

NULL

Amend Remarks

No

No

fshdrr_timestamp

decimal(10)

NULL

TimeStamp for Concurrency Check

No

No

fshdrr_acthrsrep_time_min

numeric(28)

NULL

Actual hours replaced in minutes

No

No

fshdrr_latest_flag

varchar(5)

NULL

Latest Flag

No

No

FSHDR_CREW_WEIGHT

decimal(28,8)

NULL

Crew weight

No

No

Table Name Flog_fsleg_flight_sht_leg

Table Comment Leg details stored in this table

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

fsleg_ouinstance

decimal(10)

NOT NULL

Flight sheet created ouinstance

Yes

Yes

fsleg_flight_sheet_no

varchar(40)

NOT NULL

Flight sheet number

Yes

Yes

fsleg_ammend_no

varchar(40)

NOT NULL

Amendment number

Yes

Yes

fsleg_jrnlog_no

varchar(40)

NOT NULL

journey log number

Yes

No

fsleg_leg_no

decimal(6)

NOT NULL

journey leg number

Yes

No

fsleg_from_station

varchar(40)

NULL

From Station of corresponding leg

No

No

fsleg_from_date

datetime

NULL

From Date of corresponding leg

No

No

fsleg_from_time

varchar(8)

NULL

From Time of corresponding leg

No

No

fsleg_to_station

varchar(40)

NULL

To Station of corresponding leg

No

No

fsleg_to_date

datetime

NULL

To Date of corresponding leg

No

No

fsleg_to_time

varchar(8)

NULL

To Time of corresponding leg

No

No

fsleg_flight_duration

varchar(8)

NULL

Flight Duration

No

No

fsleg_fltdurmins

decimal(10)

NULL

Flight duration in minutes

No

No

fsleg_TakeOffs

decimal(10)

NULL

Number of Take offs

No

No

fsleg_Remarks

varchar(255)

NULL

Remarks if any

No

No

fsleg_jlammend_no

varchar(40)

NULL

Journey Log Amendment Number

No

No

FSLEG_PASSENGERWT

decimal(28,8)

NULL

Passenger weight

No

No

FSLEG_BAGGAGEWT

decimal(28,8)

NULL

Baggage weight

No

No

FSLEG_CARGOWT

decimal(28,8)

NULL

Cargo weight

No

No

FSLEG_OCCTOGROSSWT

decimal(28,8)

NULL

Gross weight

No

No

FSLEG_MAXGROSSWT

decimal(28,8)

NULL

Maximum gross weight

No

No

FSLEG_FOWARDCGLIMIT

decimal(28,8)

NULL

Forward center of gravity limit

No

No

FSLEG_ALTCGLIMIT

decimal(28,8)

NULL

Altitude center of gravity limit

No

No

FSLEG_CGVALUE

decimal(28,8)

NULL

Center of gravity value

No

No

FSLEG_FUELONBOARD

decimal(28,8)

NULL

Fuel on board (Fuel quantity in aircraft during flight)

No

No

Table Name Flog_fslegr_flt_sht_leg_rev

Table Comment Leg details stored in this table

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

fslegr_ouinstance

decimal(40)

NOT NULL

created ouinstance

Yes

Yes

fslegr_flight_sheet_no

varchar(40)

NOT NULL

Flight sheet number

Yes

Yes

fslegr_ammend_no

varchar(40)

NOT NULL

Amendment number

Yes

Yes

fslegr_jrnlog_no

varchar(40)

NOT NULL

Journey Log Number

Yes

No

fslegr_leg_no

decimal(6)

NOT NULL

Journey Log Leg Number

Yes

No

fslegr_from_station

varchar(40)

NULL

From Station

No

No

fslegr_from_date

datetime

NULL

From date

No

No

fslegr_from_time

varchar(8)

NULL

From Time of corresponding leg

No

No

fslegr_to_station

varchar(40)

NULL

To Station of corresponding leg

No

No

fslegr_to_date

datetime

NULL

To Date of corresponding leg

No

No

fslegr_to_time

varchar(8)

NULL

To Time of corresponding leg

No

No

fslegr_flight_duration

varchar(8)

NULL

Flight duration

No

No

fslegr_fltdurmins

decimal(10)

NULL

Flight duration in Minutes

No

No

fslegr_TakeOffs

decimal(10)

NULL

Take offs

No

No

fslegr_remarks

varchar(255)

NULL

Remarks if any

No

No

fslegr_jlammend_no

varchar(40)

NULL

Journey Log Amendment Number

No

No

FSLEG_PASSENGERWT

decimal(28,8)

NULL

Passenger Weight

No

No

FSLEG_BAGGAGEWT

decimal(28,8)

NULL

Baggage Weight

No

No

FSLEG_CARGOWT

decimal(28,8)

NULL

Cargo Weight

No

No

FSLEG_OCCTOGROSSWT

decimal(28,8)

NULL

Gross Weight

No

No

FSLEG_MAXGROSSWT

decimal(28,8)

NULL

Maximum Gross Weight

No

No

FSLEG_FOWARDCGLIMIT

decimal(28,8)

NULL

Forward center of gravity limit

No

No

FSLEG_ALTCGLIMIT

decimal(28,8)

NULL

Altitude center of gravity limit

No

No

FSLEG_CGVALUE

decimal(28,8)

NULL

Center of gravity value

No

No

FSLEG_FUELONBOARD

decimal(28,8)

NULL

Fuel on board (Fuel quantity in aircraft during flight)

No

No

Table Name Flog_JLgAcPrm_Ac_Param_Dtl

Table Comment This table contains the Ac parameter values entered as part of the journey log. Component first level parameter values and aircraft parameter values alone are captured in the UI. Ac Parameter values are stored in this entity.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

JLGACPRM_SLFSRC_OUINSTANCE

decimal(10)

NOT NULL

Self Interaction OU Instance

Yes

No

JLGACPRM_JRNLOG_NO

varchar(40)

NOT NULL

Journey Log Number

Yes

No

JLgAcPrm_Param_OUInstance

decimal(10)

NOT NULL

Aircraft Parameter OUinstance

Yes

No

JLgAcPrm_Param_Code

varchar(40)

NOT NULL

Aircraft Parameter Code

Yes

No

JLgAcPrm_Param_Type

varchar(5)

NULL

Will be an attribute of Parameter in AC. This attribute is replicated here [denormalized] for performance optimization. Applicable values for this field are ’C’ [for consumption] or ’R’ [for Range]

No

No

JLgAcPrm_Param_Mandatory

varchar(5)

NULL

Will be an attribute of Parameter in AC. This attribute is replicated here [denormalized] for performance optimization. Value will be ’Y’ or ’N’

No

No

JLGACPRM_UPDATE_MODE

varchar(5)

NULL

Update Mode of Aircraft Parameter Details

No

No

JLgAcPrm_Param_Value

varchar(32)

NULL

Aircraft Parameter value

No

No

JLgAcPrm_Created_By

varchar(30)

NULL

User who created the details

No

No

JLgAcPrm_CreatedDate

datetime

NULL

Date at which the user created the details

No

No

JLgAcPrm_Modified_By

varchar(30)

NULL

User who modified the details

No

No

JLgAcPrm_ModifiedDate

datetime

NULL

Date at which the user modified the details

No

No

JLgAcPrm_Crt_Ou

decimal(10)

NULL

Created OU ID

No

No

JLGACPRM_AMEND_NO

varchar(40)

NOT NULL

Amend Number

No

No

Table Name FLOG_JLGAM_JOURNEY_LOG_HDR

Table Comment It stores values of the amended Journey log data

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

JLGAM_SLFSRC_OUINSTANCE

decimal(10)

NOT NULL

Self OU Instance

Yes

No

JLGAM_JRNLOG_NO

varchar(40)

NOT NULL

Journey log number

Yes

No

JLGAM_AMEND_NO

varchar(40)

NOT NULL

Amendment Number

Yes

No

JLGAM_FLIGHT_DATE

datetime

NOT NULL

Flight Date

Yes

No

JLGAM_STARTING_STATION

varchar(30)

NOT NULL

starting station number

Yes

No

JLGAM_AIRCRAFT_OUINSTANCE

decimal(10)

NOT NULL

Aircraft OU instance

Yes

No

JLGAM_AIRCRAFT_REG_NO

varchar(30)

NOT NULL

Aircraft Reg number

Yes

No

JLGAM_JRNLOG_CATEGORY

varchar(25)

NULL

This will be the quick codes that are defined under the Qc type ’Journey Log Category’

No

No

JLGAM_JRNLOG_STATUS

varchar(5)

NULL

Amended Records of Journey log status

No

No

JLGAM_FLIGHT_CATEGORY

varchar(25)

NULL

Amended records of Flight Category

No

No

JLGAM_REP_TIMEZONE

varchar(25)

NULL

Amended Records of Reporting Time Zone

No

No

JLGAM_AIRCRAFT_MODEL

varchar(30)

NULL

Amended Records of Aircraft Model

No

No

JLGAM_MFGSRLNO

varchar(40)

NULL

Amended Manufacturing Serial Number

No

No

JLGAM_CONFIG_CLASS

varchar(40)

NULL

Configuration class of aircraft

No

No

JLGAM_LAST_JLOG_DATE

datetime

NULL

Last Journey log Date

No

No

JLGAM_LEG_PARAMETER1

varchar(40)

NULL

Parameter code no 1

No

No

JLGAM_LEG_PARAM1_VAL

varchar(30)

NULL

Value of the Parameter code 1

No

No

JLGAM_LEG_PARAM1_UOM

varchar(30)

NULL

UOM of Parameter code No 1

No

No

JLGAM_LEG_PARAMETER2

varchar(40)

NULL

Parameter code no 1

No

No

JLGAM_LEG_PARAM2_VAL

varchar(30)

NULL

Value of the Parameter code 2

No

No

JLGAM_LEG_PARAM2_UOM

varchar(30)

NULL

UOM of Parameter code No 2

No

No

JLGAM_LEG_PARAMETER3

varchar(40)

NULL

Parameter code no 3

No

No

JLGAM_LEG_PARAM3_VAL

varchar(30)

NULL

Value of the Parameter code 3

No

No

JLGAM_LEG_PARAM3_UOM

varchar(30)

NULL

UOM of Parameter code No 3

No

No

JLGAM_LEG_PARAMETER4

varchar(40)

NULL

Parameter code no 4

No

No

JLGAM_LEG_PARAM4_VAL

varchar(30)

NULL

Value of the Parameter code 4

No

No

JLGAM_LEG_PARAM4_UOM

varchar(30)

NULL

UOM of Parameter code No 4

No

No

JLGAM_LEG_PARAMETER5

varchar(40)

NULL

Parameter code no 5

No

No

JLGAM_LEG_PARAM5_VAL

varchar(30)

NULL

Value of the Parameter code 5

No

No

JLGAM_LEG_PARAM5_UOM

varchar(30)

NULL

UOM of Parameter code No 5

No

No

JLGAM_LEG_PARAMETER6

varchar(40)

NULL

Parameter code no 6

No

No

JLGAM_LEG_PARAM6_VAL

varchar(30)

NULL

Value of the Parameter code 6

No

No

JLGAM_LEG_PARAM6_UOM

varchar(30)

NULL

UOM of Parameter code No 6

No

No

JLGAM_PARAM_OUINSTANCE

decimal(10)

NULL

Param Ou instance

No

No

JLGAM_TOTAL_FLIGHT_HOURS

decimal(28,8)

NULL

Total Flight Hours

No

No

JLGAM_TOTAL_TAKEOFFS

decimal(10)

NULL

Total Take Offs

No

No

JLGAM_FLIGHT_HOURS

decimal(28,8)

NULL

Flight Hours

No

No

JLGAM_TAKEOFFS

decimal(10)

NULL

Take offs for the specified Journey log

No

No

JLGAM_TAKEOFFS_UOM

varchar(30)

NULL

Take OFF - UOM

No

No

JLGAM_TOTTAKEOFFS_UOM

varchar(30)

NULL

Unit of measurement for Total Take offs

No

No

JLGAM_FLIGHTHOURS_UOM

varchar(30)

NULL

Amended Records of Uom - Flight Hours

No

No

JLGAM_TOTALFH_UOM

varchar(30)

NULL

TOTAL Flight Hours - UOM

No

No

JLGAM_REPORTING_DATETIME

datetime

NULL

Amended Reporting Datetime

No

No

JLGAM_UTC_REPORTING_DATETIME

datetime

NULL

UTC Reporting Datetime

No

No

JLGAM_CREATED_BY

varchar(30)

NULL

Created By user

No

No

JLGAM_CREATEDDATE

datetime

NULL

Record Created Date

No

No

JLGAM_MODIFIED_BY

varchar(30)

NULL

Modified By user

No

No

JLGAM_MODIFIEDDATE

datetime

NULL

Record last Modified Date

No

No

JLGAM_CONFIRMED_DATE

datetime

NULL

Record confirmed Date

No

No

JLGAM_CONFIRMED_BY

varchar(30)

NULL

Confirmed By user

No

No

JLGAM_FILENAME

varchar(50)

NULL

Filename being attached

No

No

JLGAM_REMARKS

varchar(255)

NULL

Remarks about journey

No

No

JLGAM_TIMESTAMP

decimal(10)

NULL

timestamp for concurrency Check

No

No

JLGAM_AMDREMARKS

varchar(255)

NULL

Amendment Remarks

No

No

JLgAm_Block_Hrs

int

NULL

Block Hours

No

No

JLGAM_LAST_JLOGNO

varchar(18)

NULL

Last Journey log number

No

No

JLGAM_LAST_JLOG_STATUS

varchar(15)

NULL

Last Journey Log status

No

No

JLGAM_FHLOGMODE

varchar(25)

NULL

Flight Log Mode

No

No

JLGAM_HMREADING

bigint

NULL

Hobbs Meter Reading

No

No

JLGAM_HMRESET

varchar(6)

NULL

Hobbs Reset

No

No

Table Name FLOG_JLGAM_JRNLG_AMEND_DTL

Table Comment IT stores the amended Journey leg related data

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

JLGAMLEG_SLFSRC_OUINSTANCE

decimal(10)

NOT NULL

self Interacting OU Instance

Yes

No

JLGAMLEG_JRNLOG_NO

varchar(40)

NOT NULL

Unique Journey LOg Number

Yes

No

JLGAMLEG_AMEND_NO

varchar(40)

NOT NULL

Amendment Number

Yes

No

JLGAMLEG_Line_no

int

NOT NULL

Line Number

Yes

No

JLGAMLEG_LEGNO

decimal(10)

NOT NULL

Leg No ie for each multiline there will be one leg

No

No

JLGAMLEG_FROM_STATION

varchar(40)

NULL

From Station for a particular Leg number

No

No

JLGAMLEG_TO_STATION

varchar(40)

NULL

To Station for a particular Leg number

No

No

JLGAMLEG_USER_FROM_TIME

varchar(8)

NULL

User Entered From Time in the multiline it could be in HHMM or HH:MM Format

No

No

JLGAMLEG_USER_TO_TIME

varchar(8)

NULL

User Entered To Time in the multiline it could be in HHMM or HH:MM Format

No

No

JLGAMLEG_FROM_DATE

datetime

NULL

From Date for a particular Leg Number

No

No

JLGAMLEG_FROM_TIME

datetime

NULL

From Time for a particular Leg Number

No

No

JLGAMLEG_TO_DATE

datetime

NULL

To Date for a particular Leg Number

No

No

JLGAMLEG_TO_TIME

datetime

NULL

To Time for a particular Leg Number

No

No

JLGAMLEG_UTC_FROM_DATE

datetime

NULL

UTC From Date

No

No

JLGAMLEG_UTC_TO_DATE

datetime

NULL

UTC To Date

No

No

JLGAMLEG_UTC_FROM_TIME

datetime

NULL

UTC From Time

No

No

JLGAMLEG_UTC_TO_TIME

datetime

NULL

UTC To Time

No

No

JLGAMLEG_REPORTDATETIME

datetime

NULL

Reporting Date time for a particular leg Number

No

No

JLGAMLEG_REPORTDATETIME_UTC

datetime

NULL

UTC Reporting Date time for a particular leg Number

No

No

JLGAMLEG_FLIGHT_TIME

varchar(10)

NULL

Flight Duration of each and every leg Number

No

No

JLGAMLEG_FLIGHT_FOLL

NULL

Flight Foll of each and every leg Number

No

No

JLGAMLEG_PASSENGERS

decimal(10)

NULL

Number of Passengers for each and every leg Number

No

No

JLGAMLEG_TAKEOFFS

decimal(10)

NULL

Number of Take Offs for each and every leg Number

No

No

JLGAMLEG_FLIGHT_STATUS

varchar(30)

NULL

Flight Status - OS - OnSchedule De - Delayed.

No

No

JLGAMLEG_FS_STATUS

NULL

Flight Sheet Status as ’Allocated - A’

No

No

JLGAMLEG_PARAMETER1

varchar(40)

NULL

Param Value for the Parameter Code 1

No

No

JLGAMLEG_PARAMETER2

varchar(40)

NULL

Param Value for the Parameter Code 2

No

No

JLGAMLEG_PARAMETER3

varchar(40)

NULL

Param Value for the Parameter Code 3

No

No

JLGAMLEG_PARAMETER4

varchar(40)

NULL

Param Value for the Parameter Code 4

No

No

JLGAMLEG_PARAMETER5

varchar(40)

NULL

Param Value for the Parameter Code 5

No

No

JLGAMLEG_PARAMETER6

varchar(40)

NULL

Param Value for the Parameter Code 6

No

No

JLGAMLEG_PARAM_OUINSTANCE

decimal(10)

NULL

Param OU Instance

No

No

JLGAMLEG_REMARKS

varchar(255)

NULL

Remarks if any about amendment

No

No

JLGAMLEG_CREATED_BY

varchar(30)

NULL

Created By User

No

No

JLGAMLEG_CREATEDDATE

datetime

NULL

Created Date of the Transaction

No

No

JLGAMLEG_MODIFIED_BY

varchar(30)

NULL

Modified by user

No

No

JLGAMLEG_MODIFIEDDATE

datetime

NULL

Record last Modified Date

No

No

JLGAMLEG_FLTDURMINS

decimal(10)

NULL

Flight Duration in minutes

No

No

JLGAMLEG_Takeoff_DateTime

datetime

NULL

Take Off Datetime

No

No

JLGAMLEG_UTC_TakeOff_Dttime

datetime

NULL

UTC TakeOff Date Time

No

No

JLGAMLEG_Landing_DateTime

datetime

NULL

Landing Date time

No

No

JLGAMLEG_UTC_Landing_Dttime

datetime

NULL

UTC Landing Date Time

No

No

JLGAMLEG_Touch_Gocnt

int

NULL

Touch Go Count

No

No

JLGAMLEG_Dept_Fuel_Read

int

NULL

Departure Fuel Reading

No

No

JLGAMLEG_Arvl_Fuel_Read

int

NULL

Arrival Fuel Reading

No

No

JLGAMLEG_Landing_Type

varchar(20)

NULL

Landing Type ’Emergency’ ’Normal’ ’Touch and Go’

No

No

JLGAMLEG_Maint_exe

varchar(20)

NULL

Maintain Execution? ’Yes’,’No’

No

No

JLGAMLEG_Cabin_Crew

varchar(20)

NULL

Cabin Crew Change? ’Yes’,’No’

No

No

JLGAMLEG_Lnd_Cycle

int

NULL

Landing Cycle

No

No

JLGAMLEG_Jrny_Eng_Cycle

int

NULL

Journey Engine Cycle

No

No

JLGAMLEG_Pilot_Snag_Remarks

varchar(20)

NULL

Pilot Snag Remarks

No

No

JLGAMLEG_Blk_Hrs

int

NULL

Block Hours

No

No

JLGAMLEG_Jrny_Eng_Hrs

int

NULL

Journey Engine Hours

No

No

JLGAMLEG_USER_TAKEOFTIME

varchar(20)

NULL

User Takeoff Time

No

No

JLGAMLEG_USER_LANDING_TIME

varchar(20)

NULL

User Landing Time

No

No

jlgamleg_flight_no

varchar(20)

NULL

Flight Number

No

No

JLGAMLEG_HOBBS_OUT

bigint

NULL

Hobbs Out Value

No

No

JLGAMLEG_HOBBS_IN

bigint

NULL

Hobbs In Value

No

No

JLGAMLEG_REV_ARR_DELAY_DURN

bigint

NULL

Revision Arrival Delay Duration

No

No

JLGAMLEG_REV_DEP_DELAY_DURN

bigint

NULL

Revision Departure Delay Duration

No

No

JLGAMLEG_TECH_ENG_ARR_DELAY_DURN

bigint

NULL

Technical Arrival Delay Duration

No

No

JLGAMLEG_TECH_ENG_DEP_DELAY_DURN

bigint

NULL

Technical Departure Delay Duration

No

No

Table Name FLOG_JLGAMAC_AMMEND_ACPRM

Table Comment This table contains the Ac parameter values entered as part of the journey log. Component first level parameter values and aircraft parameter values alone are captured in the UI. Ac Parameter values are stored in this entity

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

JLGAMAC_SLFSRC_OUINSTANCE

decimal(10)

NOT NULL

Self OU Interacting OU

Yes

No

JLGAMAC_JRNLOG_NO

varchar(40)

NOT NULL

Journey log number

Yes

No

JLGAMAC_PARAM_OUINSTANCE

decimal(10)

NOT NULL

Aircraft Parameter OUinstance

Yes

No

JLGAMAC_PARAM_CODE

varchar(40)

NOT NULL

Aircraft Parameter Code

Yes

No

JLGAMAC_AMEND_NO

varchar(40)

NOT NULL

Amendment Number

Yes

No

JLGAMAC_PARAM_TYPE

varchar(5)

NULL

Will be an attribute of Parameter in AC. This attribute is replicated here [denormalized] for performance optimization. Applicable values for this field are ’C’ [for consumption] or ’R’ [for Range]

No

No

JLGAMAC_PARAM_MANDATORY

varchar(5)

NULL

Will be an attribute of Parameter in AC. This attribute is replicated here [denormalized] for performance optimization. Value will be ’Y’ or ’N’

No

No

JLGAMAC_UPDATE_MODE

NULL

Update mode as ’Delta’ or ’New’

No

No

JLGAMAC_PARAM_VALUE

varchar(32)

NULL

Aircraft Parameter value

No

No

JLGAMAC_CREATED_BY

varchar(30)

NULL

User who created the details

No

No

JLGAMAC_CREATEDDATE

datetime

NULL

Date at which the user created the details

No

No

JLGAMAC_MODIFIED_BY

varchar(30)

NULL

User who modified the details

No

No

JLGAMAC_MODIFIEDDATE

datetime

NULL

Date at which the user modified the details

No

No

JLGAMAC_CRT_OU

decimal(10)

NULL

Created OU ID

No

No

Table Name FLOG_JLGAMCP_AMMEND_COMPPRM

Table Comment This table contains the component parameter values entered as part of the journey log. Component first level parameter values and aircraft parameter values alone are captured in the UI. Component 1st level Parameter values alone are stored in this entity. &nbspSystem calculated parameter value For EH and EC is also maintained in this entity.

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

JLGAMCP_CFG_OUINSTANCE

decimal(10)

NOT NULL

Configuration OUInstance

Yes

No

JLGAMCP_COMPONENT_OU

decimal(10)

NOT NULL

Component Ou

Yes

No

JLGAMCP_JRNLOG_NO

varchar(40)

NOT NULL

Journey Log Number

Yes

No

JLGAMCP_AMEND_NO

NOT NULL

Amend Number

Yes

No

JLGAMCP_SLFSRC_OUINSTANCE

decimal(10)

NOT NULL

Self Interacting OU Instance

Yes

No

JLGAMCP_PARAM_CODE

varchar(40)

NOT NULL

Param Code

Yes

No

JLGAMCP_PARAM_OUINSTANCE

decimal(10)

NOT NULL

Component Parameter OUInstance

Yes

No

JLGAMCP_PART_NO

varchar(40)

NOT NULL

Part Number

Yes

No

JLGAMCP_PART_OUINSTANCE

decimal(10)

NOT NULL

Part OUinstance

Yes

No

JLGAMCP_POS_CODE

varchar(25)

NOT NULL

Position code

Yes

No

JLGAMCP_POS_TYPE

varchar(25)

NOT NULL

Position Type. Following are the codes and it’s values A - APU, E - Engine

Yes

No

JLGAMCP_COMPONENT_ID

varchar(90)

NULL

Component Id

No

No

JLGAMCP_PART_SERIAL_NO

varchar(40)

NULL

Part Serial Number

No

No

JLGAMCP_CREATED_BY

varchar(30)

NULL

User who created the details

No

No

JLGAMCP_CREATEDDATE

datetime

NULL

Date at which the user created the details

No

No

JLGAMCP_MODIFIED_BY

varchar(30)

NULL

User who modified the details

No

No

JLGAMCP_MODIFIEDDATE

datetime

NULL

Date at which the user modified the details

No

No

JLGAMCP_PARAM_MANDATORY

varchar(5)

NULL

Will be an attribute of Parameter in AC. This attribute is replicated here [denormalized] for performance optimization. Value will be ’Y’ or ’N’

No

No

JLGAMCP_UPDATE_MODE

varchar(5)

NULL

Update mode

No

No

JLGAMCP_PARAM_TYPE

varchar(5)

NULL

Will be an attribute of Parameter in AC. This attribute is replicated here [denormalized] for performance optimization. Applicable values for this field are ’C’ [for consumption] or ’R’ [for Range]

No

No

JLGAMCP_PARAM_VALUE

varchar(32)

NULL

Component Parameter Value

No

No

JLGAMCP_CRT_OU

decimal(10)

NULL

Created OU

No

No

JLGAMCP_BASE_PRMCODE

varchar(18)

NULL

This will be NULL for all user entered parameter values. This base param code will be EH Or EC for system calculated

No

No

Table Name FLOG_JLGAMDY_JRNLG_INIT_DLY

Table Comment This table stores the delay information of a Journey Log as reported initially by the Pilot after the journey. Since Pilot entered delay information and AME entered delay information are always referred seperately and is maintained as two different records, different tables have been put for pilot reported delay and AME reported delay (i.e. same table is not used with a kind of AME_OR_PILOT_FLAG + AME_Delay_Remarks and Pilot_Delay_Remarks). Moreover, there is a possibility of changing the delay information reported by the pilot at delay category level than at the delay no level. Keeping the information separately in two different tables will reduce the impact due to such possible changes. Amended Records

Table Column Name

Table Column Datatype

Table Column Null Option

Table Column Comment

Table Column Is PK

Table Column Is FK

JLGAMDY_SLFSRC_OUINSTANCE

decimal(10)

NOT NULL

Self OU Instance

Yes

No

JLGAMDY_JRNLOG_NO

varchar(40)

NOT NULL

Journey Log number

Yes

No

JLGAMDY_JRNLOG_Line_NO

decimal(8)

NOT NULL

Leg Number as Specified in the Journey Log Header

Yes

No

JLGAMDY_DELAY_OU

decimal(10)

NOT NULL

Delay OU ID

Yes

No

JLGAMDY_DELAY_NO

varchar(25)

NOT NULL

This delay no will be created under one of the following delay category in Common Master Following lists the Delay Categories and it’s values: AGA - Airport and Government Authorities, ARH - Aircraft and Ramp Handling, CM - Cargo and Mail, DAEF - Damage to Aircraft & EDP/Automated Equipment Failure, FOC - Flight Operation and Crewing, MIS  - Miscellaneous, PB - Passenger and Baggage, RCY – Reactionary, TAE - Technical and Aircraft Equipment, WEA – Weather.

Yes

No

JLGAMDY_AMEND_NO

varchar(40)

NOT NULL

Amendment Number

Yes

No

JLGAMDY_DELAY_DESC

varchar(80)

NULL

Delay Description as specified by the User

No

No

JLGAMDY_AIRCRAFTCODE

varchar(40)

NULL

Aircraft Reg Number

No

No

JLGAMDY_DELAY_CATEGORY

varchar(25)

NULL

Delay Category as specified by the user

No