[DMS-1962] DMS Fields Validations - Workterra Jira

Details

Type: Maintenance
Status: Done
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: DMS Architecture
Labels:
None

Company:
All Clients/Multiple Clients
Epic Link:
DMS Architecture

Description

Needs to check validations implemented in DMS for fields.

Attachments

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

Attachments

DMS Data.xlsx
48 kB
18/Nov/19 01:13 AM

Activity

Ascending order - Click to sort in descending order

Rohan J Khandave (Inactive) created issue - 14/Oct/19 10:19 PM

Rohan J Khandave (Inactive) made changes - 14/Oct/19 10:19 PM

Field	Original Value	New Value
Epic Link		DMS-2 [ 69268 ]

Rohan J Khandave (Inactive) made changes - 15/Oct/19 12:01 AM

Status

To Do [ 10000 ]

In Progress [ 3 ]

Hide

Permalink

Rohan J Khandave (Inactive) added a comment - 15/Oct/19 05:54 AM

Hello Samir,

Below is finding for fields validation

WEB : No validation added on web , when an admin send document to candidate and add/update data in preview.

API :

POST : api/document : Used By SMB

email : Has regular expression.
state : Cross check with DMS state data.
employmenttype : Cross check with DMS metadata of employment type.
wageschedule : Cross check with DMS metadata of wages schedule metadata.
offerpayschedule : Cross check with DMS metadata of offer pay schedule metadata.
offerDate : Validation for date format "MM/dd/yyyy".
dateOfHire: Validation for date format "MM/dd/yyyy".

POST : Used by CBATS & CBES**

api/candidate/custom/document/create
api/candidate/document/create

CountryID : Cross check with DMS country data.
employmenttype : Cross check with DMS metadata of employment type.
wageschedule : Cross check with DMS metadata of wages schedule metadata.
offerpayschedule : Cross check with DMS metadata of offer pay schedule metadata.
Salary : Validation for double data type.
CompensationBonus : Validation for double data type.
DateofHire : Validation for date format "MM/dd/yyyy".
OfferDate : Validation for date format "MM/dd/yyyy".
EffectiveEnddate : Validation for date format "MM/dd/yyyy".

Note:

Above mentioned validations are by passed for CBATS source product.
Other than above if any DMS field having lookup type id , data will get validate against look up type data ex. Gender.
DMS custom fields are validate against data type which implemented only for custom create API.

CC – Rohan J Khandave

Show

Rohan J Khandave (Inactive) added a comment - 15/Oct/19 05:54 AM Hello Samir , Below is finding for fields validation WEB : No validation added on web , when an admin send document to candidate and add/update data in preview. API : POST : api/document : Used By SMB email : Has regular expression. state : Cross check with DMS state data. employmenttype : Cross check with DMS metadata of employment type. wageschedule : Cross check with DMS metadata of wages schedule metadata. offerpayschedule : Cross check with DMS metadata of offer pay schedule metadata. offerDate : Validation for date format "MM/dd/yyyy". dateOfHire: Validation for date format "MM/dd/yyyy". POST : Used by CBATS & CBES ** api/candidate/custom/document/create api/candidate/document/create CountryID : Cross check with DMS country data. employmenttype : Cross check with DMS metadata of employment type. wageschedule : Cross check with DMS metadata of wages schedule metadata. offerpayschedule : Cross check with DMS metadata of offer pay schedule metadata. Salary : Validation for double data type. CompensationBonus : Validation for double data type. DateofHire : Validation for date format "MM/dd/yyyy". OfferDate : Validation for date format "MM/dd/yyyy". EffectiveEnddate : Validation for date format "MM/dd/yyyy". Note: Above mentioned validations are by passed for CBATS source product. Other than above if any DMS field having lookup type id , data will get validate against look up type data ex. Gender. DMS custom fields are validate against data type which implemented only for custom create API. CC – Rohan J Khandave

Permalink

Rohan J Khandave (Inactive) logged work - 15/Oct/19 07:09 AM

Time Spent:

2.5h

Analysis

Rohan J Khandave (Inactive) made changes - 15/Oct/19 07:11 AM

Remaining Estimate		0h [ 0 ]
Time Spent		2.5h [ 9000 ]
Worklog Id	205796 [ 205796 ]

Rohan J Khandave (Inactive) made changes - 15/Oct/19 09:34 PM

Remaining Estimate	0h [ 0 ]	4h [ 14400 ]
Original Estimate		4h [ 14400 ]

Hide

Permalink

Rohan J Khandave (Inactive) added a comment - 16/Oct/19 06:12 AM - edited

Marking this as done. We will create new enhancement JIRA (~~DMS-1970~~) to implement Validations for DMS system fields.

CC – Samir

Show

Rohan J Khandave (Inactive) added a comment - 16/Oct/19 06:12 AM - edited Marking this as done. We will create new enhancement JIRA ( DMS-1970 ) to implement Validations for DMS system fields. CC – Samir

Rohan J Khandave (Inactive) made changes - 16/Oct/19 06:56 AM

Resolution		Done [ 10000 ]
Status	In Progress [ 3 ]	Done [ 10001 ]

Samir made changes - 24/Oct/19 09:10 PM

Assignee

Rohan J Khandave [ rohan.khandave ]

Samir [ samir ]

Hide

Permalink

Mohd Belal (Inactive) added a comment - 17/Nov/19 08:42 PM

Hi Rohan J Khandave,

Can you please provide details about what validations are we using for the fields mentioned above which states cross check with.

I need to apply the rule in Frontend side for the PDF documents.

cc - Samir

Thanks

Show

Mohd Belal (Inactive) added a comment - 17/Nov/19 08:42 PM Hi Rohan J Khandave , Can you please provide details about what validations are we using for the fields mentioned above which states cross check with. I need to apply the rule in Frontend side for the PDF documents. cc - Samir Thanks

Hide

Permalink

Rohan J Khandave (Inactive) added a comment - 17/Nov/19 09:02 PM - edited

Hello Mohd Belal,

I have already provided all details. For more details check with Harshveer Singh / Narendra Kumar.

Thanks,
RohanK

CC – Samir , Satya

Show

Rohan J Khandave (Inactive) added a comment - 17/Nov/19 09:02 PM - edited Hello Mohd Belal , I have already provided all details. For more details check with Harshveer Singh / Narendra Kumar . Thanks, RohanK CC – Samir , Satya

Mohd Belal (Inactive) made changes - 18/Nov/19 01:13 AM

Attachment

DMS Data.xlsx [ 126749 ]

Hide

Permalink

Mohd Belal (Inactive) added a comment - 18/Nov/19 01:13 AM

Hi Samir,

We have gone through the state table which we have for the DMS fields, but did not found anything related to the validation rules for the fields applied.

Attached is the excel of state table.DMS Data.xlsx

Need your input on this.

cc - Rohan J Khandave, Narendra Kumar

Thanks

Show

Mohd Belal (Inactive) added a comment - 18/Nov/19 01:13 AM Hi Samir , We have gone through the state table which we have for the DMS fields, but did not found anything related to the validation rules for the fields applied. Attached is the excel of state table. DMS Data.xlsx Need your input on this. cc - Rohan J Khandave , Narendra Kumar Thanks

Transition	Time In Source Status	Execution Times

Rohan J Khandave (Inactive) made transition - 15/Oct/19 12:01 AM

To Do

In Progress

1h 42m

Rohan J Khandave (Inactive) made transition - 16/Oct/19 06:56 AM

In Progress

Done

1d 6h 54m

People

Assignee:: Samir

Reporter:: Rohan J Khandave (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 1 Start watching this issue

Dates

Created:: 14/Oct/19 10:19 PM

Updated:: 18/Nov/19 01:13 AM

Resolved:: 16/Oct/19 06:56 AM

Time Tracking

Estimated:

Remaining:

Logged:

2.5h