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 |