[WT-10303] Ledcor Beneficiary Load - Trust record - Workterra Jira

Details

Type: Bug
Status: Production Complete
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: None
Component/s: BenAdmin
Labels:
None

Environment:

Stage
Bug Type:
Functional
Bug Severity:
Medium
Module:
BenAdmin - Import
Reported by:
Support
Item State:
Production Complete - Closed
Sprint:
WT Sprint 35 - Bugs

Description

Hi,
For the import template Bene_No DOB_Trust the Trust Record imported is kicking out with the error Dependent Date of Birth is required. The record being imported (see bad file) has a relationship type of Trust so do not understand why this is not loading. I thought if the relationship is defined as Trust then the Beneficiary Trust Name field is populated and the Beneficiary First Name, Beneficiary Last Name, Beneficiary Date of Birth are not required.
Can you please take a look at this import and let me know what is missing.
I did try to map the Beneficiary Date of Birth field but received an Import Failed error.
Thanks!
Cindy

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

customization.jpg
222 kB
26/Jul/17 02:34 PM
Date of birth load.jpg
174 kB
26/Jul/17 02:34 PM
employee history.jpg
198 kB
26/Jul/17 02:34 PM
QNI_5_Beneficiaries_2017-07-20.zip
0.5 kB
29/Aug/17 08:21 AM
QuincyImport.jpg
98 kB
07/Sep/17 04:48 AM

Issue Links

is caused by

WT-7755 Dependent Import - Validation For unique fields

Production Complete

Activity

Ascending order - Click to sort in descending order

Cindy Wibbing (Inactive) created issue - 26/Jul/17 04:46 AM

Mandar Kulkarni (Inactive) made changes - 26/Jul/17 06:03 AM

Field	Original Value	New Value
Assignee	Vijay Siddha [ vijays ]	Suraj Sokasane [ suraj.sokasane ]

Suraj Sokasane (Inactive) made changes - 26/Jul/17 11:21 AM

Assignee

Suraj Sokasane [ suraj.sokasane ]

Vishal Bajad [ vishal.bajad ]

Vishal Bajad (Inactive) made changes - 26/Jul/17 02:21 PM

Status

Open [ 1 ]

In Progress [ 3 ]

Vishal Bajad (Inactive) made changes - 26/Jul/17 02:34 PM

Attachment		customization.jpg [ 56861 ]
Attachment		Date of birth load.jpg [ 56862 ]
Attachment		employee history.jpg [ 56863 ]

Vishal Bajad (Inactive) made changes - 26/Jul/17 02:42 PM

Assignee	Vishal Bajad [ vishal.bajad ]	Cindy Wibbing [ cindy.wibbing ]
Resolution		Done [ 10000 ]
Status	In Progress [ 3 ]	Resolved [ 5 ]

Vishal Bajad (Inactive) made changes - 26/Jul/17 02:43 PM

Remaining Estimate		0h [ 0 ]
Time Spent		3h [ 10800 ]
Worklog Id		66651 [ 66651 ]

Vishal Bajad (Inactive) made changes - 27/Jul/17 12:20 PM

Link

This issue is caused by ~~WT-7755~~ [ ~~WT-7755~~ ]

Vishal Bajad (Inactive) made changes - 27/Jul/17 01:53 PM

Time Spent	3h [ 10800 ]	4h [ 14400 ]
Worklog Id		67396 [ 67396 ]

Suraj Sokasane (Inactive) made changes - 27/Jul/17 01:59 PM

Time Spent	4h [ 14400 ]	4.5h [ 16200 ]
Worklog Id		67400 [ 67400 ]

Amit Thorve (Inactive) made changes - 31/Jul/17 04:14 PM

Assignee

Cindy Wibbing [ cindy.wibbing ]

Vishal Bajad [ vishal.bajad ]

Amit Thorve (Inactive) made changes - 31/Jul/17 04:15 PM

Resolution	Done [ 10000 ]
Status	Resolved [ 5 ]	Reopened [ 4 ]

Jaideep Vinchurkar (Inactive) made changes - 03/Aug/17 07:47 AM

Issue Type	Support Activity [ 10301 ]	Bug [ 1 ]
Support Task Type	Data Load [ 11401 ]
Workflow	WT_Support [ 47849 ]	WT_Defects [ 48357 ]

Jaideep Vinchurkar (Inactive) made changes - 03/Aug/17 07:47 AM

Status

Reopened [ 4 ]

In Development [ 10007 ]

Jaideep Vinchurkar (Inactive) made changes - 03/Aug/17 07:48 AM

Developer		Vishal Bajad [ vishal.bajad ]
Item State		Parent values: Development(10200)Level 1 values: In Analysis(10204)
Module	Parent values: BenAdmin(10100)	Parent values: BenAdmin(10100)Level 1 values: Import(10111)
QA		Jayshree Nagpure [ jayshree.nagpure ]
Original Estimate		10h [ 36000 ]

Vishal Bajad (Inactive) made changes - 07/Aug/17 02:19 PM

Time Spent	4.5h [ 16200 ]	6.5h [ 23400 ]
Worklog Id		69811 [ 69811 ]

Vishal Bajad (Inactive) made changes - 09/Aug/17 01:56 PM

Code Reviewed By		Jaideep Vinchurkar [ 11908 ]
Item State	Parent values: Development(10200)Level 1 values: In Analysis(10204)	Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Vishal Bajad (Inactive) made changes - 09/Aug/17 02:01 PM

Time Spent	6.5h [ 23400 ]	14.5h [ 52200 ]
Worklog Id		70567 [ 70567 ]

Jaideep Vinchurkar (Inactive) made changes - 09/Aug/17 02:34 PM

Time Spent	14.5h [ 52200 ]	15.5h [ 55800 ]
Worklog Id		70597 [ 70597 ]

Jaideep Vinchurkar (Inactive) made changes - 09/Aug/17 02:35 PM

Code Review Date		09/Aug/2017
Component/s		BenAdmin [ 10000 ]
Sprint		WT Sprint 34-Bugs [ 79 ]

Khandu Kshirsagar (Inactive) made changes - 10/Aug/17 05:55 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Vishal Bajad (Inactive) made changes - 10/Aug/17 06:00 AM

Assignee

Vishal Bajad [ vishal.bajad ]

Jayshree Nagpure [ jayshree.nagpure ]

Vishal Bajad (Inactive) made changes - 10/Aug/17 06:00 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Jayshree Nagpure (Inactive) made changes - 10/Aug/17 10:15 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Jayshree Nagpure (Inactive) made changes - 10/Aug/17 01:34 PM

Time Spent	15.5h [ 55800 ]	16.5h [ 59400 ]
Worklog Id		70930 [ 70930 ]

Ashwin Wankhede (Inactive) made changes - 11/Aug/17 06:27 AM

Item State

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Jayshree Nagpure (Inactive) made changes - 11/Aug/17 11:24 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Jayshree Nagpure (Inactive) made changes - 11/Aug/17 12:46 PM

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)

Jayshree Nagpure (Inactive) made changes - 11/Aug/17 12:46 PM

Production Due Date		17/Aug/2017
Stage Due Date		14/Aug/17 [ 2017-08-14 ]

Khandu Kshirsagar (Inactive) made changes - 14/Aug/17 07:00 AM

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)

Jayshree Nagpure (Inactive) made changes - 14/Aug/17 11:28 AM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Jayshree Nagpure (Inactive) made changes - 14/Aug/17 11:28 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Jayshree Nagpure (Inactive) made changes - 14/Aug/17 12:17 PM

Time Spent	16.5h [ 59400 ]	18h [ 64800 ]
Worklog Id		71440 [ 71440 ]

Jayshree Nagpure (Inactive) made changes - 14/Aug/17 12:17 PM

Item State

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Amit Thorve (Inactive) made changes - 14/Aug/17 04:56 PM

Resolution		Unresolved [ 10200 ]
Status	Stage Testing [ 10201 ]	Reopen in Stage [ 10023 ]

Jaideep Vinchurkar (Inactive) made changes - 16/Aug/17 01:24 PM

Assignee

Jayshree Nagpure [ jayshree.nagpure ]

Vishal Bajad [ vishal.bajad ]

Jaideep Vinchurkar (Inactive) made changes - 16/Aug/17 01:25 PM

Status

Reopen in Stage [ 10023 ]

In Development [ 10007 ]

Jaideep Vinchurkar (Inactive) made changes - 16/Aug/17 01:25 PM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Jaideep Vinchurkar (Inactive) made changes - 16/Aug/17 01:26 PM

Sprint

WT Sprint 34-Bugs [ 79 ]

WT Sprint 35 - Bugs [ 81 ]

Vishal Bajad (Inactive) made changes - 17/Aug/17 04:29 PM

Time Spent	18h [ 64800 ]	22h [ 79200 ]
Worklog Id		72304 [ 72304 ]

Vishal Bajad (Inactive) made changes - 17/Aug/17 04:29 PM

Item State

Parent values: Development(10200)Level 1 values: In Analysis(10204)

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Jaideep Vinchurkar (Inactive) made changes - 18/Aug/17 07:23 AM

Time Spent	22h [ 79200 ]	22.5h [ 81000 ]
Worklog Id		72385 [ 72385 ]

Rakesh Roy (Inactive) made changes - 18/Aug/17 10:02 AM

Bug Type		Functional [ 15402 ]
Code Review Date	09/Aug/2017	09/Aug/2017
Production Due Date	17/Aug/2017	17/Aug/2017
Stage Due Date	14/Aug/17 [ 2017-08-14 ]	14/Aug/17 [ 2017-08-14 ]

Khandu Kshirsagar (Inactive) made changes - 18/Aug/17 10:14 AM

Item State

Parent values: Development(10200)Level 1 values: Ready for Review(10208)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Vishal Bajad (Inactive) made changes - 22/Aug/17 11:46 AM

Assignee

Vishal Bajad [ vishal.bajad ]

Jayshree Nagpure [ jayshree.nagpure ]

Jayshree Nagpure (Inactive) made changes - 23/Aug/17 04:56 AM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Jayshree Nagpure (Inactive) made changes - 23/Aug/17 04:57 AM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Jayshree Nagpure (Inactive) made changes - 23/Aug/17 02:09 PM

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)

Jayshree Nagpure (Inactive) made changes - 23/Aug/17 02:09 PM

Production Due Date	17/Aug/2017	29/Aug/2017
Stage Due Date	14/Aug/17 [ 2017-08-14 ]	28/Aug/17 [ 2017-08-28 ]

Jayshree Nagpure (Inactive) made changes - 23/Aug/17 02:10 PM

Time Spent	22.5h [ 81000 ]	25h [ 90000 ]
Worklog Id		73896 [ 73896 ]

Khandu Kshirsagar (Inactive) made changes - 28/Aug/17 07:12 AM

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)

Jayshree Nagpure (Inactive) made changes - 28/Aug/17 12:42 PM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Jayshree Nagpure (Inactive) made changes - 28/Aug/17 12:43 PM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Jayshree Nagpure (Inactive) made changes - 28/Aug/17 12:43 PM

Item State

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Jayshree Nagpure (Inactive) made changes - 28/Aug/17 01:08 PM

Time Spent	25h [ 90000 ]	26.5h [ 95400 ]
Worklog Id		74502 [ 74502 ]

Cindy Wibbing (Inactive) made changes - 29/Aug/17 08:21 AM

Attachment

QNI_5_Beneficiaries_2017-07-20.zip [ 60100 ]

Vishal Bajad (Inactive) made changes - 29/Aug/17 01:52 PM

Time Spent	26.5h [ 95400 ]	28.5h [ 102600 ]
Worklog Id		74899 [ 74899 ]

Khandu Kshirsagar (Inactive) made changes - 30/Aug/17 11:33 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Jayshree Nagpure (Inactive) made changes - 30/Aug/17 12:38 PM

Status

Stage Testing [ 10201 ]

Reopen in Stage [ 10023 ]

Jayshree Nagpure (Inactive) made changes - 30/Aug/17 12:38 PM

Status

Reopen in Stage [ 10023 ]

In Development [ 10007 ]

Jayshree Nagpure (Inactive) made changes - 30/Aug/17 12:38 PM

Status

In Development [ 10007 ]

Local Testing [ 10200 ]

Jayshree Nagpure (Inactive) made changes - 31/Aug/17 12:01 PM

Item State

Parent values: LB QA(10201)Level 1 values: LB Deployed(11600)

Parent values: LB QA(10201)Level 1 values: In Testing(10210)

Jayshree Nagpure (Inactive) made changes - 01/Sep/17 02:45 PM

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)

Jayshree Nagpure (Inactive) made changes - 01/Sep/17 02:45 PM

Time Spent	28.5h [ 102600 ]	30.5h [ 109800 ]
Worklog Id		76506 [ 76506 ]

Khandu Kshirsagar (Inactive) made changes - 04/Sep/17 07:48 AM

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)

Jayshree Nagpure (Inactive) made changes - 04/Sep/17 09:17 AM

Item State

Parent values: Stage QA(10202)Level 1 values: Stage Deployed(11602)

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Jayshree Nagpure (Inactive) made changes - 04/Sep/17 12:57 PM

Item State

Parent values: Stage QA(10202)Level 1 values: In Testing(10214)

Parent values: Stage QA(10202)Level 1 values: Ready for Production(10217)

Jayshree Nagpure (Inactive) made changes - 04/Sep/17 01:06 PM

Time Spent	30.5h [ 109800 ]	32.5h [ 117000 ]
Worklog Id		76703 [ 76703 ]

Khandu Kshirsagar (Inactive) made changes - 05/Sep/17 07:10 AM

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)

Jayshree Nagpure (Inactive) made changes - 06/Sep/17 04:30 AM

Item State

Parent values: Production QA(10203)Level 1 values: Production Deployed(10221)

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Jayshree Nagpure (Inactive) made changes - 06/Sep/17 01:33 PM

Item State

Parent values: Production QA(10203)Level 1 values: In Testing(10218)

Parent values: Production Complete(10222)Level 1 values: Closed(10223)

Jayshree Nagpure (Inactive) made changes - 06/Sep/17 01:33 PM

Status

Local Testing [ 10200 ]

Stage Testing [ 10201 ]

Jayshree Nagpure (Inactive) made changes - 06/Sep/17 01:33 PM

Status

Stage Testing [ 10201 ]

Production Testing [ 10202 ]

Jayshree Nagpure (Inactive) made changes - 06/Sep/17 01:34 PM

Resolution	Unresolved [ 10200 ]	Fixed [ 1 ]
Status	Production Testing [ 10202 ]	Production Complete [ 10028 ]

Jayshree Nagpure (Inactive) made changes - 06/Sep/17 01:34 PM

Time Spent	32.5h [ 117000 ]	34.5h [ 124200 ]
Worklog Id		77145 [ 77145 ]

Jayshree Nagpure (Inactive) made changes - 07/Sep/17 04:48 AM

Attachment

QuincyImport.jpg [ 60870 ]

Vishal Bajad (Inactive) made changes - 25/Sep/17 01:21 PM

Time Spent	34.5h [ 124200 ]	34.75h [ 125100 ]
Worklog Id		81133 [ 81133 ]

Satya made changes - 04/Nov/17 06:31 AM

Environment_New

Stage [ 18443 ]

People

Assignee:: Jayshree Nagpure (Inactive)

Reporter:: Cindy Wibbing (Inactive)

Developer:: Vishal Bajad (Inactive)

QA:: Jayshree Nagpure (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 26/Jul/17 04:46 AM

Updated:: 04/Nov/17 06:31 AM

Resolved:: 06/Sep/17 01:34 PM

Pre-Prod Due Date:: 28/Aug/2017

Production Due Date:: 29/Aug/2017

Code Review Date:: 09/Aug/2017

Time Tracking

Estimated:

10h

Remaining:

Logged:

34.75h