View source for 06 employee transfer transaction file es2ett

=Employee Transfer Transaction File (ES2ETT)=

'''ES2ETT - Length 20 - Revised 9/19/2003'''

<table cellspacing="0" width="100%" class="ms-rteTable-default"><tr class="ms-rteTableEvenRow-default"><td class="ms-rteTableEvenCol-default" colspan="2" style="width&#58;2%;height&#58;1px;"><p><strong>Columns</strong></p></td><td class="ms-rteTableOddCol-default" style="width&#58;2%;height&#58;1px;"><strong>Len</strong></td><td class="ms-rteTableEvenCol-default" style="width&#58;2%;height&#58;1px;"><strong>Key</strong></td><td class="ms-rteTableOddCol-default" style="width&#58;1%;height&#58;1px;"><strong>Type</strong></td><td class="ms-rteTableEvenCol-default" style="width&#58;6%;height&#58;1px;"><strong>COBOL Field Name</strong></td><td class="ms-rteTableOddCol-default" style="width&#58;14.2857%;height&#58;1px;"><strong>Description &amp; Notes</strong></td></tr><tr class="ms-rteTableOddRow-default"><td class="ms-rteTableEvenCol-default">1<br></td><td class="ms-rteTableOddCol-default">10<br></td><td class="ms-rteTableEvenCol-default" style="width&#58;2%;">10</td><td class="ms-rteTableOddCol-default" style="width&#58;2%;">Key</td><td class="ms-rteTableEvenCol-default" style="width&#58;1%;">Char</td><td class="ms-rteTableOddCol-default" style="width&#58;6%;">ETT-PRED-ACCT</td><td class="ms-rteTableEvenCol-default">U-I account number of the predecessor (i.e., the employer for which this employee was working during the previous quarter); quarters are defined in the header record, with the format delineated later; must be numeric unless this employee was not associated with any employer during the previous quarter; in this case, the field should be set to '<strong>XXXXXXXXXX</strong>', a special notation for a new hire without prior quarter employment</td></tr><tr class="ms-rteTableEvenRow-default"><td class="ms-rteTableEvenCol-default">11</td><td class="ms-rteTableOddCol-default">20</td><td class="ms-rteTableEvenCol-default" style="width&#58;2%;">10</td><td class="ms-rteTableOddCol-default" style="width&#58;2%;">Key</td><td class="ms-rteTableEvenCol-default" style="width&#58;1%;">Char</td><td class="ms-rteTableOddCol-default" style="width&#58;6%;">ETT-SUCC-ACCT</td><td class="ms-rteTableEvenCol-default">U-I account number of the successor (i.e., the account number of the company that employed this person during the next quarter); quarters are defined in the header record, which is laid out below; must be numeric unless this employee does not show an association to any employer in the later quarter; in this instance, the successor account should be set to '<strong>XXXXXXXXXX</strong>', which denotes an employee who is no longer associated with any employer, but was employed last quarter</td></tr><tr class="ms-rteTableOddRow-default"><td class="ms-rteTableEvenCol-default" colspan="7"><h5 style="text-align&#58;center;">Employee Transfer Header Record     </h5></td></tr><tr class="ms-rteTableEvenRow-default"><td class="ms-rteTableEvenCol-default">1</td><td class="ms-rteTableOddCol-default">10</td><td class="ms-rteTableEvenCol-default" style="width&#58;2%;">10R</td><td class="ms-rteTableOddCol-default" style="width&#58;2%;">Key</td><td class="ms-rteTableEvenCol-default" style="width&#58;1%;">Char</td><td class="ms-rteTableOddCol-default" style="width&#58;6%;"><p>(ETT-PRED-ACCT) <em>no special name used</em></p><p><em>&#160;&#160;&#160; </em><em>in header record application</em></p></td><td class="ms-rteTableEvenCol-default">For the header record, the predecessor account field <strong>MUST</strong> be set to <strong>spaces</strong>; this is essential, since the file is sorted by the entire key (i.e., the entire record), so the header must still appear at the very beginning of the file to assure proper processing of the rest of the file</td></tr><tr class="ms-rteTableOddRow-default"><td class="ms-rteTableEvenCol-default">11</td><td class="ms-rteTableOddCol-default">15</td><td class="ms-rteTableEvenCol-default" style="width&#58;2%;">5R</td><td class="ms-rteTableOddCol-default" style="width&#58;2%;">Key</td><td class="ms-rteTableEvenCol-default" style="width&#58;1%;">Char</td><td class="ms-rteTableOddCol-default" style="width&#58;6%;">ETT-OLD-YRQ</td><td class="ms-rteTableEvenCol-default">The year/quarter of the older of two consecutive quarters used in the transition checks; <strong><em>yyyyq</em></strong> format; employees listed in this quarter may be able to identify predecessor relationships in the following quarter</td></tr><tr class="ms-rteTableEvenRow-default"><td class="ms-rteTableEvenCol-default">16</td><td class="ms-rteTableOddCol-default">20</td><td class="ms-rteTableEvenCol-default" style="width&#58;2%;">5R</td><td class="ms-rteTableOddCol-default" style="width&#58;2%;">Key</td><td class="ms-rteTableEvenCol-default" style="width&#58;1%;">Char</td><td class="ms-rteTableOddCol-default" style="width&#58;6%;">ETT-NEW-YRQ</td><td class="ms-rteTableEvenCol-default">Year/quarter of the newer of two consecutive quarters used in predecessor/successor transition checking; <strong><em>yyyyq</em></strong> format, which is superfluous to the new Version 8.0 standard of using 2-digit year fields; employees listed in this quarter (using the ETT-SUCC-ACCT field) may be able to identify possible successor relationships to the accounts listed in the previous quarter</td></tr><tr class="ms-rteTableOddRow-default"><td class="ms-rteTableEvenCol-default" colspan="7"><p style="text-align&#58;justify;"><span style="text-decoration&#58;underline;">Employee Transfer Transaction File</span></p><p style="text-align&#58;justify;">Data Set Name&#58;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; ES2.ETT<em>YYQ</em></p><p style="text-align&#58;justify;">Service Center DSN&#58;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; YBUssX.A145.ETT<em>YYQ</em>, ('ss' = State FIPS code)</p><p style="text-align&#58;justify;">&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; <em>YYQ</em> = newer of the two year/quarter fields for processing</p><p style="text-align&#58;justify;">Type of File&#58;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; Sequential</p><p style="text-align&#58;justify;">File Layout&#58;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160;&#160; ES2ETT</p><p style="text-align&#58;justify;">The Employee Transfer Transaction (ETT) File is a State-developed extraction file that is used by <strong>Job 62D</strong> to add or replace quarters in the multi-quarter Employment Transfer File (ES2EMPX, described previously).&#160; The short, 20-byte records denote the U-I account number association for a particular individual in two consecutive quarters.&#160; A person who stays with the same company in both quarters will show the same U-I in both 10-byte fields, whereas a part-time worker in two companies will show all possible combinations of account numbers as separate ETT records.&#160; For instance, a person who works half-time for employer 1234567890, and the rest of the time for U-I number 0987654321 would have four records produced - 1234567890-to-1234567890, 1234567890-to-0987654321, 0987654321-to-1234567890, and 0987654321-to-0987654321.&#160; When the SSN (which is never revealed to the EXPO system) is found in one of the quarters, but not the other, this employee's missing-quarter listing will show a series of 10 X's.    </p></td></tr></table>


'''Related Links'''
* [[06_account_groups_file_es2grp|Account Groups File (ES2GRP)]]
* [[06_file_record_layouts|File Record Layouts Table of Contents]]
* [[EXPO_Documentation|EXPO/EARS Documentation Home]]