EXM_DELEGATIONS

This table contains the list of individuals and the persons they have authorized to enter expense reports on their behalf.

Details

• Schema: FUSION

• Object owner: EXM

• Object type: TABLE

• Tablespace: Default

Primary Key

Name	Columns
EXM_DELEGATIONS_PK	DELEGATION_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
DELEGATION_ID	NUMBER		18	Yes	Unique identifier of a delegation authorization.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
PERSON_ID	NUMBER		18		Unique person identifier of the individual who delegated expense entry.
ASSIGNMENT_ID	NUMBER		18		Unique assignment identifier of the individual who delegated expense entry.
DELEGATE_PERSON_ID	NUMBER		18	Yes	Unique person identifier of the individual who is authorized to enter expense reports for another individual.
START_DATE	DATE				Date from which the delegate is authorized to enter expense reports for another individual.
END_DATE	DATE				Date from which the delegate can no longer enter expense reports for another individual.
ENABLE_ACCOUNTS_FLAG	VARCHAR2	1			Indicator of whether the individual who delegated expense entry can charge expenses to cost centers other than the default cost center.
ENABLE_PROJECTS_FLAG	VARCHAR2	1			Indicator of whether the individual who delegated expense entry can charge expenses to projects.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
INACTIVE_EMPLOYEE_FLAG	VARCHAR2	1			Indicates whether a person is an inactive employee.
DELEGATION_TYPE_CODE	VARCHAR2	30			Delegation Type is based on the non-extensible Lookup type, ORA_EXM_DELEGATION_TYPE.
DELEGATION_ASSIGNMENT_ID	NUMBER		18		Identifier of the delegation type, for example, if the type is Business Unit this column will have the BU_ID, if the type is Individual, this column will have the PERSON_ID.
DELEGATION_ASSIGNMENT_VALUE	VARCHAR2	25			Value of the assignment based on the assignment type.
COMMENTS	VARCHAR2	960			Free form text field for the manager to add any comments to the delegation.

Indexes

Index	Uniqueness	Tablespace	Columns
EXM_DELEGATIONS_N1	Non Unique	Default	PERSON_ID, ASSIGNMENT_ID
EXM_DELEGATIONS_U1	Unique	Default	DELEGATION_ID