KTMG_PERIODS

This table stores the information that defines the time periods used in Time Management.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KTMG_PERIOD_TYPES_NLS

PERIOD_TYPE_ID

PERIOD_TYPE_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

PERIOD_ID

NOT NULL

NUMBER

System-generated identifier

CREATION_DATE

NOT NULL

DATE

Date record was created

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created the record

LAST_UPDATE_DATE

NOT NULL

DATE

Date record was last updated

LAST_UPDATED_BY

NOT NULL

NUMBER

Identifier for the user who last updated the record

PERIOD_NAME

NOT NULL

VARCHAR2(80)

User defined name for the period

PERIOD_TYPE_ID

NOT NULL

NUMBER

Foreign key to KTMG_PERIOD_TYPES table that determines the duration of the period

START_DATE

NOT NULL

DATE

Date on which the period starts (inclusive)

END_DATE

NOT NULL

DATE

Date on which the period ends (inclusive)

SEQ

NOT NULL

NUMBER

Chronological order of the period with in the period type

Indexes

Index Name

Index Type

Sequence

Column Name

KTMG_PERIODS_N1

NONUNIQUE

1

END_DATE

KTMG_PERIODS_U1

UNIQUE

1

PERIOD_ID

KTMG_PERIODS_U2

UNIQUE

1

START_DATE

KTMG_PERIODS_U2

UNIQUE

2

PERIOD_TYPE_ID

KTMG_PERIODS_U3

UNIQUE

1

PERIOD_NAME

KTMG_PERIODS_U3

UNIQUE

2

PERIOD_TYPE_ID

KTMG_PERIODS_U4

UNIQUE

1

PERIOD_TYPE_ID

KTMG_PERIODS_U4

UNIQUE

2

SEQ

Sequences

Sequence Name

Sequence Type

KTMG_PERIODS_S

PERIOD_ID