[{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.
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.
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