swo_swoccm_com_certificate_dtl
Maintains detailed records of certificates related to maintenance activities performed. It ensures that all maintenance actions meet regulatory and quality standards
Process: COMPMAINTENANCE · Component: BasSWO · Table type: Transaction Table Category: Regulatory compliance and certification management for aviation maintenance activities. This category ensures all maintenance work meets stringent aviation industry standards and regulatory requirements from authorities like DGCA, FAA, and EASA. It manages various types of certificates including maintenance certificates, conformity certificates, and regulatory compliance documentation, maintaining complete audit trails for certification processes and ensuring airworthiness standards are met.
This table is the canonical store for the SWOCertCom entity.
Primary key
swoccm_unqiue_id
Columns (10)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | swoccm_certificate_id | varchar | Unique identifier for the certificate. |
| 2 | swoccm_certificate_mode | varchar | Mode of the certificate (e.g., digital, physical). |
| 3 | swoccm_certificate_type | varchar | Type of certificate issued. |
| 4 | swoccm_certifying_authority | varchar | Authority issuing the certificate. |
| 5 | swoccm_created_by | varchar | User who created the certificate record. |
| 6 | swoccm_created_date | datetime | Timestamp when the certificate was created. |
| 7 | swoccm_modified_by | varchar | User who last modified the certificate record. |
| 8 | swoccm_modified_date | datetime | Timestamp of the last modification. |
| 9 | SWOCCM_ouinstance | int | Organizational unit instance associated with the certificate. |
| 10 | swoccm_unqiue_id 🔑 | int | System-generated unique ID for internal tracking. |
Relationships (1)
- ShopWorkOrder (swo_swoh_shop_wo_hdr) →
SWO_HAS_CERTIFICATE(this table is target)- Join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swoccm_com_certificate_dtl.swoccm_swo_no - SWO has certificate of maintenance
- Join:
Sample rows (from live DB)
swoccm_certificate_id | swoccm_certificate_mode | swoccm_certificate_type | swoccm_certifying_authority | swoccm_created_by | swoccm_created_date |
|---|---|---|---|---|---|
| COM-000098-2013 | 1 | EASA | — | DMUSER | 2013-04-20 15:06:12.510 |
| COM-000098-2013 | 1 | — | EASA | DMUSER | 2013-04-20 15:06:13.190 |
| COM-000099-2013 | 1 | EASA | — | DMUSER | 2013-04-29 13:39:33.747 |
Showing 3 of 1,594 rows.