{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":6106,"path":"customer-service-management/create-case-review-field-mapping.md","title":"Create a case digest table map","bundle":null,"doc_type":null,"release":"australia","body":"\n# Create a case digest table map\n\nCreate a table map to configure the fields that are copied from the case record to the post case review or the case action summary records.\n\n## Before you begin\n\nRole required: admin\n\n## About this task\n\nTwo table maps are included with the Case Digests plugin. The **PCR Map** uses the Case \\(sn\\_customerservice\\_case\\) table as the source table and the Post Case Review \\(sn\\_csm\\_case\\_digest\\_pcr\\) table as the target table. The **PCR Map** maps the following fields.\n\n|Case field|Post Case Review field|\n|----------|----------------------|\n|sys\\_id|Case number|\n|Short description|Short description|\n|Cause|Root Cause Analysis|\n|Close notes|Solution provided|\n\nThe **CAS Map** uses the Case \\(sn\\_customerservice\\_case\\) table as the source table and the Case Action Summary \\(sn\\_csm\\_case\\_digest\\_cas\\) table as the target table. The **CAS Map** maps the following fields.\n\n|Case field|Case Action Summary field|\n|----------|-------------------------|\n|sys\\_id|Case number|\n|Short description|Short description|\n\n## Procedure\n\n1. To access the CSM Table Map list, navigate to **csm\\_table\\_map\\_list.do**.\n\n2. Click **New** to create a new table map.\n\n You can also modify an existing table map by clicking the map name to open the map form.\n\n3. Fill in the following fields on the CSM Table Map form.\n\n\n
\n\nField\n\n\n\nDescription\n\n
\n\nMapping name\n\n\n\nThe table map name.\n\n
\n\nApplication\n\n\n\nRead only. The application for this table map.\n\n
\n\nAPI Name\n\n\n\nRead only. The API for this table map.\n\n
\n\nAdvanced Field Mapping\n\n\n\nEnables advanced field mapping.\n\n
\n\nSource Table\n\n\n\nThe source table for the map.\n\n
\n\nTarget Table\n\n\n\nThe target table for the map.\n\n
\n\nActive\n\n\n\nEnables the mapping from the source to the target tables.\n\n
\n\nUse Advanced Condition\n\n\n\nEnables advanced condition mapping, which uses a script. If enabled, add a script in the **Advanced Condition** field.\n\n
\n\nAdvanced Condition\n\n\n\nThe script to use if the **Use Advanced Condition** field is enabled.\n\n
\n\nConditions\n\n\n\nUse the condition builder to select the conditions that apply to the table map.\n\n
\n\nOrder\n\n\n\nOrder of priority for processing multiple matching map definitions simultaneously to resolve dependencies. - If there is only one matching table map, the system uses that map.\n- If there are multiple matching table maps with the same order, the system uses the map with the older created date.\n- If there are multiple matching table maps with different orders, the system uses the map with the highest order.\n\n\n
4. Click **Submit**.\n\n5. From the CSM Table Map list, select the table map created in step 2.\n\n6. In the Basic Field Mapping form section, click **New**.\n\n7. Select a **Source Field** and a **Target Field**.\n\n8. Enable the **Active** check box.\n\n9. Enter a number in the **Order** field\n\n10. Click **Submit**.\n\n11. Repeat steps 7 through10 for each field to be mapped.\n\n12. Click **Update** on the CSM Table Map form.\n\n\n"}}