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 |