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.