WORKTERRAProject Type: software

WORKTERRA

Uploaded image for project: 'WORKTERRA'
  1. WORKTERRA
  2. WT-6066

ACA 2017 : Add if exists check in DDL of ACAEmployeeStatusInfoMonthly

    Details

    • Type: Change Request
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: ACA
    • Labels:
      None
    • Module:
      ACA - 2017
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed

      Attachments

        Issue Links

        relates to

        Enhancement - An improvement or enhancement to an existing feature or task. WT-2605 Employee status, classes or date changes need to be tracked with more accuracy.

        • High - Serious problem that could block progress.
        • Closed

          Activity

          Ascending order - Click to sort in descending order
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Files:

          Database Objects/MasterCompanyDB/01_DDL/358_WT-6066_WTB_ACA_NewTable_ACAEmployeeStatusInfoMonthly.sql

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Files: Database Objects/MasterCompanyDB/01_DDL/358_ WT-6066 _WTB_ACA_NewTable_ACAEmployeeStatusInfoMonthly.sql
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Sachin Hingole

          In the earlier DDL,if exists check was not present.So if this DDL was getting executed continuously,as it happens on new companies,it was giving an error.

          Added a check to see if table is already present.
          Please provide go ahead for this as this cannot be tested from UI.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Sachin Hingole In the earlier DDL,if exists check was not present.So if this DDL was getting executed continuously,as it happens on new companies,it was giving an error. Added a check to see if table is already present. Please provide go ahead for this as this cannot be tested from UI.
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          As per discussion with Ramya, this is related to deployment hence marking this is Ready for stage.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - As per discussion with Ramya, this is related to deployment hence marking this is Ready for stage.
          Hide
          Permalink
          sachin.hingole Sachin Hingole (Inactive) added a comment -

          This is related to deployment hence marking this is Ready for Production.

          Show
          sachin.hingole Sachin Hingole (Inactive) added a comment - This is related to deployment hence marking this is Ready for Production.
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Sachin Hingole

          This JIRA relates to WT-2605 which is still on stage and as this was related to deployment,latest files will be checked into Production when parent enhancement will be checked in. Hence closing this JIRA.

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Sachin Hingole This JIRA relates to WT-2605 which is still on stage and as this was related to deployment,latest files will be checked into Production when parent enhancement will be checked in. Hence closing this JIRA.

            People

            Assignee:
            sachin.hingole Sachin Hingole (Inactive)
            Reporter:
            ramya.tantry Ramya Tantry (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: