Share this page
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.
