22.11 DB Schema Changes
Added table(s)
[tbl_SSR_Definition_Agency_Xref]
Field | Data Type | NULLABLE |
---|---|---|
[lng_SSR_Definition_Agency_Xref_Id_Nmbr] | INT | NO |
[lng_SSR_Definition_Id_Nmbr] | INT | NO |
[lng_Agency_Id_Nmbr] | INT | NO |
[dtm_Creation_Date] | SMALLDATETIME | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | SMALLDATETIME | NO |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |
[tbl_SSR_Definition_External_Provider]
Field | Data Type | NULLABLE |
---|---|---|
[lng_SSR_Definition_External_Provider_Id_Nmbr] | INT | NO |
[str_Name] | VARCHAR (50) | NO |
[str_ProgId] | VARCHAR (250) | NO |
[str_Url] | VARCHAR (250) | NO |
[str_Username] | VARCHAR (500) | NO |
[str_Password] | VARCHAR (500) | NO |
[str_Configuration] | NVARCHAR (4000) | NO |
[tbl_SSR_Res_Seg_Res_Xref]
Field | Data Type | NULLABLE |
---|---|---|
[lng_SSR_Res_Seg_Res_Xref_Id_Nmbr] | INT | NO |
[lng_SSR_Res_Leg_Xref_Id_Nmbr] | INT | NO |
[lng_SSR_Definition_Id_Nmbr] | INT | NO |
lng_Res_Segments_Id_Nmbr | INT | NO |
[dtm_Creation_Date] | SMALLDATETIME | NO |
[lng_Creation_User_Id_Nmbr] | INT | NO |
[dtm_Last_Mod_Date] | SMALLDATETIME | NO |
[lng_Last_Mod_User_Id_Nmbr] | INT | NO |
Added column(s)
[tbl_SSR_Definition]
Field | Data Type | NULLABLE |
---|---|---|
[lng_SSR_Definition_External_Provider_Id_Nmbr] | INT | NO |