Created by Corina C Larsen, last modified by Cori Schneider on Sep 19, 2019
Key | Record.Fieldname | Format | XLAT | Heading Text |
---|---|---|---|---|
ADDRESS1 - Address Line 1 | Char55 | Address 1 | ||
ADDRESS2 - Address Line 2 | Char55 | Address 2 | ||
ADDRESS3 - Address Line 3 | Char55 | Address 3 | ||
ADDRESS4 - Address Line 4 | Char55 | Address 4 | ||
ADDR_FIELD1 - Address Field 1 | Char2 | N | Address Field 1 | |
ADDR_FIELD2 - Address Field 2 | Char4 | Address Field 2 | ||
ADDR_FIELD3 - Address Field 3 | Char4 | Address Field 3 | ||
BENEFIT_RCD_NBR - Benefit Record Number | Num3.0 | Ben Record | ||
BUSINESS_UNIT - Business Unit | Char5 | Unit | ||
CHECK_DT - Paycheck Issue Date | Date | Check Dt | ||
CITY - City | Char30 | City | ||
→ | COMPANY - Company | Char3 | Co | |
COUNTRY - Country | Char3 | Country | ||
COUNTY - County | Char30 | County | ||
DEPTID - Department | Char10 | Dept ID | ||
EMPLID - Empl ID | Char11 | ID | ||
EMPL_RCD - Empl Record | Num3.0 | Empl Record | ||
EMPL_TYPE - Employee Type | Char1 | N | Type | |
FORM_ID - Form Identification | Char6 | Form ID | ||
GEO_CODE - Tax Vendor Geographical Code | Char11 | Geo Code | ||
GVT_ECS_LTD_INDIC - LTD Pay Indicator | Char1 | LTD Indic | ||
GVT_ECS_OFF_ACCT - Account Symbol | Char16 | Acct Symb | ||
GVT_PAY_ID_LINE_1 - Payment ID Line 1 | Char40 | Line 1 | ||
GVT_PAY_ID_LINE_2 - Payment ID Line 2 | Char40 | Line 2 | ||
GVT_RITS_DT - RITS Pay End Date | Date | RITS Pay End | ||
GVT_SCHEDULE_NO - Schedule Number | Char14 | Schedule Nbr | ||
GVT_TSP_SEQ_NO - Voucher Seq Nbr | Num4.0 | Seq No | ||
GVT_TSP_SEQ_YR - TSP Voucher Number | Num2.0 | Voucher Year | ||
HOUSE_TYPE - House Type | Char2 | N | House | |
HP_CORRECTED_DT - Corrected Date | Date | Date | ||
HP_CORRECT_STATUS - Check Corrected Status | Char1 | Corrected | ||
HR_WP_PROCESS_FLG - HR Wage Progression Processed? | Char1 | HR WP Process | ||
IN_CITY_LIMIT - In City Limit | Char1 | In Cty Lmt | ||
→ | LINE_NUM - Line Nbr | Num3.0 | Line Nbr | |
LOCATION - Location Code | Char10 | Location | ||
NAME - Name | Char50 | Name | ||
NET_PAY - Net Pay | SNm10.2 | Net Pay | ||
NUM1 - Number 1 | Char6 | Nbr 1 | ||
NUM2 - Number 2 | Char6 | Nbr 2 | ||
→ | OFF_CYCLE - Off Cycle ? | Char1 | Off Cycle | |
→ | PAGE_NUM - Page Nbr | Num5.0 | Page | |
PAYCHECK_ADDR_OPTN - Paycheck Address Option | Char1 | N | Addr Opt | |
PAYCHECK_ADJUST - Paycheck Adjustment Entry | Char1 | Adjustment | ||
PAYCHECK_CASHED - Paycheck Cashed | Char1 | Cashed | ||
PAYCHECK_DIST_KEY1 - Paycheck Sort Key 1 | Char90 | Chk Sort 1 | ||
PAYCHECK_DIST_KEY2 - Paycheck Sort Key 2 | Char90 | Chk Sort 2 | ||
PAYCHECK_NAME - Paycheck Name | Char50 | PaychkName | ||
PAYCHECK_NBR - Paycheck Number | Num15.0 | Check Nbr | ||
PAYCHECK_OPTION - Paycheck Option | Char1 | N | Chk Option | |
PAYCHECK_REPRINT - Paycheck Reprint | Char1 | Reprint | ||
PAYCHECK_STATUS - Paycheck Status | Char1 | N | Chk Status | |
→ | PAYGROUP - Pay Group | Char3 | Group | |
→ | PAY_END_DT - Pay Period End Date | Date | Pay Period End | |
PAY_SHEET_SRC - Source of Paysheet | Char1 | N | Src Paysht | |
POSTAL - Postal Code | Char12 | Postal | ||
PROVINCE - Province | Char6 | Province | ||
→ | SEPCHK - Separate Check Nbr | Num2.0 | Sep Check Nbr | |
SIN - Social Insurance Nbr | Char9 | SIN | ||
SSN - Social Security # | Char9 | SSN | ||
STATE - State | Char6 | State | ||
TOTAL_DEDUCTIONS - Total Deductions | SNm10.2 | Total Ded. | ||
TOTAL_GROSS - Total Gross | SNm10.2 | Tot Gross | ||
TOTAL_TAXES - Total Taxes | SNm10.2 | Total Taxes | ||
UPDATE_DT - Last Updated | Date | Update |
Data Dictionary Links
Clicking the linked (blue) fields in any table will take you to the Data Dictionary and provide you with more information about that field as well as field values if they are available.