HCM Extract - Sample

 <?xml version = '1.0' encoding = 'UTF-8'?>
<Extract_Definition><DefinitionName>XX_ZZ043B_Retirement_Payroll_Interface</DefinitionName><XmlTagName>ZZ043</XmlTagName><ExtTypeCode>HRAR</ExtTypeCode><DateStart>2000-01-01</DateStart><DefinitionDescription>Disability interface feed</DefinitionDescription><Status>A</Status><IncludeChangesFromLastSuccessfulRun>N</IncludeChangesFromLastSuccessfulRun><Extract_Block><BaseUserEntityName>PER_EXT_WORK_RELATIONSHIP_ALL_UE</BaseUserEntityName><BlockName>Work Relationship DG</BlockName><XmlTagName>PPOSDG</XmlTagName><MainBlockFlag>Y</MainBlockFlag><MultiThreadActType>O</MultiThreadActType><UserName>PER_EXT_WORK_REL_ALL_PERSON_ID</UserName><Block_Criteria><EffectiveStartDate>2000-01-01</EffectiveStartDate><Criteria>(pps.actual_termination_date >= (pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE') - 90)
   or pps.actual_termination_date is null)
and pps.legislation_code = 'US'
and pps.date_start = (select max(ppos.date_start) from per_periods_of_service ppos where ppos.person_id = pps.person_id and ppos.date_start &lt;= pay_report_utils.get_parameter_value_date('EFFECTIVE_DATE'))
 </Criteria><CriteriaFlag>C</CriteriaFlag><DispCriteriaExp>{EDITADV}{PER_EXT_WORK_REL_ALL_ACTUAL_TERMINATION_DATE}{=}{EFFECTIVE_DATE}</DispCriteriaExp></Block_Criteria><Extract_Record><RecordName>Work Relationship Rec</RecordName><XmlTagName>PPOS_Rec</XmlTagName><TypeCode>D</TypeCode><ProcessCode>FF</ProcessCode><FlexStructureCode>Work_Relationship_Rec</FlexStructureCode><Sequence>1</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><BaseRecordName>Work_Relationship_Rec300002909861862</BaseRecordName><EffectiveStartDate>2000-01-01</EffectiveStartDate><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>Person ID</DataElementName><ShortCode>PID</ShortCode><TypeCode>F</TypeCode><DataType>N</DataType><XmlTagName>PID</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><EndDate>4712-12-31</EndDate><DataElementName>PPOSID</DataElementName><ShortCode>PPOSID</ShortCode><TypeCode>F</TypeCode><DataType>N</DataType><XmlTagName>PPOSID</XmlTagName><InformationColumn>2</InformationColumn><InformationLabel>PPOSID</InformationLabel><GroupName>Extract Relationship Period Of Service Id</GroupName><BaseGroupName>PER_EXT_WORK_REL_ALL_PERIOD_OF_SERVICE_ID</BaseGroupName><KeyFlag>Y</KeyFlag><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement></Extract_Record><Extract_Record><RecordName>Person Traversal</RecordName><XmlTagName>PerTrav</XmlTagName><TypeCode>O</TypeCode><Sequence>5</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><NextBlockId>Person DG</NextBlockId><BaseRecordName>Person_Traversal300002909861863</BaseRecordName><EffectiveStartDate>2000-01-01</EffectiveStartDate></Extract_Record><Extract_Record><RecordName>Assignment Traversal</RecordName><XmlTagName>AsgTrav</XmlTagName><TypeCode>O</TypeCode><Sequence>7</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><NextBlockId>Assignment DG</NextBlockId><BaseRecordName>Assignment_Traversal300002909861864</BaseRecordName><EffectiveStartDate>2000-01-01</EffectiveStartDate></Extract_Record><Extract_Record><RecordName>Bal Trav</RecordName><XmlTagName>Bal_Trav</XmlTagName><TypeCode>O</TypeCode><Sequence>15</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><NextBlockId>Balance DG</NextBlockId><BaseRecordName>Bal_Trav300002909861865</BaseRecordName><EffectiveStartDate>2000-01-01</EffectiveStartDate></Extract_Record><Extract_Record><RecordName>Bal YTD Trav</RecordName><XmlTagName>BalYTDTrav</XmlTagName><TypeCode>O</TypeCode><Sequence>16</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><NextBlockId>YTD Balance DG</NextBlockId><BaseRecordName>Bal_YTD_Trav</BaseRecordName><EffectiveStartDate>2000-01-01</EffectiveStartDate></Extract_Record></Extract_Block><Extract_Block><BaseUserEntityName>PAYROLL REL ACTIONS RANGE UE</BaseUserEntityName><BlockName>Balance DG</BlockName><XmlTagName>BalDG</XmlTagName><Block_Link><ParentBlockId>Work Relationship DG</ParentBlockId><UserName1>PER_EXT_WORK_REL_ALL_PERSON_ID</UserName1><UserName>PAYROLL_REL_ACTION_PERSON_ID</UserName></Block_Link><Block_Criteria><EffectiveStartDate>2000-01-01</EffectiveStartDate><Criteria>ppa.effective_date between pay_report_utils.get_parameter_value_date('FROMDATE') and pay_report_utils.get_parameter_value_date('THRUDATE')
AND PPA.ACTION_TYPE IN ('Q','R','V','I')
AND PPA.ACTION_STATUS = 'C'
AND EXISTS (SELECT 'x' FROM PAY_RUN_RESULTS PRR
                , PAY_RUN_RESULT_VALUES PRRV
                , PAY_BALANCE_FEEDS_F PBF
                , PAY_BALANCE_TYPES_TL PB
            WHERE PRR.PAYROLL_REL_ACTION_ID    = PRA.PAYROLL_REL_ACTION_ID
                AND PRRV.RUN_RESULT_ID                = PRR.RUN_RESULT_ID
                AND PBF.INPUT_VALUE_ID                = PRRV.INPUT_VALUE_ID
                AND PPA.EFFECTIVE_DATE BETWEEN PBF.EFFECTIVE_START_DATE AND PBF.EFFECTIVE_END_DATE
                AND PB.BALANCE_TYPE_ID                = PBF.BALANCE_TYPE_ID
                AND PB.LANGUAGE                        = 'US'
                AND (PB.BALANCE_NAME LIKE '%401K%' OR PB.BALANCE_NAME LIKE 'PR Retirement%' OR PB.BALANCE_NAME IN ('Incentive Comp Bonus', 'Incentive Comp Bonus X','WWA', 'WHA', 'Loan 401k', 'Loan 401k Puerto Rico'))
            )</Criteria><CriteriaFlag>C</CriteriaFlag><DispCriteriaExp>{EDITADV}</DispCriteriaExp></Block_Criteria><Extract_Record><RecordName>Bal_PPRA</RecordName><XmlTagName>Bal_PPRA</XmlTagName><TypeCode>D</TypeCode><ProcessCode>FF</ProcessCode><FlexStructureCode>Bal_PPRA</FlexStructureCode><Sequence>1</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><BaseRecordName>Bal_PPRA300002909861889</BaseRecordName><EffectiveStartDate>2000-01-01</EffectiveStartDate><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>Pay Rel Action ID</DataElementName><ShortCode>Pay Rel Action ID</ShortCode><TypeCode>F</TypeCode><DataType>N</DataType><XmlTagName>PayRelActID</XmlTagName><InformationColumn>1</InformationColumn><InformationLabel>Pay Rel Action ID</InformationLabel><GroupName>PAYROLL REL ACTION RELATIONSHIP IDENTIFIER</GroupName><BaseGroupName>PAYROLL REL ACTION RELATIONSHIP IDENTIFIER</BaseGroupName></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>Pay Action EFFDT</DataElementName><ShortCode>Pay Action EFFDT</ShortCode><TypeCode>F</TypeCode><DataType>D</DataType><XmlTagName>PayActEffDT</XmlTagName><InformationColumn>2</InformationColumn><InformationLabel>Pay Action EFFDT</InformationLabel><GroupName>PAYROLL ACTION EFFECTIVE DATE</GroupName><BaseGroupName>PAYROLL ACTION EFFECTIVE DATE</BaseGroupName></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>Payroll Action ID</DataElementName><ShortCode>PAYROLL_ACTION_ID</ShortCode><TypeCode>F</TypeCode><DataType>N</DataType><XmlTagName>PayActID</XmlTagName><InformationColumn>3</InformationColumn><InformationLabel>Payroll Action ID</InformationLabel><GroupName>Payroll Action Id</GroupName><BaseGroupName>GLB_DED_ARCHIVE_PM_PAYROLL_ACTION_ID</BaseGroupName><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement></Extract_Record><Extract_Record><RecordName>Balance</RecordName><XmlTagName>Balance</XmlTagName><TypeCode>D</TypeCode><ProcessCode>BGX</ProcessCode><BaseGroupUsageName>XX_ZZ043B_Retirement_Balance_Group_Usage</BaseGroupUsageName><FlexStructureCode>Balance</FlexStructureCode><Sequence>10</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><BaseRecordName>Balance300002909861890</BaseRecordName><EffectiveStartDate>2000-01-01</EffectiveStartDate><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>PAYROLL_REL_ACTION_ID</DataElementName><ShortCode>PAYROLL_REL_ACTION_ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>PAYROLL_REL_ACTION_ID</XmlTagName><InformationColumn>10</InformationColumn><InformationLabel>PAYROLL_REL_ACTION_ID</InformationLabel><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>TAX_UNIT_ID</DataElementName><ShortCode>TAX_UNIT_ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>TAX_UNIT_ID</XmlTagName><InformationColumn>12</InformationColumn><InformationLabel>TAX_UNIT_ID</InformationLabel><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>PAYROLL ID</DataElementName><ShortCode>PAYROLL ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>PAYROLL_ID</XmlTagName><InformationColumn>13</InformationColumn><InformationLabel>PAYROLL ID</InformationLabel><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>CALC_BREAKDOWN_ID</DataElementName><ShortCode>CALC_BREAKDOWN_ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>CALC_BREAKDOWN_ID</XmlTagName><InformationColumn>14</InformationColumn><InformationLabel>CALC_BREAKDOWN_ID</InformationLabel><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>PAYROLL_RELATIONSHIP_ID</DataElementName><ShortCode>PAYROLL_RELATIONSHIP_ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>PAYROLL_RELATIONSHIP_ID</XmlTagName><InformationColumn>15</InformationColumn><InformationLabel>PAYROLL_RELATIONSHIP_ID</InformationLabel><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>BALANCE_TYPE_ID</DataElementName><ShortCode>BALANCE_TYPE_ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>BALANCE_TYPE_ID</XmlTagName><InformationColumn>16</InformationColumn><InformationLabel>BALANCE_TYPE_ID</InformationLabel></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>Base Balance Name</DataElementName><ShortCode>BASE_BALANCE_NAME</ShortCode><TypeCode>X</TypeCode><DataType>T</DataType><XmlTagName>BASE_BALANCE_NAME</XmlTagName><InformationColumn>17</InformationColumn><InformationLabel>Base Balance Name</InformationLabel><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>Category Name</DataElementName><ShortCode>CATEGORY_NAME</ShortCode><TypeCode>X</TypeCode><DataType>T</DataType><XmlTagName>CATEGORY_NAME</XmlTagName><InformationColumn>18</InformationColumn><InformationLabel>Category Name</InformationLabel><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>Base Category Name</DataElementName><ShortCode>BASE_CATEGORY_NAME</ShortCode><TypeCode>X</TypeCode><DataType>T</DataType><XmlTagName>BASE_CATEGORY_NAME</XmlTagName><InformationColumn>19</InformationColumn><InformationLabel>Base Category Name</InformationLabel><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>Reporting Name</DataElementName><ShortCode>REPORTING_NAME</ShortCode><TypeCode>X</TypeCode><DataType>T</DataType><XmlTagName>REPORTING_NAME</XmlTagName><InformationColumn>20</InformationColumn><InformationLabel>Reporting Name</InformationLabel><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>BASE DIMENSION NAME</DataElementName><ShortCode>BASE DIMENSION NAME</ShortCode><TypeCode>X</TypeCode><DataType>T</DataType><XmlTagName>BASE_DIMENSION_NAME</XmlTagName><InformationColumn>21</InformationColumn><InformationLabel>BASE DIMENSION NAME</InformationLabel></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>RUN</DataElementName><ShortCode>RUN</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>RUN</XmlTagName><InformationColumn>61</InformationColumn><InformationLabel>RUN</InformationLabel><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement></Extract_Record></Extract_Block><Extract_Block><BaseUserEntityName>PAYROLL REL ACTIONS RANGE UE</BaseUserEntityName><BlockName>YTD Balance DG</BlockName><XmlTagName>YTD_DG</XmlTagName><Block_Link><ParentBlockId>Work Relationship DG</ParentBlockId><UserName1>PER_EXT_WORK_REL_ALL_PERSON_ID</UserName1><UserName>PAYROLL_REL_ACTION_PERSON_ID</UserName></Block_Link><Block_Criteria><EffectiveStartDate>2000-01-01</EffectiveStartDate><Criteria>ppa.effective_date = pay_report_utils.get_parameter_value_date('THRUDATE')
AND PPA.ACTION_TYPE IN ('Q','R','V','I')
AND PPA.ACTION_STATUS = 'C'
AND EXISTS (SELECT 'x' FROM PAY_RUN_RESULTS PRR
                , PAY_RUN_RESULT_VALUES PRRV
                , PAY_BALANCE_FEEDS_F PBF
                , PAY_BALANCE_TYPES_TL PB
            WHERE PRR.PAYROLL_REL_ACTION_ID    = PRA.PAYROLL_REL_ACTION_ID
                AND PRRV.RUN_RESULT_ID                = PRR.RUN_RESULT_ID
                AND PBF.INPUT_VALUE_ID                = PRRV.INPUT_VALUE_ID
                AND PPA.EFFECTIVE_DATE BETWEEN PBF.EFFECTIVE_START_DATE AND PBF.EFFECTIVE_END_DATE
                AND PB.BALANCE_TYPE_ID                = PBF.BALANCE_TYPE_ID
                AND PB.LANGUAGE                        = 'US'
                AND (PB.BALANCE_NAME IN ('Incentive Comp Bonus', 'Incentive Comp Bonus X','WWA', 'WHA'))
            )</Criteria><CriteriaFlag>C</CriteriaFlag><DispCriteriaExp>{EDITADV}</DispCriteriaExp></Block_Criteria><Extract_Record><RecordName>YTD PPRA</RecordName><XmlTagName>YTD_PPRA</XmlTagName><TypeCode>D</TypeCode><ProcessCode>FF</ProcessCode><FlexStructureCode>YTD_PPRA</FlexStructureCode><Sequence>72</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><BaseRecordName>YTD_PPRA</BaseRecordName><EffectiveStartDate>2000-01-01</EffectiveStartDate><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>Pay Rel Action ID</DataElementName><ShortCode>RELACTID</ShortCode><TypeCode>F</TypeCode><DataType>N</DataType><XmlTagName>RelActID</XmlTagName><InformationColumn>1</InformationColumn><InformationLabel>Pay Rel Action ID</InformationLabel><GroupName>PAYROLL REL ACTION RELATIONSHIP IDENTIFIER</GroupName><BaseGroupName>PAYROLL REL ACTION RELATIONSHIP IDENTIFIER</BaseGroupName></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>Pay Act EffDT</DataElementName><ShortCode>ACTEFFDT</ShortCode><TypeCode>F</TypeCode><DataType>D</DataType><XmlTagName>ActEffDT</XmlTagName><InformationColumn>2</InformationColumn><InformationLabel>Pay Act EffDT</InformationLabel><GroupName>PAYROLL ACTION EFFECTIVE DATE</GroupName><BaseGroupName>PAYROLL ACTION EFFECTIVE DATE</BaseGroupName></Extract_DataElement></Extract_Record><Extract_Record><RecordName>YTD Balance</RecordName><XmlTagName>YTD_Balance</XmlTagName><TypeCode>D</TypeCode><ProcessCode>BGX</ProcessCode><BaseGroupUsageName>XX_ZZ043B_YTD_Bal_Grp_Usage</BaseGroupUsageName><FlexStructureCode>YTD_Balance</FlexStructureCode><Sequence>75</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><BaseRecordName>YTD_Balance</BaseRecordName><EffectiveStartDate>2000-01-01</EffectiveStartDate><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>PAYROLL_REL_ACTION_ID</DataElementName><ShortCode>PAYROLL_REL_ACTION_ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>PAYROLL_REL_ACTION_ID</XmlTagName><InformationColumn>120</InformationColumn><InformationLabel>PAYROLL_REL_ACTION_ID</InformationLabel></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>TAX_UNIT_ID</DataElementName><ShortCode>TAX_UNIT_ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>TAX_UNIT_ID</XmlTagName><InformationColumn>121</InformationColumn><InformationLabel>TAX_UNIT_ID</InformationLabel></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>CALC_BREAKDOWN_ID</DataElementName><ShortCode>CALC_BREAKDOWN_ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>CALC_BREAKDOWN_ID</XmlTagName><InformationColumn>122</InformationColumn><InformationLabel>CALC_BREAKDOWN_ID</InformationLabel></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>PAYROLL_RELATIONSHIP_ID</DataElementName><ShortCode>PAYROLL_RELATIONSHIP_ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>PAYROLL_RELATIONSHIP_ID</XmlTagName><InformationColumn>123</InformationColumn><InformationLabel>PAYROLL_RELATIONSHIP_ID</InformationLabel></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>BALANCE_TYPE_ID</DataElementName><ShortCode>BALANCE_TYPE_ID</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>BALANCE_TYPE_ID</XmlTagName><InformationColumn>124</InformationColumn><InformationLabel>BALANCE_TYPE_ID</InformationLabel></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>BASE_BALANCE_NAME</DataElementName><ShortCode>BASE_BALANCE_NAME</ShortCode><TypeCode>X</TypeCode><DataType>T</DataType><XmlTagName>BASE_BALANCE_NAME</XmlTagName><InformationColumn>125</InformationColumn><InformationLabel>BASE_BALANCE_NAME</InformationLabel></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>YEAR</DataElementName><ShortCode>YEAR</ShortCode><TypeCode>X</TypeCode><DataType>N</DataType><XmlTagName>YEAR</XmlTagName><InformationColumn>130</InformationColumn><InformationLabel>YEAR</InformationLabel></Extract_DataElement></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}{PER_EXT_ASG_ASSIGNMENT_TYPE}{=}{'E'}</DispCriteriaExp></Block_Criteria><Extract_Record><RecordName>Assignment Record</RecordName><XmlTagName>AsgRec</XmlTagName><TypeCode>D</TypeCode><ProcessCode>FF</ProcessCode><FlexStructureCode>Assignment_Record</FlexStructureCode><Sequence>10</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><BaseRecordName>Assignment_Record300002909861841</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>Extract Assignment Person ID</GroupName><BaseGroupName>PER_EXT_ASG_PERSON_ID</BaseGroupName><KeyFlag>Y</KeyFlag><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>Company</DataElementName><ShortCode>CMP</ShortCode><TypeCode>F</TypeCode><DataType>T</DataType><XmlTagName>CMP</XmlTagName><InformationColumn>23</InformationColumn><InformationLabel>Organization Legal Employer Legal Entity Identifier</InformationLabel><GroupName>Organization Legal Employer Legal Entity Identifier</GroupName><BaseGroupName>Organization Legal Employer Legal Entity Identifier</BaseGroupName><ExcludeFromComparison>Y</ExcludeFromComparison><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><DataElementName>Division Code</DataElementName><ShortCode>DIVCD</ShortCode><TypeCode>R</TypeCode><DataType>T</DataType><XmlTagName>DivCD</XmlTagName><InformationColumn>25</InformationColumn><InformationLabel>Division Code</InformationLabel><FormulaName>XX_ZZ043B_Division_Code</FormulaName><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement></Extract_Record></Extract_Block><Extract_Block><BaseUserEntityName>PER_EXT_SEC_PERSON_UE</BaseUserEntityName><BlockName>Person DG</BlockName><XmlTagName>PerDG</XmlTagName><Block_Link><ParentBlockId>Work Relationship DG</ParentBlockId><UserName1>PER_EXT_WORK_REL_ALL_PERSON_ID</UserName1><UserName>PER_EXT_PER_PERSON_ID</UserName></Block_Link><Block_Criteria><EffectiveStartDate>2000-01-01</EffectiveStartDate><Criteria>(pptum.system_person_type IN ('EMP', 'EX_EMP'))</Criteria><CriteriaFlag>C</CriteriaFlag><DispCriteriaExp>{PER_EXT_PER_SYSTEM_PERSON_TYPE}{In}{(}{'EMP','EX_EMP'}{)}</DispCriteriaExp></Block_Criteria><Extract_Record><RecordName>Person Rec</RecordName><XmlTagName>PerRec</XmlTagName><TypeCode>D</TypeCode><ProcessCode>FF</ProcessCode><FlexStructureCode>Person_Rec</FlexStructureCode><Sequence>10</Sequence><LastRunExecutedMode>N</LastRunExecutedMode><OverflowMode>N</OverflowMode><BaseRecordName>Person_Rec300002909861875</BaseRecordName><EffectiveStartDate>2000-01-01</EffectiveStartDate><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>Person ID</DataElementName><ShortCode>PERSONID</ShortCode><TypeCode>F</TypeCode><DataType>N</DataType><XmlTagName>PerID</XmlTagName><InformationColumn>1</InformationColumn><InformationLabel>Person ID</InformationLabel><GroupName>Extract Person ID</GroupName><BaseGroupName>PER_EXT_PER_PERSON_ID</BaseGroupName><KeyFlag>Y</KeyFlag><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>Person Number</DataElementName><ShortCode>PERNUM</ShortCode><TypeCode>F</TypeCode><DataType>T</DataType><XmlTagName>PerNum</XmlTagName><InformationColumn>10</InformationColumn><InformationLabel>Person Number</InformationLabel><GroupName>Extract Person Number</GroupName><BaseGroupName>PER_EXT_PER_PERSON_NUMBER</BaseGroupName><ExcludeFromComparison>Y</ExcludeFromComparison><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>SSN</DataElementName><ShortCode>SSN</ShortCode><TypeCode>F</TypeCode><DataType>T</DataType><XmlTagName>SSN</XmlTagName><InformationColumn>12</InformationColumn><InformationLabel>SSN</InformationLabel><GroupName>Person Primary NID</GroupName><BaseGroupName>Person Primary NID</BaseGroupName><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>First Name</DataElementName><ShortCode>FNAME</ShortCode><TypeCode>F</TypeCode><DataType>T</DataType><XmlTagName>FName</XmlTagName><InformationColumn>15</InformationColumn><InformationLabel>First Name</InformationLabel><GroupName>Person First Name</GroupName><BaseGroupName>Person First Name</BaseGroupName><ExcludeFromComparison>Y</ExcludeFromComparison><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>Last Name</DataElementName><ShortCode>LNAME</ShortCode><TypeCode>F</TypeCode><DataType>T</DataType><XmlTagName>LName</XmlTagName><InformationColumn>16</InformationColumn><InformationLabel>Last Name</InformationLabel><GroupName>Person Last Name</GroupName><BaseGroupName>Person Last Name</BaseGroupName><ExcludeFromComparison>Y</ExcludeFromComparison><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement><Extract_DataElement><StartDate>2000-01-01</StartDate><EndDate>4712-12-31</EndDate><DataElementName>Middle Name</DataElementName><ShortCode>MName</ShortCode><TypeCode>F</TypeCode><DataType>T</DataType><XmlTagName>MName</XmlTagName><InformationColumn>17</InformationColumn><InformationLabel>Middle Name</InformationLabel><GroupName>Person Middle Name</GroupName><BaseGroupName>Person Middle Name</BaseGroupName><ExcludeFromComparison>Y</ExcludeFromComparison><AlwaysDisplay>Y</AlwaysDisplay></Extract_DataElement></Extract_Record></Extract_Block><Delivery_Option><DateFrom>2000-01-01</DateFrom><DateTo>4712-12-31</DateTo><BipReportName>/Interface/Outbound/I_ZZ043/XX_ZZ043B_Retirement_Payroll_Extract.xdo</BipReportName><BipTemplateName>XX_ZZ043B_Monetary_Template</BipTemplateName><DeliveryOptionName>Payroll_File</DeliveryOptionName><DeliveryType>NONE</DeliveryType><CalendarCode>GREGORIAN</CalendarCode><OutputName>XX_ZZ043b_payroll_file</OutputName><OutputType>TEXT</OutputType><MandatoryFlag>Y</MandatoryFlag><Delivery_Option_Detail><OptionType>BURSTING</OptionType></Delivery_Option_Detail><Delivery_Option_Detail><OptionType>FILE_NAME_DE</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>OBJECT_ID</OptionType></Delivery_Option_Detail><Delivery_Option_Detail><OptionType>OBJECT_TYPE</OptionType></Delivery_Option_Detail><Delivery_Option_Detail><OptionType>SYSTEM_DOCUMENT_TYPE</OptionType></Delivery_Option_Detail><Delivery_Option_Detail><OptionType>TIMEZONE</OptionType></Delivery_Option_Detail><Delivery_Option_Detail><OptionType>ZIP</OptionType></Delivery_Option_Detail></Delivery_Option><Report_Category><CategoryName>XX_ZZ043B_Retirement_Payroll_Interface</CategoryName><ShortName>EXT300003005399777</ShortName><Description>Disability interface feed</Description><DefaultCategory>Y</DefaultCategory><SourceRepCatId>300003005399787</SourceRepCatId><Report_Category_Component><DeliveryOptionName>Payroll_File</DeliveryOptionName></Report_Category_Component></Report_Category><Extract_Parameter><ParamName>Check Date</ParamName><EssParamName>CHECK_DATE</EssParamName><XmlTagName>Check_Date</XmlTagName><DataType>D</DataType><DescriptionInParam>Check Date</DescriptionInParam><AllowedInExpression>Y</AllowedInExpression><Generated>N</Generated><DisplayFlag>Y</DisplayFlag><ParamSequence>15</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>70</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>10</ParamSequence><ParamUsageType>INPUT</ParamUsageType></Extract_Parameter><Extract_Parameter><ParamName>FromDate</ParamName><EssParamName>FROMDATE</EssParamName><XmlTagName>FromDate</XmlTagName><DataType>D</DataType><AllowedInExpression>Y</AllowedInExpression><Generated>N</Generated><DisplayFlag>Y</DisplayFlag><ParamSequence>16</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>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>20</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>30</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>40</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>60</ParamSequence><ParamUsageType>INPUT</ParamUsageType></Extract_Parameter><Extract_Parameter><ParamName>ThruDate</ParamName><EssParamName>THRUDATE</EssParamName><XmlTagName>ThruDate</XmlTagName><DataType>D</DataType><AllowedInExpression>Y</AllowedInExpression><Generated>N</Generated><DisplayFlag>Y</DisplayFlag><ParamSequence>17</ParamSequence><ParamUsageType>INPUT</ParamUsageType></Extract_Parameter></Extract_Definition>