SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
map_own_funds_hierarchy.sas
Go to the documentation of this file.
1/* Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4 \file
5 \brief Own Funds Hierarchy
6 \details
7
8 |PK |Variable |Type | Required? |Relationships |Label |Description |
9 |--------------|----------------------|------------------|-----------|-----------------------------------------|-------------------------------------|------------------------|
10 | ![ ](pk.jpg) | CHART_OF_ACCOUNT_CD | VARCHAR(32) | Y | \link map_chart_of_account.sas \endlink | Chart of Account Code | Chart of Account Code |
11 | ![ ](pk.jpg) | OWN_FUNDS_CD | VARCHAR(32) | Y | | Own Funds Code | Own Funds Code |
12 | | OWN_FUNDS_LEV1 | VARCHAR(200) | N | | Level 1 of the Own Funds hierarchy | Own Funds Level 1 |
13 | | OWN_FUNDS_LEV2 | VARCHAR(200) | N | | Level 2 of the Own Funds hierarchy | Own Funds Level 2 |
14 | | OWN_FUNDS_LEV3 | VARCHAR(200) | N | | Level 3 of the Own Funds hierarchy | Own Funds Level 3 |
15 | | OWN_FUNDS_LEV4 | VARCHAR(200) | N | | Level 4 of the Own Funds hierarchy | Own Funds Level 4 |
16 | | OWN_FUNDS_LEV5 | VARCHAR(200) | N | | Level 5 of the Own Funds hierarchy | Own Funds Level 5 |
17
18\author SAS Institute Inc.
19\date 2018
20
21*/
22CREATE TABLE &LIBREF..MAP_OWN_FUNDS_HIERARCHY (
23 CHART_OF_ACCOUNT_CD VARCHAR(32) label = 'Chart of Account Code',
24 OWN_FUNDS_CD VARCHAR(32) label = 'Own Funds Code',
25 OWN_FUNDS_LEV1 VARCHAR(200) label = 'Own Funds Level 1',
26 OWN_FUNDS_LEV2 VARCHAR(200) label = 'Own Funds Level 2',
27 OWN_FUNDS_LEV3 VARCHAR(200) label = 'Own Funds Level 3',
28 OWN_FUNDS_LEV4 VARCHAR(200) label = 'Own Funds Level 4',
29 OWN_FUNDS_LEV5 VARCHAR(200) label = 'Own Funds Level 5',
30 CONSTRAINT PRIM_KEY PRIMARY KEY (CHART_OF_ACCOUNT_CD, OWN_FUNDS_CD)
31);