Skip to end of banner
Go to start of banner

Development Overview

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 6 Next »


Target release

Epic

Document status

DRAFT

Document owner

Robert Adach

Business POC

Designer

Developers

QA

Databases

The project will two database connections. User stories will reference which connection string should be used for each/all database interaction within the user story. Each database connection will have 4 configurations associated with it

  • The ASWB connection strings are used for WRITING records.

  • The ASWBOnline connection strings are used for READING records.

Connection String Name

Server name

Database name

UserName

Description

1

ASWBLocal

local

ExamRegistration



2

ASWBQA

ASWBDevData

ExamRegistration



3

ASWBTest

ASWBDecData

ExamRegistration



4

ASWB

ASWBSQL2\ASWBSQL2

ASWBTest



5

ASWBOnlineLocal

local

ExamRegistration



6

ASWBOnlineQA

ASWBDevData

ExamRegistration



7

ASWBOnlineTest

ASWBDevData

ExamRegistration



8

ASWBOnline

ASWBData

ExamRegistration



9






10







Key Reference Information

Column / Item References

ID Number

Display

ExamBeforeGraduation

0

None Selected

ExamBeforeGraduation

1

No

ExamBeforeGraduation

2

Yes

ExamBeforeGraduation

3

Maybe

ExamBeforeGraduation

99

Unknown

ExamBeforePostGrad

0

None Selected

ExamBeforePostGrad

1

No

ExamBeforePostGrad

2

Yes

ExamBeforePostGrad

3

Maybe

ExamBeforePostGrad

99

Unknown

IsJurisdiction

0

None Selected

IsJurisdiction

1

No

IsJurisdiction

2

Yes

IsJurisdiction

3

Maybe

IsJurisdiction

99

Unknown

IsMember

0

None Selected

IsMember

1

No

IsMember

2

Yes

IsMember

3

Maybe

IsMember

99

Unknown

MSWBeforeExam

0

None Selected

MSWBeforeExam

1

No

MSWBeforeExam

2

Yes

MSWBeforeExam

3

Maybe

MSWBeforeExam

99

Unknown

UsesAGExam

0

None Selected

UsesAGExam

1

No

UsesAGExam

2

Yes

UsesAGExam

3

Maybe

UsesAGExam

99

Unknown

UsesASExam

0

None Selected

UsesASExam

1

No

UsesASExam

2

Yes

UsesASExam

3

Maybe

UsesASExam

99

Unknown

UsesBSExam

0

None Selected

UsesBSExam

1

No

UsesBSExam

2

Yes

UsesBSExam

3

Maybe

UsesBSExam

99

Unknown

UsesCLExam

0

None Selected

UsesCLExam

1

No

UsesCLExam

2

Yes

UsesCLExam

3

Maybe

UsesCLExam

99

Unknown

UsesMSExam

0

None Selected

UsesMSExam

1

No

UsesMSExam

2

Yes

UsesMSExam

3

Maybe

UsesMSExam

99

Unknown

Exam Level

0

None Selected

Exam Level

1

Associate

Exam Level

2

Bachelors

Exam Level

3

Masters

Exam Level

4

Advanced Generalist

Exam Level

5

Clinical

Supporting Procedures

lp_GetNewID

DROP PROCEDURE IF EXISTS [dbo].[lp_GetNewID]
GO

CREATE PROCEDURE [dbo].[lp_GetNewID] @type INT, @id INT OUTPUT
as
set nocount on
begin tran
select @id =  LastID from tblID where [ID] = @type
if (@id = 0) or (@id is null)
    begin
        raiserror ('Error:  Unknown type of id - is there a row for it in tblID?',15,1)
        rollback
        select @id = -99
        return -1 --no record for this type
    end
else 
  begin
    select @id = @id + 1
    update tblID set LastID = @id where [ID] = @type
    commit
  end
set nocount off
return 0  --successful



Technical Review (IT)


Areas Affected



  • No labels