0

I am new to creating forms and I do not know where to begin to start to create this form in InfoPath. Can someone help guide me in creating this form below? 

Purpose: To provide LOB’s their QA action items on a monthly basis regarding errors found within ORE (department) based upon compare to source documentation/review. Each error will need to be an ACCEPT/REJECT. If rejection is selected, then a comment must be provided. 

Outstanding QA Que (Only QA team access)

  1. Each month QA will receive a file to upload into the SharePoint site. File will include 54 columns of data. Each EventID will require the below fields to be verified. 
    1. EVENTNAME
    2. EVENTCOAU
    3. EVENTDESCRIPTION
    4. EVENTDATE
    5. DISCOVERYDATE
    6. BASEL1NAME
    7. BASEL2NAME
    8. RISKTITLENAME
    9. PRIMARYRISKTYPENAME
    10. PRIMARYROOTCAUSENAME
    11. TOTAL CROSS LOSS
    12. ALTERNATESOURCEID
    13. ALTERNATESOURCENAME
    14. MASTEREVENTCODE
    15. AGGREGATEEVENTCODE
    16. ORXPRODUCT
    17. ORXPROCESS
    18. DEPINSTNAME
    19. GEOMARKETCOUNTRY
    20. GEOMARKETCONTINENT
    21. CREDITRISKRELATED
    22. MARKETRISKRELATED
    23. ALLGDCAUSE1NAME
    24. ALLGDCAUSE2NAME
    25. ALLGDCAUSE3NAME
    26. JRSDTIONCHOISEOFLAWNAME
    27. CTRPTYCLMTTYPENAME
    28. ROLEOFTHEFIRMNAME
    29. ENVVOLATILITYNAME
    30. FIRST_EFFECTIVE_DATE
  2. Events will need to be loaded within the Business Group they belong driven by BUSINESSGROUP in uploaded file. 
    • Business Group derived from BUSINESSGROUP field from file for all groups except STAFF SUPPORT
    • STAFF SUPPORT Business Group will be derived by BUSINESSGROUP as well as LOB_ORG_NAME field from file to determine proper Enterprise Function.

        Once loaded, email will transmit QA team.

QA Verfication Que  Select LOB to view QA items pending validation:

    • Consumer Banking
    • PVSI
    • Wealth and Investment

Management

    • Wholesale
    • Enterprise Functions – Audit
    • Enterprise Functions – Legal
    • Enterprise Functions – Finance
    • Enterprise Functions –

Corporate Risk

    • Enterprise Functions – EIS
    • Enterprise Functions – EIT

** Notate total number of events beside each LOB

    3. For each Event ID, the Event ID would appear in our que with below detail.   

EVENTID BusinessGroup LOB_ORG_NAME ORGPOINTNAME

    • Click on each Event ID and each of the above 30 fields would display.  As you click on each field, the related data from the file would appear.  There would then be a dropdown option for OK or Exception. 
    • If Exception is selected, then a QA Comment field would appear.  Field would be a free text where QA could populate their comments for exception.

    4. For the below fields there needs to be an additional field for Supporting Doc with dropdown options            OK, Could Not Be Verified, Not Consistent, No Document Posted.  Fields requiring this are:

      1. EVENTDESCRIPTION
      2. EVENTDATE
      3. DISCOVERYDATE

    5. For each Event ID, include the two below verification fields:

      1. Missing Document Form Used – dropdown Yes or No.  If Yes, then dropdown appears Missing Document Form Reviewed, select Yes or No

      2. Document Naming Feedback – dropdown Ok or Exception.  If Exception is selected, then a QA Comment field would appear.  Field would be a free text where QA could populate their comments for exception.

      6. Once all the fields for each Event are populated with Ok or Exception with comments, QA would then        click Submit.

    • If no exceptions then Event record would go to QA Completed Que.  If Event has Exceptions, then Event and all exceptions will flow to Business Group QA Que. 
(Visited 71 times, 1 visits today)
Chanakya Jayabalan Answered question May 22, 2019
Add a Comment