22.11 DB Schema Changes

Added table(s)

[tbl_SSR_Definition_Agency_Xref]

Field

Data Type

NULLABLE

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

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

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

Field

Data Type

NULLABLE

[lng_SSR_Definition_External_Provider_Id_Nmbr]

INT

NO