XOG: Resource

ccppmop1561
Use the resource XOG object to view inbound (write) and outbound (read) resource attributes. This XOG object does not allow you to create a resource for a specific partition; it only supports the _ROOT partition code. You can, however, use the content pack XOG to add a resource as a member of a partition.
Schema Name
nikuxog_resource.xsd
Read and Write XML Files
The following XML files are included:
  • rsm_resources_read.xml. Use this file to export resource attributes from 
    Clarity PPM
    .
  • rsm_resources_write.xml. Use this file to import resource attributes that were previously exported from 
    Clarity PPM
    .
Business Rules and Processing
Before you import resources, set up the following items:
  • Manager
    Defines the manager for the resource by the username for the manager. In the user interface, the manager browse field is a lookup against the CMN_SEC_USERS table. If the manager does not exist, the XML schema posts the resource without the manager username and a warning is posted to the Success and Error file. If the username exists, the XML schema fills the field. When this XML schema is run for the first time, many records may be posted without values for the manager. After the schema is run, user profiles are updated to include a value for the manager (provided the user was added during the first pass).
  • Company ID
    Defines the unique identifier for the company that is associated with the resource, which is a browse field against the SRM_COMPANIES table. If the company does not exist, the schema posts the resource, leaves this field blank, and posts a warning to the Success and Error file. If the company exists, the schema fills the field. When this schema is run the first time, many records are posted without values for the company. After when the schema is run, user profiles are updated to include the company information (provided the user was added during the first pass).
  • Financial Properties
    The financial properties associated with the resource.
    Before resources can be imported into
    Clarity PPM
    , the following financial properties are set up in the Financial Administration module. If the financial properties are not found in
    Clarity PPM
    , the resource financial properties are not imported and an error is written to the Success and Error file. These properties are optional:
    • Financial Location
    • Financial Department
    • Resource Class
  • Vendor
    This item is an exception and is not required for the financial properties. The resource is added without a vendor and a warning is posted to the Success and Error file. 
  • Transaction Class
    The transaction class that is associated with the resource. The value in the XOG is found in the TRANSCLASS table.
  • Management Properties
    Defines the management properties that are associated with the resource. The XOG assumes that a resource is associated with the standard calendar that is available for a typical work day's standard number of hours (based on the standard calendar settings). The value is based on the default Allocation percentage.
  • OBS association
    The OBS that is associated with the resource. A Security OBS is required for labor resources; all resources can have OBS associations. To accommodate, there is an OBS Associations portlet that you can use to import and export.
  • Custom Attributes
    The custom fields that are associated with the resource. The XOG allows for an unlimited number of custom-defined fields. However, you must map the generated field to the schema. Within the schema for custom-defined fields, provide the Column Name, Attribute Name, and Value (because these can be modified by 
    Clarity PPM
     users).
  • Lookup values
    Any lookup values that are associated with the resource. Lookup codes must be provided when appropriate and are validated against CMN_LOOKUPS. Lookups are extracted for a set of lookup codes.
  • Primary RoleId
    The primary role of this resource, which is a browse field against SRM_RESOURCES. If the primary RoleId passed does not exist, this field is left blank and a warning message is posted to the Success and Error file (the field is filled when the role exists).
  • teamDefinitionId
    Optional. A resource that represents a team is exported with a teamDefinitionId attribute that contains the code of the associated team definition. This applies to exporting resources, exporting allocations on projects, or exporting task labor resources for assignments. During export, if the resource is a team definition, the attribute is added to the <Resource> element into the resulting XML document.
    For a successful import, the following conditions must be true:
    • If a <Resource> element has the teamDefinitionId attribute, then that team definition exists in the target system.
    • The associated resource ID for the team definition in the target system matches the resource ID on the <Resource> element in the import file.
      If necessary, use the REST API to create the team definition on the target system prior to importing.
    • Resources that are also team definitions cannot change the first name, last name, display name, resourceID, isActive flag, or availability of the resources in the target system. Any updates to these fields are ignored.
    Table and Column
    : TEAM_DEFINITIONS.CODE
    Type
    : String
Read Filters
The XOG allows for outbound processing of users who are based on the following fields:
  • Resource Type
  • Active
  • And and Or processing is supported between the two fields and for processing within Type. The following combinations are supported:
    isActive = x
    where x = Active, Inactive
    ResourceType = x
    where x = LABOR, MATERIAL, EQUIPMENT or EXPENSE
    isActive = x AND ResourceType = y
    where x = Active, Inactive where y = one of many Resource Types
    The following arguments are accepted:
    • Contact: include_contact
    • Management: include_management
    • Financials: include_financial
    • Custom Information: include_custom
    The following statements concern these two arguments:
    When all arguments are "Off", only resource basic information is exported.
    When all arguments are "On", all resource information is exported.
Error Handling
The following fields are written to the Success and Error file when the XOG process generates an error or warning:
  • externalId
  • externalSource
  • resourceId
  • lastName
If an error occurs, the table is not updated. Fix the error and run the XOG again. When a warning occurs because of inconsistencies in the data, the record is posted and the non-required fields are defaulted. Validate the errors in the following table against the resource:
Error or Warning Type
Description
resourceId
The unique identifier for the resource. The resource is validated against the resourceId field. If the resource ID:
  • Is not unique, then the resource is not imported and an error is posted to the Success and Error file.
  • Unique, then the resource is imported.
managerUserName
The unique identifier for the manager who is associated with the resource. The manager is validated against the companyId field. If the manager:
  • Is not found, then the resource is imported without any association to a manager.
  • Exists, then the resource is also imported.
companyId
The unique identifier for the company that is associated with the resource. The company ID is validated against the companyId field. If the company:
  • Is not found, then the resource is imported without any association to a company.
  • Exists, then the resource is also imported.
vendorCode
The unique code for the vendor that is associated with the resource. The vendor code is validated against the vendorCode field. If the vendor:
  • Is not found, then the resource is imported without any association to a vendor.
  • Exists, then the resource is also imported.
PAC_MNT_RESOURCES
The financial properties that are related to the resource. If the financial properties:
  • Do not exist, then the resource is imported without any association to financial properties.
  • Exist, then they are also imported.
2
Example: Resource Team Definition
The following example shows an exported resource team definition. The teamDefinitionId attribute is on the <Resource> element and contains the code of the team definition instance.
<NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_resource.xsd"> <Header action="write" externalSource="NIKU" objectType="resource" version="15.5.0.1"/> <Resources> <Resource externalId=" " includeInDatamart="true" isActive="true" isExternal="false" resourceId="TM00001" resourceType="LABOR" teamDefinitionId="TM00001"> <PersonalInformation displayName="TeamResourceXOGSTest" lastName="TeamResourceXOGSTest"/> <ManagementInformation availability="100" openForTimeEntry="false" trackMode="None" userFlag1="false" userFlag2="false" userNumber1="0" userNumber2="0"/> <General addedBy="admin" addedDate="2018-07-03"/> <OBSAssocs complete="false"/> <SkillAssocs/> <Calendar baseCalendar="Standard" resetCalendar="false"/> </Resource> </Resources> </NikuDataBus>
When importing a resource that is a team definition the following fields are not updated even if they differ from the existing team definition in the target system:
  • ID
  • Full Name
  • Availability
  • Active flag
Changes are ignored, no update is made, and no warning or error message appears.
The following example shows an exported project with assignment and staff records that are team definitions. The <Resource> and <TaskLabor> elements have the teamDefinitionId attribute.
<?xml version="1.0" encoding="UTF-8"?> <NikuDataBus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="../xsd/nikuxog_project.xsd">   <Header action="write" externalSource="NIKU" objectType="project" version="15.5.0.1"/>   <Projects>     <Project active="true" allowAssignedTasksOnly="0" approved="false" approvedForBilling="1" assgnPool="0" billingCurrencyCode="USD" billingType="S"       budgetCostFinish="2018-07-09T17:00:00" budgetCostStart="2018-07-09T00:00:00" calculateFinancialMetrics="true" closed="false"       costType="OPERATING" currencyISOcode="USD" equipmentExchageRateType="AVERAGE" evCalcMethod="0" expenseExchageRateType="AVERAGE"       financialStatus="H" finish="2018-07-09T17:00:00" format="0" investmentDefinedReinvestmentRate="0" investmentDefinedTotalCostOfCapital="0"       laborExchageRateType="AVERAGE" lastUpdatedBy="sasire" lastUpdatedDate="2018-07-09T10:11:38" managerResourceID="sasire"       materialExchageRateType="AVERAGE" name="My FooBar 2" openForTimeEntry="true" pageLayoutCode="projmgr.projectPageFrame" percentCalcMode="0"       percentComplete="0" plannedCostFinish="2018-07-09T17:00:00" plannedCostStart="2018-07-09T00:00:00" priority="10" progress="0" projectID="foobar"       requiredForScenarios="false" setBudgetValuesEqualToPlannedValues="true" start="2018-07-09T08:00:00" status="0"       syncInvestmentAndBudgetDates="true" template="false" trackMode="2" useSystemDefinedReinvestmentRate="true" useSystemDefinedTotalCostOfCapital="true">       <Resources>         <Resource availFrom="2018-07-09T08:00:00" availTo="2018-07-09T17:00:00" bookingStatus="5" capitalPercentage="0" defaultAllocation="1"           isProjectManager="false" lastUpdatedBy="sasire" lastUpdatedDate="2018-07-09T10:11:13" openForTimeEntry="true" resourceID="TM00005" teamDefinitionId="TM00005">           <CustomInformation>             <ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>           </CustomInformation>           <SkillAssocs/>         </Resource>       </Resources>       <Tasks>         <Task evCalcMethod="0" finish="2018-07-09T17:00:00" fixed="false" internalTaskID="5020060" key="false" lastUpdatedBy="sasire"           lastUpdatedDate="2018-07-09T10:11:13" lockedForScheduling="false" milestone="false" name="My FooBar" openForTimeEntry="true" orderID="1"           outlineLevel="1" percComp="0" start="2018-07-09T08:00:00" status="0" summary="false" taskID="~rmw" topDownPercent="0">           <Assignments>             <TaskLabor actualWork="0" estMax="1" estPattern="3" finish="2018-07-09T17:00:00" lastUpdatedBy="sasire"               lastUpdatedDate="2018-07-09T10:11:13" remainingWork="16" resourceID="TM00005" start="2018-07-09T08:00:00" teamDefinitionId="TM00005" unpostedActuals="0">               <CustomInformation>                 <ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>               </CustomInformation>             </TaskLabor>           </Assignments>           <estimateRules/>           <CustomInformation>             <ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>           </CustomInformation>         </Task>         <Task evCalcMethod="0" finish="2018-07-09T17:00:00" fixed="false" internalTaskID="5020061" key="true" lastUpdatedBy="sasire"           lastUpdatedDate="2018-07-09T10:11:30" lockedForScheduling="false" milestone="false" name="Test Task 1" nextSiblingOf="~rmw"         openForTimeEntry="true" orderID="2" outlineLevel="1" percComp="0" start="2018-07-09T08:00:00" status="0" summary="false" taskID="tt1">           <Assignments>             <TaskLabor actualWork="0" estMax="1" estPattern="3" finish="2018-07-09T17:00:00" lastUpdatedBy="sasire"               lastUpdatedDate="2018-07-09T10:11:38" remainingWork="16" resourceID="TM00005" start="2018-07-09T08:00:00" teamDefinitionId="TM00005" unpostedActuals="0">               <CustomInformation>                 <ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>               </CustomInformation>             </TaskLabor>           </Assignments>           <estimateRules/>           <CustomInformation>             <ColumnValue name="partition_code">NIKU.ROOT</ColumnValue>           </CustomInformation>         </Task>       </Tasks>       <Allocations/>       <scenarioDependencies/>       <InvestmentAssociations>         <Allocations/>         <Hierarchies/>       </InvestmentAssociations>       <General addedBy="sasire" addedDate="2018-07-09"/>       <OBSAssocs complete="false"/>     </Project>   </Projects> </NikuDataBus>
You can import and export resource capacity planning scenarios and can even include a <TaskLabor> element that references team definitions. Tag these scenarios with the teamDefinitionId attribute during export. Imported items are subject to team definition validation.
Personal Information Schema Tag
The personal information tag is part schema mapping for the resource XOG object and has the following attributes:
resource xog attribute--External Source
ExternalSource
Required. Required by the schema lookup value and is the originating system ID (for example, Oracle).
Table and Column:
SRM_RESOURCES.External_Source_ID
Type:
String in the XML Schema and Number in 
Clarity PPM
.
resource xog attribute--ExternalId
ExternalId
Required. Required by the XML schema and is the originating unique identifier.
Table and Column:
SRM_RESOURCES.External_ID
Type:
String
resource xog attribute--isActive
isActive
Optional. Defines the status of the resource.
Values:
  • 1. True
  • 0. False
Default:
1
Table and Column:
SRM_RESOURCES.Is_Active
Type:
Boolean
resource xog attribute--resourceType
resourceType
Optional. Defines the resource type.
Values:
LABOR, MATERIAL, EQUIPMENT, and EXPENSE
Default:
LABOR
Table and Column:
SRM_RESOURCES.Resource_type
Type:
String
resource xog attribute--forecastRate
forecastRate
Optional. Defines the resource allocation hourly forecast rate. You can export this field only if it contains a value.
Table and Column:
SRM_RESOURCES.Forecast_Rate
Type:
Double
resource xog attribute--employmentType
employmentType
Optional. Defines the employment type.
Values:
employee and contractor
Default:
employee
Table and Column:
SRM_RESOURCES.Person_Type
Type:
String
resource xog attribute--hireDate
hireDate
Optional.
Table and Column:
SRM_RESOURCES.Date_of_Hire
Type:
Date
resource xog attribute--terminationDate
terminationDate
Optional.
Table and Column:
SRM_RESOURCES.Date_of_Termination
Type:
Date
resource xog attribute--managerUserName
managerUserName
Optional. Identifies the manager of the resource.
Table and Column:
SRM_RESOURCES.Manager_ID
(User Name)
Type:
String
resource xog attribute--isExternal
isExternal
Optional. Defines the status of the resource.
Values
:
  • 1. True
  • 0. False
Default:
0
Table and Column:
SRM_RESOURCES.Is_External
Type:
Boolean
resource xog attribute--firstName
firstName
Optional.
Table and Column:
SRM_RESOURCES.First_Name
Type:
String
resource xog attribute--lastName
lastName
Optional. Validates this field for LABOR resources
Table and Column:
SRM_RESOURCES.Last_Name
Type:
String
resource xog attribute--middleName
middleName
Optional.
Table and Column:
SRM_RESOURCES.Middle_Name
Type:
String
resource xog attribute--displayName
displayName
Optional. The name to display on the interface.
Table and Column:
SRM_RESOURCES.Full_Name
Type:
String
resource xog attribute--emailAddress
emailAddress
Optional. The email address of the resource.
Table and Column:
SRM_RESOURCES.Email
Type:
String
Contact Information Schema Tag (Resources XOG)
This tag is part schema mapping for the resources XOG object and has the following attributes:
  • companyName
    Optional. The association of a resource to a company.
    Table and Column:
    SRM_CONTACTS.Company _ID
    Type:
    String
  • jobTitle
    Optional.
    Table and Column:
    SRM_CONTACTS.Job_Title
    Type:
    String
  • address1
    Optional.
    Table and Column:
    SRM_CONTACTS.Address1
    Type:
    String
  • address2
    Optional.
    Table and Column:
    SRM_CONTACTS.Address2
    Type:
    String
  • address3
    Optional.
    Table and Column:
    SRM_CONTACTS.Address3
    Type:
    String
  • city
    Optional.
    Table and Column:
    SRM_CONTACTS.City
    Type:
    String
  • state
    Optional.
    Table and Column:
    SRM_CONTACTS.State_Province
    Type:
    String
  • postalCode
    Optional.
    Table and Column:
    SRM_CONTACTS.Postal _Code
    Type:
    String
  • countryId
    Optional. Lookup values for all countries.
    Table and Column:
    SRM_CONTACTS.Country_ID
    Type:
    Number
  • homePhone
    Optional. No format is enforced.
    Table and Column:
    SRM_CONTACTS.Phone_Home
    Type:
    String
  • workPhone
    Optional. No format is enforced.
    Table and Column:
    SRM_CONTACTS.Phone_Work
    Type:
    String
  • mobilePhone
    Optional. No format is enforced.
    Table and Column:
    SRM_CONTACTS.Phone_Cell
    Type:
    String
  • fax
    Optional. No format is enforced.
    Table and Column:
    SRM_CONTACTS.Phone_Fax
    Type:
    String
  • pager
    Optional. No format is enforced.
    Table and Column:
    SRM_CONTACTS.Phone_Pager
    Type:
    String
  • webAddress
    Optional.
    Table and Column:
    SRM_CONTACTS.URL
    Type:
    String
Management Information Schema Tag
This tag is part schema mapping for the resources XOG object and has the following attributes:
  • category
    Optional. Defines the management category for this resource.
    Table and Column:
    PRJ_RESOURCES.PRCATEGORY
    Type:
    String
  • defautlAllocationPercentage
    Optional. Defines the default allocation percentage for this resource.
    Default:
    100
    Table and Column:
    PRJ_RESOURCES.DEFAULTALLOCATION
    Type:
    Number
  • trackMode
    Optional. Specifies the method in which this resource tracks time.
    Values:
    Clarity, None, and Other.
    Default:
    Clarity Time
    Table and Column:
    PRJ_RESOURCES.PRTRACKMODE
    Type:
    Number
  • openForTimeEntry
    Optional. Defines whether this resource is open for time entry.
    Values:
    • 1. True
    • 0. False
    Default:
    1
    Table and Column:
    PRJ_RESOURCES.PRISOPEN
    Type:
    Boolean
  • primaryRoleId
    Optional. Indicates the role to which the resource belongs.
    Table and Column:
    PRJ_RESOURCES.PRPRIMARYROLEID
    Type:
    Number
  • inputTypeCode
    Optional. Defines the default input type code for the resource.
    Table and Column:
    PRJ_RESOURCES.PRTYPECODEID
    Type:
    Number
  • userText1
    Optional. A user-defined field.
    Table and Column:
    PRJ_RESOURCES.PRUSERTEXT1
    type:
    String
  • userText3
    Optional. A user-defined field.
    Table and Column:
    PRJ_RESOURCES.PRUSERTEXT2
    type:
    String
  • userText3
    Optional. A user-defined field.
    Table and Column:
    PRJ_RESOURCES.PRUSERTEXT3
    type:
    String
  • userText4
    Optional. A user-defined field.
    Table and Column:
    PRJ_RESOURCES.PRUSERTEXT4
    type:
    String
  • userFlag1
    Optional. A user-defined field.
    Table and Column:
    PRJ_RESOURCES.PRUSERFLAG1
    Type:
    Boolean
  • userFlag2
    Optional. A user-defined field.
    Table and Column:
    PRJ_RESOURCES.PRUSERFLAG2
    Type:
    Boolean
  • userNumber1
    Optional. A user-defined field.
    Table and Column:
    PRJ_RESOURCES.PRUSERNUMBER1
    Type:
    Number
  • userNumber1
    Optional. A user-defined field.
    Table and Column:
    PRJ_RESOURCES.PRUSERNUMBER1
    Type:
    Number
Financial Information Schema Tag
This schema tag is part schema mapping for the resource XOG object and has the following attributes:
  • FinancialCode
    Required. A unique primary key that is equal to the Resource ID. This field is not exposed in the schema.
    Table and Column:
    PAC_MNT_RESOURCES.RESOURCE_CODE
    Type:
    String
  • location
    Optional. The location association to the resource.
    Table and Column:
    PAC_MNT_RESOURCES.LOCATIONID
    Type:
    String
  • department
    Optional. The department association to the resource.
    Table and Column:
    PAC_MNT_RESOURCES.DEPARTCODE
    Type:
    String
  • resourceClass
    Required. The resource class that is association with the resource.
    Table and Column:
    PAC_MNT_RESOURCES.RESOURCE_CLASS
    Type:
    String
  • transactionClass
    Required. The transaction class that is associated with the resource.
    Table and Column:
    PAC_MNT_RESOURCES.TRANSCLASS
    Type:
    String
  • vendorCode
    Optional. The vendor association with the resource.
    Table and Column:
    PAC_MNT_RESOURCES.VENDOR_CODE
    Type:
    String
  • Active
    Optional. Defines the status of the resource.
    Values
    :
    • 1. True
    • 0. False
    Default:
    1
    Table and Column:
    PAC_MNT_RESOURCES.ACTIVE
    Type:
    Boolean
Expenses Schema Tag
This tag is part schema mapping for the Resources XOG object and has the following attributes:
  • reimbursementCurrency
    Optional. The lookup value equal to the ISO standard code. This is the currency that is used to calculate reimbursements that are made to the resource. This code is not subject to multi-currency rules.
    This field is specific to the resource and can vary from the system settings.
    Table and Column:
    PAC_MNT_RESOURCES.EX_CURRENCY_CODE
    Type:
    String
  • employeeCountryCode
    Optional. The reimbursement country code.
    Table and Column:
    PAC_MNT_RESOURCES.EX_COUNTRY_CODE
    Type:
    String
Rates and Costs Schema Tag
This schema tag is part schema mapping for the resource XOG object and has the following attributes:
  • targetbillingRate
    Optional. Defines the target billing rate for this resource.
    Table and Column:
    PAC_MNT_RESOURCES.TARGETBILLRATE
    Type:
    Float
  • targetPercentageBillable
    Optional. Defines the billable percentage for this resource.
    Table and Column:
    PAC_MNT_RESOURCES.TARGETPERCENTBILLABLE
    Type:
    Float
Custom Information Schema Tag (Resources XOG)
This tag is part schema mapping for the resource XOG object, describes custom-defined fields, and has the following attributes:
  • Mentor
    Optional. Identifies the mentor that is associated with this resource.
    Table and Column:
    XDM_CDF_SRM_RESOURCES.XDM_RESOURCE_MENTOR
    Type:
    String
  • WillingTravel
    Optional. Defines the willingness to travel for the resource.
    Values:
    • 1. True
    • 0. False
    Default:
    0
    Table and Column:
    XDM_CDF_SRM_RESOURCES.XDM_WILLING_TRAVEL
    Type:
    Boolean
  • ResourceIndustry
    Optional. Defines the industry that is related to this resource.
    Table and Column:
    XDM_CDF_SRM_RESOURCES.XDM_RESOURCE_INDUSTRY
    Type:
    String
  • ResourceGrade
    Optional. Defines the grade that is related to this resource.
    Values:
    Bronze, Silver, Gold, and Platinum.
    Table and Column:
    XDM_CDF_SRM_RESOURCES.XDM_RESOURCE_GRADE
    Type:
    String
OBS Associations Schema Tag (Resources XOG)
The OBS Associations tag is part of the schema mapping for the
resource
XOG object. The OBS Associations tag is a shared xsd type and a wrapper for the OBSAssoc elements.
Example:
<xs:complexType name="OBSAssocsType"> <xs:annotation> <xs:documentation xml:lang="en"> <... list of OBS Associations ...> <OBSAssocs complete="false"> </xs:documentation>
The OBSAssocs tag contains the following element, plus zero or more OBSAssoc subelements.
  • complete
    Defines whether the OBS associations are complete. This field is optional. When complete is
    true
    , existing OBS associations that are not listed in the import are deleted. When the value is
    false
    , the operation inserts and/or updates any existing OBS associations.
    Complete
    replaces deprecated forms 
    completed
    and
    IsComplete
    .
The OBSAssoc element is associated with the following tables:
  • PRJ_OBS_ASSOCIATIONS (OBS Associations)
  • PRJ_OBS_TYPES (OBS)
  • PRJ_OBS_UNITS (OBS Units)
  • PRJ_OBS_UNITS_FLAT (OBS Units Flat Hierarchy)
This element has the following attributes:
  • id
    Required. Defines the OBS association ID.
    Table and Column:
    PRJ_OBS_TYPES.UNIQUE_NAME
    Type:
    String
  • name
    Optional. Defines the OBS association name.
    Table and Column:
    PRJ_OBS_TYPES.PRJ_OBS_TYPES.NAME
    Type:
    String
  • unitPath
    Required. Slash-delimited list of unit names leading up to the associated OBS unit for the object.
    Table and Column:
    PRJ_OBS_TYPES.PRJOBS_UNITS.NAME
    Type:
    String
    Example:
    CAN/BC/VAN
SkillAssocs Schema Tag (Resource XOG)
This tag is part of the schema mapping for the resources XOG object and is not mapped to any tables or columns. This tag is also a shared xsd type and is a wrapper for the SkillAssocs elements.
Example:
<xs:complexType name="SkillAssocsType"> <xs:annotation> <xs:documentation xml:lang="en"> <... list of Skill Associations ...> <SkillAssocs complete="false"> </xs:documentation>
This schema tag has the following attributes:
  • complete
    Optional. When set to
    true
    , the list of skill associations completely replaces any existing skills that are associated with the resource.
    Complete
    replaces deprecated forms 
    completed
    and
    IsComplete
    .
    Default:
    False
    Table and Column:
    None
    Type:
    Boolean
  • SkillAssoc Element
    The skills that are associated with each resource. The skillAssoc element has the following attributes:
    • skillCode
      Required. Defines the code for this skill.
      Table and Column:
      rsm_skills_associations.skill_id
      Type:
      String
    • interestLevel
      Optional. Defines the interest level in this skill for the resource.
      Table and Column:
      CMN_LOOKUPS
      The lookup code from the cmn_lookups table is based on interest_level_id from the rsm_skills_associations table.
      Type:
      String
    • proficiencyLevel
      Optional. Defines the proficiency level in this skill for the resource.
      Table and Column:
      CMN_LOOKUPS
      Note:
      The Lookup code from the cmn_lookups table is based on proficiency_level_id from the rsm_skills_associations table.
      Type:
      String
    • weight
      Optional. Used when searching to produce a weighted average.
      Table and Column:
      rsm_skills_associations.weight
      Type:
      Number