PJS_PROG_CURRENCIES

This table stores program performance reporting currencies.

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

PJS_PROG_CURRENCIES_PK

CURRENCY_CODE

Columns

Name Datatype Length Not-null Comments
CURRENCY_CODE VARCHAR2 30 Yes Column to store ISO currency code.
DEFAULT_FLAG VARCHAR2 1 Indicates whether the currency is the default for the analyze program UI. Yes means it's the default when the user's preferred currency is disabled for program reporting. No means it's not the default.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
ADDL_ATTRIBUTE1 VARCHAR2 150 Column supporting alphanumeric characters reserved for internal use.
ADDL_ATTRIBUTE2 VARCHAR2 150 Column supporting alphanumeric characters reserved for internal use.
ADDL_ATTRIBUTE3 VARCHAR2 150 Column supporting alphanumeric characters reserved for internal use.
ADDL_ATTRIBUTE4 VARCHAR2 150 Column supporting alphanumeric characters reserved for internal use.
ADDL_ATTRIBUTE5 VARCHAR2 150 Column supporting alphanumeric characters reserved for internal use.

Indexes

Index Uniqueness Tablespace Columns
PJS_PROG_CURRENCIES_U1 Unique Default CURRENCY_CODE