KeyRecord.FieldnameFormatXLATHeading Text

ADDRESS1 - Address Line 1Char55
Address 1

ADDRESS2 - Address Line 2Char55
Address 2

ADDRESS3 - Address Line 3Char55
Address 3

ADDRESS4 - Address Line 4Char55
Address 4

ADDR_FIELD1 - Address Field 1Char2NAddress Field 1

ADDR_FIELD2 - Address Field 2Char4
Address Field 2

ADDR_FIELD3 - Address Field 3Char4
Address Field 3

BENEFIT_RCD_NBR - Benefit Record NumberNum3.0
Ben Record

BUSINESS_UNIT - Business UnitChar5
Unit

CHECK_DT - Paycheck Issue DateDate
Check Dt

CITY - CityChar30
City
COMPANY - CompanyChar3
Co

COUNTRY - CountryChar3
Country

COUNTY - CountyChar30
County

DEPTID - DepartmentChar10
Dept ID

EMPLID - Empl IDChar11
ID

EMPL_RCD - Empl RecordNum3.0
Empl Record

EMPL_TYPE - Employee TypeChar1NType

FORM_ID - Form IdentificationChar6
Form ID

GEO_CODE - Tax Vendor Geographical CodeChar11
Geo Code

GVT_ECS_LTD_INDIC - LTD Pay IndicatorChar1
LTD Indic

GVT_ECS_OFF_ACCT - Account SymbolChar16
Acct Symb

GVT_PAY_ID_LINE_1 - Payment ID Line 1Char40
Line 1

GVT_PAY_ID_LINE_2 - Payment ID Line 2Char40
Line 2

GVT_RITS_DT - RITS Pay End DateDate
RITS Pay End

GVT_SCHEDULE_NO - Schedule NumberChar14
Schedule Nbr

GVT_TSP_SEQ_NO - Voucher Seq NbrNum4.0
Seq No

GVT_TSP_SEQ_YR - TSP Voucher NumberNum2.0
Voucher Year

HOUSE_TYPE - House TypeChar2NHouse

HP_CORRECTED_DT - Corrected DateDate
Date

HP_CORRECT_STATUS - Check Corrected StatusChar1
Corrected

HR_WP_PROCESS_FLG - HR Wage Progression Processed?Char1
HR WP Process

IN_CITY_LIMIT - In City LimitChar1
In Cty Lmt
LINE_NUM - Line NbrNum3.0
Line Nbr

LOCATION - Location CodeChar10
Location

NAME - NameChar50
Name

NET_PAY - Net PaySNm10.2
Net Pay

NUM1 - Number 1Char6
Nbr 1

NUM2 - Number 2Char6
Nbr 2
OFF_CYCLE - Off Cycle ?Char1
Off Cycle
PAGE_NUM - Page NbrNum5.0
Page

PAYCHECK_ADDR_OPTN - Paycheck Address OptionChar1NAddr Opt

PAYCHECK_ADJUST - Paycheck Adjustment EntryChar1
Adjustment

PAYCHECK_CASHED - Paycheck CashedChar1
Cashed

PAYCHECK_DIST_KEY1 - Paycheck Sort Key 1Char90
Chk Sort 1

PAYCHECK_DIST_KEY2 - Paycheck Sort Key 2Char90
Chk Sort 2

PAYCHECK_NAME - Paycheck NameChar50
PaychkName

PAYCHECK_NBR - Paycheck NumberNum15.0
Check Nbr

PAYCHECK_OPTION - Paycheck OptionChar1NChk Option

PAYCHECK_REPRINT - Paycheck ReprintChar1
Reprint

PAYCHECK_STATUS - Paycheck StatusChar1NChk Status
PAYGROUP - Pay GroupChar3
Group
PAY_END_DT - Pay Period End DateDate
Pay Period End

PAY_SHEET_SRC - Source of PaysheetChar1NSrc Paysht

POSTAL - Postal CodeChar12
Postal

PROVINCE - ProvinceChar6
Province
SEPCHK - Separate Check NbrNum2.0
Sep Check Nbr

SIN - Social Insurance NbrChar9
SIN

SSN - Social Security #Char9
SSN

STATE - StateChar6
State

TOTAL_DEDUCTIONS - Total DeductionsSNm10.2
Total Ded.

TOTAL_GROSS - Total GrossSNm10.2
Tot Gross

TOTAL_TAXES - Total TaxesSNm10.2
Total Taxes

UPDATE_DT - Last UpdatedDate
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.