KTMG_PAGE_COLUMNS

This table stores information for page columns for Time Management.

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

PAGE_COLUMN_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

PAGE_NAME

NOT NULL

VARCHAR2(100)

Name of the page the column resides on

SEQ

NOT NULL

NUMBER

Sequence of the page column

COLUMN_NAME

NOT NULL

VARCHAR2(100)

Name of the page column

COLUMN_TITLE

NOT NULL

VARCHAR2(100)

Title of the page column

FIELD_WIDTH

NULLABLE

NUMBER

Width of the field

NUMERIC_FLAG

NOT NULL

VARCHAR2(1)

Flag to determine whether the field is numeric

ENABLED_FLAG

NOT NULL

VARCHAR2(1)

Flag to determine whether the page column is enabled

Indexes

Index Name

Index Type

Sequence

Column Name

KTMG_PAGE_COLUMNS_U1

UNIQUE

1

PAGE_COLUMN_ID

KTMG_PAGE_COLUMNS_U2

UNIQUE

1

PAGE_NAME

KTMG_PAGE_COLUMNS_U2

UNIQUE

2

COLUMN_NAME

Sequences

Sequence Name

Sequence Type

KTMG_PAGE_COLUMNS_S

PAGE_COLUMN_ID