Data Archive Reporting fields

These tables shows the attribute and measure names and their fields from the Lawson source tables:

HR 11- Employee

Attribute or measure name Table field Archive source table
Company COMPANY EMPLOYEE
Employee EMPLOYEE EMPLOYEE
Activity ACTIVITY EMPLOYEE
Employee Name LAST_NAME EMPLOYEE
Account Category ACCT_CATEGORY EMPLOYEE
Add Allowance Amount ADD_ALLOW_AMT EMPLOYEE
Add Allowance Hours ADD_ALLOW_HRS EMPLOYEE
Add Allowance Per ADD_ALLOW_PER EMPLOYEE
Address 1 ADDR1 EMPLOYEE
Address 2 ADDR2 EMPLOYEE
Address 3 ADDR3 EMPLOYEE
Adjusted Hire Date ADJ_HIRE_DATE EMPLOYEE
Alternate Rate Exist ALT_RATE_EXIST EMPLOYEE
Anniversary Date ANNIVERS_DATE EMPLOYEE
Auto Time Record AUTO_TIME_REC EMPLOYEE
Automatic Deposit AUTO_DEPOSIT EMPLOYEE
BSI Group BSI_GROUP EMPLOYEE
Bus Number Group BUS_NBR_GRP EMPLOYEE
City CITY EMPLOYEE
Country Code COUNTRY_CODE EMPLOYEE
Creation Date CREATION_DATE EMPLOYEE
Currency Code CURRENCY_CODE EMPLOYEE
Date Hired DATE_HIRED EMPLOYEE
Deceased DECEASED EMPLOYEE
Department DEPARTMENT EMPLOYEE
Effort Flag EFFORT_FLAG EMPLOYEE
EIC Status EIC_STATUS EMPLOYEE
Email Address EMAIL_ADDRESS EMPLOYEE
Employee OT Exempt EXEMPT_EMP EMPLOYEE
Employee Status EMP_STATUS EMPLOYEE
Encumber Flag ENCUMBER_FLAG EMPLOYEE
Est Remuneration EST_REMUN EMPLOYEE
First Name FIRST_NAME EMPLOYEE
First Name UC FIRST_NAME_UC EMPLOYEE
Fringe Account FRNG_ACCOUNT EMPLOYEE
Fringe Account Category FRNG_ACCT_CAT EMPLOYEE
Fringe Sub Account FRNG_SUB_ACCT EMPLOYEE
Fringe Rate FRNG_RATE EMPLOYEE
FTE Number NBR_FTE EMPLOYEE
FTE Total FTE_TOTAL EMPLOYEE
HICN HICN EMPLOYEE
Home Account HM_ACCOUNT EMPLOYEE
Home Acct Unit HM_ACCT_UNIT EMPLOYEE
Home Sub Account HM_SUB_ACCT EMPLOYEE
Home Dist Company HM_DIST_CO EMPLOYEE
HR11EmployeeKey COMPANY EMPLOYEE
Indirect Supervisor SUPERVISOR_IND EMPLOYEE
Job Code JOB_CODE EMPLOYEE
Labor Distribution Flag LAB_DIST_FLAG EMPLOYEE
Last Comment Sequence Number LAST_CMT_SEQ EMPLOYEE
Last Day Paid LAST_DAY_PAID EMPLOYEE
Last Deduction Sequence Number LAST_DED_SEQ EMPLOYEE
Last Name LAST_NAME EMPLOYEE
Last Name UC LAST_NAME_UC EMPLOYEE
Max Limit Override MAX_LIMIT_OVRD EMPLOYEE
Middle Initial MIDDLE_INIT EMPLOYEE
Middle Name MIDDLE_NAME EMPLOYEE
Moving Expenses MOVING_EXP EMPLOYEE
Name Prefix NAME_PREFIX EMPLOYEE
Name Suffix NAME_SUFFIX EMPLOYEE
New Hire Date NEW_HIRE_DATE EMPLOYEE
Nick Name NICK_NAME EMPLOYEE
OT Plan Code OT_PLAN_CODE EMPLOYEE
Pay Frequency PAY_FREQUENCY EMPLOYEE
Pay Grade PAY_GRADE EMPLOYEE
Pay Step PAY_STEP EMPLOYEE
Pending Action Date PEND_ACT_DATE EMPLOYEE
Personal Email EMAIL_PERSONAL EMPLOYEE
Pin PIN EMPLOYEE
Position R_POSITION EMPLOYEE
Primary Certifier Company PRMCERT_COMP EMPLOYEE
Primary Certifier ID PRMCERT_ID EMPLOYEE
Process Level PROCESS_LEVEL EMPLOYEE
Public Sector Retirement PUB_SEC_RETIRE EMPLOYEE
Quebec Enterprise Number Group QC_ENT_NBR_GRP EMPLOYEE
Railroad code RAILROAD_CODE EMPLOYEE
Remote REMOTE EMPLOYEE
Reportable Insurance Cost RPT_INS_COST EMPLOYEE
Reporting Currency RPT_CURR EMPLOYEE
Salary Class SALARY_CLASS EMPLOYEE
Schedule SCHEDULE EMPLOYEE
Secondary Certifier ID SNDCERT_ID EMPLOYEE
Secondary Certifier Company SNDCERT_COMP EMPLOYEE
Security Level SEC_LVL EMPLOYEE
Security Location SEC_LOCATION EMPLOYEE
Shift SHIFT EMPLOYEE
Sick Pay SICK_PAY EMPLOYEE
Social Security Number FICA_NBR EMPLOYEE
SSN Last4 FICA_NBR_LAST4 EMPLOYEE
ST Status ST_STATUS EMPLOYEE
State STATE EMPLOYEE
Supervisor SUPERVISOR EMPLOYEE
Tax City TAX_CITY EMPLOYEE
Tax County TAX_COUNTY EMPLOYEE
Tax Province TAX_PROVINCE EMPLOYEE
Tax School TAX_SCHOOL EMPLOYEE
Tax State TAX_STATE EMPLOYEE
Tax Transport TAX_TRANSPORT EMPLOYEE
Term Date TERM_DATE EMPLOYEE
Tipped TIPPED EMPLOYEE
Union Code UNION_CODE EMPLOYEE
Updated By LTM UPDATED_BY_LTM EMPLOYEE
User Level USER_LEVEL EMPLOYEE
Warn Flag WARN_FLAG EMPLOYEE
WC State WC_STATE EMPLOYEE
WC Province WC_PROVINCE EMPLOYEE
Work County WORK_COUNTY EMPLOYEE
Work City WORK_CITY EMPLOYEE
Work School WORK_SCHOOL EMPLOYEE
Work Transport WORK_TRANSPORT EMPLOYEE
Work County WORK_COUNTY EMPLOYEE
Work Schedule WORK_SCHED EMPLOYEE
Zip ZIP EMPLOYEE
First Day Worked FST_DAY_WORKED EMPLOYEE
Process Level PROCESS_LEVEL EMPLOYEE
Last Prefix LAST_NAME_PRE EMPLOYEE
Last Prefix Suffix LAST_NAME_PRE EMPLOYEE
First Middle Initial FIRST_NAME EMPLOYEE
Last Suffix LAST_NAME EMPLOYEE
Annual Hours ANNUAL_HOURS EMPLOYEE
Emp Business Expense Amount EBE_AMOUNT EMPLOYEE
Pay Rate PAY_RATE EMPLOYEE
Pro rate Salary PRO_RATE_A_SAL EMPLOYEE
Pro rate Total PRO_RATE_TOTAL EMPLOYEE
Stand Amount STAND_AMT EMPLOYEE
Stand Hours STAND_HOURS EMPLOYEE

HR13-Employee Dependent

Attribute or measure name Table field Archive source table
Company COMPANY EMDEPEND
Employee EMPLOYEE EMDEPEND
Activity ACTIVITY EMDEPEND
Employee Name LAST_NAME EMDEPEND
Account Category ACCT_CATEGORY EMDEPEND
Add Allowance Amount ADD_ALLOW_AMT EMDEPEND
Add Allowance Hours ADD_ALLOW_HRS EMDEPEND
Add Allowance Per ADD_ALLOW_PER EMDEPEND
Address 1 ADDR1 EMDEPEND
Address 2 ADDR2 EMDEPEND
Address 3 ADDR3 EMDEPEND
Adjusted Hire Date ADJ_HIRE_DATE EMDEPEND
Alternate Rate Exist ALT_RATE_EXIST EMDEPEND
Anniversary Date ANNIVERS_DATE EMDEPEND
Auto Time Record AUTO_TIME_REC EMDEPEND
Automatic Deposit AUTO_DEPOSIT EMDEPEND
BSI Group BSI_GROUP EMDEPEND
Bus Number Group BUS_NBR_GRP EMDEPEND
City CITY EMDEPEND
Country Code COUNTRY_CODE EMDEPEND
Creation Date CREATION_DATE EMDEPEND
Currency Code CURRENCY_CODE EMDEPEND
Date Hired DATE_HIRED EMDEPEND
Deceased DECEASED EMDEPEND
Department DEPARTMENT EMDEPEND
Effort Flag EFFORT_FLAG EMDEPEND
EIC Status EIC_STATUS EMDEPEND
Email Address EMAIL_ADDRESS EMDEPEND
Employee OT Exempt EXEMPT_EMP EMDEPEND
Employee Status EMP_STATUS EMDEPEND
Encumber Flag ENCUMBER_FLAG EMDEPEND
Est Remuneration EST_REMUN EMDEPEND
First Name FIRST_NAME EMDEPEND
First Name UC FIRST_NAME_UC EMDEPEND
Fringe Account FRNG_ACCOUNT EMDEPEND
Fringe Account Category FRNG_ACCT_CAT EMDEPEND
Fringe Sub Account FRNG_SUB_ACCT EMDEPEND
Fringe Rate FRNG_RATE EMDEPEND
FTE Number NBR_FTE EMDEPEND
FTE Total FTE_TOTAL EMDEPEND
HICN HICN EMDEPEND
Home Account HM_ACCOUNT EMDEPEND
Home Acct Unit HM_ACCT_UNIT EMDEPEND
Home Sub Account HM_SUB_ACCT EMDEPEND
Home Dist Company HM_DIST_CO EMDEPEND
Indirect Supervisor SUPERVISOR_IND EMDEPEND
Job Code JOB_CODE EMDEPEND
Labor Distribution Flag LAB_DIST_FLAG EMDEPEND
Last Comment Sequence Number LAST_CMT_SEQ EMDEPEND
Last Day Paid LAST_DAY_PAID EMDEPEND
Last Deduction Sequence Number LAST_DED_SEQ EMDEPEND
Last Name LAST_NAME EMDEPEND
Last Name UC LAST_NAME_UC EMDEPEND
Max Limit Override MAX_LIMIT_OVRD EMDEPEND
Middle Initial MIDDLE_INIT EMDEPEND
Middle Name MIDDLE_NAME EMDEPEND
Moving Expenses MOVING_EXP EMDEPEND
Name Prefix NAME_PREFIX EMDEPEND
Name Suffix NAME_SUFFIX EMDEPEND
New Hire Date NEW_HIRE_DATE EMDEPEND
Nick Name NICK_NAME EMDEPEND
OT Plan Code OT_PLAN_CODE EMDEPEND
Pay Frequency PAY_FREQUENCY EMDEPEND
Pay Grade PAY_GRADE EMDEPEND
Pay Step PAY_STEP EMDEPEND
Pending Action Date PEND_ACT_DATE EMDEPEND
Personal Email EMAIL_PERSONAL EMDEPEND
Pin PIN EMDEPEND
Position R_POSITION EMDEPEND
Primary Certifier Company PRMCERT_COMP EMDEPEND
Primary Certifier ID PRMCERT_ID EMDEPEND
Process Level PROCESS_LEVEL EMDEPEND
Public Sector Retirement PUB_SEC_RETIRE EMDEPEND
Quebec Enterprise Number Group QC_ENT_NBR_GRP EMDEPEND
Railroad code RAILROAD_CODE EMDEPEND
Remote REMOTE EMDEPEND
Reportable Insurance Cost RPT_INS_COST EMDEPEND
Reporting Currency RPT_CURR EMDEPEND
Salary Class SALARY_CLASS EMDEPEND
Schedule SCHEDULE EMDEPEND
Secondary Certifier ID SNDCERT_ID EMDEPEND
Secondary Certifier Company SNDCERT_COMP EMDEPEND
Security Level SEC_LVL EMDEPEND
Security Location SEC_LOCATION EMDEPEND
Shift SHIFT EMDEPEND
Sick Pay SICK_PAY EMDEPEND
Social Security Number FICA_NBR EMDEPEND
SSN Last4 FICA_NBR_LAST4 EMDEPEND
ST Status ST_STATUS EMDEPEND
State STATE EMDEPEND
Supervisor SUPERVISOR EMDEPEND
Tax City TAX_CITY EMDEPEND
Tax County TAX_COUNTY EMDEPEND
Tax Province TAX_PROVINCE EMDEPEND
Tax School TAX_SCHOOL EMDEPEND
Tax State TAX_STATE EMDEPEND
Tax Transport TAX_TRANSPORT EMDEPEND
Term Date TERM_DATE EMDEPEND
Tipped TIPPED EMDEPEND
Union Code UNION_CODE EMDEPEND
Updated By LTM UPDATED_BY_LTM EMDEPEND
User Level USER_LEVEL EMDEPEND
Warn Flag WARN_FLAG EMDEPEND
WC State WC_STATE EMDEPEND
WC Province WC_PROVINCE EMDEPEND
Work County WORK_COUNTY EMDEPEND
Work City WORK_CITY EMDEPEND
Work School WORK_SCHOOL EMDEPEND
Work Transport WORK_TRANSPORT EMDEPEND
Work County WORK_COUNTY EMDEPEND
Work Schedule WORK_SCHED EMDEPEND
Zip ZIP EMDEPEND
First Day Worked FST_DAY_WORKED EMDEPEND
Process Level PROCESS_LEVEL EMDEPEND
Last Prefix LAST_NAME_PRE EMDEPEND
Last Prefix Suffix LAST_NAME_PRE EMDEPEND
First Middle Initial FIRST_NAME EMDEPEND
Last Suffix LAST_NAME EMDEPEND

PA12-Employee Emergency Contact

Attribute or measure name Table field Archive source table
Company Company PAEMERGCNT
Employee EMPLOYEE PAEMERGCNT
Sequence Number SEQ_NBR PAEMERGCNT
Last Name LAST_NAME PAEMERGCNT
First Name FIRST_NAME PAEMERGCNT
Contact Name Derived Field PAEMERGCNT
Middle Initial MIDDLE_INIT PAEMERGCNT
Address 1 ADDR1 PAEMERGCNT
Address 2 ADDR2 PAEMERGCNT
Address 3 ADDR3 PAEMERGCNT
Address 4 ADDR4 PAEMERGCNT
City CITY PAEMERGCNT
State STATE PAEMERGCNT
ZIP ZIP PAEMERGCNT
Relationship RELATIONSHIP PAEMERGCNT
Home Phone Country HM_PHONE_CNTRY PAEMERGCNT
Home Phone Number HM_PHONE_NBR PAEMERGCNT
Work Phone Number WK_PHONE_NBR PAEMERGCNT
Work Phone Country WK_PHONE_CNTRY PAEMERGCNT
Work Phone Extension WK_PHONE_EXT PAEMERGCNT
Phone Country CL_PHONE_CNTRY PAEMERGCNT
Phone Number CL_PHONE_NBR PAEMERGCNT
Country Code COUNTRY_CODE PAEMERGCNT
Last Updated Date DATE_STAMP PAEMERGCNT
Time Stamp TIME_STAMP PAEMERGCNT
User Id USER_ID PAEMERGCNT

PA 13.2- Multiple Position

Attribute or measure name Table field Archive source table
Company COMPANY PAEMPPOS
Employee EMPLOYEE PAEMPPOS
Position R_POSITION PAEMPPOS
Position Level POS_LEVEL PAEMPPOS
FTE Number FTE PAEMPPOS
Effect Date EFFECT_DATE PAEMPPOS
End Date END_DATE PAEMPPOS
Job Code JOB_CODE PAEMPPOS
Process Level PROCESS_LEVEL PAEMPPOS
Department DEPARTMENT PAEMPPOS
User Level USER_LEVEL PAEMPPOS
Location Code LOCAT_CODE PAEMPPOS
Supervisor SUPERVISOR PAEMPPOS
Supervisor Indirect SUPERVISOR_IND PAEMPPOS
Date Assign DATE_ASSIGN PAEMPPOS
Work Schedule WORK_SCHED PAEMPPOS
Schedule SCHEDULE PAEMPPOS
Pay Grade PAY_GRADE PAEMPPOS
Pay Step PAY_STEP PAEMPPOS
Expense Company EXP_COMPANY PAEMPPOS
Expense Acct Unit EXP_ACCT_UNIT PAEMPPOS
Expense Account EXP_ACCOUNT PAEMPPOS
Expense Sub Account EXP_SUB_ACCT PAEMPPOS
Activity ACTIVITY PAEMPPOS
Account Category ACCT_CATEGORY PAEMPPOS
Position Effective Date POS_EFF_DT PAEMPPOS
Last Updated Date DATE_STAMP PAEMPPOS
Time Stamp TIME_STAMP PAEMPPOS
User Id USER_ID PAEMPPOS
Currency Code CURRENCY_CODE PAEMPPOS
Currency Nd CURR_ND PAEMPPOS
Base Currency BASE_CURRENCY PAEMPPOS
Base Nd BASE_ND PAEMPPOS
Bargain Unit BARGAIN_UNIT PAEMPPOS
Union Code UNION_CODE PAEMPPOS
PEP Pay Rate PAY_RATE PAEMPPOS
PEP Annual Hours ANNUAL_HOURS PAEMPPOS
Prorated Salary PRO_RATE_A_SAL PAEMPPOS
Base Pay Rate BASE_PAY_RATE PAEMPPOS
User Amount USER_AMOUNT PAEMPPOS

PA15.2 - Employee Medical-Work Codes

Attribute or measure name Table field Archive source table
Company COMPANY PAMEDICAL
Employee EMPLOYEE PAMEDICAL
Type TYPE PAMEDICAL
Code CODE PAMEDICAL
Begin Date BEG_DATE PAMEDICAL
End Date END_DATE PAMEDICAL
Sequence Number SEQ_NBR PAMEDICAL
Create Date CREATE_DATE PAMEDICAL
Create Time CREATE_TIME PAMEDICAL
Create User Id CREATE_USER_ID PAMEDICAL
Last Updated Date DATE_STAMP PAMEDICAL
Time Stamp TIME_STAMP PAMEDICAL
User Id USER_ID PAMEDICAL

PA Employee codes

Attribute or measure name Table field Archive source table
Acquired Date DATE_ACQUIRED EMPCODES
Asset Number PA_ASSET_NBR EMPCODES
Base Currency BASE_CURRENCY EMPCODES
Base Nd BASE_ND EMPCODES
Co Sponsored CO_SPONSORED EMPCODES
Company COMPANY EMPCODES
Component COMPONENT EMPCODES
Currency Code CURRENCY_CODE EMPCODES
Currency Nd CURR_ND EMPCODES
Description DESCRIPTION EMPCODES
Employee EMPLOYEE EMPCODES
In Process Flag IN_PRO_FLAG EMPCODES
Instructor INSTRUCTOR EMPCODES
LIC Number LIC_NUMBER EMPCODES
Object Identifier OBJ_ID EMPCODES
State STATE EMPCODES
Employee Applicant Indicator EMP_APP EMPCODES
Per Rating PER_RATING EMPCODES
Priority Code PRIORITY_CODE EMPCODES
Proficiency Level PROFIC_LEVEL EMPCODES
Renew Date RENEW_DATE EMPCODES
Renewal Code RENEWAL_CODE EMPCODES
Returned Date DATE_RETURNED EMPCODES
Sequence Number SEQ_NBR EMPCODES
Skill Source SKILL_SOURCE EMPCODES
Subject SUBJECT EMPCODES
Type TYPE EMPCODES
User ID USER_ID EMPCODES
Verified Flag VERIFIED_FLAG EMPCODES
Base Amount BASE_AMOUNT EMPCODES
Cost COST EMPCODES
Property Value PROP_VALUE EMPCODES

PA 26- Employee Performance Review

Attribute or measure name Table field Archive source table
Review Date ACTUAL_DATE REVIEW
Reviewer BY_EMPLOYEE REVIEW
Review Type CODE REVIEW
Company COMPANY REVIEW
Last Updated Date DATE_STAMP REVIEW
Employee EMPLOYEE REVIEW
First Name FIRST_NAME REVIEW
Last Name LAST_NAME REVIEW
Last Review Date LAST_REVIEW REVIEW
Middle Initial MIDDLE_INIT REVIEW
Next Review Date NEXT_REVIEW REVIEW
Next Review Type NEXT_REV_CODE REVIEW
Rating RATING REVIEW
Review Schedule REV_SCHEDULE REVIEW
Scheduled Review Date SCHED_DATE REVIEW
Sequence Number SEQ_NBR REVIEW
Time Stamp TIME_STAMP REVIEW
User Id USER_ID REVIEW
Description DESCRIPTION REVIEW
Goal Score GOAL_SCORE REVIEW
Goal Weighting GOAL_WEIGHTING REVIEW
Percentile PERCENTILE REVIEW
Performance Score PERF_SCORE REVIEW
Performance Weighting PERF_WEIGHTING REVIEW
Total Score TOTAL_SCORE REVIEW

PA 54- Personnel Action History

Attribute or measure name Table field Archive source table
Company COMPANY PERSACTHST
Action Code ACTION_CODE PERSACTHST
Effect Date EFFECT_DATE PERSACTHST
Action Number ACTION_NBR PERSACTHST
Employee EMPLOYEE PERSACTHST
Anticipated End Date ANT_END_DATE PERSACTHST
User Id USER_ID PERSACTHST
Last Updated Date DATE_STAMP PERSACTHST
Action Type ACTION_TYPE PERSACTHST
Object Id OBJ_ID PERSACTHST
Reason 01 REASON_01 PERSACTHST
Reason 02 REASON_02 PERSACTHST
Position Level POS_LEVEL PERSACTHST
Error Flag ERROR_FLAG PERSACTHST

PA 67- Employee Rate History

Attribute or measure name Table field Archive source table
Company COMPANY PRRATEHIST
Employee EMPLOYEE PRRATEHIST
Begin Date BEG_DATE PRRATEHIST
Sequence Number SEQ_NBR PRRATEHIST
Actual Obj Id ACT_OBJ_ID PRRATEHIST
User Id USER_ID PRRATEHIST
Last Updated Date DATE_STAMP PRRATEHIST
Time Stamp TIME_STAMP PRRATEHIST
Salary Class SALARY_CLASS PRRATEHIST
Position Level POS_LEVEL PRRATEHIST
Currency Code CURRENCY_CODE PRRATEHIST
Currency Nd CURR_ND PRRATEHIST
Base Currency BASE_CURRENCY PRRATEHIST
Base Nd BASE_ND PRRATEHIST
FTE Number NBR_FTE PRRATEHIST
Pay Rate PAY_RATE PRRATEHIST
Annual Salary ANNUAL_SALARY PRRATEHIST
Base Pay Rate BASE_PAY_RATE PRRATEHIST
Annual Hours ANNUAL_HOURS PRRATEHIST

PR12- Bank Details

Attribute or measure name Table field Archive source table
Account EBNK_ACCT_NBR EMACHDEPST
Account Type ACCOUNT_TYPE EMACHDEPST
ACH Distribution Number ACH_DIST_NBR EMACHDEPST
Bank DESCRIPTION EMACHDEPST
Begin Date BEG_DATE EMACHDEPST
Company COMPANY EMACHDEPST
Country COUNTRY_CODE EMACHDEPST
Deduction Cycle 01 DED_CYCLE_01 EMACHDEPST
Deduction Cycle 02 DED_CYCLE_02 EMACHDEPST
Deduction Cycle 03 DED_CYCLE_03 EMACHDEPST
Deduction Cycle 04 DED_CYCLE_04 EMACHDEPST
Deduction Cycle 05 DED_CYCLE_05 EMACHDEPST
Deduction Cycle 06 DED_CYCLE_06 EMACHDEPST
Deduction Cycle 07 DED_CYCLE_07 EMACHDEPST
Deduction Cycle 08 DED_CYCLE_08 EMACHDEPST
Deduction Cycle 09 DED_CYCLE_09 EMACHDEPST
Default ACH Account DEFAULT_FLAG EMACHDEPST
Distribution Order ACH_DIST_ORDER EMACHDEPST
Employee EMPLOYEE EMACHDEPST
End Date END_DATE EMACHDEPST
Payables To PAYABLE_TO EMACHDEPST
Payment Description CHECK_DESC EMACHDEPST
Prenotify Status ACH_PRENOTIFY EMACHDEPST
Receiving DFI EBANK_ID EMACHDEPST
Automatic Deposit AUTO_DEPOSIT EMPLOYEE
Flat Amount DEPOSIT_AMT EMACHDEPST
Percent of Net NET_PERCENT EMACHDEPST
Flat Amount DEPOSIT_AMT EMACHDEPST
Percent of Net NET_PERCENT EMACHDEPST

PR14- Deductions

Attribute or measure name Table field Archive source table
Arrears ARREARS EMDEDMASTR
Balance Type BALANCE_TYPE EMDEDMASTR
Calculation Type CALC_TYPE DEDCODE
Company COMPANY EMDEDMASTR
Country COUNTRY_CODE DEDCODE
Deduction Code DED_CODE EMDEDMASTR
Deduction Cycle 01 DED_CYCLE_01 EMDEDMASTR
Deduction Cycle 02 DED_CYCLE_02 EMDEDMASTR
Deduction Cycle 03 DED_CYCLE_03 EMDEDMASTR
Deduction Cycle 04 DED_CYCLE_04 EMDEDMASTR
Deduction Cycle 05 DED_CYCLE_05 EMDEDMASTR
Deduction Cycle 06 DED_CYCLE_06 EMDEDMASTR
Deduction Cycle 07 DED_CYCLE_07 EMDEDMASTR
Deduction Cycle 08 DED_CYCLE_08 EMDEDMASTR
Deduction Cycle 09 DED_CYCLE_09 EMDEDMASTR
Deduction Priority DED_PRIORITY EMDEDMASTR
Employee EMPLOYEE EMDEDMASTR
End Date END_DATE EMDEDMASTR
Formula Number FORMULA_NUMBER EMDEDMASTR
Payment Description CHECK_DESC DEDCODE
Sequence Number SEQ_NBR EMDEDMASTR
Effective Date EFFECT_DATE EMDEDMASTR
Amount NEXT_AMOUNT EMDEDMASTR
Additional Amount AMOUNT_2 EMDEDMASTR
Exclude Amount EXCLUDE_AMT EMDEDMASTR
Internal Amount BALANCE_AMT EMDEDMASTR
Monthly Limit MONTHLY_LIMIT EMDEDMASTR
Pay Period Limit PAY_PRD_LIMIT EMDEDMASTR

PR26- Garnishments

Attribute or measure name Table field Archive source table
Company COMPANY PREMPGARN
Employee EMPLOYEE PREMPGARN
Case Number CASE_NUMBER PREMPGARN
File Number FILE_NUMBER PREMPGARN
Description R_DESC PREMPGARN
Tax ID Code TAX_ID_CODE PREMPGARN
Type TYPE PREMPGARN
Deduction Code DED_CODE PREMPGARN
Sequence Number SEQ_NBR PREMPGARN
Fees Deduction Code FEES_DED_CODE PREMPGARN
Fees Sequence Number FEES_SEQ_NBR PREMPGARN
Fees Override FEES_OVERRIDE PREMPGARN
EGM Clearhouse Fee CLEARHOUSE_FEE PREMPGARN
Number of Dependents NUM_OF_DEP PREMPGARN
Second Family SND_FAMILY PREMPGARN
Head of Family HEAD_OF_FAM PREMPGARN
EGM Original Balance ORIG_BALANCE PREMPGARN
Vendor VENDOR PREMPGARN
EGM Amount NEXT_AMOUNT EMDEDMASTR
EGM Monthly Limit MONTHLY_LIMIT EMDEDMASTR
EGM Amount 2 AMOUNT_2 EMDEDMASTR
EGM Exclude Amount EXCLUDE_AMT EMDEDMASTR
Balance Type BALANCE_TYPE EMDEDMASTR
EGM Internal Amount BALANCE_AMT EMDEDMASTR
Deduction Priority DED_PRIORITY EMDEDMASTR
Sub priority SUB_PRIORITY EMDEDMASTR
Effective Date EFFECT_DATE EMDEDMASTR
End Date END_DATE EMDEDMASTR
Deduction Cycle 01 DED_CYCLE_01 EMDEDMASTR
Deduction Cycle 02 DED_CYCLE_02 EMDEDMASTR
Deduction Cycle 03 DED_CYCLE_03 EMDEDMASTR
Deduction Cycle 04 DED_CYCLE_04 EMDEDMASTR
Deduction Cycle 05 DED_CYCLE_05 EMDEDMASTR
Deduction Cycle 06 DED_CYCLE_06 EMDEDMASTR
Deduction Cycle 07 DED_CYCLE_07 EMDEDMASTR
Deduction Cycle 08 DED_CYCLE_08 EMDEDMASTR
Deduction Cycle 09 DED_CYCLE_09 EMDEDMASTR
Levy Year LEVY_YEAR EMDEDMASTR
Filing Status FILING_STATUS EMDEDMASTR
Levy Exempts LEVY_EXEMPTS EMDEDMASTR
Additional Standard Exemptions ADDL_STD_DED EMDEDMASTR
Remit To Code REMIT_TO_CODE PREMPGARN
Over 12 Weeks OVER_12_WEEKS EMDEDMASTR
Deduct from Garnishment DED_FROM_GARN EMDEDMASTR
Arrears Deduction Code ARR_DED_CODE PREMPGARN
Arrears Sequence Number SEQ_NBR EMDEDMASTR
Arrear Balance Amount BAL_AMT(Arrear Type) EMDEDMASTR
Arrears Balance Type BAL_TYPE(Arrear Type) EMDEDMASTR
Arrear Original Balance ORIG_BAL(Arrear Type) PREMPGARN
Arrear Amount NEXT_AMT(Arrear Type) EMDEDMASTR
Arrear Monthly Limit MNTH_LMT(Arrear Type) EMDEDMASTR
Arrear Amount 2 AMOUNT_2(Arrear Type) EMDEDMASTR
Arrear Exclude Amount EXCL_AMT(Arrear Type) EMDEDMASTR

PR51- Pay Stub Inquiry

Attribute or measure name Table field Archive source table
Company COMPANY PAYMASTR
Employee EMPLOYEE PAYMASTR
Check ID CHECK_ID PAYMASTR
Payment Date CHECK_DATE PAYMASTR
Payment Number CHECK_NBR PAYMASTR
Wage Amount WAGE_AMOUNT PRTIME
Hours HOURS PRTIME
Pay Units PAY_UNITS PRTIME
Deduction Code DED_CODE PAYDEDUCTN
Deduction Amount DED_AMT PAYDEDUCTN

PR260- Payment Detail Listing

Attribute or measure name Table field Archive source table
Company COMPANY PAYMASTR
Employee EMPLOYEE PAYMASTR
Check ID CHECK_ID PAYMASTR
Payment Date CHECK_DATE PAYMASTR
Period End Date PER_END_DATE PAYMASTR
Payment Number CHECK_NBR PAYMASTR
Payroll Year PAYROLL_YEAR PAYMASTR
Gross Pay GROSS_PAY PAYMASTR
Net Pay NET_PAY_AMT PAYMASTR
Wage Amount WAGE_AMOUNT PRTIME
Hours HOURS PRTIME
Pay Units PAY_UNITS PRTIME
Deduction Code DED_CODE PAYDEDUCTN
Deduction Amount DED_AMT PAYDEDUCTN
PDL Tax Deductions

CASE WHEN dd.ADJUST_PAY='S' AND dd.CALC_TYPE='T' THEN coalesce(pd.DED_AMT,0.00) ELSE 0.00 END

PAYDEDUCTN
PDL Company Deductions CASE WHEN dd.ADJUST_PAY='C' THEN coalesce(pd.DED_AMT,0.00) ELSE 0.00 END PAYDEDUCTN
PDL Other Deductions

CASE WHEN dd.ADJUST_PAY='S' AND dd.CALC_TYPE <> 'T' THEN coalesce(pd.DED_AMT,0.00) ELSE 0.00 END

PAYDEDUCTN