Application Services Interface Reference > Predefined Application Service Interfaces >

Siebel Employee/External Employee


The Siebel Employee/External Employee ASI is an ASI for employee-related business processes. The Employee Integration Object allows for inbound and outbound data integration between Siebel and third-party applications that process employee data. This can include employee core data, job-related data, responsibilities, position, or résumé 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 describes this ASI.

Figure 18.  Siebel Employee/External Employee ASI

Click for full size image

The Siebel Employee/External Employee integration components are listed in Table 26.

Table 26.  Siebel Employee/External Employee Integration Components
Integration Component
XML Tag
User Keys
CMS Certifications Qualifications
CmsCertificationsQualifications
  1. Id
  2. Integration Id
  3. Certification
CMS Education
CmsEducation
  1. Id
  2. Integration Id
  3. Education
CMS Honors Awards
CmsHonorsAwards
  1. Id
  2. Integration Id
  3. Honor Award
CMS Memberships
CmsMemberships
  1. Id
  2. Integration Id
  3. Membership
CMS Past Work Experience
CmsPastWorkExperience
  1. Id
  2. Integration Id
  3. Company Name
Employee
Employee
  1. Id
  2. Integration Id
  3. Login Domain, Login Name
  4. Login Name
  5. First Name, Last Name, Middle Name
Personal Address
PersonalAddress
  1. Personal Address Id
  2. Personal Address Integration Id
Related Employee Organization
RelatedEmployeeOrganization
  1. Employee Organization Id
  2. Employee Organization Integration Id
  3. Employee Organization
Related Position
RelatedPosition
  1. Position Id
  2. Position Integration Id
  3. Division, Position
Related Position Business Address
RelatedPositionBusinessAddress
  1. Address Id
Related Responsibility
RelatedResponsibility
  1. Responsibility Id
  2. Responsibility Integration Id
  3. Responsibility
Related Subcontractor
RelatedSubcontractor
  1. Subcontractor Account Id
  2. Subcontractor Integration Id
  3. Subcontractor Name

Table 27 lists the fields and their attributes.

Table 27.  Siebel Employee/External 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 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
 
Compensation Currency
CompensationCurrency
DTYPE_TEXT
20
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
 
Salary
Salary
DTYPE_TEXT
 
N
 
Salary Grade Id
SalaryGradeId
DTYPE_ID
 
N
 
Salary Grade Integration Id
SalaryGradeIntegrationId
DTYPE_TEXT
30
N
 
Salary Grade Name
SalaryGradeName
DTYPE_TEXT
50
N
 
Salary Plan Id
SalaryPlanId
DTYPE_ID
 
N
 
Salary Plan Integration Id
SalaryPlanIntegrationId
DTYPE_TEXT
30
N
 
Salary Plan Name
SalaryPlanName
DTYPE_TEXT
50
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
 
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
 


 Application Services Interface Reference 
 Published: 15 May 2003