Data Dictionary - Engineering Service Request
Table Name esr_esreq_engg_service_req
Table Comment This Table maintains the Engineering Service Request details
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
esreq_ouinstance	decimal(10)	NOT NULL	ESR OUinstance	Yes	No
esreq_esr_no	varchar(40)	NOT NULL	Engineering Service Request Number	Yes	No
esreq_num_type	varchar(5)	NULL	Numbering Type Number for &nbspTransaction Type "Engg Service Request "	No	No
esreq_user_status	varchar(25)	NULL	User status - These are quick codes defined by the user	No	No
esreq_req_status	varchar(5)	NOT NULL	ESR Status. Can be Fresh, Confirmed, Closed, Response Declined or Preclosed. Fresh                          -  &nbspF Cancelled                   -  &nbspC Closed                        -  &nbspCL Confirmed                   -  &nbspCO PreClosed                   -  &nbspPC Response Declined    -  &nbspRD	No	No
esreq_subject	varchar(150)	NULL	Subject - Description engineering service request	No	No
esreq_req_cat	varchar(25)	NULL	ESR Category. Quick Codes in Active Status for   "Request category " in the Engg Service Request Component	No	No
esreq_ata_no	varchar(16)	NULL	ATA Chapter Numbers defined in aircraft component	No	No
esreq_applicability	varchar(5)	NULL	Applicability Can have values "Aircraft","Component" and "Engine" Aircraft            -   &nbspA Component     -   &nbspC Engine            -   &nbspE	No	No
esreq_priority	decimal(10)	NULL	Descritpion of Priority Codes defined in &nbspCommon Master	No	No
esreq_ac_reg_no	varchar(30)	NULL	Aircraft Registration Number	No	No
esreq_position_code	varchar(25)	NULL	Position Code of the Part in the Aircraft	No	No
esreq_zone	varchar(15)	NULL	The zone in which the maintenance action is being performed	No	No
esreq_body_station		NULL	Body Station	No	No
esreq_component_id	varchar(90)	NULL	Component Id	No	No
esreq_serial_no	varchar(40)	NULL	Serial Number of the Component	No	No
esreq_part_no	varchar(40)	NULL	Part number of the Component	No	No
esreq_problem_desc	varchar(2000)	NOT NULL	Problem Description	No	No
esreq_backgrd_det	varchar(2000)	NULL	Background Details if any	No	No
ESREQ_BACKGRD_DET_U	varchar(255)	NULL	Back ground detail	No	No
esreq_ref_wo_no	varchar(18)	NULL	Workorder Number	No	No
esreq_discrepancy_item	varchar(40)	NULL	Discrepancy Item	No	No
esreq_maint_rpt_no	varchar(18)	NULL	Main Report Number	No	No
ESREQ_MAINT_RPT_OU	decimal(10)	NULL	Maintenance report created ou.	No	No
esreq_ref_doc_no1	varchar(40)	NULL	Reference Document Number 1	No	No
esreq_ref_doc_no2	varchar(40)	NULL	Reference Document Number 2	No	No
esreq_comments	varchar(255)	NULL	Any Comments	No	No
esreq_preclose_comments	varchar(255)	NULL	Preclose Comments	No	No
ESREQ_DECLINING_COMMENTS	varchar(255)	NULL	Decline comments	No	No
esreq_work_centre	varchar(30)	NULL	Work Centre	No	No
esreq_req_station_no	varchar(32)	NULL	Requestor Station Number	No	No
esreq_work_phone_no	varchar(70)	NULL	Work Phone Number	No	No
esreq_emp_code	varchar(20)	NULL	Employee Code	No	No
esreq_emp_name	varchar(77)	NULL	Employee Name	No	No
ESREQ_EMP_NAME_U	varchar(150)	NULL	Employee name stored in upper	No	No
esreq_email	varchar(75)	NULL	Email	No	No
esreq_other_details	varchar(255)	NULL	Other Details	No	No
esreq_created_by	varchar(30)	NOT NULL	Created By user	No	No
esreq_createddate	datetime	NOT NULL	Record ESR Creation Date	No	No
esreq_modified_by	varchar(30)	NOT NULL	Last Modified By user	No	No
esreq_modifieddate	datetime	NOT NULL	Record Last Modified Date	No	No
esreq_confirmed_by	varchar(30)	NULL	COnfirmed By user	No	No
esreq_confirmeddate	datetime	NULL	Record Confirmed Date	No	No
esreq_timestamp	decimal(10)	NOT NULL	Timestamp for concurrency check	No	No
ESREQ_FILENAME	varchar(50)	NULL	File Name being attached	No	No
esreq_wf_new_state	varchar(10)	NULL	work flow new status	No	No
esreq_wf_doc_key	varchar(128)	NULL	Work Flow document key	No	No
ESREQ_REF_WO_TYPE	char(5)	NULL	Work Order Type	No	No
Table Name esr_esrref_reference_details
Table Comment Reference detail Table For ESR
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
esrref_doc_type	varchar(15)	NOT NULL	Type of the Reference Document. Values fetched from Common Master Component.	Yes	No
esrref_remarks	varchar(255)	NULL	Remarks if any	No	No
esrref_file_name	varchar(50)	NULL	File Name being attached	No	No
esrref_ouinstance	decimal(10)	NOT NULL	ESR OUinstance	Yes	Yes
esrref_doc_id	varchar(40)	NOT NULL	Document Id	Yes	No
esrref_esr_no	varchar(40)	NOT NULL	Engineering Service Request Number	Yes	Yes
Table Name esr_parameter_details
Table Comment Meta Data for ESR component
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	Yes	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	Yes	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.	Yes	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.	Yes	No
Langid	decimal(10)	NOT NULL	Language Id	No	No
ParamDesc	varchar(80)	NOT NULL	Description of the combo value	No	No
Creationdate	datetime	NOT NULL	Creation Date	No	No
Table Name esr_quick_code
Table Comment Quick Code Table For ESR
Table Column Name	Table Column Datatype	Table Column Null Option	Table Column Comment	Table Column Is PK	Table Column Is FK
esr_ouinstance	decimal(10)	NOT NULL	ESR OUInstance	Yes	No
esr_quick_code	varchar(25)	NOT NULL	Quick Code	Yes	No
esr_type		NOT NULL	Type - "Request Category" or " User Status" Request Category    -   &nbspR User Status              -   &nbspU	Yes	No
esr_description	varchar(150)	NOT NULL	Description	No	No
esr_status	varchar(5)	NOT NULL	Status of the Quick Code - Active or Inactive Active       -  &nbspA InActive    -  &nbspI	No	No
esr_created_by	varchar(30)	NOT NULL	Created By	No	No
esr_creationdate	datetime	NOT NULL	Creation Date	No	No
esr_modified_by	varchar(30)	NOT NULL	Last Modified By	No	No
esr_modifieddate	datetime	NOT NULL	Last Modified Date	No	No
esr_timestamp	decimal(10)	NOT NULL	Timestamp	No	No