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 |
PR260- Payroll Register
| Attribute or measure name | Table field | Archive source table |
|---|---|---|
| Company | COMPANY | PAYMASTR |
| Payment Date | CHECK_DATE | PAYMASTR |
| Employee | EMPLOYEE | PAYMASTR |
| Employee Name |
IF [DA_HR11Employee.LAST_NAME] IS NOT NULL THEN IF [DA_HR11Employee.FIRST_NAME] IS NOT NULL THEN [Employee Name] = trim([DA_HR11Employee.LAST_NAME] + ', '+ [DA_HR11Employee.FIRST_NAME] + ' ' + IFNULL([DA_HR11Employee.MIDDLE_INIT],'')) ELSE [Employee Name] = trim([DA_HR11Employee.LAST_NAME] + ' '+ IFNULL([DA_HR11Employee.MIDDLE_INIT],'')) END IF END IF |
EMPLOYEE |
| Item Name |
IF [DA_PR51PayStubInquiry.TYPE] <> 'Earnings' THEN [Item Name] = [DA_PR51PayStubInquiry.DED_CODE] + ' '+ [DA_PR51PayStubInquiry.CHECK_DESC] ELSE IF ([DA_PR51PayStubInquiry.CHECK_DESC] IS NULL) THEN [Item Name] = [DA_PR51PayStubInquiry.PAY_SUM_GRP] + ' ' + [DA_PR51PayStubInquiry.DESCRIPTION] ELSE [Item Name] = [DA_PR51PayStubInquiry.PAY_SUM_GRP] + ' ' + [DA_PR51PayStubInquiry.CHECK_DESC] END IF
END IF |
PAYDEDUCTN, PAYSUMGRP, DEDCODE |
| PSI Hours | ifnull([DA_PR51PayStubInquiry.HOURS],0.0) | PRTIME |
| PSI Deduction Amount | DED_AMT | PAYDEDUCTN |
| PSI Wage Amount | ifnull([DA_PR51PayStubInquiry.WAGE_AMOUNT],0.0) | PRTIME |
| PSI Taxable Wages | TAX_WAGES | PAYDEDUCTN |
| PSI Pay Units | ifnull([DA_PR51PayStubInquiry.PAY_UNITS],0.0) | PRTIME |
| PDL Gross Pay | GROSS_PAY | PAYMASTR |
| PDL Net Pay | NET_PAY_AMT | PAYMASTR |