Emps

Columns


Name	Type	SupportedFinders	Description
Salutation	String		Person salutation such as Mr., Ms., and so on. Valid values are defined in the list SalutationLOV.
FirstName	String		Person's first name.
MiddleName	String		Person's middle name.
LastName	String		Person's last name.
PreviousLastName	String		Previous last name of the person, if any.
NameSuffix	String		Part of the name appended to a person's last name such as Jr., III, etc.
DisplayName	String		Person's display name.
PreferredName	String		Person's preferred first name.
Honors	String		Higher qualification appended to a person's name. For example, PhD.
CorrespondenceLanguage	String		Preferred language for communication. Valid values are defined in the list CorrespondenceLanguageLOV.
PersonNumber	String		Number assigned to a person to identify the person uniquely. Does not depend on the person type (employee, contingent worker, etc). Search on this attribute is not case sensitive.
WorkPhoneCountryCode	String		Country code of the work phone number, such as 39 for Italy.
WorkPhoneAreaCode	String		Area code of the work phone number.
WorkPhoneNumber	String		Work phone number.
WorkPhoneExtension	String		Extension of the work phone number.
WorkPhoneLegislationCode	String		Legislation code of the work phone number.
WorkFaxCountryCode	String		Country code of the phone number for the work fax machine.
WorkFaxAreaCode	String		Area code of the phone number for the work fax machine.
WorkFaxNumber	String		Phone number for the home fax machine.
WorkFaxExtension	String		Extension of the phone number for the work fax machine.
WorkFaxLegislationCode	String		Legislation code of the work fax number.
WorkMobilePhoneCountryCode	String		Country code of the work mobile phone number.
WorkMobilePhoneAreaCode	String		Area code of the work mobile phone number.
WorkMobilePhoneNumber	String		Work mobile phone number.
WorkMobilePhoneExtension	String		Extension of the work mobile phone number.
WorkMobilePhoneLegislationCode	String		Legislation code of the work mobile phone number.
HomePhoneCountryCode	String		Country code of the home phone number.
HomePhoneAreaCode	String		Area code of the home phone number.
HomePhoneNumber	String		Home phone number.
HomePhoneExtension	String		Extension of the home phone number.
HomePhoneLegislationCode	String		Legislation code of the home phone number.
HomeFaxCountryCode	String		Country code of the phone number for the home fax machine.
HomeFaxAreaCode	String		Area code of the phone number for the home fax machine.
HomeFaxNumber	String		Phone number for the home fax machine.
HomeFaxExtension	String		Extension of the phone number for the home fax machine.
WorkEmail	String		Person's work email address. Search on this attribute is not case sensitive.
HomeFaxLegislationCode	String		Legislation code of the home fax number.
AddressLine1	String		First line of the primary mailing address.
AddressLine2	String		Second line of the primary mailing address.
AddressLine3	String		Third line of the primary mailing address.
City	String		Town or city in which the address is located.
Region	String		Primary region in which the address is located.
Region2	String		Secondary region within the primary region.
Country	String		Country in which the address is located.
PostalCode	String		Postal code of the address.
DateOfBirth	Date		Date of birth of the person.
Ethnicity	String		Person's ethnicity for the legislation code. Valid values are defined in the list EthnicityLOV.
ProjectedTerminationDate	Date		Projected termination date for the worker.
LegalEntityId	Long		Unique identifier for the legal entity. Valid values are defined in the list LegalEmployerLOV.
HireDate	Date		Hire date of the employee.
TerminationDate	Date		TerminationDate of Emps
Gender	String		Person's gender. Valid values are defined in the list GenderLOV.
MaritalStatus	String		Person's marital status. Valid values are defined in the list MaritalStatusLOV.
NationalIdType	String		Type of national identifier. Valid values are defined in the list NationalIdTypeLOV.
NationalId	String		Primary key generated by the application.
NationalIdCountry	String		Country of nationality.
NationalIdExpirationDate	Date		Expiration date of the national identifier.
NationalIdPlaceOfIssue	String		Place where the national identifier was issued.
PersonId [KEY]	Long	FindByPersonId, PrimaryKey	Internal identifier for the person.
EffectiveStartDate [KEY]	Date	PrimaryKey	Date at the beginning of the period within which the employee is effective.
UserName	String		User name for the record. This value is optional and is automatically generated if not specified. Also works with UsernameMatching attribute. Search on this attribute is not case sensitive.
CitizenshipId [KEY]	Long	PrimaryKey	Primary key generated by the application.
CitizenshipStatus	String		Status of the person's citizenship. Valid values are defined in the list CitizenshipStatusLOV.
CitizenshipLegislationCode	String		Legislation code derived from the legal entity. Valid values are defined in the list CitizenshipLegislationCodeLOV.
CitizenshipToDate	Date		End date of citizenship.
Religion	String		Person's religion. Valid values are defined in the list ReligionLOV.
ReligionId [KEY]	Long	PrimaryKey	Primary key generated by the application.
PassportIssueDate	Date		Date of issue of passport.
PassportNumber	String		Person's passport number.
PassportIssuingCountry	String		Country that issued the passport.
PassportId [KEY]	Long	PrimaryKey	Primary key generated by the application.
PassportExpirationDate	Date		Expiration date of the passport.
LicenseNumber	String		Person's driving license number.
DriversLicenseExpirationDate	Date		Expiration date of the driver's license.
DriversLicenseIssuingCountry	String		Country that issued the driver's license.
DriversLicenseId [KEY]	Long	PrimaryKey	System-generated primary key. Surrogate key.
MilitaryVetStatus	String		Indicates whether the person is on military service. Valid values are defined in the list MilitaryVetStatusLOV.
CreationDate	Datetime		CreationDate of Emps
LastUpdateDate	Datetime		LastUpdateDate of Emps
WorkerType	String		WorkerType of Emps
BusinessUnitName	String	FindByAssignmentAttr	BusinessUnitName of Emps
DepartmentName	String	FindByAssignmentAttr	DepartmentName of Emps
Finder	String		Finder of Emps
GradeName	String	FindByAssignmentAttr	GradeName of Emps
JobName	String	FindByAssignmentAttr	JobName of Emps
LocationName	String	FindByAssignmentAttr	LocationName of Emps
ManagerFullName	String	FindByAssignmentAttr	ManagerFullName of Emps
SysEffectiveDate	String	FindByPersonId	SysEffectiveDate of Emps

SSIS Components for Oracle Fusion Cloud HCM

Emps

Columns