<?xml version="1.0" encoding="TIS-620"?> <WORKFLOW> <APP_NAME>PERSONAL</APP_NAME> <SOURCE_TABLE> <TABLE name="Workflow_Data" central="true" out="inquiry"> <FIELD>COMPANYID</FIELD> <FIELD>WF_ID</FIELD> <FIELD>WF_VER</FIELD> <FIELD>DOC_NO</FIELD> <FIELD>SCREEN_VALUE</FIELD> </TABLE> </SOURCE_TABLE> <DESTINATION_TABLE> <TABLE name="MEMPLOYEE" central="true" out="record"> <FIELD name="EMPLOYEEID" setcolumn="1" fix_value="" not_null="1">EMPLOYEEID</FIELD> <FIELD name="COMPANYID" setcolumn="1" fix_value="" not_null="1">COMPANYID</FIELD> <FIELD name="EMP_PREFIX" setcolumn="1" fix_value="" not_null="0">EMP_PREFIX</FIELD> <FIELD name="FNAME" setcolumn="1" fix_value="" not_null="0">FNAME</FIELD> <FIELD name="LNAME" setcolumn="1" fix_value="" not_null="0">LNAME</FIELD> <FIELD name="OFNAME" setcolumn="1" fix_value="" not_null="0">OFNAME</FIELD> <FIELD name="OLNAME" setcolumn="1" fix_value="" not_null="0">OLNAME</FIELD> <FIELD name="EFNAME" setcolumn="1" fix_value="" not_null="0">EFNAME</FIELD> <FIELD name="ELNAME" setcolumn="1" fix_value="" not_null="0">ELNAME</FIELD> <FIELD name="EFFOFNAME" setcolumn="1" fix_value="" not_null="0">EFFOFNAME</FIELD> <FIELD name="MOBILE" setcolumn="1" fix_value="" not_null="0">MOBILE</FIELD> <!--PVF--> <FIELD name="INSURANCE" setcolumn="1" fix_value="" not_null="0">INSURANCE</FIELD> <FIELD name="INSURANCE_SPOUSE" setcolumn="1" fix_value="" not_null="0">INSURANCE_SPOUSE</FIELD> <FIELD name="INTEREST" setcolumn="1" fix_value="" not_null="0">INTEREST</FIELD> <FIELD name="RMF" setcolumn="1" fix_value="" not_null="0">RMF</FIELD> <FIELD name="LTF" setcolumn="1" fix_value="" not_null="0">LTF</FIELD> <FIELD name="FTHYN" setcolumn="1" fix_value="" not_null="0">FAT_DEDUC</FIELD> <FIELD name="MTHYN" setcolumn="1" fix_value="" not_null="0">MOT_DEDUC</FIELD> <FIELD name="FTHMRYYN" setcolumn="1" fix_value="" not_null="0">SPOUSE_FAT_DEDUC</FIELD> <FIELD name="MTHMRYYN" setcolumn="1" fix_value="" not_null="0">SPOUSE_MOT_DEDUC</FIELD> <FIELD name="INS_FAT" setcolumn="1" fix_value="" not_null="0">INS_FAT</FIELD> <FIELD name="INS_MOT" setcolumn="1" fix_value="" not_null="0">INS_MOT</FIELD> <FIELD name="INS_FAT_SPOUSE" setcolumn="1" fix_value="" not_null="0">INS_FAT_SPOUSE</FIELD> <FIELD name="INS_MOT_SPOUSE" setcolumn="1" fix_value="" not_null="0">INS_MOT_SPOUSE</FIELD> <FIELD name="STATMARRY" setcolumn="1" fix_value="" not_null="0">STATMARRY</FIELD> <FIELD name="FNAME_SPOUSE" setcolumn="1" fix_value="" not_null="0">FNAME_SPOUSE</FIELD> <FIELD name="LNAME_SPOUSE" setcolumn="1" fix_value="" not_null="0">LNAME_SPOUSE</FIELD> <FIELD name="PREFIX_SPOUSE" setcolumn="1" fix_value="" not_null="0">PREFIX_SPOUSE</FIELD> <FIELD name="MARR_REG_DATE" setcolumn="1" fix_value="" not_null="0">DATEMARRY</FIELD> <FIELD name="INC_SPOUSE" setcolumn="1" fix_value="" not_null="0">INC_SPOUSE</FIELD> <FIELD name="IDSPOUSETAX" setcolumn="1" fix_value="" not_null="0">IDSPOUSE</FIELD> <FIELD name="CHILD1_EDU" setcolumn="1" fix_value="" not_null="0">CHILD1_EDU</FIELD> <FIELD name="CHILD2_EDU" setcolumn="1" fix_value="" not_null="0">CHILD2_EDU</FIELD> <FIELD name="CHILD3_EDU" setcolumn="1" fix_value="" not_null="0">CHILD3_EDU</FIELD> <FIELD name="CHILDBIRTH1" setcolumn="1" fix_value="" not_null="0">CHILDBIRTH1</FIELD> <FIELD name="CHILDBIRTH2" setcolumn="1" fix_value="" not_null="0">CHILDBIRTH2</FIELD> <FIELD name="CHILDBIRTH3" setcolumn="1" fix_value="" not_null="0">CHILDBIRTH3</FIELD> <FIELD name="CHILD_DOMESTIC" setcolumn="1" fix_value="" not_null="0">CHILD_DOMESTIC</FIELD> <!-- <FIELD name="CHILD_ABROAD" setcolumn="1" fix_value="" not_null="0">CHILD_ABROAD</FIELD> --> <FIELD name="CHILD" setcolumn="1" fix_value="" not_null="0">CHILD</FIELD> <FIELD name="FTHIDCARD" setcolumn="1" fix_value="" not_null="0">FTHIDCARD</FIELD> <FIELD name="MTHIDCARD" setcolumn="1" fix_value="" not_null="0">MTHIDCARD</FIELD> <FIELD name="FTHMRYIDCARD" setcolumn="1" fix_value="" not_null="0">FTHMRYIDCARD</FIELD> <FIELD name="MTHMRYIDCARD" setcolumn="1" fix_value="" not_null="0">MTHMRYIDCARD</FIELD> <FIELD name="SPORTDONATION" setcolumn="1" fix_value="" not_null="0">SPORTDONATION</FIELD> <FIELD name="EDUDONATION" setcolumn="1" fix_value="" not_null="0">EDUDONATION</FIELD> <FIELD name="ISCRIPPLE" setcolumn="1" fix_value="" not_null="0">ISCRIPPLE</FIELD> <FIELD name="DONATION" setcolumn="1" fix_value="" not_null="0">DONATION</FIELD> <FIELD name="BEFORE_WORK" setcolumn="1" fix_value="" not_null="0">JOBEVER</FIELD> <FIELD name="OTHER_INCOME" setcolumn="1" fix_value="" not_null="0">INCOME</FIELD> </TABLE> <TABLE name="MEMPL_EDUCATE" central="true" out="table" delete="1" minorkey="educ_index"> <FIELD name="COMPANYID" setcolumn="1" fix_value="" not_null="1">COMPANYID</FIELD> <FIELD name="EMPLOYEEID" setcolumn="1" fix_value="" not_null="1">EMPLOYEEID</FIELD> <FIELD name="EDUC_INDEX" setcolumn="1" fix_value="" not_null="1">EDUC_INDEX</FIELD> <FIELD name="DEGREEID" setcolumn="1" fix_value="" not_null="1">DEGREEID</FIELD> <FIELD name="INSTITUE" setcolumn="1" fix_value="" not_null="1">INSTITUE</FIELD> <FIELD name="FACULTY" setcolumn="1" fix_value="" not_null="1">FACULTY</FIELD> <FIELD name="MAJORID" setcolumn="1" fix_value="" not_null="1">MAJORID</FIELD> <FIELD name="GPA" setcolumn="1" fix_value="" not_null="0">GPA</FIELD> <FIELD name="YEAR_START" setcolumn="1" fix_value="" not_null="1">YEAR_START</FIELD> <FIELD name="YEAR_END" setcolumn="1" fix_value="" not_null="0">YEAR_END</FIELD> </TABLE> <TABLE name="MEMPL_ADDR" central="true" out="table" delete="1" minorkey="line_no"> <FIELD name="COMPANYID" setcolumn="1" fix_value="" not_null="1">COMPANYID</FIELD> <FIELD name="EMPLOYEEID" setcolumn="1" fix_value="" not_null="1">EMPLOYEEID</FIELD> <FIELD name="LINE_NO" setcolumn="1" fix_value="" not_null="1">LINE_NO</FIELD> <FIELD name="ADDR_CURRENT" setcolumn="1" fix_value="" not_null="0">ADDR_CURRENT</FIELD> <FIELD name="TVILLAGE" setcolumn="1" fix_value="" not_null="0">TVILLAGE</FIELD> <FIELD name="TROOM_NO" setcolumn="1" fix_value="" not_null="0">TROOM_NO</FIELD> <FIELD name="TFLOOR" setcolumn="1" fix_value="" not_null="0">TFLOOR</FIELD> <FIELD name="TADDR" setcolumn="1" fix_value="" not_null="0">TADDR</FIELD> <FIELD name="TSOI" setcolumn="1" fix_value="" not_null="0">TSOI</FIELD> <FIELD name="TMOO" setcolumn="1" fix_value="" not_null="0">TMOO</FIELD> <FIELD name="TROAD" setcolumn="1" fix_value="" not_null="0">TROAD</FIELD> <FIELD name="TDISTRICT" setcolumn="1" fix_value="" not_null="0">TDISTRICT</FIELD> <FIELD name="AMPHUR" setcolumn="1" fix_value="" not_null="0">AMPHUR</FIELD> <FIELD name="ZIPCODE" setcolumn="1" fix_value="" not_null="1">ZIPCODE</FIELD> <FIELD name="EVILLAGE" setcolumn="1" fix_value="" not_null="0">EVILLAGE</FIELD> <FIELD name="EROOM_NO" setcolumn="1" fix_value="" not_null="0">EROOM_NO</FIELD> <FIELD name="EFLOOR" setcolumn="1" fix_value="" not_null="0">EFLOOR</FIELD> <FIELD name="EADDR" setcolumn="1" fix_value="" not_null="0">EADDR</FIELD> <FIELD name="ESOI" setcolumn="1" fix_value="" not_null="0">ESOI</FIELD> <FIELD name="EMOO" setcolumn="1" fix_value="" not_null="0">EMOO</FIELD> <FIELD name="EROAD" setcolumn="1" fix_value="" not_null="0">EROAD</FIELD> <FIELD name="EDISTRICT" setcolumn="1" fix_value="" not_null="0">EDISTRICT</FIELD> <FIELD name="TEL" setcolumn="1" fix_value="" not_null="0">TEL</FIELD> <FIELD name="FAX" setcolumn="1" fix_value="" not_null="0">FAX</FIELD> <FIELD name="PICTURE" setcolumn="1" fix_value="" not_null="0">PICTURE</FIELD> <FIELD name="DISTANCE" setcolumn="1" fix_value="" not_null="0">DISTANCE</FIELD> <FIELD name="WF" setcolumn="0" fix_value="1" not_null="0">COMPANYID</FIELD> </TABLE> <TABLE name="MEMPL_CARD" central="true" out="table" delete="1" minorkey="line_no"> <FIELD name="COMPANYID" setcolumn="1" fix_value="" not_null="1">COMPANYID</FIELD> <FIELD name="EMPLOYEEID" setcolumn="1" fix_value="" not_null="1">EMPLOYEEID</FIELD> <FIELD name="CARDTYPEID" setcolumn="1" fix_value="11" not_null="1">COMPANYID</FIELD> <FIELD name="CARDNO" setcolumn="1" fix_value="" not_null="1">CARDNO</FIELD> <FIELD name="LINE_NO" setcolumn="1" fix_value="" not_null="1">LINE_NO</FIELD> <FIELD name="ATFILE" setcolumn="1" fix_value="" not_null="1">ATFILE</FIELD> <FIELD name="ACTIVEDATE" setcolumn="1" fix_value="1900-01-01" not_null="1">COMPANYID</FIELD> <FIELD name="EXPIREDATE" setcolumn="1" fix_value="1900-01-01" not_null="1">COMPANYID</FIELD> </TABLE> <TABLE name="MEMPL_FAMILY" central="true" out="table" delete="0" minorkey="line_no"> <FIELD name="COMPANYID" setcolumn="1" fix_value="" not_null="1">COMPANYID</FIELD> <FIELD name="EMPLOYEEID" setcolumn="1" fix_value="" not_null="1">EMPLOYEEID</FIELD> <FIELD name="LINE_NO" setcolumn="1" fix_value="" not_null="1">LINE_NO</FIELD> <FIELD name="RELATIONID" setcolumn="1" fix_value="" not_null="1">RELATIONID</FIELD> <FIELD name="PREFIX" setcolumn="1" fix_value="" not_null="0">PREFIX</FIELD> <FIELD name="FNAMEID" setcolumn="1" fix_value="" not_null="1">FNAMEID</FIELD><!--��� not null ��������繤���� table ��������͡���Шз���� transfer �Դ--> <FIELD name="LNAME" setcolumn="1" fix_value="" not_null="">LNAME</FIELD> <FIELD name="IDCARD" setcolumn="1" fix_value="" not_null="1">IDCARD</FIELD> <FIELD name="BIRTHDAY" setcolumn="1" fix_value="" not_null="0">BIRTHDAY</FIELD> <FIELD name="YEAR_MARRY" setcolumn="1" fix_value="" not_null="0">YEAR_MARRY</FIELD> </TABLE> </DESTINATION_TABLE> </WORKFLOW>