23.04 DB Schema Changes
Added table(s)
[tbl_Principal_Authority]
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 |
---|---|---|
[str_Federation] | VARCHAR (1000) | NO |
[tbl_Insurance_Provider]
Field | Data Type | NULLABLE |
---|---|---|
[str_Integration_Configuration] | VARCHAR (100) | NO |
[tbl_Res_Insurance_Policy]
Field | Data Type | NULLABLE |
---|---|---|
[str_Plan_Identifier] | NVARCHAR (4000) | YES |
[tbl_Seat_Assignment_Algorithm]
Field | Data Type | NULLABLE |
---|---|---|
[str_Type] | VARCHAR (20) | NO |