Attributes for Worker Employment Contract

This table lists the main attributes of the Worker Employment Contract business object and exceptions for any attribute, if any.

Attribute	Field Name	Description
ASSIGNMENT_ID	Assignment ID	Identifies a set of employment or placement terms. Foreign key to PER_ALL_ASSIGNMENTS_M.
BUSINESS_GROUP_ID	Business Group ID	Identifier of enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS.
CONTRACT_END_DATE	Contact End Date	The date the contract is expected to end.
CONTRACT_ID	Contract ID	System generated primary key.
CONTRACT_NUMBER	Contract Number	Uniquely identifies a contract. If there are multiple contracts under a work relationship, sequence value will be incremented.
CONTRACTUAL_JOB_TITLE	Contractual Job Title	The contractual job title, not related to PER_JOBS.
CREATED_BY	Created By	Who column: Indicates the user who created the row.
CREATION_DATE	Creation Date	Who column: Indicates the date and time of the creation of the row.
DESCRIPTION	Description	Description of the contract.
DOC_STATUS	Document Status	This column holds the status of the physical contract.
DOC_STATUS_CHANGE_DATE	Document Status Change Date	Holds the date that the DOC_STATUS column last changed its value.
DURATION	Contract Duration	The duration of the contract.
DURATION_UNITS	Contract Duration Units	The units of time in which the duration is expressed.
EFFECTIVE_END_DATE	End Date	Date Effective Entity: Indicates the date at the end of the date range within which the row is effective.
EFFECTIVE_START_DATE	Start Date	Date Effective Entity: Indicates the date at the beginning of the date range within which the row is effective.
END_REASON	End Reason	The reason for ending the contract.
EXTENSION_PERIOD	Extension Period	The period of time for which the contract has been extended.
EXTENSION_PERIOD_UNITS	Extension Period Units	The units of time in which the extension period has been expressed.
EXTENSION_REASON	Extension Reason	The reason for extending the contract.
LAST_UPDATE_DATE	Last Update Date	Who column: Indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN	Last Update Login	Who column: Indicates the session login associated with the user who last updated the row.
LAST_UPDATED_BY	Last Update By	Who column: Indicates the user who last updated the row.
LEGISLATION_CODE	Legislation Code
NUMBER_OF_EXTENSIONS	Number of Extensions	The number of times the contract has been extended.
OBJECT_VERSION_NUMBER	Object Version Number	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.
PARTIES	Signatory Parties	The signatory parties (other than the employee).
PERIOD_OF_SERVICE_ID	Period of Service ID	Identifies the employment level. One to many relationship from PER_PERIODS_OF_SERVICE.
PERSON_ID	Person ID	Foreign key to PER_PERSONS.
START_REASON	Start Reason	The reason for the contracts existence.
STATUS	Contract Status	The status of the contract.
STATUS_REASON	Status Reason	The reason for the contract's existence.
TYPE	Type	The type of contract.

For more information about the Worker Employment Contract attributes, refer to the Tables and Views for HCM guide on the Oracle Help Center.