HCM Extract
<?xml version = '1.0' encoding = 'UTF-8'?>
<Extract_Definition>
<DefinitionName>ABC_Create_Severance_Pay</DefinitionName>
<XmlTagName>ABC_Create_Severance_Pay</XmlTagName>
<ExtTypeCode>ORA_INBINT</ExtTypeCode>
<DateStart>2000-01-01</DateStart>
<Status>A</Status>
<IncludeChangesFromLastSuccessfulRun>N</IncludeChangesFromLastSuccessfulRun>
<Extract_Block>
<BaseUserEntityName>PER_EXT_WORK_RELATIONSHIP_ALL_UE</BaseUserEntityName>
<BlockName>Work Relationship DG</BlockName>
<XmlTagName>WrkDG</XmlTagName>
<MainBlockFlag>Y</MainBlockFlag>
<MultiThreadActType>O</MultiThreadActType>
<UserName>PER_EXT_WORK_REL_ALL_PERSON_ID</UserName>
<Block_Criteria>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Criteria>pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE') between pps.attribute_date1 and pps.attribute_date2
and pps.person_id in (100000638716547,300000016736229,300000040067415)</Criteria>
<CriteriaFlag>C</CriteriaFlag>
<DispCriteriaExp>{EDITADV}{PER_EXT_WORK_REL_ALL_PERSON_ID}</DispCriteriaExp>
</Block_Criteria>
<Extract_Record>
<RecordName>Work Relationship Record</RecordName>
<XmlTagName>WrkRec</XmlTagName>
<TypeCode>D</TypeCode>
<ProcessCode>FF</ProcessCode>
<FlexStructureCode>Work_Relationship_Record</FlexStructureCode>
<Sequence>10</Sequence>
<LastRunExecutedMode>N</LastRunExecutedMode>
<OverflowMode>N</OverflowMode>
<NextBlockId>Assignment DG</NextBlockId>
<BaseRecordName>Work_Relationship_Record</BaseRecordName>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Person ID</DataElementName>
<ShortCode>PERID</ShortCode>
<TypeCode>F</TypeCode>
<DataType>N</DataType>
<XmlTagName>PerID</XmlTagName>
<InformationColumn>1</InformationColumn>
<InformationLabel>Person ID</InformationLabel>
<GroupName>Relationship Person ID</GroupName>
<BaseGroupName>Relationship Person Id</BaseGroupName>
<KeyFlag>Y</KeyFlag>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Severance Start Date</DataElementName>
<ShortCode>SEVSTDT</ShortCode>
<TypeCode>F</TypeCode>
<DataType>D</DataType>
<XmlTagName>SevStDt</XmlTagName>
<InformationColumn>10</InformationColumn>
<InformationLabel>Severance Start Date</InformationLabel>
<GroupName>Relationship Attribute Date1</GroupName>
<BaseGroupName>Relationship Attribute Date1</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Severance End Date</DataElementName>
<ShortCode>SEVENDDT</ShortCode>
<TypeCode>F</TypeCode>
<DataType>D</DataType>
<XmlTagName>SevEndDt</XmlTagName>
<InformationColumn>12</InformationColumn>
<InformationLabel>Severance End Date</InformationLabel>
<GroupName>Relationship Attribute Date2</GroupName>
<BaseGroupName>Relationship Attribute Date2</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
</Extract_Record>
<Extract_Record>
<RecordName>Benefits Traversal</RecordName>
<XmlTagName>BenTR</XmlTagName>
<TypeCode>O</TypeCode>
<Sequence>15</Sequence>
<LastRunExecutedMode>N</LastRunExecutedMode>
<OverflowMode>N</OverflowMode>
<NextBlockId>Benefits DG</NextBlockId>
<BaseRecordName>Benefits_Traversal</BaseRecordName>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
</Extract_Record>
</Extract_Block>
<Extract_Block>
<BaseUserEntityName>PER_EXT_SEC_ASSIGNMENT_UE</BaseUserEntityName>
<BlockName>Assignment DG</BlockName>
<XmlTagName>AsgDG</XmlTagName>
<Block_Link>
<ParentBlockId>Work Relationship DG</ParentBlockId>
<UserName1>PER_EXT_WORK_REL_ALL_PERIOD_OF_SERVICE_ID</UserName1>
<UserName>PER_EXT_ASG_PERIOD_OF_SERVICE_ID</UserName>
</Block_Link>
<Block_Criteria>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Criteria>((asg.assignment_type='E')
AND (asg.primary_work_relation_flag='Y'))</Criteria>
<CriteriaFlag>C</CriteriaFlag>
<DispCriteriaExp>{EDITADV}</DispCriteriaExp>
</Block_Criteria>
<Extract_Record>
<RecordName>Assignment Record</RecordName>
<XmlTagName>AsgRec</XmlTagName>
<TypeCode>D</TypeCode>
<ProcessCode>FF</ProcessCode>
<FlexStructureCode>Assignment_Record</FlexStructureCode>
<Sequence>15</Sequence>
<LastRunExecutedMode>N</LastRunExecutedMode>
<OverflowMode>N</OverflowMode>
<BaseRecordName>Assignment_Record</BaseRecordName>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Assignment ID</DataElementName>
<ShortCode>ASGID</ShortCode>
<TypeCode>F</TypeCode>
<DataType>N</DataType>
<XmlTagName>AsgID</XmlTagName>
<InformationColumn>5</InformationColumn>
<InformationLabel>Assignment ID</InformationLabel>
<GroupName>Extract Assignment ID</GroupName>
<BaseGroupName>PER_EXT_ASG_ASSIGNMENT_ID</BaseGroupName>
<KeyFlag>Y</KeyFlag>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Assignment Number</DataElementName>
<ShortCode>ASGNUM</ShortCode>
<TypeCode>F</TypeCode>
<DataType>T</DataType>
<XmlTagName>AsgNum</XmlTagName>
<InformationColumn>10</InformationColumn>
<InformationLabel>Assignment Number</InformationLabel>
<GroupName>Extract Assignment Number</GroupName>
<BaseGroupName>PER_EXT_ASG_ASSIGNMENT_NUMBER</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
</Extract_Record>
</Extract_Block>
<Extract_Block>
<BaseUserEntityName>BEN_EXT_ENRT_RTCVG_UE</BaseUserEntityName>
<BlockName>Benefits DG</BlockName>
<XmlTagName>BenDG</XmlTagName>
<Block_Link>
<ParentBlockId>Work Relationship DG</ParentBlockId>
<UserName1>PER_EXT_WORK_REL_ALL_PERSON_ID</UserName1>
<UserName>BEN_EXT_RTCVG_PERSON_ID</UserName>
</Block_Link>
<Block_Criteria>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Criteria>(ptp.name IN ('Medical', 'Dental', 'Vision', 'Healthcare FSA', 'Tobacco Differential', 'Spousal Surcharge'))</Criteria>
<CriteriaFlag>C</CriteriaFlag>
<DispCriteriaExp>{BEN_EXT_RTCVG_PTP_NAME}{In}{(}{'Medical', 'Dental', 'Vision','Healthcare FSA','Tobacco Differential','Spousal Surcharge'}{)}</DispCriteriaExp>
</Block_Criteria>
<Extract_Record>
<RecordName>Benefits Record</RecordName>
<XmlTagName>BenRec</XmlTagName>
<TypeCode>D</TypeCode>
<ProcessCode>FF</ProcessCode>
<FlexStructureCode>Benefits_Record</FlexStructureCode>
<Sequence>20</Sequence>
<LastRunExecutedMode>N</LastRunExecutedMode>
<OverflowMode>N</OverflowMode>
<BaseRecordName>Benefits_Record</BaseRecordName>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Person ID</DataElementName>
<ShortCode>PERID</ShortCode>
<TypeCode>F</TypeCode>
<DataType>N</DataType>
<XmlTagName>PerID</XmlTagName>
<InformationColumn>1</InformationColumn>
<InformationLabel>Person ID</InformationLabel>
<GroupName>Person ID</GroupName>
<BaseGroupName>Person ID</BaseGroupName>
<KeyFlag>Y</KeyFlag>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Plan Name</DataElementName>
<ShortCode>PLANNAME</ShortCode>
<TypeCode>F</TypeCode>
<DataType>T</DataType>
<XmlTagName>PlanName</XmlTagName>
<InformationColumn>10</InformationColumn>
<InformationLabel>Plan Name</InformationLabel>
<GroupName>Plan - Name</GroupName>
<BaseGroupName>Plan - Name</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Plan Type</DataElementName>
<ShortCode>PLANTYPE</ShortCode>
<TypeCode>F</TypeCode>
<DataType>T</DataType>
<XmlTagName>PlanType</XmlTagName>
<InformationColumn>12</InformationColumn>
<InformationLabel>Plan Type</InformationLabel>
<GroupName>Plan Type - Name</GroupName>
<BaseGroupName>Plan Type - Name</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Opted For</DataElementName>
<ShortCode>OPTD</ShortCode>
<TypeCode>F</TypeCode>
<DataType>T</DataType>
<XmlTagName>Optd</XmlTagName>
<InformationColumn>14</InformationColumn>
<InformationLabel>Opted For</InformationLabel>
<GroupName>Option Name</GroupName>
<BaseGroupName>Option Name</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Coverage Begin Date</DataElementName>
<ShortCode>CVGBEGINDT</ShortCode>
<TypeCode>F</TypeCode>
<DataType>D</DataType>
<XmlTagName>CvgBeginDt</XmlTagName>
<InformationColumn>16</InformationColumn>
<InformationLabel>Coverage Begin Date</InformationLabel>
<GroupName>Enrollment - Coverage Start Date</GroupName>
<BaseGroupName>Enrollment - Coverage Start Date</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Coverage Through Date</DataElementName>
<ShortCode>CVGTHRUDT</ShortCode>
<TypeCode>F</TypeCode>
<DataType>D</DataType>
<XmlTagName>CvgThruDt</XmlTagName>
<InformationColumn>18</InformationColumn>
<InformationLabel>Coverage Through Date</InformationLabel>
<GroupName>Enrollment - Coverage Through Date</GroupName>
<BaseGroupName>Enrollment - Coverage Through Date</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Rate</DataElementName>
<ShortCode>RATE</ShortCode>
<TypeCode>F</TypeCode>
<DataType>N</DataType>
<XmlTagName>Rate</XmlTagName>
<InformationColumn>20</InformationColumn>
<InformationLabel>Rate</InformationLabel>
<GroupName>Rate Value</GroupName>
<BaseGroupName>Rate Value</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Tax Type</DataElementName>
<ShortCode>TAXTYPE</ShortCode>
<TypeCode>F</TypeCode>
<DataType>T</DataType>
<XmlTagName>TaxType</XmlTagName>
<InformationColumn>22</InformationColumn>
<InformationLabel>Tax Type Code</InformationLabel>
<GroupName>Tax Type Code</GroupName>
<BaseGroupName>Tax Type Code</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
</Extract_Record>
</Extract_Block>
<Delivery_Option>
<DateFrom>2000-01-01</DateFrom>
<DateTo>4712-12-31</DateTo>
<BipReportName>/Interface/Inbound/I_BN121/ABC_Severance_Pay_Load.xdo</BipReportName>
<BipTemplateName>ABC_Severance_Template</BipTemplateName>
<DeliveryOptionName>HDL_Output</DeliveryOptionName>
<DeliveryType>INBINT</DeliveryType>
<CalendarCode>GREGORIAN</CalendarCode>
<OutputName>ElementEntry.dat</OutputName>
<OutputType>TEXT</OutputType>
<MandatoryFlag>Y</MandatoryFlag>
<Delivery_Option_Detail>
<OptionType>ENCMODE</OptionType>
<OptionValue>NONE</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>FILEEXTN</OptionType>
<OptionValue>.dat</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>FILE_NAME_DE</OptionType>
<OptionValue>ElementEntry</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>INTGNAME</OptionType>
<OptionValue>ABC121</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>INTGTYPE</OptionType>
<OptionValue>ORA_HDL</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>INTG_PARAMETERS</OptionType>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>KEY</OptionType>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>LOCALE</OptionType>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>TIMEZONE</OptionType>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>ZIP</OptionType>
<OptionValue>NO</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>ZIPGROUP</OptionType>
<OptionValue>ABC_%y%m%d_%H%M%S.zip</OptionValue>
</Delivery_Option_Detail>
</Delivery_Option>
<Report_Category>
<CategoryName>ABC_Create_Severance_Pay</CategoryName>
<ShortName>EXT300003144435500</ShortName>
<DefaultCategory>Y</DefaultCategory>
<SourceRepCatId>300003144435512</SourceRepCatId>
<Report_Category_Component>
<DeliveryOptionName>HDL_Output</DeliveryOptionName>
</Report_Category_Component>
</Report_Category>
<Extract_Parameter>
<ParamName>Delete After Successful Load</ParamName>
<EssParamName>AUTO_DELETE</EssParamName>
<XmlTagName>auto_delete</XmlTagName>
<DataType>T</DataType>
<DescriptionInParam>Delete After Successful Load</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>20</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Delete Archive</ParamName>
<EssParamName>DELETE_ARCHIVE</EssParamName>
<XmlTagName>delete_archive</XmlTagName>
<DataType>T</DataType>
<DescriptionInParam>Delete Archive</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamDispType>LK</ParamDispType>
<ParamLookup>ORA_PER_EXT_DELETE_ARCHIVE</ParamLookup>
<ParamSequence>80</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Effective Date</ParamName>
<EssParamName>EFFECTIVE_DATE</EssParamName>
<XmlTagName>effective_date</XmlTagName>
<DataType>D</DataType>
<DescriptionInParam>Effective Date</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>Y</DisplayFlag>
<ParamSequence>40</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Legislative Data Group</ParamName>
<EssParamName>LEGISLATIVE_DATA_GROUP_ID</EssParamName>
<XmlTagName>legislative_data_group_id</XmlTagName>
<DataType>N</DataType>
<DescriptionInParam>Legislative Data Group</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>50</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Load Automatically</ParamName>
<EssParamName>AUTO_LOAD</EssParamName>
<XmlTagName>auto_load</XmlTagName>
<DataType>T</DataType>
<DescriptionInParam>Load Automatically</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>30</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Parameter Group</ParamName>
<EssParamName>PARAMETER_GROUP_ID</EssParamName>
<XmlTagName>parameter_group_id</XmlTagName>
<DataType>N</DataType>
<DescriptionInParam>Parameter Group</DescriptionInParam>
<AllowedInExpression>N</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>60</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Report Category</ParamName>
<EssParamName>REPORT_CATEGORY_ID</EssParamName>
<XmlTagName>report_category_id</XmlTagName>
<DataType>N</DataType>
<DescriptionInParam>Report Category</DescriptionInParam>
<AllowedInExpression>N</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>70</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Request ID</ParamName>
<EssParamName>REQUEST_ID</EssParamName>
<XmlTagName>request_id</XmlTagName>
<DataType>N</DataType>
<DescriptionInParam>Request ID</DescriptionInParam>
<AllowedInExpression>N</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>90</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Start Date</ParamName>
<EssParamName>START_DATE</EssParamName>
<XmlTagName>start_date</XmlTagName>
<DataType>D</DataType>
<DescriptionInParam>Start Date</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>10</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
</Extract_Definition>
<DefinitionName>ABC_Create_Severance_Pay</DefinitionName>
<XmlTagName>ABC_Create_Severance_Pay</XmlTagName>
<ExtTypeCode>ORA_INBINT</ExtTypeCode>
<DateStart>2000-01-01</DateStart>
<Status>A</Status>
<IncludeChangesFromLastSuccessfulRun>N</IncludeChangesFromLastSuccessfulRun>
<Extract_Block>
<BaseUserEntityName>PER_EXT_WORK_RELATIONSHIP_ALL_UE</BaseUserEntityName>
<BlockName>Work Relationship DG</BlockName>
<XmlTagName>WrkDG</XmlTagName>
<MainBlockFlag>Y</MainBlockFlag>
<MultiThreadActType>O</MultiThreadActType>
<UserName>PER_EXT_WORK_REL_ALL_PERSON_ID</UserName>
<Block_Criteria>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Criteria>pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE') between pps.attribute_date1 and pps.attribute_date2
and pps.person_id in (100000638716547,300000016736229,300000040067415)</Criteria>
<CriteriaFlag>C</CriteriaFlag>
<DispCriteriaExp>{EDITADV}{PER_EXT_WORK_REL_ALL_PERSON_ID}</DispCriteriaExp>
</Block_Criteria>
<Extract_Record>
<RecordName>Work Relationship Record</RecordName>
<XmlTagName>WrkRec</XmlTagName>
<TypeCode>D</TypeCode>
<ProcessCode>FF</ProcessCode>
<FlexStructureCode>Work_Relationship_Record</FlexStructureCode>
<Sequence>10</Sequence>
<LastRunExecutedMode>N</LastRunExecutedMode>
<OverflowMode>N</OverflowMode>
<NextBlockId>Assignment DG</NextBlockId>
<BaseRecordName>Work_Relationship_Record</BaseRecordName>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Person ID</DataElementName>
<ShortCode>PERID</ShortCode>
<TypeCode>F</TypeCode>
<DataType>N</DataType>
<XmlTagName>PerID</XmlTagName>
<InformationColumn>1</InformationColumn>
<InformationLabel>Person ID</InformationLabel>
<GroupName>Relationship Person ID</GroupName>
<BaseGroupName>Relationship Person Id</BaseGroupName>
<KeyFlag>Y</KeyFlag>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Severance Start Date</DataElementName>
<ShortCode>SEVSTDT</ShortCode>
<TypeCode>F</TypeCode>
<DataType>D</DataType>
<XmlTagName>SevStDt</XmlTagName>
<InformationColumn>10</InformationColumn>
<InformationLabel>Severance Start Date</InformationLabel>
<GroupName>Relationship Attribute Date1</GroupName>
<BaseGroupName>Relationship Attribute Date1</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Severance End Date</DataElementName>
<ShortCode>SEVENDDT</ShortCode>
<TypeCode>F</TypeCode>
<DataType>D</DataType>
<XmlTagName>SevEndDt</XmlTagName>
<InformationColumn>12</InformationColumn>
<InformationLabel>Severance End Date</InformationLabel>
<GroupName>Relationship Attribute Date2</GroupName>
<BaseGroupName>Relationship Attribute Date2</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
</Extract_Record>
<Extract_Record>
<RecordName>Benefits Traversal</RecordName>
<XmlTagName>BenTR</XmlTagName>
<TypeCode>O</TypeCode>
<Sequence>15</Sequence>
<LastRunExecutedMode>N</LastRunExecutedMode>
<OverflowMode>N</OverflowMode>
<NextBlockId>Benefits DG</NextBlockId>
<BaseRecordName>Benefits_Traversal</BaseRecordName>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
</Extract_Record>
</Extract_Block>
<Extract_Block>
<BaseUserEntityName>PER_EXT_SEC_ASSIGNMENT_UE</BaseUserEntityName>
<BlockName>Assignment DG</BlockName>
<XmlTagName>AsgDG</XmlTagName>
<Block_Link>
<ParentBlockId>Work Relationship DG</ParentBlockId>
<UserName1>PER_EXT_WORK_REL_ALL_PERIOD_OF_SERVICE_ID</UserName1>
<UserName>PER_EXT_ASG_PERIOD_OF_SERVICE_ID</UserName>
</Block_Link>
<Block_Criteria>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Criteria>((asg.assignment_type='E')
AND (asg.primary_work_relation_flag='Y'))</Criteria>
<CriteriaFlag>C</CriteriaFlag>
<DispCriteriaExp>{EDITADV}</DispCriteriaExp>
</Block_Criteria>
<Extract_Record>
<RecordName>Assignment Record</RecordName>
<XmlTagName>AsgRec</XmlTagName>
<TypeCode>D</TypeCode>
<ProcessCode>FF</ProcessCode>
<FlexStructureCode>Assignment_Record</FlexStructureCode>
<Sequence>15</Sequence>
<LastRunExecutedMode>N</LastRunExecutedMode>
<OverflowMode>N</OverflowMode>
<BaseRecordName>Assignment_Record</BaseRecordName>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Assignment ID</DataElementName>
<ShortCode>ASGID</ShortCode>
<TypeCode>F</TypeCode>
<DataType>N</DataType>
<XmlTagName>AsgID</XmlTagName>
<InformationColumn>5</InformationColumn>
<InformationLabel>Assignment ID</InformationLabel>
<GroupName>Extract Assignment ID</GroupName>
<BaseGroupName>PER_EXT_ASG_ASSIGNMENT_ID</BaseGroupName>
<KeyFlag>Y</KeyFlag>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Assignment Number</DataElementName>
<ShortCode>ASGNUM</ShortCode>
<TypeCode>F</TypeCode>
<DataType>T</DataType>
<XmlTagName>AsgNum</XmlTagName>
<InformationColumn>10</InformationColumn>
<InformationLabel>Assignment Number</InformationLabel>
<GroupName>Extract Assignment Number</GroupName>
<BaseGroupName>PER_EXT_ASG_ASSIGNMENT_NUMBER</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
</Extract_Record>
</Extract_Block>
<Extract_Block>
<BaseUserEntityName>BEN_EXT_ENRT_RTCVG_UE</BaseUserEntityName>
<BlockName>Benefits DG</BlockName>
<XmlTagName>BenDG</XmlTagName>
<Block_Link>
<ParentBlockId>Work Relationship DG</ParentBlockId>
<UserName1>PER_EXT_WORK_REL_ALL_PERSON_ID</UserName1>
<UserName>BEN_EXT_RTCVG_PERSON_ID</UserName>
</Block_Link>
<Block_Criteria>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Criteria>(ptp.name IN ('Medical', 'Dental', 'Vision', 'Healthcare FSA', 'Tobacco Differential', 'Spousal Surcharge'))</Criteria>
<CriteriaFlag>C</CriteriaFlag>
<DispCriteriaExp>{BEN_EXT_RTCVG_PTP_NAME}{In}{(}{'Medical', 'Dental', 'Vision','Healthcare FSA','Tobacco Differential','Spousal Surcharge'}{)}</DispCriteriaExp>
</Block_Criteria>
<Extract_Record>
<RecordName>Benefits Record</RecordName>
<XmlTagName>BenRec</XmlTagName>
<TypeCode>D</TypeCode>
<ProcessCode>FF</ProcessCode>
<FlexStructureCode>Benefits_Record</FlexStructureCode>
<Sequence>20</Sequence>
<LastRunExecutedMode>N</LastRunExecutedMode>
<OverflowMode>N</OverflowMode>
<BaseRecordName>Benefits_Record</BaseRecordName>
<EffectiveStartDate>2000-01-01</EffectiveStartDate>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Person ID</DataElementName>
<ShortCode>PERID</ShortCode>
<TypeCode>F</TypeCode>
<DataType>N</DataType>
<XmlTagName>PerID</XmlTagName>
<InformationColumn>1</InformationColumn>
<InformationLabel>Person ID</InformationLabel>
<GroupName>Person ID</GroupName>
<BaseGroupName>Person ID</BaseGroupName>
<KeyFlag>Y</KeyFlag>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Plan Name</DataElementName>
<ShortCode>PLANNAME</ShortCode>
<TypeCode>F</TypeCode>
<DataType>T</DataType>
<XmlTagName>PlanName</XmlTagName>
<InformationColumn>10</InformationColumn>
<InformationLabel>Plan Name</InformationLabel>
<GroupName>Plan - Name</GroupName>
<BaseGroupName>Plan - Name</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Plan Type</DataElementName>
<ShortCode>PLANTYPE</ShortCode>
<TypeCode>F</TypeCode>
<DataType>T</DataType>
<XmlTagName>PlanType</XmlTagName>
<InformationColumn>12</InformationColumn>
<InformationLabel>Plan Type</InformationLabel>
<GroupName>Plan Type - Name</GroupName>
<BaseGroupName>Plan Type - Name</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Opted For</DataElementName>
<ShortCode>OPTD</ShortCode>
<TypeCode>F</TypeCode>
<DataType>T</DataType>
<XmlTagName>Optd</XmlTagName>
<InformationColumn>14</InformationColumn>
<InformationLabel>Opted For</InformationLabel>
<GroupName>Option Name</GroupName>
<BaseGroupName>Option Name</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Coverage Begin Date</DataElementName>
<ShortCode>CVGBEGINDT</ShortCode>
<TypeCode>F</TypeCode>
<DataType>D</DataType>
<XmlTagName>CvgBeginDt</XmlTagName>
<InformationColumn>16</InformationColumn>
<InformationLabel>Coverage Begin Date</InformationLabel>
<GroupName>Enrollment - Coverage Start Date</GroupName>
<BaseGroupName>Enrollment - Coverage Start Date</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Coverage Through Date</DataElementName>
<ShortCode>CVGTHRUDT</ShortCode>
<TypeCode>F</TypeCode>
<DataType>D</DataType>
<XmlTagName>CvgThruDt</XmlTagName>
<InformationColumn>18</InformationColumn>
<InformationLabel>Coverage Through Date</InformationLabel>
<GroupName>Enrollment - Coverage Through Date</GroupName>
<BaseGroupName>Enrollment - Coverage Through Date</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Rate</DataElementName>
<ShortCode>RATE</ShortCode>
<TypeCode>F</TypeCode>
<DataType>N</DataType>
<XmlTagName>Rate</XmlTagName>
<InformationColumn>20</InformationColumn>
<InformationLabel>Rate</InformationLabel>
<GroupName>Rate Value</GroupName>
<BaseGroupName>Rate Value</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
<Extract_DataElement>
<StartDate>2000-01-01</StartDate>
<DataElementName>Tax Type</DataElementName>
<ShortCode>TAXTYPE</ShortCode>
<TypeCode>F</TypeCode>
<DataType>T</DataType>
<XmlTagName>TaxType</XmlTagName>
<InformationColumn>22</InformationColumn>
<InformationLabel>Tax Type Code</InformationLabel>
<GroupName>Tax Type Code</GroupName>
<BaseGroupName>Tax Type Code</BaseGroupName>
<AlwaysDisplay>Y</AlwaysDisplay>
</Extract_DataElement>
</Extract_Record>
</Extract_Block>
<Delivery_Option>
<DateFrom>2000-01-01</DateFrom>
<DateTo>4712-12-31</DateTo>
<BipReportName>/Interface/Inbound/I_BN121/ABC_Severance_Pay_Load.xdo</BipReportName>
<BipTemplateName>ABC_Severance_Template</BipTemplateName>
<DeliveryOptionName>HDL_Output</DeliveryOptionName>
<DeliveryType>INBINT</DeliveryType>
<CalendarCode>GREGORIAN</CalendarCode>
<OutputName>ElementEntry.dat</OutputName>
<OutputType>TEXT</OutputType>
<MandatoryFlag>Y</MandatoryFlag>
<Delivery_Option_Detail>
<OptionType>ENCMODE</OptionType>
<OptionValue>NONE</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>FILEEXTN</OptionType>
<OptionValue>.dat</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>FILE_NAME_DE</OptionType>
<OptionValue>ElementEntry</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>INTGNAME</OptionType>
<OptionValue>ABC121</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>INTGTYPE</OptionType>
<OptionValue>ORA_HDL</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>INTG_PARAMETERS</OptionType>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>KEY</OptionType>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>LOCALE</OptionType>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>TIMEZONE</OptionType>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>ZIP</OptionType>
<OptionValue>NO</OptionValue>
</Delivery_Option_Detail>
<Delivery_Option_Detail>
<OptionType>ZIPGROUP</OptionType>
<OptionValue>ABC_%y%m%d_%H%M%S.zip</OptionValue>
</Delivery_Option_Detail>
</Delivery_Option>
<Report_Category>
<CategoryName>ABC_Create_Severance_Pay</CategoryName>
<ShortName>EXT300003144435500</ShortName>
<DefaultCategory>Y</DefaultCategory>
<SourceRepCatId>300003144435512</SourceRepCatId>
<Report_Category_Component>
<DeliveryOptionName>HDL_Output</DeliveryOptionName>
</Report_Category_Component>
</Report_Category>
<Extract_Parameter>
<ParamName>Delete After Successful Load</ParamName>
<EssParamName>AUTO_DELETE</EssParamName>
<XmlTagName>auto_delete</XmlTagName>
<DataType>T</DataType>
<DescriptionInParam>Delete After Successful Load</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>20</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Delete Archive</ParamName>
<EssParamName>DELETE_ARCHIVE</EssParamName>
<XmlTagName>delete_archive</XmlTagName>
<DataType>T</DataType>
<DescriptionInParam>Delete Archive</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamDispType>LK</ParamDispType>
<ParamLookup>ORA_PER_EXT_DELETE_ARCHIVE</ParamLookup>
<ParamSequence>80</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Effective Date</ParamName>
<EssParamName>EFFECTIVE_DATE</EssParamName>
<XmlTagName>effective_date</XmlTagName>
<DataType>D</DataType>
<DescriptionInParam>Effective Date</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>Y</DisplayFlag>
<ParamSequence>40</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Legislative Data Group</ParamName>
<EssParamName>LEGISLATIVE_DATA_GROUP_ID</EssParamName>
<XmlTagName>legislative_data_group_id</XmlTagName>
<DataType>N</DataType>
<DescriptionInParam>Legislative Data Group</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>50</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Load Automatically</ParamName>
<EssParamName>AUTO_LOAD</EssParamName>
<XmlTagName>auto_load</XmlTagName>
<DataType>T</DataType>
<DescriptionInParam>Load Automatically</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>30</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Parameter Group</ParamName>
<EssParamName>PARAMETER_GROUP_ID</EssParamName>
<XmlTagName>parameter_group_id</XmlTagName>
<DataType>N</DataType>
<DescriptionInParam>Parameter Group</DescriptionInParam>
<AllowedInExpression>N</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>60</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Report Category</ParamName>
<EssParamName>REPORT_CATEGORY_ID</EssParamName>
<XmlTagName>report_category_id</XmlTagName>
<DataType>N</DataType>
<DescriptionInParam>Report Category</DescriptionInParam>
<AllowedInExpression>N</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>70</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Request ID</ParamName>
<EssParamName>REQUEST_ID</EssParamName>
<XmlTagName>request_id</XmlTagName>
<DataType>N</DataType>
<DescriptionInParam>Request ID</DescriptionInParam>
<AllowedInExpression>N</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>90</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
<Extract_Parameter>
<ParamName>Start Date</ParamName>
<EssParamName>START_DATE</EssParamName>
<XmlTagName>start_date</XmlTagName>
<DataType>D</DataType>
<DescriptionInParam>Start Date</DescriptionInParam>
<AllowedInExpression>Y</AllowedInExpression>
<Generated>Y</Generated>
<DisplayFlag>N</DisplayFlag>
<ParamSequence>10</ParamSequence>
<ParamUsageType>INPUT</ParamUsageType>
</Extract_Parameter>
</Extract_Definition>
Payroll Flow Pattern:
1. Add "Initiate HCM Data Loader" Task.
2. Add following parameters
Data Loader Archive Action --> Bind To Flow Task -->
Data Loader Configuration --> Constant Bind --> ImportMaximumErrors=100,LoadMaximumErrors=100,LoadConcurrentThreads=8,LoadGroupSize=100
No comments:
Post a Comment