CM_RMVRSN_REMOVAL_REASONS
This is a component maintenance reference table that stores reasons for component removal or replacement. It ensures consistent reasoning and coding for component removal/replacement in transaction-level maintenance activities.
Process: MAINTPLANNING · Component: BASCm · Table type: Master Table Category: Organize the table related to the Aircraft Maintenance Execution ( AME ) package which tracks part consumption, resources, materials, component removals and component replacement.
This table is the canonical store for the RemovalReason entity.
Primary key
RMVRSN_REASON_CODE, RMVRSN_OUINSTANCE
Columns (14)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | RMVRSN_OUINSTANCE 🔑 | #N/A | OUInstance |
| 2 | RMVRSN_REASON_CODE 🔑 | varchar | Represents the Various Reasons for Removal of a Component from the Aircraft |
| 3 | RMVRSN_DESC | varchar | Description of the Reason for Removal |
| 4 | RMVRSN_DESC_UP | varchar | Description of Reason for Removal in Upper Case for Oracle Conversion |
| 5 | RMVRSN_STATUS | varchar | Removal Reason Status Which Takes Value Either Active or Inactive |
| 6 | RMVRSN_CATEGORY | Varchar | Reason Category is to Categorize Various Reasons Identified |
| 7 | RMVRSN_CREATED_BY | varchar | The User Who Created the Record |
| 8 | RMVRSN_CREATEDDATE | datetime | Date at Which the Reason for Removal is Created |
| 9 | RMVRSN_MODIFIED_BY | varchar | The User Who Modified the Record |
| 10 | RMVRSN_MODIFIEDDATE | datetime | Date at Which the Reason for Removal is Modified |
| 11 | RMVRSN_TIMESTAMP | #N/A | Timestamp |
| 12 | RMVRSN_RELANALYIS | varchar | To Store the Reliability Analysis with Values RE Required NREQ Not Required |
| 13 | RMVRSN_REMTYPE | varchar | To Store the Removal Type with Values SCH Scheduled UNSCH Unscheduled OTH Others |
| 14 | RMVRSN_BASISREMOVAL | varchar | To Store the Basic Removal with Values Y Yes N No |
Sample rows (from live DB)
RMVRSN_OUINSTANCE | RMVRSN_REASON_CODE | RMVRSN_DESC | RMVRSN_DESC_UP | RMVRSN_STATUS | RMVRSN_CATEGORY |
|---|---|---|---|---|---|
| 2.0 | 1 | 123345 | 123345 | A | — |
| 2.0 | BIRD HIT | Removed due to Bird Hit Damage | REMOVED DUE TO BIRD HIT DAMAGE | A | — |
| 2.0 | FOD | Removal due to FOD | REMOVAL DUE TO FOD | A | — |
Showing 3 of 18 rows.