Corrective Action Plan
This table shows the Infor LN table from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| qmcpl100 | Corrective Action Plan |
This table shows the attribute mapping to LN table fields for the dimension:
| Attribute | Mapping |
|---|---|
| Approved Date | qmcpl100.apdt |
| Approver | qmcpl100.appr |
| Canceled Date | qmcpl100.cndt |
| Category | qmcpl100.catg |
| Category Desc | qmcpl100.dsca |
| Closed Date | qmcpl100.cmdt |
| Company | qmcpl100.compnr |
| Completion Date | qmcpl100.codt |
| Corrective Action Plan | qmcpl100.capn |
| Corrective Action Plan Desc | qmcpl100.dsca |
| Corrective Action Plan ID Desc | qmcpl100.capn + qmcpl100.dsca |
| Corrective Action Plan Status | qmcpl100.stat |
| Corrective Action Plan Status Filter | qmcpl100.stat |
| Corrective Action Plan Status Sort | qmcpl100.stat |
| Created by User | qmcpl100.cusr |
| Creation Date | qmcpl100.crdt |
| Due Date | qmcpl100.dudt |
| Due Date for Effectiveness | qmcpl100.efdt |
| E-Item Revision | qmcpl100.revi |
| Effectiveness is Verified | qmcpl100.ecpv |
| Effectiveness is Verified Filter | qmcpl100.ecpv |
| Effectiveness is Verified Sort | qmcpl100.ecpv |
| Effectivity Unit | qmcpl100.effn |
| Is Current | 1 if latest record, else 0 |
| Is Effective | qmcpl100.cpef |
| Is Effective Filter | qmcpl100.cpef |
| Is Effective Sort | qmcpl100.cpef |
| Modified Date | qmcpl100.modt |
| Other Method | qmcpl100.psmo |
| Problem Solving Method | qmcpl100.pbsm |
| Problem Solving Method Filter | qmcpl100.pbsm |
| Problem Solving Method Sort | qmcpl100.pbsm |
| RCA Document Number | qmcpl100.rcad |
| Review Board | qmcpl100.mrcb |
| Submitted Date | qmcpl100.sudt |
| Supplier Corrective Action Plan | qmcpl100.scap |
| Supplier Corrective Action Plan Filter | qmcpl100.scap |
| Supplier Corrective Action Plan Sort | qmcpl100.scap |
| Supplier Corrective Action Plan Status | qmcpl100.scas |
| Supplier Corrective Action Plan Status Filter | qmcpl100.scas |
| Supplier Corrective Action Plan Status Sort | qmcpl100.scas |
| deleted | 1 if deleted in LN, else 0 |
| Unknown | 1 for null records, else 0 |
| Customer Defined Fields | Standard list of fields |