Full Extract of Licenses and Certifications
This is a full file extract, required by the third-party provider that consistently accepts the entire file. Use the listed User Entities (UEs) and their corresponding Database Items (DBIs) to retrieve licenses and certifications.
User Entity | Root Block | Level | Function | How to Identify Database Item Identifier under User Entity? | Connect Data Groups |
---|---|---|---|---|---|
HRT_EXT_MODEL_CERTIFICATION_UE | Y | 1 | Extract licenses and certifications from position or job profile, which are flagged as Verification is done by third party. | Extract Model Certifications % | NA |
HRT_EXT_POS_PERSON_CERTIFICATION_DETAILS_UE | N | 2 | Extract licenses and certifications of a person, which are flagged as Verification is done by third party in the position profile. The position profile is derived using the position ID on the person's assignment. | Extract Person Position Certifications Details % |
Parent Data Group Database Item: Extract Model Certifications Object ID Database Item: Extract Person Position Certifications Details Position ID Parent Data Group Database Item: Extract Model Certifications Content Item ID Database Item: Extract Person Position Certifications Details Content Item ID |
HRT_EXT_JOB_PERSON_CERTIFICATION_DETAILS_UE | N | 2 | Extract licenses and certifications of a person, which are flagged as Verification is done by third party in the job profile, provided the person assignment doesn't have a position ID, or the position ID doesn't have an associated position profile. | Extract Person Job Certifications Details |
Parent Data Group Database Item: Extract Model Certifications Object ID Database Item: Extract Person Job Certifications Details Job ID Parent Data Group Database Item: Extract Model Certifications Content Item ID Database Item: Extract Person Job Certifications Details Content Item ID |
The HRT_EXT_POS_PERSON_CERTIFICATION_DETAILS_UE user entity will provide output for person licenses and certifications that match the position profile requirements, and HRT_EXT_JOB_PERSON_CERTIFICATION_DETAILS_UE will provide output for person licenses and certifications that match job profile requirements in case the person is not associated with the position. If both job and position profiles are found for a person, then the person licenses and certifications that match the position profile take precedence.
For adding database items to the records of a block, use the database item identifier provided in the above table to search for the available attributes in the user entity.
The next example demonstrates how to add a filter to this extract.
While creating the extract with the previous user entities, if the user is already aware of the positions and jobs that would have licenses or certifications flagged for third-party verification, then an additional filter criteria can be provided on the root block with user entity as HRT_EXT_MODEL_CERTIFICATION_UE using position ID and job ID or a combination of both against the objectId attribute in root block.
In the basic mode of filter criteria, provide the filter for the DBI Extract Model Certifications Object ID.
In advanced mode, the filter criteria are provided for pr.object_id. This helps the extract to query only those positions and jobs restricted by the filter query. The next image is an example displaying the filter criteria provided to run the extract for licenses part of 6 positions and 2 jobs.
Extract Output Mapped to the UI Attributes
Fusion Attribute Name | Extract Output XML Tag Name |
---|---|
Person ID | Employee_ID |
First name | Person_First_Name |
Middle Name | Person_Middle_Name |
Last Name | Person_Last_Name |
Status | License_Status |
State | State_Code |
Country | Country_Code |
License Number | License_or_Certification_Number |
License Name | License_or_Certification_Name |
Issue Date | Issue_Date |
Issue By | Issued_By |
Expiration Date | Expiration_Date |
Employee email address | Person_EMail_Address |
Content Item Code | Item_ID |
SSN | National_Identifier_Number |
Date of Birth | Person_Date_of_Birth |
Profile Item Id | Certification_ID |
Profile Id | Profile_ID |
Address Line 1 | Person_Address_Line1 |
Address Line 2 | Person_Address_Line2 |
Address Line 3 | Person_Address_Line3 |
Address Line 4 | Person_Address_Line4 |
Address Region 1 | Person_Address_Region1 |
Address Region 2 | Person_Address_Region2 |
Address Region 3 | Person_Address_Region3 |
Home Town or City | Person_Home_Town_or_City |
Postal code | Person_Postal_Code |
Person Country Code | Person_Country |
Person Country Name | Person_Country_Name |