SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
entity.sas
Go to the documentation of this file.
1/*
2 Copyright (C) 2017 SAS Institute Inc. Cary, NC, USA
3*/
4
5/**
6 \file
7 \brief The SAS solution allows users to perform calculations and generate reports for more than one financial entity. To track and manage these relationships, this table will provide entity information.
8 \details
9
10 |PK |Variable |Type | Required? |Relationships |Label |Description |
11 |--------------|----------------------------|------------------|-----------|--------------|-------------------------|-----------------------------------------------------------|
12 |![ ](pk.jpg) | <b>REPORTING_DT</b> | NUMERIC(8) | Y | | Reporting Date | SAS Date value |
13 |![ ](pk.jpg) | <b>ENTITY_ID</b> | VARCHAR(32) | Y | | Entity Id | Unique Entity identifier |
14 | | ENTITY_NM | VARCHAR(40) | Y | | Entity Name | Entity Name |
15 | | ENTITY_DESC | VARCHAR(100) | Y | | Entity Description | Entity Description |
16 | | COUNTRY_CD | VARCHAR(3) | N | | Country Code | Country Code |
17 | | ENTITY_ROLE_CD | VARCHAR(5) | N | | Entity Role Code | Entity Role: SOLO or GROUP |
18 | | LEGAL_ENTITY_FLG | VARCHAR(1) | N | | Legal Entity Flag | Flag (Y/N). Specifies whether this is a legal entity |
19 | | GROUP_ID | VARCHAR(32) | N | | Group Identifier | Parent Entity Identifier |
20 | | REPORTING_CURRENCY_CD | VARCHAR(3) | Y | | Reporting Currency | Reporting currency code |
21
22 \ingroup ddlFactEntity
23 \author SAS Institute Inc.
24 \date 2016
25*/
26
27CREATE TABLE &LIBREF..ENTITY(
28 REPORTING_DT DATE label = 'Reporting Date' FORMAT = &DTFMT.,
29 ENTITY_ID VARCHAR(32) label = 'Entity Id',
30 ENTITY_ID VARCHAR(32) label = 'Entity Id',
31 ENTITY_NM VARCHAR(120) label = 'Entity Name',
32 ENTITY_DESC VARCHAR(300) label = 'Entity Description',
33 COUNTRY_CD VARCHAR(9) label = 'Country Code',
34 ENTITY_ROLE_CD VARCHAR(15) NOT NULL label = 'Entity Role Code',
35 LEGAL_ENTITY_FLG VARCHAR(3) label = 'Legal Entity Flag',
36 GROUP_ID VARCHAR(32) label = 'Group Id',
37 REPORTING_CURRENCY_CD VARCHAR(9) NOT NULL label = 'Reporting Currency',
38 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, ENTITY_ID)
39);
40
41