New Features 2017Project Type: software

New Features 2017

Uploaded image for project: 'New Features 2017'
  1. New Features 2017
  2. NF-938

Bullhorn Integration: Map Company ID and Corporation ID in Company Table

    Details

    • Type: Enhancement
    • Status: Closed
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Bullhorn, Integrations
    • Labels:
      None
    • Module:
      Bullhorn
    • Reported by:
      Harbinger
    • Item State:
      Production Complete - Closed
    • Sprint:
      Bullhorn - 10 Apr 2017
    • Severity:
      Simple

      Description

      Add a new column in Company Table named "ATSCorporationID" and Map corporation ID of Bullhorn company with Company in WT.

        Attachments

          Activity

          Ascending order - Click to sort in descending order
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 12/Apr/17 03:38 PM
          • Time Spent:
            1h
             

            Script to add New Column in Company and Company_history Table.
            Discussion with Saurabh.

          ramya.tantry Ramya Tantry (Inactive) created issue -
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Field Original Value New Value
          Remaining Estimate 2h [ 7200 ] 1h [ 3600 ]
          Time Spent 1h [ 3600 ]
          Worklog Id 37854 [ 37854 ]
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 13/Apr/17 03:46 PM
          • Time Spent:
            20m
             

            Code review files creation

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 1h [ 3600 ] 40m [ 2400 ]
          Time Spent 1h [ 3600 ] 1h 20m [ 4800 ]
          Worklog Id 38076 [ 38076 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Code Review Date 14/Apr/2017
          Code Reviewed By Saurabh Sablaka [ 11909 ]
          Item State Parent values: Development(10200)Level 1 values: In Progress(10206) Parent values: Development(10200)Level 1 values: Ready for Local Testing(10209)
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Files Affected:
          /Database Objects/OnlineEnrollment/01_DDL/118_NF-938_WTB_WORKTERRAAPI_ModTable_Company.sql
          /Database Objects/OnlineEnrollment/01_DDL/119_NF-938_WTB_WORKTERRAAPI_ModTable_Company_History.sql

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Files Affected: /Database Objects/OnlineEnrollment/01_DDL/118_ NF-938 _WTB_WORKTERRAAPI_ModTable_Company.sql /Database Objects/OnlineEnrollment/01_DDL/119_ NF-938 _WTB_WORKTERRAAPI_ModTable_Company_History.sql
          Permalink
          ramya.tantry Ramya Tantry (Inactive) logged work - 14/Apr/17 10:03 AM
          • Time Spent:
            20m
             

            Code review changes
            Checkins to LB,Local and UI refresh

          ramya.tantry Ramya Tantry (Inactive) made changes -
          Remaining Estimate 40m [ 2400 ] 20m [ 1200 ]
          Time Spent 1h 20m [ 4800 ] 1h 40m [ 6000 ]
          Worklog Id 38284 [ 38284 ]
          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)
          shyam.sharma shyam sharma (Inactive) made changes -
          Sprint Bullhorn - 10 Apr 2017 [ 59 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Issue Type Change Request [ 10002 ] Enhancement [ 4 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Dev Estimates 2
          ramya.tantry Ramya Tantry (Inactive) made changes -
          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 -
          Status In Development [ 10007 ] Local Testing [ 10200 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Local Testing [ 10200 ] Pending for Stage Approval [ 10300 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Pending for Stage Approval [ 10300 ] Approved for Stage [ 10030 ]
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Item State Parent values: LB QA(10201)Level 1 values: LB Deployed(11600) Parent values: LB QA(10201)Level 1 values: Ready for Stage(10213)
          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)
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Status Approved for Stage [ 10030 ] Stage Testing [ 10201 ]
          Hide
          Permalink
          ramya.tantry Ramya Tantry (Inactive) added a comment -

          Hi Prasad Pise,

          This is a setup jira created to map company id with corporation id for bullhorn.
          There is no UI for this to verify.
          Assigning this to you as per discussion with Saurabh.

          CC:Saurabh Sablaka

          Show
          ramya.tantry Ramya Tantry (Inactive) added a comment - Hi Prasad Pise , This is a setup jira created to map company id with corporation id for bullhorn. There is no UI for this to verify. Assigning this to you as per discussion with Saurabh. CC: Saurabh Sablaka
          ramya.tantry Ramya Tantry (Inactive) made changes -
          Assignee Ramya Tantry [ ramya.tantry ] Prasad Pise [ prasadp ]
          prasadp Prasad Pise (Inactive) made changes -
          Assignee Prasad Pise [ prasadp ] Kunal Kedari [ kunal.kedari ]
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602) Parent values: Stage QA(10202)Level 1 values: In Testing(10214)
          Hide
          Permalink
          kunal.kedari Kunal Kedari (Inactive) added a comment -

          We have verified the change on Local and Stage environment company id has been mapped to corporation ID.

          Show
          kunal.kedari Kunal Kedari (Inactive) added a comment - We have verified the change on Local and Stage environment company id has been mapped to corporation ID.
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: In Testing(10214) Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224)
          Permalink
          kunal.kedari Kunal Kedari (Inactive) logged work - 12/Jun/17 05:54 PM
          • Time Spent:
            1.5h
             

            Testing on Stage

          Hide
          Permalink
          kunal.kedari Kunal Kedari (Inactive) added a comment -

          Added QA estimations (2h) to original one

          Show
          kunal.kedari Kunal Kedari (Inactive) added a comment - Added QA estimations (2h) to original one
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Original Estimate 2h [ 7200 ] 4h [ 14400 ]
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Remaining Estimate 20m [ 1200 ] 0h [ 0 ]
          Time Spent 1h 40m [ 6000 ] 3h 10m [ 11400 ]
          Worklog Id 56036 [ 56036 ]
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Production Deployment on Hold(10224) Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)
          khandu.kshirsagar Khandu Kshirsagar (Inactive) made changes -
          Item State Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217) Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: Production Deployed(10221) Parent values: Production QA(10203)Level 1 values: In Testing(10218)
          Permalink
          kunal.kedari Kunal Kedari (Inactive) logged work - 22/Jun/17 05:15 PM
          • Time Spent:
            0.5h
             

            Testing on Production

          Hide
          Permalink
          kunal.kedari Kunal Kedari (Inactive) added a comment -

          Verified the change on Production, working as expected. Closing the ticket.

          Show
          kunal.kedari Kunal Kedari (Inactive) added a comment - Verified the change on Production, working as expected. Closing the ticket.
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Item State Parent values: Production QA(10203)Level 1 values: In Testing(10218) Parent values: Production Complete(10222)Level 1 values: Closed(10223)
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Status Stage Testing [ 10201 ] Pending for Production Approval [ 10301 ]
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Status Pending for Production Approval [ 10301 ] Approved for production [ 10034 ]
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Status Approved for production [ 10034 ] Production Testing [ 10202 ]
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Resolution Fixed [ 1 ]
          Status Production Testing [ 10202 ] Production Complete [ 10028 ]
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Status Production Complete [ 10028 ] Closed [ 6 ]
          kunal.kedari Kunal Kedari (Inactive) made changes -
          Time Spent 3h 10m [ 11400 ] 3h 40m [ 13200 ]
          Worklog Id 59027 [ 59027 ]
          Transition Time In Source Status Execution Times
          Ramya Tantry (Inactive) made transition -
          New Request Pending for Approval
          		11d 2h 57m 1
          Ramya Tantry (Inactive) made transition -
          Pending for Approval Approved for Development
          		3s 1
          Ramya Tantry (Inactive) made transition -
          Approved for Development In Development
          		3s 1
          Ramya Tantry (Inactive) made transition -
          In Development In LB Testing
          		4s 1
          Ramya Tantry (Inactive) made transition -
          In LB Testing Pending for Stage Approval
          		15d 21h 58m 1
          Ramya Tantry (Inactive) made transition -
          Pending for Stage Approval Approved for Stage
          		3s 1
          Ramya Tantry (Inactive) made transition -
          Approved for Stage Stage Testing
          		7h 50m 1
          Kunal Kedari (Inactive) made transition -
          Stage Testing Pending for Production Approval
          		43d 16h 47m 1
          Kunal Kedari (Inactive) made transition -
          Pending for Production Approval Approved for production
          		2s 1
          Kunal Kedari (Inactive) made transition -
          Approved for production In Production Testing
          		2s 1
          Kunal Kedari (Inactive) made transition -
          In Production Testing Production Complete
          		6s 1
          Kunal Kedari (Inactive) made transition -
          Production Complete Closed
          		2s 1

            People

            Assignee:
            kunal.kedari Kunal Kedari (Inactive)
            Reporter:
            ramya.tantry Ramya Tantry (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Code Review Date:

                Time Tracking

                Estimated:
                Original Estimate - 4h
                4h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 3h 40m Time Not Required
                3h 40m