Bookshelf v8.1/8.2: 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. Figure 18 shows the Siebel Employee ASI structure.

Table 27. Siebel Employee ASI Fields
Name	XML Tag	Data Type	Length	Req.
CMS Certifications Qualifications
Certification	Certification	DTYPE_TEXT	30	No
Comments	Comments	DTYPE_TEXT	250	No
Date of Certification	DateofCertification	DTYPE_TEXT	Not applicable	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
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	Not applicable	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	Not applicable	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
Competency Id	CompetencyId	DTYPE_ID	Not applicable	No
Skill Name	SkillName	DTYPE_TEXT	50	No
Current Skill Level	CurrentSkillLevel	DTYPE_TEXT	100	No
Current Skill Level Id	CurrentSkillLevelId	DTYPE_ID	Not applicable	No
Current Skill Level Value	CurrentSkillLevelValue	DTYPE_NUMBER	Not applicable	No
Date of Accomplishment	DateOfAccomplishment	DTYPE_DATETIME	Not applicable	No
Employee Id	EmployeeId	DTYPE_ID	Not applicable	No
Id	Id	DTYPE_ID	30	No
Required Skill Level Value	RequiredSkillLevelValue	DTYPE_NUMBER	Not applicable	No
Required Skill Level Id	RequiredSkillLevel Id	DTYPE_ID	Not applicable	No
Parent Skill	ParentSkill	DTYPE_TEXT	50	No
Rating Scale Id	RatingScaleId	DTYPE_ID	Not applicable	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	Not applicable	No
Skill Description	SkillDescription	DTYPE_TEXT	250	No
Root Category Id	RootCategoryId	DTYPE_ID	Not applicable	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	Not applicable	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	Not applicable	No
Assessment Type	AssessmentType	DTYPE_TEXT	30	No
Approved By Id	ApprovedById	DTYPE_ID	Not applicable	No
Mod Id	ModId	DTYPE_ID	30	No
CMS Honors Awards
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	Not applicable	No
Relevance to Company	RelevancetoCompany	DTYPE_TEXT	30	No
operation	operation	DTYPE_TEXT	30	No
CMS Memberships
Active Status	ActiveStatus	DTYPE_TEXT	Not applicable	No
Comments	Comments	DTYPE_TEXT	250	No
End Date	EndDate	DTYPE_TEXT	Not applicable	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	Not applicable	No
operation	operation	DTYPE_TEXT	30	No
CMS Past Work Experience
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	Not applicable	No
First Name	FirstName	DTYPE_TEXT	50	No
Id	Id	DTYPE_ID	30	No
Industry	Industry	DTYPE_ID	Not applicable	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	Not applicable	No
operation	operation	DTYPE_TEXT	30	No
Employee
Alias	Alias	DTYPE_TEXT	50	No
Availability Status	AvailabilityStatus	DTYPE_TEXT	30	No
Availability Status Until	AvailabilityStatusUntil	DTYPE_TEXT	Not applicable	No
Bonus Target %	BonusTarget	DTYPE_NUMBER	Not applicable	No
Building Number	BuildingNumber	DTYPE_TEXT	30	No
CP Region	CPRegion	DTYPE_TEXT	50	No
CP Region Id	CPRegionId	DTYPE_ID	Not applicable	No
CP Region Integration Id	CPRegionIntegrationId	DTYPE_TEXT	30	No
Cell Phone #	CellPhone	DTYPE_TEXT	Not applicable	No
Cost Currency Code	CostCurrencyCode	DTYPE_TEXT	30	No
Cost Per Hour	CostPerHour	DTYPE_TEXT	Not applicable	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	Not applicable	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	Not applicable	No
First Name	FirstName	DTYPE_TEXT	50	No
Hire Date	HireDate	DTYPE_DATETIME	Not applicable	No
Home Phone #	HomePhone	DTYPE_TEXT	Not applicable	No
Id	Id	DTYPE_ID	30	No
Integration Id	IntegrationId	DTYPE_TEXT	30	No
Job Code Id	JobCodeId	DTYPE_ID	Not applicable	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	Not applicable	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	Not applicable	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	Not applicable	No
Pager Type	PagerType	DTYPE_TEXT	30	No
Personal Title	PersonalTitle	DTYPE_TEXT	15	No
Phone #	Phone	DTYPE_TEXT	Not applicable	No
Preferred Communications	PreferredCommunications	DTYPE_TEXT	30	No
Private	Private	DTYPE_TEXT	Not applicable	No
Readiness	Readiness	DTYPE_TEXT	30	No
Seniority Date	SeniorityDate	DTYPE_TEXT	Not applicable	No
Share Address Flag	ShareAddressFlag	DTYPE_TEXT	Not applicable	No
Share Home Phone Flag	ShareHomePhoneFlag	DTYPE_TEXT	Not applicable	No
Shift Id	ShiftId	DTYPE_ID	Not applicable	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	Not applicable	No
Termination Date	TerminationDate	DTYPE_DATETIME	Not applicable	No
Time Zone Id	TimeZoneId	DTYPE_ID	Not applicable	No
Time Zone Name	TimeZoneName	DTYPE_TEXT	100	No
operation	operation	DTYPE_TEXT	30	No
Employee_Employee Organization
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
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
Division	Division	DTYPE_TEXT	255	No
Division Id	DivisionId	DTYPE_ID	Not applicable	No
Division Integration Id	DivisionIntegrationId	DTYPE_TEXT	30	No
Employee End Date	EmployeeEndDate	DTYPE_DATETIME	NA	No
Employee Start Date	EmployeeStartDate	DTYPE_DATETIME	Not applicable	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
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
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
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
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
Division	Division	DTYPE_TEXT	255	No
Division Id	DivisionId	DTYPE_ID	Not applicable	No
Division Integration Id	DivisionIntegrationId	DTYPE_TEXT	30	No
Employee End Date	EmployeeEndDate	DTYPE_DATETIME	Not applicable	No
Employee Start Date	EmployeeStartDate	DTYPE_DATETIME	Not applicable	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
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
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
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

Siebel Application Services Interface Reference		Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices.