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 Transaction 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 - F Cancelled - C Closed -  CL Confirmed -  CO PreClosed -  PC Response Declined -  RD |
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 - A Component - C Engine - E |
No |
No |
|
esreq_priority |
decimal(10) |
NULL |
Description of Priority Codes defined in Common 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 |
|
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 - R User Status - U |
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 - A InActive - I |
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 |
|
|
|
|
|
|
|