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