SENIORITY_DESCRIPTION

The SENIORITY_DESCRIPTION table provides a ranking of seniorities that can be used when calculating the DRC non-Sec net JTD.

Column Name Type Not Null Description
AS_OF_DATE DATE Y Timestamp (at close of business) for the data.
SENIORITY STRING Y Seniority of the exposure.
RANKING INTEGER Y Ranking to determine relative seniorities of SENIORITY values.

Unique Key

Columns
AS_OF_DATE
SENIORITY

Incoming Joins

Source Table Source Columns Target Columns
RISK_FACTOR_DESCRIPTION AS_OF_DATE
SENIORITY
AS_OF_DATE
SENIORITY