SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
map_balance_sheet_hierarchy.sas
1/* Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA */
2
3/*!
4 \file
5 \brief Balance Sheet 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) | BALANCE_SHEET_CD | VARCHAR(32) | Y | | Balance Sheet Code | Balance Sheet Code |
12 | | BALANCE_SHEET_LEV1 | VARCHAR(200) | N | | Level 1 of the Balance Sheet hierarchy | Balance Sheet Level 1 |
13 | | BALANCE_SHEET_LEV2 | VARCHAR(200) | N | | Level 2 of the Balance Sheet hierarchy | Balance Sheet Level 2 |
14 | | BALANCE_SHEET_LEV3 | VARCHAR(200) | N | | Level 3 of the Balance Sheet hierarchy | Balance Sheet Level 3 |
15 | | BALANCE_SHEET_LEV4 | VARCHAR(200) | N | | Level 4 of the Balance Sheet hierarchy | Balance Sheet Level 4 |
16 | | BALANCE_SHEET_LEV5 | VARCHAR(200) | N | | Level 5 of the Balance Sheet hierarchy | Balance Sheet Level 5 |
17 | | ROLL_UP | VARCHAR(10) | N | | Roll-up flag | Yes/No flag to specify roll-up |
18
19\author SAS Institute Inc.
20\date 2018
21
22*/
23CREATE TABLE &LIBREF..MAP_BALANCE_SHEET_HIERARCHY (
24 CHART_OF_ACCOUNT_CD VARCHAR(32) label = 'Chart of Account Code',
25 BALANCE_SHEET_CD VARCHAR(32) label = 'Balance Sheet Code',
26 BALANCE_SHEET_LEV1 VARCHAR(200) label = 'Balance Sheet Level 1',
27 BALANCE_SHEET_LEV2 VARCHAR(200) label = 'Balance Sheet Level 2',
28 BALANCE_SHEET_LEV3 VARCHAR(200) label = 'Balance Sheet Level 3',
29 BALANCE_SHEET_LEV4 VARCHAR(200) label = 'Balance Sheet Level 4',
30 BALANCE_SHEET_LEV5 VARCHAR(200) label = 'Balance Sheet Level 5',
31 ROLL_UP VARCHAR(10) label = 'Roll-Up',
32 CONSTRAINT PRIM_KEY PRIMARY KEY (CHART_OF_ACCOUNT_CD, BALANCE_SHEET_CD)
33);