vIndividuals

Owned by Jordan Lamb
Last updated: May 14, 2021
1 min read

Oracle Field/Calc

DW Field

Description or Sample

Date Added

StudentNet.dbo.vIndividuals

WITH Individuals AS (SELECT STUDENTID AS BannerID,            PIDM     FROM dbo.Student     UNION     SELECT ID,            PIDM     FROM dbo.Faculty) SELECT DISTINCT        CONVERT(VARCHAR(256), HASHBYTES('SHA2_256', CONVERT(NVARCHAR(8), PIDM)), 2) AS ROW_ID,        BannerID,        PIDM FROM Individuals AS i;

ROW_ID

Encrypted column to utilize and compare with

12/4/19 - AhsenB

 

BannerID

Banner ID of Students and Faculty (not staff)

12/4/19 - AhsenB

 

PIDM

Personal Identification Number of the individuals.

12/4/19 - AhsenB