<?xml version="1.0" encoding="ISO-8859-1"?>
<!DOCTYPE POWERMART SYSTEM "powrmart.dtd">
<POWERMART CREATION_DATE="06/27/2019 19:07:03" REPOSITORY_VERSION="187.96">
<REPOSITORY NAME="Test_Repo_Srvc" VERSION="187" CODEPAGE="Latin1" DATABASETYPE="Oracle">
<FOLDER NAME="COMP_TIME" GROUP="" OWNER="Administrator" SHARED="NOTSHARED" DESCRIPTION="Deployement code COMP_TIME on 06202019" PERMISSIONS="rwx---r--" UUID="2f90f391-a366-4957-b3ee-9a039dc81b35">
<SOURCE BUSINESSNAME ="" DATABASETYPE ="Flat File" DBDNAME ="FlatFile" DESCRIPTION ="" NAME ="U0287D01" OBJECTVERSION ="1" OWNERNAME ="" VERSIONNUMBER ="1">
<FLATFILE CODEPAGE ="MS1252" CONSECDELIMITERSASONE ="NO" DELIMITED ="YES" DELIMITERS ="," ESCAPE_CHARACTER ="" KEEPESCAPECHAR ="NO" LINESEQUENTIAL ="NO" MULTIDELIMITERSASAND ="NO" NULLCHARTYPE ="ASCII" NULL_CHARACTER ="*" PADBYTES ="1" QUOTE_CHARACTER ="DOUBLE" REPEATABLE ="NO" ROWDELIMITER ="0" SHIFTSENSITIVEDATA ="NO" SKIPROWS ="0" STRIPTRAILINGBLANKS ="NO"/>
<TABLEATTRIBUTE NAME ="Base Table Name" VALUE =""/>
<TABLEATTRIBUTE NAME ="Search Specification" VALUE =""/>
<TABLEATTRIBUTE NAME ="Sort Specification" VALUE =""/>
<TABLEATTRIBUTE NAME ="Datetime Format" VALUE ="A 19 mm/dd/yyyy hh24:mi:ss"/>
<TABLEATTRIBUTE NAME ="Thousand Separator" VALUE ="None"/>
<TABLEATTRIBUTE NAME ="Decimal Separator" VALUE ="."/>
<TABLEATTRIBUTE NAME ="Add Currently Processed Flat File Name Port" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Source TimeStamp" VALUE =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="string" DESCRIPTION ="" FIELDNUMBER ="1" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="9" LEVEL ="0" NAME ="SSN" NULLABLE ="NULL" OCCURS ="0" OFFSET ="0" PHYSICALLENGTH ="9" PHYSICALOFFSET ="0" PICTURETEXT ="" PRECISION ="9" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="string" DESCRIPTION ="" FIELDNUMBER ="2" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="30" LEVEL ="0" NAME ="NAME" NULLABLE ="NULL" OCCURS ="0" OFFSET ="9" PHYSICALLENGTH ="30" PHYSICALOFFSET ="9" PICTURETEXT ="" PRECISION ="30" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="string" DESCRIPTION ="" FIELDNUMBER ="3" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="6" LEVEL ="0" NAME ="CURRENT_ACCT" NULLABLE ="NULL" OCCURS ="0" OFFSET ="39" PHYSICALLENGTH ="6" PHYSICALOFFSET ="39" PICTURETEXT ="" PRECISION ="6" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="string" DESCRIPTION ="" FIELDNUMBER ="4" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="7" LEVEL ="0" NAME ="CURRENT_ORG" NULLABLE ="NULL" OCCURS ="0" OFFSET ="45" PHYSICALLENGTH ="7" PHYSICALOFFSET ="45" PICTURETEXT ="" PRECISION ="7" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="string" DESCRIPTION ="" FIELDNUMBER ="5" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="1" LEVEL ="0" NAME ="FLSA_STATUS" NULLABLE ="NULL" OCCURS ="0" OFFSET ="52" PHYSICALLENGTH ="1" PHYSICALOFFSET ="52" PICTURETEXT ="" PRECISION ="1" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="number" DESCRIPTION ="" FIELDNUMBER ="6" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="8" LEVEL ="0" NAME ="COMP_TIME_CUR_BAL" NULLABLE ="NULL" OCCURS ="0" OFFSET ="53" PHYSICALLENGTH ="8" PHYSICALOFFSET ="53" PICTURETEXT ="" PRECISION ="8" SCALE ="2" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="number" DESCRIPTION ="" FIELDNUMBER ="7" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="4" LEVEL ="0" NAME ="COMP_TIME_YEAR_EARNED" NULLABLE ="NULL" OCCURS ="0" OFFSET ="61" PHYSICALLENGTH ="4" PHYSICALOFFSET ="61" PICTURETEXT ="" PRECISION ="4" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="string" DESCRIPTION ="" FIELDNUMBER ="8" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="8" LEVEL ="0" NAME ="PP_END_DATE" NULLABLE ="NULL" OCCURS ="0" OFFSET ="65" PHYSICALLENGTH ="8" PHYSICALOFFSET ="65" PICTURETEXT ="" PRECISION ="8" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="string" DESCRIPTION ="" FIELDNUMBER ="9" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="8" LEVEL ="0" NAME ="DAILY_DATE_EARNED" NULLABLE ="NULL" OCCURS ="0" OFFSET ="73" PHYSICALLENGTH ="8" PHYSICALOFFSET ="73" PICTURETEXT ="" PRECISION ="8" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="number" DESCRIPTION ="" FIELDNUMBER ="10" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="6" LEVEL ="0" NAME ="COMP_TIME_RATE" NULLABLE ="NULL" OCCURS ="0" OFFSET ="81" PHYSICALLENGTH ="6" PHYSICALOFFSET ="81" PICTURETEXT ="" PRECISION ="6" SCALE ="2" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="number" DESCRIPTION ="" FIELDNUMBER ="11" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="8" LEVEL ="0" NAME ="COMP_TIME_HOURS" NULLABLE ="NULL" OCCURS ="0" OFFSET ="87" PHYSICALLENGTH ="8" PHYSICALOFFSET ="87" PICTURETEXT ="" PRECISION ="8" SCALE ="2" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="number" DESCRIPTION ="" FIELDNUMBER ="12" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="6" LEVEL ="0" NAME ="COMP_TIME_UNDEF" NULLABLE ="NULL" OCCURS ="0" OFFSET ="95" PHYSICALLENGTH ="6" PHYSICALOFFSET ="95" PICTURETEXT ="" PRECISION ="6" SCALE ="0" USAGE_FLAGS =""/>
</SOURCE>
<SOURCE BUSINESSNAME ="" DATABASETYPE ="Oracle" DBDNAME ="ORA_BIIS" DESCRIPTION ="" NAME ="PAY_PERIOD" OBJECTVERSION ="1" OWNERNAME ="HISTDBA" VERSIONNUMBER ="1">
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="1" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="PRIMARY KEY" LENGTH ="4" LEVEL ="0" NAME ="PP_NUM" NULLABLE ="NOTNULL" OCCURS ="0" OFFSET ="0" PHYSICALLENGTH ="2" PHYSICALOFFSET ="0" PICTURETEXT ="" PRECISION ="2" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="2" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="PRIMARY KEY" LENGTH ="6" LEVEL ="0" NAME ="PP_END_YEAR" NULLABLE ="NOTNULL" OCCURS ="0" OFFSET ="4" PHYSICALLENGTH ="4" PHYSICALOFFSET ="2" PICTURETEXT ="" PRECISION ="4" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="3" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="19" LEVEL ="0" NAME ="PP_START_DTE" NULLABLE ="NULL" OCCURS ="0" OFFSET ="10" PHYSICALLENGTH ="19" PHYSICALOFFSET ="6" PICTURETEXT ="" PRECISION ="19" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="4" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="19" LEVEL ="0" NAME ="PP_END_DTE" NULLABLE ="NULL" OCCURS ="0" OFFSET ="29" PHYSICALLENGTH ="19" PHYSICALOFFSET ="25" PICTURETEXT ="" PRECISION ="19" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="5" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="4" LEVEL ="0" NAME ="LV_NUM" NULLABLE ="NULL" OCCURS ="0" OFFSET ="48" PHYSICALLENGTH ="2" PHYSICALOFFSET ="44" PICTURETEXT ="" PRECISION ="2" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="6" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="6" LEVEL ="0" NAME ="LV_YEAR" NULLABLE ="NULL" OCCURS ="0" OFFSET ="52" PHYSICALLENGTH ="4" PHYSICALOFFSET ="46" PICTURETEXT ="" PRECISION ="4" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="7" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="19" LEVEL ="0" NAME ="PAY_DTE" NULLABLE ="NULL" OCCURS ="0" OFFSET ="58" PHYSICALLENGTH ="19" PHYSICALOFFSET ="50" PICTURETEXT ="" PRECISION ="19" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="varchar2" DESCRIPTION ="" FIELDNUMBER ="8" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="0" LEVEL ="0" NAME ="CURR_PP_FLAG" NULLABLE ="NULL" OCCURS ="0" OFFSET ="77" PHYSICALLENGTH ="1" PHYSICALOFFSET ="69" PICTURETEXT ="" PRECISION ="1" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="9" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="19" LEVEL ="0" NAME ="HOLIDAY_1" NULLABLE ="NULL" OCCURS ="0" OFFSET ="77" PHYSICALLENGTH ="19" PHYSICALOFFSET ="70" PICTURETEXT ="" PRECISION ="19" SCALE ="0" USAGE_FLAGS =""/>
<SOURCEFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="10" FIELDPROPERTY ="0" FIELDTYPE ="ELEMITEM" HIDDEN ="NO" KEYTYPE ="NOT A KEY" LENGTH ="19" LEVEL ="0" NAME ="HOLIDAY_2" NULLABLE ="NULL" OCCURS ="0" OFFSET ="96" PHYSICALLENGTH ="19" PHYSICALOFFSET ="89" PICTURETEXT ="" PRECISION ="19" SCALE ="0" USAGE_FLAGS =""/>
</SOURCE>
<TARGET BUSINESSNAME ="" CONSTRAINT ="" DATABASETYPE ="Oracle" DESCRIPTION ="" NAME ="COUNTER_TBL" OBJECTVERSION ="1" TABLEOPTIONS ="" VERSIONNUMBER ="1">
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="1" KEYTYPE ="NOT A KEY" NAME ="RUN_DATE" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="19" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="varchar2" DESCRIPTION ="" FIELDNUMBER ="2" KEYTYPE ="NOT A KEY" NAME ="PROCESS_NAME" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="100" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="varchar2" DESCRIPTION ="" FIELDNUMBER ="3" KEYTYPE ="NOT A KEY" NAME ="COUNTER_DESCRIPTION" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="200" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number" DESCRIPTION ="" FIELDNUMBER ="4" KEYTYPE ="NOT A KEY" NAME ="COUNTER_VALUE" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="15" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="5" KEYTYPE ="NOT A KEY" NAME ="PP_END_YEAR" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="4" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="6" KEYTYPE ="NOT A KEY" NAME ="PP_NUM" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="2" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="7" KEYTYPE ="NOT A KEY" NAME ="CYCLE_ID" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="1" SCALE ="0"/>
</TARGET>
<TARGET BUSINESSNAME ="" CONSTRAINT ="" DATABASETYPE ="Flat File" DESCRIPTION ="" NAME ="COMPTIME_MESSAGE_FILE" OBJECTVERSION ="1" TABLEOPTIONS ="" VERSIONNUMBER ="1">
<FLATFILE CODEPAGE ="Latin1" CONSECDELIMITERSASONE ="NO" DELIMITED ="NO" DELIMITERS ="," ESCAPE_CHARACTER ="" KEEPESCAPECHAR ="NO" LINESEQUENTIAL ="NO" MULTIDELIMITERSASAND ="NO" NULLCHARTYPE ="ASCII" NULL_CHARACTER ="*" PADBYTES ="1" QUOTE_CHARACTER ="NONE" REPEATABLE ="NO" ROWDELIMITER ="0" SKIPROWS ="0" STRIPTRAILINGBLANKS ="NO"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="string" DESCRIPTION ="" FIELDNUMBER ="1" KEYTYPE ="NOT A KEY" NAME ="SUBJECT" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="100" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="string" DESCRIPTION ="" FIELDNUMBER ="2" KEYTYPE ="NOT A KEY" NAME ="MESSAGE" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="300" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Datetime Format" VALUE ="A 19 mm/dd/yyyy hh24:mi:ss"/>
<TABLEATTRIBUTE NAME ="Thousand Separator" VALUE ="None"/>
<TABLEATTRIBUTE NAME ="Decimal Separator" VALUE ="."/>
<TABLEATTRIBUTE NAME ="Line Endings" VALUE ="System default"/>
</TARGET>
<TARGET BUSINESSNAME ="" CONSTRAINT ="" DATABASETYPE ="Oracle" DESCRIPTION ="" NAME ="COMP_TIME_DAILY_TBL" OBJECTVERSION ="1" TABLEOPTIONS ="" VERSIONNUMBER ="1">
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="1" KEYTYPE ="NOT A KEY" NAME ="PP_END_YEAR" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="4" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="2" KEYTYPE ="NOT A KEY" NAME ="PP_NUM" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="2" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="3" KEYTYPE ="NOT A KEY" NAME ="PP_YEAR_NUM" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="6" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="varchar2" DESCRIPTION ="" FIELDNUMBER ="4" KEYTYPE ="NOT A KEY" NAME ="SSN" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="9" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="varchar2" DESCRIPTION ="" FIELDNUMBER ="5" KEYTYPE ="NOT A KEY" NAME ="NAME" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="30" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="varchar2" DESCRIPTION ="" FIELDNUMBER ="6" KEYTYPE ="NOT A KEY" NAME ="CURRENT_ACCT" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="6" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="varchar2" DESCRIPTION ="" FIELDNUMBER ="7" KEYTYPE ="NOT A KEY" NAME ="CURRENT_ORG" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="7" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="varchar2" DESCRIPTION ="" FIELDNUMBER ="8" KEYTYPE ="NOT A KEY" NAME ="FLSA_STATUS" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="1" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="9" KEYTYPE ="NOT A KEY" NAME ="COMP_TIME_CUR_BAL" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="8" SCALE ="2"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="10" KEYTYPE ="NOT A KEY" NAME ="COMP_TIME_YEAR_EARNED" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="4" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="11" KEYTYPE ="NOT A KEY" NAME ="PP_END_DATE" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="19" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="date" DESCRIPTION ="" FIELDNUMBER ="12" KEYTYPE ="NOT A KEY" NAME ="DAILY_DATE_EARNED" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="19" SCALE ="0"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="13" KEYTYPE ="NOT A KEY" NAME ="COMP_TIME_RATE" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="6" SCALE ="2"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="14" KEYTYPE ="NOT A KEY" NAME ="COMP_TIME_HOURS" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="8" SCALE ="2"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="number(p,s)" DESCRIPTION ="" FIELDNUMBER ="15" KEYTYPE ="NOT A KEY" NAME ="COMP_TIME_UNDEF" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="6" SCALE ="0"/>
</TARGET>
<TARGET BUSINESSNAME ="" CONSTRAINT ="" DATABASETYPE ="Flat File" DESCRIPTION ="" NAME ="COMP_TIME_DATE_FILE" OBJECTVERSION ="1" TABLEOPTIONS ="" VERSIONNUMBER ="1">
<FLATFILE CODEPAGE ="MS1252" CONSECDELIMITERSASONE ="NO" DELIMITED ="NO" DELIMITERS ="," ESCAPE_CHARACTER ="" KEEPESCAPECHAR ="NO" LINESEQUENTIAL ="NO" MULTIDELIMITERSASAND ="NO" NULLCHARTYPE ="ASCII" NULL_CHARACTER ="*" PADBYTES ="1" QUOTE_CHARACTER ="NONE" REPEATABLE ="NO" ROWDELIMITER ="0" SKIPROWS ="0" STRIPTRAILINGBLANKS ="NO"/>
<TARGETFIELD BUSINESSNAME ="" DATATYPE ="string" DESCRIPTION ="" FIELDNUMBER ="1" KEYTYPE ="NOT A KEY" NAME ="PAY_PERIOD" NULLABLE ="NULL" PICTURETEXT ="" PRECISION ="6" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Datetime Format" VALUE ="A 19 mm/dd/yyyy hh24:mi:ss"/>
<TABLEATTRIBUTE NAME ="Thousand Separator" VALUE ="None"/>
<TABLEATTRIBUTE NAME ="Decimal Separator" VALUE ="."/>
<TABLEATTRIBUTE NAME ="Line Endings" VALUE ="System default"/>
</TARGET>
<MAPPING DESCRIPTION ="This mapping gets the count of detail records on the CompTime file that was processed and loads it to the Counters Table. " ISVALID ="YES" NAME ="m_COMPTIME_Build_Message_Counters" OBJECTVERSION ="1" VERSIONNUMBER ="1">
<TRANSFORMATION DESCRIPTION ="This transformation sets the mapping variables MAP_SUBJECT and MAP_MESSAGE using the counters and descriptions set in the previous expression transformation." NAME ="exp_Build_Message" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COUNTER_DESCRIPTION_1" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="200" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COUNTER_1" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_NUM" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="IIF(PP_NUM < 10,
 LPAD(TO_CHAR(PP_NUM), 2, '0'),
 TO_CHAR(PP_NUM)
)" EXPRESSIONTYPE ="GENERAL" NAME ="v_PP_NUM" PICTURETEXT ="" PORTTYPE ="LOCAL VARIABLE" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="DECODE(SUBSTR($PMRepositoryServiceName, 1, 4),
 'Dev_', 'Dev: ',
 'Test', 'Test: ',
 'Prod', 'Prod: ')
" EXPRESSIONTYPE ="GENERAL" NAME ="v_ENVIRONMENT" PICTURETEXT ="" PORTTYPE ="LOCAL VARIABLE" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="v_ENVIRONMENT ||
'Comp Time File loaded successfully for Pay Period: ' || 
TO_CHAR(PP_END_YEAR) || '-' || v_PP_NUM" EXPRESSIONTYPE ="GENERAL" NAME ="v_SUBJECT" PICTURETEXT ="" PORTTYPE ="LOCAL VARIABLE" PRECISION ="100" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="SETVARIABLE($$MAP_SUBJECT, v_SUBJECT)" EXPRESSIONTYPE ="GENERAL" NAME ="o_SUBJECT" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="100" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="'Number of Detail Records from Comp Time file	= ' || TO_CHAR(COUNTER_1)" EXPRESSIONTYPE ="GENERAL" NAME ="v_MESSAGE" PICTURETEXT ="" PORTTYPE ="LOCAL VARIABLE" PRECISION ="300" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="SETVARIABLE($$MAP_MESSAGE, v_MESSAGE)" EXPRESSIONTYPE ="GENERAL" NAME ="o_MESSAGE" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="300" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="Filters Detail Records" NAME ="fil_Detail" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Filter" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="SSN" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="9" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="RECORD_TYPE_FLAG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="RECORD_TYPE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="DETAIL_CONSTANT" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="1" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Filter Condition" VALUE ="RECORD_TYPE_FLAG = 'D'

--RECORD_TYPE_FLAG = 'H' OR"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="Determines Detail records to be used for further processing." NAME ="exp_Initial" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="SSN" EXPRESSIONTYPE ="GENERAL" NAME ="SSN" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="9" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="NAME" EXPRESSIONTYPE ="GENERAL" NAME ="NAME" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="30" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="DECODE(TRUE,
			 IS_NUMBER(SSN), 'D',
			 'NO')" EXPRESSIONTYPE ="GENERAL" NAME ="o_RECORD_TYPE_FLAG" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="10" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="Performs a count on all Detail Records." NAME ="agg_ALL_RECORDS" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Aggregator" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="SSN" EXPRESSIONTYPE ="GENERAL" NAME ="SSN" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="9" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="RECORD_TYPE_FLAG" EXPRESSIONTYPE ="GENERAL" NAME ="RECORD_TYPE_FLAG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="RECORD_TYPE" EXPRESSIONTYPE ="GENERAL" NAME ="RECORD_TYPE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="integer" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="COUNT(SSN)" EXPRESSIONTYPE ="GENERAL" NAME ="o_DETAIL_RECORD_COUNT" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="10" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Cache Directory" VALUE ="$PMCacheDir"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
<TABLEATTRIBUTE NAME ="Sorted Input" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Aggregator Data Cache Size" VALUE ="Auto"/>
<TABLEATTRIBUTE NAME ="Aggregator Index Cache Size" VALUE ="Auto"/>
<TABLEATTRIBUTE NAME ="Transformation Scope" VALUE ="All Input"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="exp_Detail_Count" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="DETAIL_RECORD_COUNT" EXPRESSIONTYPE ="GENERAL" NAME ="DETAIL_RECORD_COUNT" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="'Y'" EXPRESSIONTYPE ="GENERAL" NAME ="o_CURR_PP_FLAG" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="Compiles all the counter values." NAME ="exp_Counters" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="'Number of detail records from the COMP TIME file.'" EXPRESSIONTYPE ="GENERAL" NAME ="o_COUNTER_DESCRIPTION_1" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="200" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="DETAIL_RECORD_COUNT" EXPRESSIONTYPE ="GENERAL" NAME ="DETAIL_RECORD_COUNT" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="lkp_PP_NUM" EXPRESSIONTYPE ="GENERAL" NAME ="lkp_PP_NUM" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="lkp_PP_END_YEAR" EXPRESSIONTYPE ="GENERAL" NAME ="lkp_PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="exp_Final" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="SESSSTARTTIME" EXPRESSIONTYPE ="GENERAL" NAME ="o_RUN_DATE" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="$PMMappingName" EXPRESSIONTYPE ="GENERAL" NAME ="o_PROCESS_NAME" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="100" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COUNTER_DESCRIPTION" EXPRESSIONTYPE ="GENERAL" NAME ="COUNTER_DESCRIPTION" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="200" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="double" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COUNTER_VALUE" EXPRESSIONTYPE ="GENERAL" NAME ="COUNTER_VALUE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="15" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="SQ_U0287D01" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Source Qualifier" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="SSN" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="9" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="NAME" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="30" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="CURRENT_ACCT" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="CURRENT_ORG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="7" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="FLSA_STATUS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="1" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_CUR_BAL" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_YEAR_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_DATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="DAILY_DATE_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_RATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_HOURS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_UNDEF" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Sql Query" VALUE =""/>
<TABLEATTRIBUTE NAME ="User Defined Join" VALUE =""/>
<TABLEATTRIBUTE NAME ="Source Filter" VALUE =""/>
<TABLEATTRIBUTE NAME ="Number Of Sorted Ports" VALUE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
<TABLEATTRIBUTE NAME ="Select Distinct" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Is Partitionable" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Pre SQL" VALUE =""/>
<TABLEATTRIBUTE NAME ="Post SQL" VALUE =""/>
<TABLEATTRIBUTE NAME ="Output is deterministic" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Output is repeatable" VALUE ="Never"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="lkp_PAY_PERIOD" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Lookup Procedure" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="in_CURR_PP_FLAG" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_NUM" PICTURETEXT ="" PORTTYPE ="LOOKUP/OUTPUT" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="LOOKUP/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_START_DTE" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_DTE" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="LV_NUM" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="LV_YEAR" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PAY_DTE" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="CURR_PP_FLAG" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="1" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Lookup Sql Override" VALUE =""/>
<TABLEATTRIBUTE NAME ="Lookup table name" VALUE ="PAY_PERIOD"/>
<TABLEATTRIBUTE NAME ="Lookup Source Filter" VALUE =""/>
<TABLEATTRIBUTE NAME ="Lookup caching enabled" VALUE ="YES"/>
<TABLEATTRIBUTE NAME ="Lookup policy on multiple match" VALUE ="Use Any Value"/>
<TABLEATTRIBUTE NAME ="Lookup condition" VALUE ="CURR_PP_FLAG = in_CURR_PP_FLAG"/>
<TABLEATTRIBUTE NAME ="Connection Information" VALUE ="$Target"/>
<TABLEATTRIBUTE NAME ="Source Type" VALUE ="Database"/>
<TABLEATTRIBUTE NAME ="Recache if Stale" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
<TABLEATTRIBUTE NAME ="Lookup cache directory name" VALUE ="$PMCacheDir"/>
<TABLEATTRIBUTE NAME ="Lookup cache initialize" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Lookup cache persistent" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Lookup Data Cache Size" VALUE ="Auto"/>
<TABLEATTRIBUTE NAME ="Lookup Index Cache Size" VALUE ="Auto"/>
<TABLEATTRIBUTE NAME ="Dynamic Lookup Cache" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Synchronize Dynamic Cache" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Output Old Value On Update" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Update Dynamic Cache Condition" VALUE ="TRUE"/>
<TABLEATTRIBUTE NAME ="Cache File Name Prefix" VALUE =""/>
<TABLEATTRIBUTE NAME ="Re-cache from lookup source" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Insert Else Update" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Update Else Insert" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Datetime Format" VALUE =""/>
<TABLEATTRIBUTE NAME ="Thousand Separator" VALUE ="None"/>
<TABLEATTRIBUTE NAME ="Decimal Separator" VALUE ="."/>
<TABLEATTRIBUTE NAME ="Case Sensitive String Comparison" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Null ordering" VALUE ="Null Is Highest Value"/>
<TABLEATTRIBUTE NAME ="Sorted Input" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Lookup source is static" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Pre-build lookup cache" VALUE ="Auto"/>
<TABLEATTRIBUTE NAME ="Subsecond Precision" VALUE ="6"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="exp_Final_Message" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="SUBJECT" EXPRESSIONTYPE ="GENERAL" NAME ="SUBJECT" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="100" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="MESSAGE" EXPRESSIONTYPE ="GENERAL" NAME ="MESSAGE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="600" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<INSTANCE DESCRIPTION ="" NAME ="COUNTER_TBL" TRANSFORMATION_NAME ="COUNTER_TBL" TRANSFORMATION_TYPE ="Target Definition" TYPE ="TARGET"/>
<INSTANCE DESCRIPTION ="" NAME ="COMPTIME_MESSAGE_FILE" TRANSFORMATION_NAME ="COMPTIME_MESSAGE_FILE" TRANSFORMATION_TYPE ="Target Definition" TYPE ="TARGET"/>
<INSTANCE DESCRIPTION ="This transformation sets the mapping variables MAP_SUBJECT and MAP_MESSAGE using the counters and descriptions set in the previous expression transformation." NAME ="exp_Build_Message" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Build_Message" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="Filters Detail Records" NAME ="fil_Detail" REUSABLE ="NO" TRANSFORMATION_NAME ="fil_Detail" TRANSFORMATION_TYPE ="Filter" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="Determines Detail records to be used for further processing." NAME ="exp_Initial" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Initial" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="Performs a count on all Detail Records." NAME ="agg_ALL_RECORDS" REUSABLE ="NO" TRANSFORMATION_NAME ="agg_ALL_RECORDS" TRANSFORMATION_TYPE ="Aggregator" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="" NAME ="exp_Detail_Count" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Detail_Count" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="Compiles all the counter values." NAME ="exp_Counters" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Counters" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="" NAME ="exp_Final" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Final" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<INSTANCE DBDNAME ="FlatFile" DESCRIPTION ="" NAME ="U0287D01" TRANSFORMATION_NAME ="U0287D01" TRANSFORMATION_TYPE ="Source Definition" TYPE ="SOURCE"/>
<INSTANCE DESCRIPTION ="" NAME ="SQ_U0287D01" REUSABLE ="NO" TRANSFORMATION_NAME ="SQ_U0287D01" TRANSFORMATION_TYPE ="Source Qualifier" TYPE ="TRANSFORMATION">
<ASSOCIATED_SOURCE_INSTANCE NAME ="U0287D01"/>
</INSTANCE>
<INSTANCE DESCRIPTION ="" NAME ="lkp_PAY_PERIOD" REUSABLE ="NO" TRANSFORMATION_NAME ="lkp_PAY_PERIOD" TRANSFORMATION_TYPE ="Lookup Procedure" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="" NAME ="exp_Final_Message" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Final_Message" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<CONNECTOR FROMFIELD ="o_RUN_DATE" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="RUN_DATE" TOINSTANCE ="COUNTER_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="COUNTER_DESCRIPTION" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="COUNTER_DESCRIPTION" TOINSTANCE ="COUNTER_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="COUNTER_VALUE" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="COUNTER_VALUE" TOINSTANCE ="COUNTER_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="o_PROCESS_NAME" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="PROCESS_NAME" TOINSTANCE ="COUNTER_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="SUBJECT" FROMINSTANCE ="exp_Final_Message" FROMINSTANCETYPE ="Expression" TOFIELD ="SUBJECT" TOINSTANCE ="COMPTIME_MESSAGE_FILE" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="MESSAGE" FROMINSTANCE ="exp_Final_Message" FROMINSTANCETYPE ="Expression" TOFIELD ="MESSAGE" TOINSTANCE ="COMPTIME_MESSAGE_FILE" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="o_MESSAGE" FROMINSTANCE ="exp_Build_Message" FROMINSTANCETYPE ="Expression" TOFIELD ="MESSAGE" TOINSTANCE ="exp_Final_Message" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_SUBJECT" FROMINSTANCE ="exp_Build_Message" FROMINSTANCETYPE ="Expression" TOFIELD ="SUBJECT" TOINSTANCE ="exp_Final_Message" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_COUNTER_DESCRIPTION_1" FROMINSTANCE ="exp_Counters" FROMINSTANCETYPE ="Expression" TOFIELD ="COUNTER_DESCRIPTION_1" TOINSTANCE ="exp_Build_Message" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="DETAIL_RECORD_COUNT" FROMINSTANCE ="exp_Counters" FROMINSTANCETYPE ="Expression" TOFIELD ="COUNTER_1" TOINSTANCE ="exp_Build_Message" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="lkp_PP_NUM" FROMINSTANCE ="exp_Counters" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_NUM" TOINSTANCE ="exp_Build_Message" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="lkp_PP_END_YEAR" FROMINSTANCE ="exp_Counters" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_END_YEAR" TOINSTANCE ="exp_Build_Message" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="SSN" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="SSN" TOINSTANCE ="fil_Detail" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="o_RECORD_TYPE_FLAG" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="RECORD_TYPE_FLAG" TOINSTANCE ="fil_Detail" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="SSN" FROMINSTANCE ="fil_Detail" FROMINSTANCETYPE ="Filter" TOFIELD ="SSN" TOINSTANCE ="agg_ALL_RECORDS" TOINSTANCETYPE ="Aggregator"/>
<CONNECTOR FROMFIELD ="RECORD_TYPE_FLAG" FROMINSTANCE ="fil_Detail" FROMINSTANCETYPE ="Filter" TOFIELD ="RECORD_TYPE_FLAG" TOINSTANCE ="agg_ALL_RECORDS" TOINSTANCETYPE ="Aggregator"/>
<CONNECTOR FROMFIELD ="RECORD_TYPE" FROMINSTANCE ="fil_Detail" FROMINSTANCETYPE ="Filter" TOFIELD ="RECORD_TYPE" TOINSTANCE ="agg_ALL_RECORDS" TOINSTANCETYPE ="Aggregator"/>
<CONNECTOR FROMFIELD ="SSN" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="SSN" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="NAME" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="NAME" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_DETAIL_RECORD_COUNT" FROMINSTANCE ="agg_ALL_RECORDS" FROMINSTANCETYPE ="Aggregator" TOFIELD ="DETAIL_RECORD_COUNT" TOINSTANCE ="exp_Detail_Count" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="DETAIL_RECORD_COUNT" FROMINSTANCE ="exp_Detail_Count" FROMINSTANCETYPE ="Expression" TOFIELD ="DETAIL_RECORD_COUNT" TOINSTANCE ="exp_Counters" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_CURR_PP_FLAG" FROMINSTANCE ="exp_Detail_Count" FROMINSTANCETYPE ="Expression" TOFIELD ="in_CURR_PP_FLAG" TOINSTANCE ="lkp_PAY_PERIOD" TOINSTANCETYPE ="Lookup Procedure"/>
<CONNECTOR FROMFIELD ="PP_NUM" FROMINSTANCE ="lkp_PAY_PERIOD" FROMINSTANCETYPE ="Lookup Procedure" TOFIELD ="lkp_PP_NUM" TOINSTANCE ="exp_Counters" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="PP_END_YEAR" FROMINSTANCE ="lkp_PAY_PERIOD" FROMINSTANCETYPE ="Lookup Procedure" TOFIELD ="lkp_PP_END_YEAR" TOINSTANCE ="exp_Counters" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_COUNTER_DESCRIPTION_1" FROMINSTANCE ="exp_Counters" FROMINSTANCETYPE ="Expression" TOFIELD ="COUNTER_DESCRIPTION" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="DETAIL_RECORD_COUNT" FROMINSTANCE ="exp_Counters" FROMINSTANCETYPE ="Expression" TOFIELD ="COUNTER_VALUE" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="SSN" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="SSN" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="NAME" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="NAME" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="CURRENT_ACCT" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="CURRENT_ACCT" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="CURRENT_ORG" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="CURRENT_ORG" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="FLSA_STATUS" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="FLSA_STATUS" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="COMP_TIME_CUR_BAL" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="COMP_TIME_CUR_BAL" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="COMP_TIME_YEAR_EARNED" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="COMP_TIME_YEAR_EARNED" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="PP_END_DATE" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="PP_END_DATE" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="DAILY_DATE_EARNED" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="DAILY_DATE_EARNED" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="COMP_TIME_RATE" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="COMP_TIME_RATE" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="COMP_TIME_HOURS" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="COMP_TIME_HOURS" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="COMP_TIME_UNDEF" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="COMP_TIME_UNDEF" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<TARGETLOADORDER ORDER ="1" TARGETINSTANCE ="COUNTER_TBL"/>
<TARGETLOADORDER ORDER ="1" TARGETINSTANCE ="COMPTIME_MESSAGE_FILE"/>
<MAPPINGVARIABLE AGGFUNCTION ="MAX" DATATYPE ="string" DEFAULTVALUE ="0" DESCRIPTION ="" ISEXPRESSIONVARIABLE ="NO" ISPARAM ="NO" NAME ="$$MAP_MESSAGE" PRECISION ="300" SCALE ="0" USERDEFINED ="YES"/>
<MAPPINGVARIABLE AGGFUNCTION ="MAX" DATATYPE ="string" DEFAULTVALUE ="0" DESCRIPTION ="" ISEXPRESSIONVARIABLE ="NO" ISPARAM ="NO" NAME ="$$MAP_SUBJECT" PRECISION ="100" SCALE ="0" USERDEFINED ="YES"/>
<ERPINFO/>
</MAPPING>
<MAPPING DESCRIPTION ="" ISVALID ="YES" NAME ="m_COMPTIME_Load_COMP_TIME_DAILY_TBL" OBJECTVERSION ="1" VERSIONNUMBER ="1">
<TRANSFORMATION DESCRIPTION ="" NAME ="SQ_U0287D01" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Source Qualifier" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="SSN" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="9" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="NAME" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="30" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="CURRENT_ACCT" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="CURRENT_ORG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="7" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="FLSA_STATUS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="1" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_CUR_BAL" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_YEAR_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_DATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="DAILY_DATE_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_RATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_HOURS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_UNDEF" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Sql Query" VALUE =""/>
<TABLEATTRIBUTE NAME ="User Defined Join" VALUE =""/>
<TABLEATTRIBUTE NAME ="Source Filter" VALUE =""/>
<TABLEATTRIBUTE NAME ="Number Of Sorted Ports" VALUE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
<TABLEATTRIBUTE NAME ="Is Partitionable" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Pre SQL" VALUE =""/>
<TABLEATTRIBUTE NAME ="Post SQL" VALUE =""/>
<TABLEATTRIBUTE NAME ="Output is deterministic" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Output is repeatable" VALUE ="Never"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="exp_Initial" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="SSN" EXPRESSIONTYPE ="GENERAL" NAME ="SSN" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="9" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="NAME" EXPRESSIONTYPE ="GENERAL" NAME ="NAME" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="30" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="CURRENT_ACCT" EXPRESSIONTYPE ="GENERAL" NAME ="CURRENT_ACCT" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="CURRENT_ORG" EXPRESSIONTYPE ="GENERAL" NAME ="CURRENT_ORG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="7" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="FLSA_STATUS" EXPRESSIONTYPE ="GENERAL" NAME ="FLSA_STATUS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="1" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_CUR_BAL" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_CUR_BAL" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_YEAR_EARNED" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_YEAR_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="PP_END_DATE" EXPRESSIONTYPE ="GENERAL" NAME ="PP_END_DATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="DAILY_DATE_EARNED" EXPRESSIONTYPE ="GENERAL" NAME ="DAILY_DATE_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_RATE" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_RATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_HOURS" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_HOURS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_UNDEF" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_UNDEF" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="'Y'" EXPRESSIONTYPE ="GENERAL" NAME ="o_CURR_PP_FLAG" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="1" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="integer" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="DECODE (TRUE, IS_NUMBER(SSN), 1,
 0)
 " EXPRESSIONTYPE ="GENERAL" NAME ="o_VALID_RECORD_FLAG" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="10" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="exp_Final" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="PP_END_YEAR" EXPRESSIONTYPE ="GENERAL" NAME ="PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="PP_NUM" EXPRESSIONTYPE ="GENERAL" NAME ="PP_NUM" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="PP_YEAR_NUM" EXPRESSIONTYPE ="GENERAL" NAME ="PP_YEAR_NUM" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="SSN" EXPRESSIONTYPE ="GENERAL" NAME ="SSN" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="9" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="NAME" EXPRESSIONTYPE ="GENERAL" NAME ="NAME" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="30" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="CURRENT_ACCT" EXPRESSIONTYPE ="GENERAL" NAME ="CURRENT_ACCT" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="CURRENT_ORG" EXPRESSIONTYPE ="GENERAL" NAME ="CURRENT_ORG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="7" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="FLSA_STATUS" EXPRESSIONTYPE ="GENERAL" NAME ="FLSA_STATUS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="1" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_CUR_BAL" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_CUR_BAL" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_YEAR_EARNED" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_YEAR_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="PP_END_DATE" EXPRESSIONTYPE ="GENERAL" NAME ="PP_END_DATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="DAILY_DATE_EARNED" EXPRESSIONTYPE ="GENERAL" NAME ="DAILY_DATE_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_RATE" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_RATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_HOURS" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_HOURS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_UNDEF" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_UNDEF" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="lkp_PAY_PERIOD" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Lookup Procedure" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="in_CURR_PP_FLAG" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="1" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_NUM" PICTURETEXT ="" PORTTYPE ="LOOKUP/OUTPUT" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="LOOKUP/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_START_DTE" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_DTE" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="LV_NUM" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="LV_YEAR" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PAY_DTE" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="CURR_PP_FLAG" PICTURETEXT ="" PORTTYPE ="LOOKUP" PRECISION ="1" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Lookup Sql Override" VALUE =""/>
<TABLEATTRIBUTE NAME ="Lookup table name" VALUE ="PAY_PERIOD"/>
<TABLEATTRIBUTE NAME ="Lookup Source Filter" VALUE =""/>
<TABLEATTRIBUTE NAME ="Lookup caching enabled" VALUE ="YES"/>
<TABLEATTRIBUTE NAME ="Lookup policy on multiple match" VALUE ="Use Any Value"/>
<TABLEATTRIBUTE NAME ="Lookup condition" VALUE ="CURR_PP_FLAG = in_CURR_PP_FLAG"/>
<TABLEATTRIBUTE NAME ="Connection Information" VALUE ="$Target"/>
<TABLEATTRIBUTE NAME ="Source Type" VALUE ="Database"/>
<TABLEATTRIBUTE NAME ="Recache if Stale" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
<TABLEATTRIBUTE NAME ="Lookup cache directory name" VALUE ="$PMCacheDir"/>
<TABLEATTRIBUTE NAME ="Lookup cache initialize" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Lookup cache persistent" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Lookup Data Cache Size" VALUE ="Auto"/>
<TABLEATTRIBUTE NAME ="Lookup Index Cache Size" VALUE ="Auto"/>
<TABLEATTRIBUTE NAME ="Dynamic Lookup Cache" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Synchronize Dynamic Cache" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Output Old Value On Update" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Update Dynamic Cache Condition" VALUE ="TRUE"/>
<TABLEATTRIBUTE NAME ="Cache File Name Prefix" VALUE =""/>
<TABLEATTRIBUTE NAME ="Re-cache from lookup source" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Insert Else Update" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Update Else Insert" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Datetime Format" VALUE =""/>
<TABLEATTRIBUTE NAME ="Thousand Separator" VALUE ="None"/>
<TABLEATTRIBUTE NAME ="Decimal Separator" VALUE ="."/>
<TABLEATTRIBUTE NAME ="Case Sensitive String Comparison" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Null ordering" VALUE ="Null Is Highest Value"/>
<TABLEATTRIBUTE NAME ="Sorted Input" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Lookup source is static" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Pre-build lookup cache" VALUE ="Auto"/>
<TABLEATTRIBUTE NAME ="Subsecond Precision" VALUE ="6"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="exp_Convert" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="SSN" EXPRESSIONTYPE ="GENERAL" NAME ="SSN" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="9" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="NAME" EXPRESSIONTYPE ="GENERAL" NAME ="NAME" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="30" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="CURRENT_ACCT" EXPRESSIONTYPE ="GENERAL" NAME ="CURRENT_ACCT" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="CURRENT_ORG" EXPRESSIONTYPE ="GENERAL" NAME ="CURRENT_ORG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="7" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="FLSA_STATUS" EXPRESSIONTYPE ="GENERAL" NAME ="FLSA_STATUS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="1" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_CUR_BAL" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_CUR_BAL" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_YEAR_EARNED" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_YEAR_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_DATE" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="8" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="IIF(IS_DATE(PP_END_DATE, 'YYYYMMDD'),
 TO_DATE(PP_END_DATE, 'YYYYMMDD')
 )" EXPRESSIONTYPE ="GENERAL" NAME ="o_PP_END_DATE" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="DAILY_DATE_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="8" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="IIF(IS_DATE(DAILY_DATE_EARNED, 'YYYYMMDD'),
 TO_DATE(DAILY_DATE_EARNED, 'YYYYMMDD')
 )" EXPRESSIONTYPE ="GENERAL" NAME ="o_DAILY_DATE_EARNED" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_RATE" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_RATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_HOURS" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_HOURS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="COMP_TIME_UNDEF" EXPRESSIONTYPE ="GENERAL" NAME ="COMP_TIME_UNDEF" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="lkp_PP_NUM" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="lkp_PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="lkp_PP_END_YEAR
" EXPRESSIONTYPE ="GENERAL" NAME ="o_PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="lkp_PP_NUM
" EXPRESSIONTYPE ="GENERAL" NAME ="o_PP_NUM" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="TO_DECIMAL(
TO_CHAR(lkp_PP_END_YEAR) || 
LPAD(TO_CHAR(lkp_PP_NUM), 2, '0'))
" EXPRESSIONTYPE ="GENERAL" NAME ="o_PP_YEAR_NUM" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="6" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="fil_Valid_Records" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Filter" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="SSN" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="9" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="NAME" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="30" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="CURRENT_ACCT" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="CURRENT_ORG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="7" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="FLSA_STATUS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="1" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_CUR_BAL" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_YEAR_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_DATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="DAILY_DATE_EARNED" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_RATE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_HOURS" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="8" SCALE ="2"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="COMP_TIME_UNDEF" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="CURR_PP_FLAG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="1" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="VALID_RECORD_FLAG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="10" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Filter Condition" VALUE ="VALID_RECORD_FLAG = TRUE"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<INSTANCE DESCRIPTION ="" NAME ="COMP_TIME_DAILY_TBL" TRANSFORMATION_NAME ="COMP_TIME_DAILY_TBL" TRANSFORMATION_TYPE ="Target Definition" TYPE ="TARGET"/>
<INSTANCE DBDNAME ="FlatFile" DESCRIPTION ="" NAME ="U0287D01" TRANSFORMATION_NAME ="U0287D01" TRANSFORMATION_TYPE ="Source Definition" TYPE ="SOURCE"/>
<INSTANCE DESCRIPTION ="" NAME ="SQ_U0287D01" REUSABLE ="NO" TRANSFORMATION_NAME ="SQ_U0287D01" TRANSFORMATION_TYPE ="Source Qualifier" TYPE ="TRANSFORMATION">
<ASSOCIATED_SOURCE_INSTANCE NAME ="U0287D01"/>
</INSTANCE>
<INSTANCE DESCRIPTION ="" NAME ="exp_Initial" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Initial" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="" NAME ="exp_Final" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Final" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="" NAME ="lkp_PAY_PERIOD" REUSABLE ="NO" TRANSFORMATION_NAME ="lkp_PAY_PERIOD" TRANSFORMATION_TYPE ="Lookup Procedure" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="" NAME ="exp_Convert" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Convert" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="" NAME ="fil_Valid_Records" REUSABLE ="NO" TRANSFORMATION_NAME ="fil_Valid_Records" TRANSFORMATION_TYPE ="Filter" TYPE ="TRANSFORMATION"/>
<CONNECTOR FROMFIELD ="COMP_TIME_RATE" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_RATE" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="COMP_TIME_HOURS" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_HOURS" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="COMP_TIME_UNDEF" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_UNDEF" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="PP_END_YEAR" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_END_YEAR" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="PP_NUM" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_NUM" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="PP_YEAR_NUM" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_YEAR_NUM" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="SSN" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="SSN" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="NAME" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="NAME" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="CURRENT_ACCT" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="CURRENT_ACCT" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="CURRENT_ORG" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="CURRENT_ORG" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="FLSA_STATUS" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="FLSA_STATUS" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="COMP_TIME_CUR_BAL" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_CUR_BAL" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="COMP_TIME_YEAR_EARNED" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_YEAR_EARNED" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="PP_END_DATE" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_END_DATE" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="DAILY_DATE_EARNED" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="DAILY_DATE_EARNED" TOINSTANCE ="COMP_TIME_DAILY_TBL" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="SSN" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="SSN" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="NAME" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="NAME" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="CURRENT_ACCT" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="CURRENT_ACCT" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="CURRENT_ORG" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="CURRENT_ORG" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="FLSA_STATUS" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="FLSA_STATUS" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="COMP_TIME_CUR_BAL" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="COMP_TIME_CUR_BAL" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="COMP_TIME_YEAR_EARNED" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="COMP_TIME_YEAR_EARNED" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="PP_END_DATE" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="PP_END_DATE" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="DAILY_DATE_EARNED" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="DAILY_DATE_EARNED" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="COMP_TIME_RATE" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="COMP_TIME_RATE" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="COMP_TIME_HOURS" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="COMP_TIME_HOURS" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="COMP_TIME_UNDEF" FROMINSTANCE ="U0287D01" FROMINSTANCETYPE ="Source Definition" TOFIELD ="COMP_TIME_UNDEF" TOINSTANCE ="SQ_U0287D01" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="SSN" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="SSN" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="NAME" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="NAME" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="CURRENT_ACCT" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="CURRENT_ACCT" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="CURRENT_ORG" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="CURRENT_ORG" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="FLSA_STATUS" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="FLSA_STATUS" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_CUR_BAL" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="COMP_TIME_CUR_BAL" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_YEAR_EARNED" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="COMP_TIME_YEAR_EARNED" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="PP_END_DATE" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="PP_END_DATE" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="DAILY_DATE_EARNED" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="DAILY_DATE_EARNED" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_RATE" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="COMP_TIME_RATE" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_HOURS" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="COMP_TIME_HOURS" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_UNDEF" FROMINSTANCE ="SQ_U0287D01" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="COMP_TIME_UNDEF" TOINSTANCE ="exp_Initial" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="SSN" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="SSN" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="NAME" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="NAME" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="CURRENT_ACCT" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="CURRENT_ACCT" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="CURRENT_ORG" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="CURRENT_ORG" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="FLSA_STATUS" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="FLSA_STATUS" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="COMP_TIME_CUR_BAL" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_CUR_BAL" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="COMP_TIME_YEAR_EARNED" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_YEAR_EARNED" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="PP_END_DATE" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_END_DATE" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="DAILY_DATE_EARNED" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="DAILY_DATE_EARNED" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="COMP_TIME_RATE" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_RATE" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="COMP_TIME_HOURS" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_HOURS" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="COMP_TIME_UNDEF" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_UNDEF" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="o_CURR_PP_FLAG" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="CURR_PP_FLAG" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="o_VALID_RECORD_FLAG" FROMINSTANCE ="exp_Initial" FROMINSTANCETYPE ="Expression" TOFIELD ="VALID_RECORD_FLAG" TOINSTANCE ="fil_Valid_Records" TOINSTANCETYPE ="Filter"/>
<CONNECTOR FROMFIELD ="o_PP_END_YEAR" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_END_YEAR" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_PP_NUM" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_NUM" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_PP_YEAR_NUM" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_YEAR_NUM" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="SSN" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="SSN" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="NAME" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="NAME" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="CURRENT_ACCT" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="CURRENT_ACCT" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="CURRENT_ORG" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="CURRENT_ORG" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="FLSA_STATUS" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="FLSA_STATUS" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_CUR_BAL" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_CUR_BAL" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_YEAR_EARNED" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_YEAR_EARNED" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_PP_END_DATE" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_END_DATE" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_DAILY_DATE_EARNED" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="DAILY_DATE_EARNED" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_RATE" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_RATE" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_HOURS" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_HOURS" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_UNDEF" FROMINSTANCE ="exp_Convert" FROMINSTANCETYPE ="Expression" TOFIELD ="COMP_TIME_UNDEF" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="CURR_PP_FLAG" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="in_CURR_PP_FLAG" TOINSTANCE ="lkp_PAY_PERIOD" TOINSTANCETYPE ="Lookup Procedure"/>
<CONNECTOR FROMFIELD ="PP_NUM" FROMINSTANCE ="lkp_PAY_PERIOD" FROMINSTANCETYPE ="Lookup Procedure" TOFIELD ="lkp_PP_NUM" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="PP_END_YEAR" FROMINSTANCE ="lkp_PAY_PERIOD" FROMINSTANCETYPE ="Lookup Procedure" TOFIELD ="lkp_PP_END_YEAR" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_YEAR_EARNED" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="COMP_TIME_YEAR_EARNED" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="PP_END_DATE" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="PP_END_DATE" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="DAILY_DATE_EARNED" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="DAILY_DATE_EARNED" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_RATE" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="COMP_TIME_RATE" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_HOURS" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="COMP_TIME_HOURS" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_UNDEF" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="COMP_TIME_UNDEF" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="SSN" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="SSN" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="NAME" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="NAME" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="CURRENT_ACCT" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="CURRENT_ACCT" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="CURRENT_ORG" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="CURRENT_ORG" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="FLSA_STATUS" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="FLSA_STATUS" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="COMP_TIME_CUR_BAL" FROMINSTANCE ="fil_Valid_Records" FROMINSTANCETYPE ="Filter" TOFIELD ="COMP_TIME_CUR_BAL" TOINSTANCE ="exp_Convert" TOINSTANCETYPE ="Expression"/>
<TARGETLOADORDER ORDER ="1" TARGETINSTANCE ="COMP_TIME_DAILY_TBL"/>
<ERPINFO/>
</MAPPING>
<MAPPING DESCRIPTION ="This mapping returns the Current Pay Period from the Pay Period table." ISVALID ="YES" NAME ="m_COMPTIME_Current_Pay_Period" OBJECTVERSION ="1" VERSIONNUMBER ="1">
<TRANSFORMATION DESCRIPTION ="" NAME ="SQ_PAY_PERIOD" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Source Qualifier" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_NUM" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_START_DTE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_DTE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="LV_NUM" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="LV_YEAR" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PAY_DTE" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="29" SCALE ="9"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="CURR_PP_FLAG" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="1" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Sql Query" VALUE =""/>
<TABLEATTRIBUTE NAME ="User Defined Join" VALUE =""/>
<TABLEATTRIBUTE NAME ="Source Filter" VALUE ="CURR_PP_FLAG = 'Y'"/>
<TABLEATTRIBUTE NAME ="Number Of Sorted Ports" VALUE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
<TABLEATTRIBUTE NAME ="Select Distinct" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Is Partitionable" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Pre SQL" VALUE =""/>
<TABLEATTRIBUTE NAME ="Post SQL" VALUE =""/>
<TABLEATTRIBUTE NAME ="Output is deterministic" VALUE ="NO"/>
<TABLEATTRIBUTE NAME ="Output is repeatable" VALUE ="Never"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="This transformation combines the Current Pay Period and Current year into one string." NAME ="exp_Build_Pay_Period" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_NUM" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="4" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="IIF(PP_NUM < 10,
 LPAD(TO_CHAR(PP_NUM), 2, '0'),
 TO_CHAR(PP_NUM)
)" EXPRESSIONTYPE ="GENERAL" NAME ="v_PP_NUM" PICTURETEXT ="" PORTTYPE ="LOCAL VARIABLE" PRECISION ="2" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="TO_CHAR(PP_END_YEAR) || v_PP_NUM" EXPRESSIONTYPE ="GENERAL" NAME ="o_PAY_PERIOD" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="TO_CHAR(PP_END_YEAR) || v_PP_NUM" EXPRESSIONTYPE ="GENERAL" NAME ="v_PAY_PERIOD" PICTURETEXT ="" PORTTYPE ="LOCAL VARIABLE" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="SETVARIABLE($$MAP_PP_YEAR_NUM, v_PAY_PERIOD)" EXPRESSIONTYPE ="GENERAL" NAME ="o_MAP_PP_YEAR_NUM" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="integer" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="SETVARIABLE($$MAP_PP_END_YEAR, PP_END_YEAR)" EXPRESSIONTYPE ="GENERAL" NAME ="o_PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="integer" DEFAULTVALUE ="ERROR('transformation error')" DESCRIPTION ="" EXPRESSION ="SETVARIABLE($$MAP_PP_NUM, PP_NUM)" EXPRESSIONTYPE ="GENERAL" NAME ="o_PP_NUM" PICTURETEXT ="" PORTTYPE ="OUTPUT" PRECISION ="10" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<TRANSFORMATION DESCRIPTION ="" NAME ="exp_Final" OBJECTVERSION ="1" REUSABLE ="NO" TYPE ="Expression" VERSIONNUMBER ="1">
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" EXPRESSION ="PAY_PERIOD" EXPRESSIONTYPE ="GENERAL" NAME ="PAY_PERIOD" PICTURETEXT ="" PORTTYPE ="INPUT/OUTPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="MAP_PP_YEAR_NUM" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="6" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_END_YEAR" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="10" SCALE ="0"/>
<TRANSFORMFIELD DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="PP_NUM" PICTURETEXT ="" PORTTYPE ="INPUT" PRECISION ="10" SCALE ="0"/>
<TABLEATTRIBUTE NAME ="Tracing Level" VALUE ="Normal"/>
</TRANSFORMATION>
<INSTANCE DESCRIPTION ="" NAME ="COMP_TIME_DATE_FILE" TRANSFORMATION_NAME ="COMP_TIME_DATE_FILE" TRANSFORMATION_TYPE ="Target Definition" TYPE ="TARGET"/>
<INSTANCE DBDNAME ="ORA_BIIS" DESCRIPTION ="" NAME ="PAY_PERIOD" TRANSFORMATION_NAME ="PAY_PERIOD" TRANSFORMATION_TYPE ="Source Definition" TYPE ="SOURCE"/>
<INSTANCE DESCRIPTION ="" NAME ="SQ_PAY_PERIOD" REUSABLE ="NO" TRANSFORMATION_NAME ="SQ_PAY_PERIOD" TRANSFORMATION_TYPE ="Source Qualifier" TYPE ="TRANSFORMATION">
<ASSOCIATED_SOURCE_INSTANCE NAME ="PAY_PERIOD"/>
</INSTANCE>
<INSTANCE DESCRIPTION ="This transformation combines the Current Pay Period and Current year into one string." NAME ="exp_Build_Pay_Period" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Build_Pay_Period" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<INSTANCE DESCRIPTION ="" NAME ="exp_Final" REUSABLE ="NO" TRANSFORMATION_NAME ="exp_Final" TRANSFORMATION_TYPE ="Expression" TYPE ="TRANSFORMATION"/>
<CONNECTOR FROMFIELD ="PAY_PERIOD" FROMINSTANCE ="exp_Final" FROMINSTANCETYPE ="Expression" TOFIELD ="PAY_PERIOD" TOINSTANCE ="COMP_TIME_DATE_FILE" TOINSTANCETYPE ="Target Definition"/>
<CONNECTOR FROMFIELD ="PP_NUM" FROMINSTANCE ="PAY_PERIOD" FROMINSTANCETYPE ="Source Definition" TOFIELD ="PP_NUM" TOINSTANCE ="SQ_PAY_PERIOD" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="PP_END_YEAR" FROMINSTANCE ="PAY_PERIOD" FROMINSTANCETYPE ="Source Definition" TOFIELD ="PP_END_YEAR" TOINSTANCE ="SQ_PAY_PERIOD" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="PP_START_DTE" FROMINSTANCE ="PAY_PERIOD" FROMINSTANCETYPE ="Source Definition" TOFIELD ="PP_START_DTE" TOINSTANCE ="SQ_PAY_PERIOD" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="PP_END_DTE" FROMINSTANCE ="PAY_PERIOD" FROMINSTANCETYPE ="Source Definition" TOFIELD ="PP_END_DTE" TOINSTANCE ="SQ_PAY_PERIOD" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="LV_NUM" FROMINSTANCE ="PAY_PERIOD" FROMINSTANCETYPE ="Source Definition" TOFIELD ="LV_NUM" TOINSTANCE ="SQ_PAY_PERIOD" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="LV_YEAR" FROMINSTANCE ="PAY_PERIOD" FROMINSTANCETYPE ="Source Definition" TOFIELD ="LV_YEAR" TOINSTANCE ="SQ_PAY_PERIOD" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="PAY_DTE" FROMINSTANCE ="PAY_PERIOD" FROMINSTANCETYPE ="Source Definition" TOFIELD ="PAY_DTE" TOINSTANCE ="SQ_PAY_PERIOD" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="CURR_PP_FLAG" FROMINSTANCE ="PAY_PERIOD" FROMINSTANCETYPE ="Source Definition" TOFIELD ="CURR_PP_FLAG" TOINSTANCE ="SQ_PAY_PERIOD" TOINSTANCETYPE ="Source Qualifier"/>
<CONNECTOR FROMFIELD ="PP_NUM" FROMINSTANCE ="SQ_PAY_PERIOD" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="PP_NUM" TOINSTANCE ="exp_Build_Pay_Period" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="PP_END_YEAR" FROMINSTANCE ="SQ_PAY_PERIOD" FROMINSTANCETYPE ="Source Qualifier" TOFIELD ="PP_END_YEAR" TOINSTANCE ="exp_Build_Pay_Period" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_PAY_PERIOD" FROMINSTANCE ="exp_Build_Pay_Period" FROMINSTANCETYPE ="Expression" TOFIELD ="PAY_PERIOD" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_MAP_PP_YEAR_NUM" FROMINSTANCE ="exp_Build_Pay_Period" FROMINSTANCETYPE ="Expression" TOFIELD ="MAP_PP_YEAR_NUM" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_PP_END_YEAR" FROMINSTANCE ="exp_Build_Pay_Period" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_END_YEAR" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<CONNECTOR FROMFIELD ="o_PP_NUM" FROMINSTANCE ="exp_Build_Pay_Period" FROMINSTANCETYPE ="Expression" TOFIELD ="PP_NUM" TOINSTANCE ="exp_Final" TOINSTANCETYPE ="Expression"/>
<TARGETLOADORDER ORDER ="1" TARGETINSTANCE ="COMP_TIME_DATE_FILE"/>
<MAPPINGVARIABLE AGGFUNCTION ="MAX" DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="" ISEXPRESSIONVARIABLE ="NO" ISPARAM ="NO" NAME ="$$MAP_PP_YEAR_NUM" PRECISION ="6" SCALE ="0" USERDEFINED ="YES"/>
<MAPPINGVARIABLE AGGFUNCTION ="MAX" DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="" ISEXPRESSIONVARIABLE ="NO" ISPARAM ="NO" NAME ="$$MAP_PP_END_YEAR" PRECISION ="10" SCALE ="0" USERDEFINED ="YES"/>
<MAPPINGVARIABLE AGGFUNCTION ="MAX" DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="" ISEXPRESSIONVARIABLE ="NO" ISPARAM ="NO" NAME ="$$MAP_PP_NUM" PRECISION ="10" SCALE ="0" USERDEFINED ="YES"/>
<ERPINFO/>
</MAPPING>
<CONFIG DESCRIPTION ="Default session configuration object" ISDEFAULT ="YES" NAME ="default_session_config" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Advanced" VALUE =""/>
<ATTRIBUTE NAME ="Constraint based load ordering" VALUE ="NO"/>
<ATTRIBUTE NAME ="Cache LOOKUP() function" VALUE ="YES"/>
<ATTRIBUTE NAME ="Default buffer block size" VALUE ="Auto"/>
<ATTRIBUTE NAME ="Line Sequential buffer length" VALUE ="1024"/>
<ATTRIBUTE NAME ="Maximum Memory Allowed For Auto Memory Attributes" VALUE ="512MB"/>
<ATTRIBUTE NAME ="Maximum Percentage of Total Memory Allowed For Auto Memory Attributes" VALUE ="5"/>
<ATTRIBUTE NAME ="Additional Concurrent Pipelines for Lookup Cache Creation" VALUE ="Auto"/>
<ATTRIBUTE NAME ="Custom Properties" VALUE =""/>
<ATTRIBUTE NAME ="Pre-build lookup cache" VALUE ="Auto"/>
<ATTRIBUTE NAME ="Optimization Level" VALUE ="Medium"/>
<ATTRIBUTE NAME ="DateTime Format String" VALUE ="MM/DD/YYYY HH24:MI:SS.US"/>
<ATTRIBUTE NAME ="Pre 85 Timestamp Compatibility" VALUE ="NO"/>
<ATTRIBUTE NAME ="Log Options" VALUE ="0"/>
<ATTRIBUTE NAME ="Save session log by" VALUE ="Session runs"/>
<ATTRIBUTE NAME ="Save session log for these runs" VALUE ="0"/>
<ATTRIBUTE NAME ="Session Log File Max Size" VALUE ="0"/>
<ATTRIBUTE NAME ="Session Log File Max Time Period" VALUE ="0"/>
<ATTRIBUTE NAME ="Maximum Partial Session Log Files" VALUE ="1"/>
<ATTRIBUTE NAME ="Writer Commit Statistics Log Frequency" VALUE ="1"/>
<ATTRIBUTE NAME ="Writer Commit Statistics Log Interval" VALUE ="0"/>
<ATTRIBUTE NAME ="Error handling" VALUE =""/>
<ATTRIBUTE NAME ="Stop on errors" VALUE ="0"/>
<ATTRIBUTE NAME ="Override tracing" VALUE ="None"/>
<ATTRIBUTE NAME ="On Stored Procedure error" VALUE ="Stop"/>
<ATTRIBUTE NAME ="On Pre-session command task error" VALUE ="Stop"/>
<ATTRIBUTE NAME ="On Pre-Post SQL error" VALUE ="Stop"/>
<ATTRIBUTE NAME ="Enable Recovery" VALUE ="NO"/>
<ATTRIBUTE NAME ="Error Log Type" VALUE ="None"/>
<ATTRIBUTE NAME ="Error Log Table Name Prefix" VALUE =""/>
<ATTRIBUTE NAME ="Error Log File Name" VALUE ="PMError.log"/>
<ATTRIBUTE NAME ="Log Source Row Data" VALUE ="NO"/>
<ATTRIBUTE NAME ="Data Column Delimiter" VALUE ="|"/>
<ATTRIBUTE NAME ="Partitioning Options" VALUE =""/>
<ATTRIBUTE NAME ="Dynamic Partitioning" VALUE ="Disabled"/>
<ATTRIBUTE NAME ="Number of Partitions" VALUE ="1"/>
<ATTRIBUTE NAME ="Multiplication Factor" VALUE ="Auto"/>
<ATTRIBUTE NAME ="Session on Grid" VALUE =""/>
<ATTRIBUTE NAME ="Is Enabled" VALUE ="NO"/>
</CONFIG>
<WORKFLOW DESCRIPTION ="" ISENABLED ="YES" ISRUNNABLESERVICE ="NO" ISSERVICE ="NO" ISVALID ="YES" NAME ="wf_COMPTIME" REUSABLE_SCHEDULER ="NO" SCHEDULERNAME ="Scheduler" SERVERNAME ="Test_IS" SERVER_DOMAINNAME ="Dom_dev" SUSPEND_ON_ERROR ="NO" TASKS_MUST_RUN_ON_SERVER ="NO" VERSIONNUMBER ="1">
<SCHEDULER DESCRIPTION ="" NAME ="Scheduler" REUSABLE ="NO" VERSIONNUMBER ="1">
<SCHEDULEINFO SCHEDULETYPE ="ONDEMAND"/>
</SCHEDULER>
<TASK DESCRIPTION ="" NAME ="Start" REUSABLE ="NO" TYPE ="Start" VERSIONNUMBER ="1"/>
<TASK DESCRIPTION ="" NAME ="email_COMPTIME_Complete" REUSABLE ="NO" TYPE ="Email" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Email User Name" VALUE ="$$WF_COMPTIME_EMAIL_LIST"/>
<ATTRIBUTE NAME ="Email Subject" VALUE ="$$WF_SUBJECT"/>
<ATTRIBUTE NAME ="Email Text" VALUE ="$$WF_MESSAGE"/>
</TASK>
<SESSION DESCRIPTION ="" ISVALID ="YES" MAPPINGNAME ="m_COMPTIME_Current_Pay_Period" NAME ="s_COMPTIME_Current_Pay_Period" REUSABLE ="NO" SORTORDER ="Binary" VERSIONNUMBER ="1">
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="0" SINSTANCENAME ="PAY_PERIOD" STAGE ="0" TRANSFORMATIONNAME ="PAY_PERIOD" TRANSFORMATIONTYPE ="Source Definition"/>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="YES" PARTITIONTYPE ="PASS THROUGH" PIPELINE ="1" SINSTANCENAME ="SQ_PAY_PERIOD" STAGE ="2" TRANSFORMATIONNAME ="SQ_PAY_PERIOD" TRANSFORMATIONTYPE ="Source Qualifier"/>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Build_Pay_Period" STAGE ="2" TRANSFORMATIONNAME ="exp_Build_Pay_Period" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Final" STAGE ="2" TRANSFORMATIONNAME ="exp_Final" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="YES" PARTITIONTYPE ="PASS THROUGH" PIPELINE ="1" SINSTANCENAME ="COMP_TIME_DATE_FILE" STAGE ="3" TRANSFORMATIONNAME ="COMP_TIME_DATE_FILE" TRANSFORMATIONTYPE ="Target Definition">
<FLATFILE CODEPAGE ="MS1252" CONSECDELIMITERSASONE ="NO" DELIMITED ="NO" DELIMITERS ="," ESCAPE_CHARACTER ="" KEEPESCAPECHAR ="NO" LINESEQUENTIAL ="NO" MULTIDELIMITERSASAND ="NO" NULLCHARTYPE ="ASCII" NULL_CHARACTER ="*" PADBYTES ="1" QUOTE_CHARACTER ="NONE" REPEATABLE ="NO" ROWDELIMITER ="0" SKIPROWS ="0" STRIPTRAILINGBLANKS ="NO"/>
</SESSTRANSFORMATIONINST>
<CONFIGREFERENCE REFOBJECTNAME ="default_session_config" TYPE ="Session config"/>
<SESSIONCOMPONENT REFOBJECTNAME ="presession_variable_assignment" REUSABLE ="NO" TYPE ="Pre-session variable assignment">
<TASK DESCRIPTION ="" NAME ="presession_variable_assignment" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Fail task if any command fails" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
</TASK>
<VALUEPAIR EXECORDER ="1" NAME ="$$MAP_PP_END_YEAR" REVERSEASSIGNMENT ="NO" VALUE ="$$WF_PP_END_YEAR"/>
<VALUEPAIR EXECORDER ="2" NAME ="$$MAP_PP_NUM" REVERSEASSIGNMENT ="NO" VALUE ="$$WF_PP_NUM"/>
<VALUEPAIR EXECORDER ="3" NAME ="$$MAP_PP_YEAR_NUM" REVERSEASSIGNMENT ="NO" VALUE ="$$WF_PP_YEAR_NUM"/>
</SESSIONCOMPONENT>
<SESSIONCOMPONENT REFOBJECTNAME ="postsession_success_variable_assignment" REUSABLE ="NO" TYPE ="Post-session success variable assignment">
<TASK DESCRIPTION ="" NAME ="postsession_success_variable_assignment" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Fail task if any command fails" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
</TASK>
<VALUEPAIR EXECORDER ="1" NAME ="$$WF_PP_END_YEAR" REVERSEASSIGNMENT ="NO" VALUE ="$$MAP_PP_END_YEAR"/>
<VALUEPAIR EXECORDER ="2" NAME ="$$WF_PP_NUM" REVERSEASSIGNMENT ="NO" VALUE ="$$MAP_PP_NUM"/>
<VALUEPAIR EXECORDER ="3" NAME ="$$WF_PP_YEAR_NUM" REVERSEASSIGNMENT ="NO" VALUE ="$$MAP_PP_YEAR_NUM"/>
</SESSIONCOMPONENT>
<SESSIONCOMPONENT REFOBJECTNAME ="postsession_failure_variable_assignment" REUSABLE ="NO" TYPE ="Post-session failure variable assignment">
<TASK DESCRIPTION ="" NAME ="postsession_failure_variable_assignment" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Fail task if any command fails" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
</TASK>
</SESSIONCOMPONENT>
<SESSIONEXTENSION DSQINSTNAME ="SQ_PAY_PERIOD" DSQINSTTYPE ="Source Qualifier" NAME ="Relational Reader" SINSTANCENAME ="PAY_PERIOD" SUBTYPE ="Relational Reader" TRANSFORMATIONTYPE ="Source Definition" TYPE ="READER"/>
<SESSIONEXTENSION NAME ="Relational Reader" SINSTANCENAME ="SQ_PAY_PERIOD" SUBTYPE ="Relational Reader" TRANSFORMATIONTYPE ="Source Qualifier" TYPE ="READER">
<CONNECTIONREFERENCE CNXREFNAME ="DB Connection" CONNECTIONNAME ="INFO_TARGET" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="Oracle" CONNECTIONTYPE ="Relational" VARIABLE =""/>
</SESSIONEXTENSION>
<SESSIONEXTENSION NAME ="File Writer" SINSTANCENAME ="COMP_TIME_DATE_FILE" SUBTYPE ="File Writer" TRANSFORMATIONTYPE ="Target Definition" TYPE ="WRITER">
<CONNECTIONREFERENCE CNXREFNAME ="Connection" CONNECTIONNAME ="" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="" CONNECTIONTYPE ="" VARIABLE =""/>
<ATTRIBUTE NAME ="Merge Type" VALUE ="No Merge"/>
<ATTRIBUTE NAME ="Merge File Directory" VALUE ="$PMTargetFileDir\"/>
<ATTRIBUTE NAME ="Merge File Name" VALUE ="comp_time_date_file.out"/>
<ATTRIBUTE NAME ="Append if Exists" VALUE ="NO"/>
<ATTRIBUTE NAME ="Create Target Directory" VALUE ="NO"/>
<ATTRIBUTE NAME ="Header Options" VALUE ="No Header"/>
<ATTRIBUTE NAME ="Header Command" VALUE =""/>
<ATTRIBUTE NAME ="Footer Command" VALUE =""/>
<ATTRIBUTE NAME ="Output Type" VALUE ="File"/>
<ATTRIBUTE NAME ="Merge Command" VALUE =""/>
<ATTRIBUTE NAME ="Output file directory" VALUE ="$PMTargetFileDir\"/>
<ATTRIBUTE NAME ="Output filename" VALUE ="comp_time_date_file.txt"/>
<ATTRIBUTE NAME ="Reject file directory" VALUE ="$PMBadFileDir\"/>
<ATTRIBUTE NAME ="Reject filename" VALUE ="comp_time_date_file1.bad"/>
<ATTRIBUTE NAME ="Command" VALUE =""/>
<ATTRIBUTE NAME ="Codepage Parameter" VALUE =""/>
</SESSIONEXTENSION>
<ATTRIBUTE NAME ="General Options" VALUE =""/>
<ATTRIBUTE NAME ="Write Backward Compatible Session Log File" VALUE ="NO"/>
<ATTRIBUTE NAME ="Session Log File Name" VALUE ="s_m_COMPTIME_Current_Pay_Period.log"/>
<ATTRIBUTE NAME ="Session Log File directory" VALUE ="$PMSessionLogDir\"/>
<ATTRIBUTE NAME ="Parameter Filename" VALUE =""/>
<ATTRIBUTE NAME ="Enable Test Load" VALUE ="NO"/>
<ATTRIBUTE NAME ="$Source connection value" VALUE =""/>
<ATTRIBUTE NAME ="$Target connection value" VALUE =""/>
<ATTRIBUTE NAME ="Treat source rows as" VALUE ="Insert"/>
<ATTRIBUTE NAME ="Commit Type" VALUE ="Target"/>
<ATTRIBUTE NAME ="Commit Interval" VALUE ="10000"/>
<ATTRIBUTE NAME ="Commit On End Of File" VALUE ="YES"/>
<ATTRIBUTE NAME ="Rollback Transactions on Errors" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
<ATTRIBUTE NAME ="Java Classpath" VALUE =""/>
<ATTRIBUTE NAME ="Performance" VALUE =""/>
<ATTRIBUTE NAME ="DTM buffer size" VALUE ="Auto"/>
<ATTRIBUTE NAME ="Collect performance data" VALUE ="NO"/>
<ATTRIBUTE NAME ="Write performance data to repository" VALUE ="NO"/>
<ATTRIBUTE NAME ="Incremental Aggregation" VALUE ="NO"/>
<ATTRIBUTE NAME ="Enable high precision" VALUE ="NO"/>
<ATTRIBUTE NAME ="Session retry on deadlock" VALUE ="NO"/>
<ATTRIBUTE NAME ="Pushdown Optimization" VALUE ="None"/>
<ATTRIBUTE NAME ="Allow Temporary View for Pushdown" VALUE ="NO"/>
<ATTRIBUTE NAME ="Allow Temporary Sequence for Pushdown" VALUE ="NO"/>
<ATTRIBUTE NAME ="Allow Pushdown for User Incompatible Connections" VALUE ="NO"/>
</SESSION>
<SESSION DESCRIPTION ="" ISVALID ="YES" MAPPINGNAME ="m_COMPTIME_Build_Message_Counters" NAME ="s_COMPTIME_Build_Message_Counters" REUSABLE ="NO" SORTORDER ="Binary" VERSIONNUMBER ="1">
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="YES" PARTITIONTYPE ="PASS THROUGH" PIPELINE ="1" SINSTANCENAME ="COUNTER_TBL" STAGE ="1" TRANSFORMATIONNAME ="COUNTER_TBL" TRANSFORMATIONTYPE ="Target Definition"/>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="YES" PARTITIONTYPE ="PASS THROUGH" PIPELINE ="1" SINSTANCENAME ="COMPTIME_MESSAGE_FILE" STAGE ="2" TRANSFORMATIONNAME ="COMPTIME_MESSAGE_FILE" TRANSFORMATIONTYPE ="Target Definition">
<FLATFILE CODEPAGE ="Latin1" CONSECDELIMITERSASONE ="NO" DELIMITED ="NO" DELIMITERS ="," ESCAPE_CHARACTER ="" KEEPESCAPECHAR ="NO" LINESEQUENTIAL ="NO" MULTIDELIMITERSASAND ="NO" NULLCHARTYPE ="ASCII" NULL_CHARACTER ="*" PADBYTES ="1" QUOTE_CHARACTER ="NONE" REPEATABLE ="NO" ROWDELIMITER ="0" SKIPROWS ="0" STRIPTRAILINGBLANKS ="NO"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Final_Message" STAGE ="3" TRANSFORMATIONNAME ="exp_Final_Message" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Build_Message" STAGE ="3" TRANSFORMATIONNAME ="exp_Build_Message" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="fil_Detail" STAGE ="4" TRANSFORMATIONNAME ="fil_Detail" TRANSFORMATIONTYPE ="Filter">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Initial" STAGE ="4" TRANSFORMATIONNAME ="exp_Initial" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="YES" PARTITIONTYPE ="HASH AUTO KEYS" PIPELINE ="1" SINSTANCENAME ="agg_ALL_RECORDS" STAGE ="3" TRANSFORMATIONNAME ="agg_ALL_RECORDS" TRANSFORMATIONTYPE ="Aggregator">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Detail_Count" STAGE ="3" TRANSFORMATIONNAME ="exp_Detail_Count" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Counters" STAGE ="3" TRANSFORMATIONNAME ="exp_Counters" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Final" STAGE ="3" TRANSFORMATIONNAME ="exp_Final" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="0" SINSTANCENAME ="U0287D01" STAGE ="0" TRANSFORMATIONNAME ="U0287D01" TRANSFORMATIONTYPE ="Source Definition">
<FLATFILE CODEPAGE ="MS1252" CONSECDELIMITERSASONE ="NO" DELIMITED ="YES" DELIMITERS ="," ESCAPE_CHARACTER ="" KEEPESCAPECHAR ="NO" LINESEQUENTIAL ="NO" MULTIDELIMITERSASAND ="NO" NULLCHARTYPE ="ASCII" NULL_CHARACTER ="*" PADBYTES ="1" QUOTE_CHARACTER ="DOUBLE" REPEATABLE ="NO" ROWDELIMITER ="0" SKIPROWS ="0" STRIPTRAILINGBLANKS ="NO"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="YES" PARTITIONTYPE ="PASS THROUGH" PIPELINE ="1" SINSTANCENAME ="SQ_U0287D01" STAGE ="4" TRANSFORMATIONNAME ="SQ_U0287D01" TRANSFORMATIONTYPE ="Source Qualifier"/>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="lkp_PAY_PERIOD" STAGE ="3" TRANSFORMATIONNAME ="lkp_PAY_PERIOD" TRANSFORMATIONTYPE ="Lookup Procedure">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<CONFIGREFERENCE REFOBJECTNAME ="default_session_config" TYPE ="Session config"/>
<SESSIONCOMPONENT REFOBJECTNAME ="post_session_success_command" REUSABLE ="NO" TYPE ="Post-session success command">
<TASK DESCRIPTION ="" NAME ="post_session_success_command" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Fail task if any command fails" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
<VALUEPAIR EXECORDER ="1" NAME ="Command1" REVERSEASSIGNMENT ="NO" VALUE ="mv $Param_Root_Directory/data/int/in/COMPTIME/$Param_COMPTIME_filename $Param_Root_Directory/data/archive/COMPTIME/u0827d01_P$$WF_PP_YEAR_NUM.txt"/>
</TASK>
</SESSIONCOMPONENT>
<SESSIONCOMPONENT REFOBJECTNAME ="presession_variable_assignment" REUSABLE ="NO" TYPE ="Pre-session variable assignment">
<TASK DESCRIPTION ="" NAME ="presession_variable_assignment" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Fail task if any command fails" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
</TASK>
<VALUEPAIR EXECORDER ="1" NAME ="$$MAP_SUBJECT" REVERSEASSIGNMENT ="NO" VALUE ="$$WF_SUBJECT"/>
<VALUEPAIR EXECORDER ="2" NAME ="$$MAP_MESSAGE" REVERSEASSIGNMENT ="NO" VALUE ="$$WF_MESSAGE"/>
</SESSIONCOMPONENT>
<SESSIONCOMPONENT REFOBJECTNAME ="postsession_success_variable_assignment" REUSABLE ="NO" TYPE ="Post-session success variable assignment">
<TASK DESCRIPTION ="" NAME ="postsession_success_variable_assignment" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Fail task if any command fails" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
</TASK>
<VALUEPAIR EXECORDER ="1" NAME ="$$WF_SUBJECT" REVERSEASSIGNMENT ="NO" VALUE ="$$MAP_SUBJECT"/>
<VALUEPAIR EXECORDER ="2" NAME ="$$WF_MESSAGE" REVERSEASSIGNMENT ="NO" VALUE ="$$MAP_MESSAGE"/>
</SESSIONCOMPONENT>
<SESSIONCOMPONENT REFOBJECTNAME ="postsession_failure_variable_assignment" REUSABLE ="NO" TYPE ="Post-session failure variable assignment">
<TASK DESCRIPTION ="" NAME ="postsession_failure_variable_assignment" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Fail task if any command fails" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
</TASK>
</SESSIONCOMPONENT>
<SESSIONEXTENSION NAME ="Relational Writer" SINSTANCENAME ="COUNTER_TBL" SUBTYPE ="Relational Writer" TRANSFORMATIONTYPE ="Target Definition" TYPE ="WRITER">
<CONNECTIONREFERENCE CNXREFNAME ="DB Connection" CONNECTIONNAME ="INFO_TARGET" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="Oracle" CONNECTIONTYPE ="Relational" VARIABLE =""/>
<ATTRIBUTE NAME ="Target load type" VALUE ="Normal"/>
<ATTRIBUTE NAME ="Insert" VALUE ="YES"/>
<ATTRIBUTE NAME ="Update as Update" VALUE ="YES"/>
<ATTRIBUTE NAME ="Update as Insert" VALUE ="NO"/>
<ATTRIBUTE NAME ="Update else Insert" VALUE ="NO"/>
<ATTRIBUTE NAME ="Delete" VALUE ="YES"/>
<ATTRIBUTE NAME ="Truncate target table option" VALUE ="NO"/>
<ATTRIBUTE NAME ="Reject file directory" VALUE ="$PMBadFileDir\"/>
<ATTRIBUTE NAME ="Reject filename" VALUE ="counter_tbl1.bad"/>
</SESSIONEXTENSION>
<SESSIONEXTENSION NAME ="File Writer" SINSTANCENAME ="COMPTIME_MESSAGE_FILE" SUBTYPE ="File Writer" TRANSFORMATIONTYPE ="Target Definition" TYPE ="WRITER">
<CONNECTIONREFERENCE CNXREFNAME ="Connection" CONNECTIONNAME ="" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="" CONNECTIONTYPE ="" VARIABLE =""/>
<ATTRIBUTE NAME ="Merge Type" VALUE ="No Merge"/>
<ATTRIBUTE NAME ="Merge File Directory" VALUE ="$PMTargetFileDir\"/>
<ATTRIBUTE NAME ="Merge File Name" VALUE ="comptime_message_file.out"/>
<ATTRIBUTE NAME ="Append if Exists" VALUE ="NO"/>
<ATTRIBUTE NAME ="Create Target Directory" VALUE ="NO"/>
<ATTRIBUTE NAME ="Header Options" VALUE ="No Header"/>
<ATTRIBUTE NAME ="Header Command" VALUE =""/>
<ATTRIBUTE NAME ="Footer Command" VALUE =""/>
<ATTRIBUTE NAME ="Output Type" VALUE ="File"/>
<ATTRIBUTE NAME ="Merge Command" VALUE =""/>
<ATTRIBUTE NAME ="Output file directory" VALUE ="$PMTargetFileDir\"/>
<ATTRIBUTE NAME ="Output filename" VALUE ="comptime_message_file.txt"/>
<ATTRIBUTE NAME ="Reject file directory" VALUE ="$PMBadFileDir\"/>
<ATTRIBUTE NAME ="Reject filename" VALUE ="comptime_message_file1.bad"/>
<ATTRIBUTE NAME ="Command" VALUE =""/>
<ATTRIBUTE NAME ="Codepage Parameter" VALUE =""/>
</SESSIONEXTENSION>
<SESSIONEXTENSION DSQINSTNAME ="SQ_U0287D01" DSQINSTTYPE ="Source Qualifier" NAME ="File Reader" SINSTANCENAME ="U0287D01" SUBTYPE ="File Reader" TRANSFORMATIONTYPE ="Source Definition" TYPE ="READER">
<CONNECTIONREFERENCE CNXREFNAME ="Connection" CONNECTIONNAME ="" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="" CONNECTIONTYPE ="" VARIABLE =""/>
<ATTRIBUTE NAME ="Input Type" VALUE ="File"/>
<ATTRIBUTE NAME ="Concurrent read partitioning" VALUE ="Optimize throughput"/>
<ATTRIBUTE NAME ="Command Type" VALUE ="Command Generating Data"/>
<ATTRIBUTE NAME ="Source filetype" VALUE ="Direct"/>
<ATTRIBUTE NAME ="Source file directory" VALUE ="$Param_Root_Directory/data/int/in/COMPTIME"/>
<ATTRIBUTE NAME ="Source filename" VALUE ="$Param_COMPTIME_filename"/>
<ATTRIBUTE NAME ="Command" VALUE =""/>
<ATTRIBUTE NAME ="File Reader Truncate String Null" VALUE ="NO"/>
<ATTRIBUTE NAME ="Codepage Parameter" VALUE =""/>
</SESSIONEXTENSION>
<SESSIONEXTENSION NAME ="File Reader" SINSTANCENAME ="SQ_U0287D01" SUBTYPE ="File Reader" TRANSFORMATIONTYPE ="Source Qualifier" TYPE ="READER"/>
<SESSIONEXTENSION NAME ="Relational Lookup" SINSTANCENAME ="lkp_PAY_PERIOD" SUBTYPE ="Relational Lookup" TRANSFORMATIONTYPE ="Lookup Procedure" TYPE ="LOOKUPEXTENSION">
<CONNECTIONREFERENCE CNXREFNAME ="DB Connection" CONNECTIONNAME ="" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="" CONNECTIONTYPE ="Relational" VARIABLE ="$Target"/>
</SESSIONEXTENSION>
<ATTRIBUTE NAME ="General Options" VALUE =""/>
<ATTRIBUTE NAME ="Write Backward Compatible Session Log File" VALUE ="NO"/>
<ATTRIBUTE NAME ="Session Log File Name" VALUE ="s_m_COMPTIME_Build_Message_Counters.log"/>
<ATTRIBUTE NAME ="Session Log File directory" VALUE ="$PMSessionLogDir\"/>
<ATTRIBUTE NAME ="Parameter Filename" VALUE =""/>
<ATTRIBUTE NAME ="Enable Test Load" VALUE ="NO"/>
<ATTRIBUTE NAME ="$Source connection value" VALUE =""/>
<ATTRIBUTE NAME ="$Target connection value" VALUE =""/>
<ATTRIBUTE NAME ="Treat source rows as" VALUE ="Insert"/>
<ATTRIBUTE NAME ="Commit Type" VALUE ="Target"/>
<ATTRIBUTE NAME ="Commit Interval" VALUE ="10000"/>
<ATTRIBUTE NAME ="Commit On End Of File" VALUE ="YES"/>
<ATTRIBUTE NAME ="Rollback Transactions on Errors" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
<ATTRIBUTE NAME ="Java Classpath" VALUE =""/>
<ATTRIBUTE NAME ="Performance" VALUE =""/>
<ATTRIBUTE NAME ="DTM buffer size" VALUE ="Auto"/>
<ATTRIBUTE NAME ="Collect performance data" VALUE ="NO"/>
<ATTRIBUTE NAME ="Write performance data to repository" VALUE ="NO"/>
<ATTRIBUTE NAME ="Incremental Aggregation" VALUE ="NO"/>
<ATTRIBUTE NAME ="Enable high precision" VALUE ="NO"/>
<ATTRIBUTE NAME ="Session retry on deadlock" VALUE ="NO"/>
<ATTRIBUTE NAME ="Pushdown Optimization" VALUE ="None"/>
<ATTRIBUTE NAME ="Allow Temporary View for Pushdown" VALUE ="NO"/>
<ATTRIBUTE NAME ="Allow Temporary Sequence for Pushdown" VALUE ="NO"/>
<ATTRIBUTE NAME ="Allow Pushdown for User Incompatible Connections" VALUE ="NO"/>
</SESSION>
<SESSION DESCRIPTION ="" ISVALID ="YES" MAPPINGNAME ="m_COMPTIME_Load_COMP_TIME_DAILY_TBL" NAME ="s_COMPTIME_Load_COMP_TIME_DAILY_TBL" REUSABLE ="NO" SORTORDER ="Binary" VERSIONNUMBER ="1">
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="0" SINSTANCENAME ="U0287D01" STAGE ="0" TRANSFORMATIONNAME ="U0287D01" TRANSFORMATIONTYPE ="Source Definition">
<FLATFILE CODEPAGE ="MS1252" CONSECDELIMITERSASONE ="NO" DELIMITED ="YES" DELIMITERS ="," ESCAPE_CHARACTER ="" KEEPESCAPECHAR ="NO" LINESEQUENTIAL ="NO" MULTIDELIMITERSASAND ="NO" NULLCHARTYPE ="ASCII" NULL_CHARACTER ="*" PADBYTES ="1" QUOTE_CHARACTER ="DOUBLE" REPEATABLE ="NO" ROWDELIMITER ="0" SKIPROWS ="0" STRIPTRAILINGBLANKS ="NO"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="YES" PARTITIONTYPE ="PASS THROUGH" PIPELINE ="1" SINSTANCENAME ="SQ_U0287D01" STAGE ="1" TRANSFORMATIONNAME ="SQ_U0287D01" TRANSFORMATIONTYPE ="Source Qualifier"/>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="YES" PARTITIONTYPE ="PASS THROUGH" PIPELINE ="1" SINSTANCENAME ="COMP_TIME_DAILY_TBL" STAGE ="2" TRANSFORMATIONNAME ="COMP_TIME_DAILY_TBL" TRANSFORMATIONTYPE ="Target Definition"/>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Initial" STAGE ="1" TRANSFORMATIONNAME ="exp_Initial" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Final" STAGE ="1" TRANSFORMATIONNAME ="exp_Final" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="lkp_PAY_PERIOD" STAGE ="1" TRANSFORMATIONNAME ="lkp_PAY_PERIOD" TRANSFORMATIONTYPE ="Lookup Procedure">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="exp_Convert" STAGE ="1" TRANSFORMATIONNAME ="exp_Convert" TRANSFORMATIONTYPE ="Expression">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<SESSTRANSFORMATIONINST ISREPARTITIONPOINT ="NO" PIPELINE ="1" SINSTANCENAME ="fil_Valid_Records" STAGE ="1" TRANSFORMATIONNAME ="fil_Valid_Records" TRANSFORMATIONTYPE ="Filter">
<PARTITION DESCRIPTION ="" NAME ="Partition #1"/>
</SESSTRANSFORMATIONINST>
<CONFIGREFERENCE REFOBJECTNAME ="default_session_config" TYPE ="Session config"/>
<SESSIONCOMPONENT REFOBJECTNAME ="presession_variable_assignment" REUSABLE ="NO" TYPE ="Pre-session variable assignment">
<TASK DESCRIPTION ="" NAME ="presession_variable_assignment" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Fail task if any command fails" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
</TASK>
</SESSIONCOMPONENT>
<SESSIONCOMPONENT REFOBJECTNAME ="postsession_success_variable_assignment" REUSABLE ="NO" TYPE ="Post-session success variable assignment">
<TASK DESCRIPTION ="" NAME ="postsession_success_variable_assignment" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Fail task if any command fails" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
</TASK>
</SESSIONCOMPONENT>
<SESSIONCOMPONENT REFOBJECTNAME ="postsession_failure_variable_assignment" REUSABLE ="NO" TYPE ="Post-session failure variable assignment">
<TASK DESCRIPTION ="" NAME ="postsession_failure_variable_assignment" REUSABLE ="NO" TYPE ="Command" VERSIONNUMBER ="1">
<ATTRIBUTE NAME ="Fail task if any command fails" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
</TASK>
</SESSIONCOMPONENT>
<SESSIONEXTENSION DSQINSTNAME ="SQ_U0287D01" DSQINSTTYPE ="Source Qualifier" NAME ="File Reader" SINSTANCENAME ="U0287D01" SUBTYPE ="File Reader" TRANSFORMATIONTYPE ="Source Definition" TYPE ="READER">
<CONNECTIONREFERENCE CNXREFNAME ="Connection" CONNECTIONNAME ="" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="" CONNECTIONTYPE ="" VARIABLE =""/>
<ATTRIBUTE NAME ="Input Type" VALUE ="File"/>
<ATTRIBUTE NAME ="Concurrent read partitioning" VALUE ="Optimize throughput"/>
<ATTRIBUTE NAME ="Command Type" VALUE ="Command Generating Data"/>
<ATTRIBUTE NAME ="Source filetype" VALUE ="Direct"/>
<ATTRIBUTE NAME ="Source file directory" VALUE ="$Param_Root_Directory/data/int/in/COMPTIME"/>
<ATTRIBUTE NAME ="Source filename" VALUE ="$Param_COMPTIME_filename"/>
<ATTRIBUTE NAME ="Command" VALUE =""/>
<ATTRIBUTE NAME ="File Reader Truncate String Null" VALUE ="NO"/>
<ATTRIBUTE NAME ="Codepage Parameter" VALUE =""/>
</SESSIONEXTENSION>
<SESSIONEXTENSION NAME ="File Reader" SINSTANCENAME ="SQ_U0287D01" SUBTYPE ="File Reader" TRANSFORMATIONTYPE ="Source Qualifier" TYPE ="READER"/>
<SESSIONEXTENSION NAME ="Relational Writer" SINSTANCENAME ="COMP_TIME_DAILY_TBL" SUBTYPE ="Relational Writer" TRANSFORMATIONTYPE ="Target Definition" TYPE ="WRITER">
<CONNECTIONREFERENCE CNXREFNAME ="DB Connection" CONNECTIONNAME ="INFO_TARGET" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="Oracle" CONNECTIONTYPE ="Relational" VARIABLE =""/>
<ATTRIBUTE NAME ="Target load type" VALUE ="Normal"/>
<ATTRIBUTE NAME ="Insert" VALUE ="YES"/>
<ATTRIBUTE NAME ="Update as Update" VALUE ="YES"/>
<ATTRIBUTE NAME ="Update as Insert" VALUE ="NO"/>
<ATTRIBUTE NAME ="Update else Insert" VALUE ="NO"/>
<ATTRIBUTE NAME ="Delete" VALUE ="YES"/>
<ATTRIBUTE NAME ="Truncate target table option" VALUE ="NO"/>
<ATTRIBUTE NAME ="Reject file directory" VALUE ="$PMBadFileDir\"/>
<ATTRIBUTE NAME ="Reject filename" VALUE ="INFO_MSIMON"/>
</SESSIONEXTENSION>
<SESSIONEXTENSION NAME ="Relational Lookup" SINSTANCENAME ="lkp_PAY_PERIOD" SUBTYPE ="Relational Lookup" TRANSFORMATIONTYPE ="Lookup Procedure" TYPE ="LOOKUPEXTENSION">
<CONNECTIONREFERENCE CNXREFNAME ="DB Connection" CONNECTIONNAME ="" CONNECTIONNUMBER ="1" CONNECTIONSUBTYPE ="" CONNECTIONTYPE ="Relational" VARIABLE ="$Target"/>
</SESSIONEXTENSION>
<ATTRIBUTE NAME ="General Options" VALUE =""/>
<ATTRIBUTE NAME ="Write Backward Compatible Session Log File" VALUE ="NO"/>
<ATTRIBUTE NAME ="Session Log File Name" VALUE ="s_COMPTIME_Load_COMP_TIME_DAILY_TBL.log"/>
<ATTRIBUTE NAME ="Session Log File directory" VALUE ="$PMSessionLogDir\"/>
<ATTRIBUTE NAME ="Parameter Filename" VALUE =""/>
<ATTRIBUTE NAME ="Enable Test Load" VALUE ="NO"/>
<ATTRIBUTE NAME ="$Source connection value" VALUE =""/>
<ATTRIBUTE NAME ="$Target connection value" VALUE ="Relational:INFO_TARGET"/>
<ATTRIBUTE NAME ="Treat source rows as" VALUE ="Insert"/>
<ATTRIBUTE NAME ="Commit Type" VALUE ="Target"/>
<ATTRIBUTE NAME ="Commit Interval" VALUE ="10000"/>
<ATTRIBUTE NAME ="Commit On End Of File" VALUE ="YES"/>
<ATTRIBUTE NAME ="Rollback Transactions on Errors" VALUE ="NO"/>
<ATTRIBUTE NAME ="Recovery Strategy" VALUE ="Fail task and continue workflow"/>
<ATTRIBUTE NAME ="Java Classpath" VALUE =""/>
<ATTRIBUTE NAME ="Performance" VALUE =""/>
<ATTRIBUTE NAME ="DTM buffer size" VALUE ="24000000"/>
<ATTRIBUTE NAME ="Collect performance data" VALUE ="NO"/>
<ATTRIBUTE NAME ="Write performance data to repository" VALUE ="NO"/>
<ATTRIBUTE NAME ="Incremental Aggregation" VALUE ="NO"/>
<ATTRIBUTE NAME ="Session retry on deadlock" VALUE ="NO"/>
<ATTRIBUTE NAME ="Pushdown Optimization" VALUE ="None"/>
<ATTRIBUTE NAME ="Allow Temporary View for Pushdown" VALUE ="NO"/>
<ATTRIBUTE NAME ="Allow Temporary Sequence for Pushdown" VALUE ="NO"/>
<ATTRIBUTE NAME ="Allow Pushdown for User Incompatible Connections" VALUE ="NO"/>
</SESSION>
<TASKINSTANCE DESCRIPTION ="" FAIL_PARENT_IF_INSTANCE_DID_NOT_RUN ="NO" FAIL_PARENT_IF_INSTANCE_FAILS ="YES" ISENABLED ="YES" NAME ="s_COMPTIME_Current_Pay_Period" REUSABLE ="NO" TASKNAME ="s_COMPTIME_Current_Pay_Period" TASKTYPE ="Session" TREAT_INPUTLINK_AS_AND ="YES"/>
<TASKINSTANCE DESCRIPTION ="" FAIL_PARENT_IF_INSTANCE_DID_NOT_RUN ="NO" FAIL_PARENT_IF_INSTANCE_FAILS ="YES" ISENABLED ="YES" NAME ="s_COMPTIME_Build_Message_Counters" REUSABLE ="NO" TASKNAME ="s_COMPTIME_Build_Message_Counters" TASKTYPE ="Session" TREAT_INPUTLINK_AS_AND ="YES"/>
<TASKINSTANCE DESCRIPTION ="" FAIL_PARENT_IF_INSTANCE_DID_NOT_RUN ="NO" FAIL_PARENT_IF_INSTANCE_FAILS ="YES" ISENABLED ="YES" NAME ="s_COMPTIME_Load_COMP_TIME_DAILY_TBL" REUSABLE ="NO" TASKNAME ="s_COMPTIME_Load_COMP_TIME_DAILY_TBL" TASKTYPE ="Session" TREAT_INPUTLINK_AS_AND ="YES"/>
<TASKINSTANCE DESCRIPTION ="" ISENABLED ="YES" NAME ="Start" REUSABLE ="NO" TASKNAME ="Start" TASKTYPE ="Start"/>
<TASKINSTANCE DESCRIPTION ="" FAIL_PARENT_IF_INSTANCE_DID_NOT_RUN ="NO" FAIL_PARENT_IF_INSTANCE_FAILS ="NO" ISENABLED ="YES" NAME ="email_COMPTIME_Complete" REUSABLE ="NO" TASKNAME ="email_COMPTIME_Complete" TASKTYPE ="Email" TREAT_INPUTLINK_AS_AND ="YES"/>
<WORKFLOWLINK CONDITION ="" FROMTASK ="Start" TOTASK ="s_COMPTIME_Current_Pay_Period"/>
<WORKFLOWLINK CONDITION ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.Status = Succeeded" FROMTASK ="s_COMPTIME_Load_COMP_TIME_DAILY_TBL" TOTASK ="s_COMPTIME_Build_Message_Counters"/>
<WORKFLOWLINK CONDITION ="$s_COMPTIME_Current_Pay_Period.Status = Succeeded" FROMTASK ="s_COMPTIME_Current_Pay_Period" TOTASK ="s_COMPTIME_Load_COMP_TIME_DAILY_TBL"/>
<WORKFLOWLINK CONDITION ="$s_COMPTIME_Build_Message_Counters.Status = Succeeded" FROMTASK ="s_COMPTIME_Build_Message_Counters" TOTASK ="email_COMPTIME_Complete"/>
<WORKFLOWVARIABLE DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="The time this task started" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.StartTime" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="The time this task completed" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.EndTime" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Status of this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.Status" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Status of the previous task that is not disabled" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.PrevTaskStatus" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Error code for this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.ErrorCode" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="Error message for this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.ErrorMsg" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows successfully read" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.SrcSuccessRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows failed to read" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.SrcFailedRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows successfully loaded" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.TgtSuccessRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows failed to load" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.TgtFailedRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Total number of transformation errors" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.TotalTransErrors" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="First error code" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.FirstErrorCode" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="First error message" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Current_Pay_Period.FirstErrorMsg" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="The time this task started" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.StartTime" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="The time this task completed" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.EndTime" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Status of this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.Status" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Status of the previous task that is not disabled" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.PrevTaskStatus" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Error code for this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.ErrorCode" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="Error message for this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.ErrorMsg" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows successfully read" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.SrcSuccessRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows failed to read" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.SrcFailedRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows successfully loaded" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.TgtSuccessRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows failed to load" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.TgtFailedRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Total number of transformation errors" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.TotalTransErrors" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="First error code" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.FirstErrorCode" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="First error message" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Build_Message_Counters.FirstErrorMsg" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="The time this task started" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.StartTime" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="The time this task completed" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.EndTime" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Status of this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.Status" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Status of the previous task that is not disabled" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.PrevTaskStatus" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Error code for this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.ErrorCode" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="Error message for this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.ErrorMsg" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows successfully read" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.SrcSuccessRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows failed to read" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.SrcFailedRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows successfully loaded" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.TgtSuccessRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Rows failed to load" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.TgtFailedRows" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Total number of transformation errors" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.TotalTransErrors" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="First error code" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.FirstErrorCode" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="First error message" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$s_COMPTIME_Load_COMP_TIME_DAILY_TBL.FirstErrorMsg" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="The time this task started" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$Start.StartTime" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="The time this task completed" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$Start.EndTime" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Status of this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$Start.Status" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Status of the previous task that is not disabled" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$Start.PrevTaskStatus" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Error code for this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$Start.ErrorCode" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="Error message for this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$Start.ErrorMsg" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="The time this task started" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$email_COMPTIME_Complete.StartTime" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="date/time" DEFAULTVALUE ="" DESCRIPTION ="The time this task completed" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$email_COMPTIME_Complete.EndTime" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Status of this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$email_COMPTIME_Complete.Status" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Status of the previous task that is not disabled" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$email_COMPTIME_Complete.PrevTaskStatus" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="Error code for this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$email_COMPTIME_Complete.ErrorCode" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="string" DEFAULTVALUE ="" DESCRIPTION ="Error message for this task's execution" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$email_COMPTIME_Complete.ErrorMsg" USERDEFINED ="NO"/>
<WORKFLOWVARIABLE DATATYPE ="nstring" DEFAULTVALUE ="" DESCRIPTION ="" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$$WF_PP_YEAR_NUM" USERDEFINED ="YES"/>
<WORKFLOWVARIABLE DATATYPE ="nstring" DEFAULTVALUE ="" DESCRIPTION ="" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$$WF_COMPTIME_EMAIL_LIST" USERDEFINED ="YES"/>
<WORKFLOWVARIABLE DATATYPE ="nstring" DEFAULTVALUE ="" DESCRIPTION ="" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$$WF_SUBJECT" USERDEFINED ="YES"/>
<WORKFLOWVARIABLE DATATYPE ="nstring" DEFAULTVALUE ="" DESCRIPTION ="" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$$WF_MESSAGE" USERDEFINED ="YES"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$$WF_PP_END_YEAR" USERDEFINED ="YES"/>
<WORKFLOWVARIABLE DATATYPE ="integer" DEFAULTVALUE ="" DESCRIPTION ="" ISNULL ="NO" ISPERSISTENT ="NO" NAME ="$$WF_PP_NUM" USERDEFINED ="YES"/>
<ATTRIBUTE NAME ="Parameter Filename" VALUE ="/data/BIISINT/control/BIIS_parms.iparms"/>
<ATTRIBUTE NAME ="Write Backward Compatible Workflow Log File" VALUE ="NO"/>
<ATTRIBUTE NAME ="Workflow Log File Name" VALUE ="wf_COMPTIME_Load_COMP_TIME_DAILY_TBL.log"/>
<ATTRIBUTE NAME ="Workflow Log File Directory" VALUE ="$PMWorkflowLogDir\"/>
<ATTRIBUTE NAME ="Save Workflow log by" VALUE ="By runs"/>
<ATTRIBUTE NAME ="Save workflow log for these runs" VALUE ="0"/>
<ATTRIBUTE NAME ="Service Name" VALUE =""/>
<ATTRIBUTE NAME ="Service Timeout" VALUE ="0"/>
<ATTRIBUTE NAME ="Is Service Visible" VALUE ="NO"/>
<ATTRIBUTE NAME ="Is Service Protected" VALUE ="NO"/>
<ATTRIBUTE NAME ="Fail task after wait time" VALUE ="0"/>
<ATTRIBUTE NAME ="Enable HA recovery" VALUE ="NO"/>
<ATTRIBUTE NAME ="Automatically recover terminated tasks" VALUE ="NO"/>
<ATTRIBUTE NAME ="Service Level Name" VALUE ="Default"/>
<ATTRIBUTE NAME ="Allow concurrent run with unique run instance name" VALUE ="NO"/>
<ATTRIBUTE NAME ="Allow concurrent run with same run instance name" VALUE ="NO"/>
<ATTRIBUTE NAME ="Maximum number of concurrent runs" VALUE ="0"/>
<ATTRIBUTE NAME ="Assigned Web Services Hubs" VALUE =""/>
<ATTRIBUTE NAME ="Maximum number of concurrent runs per Hub" VALUE ="1000"/>
<ATTRIBUTE NAME ="Expected Service Time" VALUE ="1"/>
</WORKFLOW>
</FOLDER>
</REPOSITORY>
</POWERMART>
