Bookshelf v7.7: 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 20 shows the Siebel Employee ASI structure.

Table 32. Siebel Employee ASI Fields
Name	XML Tag	Data Type	Length	Req.	Notes
CMS Certifications Qualifications
Certification	Certification	DTYPE_TEXT	30	N
Comments	Comments	DTYPE_TEXT	250	N
Date of Certification	DateofCertification	DTYPE_TEXT		N
Id	Id	DTYPE_ID	30	N
Institution	Institution	DTYPE_TEXT	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
operation	operation	DTYPE_TEXT	30	N
CMS Education
Comments	Comments	DTYPE_TEXT	250	N
Country	Country	DTYPE_TEXT	30	N
Degree	Degree	DTYPE_TEXT	30	N
Education	Education	DTYPE_TEXT	30	N
Grade	Grade	DTYPE_TEXT	30	N
Graduation Date	GraduationDate	DTYPE_TEXT		N
Id	Id	DTYPE_ID	30	N
Institution	Institution	DTYPE_TEXT	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
Major	Major	DTYPE_TEXT	30	N
Number of Years	NumberofYears	DTYPE_NUMBER		N
Scale	Scale	DTYPE_TEXT	30	N
Type of Education	TypeofEducation	DTYPE_TEXT	30	N
operation	operation	DTYPE_TEXT	30	N
CMS Employee Competency Administration
Competency Id	CompetencyId	DTYPE_ID		N
Skill Name	SkillName	DTYPE_TEXT	50	N
Current Skill Level	CurrentSkillLevel	DTYPE_TEXT	100	N
Current Skill Level Id	CurrentSkillLevelId	DTYPE_ID		N
Current Skill Level Value	CurrentSkillLevelValue	DTYPE_NUMBER		N
Date of Accomplishment	DateOfAccomplishment	DTYPE_DATETIME		N
Employee Id	EmployeeId	DTYPE_ID		N
Id	Id	DTYPE_ID	30	N
Required Skill Level Value	RequiredSkillLevelValue	DTYPE_NUMBER		N
Required Skill Level Id	RequiredSkillLevel Id	DTYPE_ID		N
Parent Skill	ParentSkill	DTYPE_TEXT	50	N
Rating Scale Id	RatingScaleId	DTYPE_ID		N
Required Skill Level	Required Skill Level	DTYPE_TEXT	100	N
operation	operation	DTYPE_TEXT	30	N
Updated	Updated	DTYPE_DATETIME	30	N
Status	Status	DTYPE_TEXT	30	N
Skill Gap	SkillGap	DTYPE_NUMBER		N
Skill Description	SkillDescription	DTYPE_TEXT	250	N
Root Category Id	RootCategoryId	DTYPE_ID		N
Root Category	RootCategory	DTYPE_TEXT	50	N
searchspec	searchspec	DTYPE_TEXT	250	N
Manager Comments	ManagerComents	DTYPE_TEXT	2000	N
Employee Comments	EmployeeComments	DTYPE_TEXT	2000	N
Delete Record Flag	DeleteRecordFlag	DTYPE_TEXT		N
Criticality	Criticality	DTYPE_TEXT	30	N
Created	Created	DTYPE_DATETIME	30	N
Conflict Id	ConflictId	DTYPE_ID	30	N
Category Id	CategoryId	DTYPE_ID		N
Assessment Type	AssessmentType	DTYPE_TEXT	30	N
Approved By Id	ApprovedById	DTYPE_ID		N
Mod Id	ModId	DTYPE_ID	30	N
CMS Honors Awards
Comments	Comments	DTYPE_TEXT	250	N
Honor Award	HonorAward	DTYPE_TEXT	30	N
Id	Id	DTYPE_ID	30	N
Institution	Institution	DTYPE_TEXT	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
Received Date	ReceivedDate	DTYPE_TEXT		N
Relevance to Company	RelevancetoCompany	DTYPE_TEXT	30	N
operation	operation	DTYPE_TEXT	30	N
CMS Memberships
Active Status	ActiveStatus	DTYPE_TEXT		N
Comments	Comments	DTYPE_TEXT	250	N
End Date	EndDate	DTYPE_TEXT		N
Id	Id	DTYPE_ID	30	N
Institution	Institution	DTYPE_TEXT	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
Membership	Membership	DTYPE_TEXT	30	N
Relevance to Company	RelevancetoCompany	DTYPE_TEXT	30	N
Start Date	StartDate	DTYPE_TEXT		N
operation	operation	DTYPE_TEXT	30	N
CMS Past Work Experience
Business Title	BusinessTitle	DTYPE_TEXT	50	N
Business Unit	BusinessUnit	DTYPE_TEXT	30	N
Comments	Comments	DTYPE_TEXT	250	N
Company Name	CompanyName	DTYPE_TEXT	30	N
End Date	EndDate	DTYPE_TEXT		N
First Name	FirstName	DTYPE_TEXT	50	N
Id	Id	DTYPE_ID	30	N
Industry	Industry	DTYPE_ID		N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
Last Name	LastName	DTYPE_TEXT	50	N
Position	Position	DTYPE_TEXT	50	N
Start Date	StartDate	DTYPE_TEXT		N
operation	operation	DTYPE_TEXT	30	N
Employee
Alias	Alias	DTYPE_TEXT	50	N
Availability Status	AvailabilityStatus	DTYPE_TEXT	30	N
Availability Status Until	AvailabilityStatusUntil	DTYPE_TEXT		N
Bonus Target %	BonusTarget	DTYPE_NUMBER		N
Building Number	BuildingNumber	DTYPE_TEXT	30	N
CP Region	CPRegion	DTYPE_TEXT	50	N
CP Region Id	CPRegionId	DTYPE_ID		N
CP Region Integration Id	CPRegionIntegrationId	DTYPE_TEXT	30	N
Cell Phone #	CellPhone	DTYPE_TEXT		N
Cost Currency Code	CostCurrencyCode	DTYPE_TEXT	30	N
Cost Per Hour	CostPerHour	DTYPE_TEXT		N
Cubicle Number	CubicleNumber	DTYPE_TEXT	20	N
EMail Addr	EMailAddr	DTYPE_TEXT	50	N
Emergency Notification	EmergencyNotification	DTYPE_TEXT	30	N
Emp #	Emp	DTYPE_TEXT	30	N
Employee Flag	EmployeeFlag	DTYPE_TEXT		N
Employee Type Code	EmployeeTypeCode	DTYPE_TEXT	30	N
Employment Status	EmploymentStatus	DTYPE_TEXT	30	N
End Shift to	EndShiftto	DTYPE_TEXT	30	N
Fax #	Fax	DTYPE_TEXT		N
First Name	FirstName	DTYPE_TEXT	50	N
Hire Date	HireDate	DTYPE_DATETIME		N
Home Phone #	HomePhone	DTYPE_TEXT		N
Id	Id	DTYPE_ID	30	N
Integration Id	IntegrationId	DTYPE_TEXT	30	N
Job Code Id	JobCodeId	DTYPE_ID		N
Job Code Integration Id	JobCodeIntegrationId	DTYPE_TEXT	30	N
Job Code Name	JobCodeName	DTYPE_TEXT	30	N
Job Title	JobTitle	DTYPE_TEXT	75	N
Last Name	LastName	DTYPE_TEXT	50	N
Last Promotion Date	LastPromotionDate	DTYPE_DATETIME		N
License Plate Number	LicensePlateNumber	DTYPE_TEXT	50	N
Login Domain	LoginDomain	DTYPE_TEXT	50	N
Login Name	LoginName	DTYPE_TEXT	50	N
M/F	MF	DTYPE_TEXT	1	N
Maiden Name	MaidenName	DTYPE_TEXT	50	N
Middle Name	MiddleName	DTYPE_TEXT	50	N
Next Annual Review Date	NextAnnualReviewDate	DTYPE_DATETIME		N
Next Availability Status	NextAvailabilityStatus	DTYPE_TEXT	30	N
Nick Name	NickName	DTYPE_TEXT	50	N
Overtime Code	OvertimeCode	DTYPE_TEXT	30	N
Pager PIN	PagerPIN	DTYPE_TEXT	10	N
Pager Phone #	PagerPhone	DTYPE_TEXT		N
Pager Type	PagerType	DTYPE_TEXT	30	N
Personal Title	PersonalTitle	DTYPE_TEXT	15	N
Phone #	Phone	DTYPE_TEXT		N
Preferred Communications	PreferredCommunications	DTYPE_TEXT	30	N
Private	Private	DTYPE_TEXT		N
Readiness	Readiness	DTYPE_TEXT	30	N
Seniority Date	SeniorityDate	DTYPE_TEXT		N
Share Address Flag	ShareAddressFlag	DTYPE_TEXT		N
Share Home Phone Flag	ShareHomePhoneFlag	DTYPE_TEXT		N
Shift Id	ShiftId	DTYPE_ID		N
Shift Integration Id	ShiftIntegrationId	DTYPE_TEXT	30	N
Shift Name	ShiftName	DTYPE_TEXT	100	N
Standard Notification	StandardNotification	DTYPE_TEXT	30	N
Start Shift From	StartShiftFrom	DTYPE_TEXT	30	N
Subcontractor Flag	SubcontractorFlag	DTYPE_TEXT		N
Termination Date	TerminationDate	DTYPE_DATETIME		N
Time Zone Id	TimeZoneId	DTYPE_ID		N
Time Zone Name	TimeZoneName	DTYPE_TEXT	100	N
operation	operation	DTYPE_TEXT	30	N
Employee_Employee Organization
Employee Organization	EmployeeOrganization	DTYPE_TEXT	50	N
Employee Organization Id	EmployeeOrganizationId	DTYPE_ID	30	N
Employee Organization Integration Id	EmployeeOrganizationIntegraitionId	DTYPE_TEXT	30	N
IsPrimaryMVG	IsPrimaryMvg	DTYPE_TEXT	1	N
Employee_Personal Address
IsPrimaryMVG	IsPrimaryMvg	DTYPE_TEXT	1	N
Personal Address Id	PersonalAddressId	DTYPE_ID	30	N
Personal Address Integration Id	PersonalAddressIntegrationId	DTYPE_TEXT	30	N
Personal City	PersonalCity	DTYPE_TEXT	50	N
Personal Country	PersonalCountry	DTYPE_TEXT	50	N
Personal County	PersonalCounty	DTYPE_TEXT	50	N
Personal Postal Code	PersonalPostalCode	DTYPE_TEXT	30	N
Personal Province	PersonalProvince	DTYPE_TEXT	50	N
Personal State	PersonalState	DTYPE_TEXT	10	N
Personal Street Address	PersonalStreetAddress	DTYPE_TEXT	200	N
Personal Street Address 2	PersonalStreetAddress2	DTYPE_TEXT	100	N
operation	operation	DTYPE_TEXT	30	N
Employee_Position
Division	Division	DTYPE_TEXT	255	N
Division Id	DivisionId	DTYPE_ID		N
Division Integration Id	DivisionIntegrationId	DTYPE_TEXT	30	N
Employee End Date	EmployeeEndDate	DTYPE_DATETIME		N
Employee Start Date	EmployeeStartDate	DTYPE_DATETIME		N
IsPrimaryMVG	IsPrimaryMvg	DTYPE_TEXT	1	N
Position	Position	DTYPE_TEXT	50	N
Position Id	PositionId	DTYPE_ID	30	N
Position Integration Id	PositionIntegrationId	DTYPE_TEXT	30	N
Employee_Responsibility
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
Responsibility	Responsibility	DTYPE_TEXT	50	N
Responsibility Id	ResponsibilityId	DTYPE_ID	30	N
Responsibility Integration Id	ResponsibilityIntegrationId	DTYPE_TEXT	30	N
Employee_Subcontractor
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
Subcontractor Account Id	SubcontractorAccountId	DTYPE_ID	30	N
Subcontractor Integration Id	SubcontractorIntegrationId	DTYPE_TEXT	30	N
Subcontractor Name	Subcontractor Name	DTYPE_TEXT	100	N
Personal Address
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
Personal Address Id	PersonalAddressId	DTYPE_ID	30	N
Personal Address Integration Id	PersonalAddressIntegrationId	DTYPE_TEXT	30	N
Personal City	PersonalCity	DTYPE_TEXT	50	N
Personal Country	PersonalCountry	DTYPE_TEXT	50	N
Personal County	PersonalCounty	DTYPE_TEXT	50	N
Personal Postal Code	PersonalPostalCode	DTYPE_TEXT	30	N
Personal Province	PersonalProvince	DTYPE_TEXT	50	N
Personal State	PersonalState	DTYPE_TEXT	10	N
Personal Street Address	PersonalStreetAddress	DTYPE_TEXT	200	N
Personal Street Address 2	PersonalStreetAddress2	DTYPE_TEXT	100	N
operation	operation	DTYPE_TEXT	30	N
Related Employee Organization
Employee Organization	EmployeeOrganization	DTYPE_TEXT	50	N
Employee Organization Id	EmployeeOrganizationId	DTYPE_ID	30	N
Employee Organization Integration Id	EmployeeOrganizationIntegrationId	DTYPE_TEXT	30	N
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
Related Position
Division	Division	DTYPE_TEXT	255	N
Division Id	DivisionId	DTYPE_ID		N
Division Integration Id	DivisionIntegrationId	DTYPE_TEXT	30	N
Employee End Date	EmployeeEndDate	DTYPE_DATETIME		N
Employee Start Date	EmployeeStartDate	DTYPE_DATETIME		N
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
Position	Position	DTYPE_TEXT	50	N
Position Id	PositionId	DTYPE_ID	30	N
Position Integration Id	PositionIntegrationId	DTYPE_TEXT	30	N
Related Position Business Address
Address Id	AddressId	DTYPE_ID	30	N	Added for UAN 3.0
Address Integration Id	AddressIntegrationId	DTYPE_TEXT	30	N	Added for UAN 3.0
Address Name	AddressName	DTYPE_TEXT	100	N	Added for UAN 3.0
City	City	DTYPE_TEXT	50	N	Added for UAN 3.0
Country	Country	DTYPE_TEXT	30	N	Added for UAN 3.0
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N	Added for UAN 3.0
Postal Code	PostalCode	DTYPE_TEXT	30	N	Added for UAN 3.0
State	State	DTYPE_TEXT	10	N	Added for UAN 3.0
Street Address	StreetAddress	DTYPE_TEXT	200	N	Added for UAN 3.0
Related Responsibility
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
Responsibility	Responsibility	DTYPE_TEXT	50	N
Responsibility Id	ResponsibilityId	DTYPE_ID	30	N
Responsibility Integration Id	ResponsibilityIntegrationId	DTYPE_TEXT	30	N
Related Subcontractor
IsPrimaryMVG	IsPrimaryMVG	DTYPE_TEXT	1	N
Subcontractor Account Id	SubcontractorAccountId	DTYPE_ID	30	N
Subcontractor Integration Id	SubcontractorIntegrationId	DTYPE_TEXT	30	N
Subcontractor Name	SubcontractorName	DTYPE_TEXT	100	N