[{TableOfContents }]

!!!PROCESS QUARTERLY TWC

The state of Texas requires that each employer submit employee Quarterly Wages and Wage Distribution reports. The exact requirements vary depending on the type of employer, and some reports are mandatory or optional depending on the type of employer. Personality2000 does not support all TWC (Texas Workforce Commission) requirements, since some are as simple as a single page summary on a quarterly basis. 

The reporting requirements as per the ‘Magnetic Media Reporting’ guide (July 1999) are followed. 

The two reports supported are: 
!Employer Quarterly Report 
This report provides TWC with Employee Wage details for the quarter. 

!Multiple Work Site Report (BLS3020) 
This report includes wage and work location information by work site.  All multi-location employers in Texas with a total of 10 or more employees outside their primary establishment (establishment with the largest employment) should file form BLS3020 Multiple Work Site Report 

Personality2000 provides support for submitting these two reports on magnetic media in the ICESA format. ICESA is an interstate format in a media format published by the ‘Interstate Conference of Employment Security Agencies’, TWC provides support for two other formats (TWC Tape and TWC Diskette) which are NOT supported. 

__Employer Contribution Data (C3)__ 
Employer Contribution Information is submitted at the same time as the Employer Quarterly report.  This report is presently NOT supported by Personality2000 . TWC provides for this information to be included in the same file as the Employer Quarterly Report so long as it is approved by TWC prior to submitting electronically.  The C3 must be prepared manually. 

!!Texas Workforce Commission Set Up 
 
!User Field - IMUF 
The following ‘User Field’ must be established for the ‘Assignment Details’ table.   

Although optional, this field is required for the Multiple Work Sites report.  It is recommended that this User Fields be set up each employee, even if the Multiple Work Site report is not submitted.  This User Field must be attached to the Assignment Form in the date sensitive area - IEAS. 

Establishment ID This ID is assigned is assigned by TWC for each work location, and is stored as a User Field on each Prime Assignment Detail. 
 
!Lexicon - IMLN 
The User Defined lexicon of 'X_POSITION_TYPES' must be completed with the saved value as the SIC codes that are needed. 

The User Defined lexicon of ‘X_TWC_SIC_CODE’ must be completed.  This lexicon provides the names associated with all ‘SIC Codes’ used. 
 
!Position Details - IDPS 
 
The Position Details contains the SIC code for each position indicated in the 'Position Type' field. 
SIC Code (Standard Industry Classification) is a code assigned by TWC to the reporting unit where each employee is assigned. 

The SIC code is taken from the position type of the ‘Prime’ Employee Position.  This field is used on the Multiple Work Site Report. 
 
!Tax Jurisdictions - IDTX 
TWC requires that each Tax Jurisdiction within the state of Texas be assigned a ‘State County Code’ known 
as the FIPS Code. The ‘Magnetic Reporting Media’ guide contains an appendix that lists all of these codes. 

The FIPS Code must be entered on each ‘Tax Jurisdiction’ established in the State of Texas. 
This code is required for the ‘Multiple Work Site Report’, and it is recommended that these be set up even if 
the Multiple Site report is not required. 

Assign a FIPS code to all tax jurisdictions for both state and county. 
 
!Interface Format - IDIF 

The ICESA format used for TWC can be set up using the ‘Define Interface Formats’ function IDIF. Personality2000 provides a default format HL$RPTWC that should be copied and then adjusted to suit the client specific needs. 
 
!!Process Quarterly TWC 
 
Once per quarter, the function ‘RPTWC’ must be executed to create the ‘TWC’ Report. It may include both ‘Quarterly Wages' and ‘Multi Work Site’ information.  The TWC file is also created in accordance with the IDIF entry chosen. 
 
‘Process Quarterly TWC’ Usage and Examples 

Report Parameters 
Entity 	Mandatory, LOV available 
Limits the process to the entity specified. 	
TWC Earnings Element 	Mandatory, LOV available 

Pay element that contains the earnings pay components that qualify for TWC 
Payroll Quarter (YYYQQ) Mandatory, text  
The ‘Payroll Quarter' will be used to determine which transactions to include in the report. The quarter should be entered as YYYYQQ. 
Include Multiple Work Site Mandatory, LOV available 
If you wish to include multiple work sites then indicate <Yes>. 
Include Wage Records Mandatory, LOV available 
If you wish to include wage records then indicate <Yes>. Interface Code Mandatory, LOV available Interface Directory Mandatory, text 
Must be a directory on the server for which the current user (as signed onto the client’s network) has write capability. For example the entry ‘C:\TEMP’ accesses the ‘TEMP’ directory on the server, not the local directory for the computer terminal being used. 
File Name Mandatory, text 
Enter the name of the file that will be created in the interface directory specified. 
Write or Append Mandatory, LOV available 
If the file already exists should the current information overwrite it or append to it? 
Output Header and Trailer Mandatory, LOV available 
If the file is to contain a header and trailer record then indicate <Yes>. 
Exception Level Mandatory, LOV available 
A ‘trace’ report of exception messages may be produced to assist in the testing phase. If necessary, choose from 0 – 9 (highest) level of trace. Please note that this is a voluminous report and will cause very slow performance. 
Trial Mandatory, LOV available 
The report may be run in trial mode (Yes) or update mode (No) 
 
A ‘Record of Employment’ is a pre-printed form provided by the HRDC to report employee’s Employment Insurance information. The instruction for completing ‘Record of Employment’ is provided in the booklet called ‘How to Complete the Record of Employment (ROE) Form’. 
The ROE Form supported is INS-2106-09-98E. 
The ROE process within Personality2000 will allow users to report employees' Record of Employment information according to user selection criteria to generate a file for the import into the government ROELaser.exe print program. 
Please refer to the government Web site for ROE Laser program details.   
 http://www.hrdc-drhc.gc.ca/ae-ei/pubs/guide.shtml  
ROE Set Up 
 
User Fields 
If ROE Amend Serial #, Box 17 and 19 are to be used, set up the following User Fields in IMUF for 
P2K_HR_EMPLOYMENTS. 
 
User Fields on Employment 
If an employee requires Box 17 and/or 19 to be reported on the ROE, enter the appropriate values in the User Fields attached to the Employment (IEEI) form. 
 
ROE Fields on Employment 
 
 
 
ROE Status 
00 	Not Required 
01 	ROE Required/Request 	Will be picked up by UPROE 
02 	ROE Issued 	Updated by UPROE 
03 	Duplicate Requested 	Will be picked up by UPROE 
04 	Duplicate Issued 	Updated by UPROE 

ROE Issue Date 
Updated by UPROE 
ROE Letter 
Updated by UPROE to the ROE Letter of the Termination Reason (IDTR) for the employee. 
 
Form Definition Variables 
 
 
 
Field Identifier 	Description 	Suggested Field 	Source/Constant 
ROE-FILE-HEADER 	File Header 	Constant 	PDFSProe 
ROE-SOFTWARE-VERS 	Major and Minor Software Version 	Constant 	0300 
ROE-SOFTWARE-REV 	Software Revision 	Constant 	000 
ROE-PRINT-LANG 	Language used to print ROE 	Data Base Column 	EID.LANGUAGE_CODE or Constant E or F 
ROE-REFERENCE1 	Employer’s Payroll Reference 1 	Data Base Column 	PPA.PAYROLL_CODE 
ROE-REFERENCE2 	Employer’s Payroll Reference 2 	Data Base Column 	EID.PERSON_CODE 
ROE-ER-MAIL-ADDR 	Use Employer Mailing Address 	Constant 	Y or N 
ROE-EE-MAIL-ADDR 	Use Employee Mailing Address 	Constant 	Y or N 
ROE-1ST-DAY-WORK 	First Day Worked 	Data Base Column 	EEM.FIRST_WORK_DATE 
ROE-LAST-DAY-PAID 	Last Day For Which Paid 	Data Base Column 	EEM.LAST_WORK_DATE 
ROE-FINAL-PER-END 	Final Pay Period End Date 	Data Base Column 	PPP.PAY_PERIOD_END_DATE 
ROE-OCCUPATION 	Occupation Description 	Data Base Column 	EASD.ASSIGNMENT_TITLE 
ROE-RECALL-DATE 	Expected Date of Recall 	Data Base Column 	EEM.EXPECTED_RETURN_DATE 
ROE-RECALL-CODE 	Expected Recall Code 	Data Base Column 	EEM.REHIRE_STATUS 
ROE-REASON 	Reason for ROE issue 	Constant 	DTR.ROE_LETTER 
ROE-CONT-NAME 	Contact name 	Constant 	Enter your company data 
ROE-CONT-TEL-AREA 	Contact Phone Area Code 	Constant 	Enter your company data 
ROE-CONT-TEL 	Contact Phone Number 	Constant 	Enter your company data 

 
 
Field Identifier 	Description 	Suggested Field 	Source/Constant 
ROE-CONT-TEL-EXT 	Contact Phone Extension 	Constant 	Enter your company data 
ROE-MONEY-PAID 	Moneys paid on Separation 	Constant 	Y or N 
ROE-VACN-CODE 	Vacation Pay Code 	Constant 	Enter a Constant e.g. A, B, … V etc. Or the constant ‘ROE VACN CODE’ which points to the EEM user field ‘ROE VACN CODE’ 
ROE-VACN-AMT 	Vacation Pay Amount 	Element 	ROE-BOX-17-VACN 
ROE-STATHOL1-CODE 	Statutory Holiday 1 Code 	Constant 	Enter a Constant e.g. A, B, … V etc. Or the constant ‘ROE STATHOL1 CODE’ which points to the EEM user field ‘ROE STATHOL1 CODE’ 
ROE-STATHOL1-DATE 	Statutory Holiday 1 Date 	Constant 	Enter a Date Constant e.g. 24-May-2000  Or the constant ‘ROE STATHOL1 DATE’ which points to the EEM user field ‘ROE STATHOL1 DATE’ 
ROE-STATHOL1-AMT 	Statutory Holiday 1 Amount 	Element 	ROE-BOX-17-STAT1 
ROE-STATHOL2-CODE 	Statutory Holiday 2 Code 	Constant 	Enter a Constant e.g. A, B, … V etc. Or the constant ‘ROE STATHOL2 CODE’ which points to the EEM user field ‘ROE STATHOL2 CODE’ 
ROE-STATHOL2-DATE 	Statutory Holiday 2 Date 	Constant 	Enter a Date Constant e.g. 01-Jul-2000 Or the constant ‘ROE STATHOL2 DATE’ which points to the EEM user field ‘ROE STATHOL2 DATE’ 
ROE-STATHOL2-AMT 	Statutory Holiday 2 Amount 	Element 	ROE-BOX-17-STAT2 
ROE-STATHOL3-CODE 	Statutory Holiday 3 Code 	Constant 	Enter a Constant e.g. A, B, … V etc. Or the constant ‘ROE STATHOL3 CODE’ which points to the EEM user field ‘ROE STATHOL3 CODE’ 
ROE-STATHOL3-DATE 	Statutory Holiday 3 Date 	Constant 	Enter a Date Constant e.g. 24-May-2000 Or the constant ‘ROE STATHOL3 DATE’ which points to the EEM user field ‘ROE STATHOL3 DATE’ 
ROE-STATHOL3-AMT 	Statutory Holiday 3 Amount 	Element 	ROE-BOX-17-STAT3 
ROE-OTHER1-DESC 	Other Money 1 Description 	Constant 	Enter a Constant description Or the constant ‘ROE OTHER1 DESC’ which points to the EEM user field ‘ROE OTHER1 DESC’ 
ROE-OTHER1-AMT 	Other Money 1 Amount 	Element 	ROE-BOX-17-OTH1 

 
 
Field Identifier 	Description 	Suggested Field 	Source/Constant 
ROE-OTHER2-DESC 	Other Money 2 Description 	Constant 	Enter a Constant description Or the constant ‘ROE OTHER2 DESC’ which points to the EEM user field ‘ROE OTHER2 DESC’ 
ROE-OTHER2-AMT 	Other Money 2 Amount 	Element 	ROE-BOX-17-OTH2 
ROE-OTHER3-DESC 	Other Money 3 Description 	Constant 	Enter a Constant description Or the constant ‘ROE OTHER3 DESC’ which points to the EEM user field ‘ROE OTHER3 DESC’ 
ROE-OTHER3-AMT 	Other Money 3 Amount 	Element 	ROE-BOX-17-OTH3 
ROE-COMMENTS 	ROE Comments Line 	Data Base Column 	EEM.ROE_COMMENTS or constant 
ROE-SICK-LV-DATE 	Paid Sick or Parental Leave Date 	Constant 	Enter a Date Constant e.g. 01-Aug-2000 Or the constant ‘ROE SICK LV DATE’ which points to the EEM user field ‘ROE SICK LV DATE’ 
ROE-SICK-LV-AMT 	Paid Sick or Parental Leave Amt 	Element 	ROE-SICK-LV-AMT 
ROE-SICK-LV-PER 	Paid Sick or Parental Per Day or Week 	Constant 	D or W 
ROE-ER-LANG 	Correspondence Language 	Constant 	E or F 
ROE-ISSUER-TEL-AREA 	Issuer Phone Area Code 	Constant 	Enter your company data 
ROE-ISSUER-TEL 	Issuer Phone Number 	Constant 	Enter your company data 
ROE-ISSUER-TEL-EXT 	Issuer Phone Extension 	Constant 	Enter your company data 
ROE-ISSUER-NAME 	Issuer Name 	Constant 	Enter your company data 

 
 
Produce Record of Employment 
The UPROE function produces a file that is then used by the ‘ROELase.exe’ program obtained from HRDC. 
 
 
 
 
‘Produce Record of Employment’ Highlights 
‘Produce Record of Employment’ may be found through the menu bar: 
 
The form may also be accessed through the command with ‘UPROE’. 
UPROE allows the user to select employees to print the Record of Employment form. 
UPROE parameter screen allows the user to select employees by ‘Employment Status’ and ‘Termination