Siebel Employee

The Siebel Employee ASI is an ASI for employee-related business processes. The Employee Integration Object enables inbound and outbound data integration between Siebel applications and third-party applications that process employee data. This can include employee core data, job-related data, responsibilities, position, or resume data. The integration business services are included to perform the basic Create, Update, Delete, and Query functions on Employee objects in the Siebel application. The following image shows the Siebel Employee ASI structure, which contains the following components: . Personal Address, Related Organization, Related Position (Related Position Business Address), Related Subcontractor, CMS Certification Qualification, CMS Education, CMS Past Work Experience, CMS Honors Award, CMS Memberships. There is a one-to-many relationship between Employee and its components.

The following table lists the Siebel Employee integration components.

Integration Component	XML Tag	User Keys
CMS Certifications Qualifications	CmsCertificationsQualifications	Id Integration Id Certification
CMS Education	CmsEducation	Id Integration Id Education
CMS Employee Competency Administration	CmsEmployeeCompetencyAdministration	Competency Id Employee Id
CMS Honors Awards	CmsHonorsAwards	Id Integration Id Honor Award
CMS Memberships	CmsMemberships	Id Integration Id Membership
CMS Past Work Experience	CmsPastWorkExperience	Id Integration Id Company Name
Employee	Employee	Id Integration Id Login Domain, Login Name Login Name First Name, Last Name, Middle Name
Employee_Employee Organization	EmployeeEmployeeOrganization	Employee Organization Id Employee Organization Integration Id Employee Organization
Employee_Personal Address	EmployeePersonalAddress	Personal Address Id Personal Address Integration Id
Employee_Position	EmployeePosition	Position Id Position Integration Id Division, Position
Employee_Subcontractor	EmployeeSubcontractor	Subcontractor Account Id Subcontractor Integration Id Subcontractor Name
Employee_Responsibility	EmployeeResponsibility	Responsibility Id Responsibility Integration Id Responsibility
Personal Address	PersonalAddress	Personal Address Id Personal Address Integration Id
Related Employee Organization	RelatedEmployeeOrganization	Employee Organization Id Employee Organization Integration Id Employee Organization
Related Position	RelatedPosition	Position Id Position Integration Id Division, Position
Related Position Business Address	RelatedPositionBusinessAddress	Address Id
Related Responsibility	RelatedResponsibility	Responsibility Id Responsibility Integration Id Responsibility
Related Subcontractor	RelatedSubcontractor	Subcontractor Account Id Subcontractor Integration Id Subcontractor Name

CMS Certifications Qualifications Fields in Siebel Employee ASI

The following table lists the CMS Certifications Qualifications fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Certification	Certification	DTYPE_TEXT	30	No
Comments	Comments	DTYPE_TEXT	250	No
Date of Certification	DateofCertification	DTYPE_TEXT	N/A	No
Id	Id	DTYPE_ID	30	No
Institution	Institution	DTYPE_TEXT	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
operation	operation	DTYPE_TEXT	30	No

CMS Education Fields in Siebel Employee ASI

The following table lists the CMS Education fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Comments	Comments	DTYPE_TEXT	250	No
Country	Country	DTYPE_TEXT	30	No
Degree	Degree	DTYPE_TEXT	30	No
Education	Education	DTYPE_TEXT	30	No
Grade	Grade	DTYPE_TEXT	30	No
Graduation Date	GraduationDate	DTYPE_TEXT	N/A	No
Id	Id	DTYPE_ID	30	No
Institution	Institution	DTYPE_TEXT	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Major	Major	DTYPE_TEXT	30	No
Number of Years	NumberofYears	DTYPE_NUMBER	N/A	No
Scale	Scale	DTYPE_TEXT	30	No
Type of Education	TypeofEducation	DTYPE_TEXT	30	No
operation	operation	DTYPE_TEXT	30	No

CMS Employee Competency Administration Fields in Siebel Employee ASI

The following table lists the CMS Employee Competency Administration fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Competency Id	CompetencyId	DTYPE_ID	N/A	No
Skill Name	SkillName	DTYPE_TEXT	50	No
Current Skill Level	CurrentSkillLevel	DTYPE_TEXT	100	No
Current Skill Level Id	CurrentSkillLevelId	DTYPE_ID	N/A	No
Current Skill Level Value	CurrentSkillLevelValue	DTYPE_NUMBER	N/A	No
Date of Accomplishment	DateOfAccomplishment	DTYPE_DATETIME	N/A	No
Employee Id	EmployeeId	DTYPE_ID	N/A	No
Id	Id	DTYPE_ID	30	No
Required Skill Level Value	RequiredSkillLevelValue	DTYPE_NUMBER	N/A	No
Required Skill Level Id	RequiredSkillLevel Id	DTYPE_ID	N/A	No
Parent Skill	ParentSkill	DTYPE_TEXT	50	No
Rating Scale Id	RatingScaleId	DTYPE_ID	N/A	No
Required Skill Level	Required Skill Level	DTYPE_TEXT	100	No
operation	operation	DTYPE_TEXT	30	No
Updated	Updated	DTYPE_DATETIME	30	No
Status	Status	DTYPE_TEXT	30	No
Skill Gap	SkillGap	DTYPE_NUMBER	N/A	No
Skill Description	SkillDescription	DTYPE_TEXT	250	No
Root Category Id	RootCategoryId	DTYPE_ID	N/A	No
Root Category	RootCategory	DTYPE_TEXT	50	No
searchspec	searchspec	DTYPE_TEXT	250	No
Manager Comments	ManagerComments	DTYPE_TEXT	2000	No
Employee Comments	EmployeeComments	DTYPE_TEXT	2000	No
Delete Record Flag	DeleteRecordFlag	DTYPE_TEXT	N/A	No
Criticality	Criticality	DTYPE_TEXT	30	No
Created	Created	DTYPE_DATETIME	30	No
Conflict Id	ConflictId	DTYPE_ID	30	No
Category Id	CategoryId	DTYPE_ID	N/A	No
Assessment Type	AssessmentType	DTYPE_TEXT	30	No
Approved By Id	ApprovedById	DTYPE_ID	N/A	No
Mod Id	ModId	DTYPE_ID	30	No

CMS Honors Awards Fields in Siebel Employee ASI

The following table lists the CMS Honors Awards fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Name	XML Tag	Data Type	Length	Req.
Comments	Comments	DTYPE_TEXT	250	No
Honor Award	HonorAward	DTYPE_TEXT	30	No
Id	Id	DTYPE_ID	30	No
Institution	Institution	DTYPE_TEXT	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Received Date	ReceivedDate	DTYPE_TEXT	N/A	No
Relevance to Company	RelevancetoCompany	DTYPE_TEXT	30	No
operation	operation	DTYPE_TEXT	30	No

CMS Memberships Fields in Siebel Employee ASI

The following table lists the CMS Memberships fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Active Status	ActiveStatus	DTYPE_TEXT	N/A	No
Comments	Comments	DTYPE_TEXT	250	No
End Date	EndDate	DTYPE_TEXT	N/A	No
Id	Id	DTYPE_ID	30	No
Institution	Institution	DTYPE_TEXT	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Membership	Membership	DTYPE_TEXT	30	No
Relevance to Company	RelevancetoCompany	DTYPE_TEXT	30	No
Start Date	StartDate	DTYPE_TEXT	N/A	No
operation	operation	DTYPE_TEXT	30	No

CMS Past Work Experience Fields in Siebel Employee ASI

The following table lists the CMS Past Work Experience fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Business Title	BusinessTitle	DTYPE_TEXT	50	No
Business Unit	BusinessUnit	DTYPE_TEXT	30	No
Comments	Comments	DTYPE_TEXT	250	No
Company Name	CompanyName	DTYPE_TEXT	30	No
End Date	EndDate	DTYPE_TEXT	N/A	No
First Name	FirstName	DTYPE_TEXT	50	No
Id	Id	DTYPE_ID	30	No
Industry	Industry	DTYPE_ID	N/A	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Last Name	LastName	DTYPE_TEXT	50	No
Position	Position	DTYPE_TEXT	50	No
Start Date	StartDate	DTYPE_TEXT	N/A	No
operation	operation	DTYPE_TEXT	30	No

Employee Fields in Siebel Employee ASI

The following table lists the Employee fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Alias	Alias	DTYPE_TEXT	50	No
Availability Status	AvailabilityStatus	DTYPE_TEXT	30	No
Availability Status Until	AvailabilityStatusUntil	DTYPE_TEXT	N/A	No
Bonus Target %	BonusTarget	DTYPE_NUMBER	N/A	No
Building Number	BuildingNumber	DTYPE_TEXT	30	No
CP Region	CPRegion	DTYPE_TEXT	50	No
CP Region Id	CPRegionId	DTYPE_ID	N/A	No
CP Region Integration Id	CPRegionIntegrationId	DTYPE_TEXT	30	No
Cell Phone #	CellPhone	DTYPE_TEXT	N/A	No
Cost Currency Code	CostCurrencyCode	DTYPE_TEXT	30	No
Cost Per Hour	CostPerHour	DTYPE_TEXT	N/A	No
Cubicle Number	CubicleNumber	DTYPE_TEXT	20	No
EMail Addr	EMailAddr	DTYPE_TEXT	50	No
Emergency Notification	EmergencyNotification	DTYPE_TEXT	30	No
Emp #	Emp	DTYPE_TEXT	30	No
Employee Flag	EmployeeFlag	DTYPE_TEXT	N/A	No
Employee Type Code	EmployeeTypeCode	DTYPE_TEXT	30	No
Employment Status	EmploymentStatus	DTYPE_TEXT	30	No
End Shift to	EndShiftto	DTYPE_TEXT	30	No
Fax #	Fax	DTYPE_TEXT	N/A	No
First Name	FirstName	DTYPE_TEXT	50	No
Hire Date	HireDate	DTYPE_DATETIME	N/A	No
Home Phone #	HomePhone	DTYPE_TEXT	N/A	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Job Code Id	JobCodeId	DTYPE_ID	N/A	No
Job Code Integration Id	JobCodeIntegrationId	DTYPE_TEXT	30	No
Job Code Name	JobCodeName	DTYPE_TEXT	30	No
Job Title	JobTitle	DTYPE_TEXT	75	No
Last Name	LastName	DTYPE_TEXT	50	No
Last Promotion Date	LastPromotionDate	DTYPE_DATETIME	N/A	No
License Plate Number	LicensePlateNumber	DTYPE_TEXT	50	No
Login Domain	LoginDomain	DTYPE_TEXT	50	No
Login Name	LoginName	DTYPE_TEXT	50	No
M/F	MF	DTYPE_TEXT	1	No
Maiden Name	MaidenName	DTYPE_TEXT	50	No
Middle Name	MiddleName	DTYPE_TEXT	50	No
Next Annual Review Date	NextAnnualReviewDate	DTYPE_DATETIME	N/A	No
Next Availability Status	NextAvailabilityStatus	DTYPE_TEXT	30	No
Nick Name	NickName	DTYPE_TEXT	50	No
Overtime Code	OvertimeCode	DTYPE_TEXT	30	No
Pager PIN	PagerPIN	DTYPE_TEXT	10	No
Pager Phone #	PagerPhone	DTYPE_TEXT	N/A	No
Pager Type	PagerType	DTYPE_TEXT	30	No
Personal Title	PersonalTitle	DTYPE_TEXT	15	No
Phone #	Phone	DTYPE_TEXT	N/A	No
Preferred Communications	PreferredCommunications	DTYPE_TEXT	30	No
Private	Private	DTYPE_TEXT	N/A	No
Readiness	Readiness	DTYPE_TEXT	30	No
Seniority Date	SeniorityDate	DTYPE_TEXT	N/A	No
Share Address Flag	ShareAddressFlag	DTYPE_TEXT	N/A	No
Share Home Phone Flag	ShareHomePhoneFlag	DTYPE_TEXT	N/A	No
Shift Id	ShiftId	DTYPE_ID	N/A	No
Shift Integration Id	ShiftIntegrationId	DTYPE_TEXT	30	No
Shift Name	ShiftName	DTYPE_TEXT	100	No
Standard Notification	StandardNotification	DTYPE_TEXT	30	No
Start Shift From	StartShiftFrom	DTYPE_TEXT	30	No
Subcontractor Flag	SubcontractorFlag	DTYPE_TEXT	N/A	No
Termination Date	TerminationDate	DTYPE_DATETIME	N/A	No
Time Zone Id	TimeZoneId	DTYPE_ID	N/A	No
Time Zone Name	TimeZoneName	DTYPE_TEXT	100	No
operation	operation	DTYPE_TEXT	30	No

Employee_Employee Organization Fields in Siebel Employee ASI

The following table lists the Employee_Employee Organization fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Employee Organization	EmployeeOrganization	DTYPE_TEXT	50	No
Employee Organization Id	EmployeeOrganizationId	DTYPE_ID	30	No
Employee Organization Integration Id	EmployeeOrganizationIntegraitionId	DTYPE_TEXT	30	No
IsPrimaryMVG	IsPrimaryMvg	DTYPE_TEXT	1	No

Employee_Personal Address Fields in Siebel Employee ASI

The following table lists the Employee_Personal Address fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
IsPrimaryMVG	IsPrimaryMvg	DTYPE_TEXT	1	No
Personal Address Id	PersonalAddressId	DTYPE_ID	30	No
Personal Address Integration Id	PersonalAddressIntegrationId	DTYPE_TEXT	30	No
Personal City	PersonalCity	DTYPE_TEXT	50	No
Personal Country	PersonalCountry	DTYPE_TEXT	50	No
Personal County	PersonalCounty	DTYPE_TEXT	50	No
Personal Postal Code	PersonalPostalCode	DTYPE_TEXT	30	No
Personal Province	PersonalProvince	DTYPE_TEXT	50	No
Personal State	PersonalState	DTYPE_TEXT	10	No
Personal Street Address	PersonalStreetAddress	DTYPE_TEXT	200	No
Personal Street Address 2	PersonalStreetAddress2	DTYPE_TEXT	100	No
operation	operation	DTYPE_TEXT	30	No

Employee_Position Fields in Siebel Employee ASI

The following table lists the Employee_Position fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Division	Division	DTYPE_TEXT	255	No
Division Id	DivisionId	DTYPE_ID	N/A	No
Division Integration Id	DivisionIntegrationId	DTYPE_TEXT	30	No
Employee End Date	EmployeeEndDate	DTYPE_DATETIME	N/A	No
Employee Start Date	EmployeeStartDate	DTYPE_DATETIME	N/A	No
IsPrimaryMVG	IsPrimaryMvg	DTYPE_TEXT	1	No
Position	Position	DTYPE_TEXT	50	No
Position Id	PositionId	DTYPE_ID	30	No
Position Integration Id	PositionIntegrationId	DTYPE_TEXT	30	No

Employee_Responsibility Fields in Siebel Employee ASI

The following table lists the Employee_Responsibility fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Responsibility	Responsibility	DTYPE_TEXT	50	No
Responsibility Id	ResponsibilityId	DTYPE_ID	30	No
Responsibility Integration Id	ResponsibilityIntegrationId	DTYPE_TEXT	30	No

Employee_Subcontractor Fields in Siebel Employee ASI

The following table lists the Employee_Subcontractor fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Subcontractor Account Id	SubcontractorAccountId	DTYPE_ID	30	No
Subcontractor Integration Id	SubcontractorIntegrationId	DTYPE_TEXT	30	No
Subcontractor Name	Subcontractor Name	DTYPE_TEXT	100	No

Personal Address Fields in Siebel Employee ASI

The following table lists the Personal Address fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Personal Address Id	PersonalAddressId	DTYPE_ID	30	No
Personal Address Integration Id	PersonalAddressIntegrationId	DTYPE_TEXT	30	No
Personal City	PersonalCity	DTYPE_TEXT	50	No
Personal Country	PersonalCountry	DTYPE_TEXT	50	No
Personal County	PersonalCounty	DTYPE_TEXT	50	No
Personal Postal Code	PersonalPostalCode	DTYPE_TEXT	30	No
Personal Province	PersonalProvince	DTYPE_TEXT	50	No
Personal State	PersonalState	DTYPE_TEXT	10	No
Personal Street Address	PersonalStreetAddress	DTYPE_TEXT	200	No
Personal Street Address 2	PersonalStreetAddress2	DTYPE_TEXT	100	No
operation	operation	DTYPE_TEXT	30	No

Related Employee Organization Fields in Siebel Employee ASI

The following table lists the Related Employee Organization fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Employee Organization	EmployeeOrganization	DTYPE_TEXT	50	No
Employee Organization Id	EmployeeOrganizationId	DTYPE_ID	30	No
Employee Organization Integration Id	EmployeeOrganizationIntegrationId	DTYPE_TEXT	30	No
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No

Related Position Fields in Siebel Employee ASI

The following table lists the Related Position fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Division	Division	DTYPE_TEXT	255	No
Division Id	DivisionId	DTYPE_ID	N/A	No
Division Integration Id	DivisionIntegrationId	DTYPE_TEXT	30	No
Employee End Date	EmployeeEndDate	DTYPE_DATETIME	N/A	No
Employee Start Date	EmployeeStartDate	DTYPE_DATETIME	N/A	No
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Position	Position	DTYPE_TEXT	50	No
Position Id	PositionId	DTYPE_ID	30	No
Position Integration Id	PositionIntegrationId	DTYPE_TEXT	30	No

Related Position Business Address Fields in Siebel Employee ASI

The following table lists the Related Position Business Address fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
Address Id	AddressId	DTYPE_ID	30	No
Address Integration Id	AddressIntegrationId	DTYPE_TEXT	30	No
Address Name	AddressName	DTYPE_TEXT	100	No
City	City	DTYPE_TEXT	50	No
Country	Country	DTYPE_TEXT	30	No
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Postal Code	PostalCode	DTYPE_TEXT	30	No
State	State	DTYPE_TEXT	10	No
Street Address	StreetAddress	DTYPE_TEXT	200	No

Related Responsibility Fields in Siebel Employee ASI

The following table lists the Related Responsibility fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Responsibility	Responsibility	DTYPE_TEXT	50	No
Responsibility Id	ResponsibilityId	DTYPE_ID	30	No
Responsibility Integration Id	ResponsibilityIntegrationId	DTYPE_TEXT	30	No

Related Subcontractor Fields in Siebel Employee ASI

The following table lists the Related Subcontractor fields and their attributes in Siebel Employee ASI.

Name	XML Tag	Data Type	Length	Req.
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	No
Subcontractor Account Id	SubcontractorAccountId	DTYPE_ID	30	No
Subcontractor Integration Id	SubcontractorIntegrationId	DTYPE_TEXT	30	No
Subcontractor Name	SubcontractorName	DTYPE_TEXT	100	No