Assette Period Code Map Data Block

The Assette Period Code Map (ast_period_code_map) Data Block is an Open-source Data Block.

The Assette Period Code Map (ast_period_code_map) Data Block maps period codes (e.g., “QTD” for “Quarter to Date”) to their display name. These codes represent different time periods or financial reporting intervals such as months, quarters, years, and fiscal years. Some of the codes are for cumulative or annualized data over different periods, like the past 1, 5, or 10 years, while others are for specific quarters or fiscal years.

General Info #

The following table shows the default fields of the Data Block.

Field	Value
Name	ast_period_code_map
Block Category	Interface
Block Type	Constant
Data Category	None
Output Type	Values
Editable	True

Dependencies #

None

Columns #

None

Example Definition #

{
      "QTD": "QUARTERTODATE",
      "YTD": "YEARTODATE",
      "MRQ": "",
      "MRY": "MOSTRECENTCALENDARYEAR",
      "PQ1": "PRIORQUARTER1",
      "PQ2": "PRIORQUARTER2",
      "PQ3": "PRIORQUARTER3",
      "PQ4": "PRIORQUARTER4",
      "PY1": "PRIORCALENDARYEAR1",
      "PY2": "PRIORCALENDARYEAR2",
      "PY3": "PRIORCALENDARYEAR3",
      "PY4": "PRIORCALENDARYEAR4",
      "PY5": "PRIORCALENDARYEAR5",
      "PY6": "PRIORCALENDARYEAR6",
      "PY7": "PRIORCALENDARYEAR7",
      "PY8": "PRIORCALENDARYEAR8",
      "PY9": "PRIORCALENDARYEAR9",
      "PY10": "PRIORCALENDARYEAR10",
      "1MT": "MONTH1",
      "3MT": "MONTHS3",
      "6MT": "MONTHS6",
      "9MT": "MONTHS9",
      "12MT": "YEAR1",
      "2YC": "YEAR2CUMULATIVE",
      "3YC": "YEAR3CUMULATIVE",
      "4YC": "YEAR4CUMULATIVE",
      "5YC": "YEAR5CUMULATIVE",
      "6YC": "YEAR6CUMULATIVE",
      "7YC": "YEAR7CUMULATIVE",
      "8YC": "YEAR8CUMULATIVE",
      "9YC": "YEAR9CUMULATIVE",
      "10YC": "YEAR10CUMULATIVE",
      "12YC": "YEAR12CUMULATIVE",
      "15YC": "YEAR15CUMULATIVE",
      "20YC": "YEAR20CUMULATIVE",
      "25YC": "YEAR25CUMULATIVE",
      "30YC": "YEAR30CUMULATIVE",
      "ITD": "INCEPTIONTODATECUMULATIVE",
      "2YA": "YEAR2ANNUALIZED",
      "3YA": "YEAR3ANNUALIZED",
      "4YA": "YEAR4ANNUALIZED",
      "5YA": "YEAR5ANNUALIZED",
      "6YA": "YEAR6ANNUALIZED",
      "7YA": "YEAR7ANNUALIZED",
      "8YA": "YEAR8ANNUALIZED",
      "9YA": "YEAR9ANNUALIZED",
      "10YA": "YEAR10ANNUALIZED",
      "12YA": "YEAR12ANNUALIZED",
      "15YA": "YEAR15ANNUALIZED",
      "20YA": "YEAR20ANNUALIZED",
      "25YA": "YEAR25ANNUALIZED",
      "30YA": "YEAR30ANNUALIZED",
      "ITDA": "INCEPTIONTODATEANNUALIZED",
      "FYTD": "FISCALYEARTODATE",
      "MRFQ": "",
      "PFQ1": "PRIORFISCALQUARTER1",
      "PFQ2": "PRIORFISCALQUARTER2",
      "PFQ3": "PRIORFISCALQUARTER3",
      "PFQ4": "PRIORFISCALQUARTER4",
      "PFY1": "PRIORFISCALYEAR1",
      "PFY2": "PRIORFISCALYEAR2",
      "PFY3": "PRIORFISCALYEAR3",
      "PFY4": "PRIORFISCALYEAR4",
      "PFY5": "PRIORFISCALYEAR5",
      "PFY6": "PRIORFISCALYEAR6",
      "PFY7": "PRIORFISCALYEAR7",
      "PFY8": "PRIORFISCALYEAR8",
      "PFY9": "PRIORFISCALYEAR9",
      "PFY10": "PRIORFISCALYEAR10",
      "MTD": "MONTHTODATE"
}

Example Request #

The following code shows an example request using the default values of the Data Block.

{}

Example Response #

The following code shows an example response using the default values of the Data Block. The default data source is the Assette Snowflake Demo Instance. The response may be shortened for brevity.

{
    "QTD": "QUARTERTODATE",
    "YTD": "YEARTODATE",
    "MRQ": "",
    "MRY": "MOSTRECENTCALENDARYEAR",
    "PQ1": "PRIORQUARTER1",
    "PQ2": "PRIORQUARTER2",
    "PQ3": "PRIORQUARTER3",
    "PQ4": "PRIORQUARTER4",
    "PY1": "PRIORCALENDARYEAR1",
    "PY2": "PRIORCALENDARYEAR2",
    "PY3": "PRIORCALENDARYEAR3",
    "PY4": "PRIORCALENDARYEAR4",
    "PY5": "PRIORCALENDARYEAR5",
    "PY6": "PRIORCALENDARYEAR6",
    "PY7": "PRIORCALENDARYEAR7",
    "PY8": "PRIORCALENDARYEAR8",
    "PY9": "PRIORCALENDARYEAR9",
    "PY10": "PRIORCALENDARYEAR10",
    "1MT": "MONTH1",
    "3MT": "MONTHS3",
    "6MT": "MONTHS6",
    "9MT": "MONTHS9",
    "12MT": "YEAR1",
    "2YC": "YEAR2CUMULATIVE",
    "3YC": "YEAR3CUMULATIVE",
    "4YC": "YEAR4CUMULATIVE",
    "5YC": "YEAR5CUMULATIVE",
    "6YC": "YEAR6CUMULATIVE",
    "7YC": "YEAR7CUMULATIVE",
    "8YC": "YEAR8CUMULATIVE",
    "9YC": "YEAR9CUMULATIVE",
    "10YC": "YEAR10CUMULATIVE",
    "12YC": "YEAR12CUMULATIVE",
    "15YC": "YEAR15CUMULATIVE",
    "20YC": "YEAR20CUMULATIVE",
    "25YC": "YEAR25CUMULATIVE",
    "30YC": "YEAR30CUMULATIVE",
    "ITD": "INCEPTIONTODATECUMULATIVE",
    "2YA": "YEAR2ANNUALIZED",
    "3YA": "YEAR3ANNUALIZED",
    "4YA": "YEAR4ANNUALIZED",
    "5YA": "YEAR5ANNUALIZED",
    "6YA": "YEAR6ANNUALIZED",
    "7YA": "YEAR7ANNUALIZED",
    "8YA": "YEAR8ANNUALIZED",
    "9YA": "YEAR9ANNUALIZED",
    "10YA": "YEAR10ANNUALIZED",
    "12YA": "YEAR12ANNUALIZED",
    "15YA": "YEAR15ANNUALIZED",
    "20YA": "YEAR20ANNUALIZED",
    "25YA": "YEAR25ANNUALIZED",
    "30YA": "YEAR30ANNUALIZED",
    "ITDA": "INCEPTIONTODATEANNUALIZED",
    "FYTD": "FISCALYEARTODATE",
    "MRFQ": "",
    "PFQ1": "PRIORFISCALQUARTER1",
    "PFQ2": "PRIORFISCALQUARTER2",
    "PFQ3": "PRIORFISCALQUARTER3",
    "PFQ4": "PRIORFISCALQUARTER4",
    "PFY1": "PRIORFISCALYEAR1",
    "PFY2": "PRIORFISCALYEAR2",
    "PFY3": "PRIORFISCALYEAR3",
    "PFY4": "PRIORFISCALYEAR4",
    "PFY5": "PRIORFISCALYEAR5",
    "PFY6": "PRIORFISCALYEAR6",
    "PFY7": "PRIORFISCALYEAR7",
    "PFY8": "PRIORFISCALYEAR8",
    "PFY9": "PRIORFISCALYEAR9",
    "PFY10": "PRIORFISCALYEAR10",
    "MTD": "MONTHTODATE",
    "errors": [],
    "success": true,
    "logs": []
}