| BPR31REGUSER |
rs_afmd_ac_fleet_map_det |
Aircraft and Fleet Mapping Details |
afmd_ouinstance |
decimal(38) |
Reliability Setup OU Instance |
Yes |
Yes |
| |
|
|
afmd_calendar_code |
varchar(16) |
Reliability Calendar Code |
|
|
| |
|
|
afmd_fleet |
varchar(20) |
Fleet Number |
|
|
| |
|
|
afmd_seq_no |
decimal(38) |
Sequence number to identify unique |
|
No |
| |
|
|
afmd_ac_regno |
varchar(30) |
Aircraft Registration Number |
|
|
| |
|
|
afmd_ac_regno_ou |
decimal(38) |
Aircraft Number Created OU |
No |
|
| |
|
|
afmd_map_status |
varchar(15) |
Mapping Status
F- Fresh
A- Associated
C - Cancelled / Removed |
|
|
| |
|
|
afmd_map_eff_from_date |
datetime |
Mapping Effective From Date
An Aircraft can be mapped to only one fleet in any calendar period |
|
|
| |
|
|
afmd_map_eff_to_date |
|
Effective To Date |
|
|
| |
|
|
afmd_ac_modelno |
varchar(18) |
Aircraft Model Number |
|
|
| |
|
|
afmd_created_by |
varchar(30) |
Created By user |
|
|
| |
|
|
afmd_created_date |
datetime |
Created Date |
|
|
| |
|
|
afmd_modified_by |
varchar(30) |
Modified By user |
|
|
| |
|
|
afmd_modified_date |
datetime |
Record Modified Date |
|
|
| |
|
|
afmd_timestamp |
decimal(38) |
Time Stamp - for internal purpose |
|
|
| |
rs_afms_ac_fleet_map_sum |
AC Fleet Mapping Details for Each Month |
afms_ouinstance |
|
Reliability Setup OU Instance |
Yes |
|
| |
|
|
afms_fleet |
varchar(20) |
Fleet Number |
|
|
| |
|
|
afms_ac_regno |
varchar(30) |
Aircraft Reg Number |
|
|
| |
|
|
afms_calendar_code |
varchar(16) |
Calendar Code |
|
|
| |
|
|
afms_month |
decimal(38) |
Month in Number |
|
|
| |
|
|
afms_year |
|
Year in Number |
|
|
| |
|
|
afms_seq_no |
|
Sequence Number |
No |
|
| |
|
|
afms_ac_regno_ou |
|
Aircraft Reg OU |
|
|
| |
rs_ccd_calendar_code_det |
Relaibility Calendar Details |
ccd_period_no |
decimal(10) |
Calendar Period Number |
Yes |
|
| |
|
|
ccd_valid_from_month_year |
datetime |
Calendar Period Valid From Month and Year |
No |
|
| |
|
|
ccd_valid_to_month_year |
|
Calendar Period Valid To Month and Year |
|
|
| |
|
|
ccd_calendar_code |
varchar(16) |
Calendar Code |
Yes |
Yes |
| |
|
|
ccd_ouinstance |
decimal(38) |
Reliability Setup OU Instance |
|
|
| |
rs_cch_calendar_code_hdr |
Reliability Calendar Codes Header |
cch_ouinstance |
|
|
|
No |
| |
|
|
cch_calendar_code |
varchar(16) |
Calendar Code |
|
|
| |
|
|
cch_calendar_desc |
varchar(150) |
Calendar Description |
No |
|
| |
|
|
cch_calendar_desc_upper |
|
Calendar Description in Upper |
|
|
| |
|
|
cch_valid_from_month_year |
datetime |
Calendar Valid From Month and Year |
|
|
| |
|
|
cch_valid_to_month_year |
|
Calendar Valid To Month and Year |
|
|
| |
|
|
cch_number_of_periods |
varchar(20) |
Total Number of Periods in a Calendar |
|
|
| |
|
|
cch_peeriod_duration_months |
decimal(38) |
Period Duration in Months |
|
|
| |
|
|
cch_remarks |
varchar(255) |
Calendar Remarks |
|
|
| |
|
|
cch_created_by |
varchar(30) |
record Created By User |
|
|
| |
|
|
cch_created_date |
datetime |
Record Created Date |
|
|
| |
|
|
cch_modified_by |
varchar(30) |
Record Last Modified By |
|
|
| |
|
|
cch_modified_date |
datetime |
Record last Modification Date |
|
|
| |
|
|
cch_timestamp |
decimal(38) |
Record Time Stamp - for internal purpose |
|
|
| |
rs_cfm_calendar_fleet_map |
Reliability Calendar to Fleet Mapping |
cfm_created_date |
datetime |
Record Created Date |
|
|
| |
|
|
cfm_created_by |
varchar(30) |
Record Created By |
|
|
| |
|
|
cfm_map_confirm_date |
datetime |
Mapping Confirmation Date |
|
|
| |
|
|
cfm_modified_by |
varchar(30) |
Last Modified BY |
|
|
| |
|
|
cfm_modified_date |
datetime |
Last Modified Date |
|
|
| |
|
|
cfm_timestamp |
decimal(38) |
Record Timestamp - for internal purpose |
|
|
| |
|
|
cfm_calendar_code |
varchar(16) |
Calendar Code |
Yes |
Yes |
| |
|
|
cfm_ouinstance |
decimal(38) |
Reliability setup OU Instance |
|
|
| |
|
|
cfm_map_confirm_by |
varchar(30) |
Mapping Confirmed by user id |
No |
No |
| |
|
|
cfm_status |
varchar(20) |
Calendar , Fleet Mapping Status
F- Fresh
A- Confirmed /Authorized
C - Cancelled
L - Closed |
|
|
| |
|
|
cfm_fleet |
|
Fleet Number |
Yes |
Yes |
| |
|
|
cfm_remarks |
varchar(150) |
Remarks |
No |
No |
| |
rs_cfps_cal_fleet_per_stat |
Calendar - Fleet, Period Status |
cfps_period_status |
varchar(15) |
Fleet to Period mapping Status
F- Fresh
C - Confirmed |
|
|
| |
|
|
cfps_period_no |
decimal(10) |
Calendar Period Number |
Yes |
|
| |
|
|
cfps_created_date |
datetime |
Record Created Date |
No |
|
| |
|
|
cfps_created_by |
varchar(30) |
Record Creted By |
|
|
| |
|
|
cfps_ouinstance |
decimal(38) |
Reliability OU Instance |
Yes |
Yes |
| |
|
|
cfps_fleet |
varchar(20) |
Fleet Number |
|
|
| |
|
|
cfps_calendar_code |
varchar(16) |
Calendar Code |
|
|
| |
rs_fd_fleet_details |
Reliability Setup fleet Details |
fd_ouinstance |
decimal(38) |
Fleet OU Instance |
|
No |
| |
|
|
fd_fleet |
varchar(20) |
Fleet Number |
|
|
| |
|
|
fd_fleet_status |
|
Fleet Status
A - Active
I - Inactive |
No |
|
| |
|
|
fd_fleet_description |
varchar(150) |
Fleet Description |
|
|
| |
|
|
fd_fleet_description_up |
|
Fleet Description in Upper case |
|
|
| |
|
|
fd_remarks |
varchar(255) |
Fleet Remarks |
|
|
| |
|
|
fd_created_by |
varchar(30) |
Record Created BY |
|
|
| |
|
|
fd_created_date |
datetime |
Record Created Date |
|
|
| |
|
|
fd_modified_by |
varchar(30) |
Record last Modified By |
|
|
| |
|
|
fd_modification_date |
datetime |
Record last Moification Date |
|
|
| |
|
|
fd_timestamp |
decimal(38) |
Fleet Timestamp |
|
|
| |
rs_fpm_fleet_planner_map |
Fleet to Planner Mapping |
fpm_ouinstance |
|
Fleet OU Instance |
Yes |
Yes |
| |
|
|
fpm_fleet |
varchar(20) |
Fleet Number |
|
|
| |
|
|
fpm_user_name |
varchar(30) |
Planner User name |
|
No |
| |
|
|
fpm_valid_from_date |
datetime |
Fleet- Planner Valid From Date |
No |
|
| |
|
|
fpm_valid_to_date |
|
Fleet to User Name Valid To Date |
|
|
| |
|
|
fpm_created_by |
varchar(30) |
Record Created By |
|
|
| |
|
|
fpm_created_date |
datetime |
Record Created Date |
|
|
| |
|
|
fpm_modified_date |
|
Record last Modified Date |
|
|
| |
|
|
fpm_modified_by |
varchar(30) |
Record last Modified By |
|
|
| |
|
|
fpm_timestamp |
decimal(38) |
Record TimeStamp - for internal purpose |
|
|
| |
rs_parameter_details |
Component Program Parameter Table |
rs_component_name |
varchar(80) |
Component Name - BASRS |
Yes |
|
| |
|
|
rs_param_code |
varchar(5) |
Param code is the value to be filled in the combo box or guidance text. This is actually the meta data of this component |
|
|
| |
|
|
rs_param_type |
varchar(15) |
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. |
|
|
| |
|
|
rs_param_cat |
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. |
|
|
| |
|
|
rs_langid |
decimal(10) |
language ID |
|
|
| |
|
|
rs_param_desc |
varchar(80) |
Description of the combo value |
No |
|
| |
|
|
rs_prefix_sort_by |
decimal(10) |
The Order of creation of Parameter details |
|
|
| |
|
|
rs_created_date |
char(18) |
Created Date |
|
|
| |
rs_urd_upload_run_det |
Upload Relaibility Batch Run Details |
urd_ouinstance |
decimal(38) |
Reliability Ou Instance |
Yes |
|
| |
|
|
urd_fleet |
varchar(20) |
Fleet Number |
|
|
| |
|
|
urd_calendar_code |
varchar(16) |
Calendar Code |
|
|
| |
|
|
urd_run_type |
varchar(18) |
S- Simulation
U - Upload Records |
No |
|
| |
|
|
urd_remarks |
varchar(255) |
Upload Reliability Records Remarks |
|
|
| |
|
|
urd_run_start_datetime |
datetime |
Upload Reliability Records Run Start Time |
|
|
| |
|
|
urd_run_end_datetime |
|
Upload Reliability Records Run End Time |
|
|
| |
|
|
urd_run_by |
varchar(30) |
Upload Reliability Records Run User Details |
|
|
| |
rs_urs_upload_rel_sum |
Uploaded Data Summary for the Fleet |
urs_ouinstance |
decimal(38) |
Reliability ouinstance |
Yes |
|
| |
|
|
urs_fleet |
varchar(20) |
Fleet Number |
|
|
| |
|
|
urs_calendar_code |
varchar(16) |
Calendar Code |
|
|
| |
|
|
urs_record_type |
varchar(255) |
Reocrd Type
CR - Component Replacement
FL - Flight Log
TL - Tech Log |
|
|
| |
|
|
urs_last_upload_date |
datetime |
Last Uploaded Date - The point till which the data from the History Components Processed and Stored as Summary Information |
No |
|
| |
|
|
urs_modified_date |
|
Record Last Modified Date |
|
|
| |
|
|
urs_modified_by |
varchar(30) |
Record Last Modified By |
|
|
|
rs_usd_upload_sch_det |
Upload Reliability Record |
usd_ouinstance |
decimal(38) |
Reliability OU Instance |
Yes |
|
|
|
|
usd_guid_no |
varchar(40) |
Globally Unique Identifier |
|
|
|
|
|
usd_record_type |
varchar(5) |
Record Type
’Component Replacement’
’Flight Log’ |
No |
|
|
|
|
usd_jobid |
decimal(10) |
Job ID |
|
|
|
|
|
usd_fleetno |
varchar(20) |
Fleet Number |
|
|
|
|
|
usd_calendarNo |
varchar(18) |
Calendar Number |
|
|
|
|
|
usd_sch_start_datetime |
datetime |
Schedule Start Date time |
|
|
|
|
|
usd_act_start_datetime |
|
Actual Start Date Time |
|
|
|
|
|
usd_act_end_datetime |
|
Actual End Date Time |
|
|
|
|
|
usd_job_status |
varchar(5) |
Job Status
’Schedule’
’Completed’
’InProgress’
’Aborted’
’Cancelled’ |
|
|
|
|
|
usd_Remarks |
varchar(225) |
Remarks if any |
|
|
|
|
|
usd_created_date |
datetime |
Created Date |
|
|
|
|
|
usd_created_by |
varchar(30) |
Created By |
|
|
|
|
|
usd_modified_date |
datetime |
Modified Date |
|
|
|
|
|
usd_modified_by |
varchar(30) |
Modified By |
|
|
|
|
|
USD_BATCH_RUN_BY |
|
Batch Run BY |
|
|