DP_DPMRDA_DOC_ATTACH_DTL
Contains references and metadata of documents attached to discrepancy records. Supports linking of manuals, approvals, and evidence files to discrepancies.
Process: LINEMAINTENANCE 路 Component: BasDP 路 Table type: Transaction Table Category: Groups the tables related to the discrepancy details, deferrals, deferral history, deferral categories, and resolution history
Primary key
DPMRDA_DOCATTACH_ID, DPMRDA_DAREF_DOC_TYPE, DPMRDA_MAINT_REPORT_NO, DPMRDA_SLFSRC_OUINSTANCE
Columns (12)
| # | Column | Type | Description |
|---|---|---|---|
| 1 | DPMRDA_SLFSRC_OUINSTANCE 馃攽 | #N/A | Maintains the Organizational Unit number that attached the document to the discrepancy |
| 2 | DPMRDA_MAINT_REPORT_NO 馃攽 | varchar | Maintains the maintenance report number related to the document attachment |
| 3 | DPMRDA_DAREF_DOC_TYPE 馃攽 | varchar | Maintains the document type against which the attachment has been referenced |
| 4 | DPMRDA_DOCATTACH_ID 馃攽 | varchar | Maintains the unique document attachment identifier |
| 5 | DPMRDA_CRT_OUINSTANCE | #N/A | Maintains the Organizational Unit that made the document attachment |
| 6 | DPMRDA_FILE_NAME | varchar | Maintains the filename of the attached document |
| 7 | DPMRDA_REMARKS | varchar | Maintains remarks related to the attached document |
| 8 | DPMRDA_DOC_NAME | varchar | Maintains the document name of the attached document |
| 9 | DPMRDA_CREATED_BY | varchar | Maintains the user ID of the employee who made the attachment |
| 10 | DPMRDA_CREATED_DATETIME | datetime | Maintains the date and time when the document attachment record was made |
| 11 | DPMRDA_MODIFIED_BY | varchar | Maintains the user ID of the person who last modified the attachment record |
| 12 | DPMRDA_MODIFIED_DATETIME | datetime | Maintains the date and time when the document attachment record was modified |