TM_USERS_TIME_APPROVERS

This many-to-one cross reference table stores the users who are the time approvers for each time sheet item.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

TM_TIME_SHEET_LINES

TIME_SHEET_LINE_ID

APPROVER_TIME_SHEET_LINE_ID

KNTA_USERS

USER_ID

TIME_APPROVER_USER_ID

Column Descriptions

Column Name

Null?

Data Type

Description

APPROVER_TIME_SHEET_LINE_ID

NOT NULL

NUMBER

References the TIME_SHEET_LINE_ID in TM_TIME_SHEET_LINESS that this approval record is for.

TIME_APPROVER_USER_ID

NOT NULL

NUMBER

References the USER_ID in KNTA_USERS of a user who can act as a time approver for the associated time sheet item.

TYPE NULLABLE VARCHAR2(20) Identifies the type of time approver
SOURCE NULLABLE VARCHAR2(100) Identifies the source of time approver

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C001086734

UNIQUE

1

APPROVER_TIME_SHEET_LINE_ID

SYS_C001086734

UNIQUE

2

TIME_APPROVER_USER_ID

SYS_C001086734 UNIQUE 3 TYPE
SYS_C001086734 UNIQUE 4 SOURCE

Sequences

This table uses no sequences.