TM_USERS_BILLING_APPROVERS

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

Foreign Keys

Primary Key Table	Primary Key Column	Foreign Key Column
KNTA_USERS	USER_ID	BILLING_APPROVER_USER_ID
TM_TIME_SHEETS	TIME_SHEET_ID	BILLING_APPROVER_TIME_SHEET_ID

Column Descriptions

Column Name	Null?	Data Type	Description
BILLING_APPROVER_TIME_SHEET_ID	NOT NULL	NUMBER	References the TIME_SHEET_ID in TM_TIME_SHEETS that this approval record is for.
BILLING_APPROVER_USER_ID	NOT NULL	NUMBER	References the USER_ID in KNTA_USERS of a user who can act as a billing approver for associated time sheet.
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_C001086735	UNIQUE	1	BILLING_APPROVER_TIME_SHEET_ID
SYS_C001086735	UNIQUE	2	BILLING_APPROVER_USER_ID
SYS_C001086735	UNIQUE	3	TYPE
SYS_C001086735	UNIQUE	4	SOURCE

Sequences

This table uses no sequences.