swo_swocol_calibration_cert_list
Detail table for Certificate of Calibration facility information. Records facility details for calibration certificates issued to customers as per regulatory requirements from aviation authorities like DGCA (Director General of Civil Aviation) and FAA (Federal Aviation Administration).
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Calibration facility and certificate details
This table is the canonical store for the CalibrationCert entity.
Primary key
swocol_unique_no
Columns (39)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swocol_addln_comm | varchar | Unique record ID. |
| 2 | swocol_as_rec_cond | varchar | Additional comments. |
| 3 | swocol_as_ret_cond | varchar | Condition as received. |
| 4 | swocol_auth_emp_code | varchar | Condition as returned. |
| 5 | swocol_auth_license_no | varchar | Employee code for authorization. |
| 6 | swocol_auth_no | varchar | License number for authorization. |
| 7 | swocol_auth_ref_no | varchar | Authorization number. |
| 8 | swocol_auth_skill_code | varchar | Skill code of authorized employee. |
| 9 | swocol_auth_wc_code | varchar | Work code for the authenticated employee |
| 10 | swocol_cal_date | datetime | Calculation date |
| 11 | swocol_certificate_id | varchar | Certificate ID |
| 12 | swocol_certificate_status | varchar | Certificate status. |
| 13 | swocol_cond_found | varchar | Condition found during inspection. |
| 14 | swocol_corr_action | varchar | Condition action required . |
| 15 | swocol_created_by | varchar | Corrective action required. |
| 16 | swocol_created_date | datetime | Record created by. |
| 17 | swocol_current_flag | varchar | Flag indicating current record (Yes or No). |
| 18 | swocol_cust_asset_no | varchar | Customer asset number. |
| 19 | swocol_filename | varchar | Customer asset number. |
| 20 | swocol_issue_date | datetime | Issue date of document. |
| 21 | swocol_last_printed_on | datetime | Last printed timestamp. |
| 22 | swocol_model_no | varchar | Last printed timestamp. |
| 23 | swocol_modified_by | varchar | User who last modified record. |
| 24 | swocol_modified_date | datetime | Last modification timestamp. |
| 25 | swocol_no_Copies | int | Number of copies. |
| 26 | swocol_ouinstance | int | Organizational unit instance. |
| 27 | swocol_prntoptn | varchar | Print option selected. |
| 28 | swocol_recomm_due_dt | datetime | Recommended due date. |
| 29 | swocol_rel_humidity | varchar | Relative humidity measured during the process. |
| 30 | swocol_rep_certificate | varchar | Replacement certificate identifier. |
| 31 | swocol_swococ_approved_By | varchar | Name or ID of the approver for SWOC/OC. |
| 32 | swocol_swococ_approved_date | datetime | Date on which shop work order created ( SWOC ) or order created ( OC ) was approved. |
| 33 | swocol_swo_event_id | varchar | Identifier for the shop work order event. |
| 34 | swocol_swo_no | varchar | Shop work order number. |
| 35 | swocol_swo_part | varchar | Part number included in the work order. |
| 36 | swocol_swo_serial | varchar | Serial number of the part in the work order. |
| 37 | swocol_temperature | varchar | Temperature recorded during the process. |
| 38 | swocol_timestamp | int | Timestamp of the record. |
| 39 | swocol_unique_no 🔑 | int | Unique identifier for the record. |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_HAS_CALIBRATION_CERT(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocol_calibration_cert_list.swocol_swo_no - SWO has calibration certificate
- Join:
Sample rows (from live DB)
swocol_addln_comm | swocol_as_rec_cond | swocol_as_ret_cond | swocol_auth_emp_code | swocol_auth_license_no | swocol_auth_no |
|---|---|---|---|---|---|
| Serviceable | OUT-OF-TOLERANCE | IN-TOLERANCE | 00000011 | CFM | — |
| Corrosion found in the some… | OUT-OF-TOLERANCE | IN-TOLERANCE | 00000011 | CFM | — |
| All the conditions found ar… | OUT-OF-TOLERANCE | IN-TOLERANCE | 00000011 | CFM | — |
Showing 3 of 6 rows.