FM_USER_DATA

This table stores user data at forecast actual level, forecast actual line level, benefit level, and benefit line level.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KNTA_USERS

USER_ID

LAST_UPDATED_BY

KNTA_USERS

USER_ID

CREATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

USER_DATA_ID

NOT NULL

NUMBER

System-generated identifier

VERSION

NOT NULL

NUMBER

System-generated version for the entity. This column must not be updated manually.

DATUM1_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM1_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM10_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM10_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM11_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM11_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM12_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM12_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM13_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM13_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM14_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM14_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM15_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM15_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM16_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM16_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM17_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM17_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM18_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM18_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM19_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM19_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM2_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM2_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM20_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM20_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM3_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM3_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM4_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM4_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM5_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM5_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM6_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM6_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM7_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM7_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM8_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM8_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

DATUM9_VISIBLE

NULLABLE

VARCHAR2(255)

User data visible value

DATUM9_CODE

NULLABLE

VARCHAR2(255)

User data hidden value

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

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005201530

UNIQUE

1

USER_DATA_ID

Sequences

Sequence Name

Sequence Type

FM_USER_DATA_S

USER_DATA_ID