PJS_PROG_ORG_CAL_CURR_INFO
This table stores BU, Calendar and Currency Info for program performance reporting.
Details
-
Schema: FUSION
-
Object owner: PJS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
PJS_PROG_ORG_CAL_CURR_INFO_PK |
RECORD_TYPE, ORG_ID, LEDGER_ID, GL_CURRENCY_CODE, GL_CALENDAR_ID, GL_PERIOD_SET_NAME, GL_PERIOD_TYPE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| RECORD_TYPE | VARCHAR2 | 30 | Yes | Column to store type of the record. | |
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| LEDGER_ID | NUMBER | 18 | Yes | Unique identifier of the ledger. | |
| GL_CURRENCY_CODE | VARCHAR2 | 15 | Yes | Functional currency of the ledger. | |
| GL_CALENDAR_ID | NUMBER | 18 | Yes | Unique identifier of the ledger calendar. | |
| GL_PERIOD_SET_NAME | VARCHAR2 | 15 | Yes | Name of the accounting calendar. | |
| GL_PERIOD_TYPE | VARCHAR2 | 15 | Yes | Accounting period type. Examples are Weekly, Monthly, Quarterly. | |
| 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_ORG_CAL_CURR_INFO_N2 | Non Unique | Default | RECORD_TYPE, GL_CURRENCY_CODE |
| PJS_PROG_ORG_CAL_CURR_INFO_N3 | Non Unique | Default | RECORD_TYPE, GL_CALENDAR_ID |
| PJS_PROG_ORG_CAL_CURR_INFO_U1 | Unique | Default | RECORD_TYPE, ORG_ID, LEDGER_ID, GL_CURRENCY_CODE, GL_CALENDAR_ID, GL_PERIOD_SET_NAME, GL_PERIOD_TYPE |