Occurrence Processing

dbo

Ocp_OcpEmp_Employee_Dtl

This table is Used to store the employee information of the occurrence processing Document

ocpemp_emp_no

varchar(20)

This field holds the employee number

No

No

ocpemp_duty

varchar(5)

This field holds the  employee duty. The duty  maintained are 1)Pilot (P) 2)Co-pilot (CP) 3)Mechanic (M) 4)Others (O)

ocpemp_schedule

This field holds the employee schedule. The schedules maintained are 7,14, 28, 35

ocpemp_cons_days_worked

varchar(25)

This fields  holds the consecutive days worked

ocpemp_overtime

varchar(5)

This fields  holds the overtime Flag The List of values are 1.(Y)es 2.(N)o

ocpemp_remarks

varchar(255)

This field holds the remarks

Ocp_Ocphdr_Occ_Report_Hdr

This table is used to  Store the Information Of the Occurrence Report and Occurrence processing Documents

ocphdr_ouinstance

numeric(10)

This is the ouinstance in which occurrence report document is created

ocphdr_occrep_no

varchar(40)

This field holds the occurrence report number

ocphdr_num_type

varchar(5)

stores the numbering type no for the occurrence report

ocphdr_user_status

varchar(25)

This field   holds the User status  -  All active quick codes under quick code type User Status

ocphdr_occ_type

varchar(5)

This field holds occurrence type The occurrence types  maintained are 1)Aircraft Related (AR) 2)Personnel Related (PR) 3)Spill (SP) 4)Tool / Equipment (TE) 5)Vehicle Related (VR) 6)Scheduled Maintenance (SM) 7)Unscheduled Maintenance.(UM)

OCPHDR_STATUS

This field holds occurrence status The occurrence status  can be 1)Fresh (F) 2)Confirmed (CN) 3)Cancelled (C) 4)Approved (A) 5)Processed (P)

ocphdr_occ_location

varchar(16)

This field holds the location of occurrence

ocphdr_occ_datetime

datetime

This field holds the date and time of occurrence

ocphdr_business_unit

varchar(25)

This field holds all the values defined for the QuickCodeType as "Business Unit" in the Common Master component

ocphdr_cust_call_sign

varchar(20)

This field holds the customer call sign

ocphdr_aog_flag

varchar(5)

This field holds the Aircraft on Ground Flag The List of values are 1.(Y)es 2.(N)o

ocphdr_personnel_injury

This field holds the Personnel Injury Involved Flag The List of values are 1.(Y)es 2.(N)o

ocphdr_property_damaged

This field holds the Property Damaged flag The List of values are 1.(Y)es 2.(N)o

ocphdr_emerg_proc_perform

This field holds the Emergency  Procedure Performed flag The List of values are 1.(Y)es 2.(N)o

ocphdr_reporting_station

varchar(32)

This field holds the reporting station

ocphdr_reported_by

varchar(20)

This field holds the reported by

ocphdr_ac_regno

varchar(30)

This field holds the aircraft registration number

ocphdr_base_wc

This field holds the workcenter

ocphdr_no_of_pax

numeric(6)

number of passengers

ocphdr_fuel_on_board

numeric(28)

fuel on board

ocphdr_central_Gravity

central gravity

ocphdr_toff_gross_weight

Take off gross weight

ocphdr_est_ac_unavl

varchar(11)

Estimated aircraft unavail time

ocphdr_est_unavl_time_cust

Estimated  unavail time to customer

ocphdr_ac_replaced

varchar(5)

This field holds the  aircraft replaced flag The List of values are 1)Yes (Y) 2)Not Required (NR) 3)None Avaliable(NA)

ocphdr_replaced_datetime

datetime

This field holds the aircraft replaced date and time

ocphdr_replaced_ac_regno

varchar(30)

Replaced aircraft registration number

ocphdr_occ_during

varchar(5)

This field holds the Occurrence Occurred During The List of values are 1)Pilot Activity (PA) 2)AMT Activity (AA) 3)Others.(O)

ocphdr_discrepancy_no

varchar(40)

This field holds the discrepancy number

ocphdr_phase_of_opns

varchar(5)

This field holds the phase of operation 1)If Occurrence Occurred During is Pilot Activity then load the combo Phase of Operations with the values: Pre-Flight, Pax Loading,Baggage Loading, Start, Before T/O, Hovering, During T/O, Climb, Cruise, Descent, Go Around, Landing - Normal, Landing - Precaut., Landing - Autorot., Landing - OEI, After Landing, Shut Down, Post Flight, Tied Down, IFR, Sling, Ground Run, Ops Chk-flt, Ground Handling, Routine Maint., Parts Handling, Fueling, Driving, Others 2)If Occurrence Occurred During is  ’AMT Activity’ or ’Others’,  then load the combo Phase of Operations with the values: Pre-Flight,  Start, Shut Down, Post Flight, Tied Down, Ground Run, Ground Handling, Routine Maint., Parts Handling, Fueling, Driving, Others

ocphdr_occ_Account

varchar(2000)

occurrence account

ocrhdr_file_name

varchar(50)

Occurrence file name

ocphdr_ac_rel_maint

datetime

This field holds the date and time of aircraft reliability maintenance

ocphdr_proc_ouinstance

numeric(10)

This is the ouinstance in which occurrence report  is processed

ocphdr_App_comments

varchar(255)

This field holds the Approver Comments

ocphdr_preventable

varchar(5)

This field holds the preventable  Flag The List of values are 1.(Y)es 2.(N)o

ocphdr_cust_ac_lost_time

varchar(11)

This field holds the Customer Aircraft Lost Time

ocphdr_app_file_name

varchar(50)

This field holds the approval file name

ocphdr_occ_cate

varchar(25)

This field holds  with all the values defined for the QuickCodeType as "Occurrence Category" in the Common Master component

ocphdr_rca_ref_no

varchar(40)

This field holds the root cause analysis reference  number

ocphdr_occ_class_acci

varchar(5)

This field holds the occurrence Classification --Accident

ocphdr_occ_class_air

This field holds the occurrence Classification --AIR

ocphdr_occ_class_mmir

This field holds the occurrence Classification --MMIR

ocphdr_occ_class_sdr

This field holds the occurrence Classification -SDR

ocphdr_occ_class_ccall

This field holds the occurrence Classification --Close Call

ocphdr_occ_class_hazard

This field holds the occurrence Classification -- Hazard

ocphdr_occ_class_others

This field holds the occurrence Classification --Others

ocphdr_proc_comments

varchar(255)

This field holds the  process comments

ocphdr_cust_report

varchar(5)

This field holds the customer reportable flag The List of values are 1.(Y)es 2.(N)o

ocphdr_faa_report

This field holds the FAA reportable flag The List of values are 1.(Y)es 2.(N)o

ocphdr_proc_file_name

varchar(50)

This field holds the  process file name

ocphdr_wf_doc_key

varchar(40)

stores the document key for the purpose of work flow

OCPHDR_NEW_STATE

varchar(25)

Holds the state of occurrence after workflow.

ocphdr_createddate

datetime

This field   holds the date when the occurrence report  is created

ocphdr_createdby

varchar(30)

This field  holds  the user who created  the occurrence report

ocphdr_modifieddate

datetime

This field   holds the date when the occurrence report  is modified

ocphdr_modified_by

varchar(30)

This field  holds  the user who modified  the occurrence report

ocphdr_confirmeddate

datetime

This field   holds the date when the occurrence report  is confirmed

ocphdr_confirmed_by

varchar(30)

This field  holds  the user who  confirmed  the occurrence report

ocphdr_approveddate

datetime

This field   holds the date when the occurrence report  is approved

ocphdr_approved_by

varchar(30)

This field  holds  the user who approved  the occurrence report

ocphdr_processeddate

datetime

This field   holds the date when the occurrence report  is processed

ocphdr_processed_by

varchar(30)

This field  holds  the user who  processed  the occurrence report

ocphdr_timestamp

numeric(10)

This field   holds the  integer value which identifies if any change has been made to the record. -- the first time the  document is created , the timestamp value is 1, -- the next time any change is made  to the record ,increment it by 1.

ocphdr_atanumber

varchar(16)

This field  holds  the ata number for the discrepancy associated with the occurrence report.

ocphdr_discrepancy_desc

varchar(255)

This field  holds  the description of the discrepancy associated with the occurrence report.

ocphdr_fault_no

varchar(25)

This field  holds  the fault number for the discrepancy associated with the occurrence report.

OCPHDR_APPROVING_USER

varchar(30)

OCPHDR_PROCESSING_USER

OCPHDR_UTC_OCC_DATETIME

datetime

OCPHDR_UTC_REP_DATETIME

OCPHDR_UTC_AC_REL_MAINT

OCPHDR_OCC_TIMEZONE

varchar(25)

OCPHDR_FLIGHT_DEVIATION

varchar(5)

ocphdr_frz_ac_regno

OCPHDR_NATOFCOND

varchar(25)

OCPHDR_REASON

OCPHDR_PRECPROC

Ocp_OcpInc_Incident_Dtl

This table is Used to store the incident  information of the occurrence processing Document

ocpinc_incident_no

varchar(16)

This field holds the incident number

ocpinc_remarks

varchar(255)

This field holds the Incident remarks

Ocp_Ocpopt_Setoption_Info

Stores the set option details defined for the occurrence report and occurrence processing documents

ocpopt_ouinstance

numeric(10)

Stores the OUInstance where the set option record is created

ocpopt_num_type_pdr_disc

varchar(25)

Store the Numbering Type for Occurrence Related PDR Description

ocpopt_num_type_tech_disc

Store the Numbering Type for Occurrence Related Tech. Log Description

ocpopt_ocr_time_zone

varchar(20)

Store the default time zone for occurrence reporting

ocpopt_ocp_time_zone

Store the default time zone for occurrence Processing

ocpopt_disc_rec_status

Store the Discrepancy record status for occurrence approval

ocpopt_created_date

datetime

This field holds the created date of the record

ocpopt_created_by

varchar(40)

This field holds the user who created the record

ocpopt_modified_date

datetime

This field holds the modified date of the record

ocpopt_modified_by

varchar(30)

This field holds the user who modified the record

ocpopt_timestamp

numeric(10)

This field holds the timestamp value

Ocp_Ocpprm_Parameter_Dtl

This table used to Store the Parameter Details of the Occurrence Report and Occurrence Processing Documents

ocpprm_componentname

varchar(150)

This field holds the Name of the component.

ocpprm_paramcategory

varchar(10)

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.

ocpprm_paramtype

varchar(25)

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.

ocpprm_paramcode

varchar(5)

This is the code that may be used for data storage. This is valid only incase of combo boxes. Here the short code that will be stored as data in the transaction could be maintained.

ocpprm_Langid

numeric(10)

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

ocpprm_paramdesc

varchar(80)

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

ocpprm_sort_by

numeric(10)

This field holds the default sort by code

ocpprm_creationdate

datetime

This field holds the record created date for auditing purpose.