How to add an item to the Telesales Module

Telesales Module here

Example ticket: BIST-8113

1. Query CDSITM_M with the provided pub code to extract the necessary data that will be added to the module:

   SELECT ITM_NUM, ITM_DSC1, OWN_ORG FROM CDSITM_M WHERE ITM_NUM = {PUB_CDE}

    

2. Prepare the INSERT STATEMENT with the data from the previous step:

   INSERT INTO Telesales.dbo.tblPubs (PUB_CDE,PUB_TTL,BIL_ORG) VALUES ('[ITM_NUM]','[ITM_DSC1]','[OWN_ORG]')

   Save as a SQL file
   
   

3. Submit a SQL change request using SQL Change Request Form from here.

   • ATTACH THE SQL FILE FROM THE PREVIOUS STEP TO THE FORM

   • SQL SERVER: MIDWAY - TELESALES

   • MANAGER NAME: RADHIKA SHENOY

   • MANAGER EMAIL: RSHENOY@14WEST.US

4. Once the SQL change has been approved and completed, the publication is now in the Telesales Module.