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
          ramya.tantry Ramya Tantry (Inactive) created issue -
          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
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Field Original Value New Value
          Status New Request [ 10029 ] Pending for Approval [ 10002 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Pending for Approval [ 10002 ] Approved for Development [ 10003 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Approved for Development [ 10003 ] In Development [ 10007 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Code Reviewed By Yogesh Chaudhari [ 13000 ]
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209) Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)
          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.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Sachin Hingole [ sachin.hingole ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Link This issue relates to WT-2605 [ WT-2605 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: In Testing(10210)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: In Testing(10210) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          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.
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213) Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          sachin.hingole Sachin Hingole (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          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.
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Resolution Done [ 10000 ] Fixed [ 1 ]
          Status Production Complete [ 10028 ] Closed [ 6 ]
          rakeshr Rakesh Roy (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          Transition Time In Source Status Execution Times
          Ramya Tantry (Inactive) made transition -
          New Request Pending for Approval
          		12m 48s 1
          Ramya Tantry (Inactive) made transition -
          Pending for Approval Approved for Development
          		2s 1
          Ramya Tantry (Inactive) made transition -
          Approved for Development In Development
          		2s 1
          Ramya Tantry (Inactive) made transition -
          In Development In LB Testing
          		19h 33m 1
          Sachin Hingole (Inactive) made transition -
          In LB Testing Pending for Stage Approval
          		1d 22h 9m 1
          Sachin Hingole (Inactive) made transition -
          Pending for Stage Approval Approved for Stage
          		14s 1
          Sachin Hingole (Inactive) made transition -
          Approved for Stage Stage Testing
          		3s 1
          Ramya Tantry (Inactive) made transition -
          Stage Testing Pending for Production Approval
          		12m 31s 1
          Ramya Tantry (Inactive) made transition -
          Pending for Production Approval Approved for production
          		4s 1
          Ramya Tantry (Inactive) made transition -
          Approved for production In Production Testing
          		4s 1
          Ramya Tantry (Inactive) made transition -
          In Production Testing Production Complete
          		15s 1
          Ramya Tantry (Inactive) made transition -
          Production Complete Closed
          		48m 29s 1

            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: