SAS Documentation
SASĀ® Solution for Stress Testing
Reference manual - version 08.2021
Loading...
Searching...
No Matches
own_funds_account.sas
Go to the documentation of this file.
1/*
2 Copyright (C) 2018 SAS Institute Inc. Cary, NC, USA
3*/
4
5/**
6 \file
7 \brief Own Funds account
8 \details
9
10 |PK |Variable |Type | Required? |Relationships |Label |Description | Required by models |
11 |--------------|--------------------------|----------------|-----------|------------------------------------------------|--------------------------------|-----------------------------------------------------------------------|----------------------------------------------------------------------------------|
12 | ![ ](pk.jpg) | <b>REPORTING_DT</b> | NUMERIC(8) | Y | | Reporting Date | Reporting Period | ST - Financial Statement Projection |
13 | | <b>ENTITY_ID</b> | VARCHAR(32) | Y | \link entity.sas \endlink | Entity Id | Unique Entity identifier | ST - Financial Statement Projection |
14 | ![ ](pk.jpg) | <b>OF_ACCOUNT_ID</b> | VARCHAR(32) | Y | | Own Funds Account Id | Identifier of the Own Funds account | ST - Financial Statement Projection |
15 | ![ ](pk.jpg) | <b>FORECAST_HORIZON</b> | NUMERIC(8) | Y | | Forecast Horizon | Forecast horizon: <br> - FORECAST_HORIZON = 0 identifies actual values. <br> - FORECAST_HORIZON > 0 indicate forecasts. <br> Forecast values (if any) override any computed values | ST - Financial Statement Projection |
16 | | GEOGRAPHY_CD | VARCHAR(32) | N | \link map_geo_hierarchy.sas \endlink | Geography Code | Geography code | |
17 | | CHART_OF_ACCOUNT_CD | VARCHAR(32) | N | \link map_chart_of_account.sas \endlink | Chart of Account Code | Chart of Account Code | |
18 | | OWN_FUNDS_CD | VARCHAR(32) | N | \link map_own_funds_hierarchy.sas \endlink | Own Funds Code | Own Funds Code | ST - Financial Statement Projection |
19 | ![ ](pk.jpg) | <b>SCENARIO_ID</b> | VARCHAR(32) | Y | | Scenario Id | Scenario Identifier | |
20 | ![ ](pk.jpg) | <b>MOVEMENT_TYPE_CD</b> | VARCHAR(32) | Y | \link map_movement_type.sas \endlink | Movement Type Code | Movement Type Code | |
21 | | CURRENCY_CD | VARCHAR(3) | N | | Currency Code | 3 character ISO code for nominal currency of Own Funds account value | |
22 | | BALANCE_SHEET_CD | VARCHAR(32) | N | | Balance Sheet Code | Balance Sheet Code | ST - Financial Statement Projection |
23 | | OF_ACCOUNT_VALUE_AMT | NUMERIC(8) | N | | Own Funds Account Value Amount | Value amount of the Own Funds account | ST - Financial Statement Projection |
24
25 \author SAS Institute Inc.
26 \date 2018
27
28*/
29CREATE TABLE &LIBREF..OWN_FUNDS_ACCOUNT (
30 REPORTING_DT DATE label = 'Reporting Date' FORMAT = &DTFMT.,
31 ENTITY_ID VARCHAR(32) label = 'Entity Id',
32 OF_ACCOUNT_ID VARCHAR(32) label = 'Own Funds Account Id',
33 FORECAST_HORIZON NUMERIC label = 'Forecast Horizon',
34 GEOGRAPHY_CD VARCHAR(32) label = 'Geography Code',
35 CHART_OF_ACCOUNT_CD VARCHAR(32) label = 'Chart of Account Code',
36 OWN_FUNDS_CD VARCHAR(32) label = 'Own Funds Code',
37 SCENARIO_ID VARCHAR(32) label = 'Scenario Id',
38 MOVEMENT_TYPE_CD VARCHAR(32) label = 'Movement Type Code',
39 CURRENCY_CD VARCHAR(3) label = 'Currency Code',
40 BALANCE_SHEET_CD VARCHAR(32) label = 'Balance Sheet Code',
41 OF_ACCOUNT_VALUE_AMT NUMERIC(8) label = 'Own Funds Account Value Amount' FORMAT = NLNUM15.3,
42 CONSTRAINT PRIM_KEY PRIMARY KEY (REPORTING_DT, ENTITY_ID, OF_ACCOUNT_ID, FORECAST_HORIZON, SCENARIO_ID, MOVEMENT_TYPE_CD)
43);