Versions Compared

Version Old Version 2 New Version 3
Changes made by

Chris Smith

Chris Smith

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The source code for the jar file is in an Eclipse project which can be found in the RAS GitLab repository: https://gitlab.it.tufts.edu/ras/click-irb-person-feed 


Click Database Schema

Code Block
languagesql
Person table schema:
[ClickIntegration].[Person_Staging](
       [ID] [int] IDENTITY(1,1) NOT NULL,
       [UserId] [nvarchar](255) NULL,
       [CompanyID] [nvarchar](50) NULL,
       [FirstName] [nvarchar](255) NULL,
       [LastName] [nvarchar](255) NULL,
       [MiddleName] [nvarchar](255) NULL,
       [PhoneNumber] [nvarchar](50) NULL,
       [EmailAddress] [nvarchar](255) NULL,
       [Roles] [nvarchar](4000) NULL,
       [IsActive] [bit] NULL,
       [Address1] [nvarchar](255) NULL,
       [City] [nvarchar](255) NULL,
       [State] [nvarchar](255) NULL,
       [Country] [nvarchar](255) NULL,
       [PostalCode] [nvarchar](255) NULL,
       [EmployeeID] [nvarchar](255) NULL,
CONSTRAINT [PK_Person_Staging] PRIMARY KEY CLUSTERED

Org table schema:
[ClickIntegration].[Org_Staging](
       [ID] [nvarchar](255) NOT NULL,
       [IsFundingSource] [bit] NULL,
       [Name] [nvarchar](255) NULL,
       [Parent] [nvarchar](255) NULL,
CONSTRAINT [PK_Org_Staging] PRIMARY KEY CLUSTERED