BasProcOccRep

Table Owner	Table Name	Table Comment	Table Column Name	Table Column Datatype	Table Column Comment	Table Column Is PK	Table Column Is FK
dbo	Ocp_OcpEmp_Employee_Dtl	This table is Used to store the employee information of the occurence 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 Occurence Report and Occurence processing Documents	ocphdr_ouinstance	numeric(10)	This is the ouinstance in which occurence report document is created
			ocphdr_occrep_no	varchar(40)	This field holds the occurence report number
			ocphdr_num_type	varchar(5)	stores the numbering type no for the occurence 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 occurence type The occurence 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 occurence
			ocphdr_occ_datetime	datetime	This field holds the date and time of occurence
			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 unavial time
			ocphdr_est_unavl_time_cust		Estimated  unavial 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)	occurence account
			ocrhdr_file_name	varchar(50)	Occurence 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 occurence report  is processed
			ocphdr_App_comments	varchar(255)	This field holds th 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 occurence report  is created
			ocphdr_createdby	varchar(30)	This field  holds  the user who created  the occurence report
			ocphdr_modifieddate	datetime	This field   holds the date when the occurence report  is modified
			ocphdr_modified_by	varchar(30)	This field  holds  the user who modified  the occurence report
			ocphdr_confirmeddate	datetime	This field   holds the date when the occurence report  is confirmed
			ocphdr_confirmed_by	varchar(30)	This field  holds  the user who  confirmed  the occurence report
			ocphdr_approveddate	datetime	This field   holds the date when the occurence report  is approved
			ocphdr_approved_by	varchar(30)	This field  holds  the user who approved  the occurence report
			ocphdr_processeddate	datetime	This field   holds the date when the occurence report  is processed
			ocphdr_processed_by	varchar(30)	This field  holds  the user who  processed  the occurence 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 occurence processing Document	ocpinc_incident_no	varchar(16)	This field holds the incient number
			ocpinc_remarks	varchar(255)	This field holds the Incient remarks
	Ocp_Ocpopt_Setoption_Info	Stores the set option details defined for the occurence report and occurence 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 Occurence Related PDR Discription
			ocpopt_num_type_tech_disc		Store the Numbering Type for Occurence Related Tech. Log Discription
			ocpopt_ocr_time_zone	varchar(20)	Store the default time zone for occurence reporting
			ocpopt_ocp_time_zone		Store the default time zone for occurence Processing
			ocpopt_disc_rec_status		Store the Discreipancy record status for occurence 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 Occurence Report and Occurence 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.