Share this page
PPM_FISCAL_PERIODS_NLS
This table stores the list of weekly, monthly, quarterly, half-yearly and yearly fiscal periods.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
PPM_FISCAL_PERIODS_NLS |
FISCAL_PERIOD_ID |
PARENT_PERIOD_ID |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
FISCAL_PERIOD_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
|
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
|
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
|
DEFINITION_LANGUAGE |
NOT NULL |
VARCHAR2(255) |
Language definition for MLU |
|
PERIOD_TYPE |
NOT NULL |
NUMBER |
Numeric value to identify the type of fiscal period (4=MONTH, 5=QUARTER, 6=YEAR, 7=HALF_YEAR, 8=WEEK) |
|
PARENT_PERIOD_ID |
NULLABLE |
NUMBER |
Identifies this fiscal period's parent period. |
|
START_DATE |
NOT NULL |
DATE |
Date on which the fiscal period starts (inclusive) |
|
END_DATE |
NOT NULL |
DATE |
Date on which the fiscal period ends (inclusive) |
|
LONG_NAME |
NOT NULL |
VARCHAR2(100) |
Name for the defined fiscal period |
|
SHORT_NAME |
NOT NULL |
VARCHAR2(50) |
Abbreviated name for the defined fiscal period |
|
CHILD_PERIOD_SEQ |
NULLABLE |
NUMBER |
Chronological order of the fiscal period within its parent period |
|
SEQ |
NOT NULL |
NUMBER |
Chronological order of the fiscal period within the period type |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
PPM_FISCAL_PERIODS_NLS_N1 |
NONUNIQUE |
1 |
PARENT_PERIOD_ID |
|
PPM_FISCAL_PERIODS_NLS_PK |
UNIQUE |
1 |
FISCAL_PERIOD_ID |
|
PPM_FISCAL_PERIODS_NLS_U1 |
UNIQUE |
1 |
START_DATE |
|
PPM_FISCAL_PERIODS_NLS_U1 |
UNIQUE |
2 |
END_DATE |
|
PPM_FISCAL_PERIODS_NLS_U1 |
UNIQUE |
3 |
PERIOD_TYPE |
|
PPM_FISCAL_PERIODS_NLS_U2 |
UNIQUE |
1 |
PERIOD_TYPE |
|
PPM_FISCAL_PERIODS_NLS_U2 |
UNIQUE |
2 |
SEQ |
| PPM_FISCAL_PERIODS_NLS_N2 | NONUNIQUE | 1 | PERIOD_TYPE |
| PPM_FISCAL_PERIODS_NLS_N2 | NONUNIQUE | 2 | START_DATE |
| PPM_FISCAL_PERIODS_NLS_N2 | NONUNIQUE | 3 | END_DATE |
| PPM_FISCAL_PERIODS_NLS_N2 | NONUNIQUE | 4 | FISCAL_PERIOD_ID |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
PPM_FISCAL_PERIODS_NLS_S |
FISCAL_PERIOD_ID |
