23.04 DB Schema Changes

Added table(s)

[tbl_Principal_Authority]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[lng_Principal_Authority_Id_Nmbr]

INT

NO

[str_Code]

VARCHAR (100)

NO

[str_Details]

VARCHAR (2000)

NO

[dtm_Creation_Date]

DATETIME2

NO

[lng_Creation_User_Id_Nmbr]

INT

NO

[dtm_Last_Mod_Date]

DATETIME2

NO

[lng_Last_Mod_User_Id_Nmbr]

INT

NO

Added column(s)

[tbl_Users]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Federation]

VARCHAR (1000)

NO

[tbl_Insurance_Provider]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Integration_Configuration]

VARCHAR (100)

NO

[tbl_Res_Insurance_Policy]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Plan_Identifier]

NVARCHAR (4000)

YES

[tbl_Seat_Assignment_Algorithm]

Field

Data Type

NULLABLE

Field

Data Type

NULLABLE

[str_Type]

VARCHAR (20)

NO