select 'METADATA|WorkTerms|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentStatusTypeId|BusinessUnitId|PeriodOfServiceId|PersonId|PrimaryWorkTermsFlag|ActionCode|ReasonCode|WorkTermsAssignmentId|JobCode|DepartmentName|DefaultExpenseAccount' from dual UNION ALL
SELECT r_code.*,"Role Code" || ' - '||"Role Name"|| ' - '||"Job Role Name" || ' - '||"Organization Security Profile"|| ' - '||"Position Security Profile"|| ' - '||"Country Security Profile"|| ' - '||"LDG Security Profile"|| ' - '||"Person Security Profile"|| ' - '||"Public Person Security Profile"||' - '||"Document Type Security Profile"||
Date File Name: ContentItem.dat METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name MERGE|ContentItem||||1951/01/01|CERTIFICATION|U|103|ABC Safety Officer SQL Query to get the content id Select ITEM.CONTENT_ITEM_ID, ITEM.CONTENT_TYPE_ID, ITEM.CONTENT_ITEM_CODE,ITEM.DATE_FROM, ITEM.BUSINESS_GROUP_ID, TL.NAME, TL.ITEM_DESCRIPTION, TYPE.CONTEXT_NAME, ITEM.CREATED_BY, ITEM.CREATION_DATE, ITEM.LAST_UPDATED_BY, ITEM.LAST_UPDATE_DATE from hrt_content_items_b ITEM, hrt_content_items_tl TL, hrt_content_types_b TYPE where ITEM.CONTENT_ITEM_ID=TL.CONTENT_ITEM_ID AND ITEM.CONTENT_TYPE_ID=TYPE.CONTENT_TYPE_ID AND UPPER(TYPE.CONTEXT_NAME) =UPPER('CERTIFICATION')
Dat File Name: ContentItem.dat METADATA|ContentItem|ContentItemValueSetName|ContentItemCode|ItemDescription|DateFrom|ContextName|ContentSupplierCode|ContentTypeId|Name
select 'METADATA|Assignment|AssignmentId|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|AssignmentType|AssignmentStatusTypeId|BusinessUnitId|PeriodOfServiceId|PersonId|PrimaryFlag|ActionCode|ReasonCode|WorkTermsAssignmentId|JobCode|DepartmentName|DefaultExpenseAccount|InternalFloo