| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | JFAN8 | Address Number | Numeric | UDC | 8 | 0 | Allow NULL? |
| 2 | JFPCT# | Primary Control Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 3 | JFROEN | Serial Number - ROE | String | Generic Edit | 11 | 0 | Allow NULL? |
| 4 | JFDTM | Date - Election Form Mailed | Date | Generic Edit | 6 | 0 | |
| 5 | JFROER | Serial Number - ROE(Replacement) | String | Generic Edit | 11 | 0 | Allow NULL? |
| 6 | JFREDT | Date - Void/Reissue | Date | Generic Edit | 6 | 0 | |
| 7 | JFRTRS | ROE Work Stoppage Reason | Character | UDC (06 RT) | 1 | 0 | Allow NULL? |
| 8 | JFDT | Date - Terminated | Date | Generic Edit | 6 | 0 | |
| 9 | JFPPED | Date - Pay Period Ending | Date | Generic Edit | 6 | 0 | |
| 10 | JFPCCD | Pay Cycle Code | String | UDC (06 PY) | 5 | 0 | Allow NULL? |
| 11 | JFIPAY | Amount - Insured Earnings | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 12 | JFVPAY | Amount - Vacation Pay at Termination | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 13 | JFWDT | Date - ROE 1st Worked | Date | Generic Edit | 6 | 0 | |
| 14 | JFWKDT | Date - ROE Last Worked | Date | Generic Edit | 6 | 0 | |
| 15 | JFRCDT | Date - Employee Recall | Date | Generic Edit | 6 | 0 | |
| 16 | JFRCFG | Recall Flag | Character | UDC (07 RE) | 1 | 0 | Allow NULL? |
| 17 | JFQLWK | Weeks Worked - Qualifying | Numeric | Generic Edit | 5 | 2 | Allow NULL? |
| 18 | JFHPA1 | ROE Holiday Pay 1 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 19 | JFHLD1 | Date - ROE Holiday 1 | Date | Generic Edit | 6 | 0 | |
| 20 | JFHPA2 | ROE Holiday Pay 2 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 21 | JFHLD2 | Date - ROE Holiday 2 | Date | Generic Edit | 6 | 0 | |
| 22 | JFHPA3 | ROE Holiday Pay 3 | Numeric | Generic Edit | 11 | 2 | Allow NULL? |
| 23 | JFHLD3 | Date - ROE Holiday 3 | Date | Generic Edit | 6 | 0 | |
| 24 | JFOPA1 | ROE Ohter Pay at Termination 1 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 25 | JFOPE1 | ROE Other Pay Code 1 | String | UDC (77 OM) | 16 | 0 | Allow NULL? |
| 26 | JFOPA2 | ROE Other Pay at Termination 2 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 27 | JFOPE2 | ROE Other Pay Code 2 | String | UDC (77 OM) | 16 | 0 | Allow NULL? |
| 28 | JFOPA3 | ROE Other Pay at Termination 3 | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 29 | JFOPE3 | ROE Other Pay Code 3 | String | UDC (77 OM) | 16 | 0 | Allow NULL? |
| 30 | JFNWKD | Date - ROE Non Work Pay Start Date | Date | Generic Edit | 6 | 0 | |
| 31 | JFNWKP | Amount - Non Work Pay after Termination | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 32 | JFNWK# | # of weeks for Non Work Pay to be paid | Numeric | Generic Edit | 5 | 0 | Allow NULL? |
| 33 | JFINFG | Insurable Pay allocated to last pay per. | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 34 | JFLUID | Date - Unemployment Ins Prem payable to | Date | Generic Edit | 6 | 0 | |
| 35 | JFYST | Processed Code | Character | UDC (07 YW) | 1 | 0 | Allow NULL? |
| 36 | JFHMCO | Company - Home | String | Generic Edit | 5 | 0 | Allow NULL? |
| 37 | JFHMCU | Business Unit - Home | String | Generic Edit | 12 | 0 | Allow NULL? |
| 38 | JFSG | Last Job Worked | String | Generic Edit | 12 | 0 | Allow NULL? |
| 39 | JFUN | Union Code | String | UDC (06 UN) | 6 | 0 | Allow NULL? |
| 40 | JFJBCD | Job Type (Craft) Code | String | UDC (06 G) | 6 | 0 | Allow NULL? |
| 41 | JFJBST | Job Step | String | UDC (06 GS) | 4 | 0 | Allow NULL? |
| 42 | JFMAIL | Routing Code - Check | String | UDC (06 CR) | 10 | 0 | Allow NULL? |
| 43 | JFTARA | Tax Area (Work) | String | Generic Edit | 10 | 0 | Allow NULL? |
| 44 | JFP001 | Category Codes - Payroll1 | String | UDC (06 01) | 3 | 0 | Allow NULL? |
| 45 | JFP002 | Category Codes - Payroll2 | String | UDC (06 02) | 3 | 0 | Allow NULL? |
| 46 | JFP003 | Category Codes - Payroll3 | String | UDC (06 03) | 3 | 0 | Allow NULL? |
| 47 | JFP004 | Category Codes - Payroll4 | String | UDC (06 04) | 3 | 0 | Allow NULL? |
| 48 | JFROEF | Flag - ROE | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 49 | JFVERS | Version History | String | Generic Edit | 10 | 0 | Allow NULL? |
| 50 | JFUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 51 | JFPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 52 | JFUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 53 | JFDTSP | Date - Time Stamp | Numeric | Generic Edit | 13 | 0 | Allow NULL? |