KNTA_PERIOD_TYPES

This table stores information about period types.

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	CREATED_BY
KNTA_USERS	USER_ID	LAST_UPDATED_BY

Column Descriptions

Column Name	Null?	Data Type	Description
PERIOD_TYPE_ID	NOT NULL	NUMBER	System-generated identifier
CREATION_DATE	NOT NULL	DATE	Date record was created
CREATED_BY	NOT NULL	NUMBER	User who created the record
LAST_UPDATE_DATE	NOT NULL	DATE	Date record was last updated
LAST_UPDATED_BY	NOT NULL	NUMBER	User who last updated the record
PERIOD_TYPE_NAME	NOT NULL	VARCHAR2(100)
DESCRIPTION	NOT NULL	VARCHAR2(250)
START_DAY_CODE	NOT NULL	VARCHAR2(30)
ENABLED_FLAG	NOT NULL	VARCHAR2(1)
DEFINITION_LANGUAGE	NOT NULL	VARCHAR2(40)
REFERENCE_CODE	NOT NULL	VARCHAR2(200)

Indexes

Index Name	Index Type	Sequence	Column Name
KNTA_PERIOD_TYPES_U1	UNIQUE	1	PERIOD_TYPE_ID
SYS_C005198572	UNIQUE	1	REFERENCE_CODE

Sequences

This table uses no sequences.