Personnel – Lawson PA tables and programs
Personnel (PA) in Lawson S3 v10 MSP6 has 75 tables, 172 online screens and 133 batch programs.
Tables (75)
| Table | Prefix | Description | Primary key | Fields |
|---|---|---|---|---|
| APPJOBHIST | AJH | Applicant Job History | COMPANY, APPLICANT, EMPLOYEE, SEQ-NBR | 35 |
| APPLICANT | APL | Applicant | COMPANY, APPLICANT | 188 |
| EEODETAIL | EOD | EEO Establishment Detail | COMPANY, ESTBLSH-NBR, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE | 5 |
| EEOUNIT | EEO | EEO Establishment | COMPANY, ESTBLSH-NBR | 53 |
| EMPAUTO | EAT | Employee Automobiles | COMPANY, EMPLOYEE, AUTO-NBR | 11 |
| EMPCODES | EPC | Emp/App Personnel Codes | COMPANY, TYPE, EMP-APP, EMPLOYEE, CODE, SUBJECT, SEQ-NBR | 36 |
| EMPVISA | EMV | Employee Travel and Visa | COMPANY, EMPLOYEE, DEPENDENT, SEQ-NBR | 21 |
| INTERVIEW | ITV | Applicant Interview | COMPANY, EMP-APP, APPLICANT, SEQ-NBR | 33 |
| JOBAUTH | JBA | Employee Job Authorization | COMPANY, EMP-APP, JOB-CODE, POSITION, EMPLOYEE | 5 |
| JOBRELATE | JBR | Job Code Relationship | COMPANY, PROCESS-LEVEL, JOB-CODE, POSITION, TYPE, PERS-CODE, SUBJECT-CODE | 11 |
| MILITARY | MIL | Military Service History | COMPANY, EMP-APP, EMPLOYEE, BR-SERVICE, SEQ-NBR | 11 |
| OSHA | OSH | OSHA Incident History | COMPANY, EMPLOYEE, ESTABLISHMENT, SEQ-NBR | 108 |
| OSHESTAB | OTB | No description in the Lawson data dictionary | COMPANY, ESTABLISHMENT | 35 |
| OSHESTDTL | ODT | No description in the Lawson data dictionary | COMPANY, ESTABLISHMENT, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE | 5 |
| PAACTREAS | CRE | This table is used to hold reason codes. | COMPANY, ACT-REASON-CD, ACTION-CODE | 8 |
| PAAEEORACE | AEO | Personnel Applicant Equal Employment Opportunity Race | COMPANY, APPLICANT, RACE | 5 |
| PAASSIGNED | PAA | Assigned Resources | COMPANY, POSITION, PROCESS-LEVEL, DEPARTMENT, JOB-CODE | 14 |
| PAATTRIB | TRB | Course Attributes | COURSE, TYPE, CODE | 10 |
| PABUDGET | PAB | Budget | COMPANY, POSITION, PROCESS-LEVEL, DEPARTMENT, JOB-CODE, EFFECT-DATE | 23 |
| PACANEEA | PCE | No description in the Lawson data dictionary | COMPANY, SIC, PROCESS-LEVEL, DEPARTMENT, LOCAT-CODE | 5 |
| PACANHDR | PHD | No description in the Lawson data dictionary | COMPANY, SIC | 3 |
| PACLASS | PAQ | Position Class | COMPANY, POS-CLASS | 3 |
| PACLASSPOS | PQP | Position Class/Position Number | COMPANY, POS-CLASS, POSITION | 3 |
| PACOMMENTS | PAC | Personnel Comments | COMPANY, EMP-APP, CMT-TYPE, EMPLOYEE, JOB-CODE, ACTION-CODE, LN-NBR, SEQ-NBR, DATE | 11 |
| PACOMPPROF | PCM | No description in the Lawson data dictionary | COMPANY, PROCESS-LEVEL, TYPE, CODE, PROFIC-LEVEL | 12 |
| PACOST | CST | Course Cost | COURSE, COST-TYPE, COST-CAT, EFFECTIVE-DATE | 16 |
| PACOURSE | CRS | Courses | COURSE, EFFECTIVE-DATE | 22 |
| PAEEEORACE | EER | Personnel Administration Equal Opportunity Race | COMPANY, EMPLOYEE, RACE | 5 |
| PAEMERGCNT | PAE | Employee Emergency Contact | COMPANY, EMPLOYEE, SEQ-NBR | 27 |
| PAEMPAPP | PPP | No description in the Lawson data dictionary | COMPANY, APPLICANT, EMPLOYEE | 3 |
| PAEMPAPTST | PTS | Contains employee test information. | COMPANY, EMP-APP, EMPLOYEE, TEST, SEQ-NBR | 28 |
| PAEMPCOSTS | EMC | Employee Costs | COMPANY, EMPLOYEE, COURSE, DATE, COST-TYPE, COST-CAT | 17 |
| PAEMPTRACK | ETR | Required Training | COMPANY, EMPLOYEE, TYPE, TRACK | 8 |
| PAENCUMBER | PEN | No description in the Lawson data dictionary | COMPANY, POSITION, PROCESS-LEVEL, DEPARTMENT, JOB-CODE, EMPLOYEE, GLT-OBJ-ID, ATN-OBJ-ID | 14 |
| PAERECRUIT | PEU | No description in the Lawson data dictionary | RECRD-TYPE, COMPANY, PROCESS-LEVEL, EMPLOYEE, CODE, TYPE, SUBJECT, SEQ-NBR | 14 |
| PAFOLLOWUP | PAF | Employee Incident Follow Up | COMPANY, EMPLOYEE, ESTABLISHMENT, INCIDENT-NBR, SEQ-NBR | 15 |
| PAGRDI | PAG | Grievance,Disciplinary Actions | COMPANY, EMPLOYEE, TYPE, GRIEV-DIS-NBR | 37 |
| PAGRDISTEP | PGI | Contains follow up step information for grievance or disciplinary actions. | COMPANY, EMPLOYEE, TYPE, GRIEV-DIS-NBR, SEQ-NBR | 15 |
| PAINCICOST | PAI | Employee Incident Costs | COMPANY, EMPLOYEE, ESTABLISHMENT, INCIDENT-NBR, SEQ-NBR | 22 |
| PAINSCOURS | INC | Course Instructors | COURSE, INSTRUCT | 4 |
| PAINSTRUCT | INS | Instructor Information | INSTRUCT | 28 |
| PAINSTSES | ISE | Session Instructors | COURSE, SESSION, START-DATE, INSTR-TYPE, INSTRUCT | 12 |
| PAJOBINTRS | PJI | Employee Job Interest | COMPANY, EMP-APP, EMPLOYEE, JOB-CODE, POSITION | 8 |
| PAJOBREQ | PJR | Job Requisition | COMPANY, REQUISITION | 83 |
| PAMEDICAL | PMD | Emp Medical and Work Desc Code | COMPANY, EMPLOYEE, TYPE, CODE, SEQ-NBR | 13 |
| PAMODOPT | MOD | Training Options | KEY | 12 |
| PAOFFLANG | PLA | No description in the Lawson data dictionary | COMPANY, EMPLOYEE, POSITION, REPORT-TYPE, SEQ-NBR | 10 |
| PAPEPAUDIT | PEA | Retroactive Pos, Job Changes | COMPANY, EMPLOYEE, POS-LEVEL, EFFECT-DATE, UPDATE-DATE, FLD-NBR, ACT-OBJ-ID | 15 |
| PAPOSCHG | PPC | Position Changes | COMPANY, POSITION, EFFECT-DATE, FLD-NBR | 19 |
| PAPOSERR | PPE | Position Errors | COMPANY, EMPLOYEE, REQUISITION, POSITION, EFFECT-DATE, UPDATE-TYPE | 7 |
| PAPOSITION | POS | Positions | COMPANY, POSITION, EFFECT-DATE | 52 |
| PAPOSRULE | PPR | Position Rules | COMPANY, PROCESS-LEVEL, DEPARTMENT, EFFECT-DATE | 38 |
| PAPREPROPT | PQO | Prerequisite Options | COURSE | 5 |
| PAPREREQ | RQS | Course Prerequisites | COURSE, PREREQ-TYPE, PREREQUISITE, COMPANY | 12 |
| PAPROFILE | PPF | No description in the Lawson data dictionary | COMPANY, WEB-TYPE, SEQ | 4 |
| PAPROMAP | PPM | No description in the Lawson data dictionary | COMPANY, WEB-TYPE, SEQ, TYPE, CODE, SEQ-NBR | 7 |
| PAREGISTER | REG | Registration Information | COURSE, SESSION, START-DATE, COMPANY, EMPLOYEE | 18 |
| PAREQAPP | PRA | Job Requisition Application | COMPANY, REQUISITION, EMP-APP, APPLICANT | 7 |
| PAREQCOST | PRC | Job Requisition Cost | COMPANY, REQUISITION, DATE, REASON, EMP-APP, APPLICANT | 12 |
| PAREQLOG | PQL | Job Requisition Log | COMPANY, REQUISITION, EMP-APP, APPLICANT, DATE, APP-STATUS, SEQ-NBR | 9 |
| PAREQOFFER | PRF | Job Requisition Offer | COMPANY, REQUISITION, EMP-APP, APPLICANT, DATE, OFFER-TYPE | 23 |
| PASCOST | COS | Session Costs | COURSE, SESSION, START-DATE, COST-TYPE, COST-CAT | 16 |
| PASESSION | SES | Sessions | COURSE, SESSION, START-DATE | 26 |
| PATESTOVER | PAV | Contains employee test override information. | COMPANY, EMPLOYEE, TEST | 8 |
| PATRACK | TRA | Tracks | TRACK, EFFECTIVE-DATE | 10 |
| PATRACKDTL | TKD | Track Courses | TRACK, COURSE | 8 |
| PATRNHIST | TRH | Training History | COMPANY, EMPLOYEE, COURSE, DATE-COMPLETED | 8 |
| PATSTRESLT | PTR | Contains test results. | COMPANY, TEST, CODE | 8 |
| PATSTSETUP | PAP | Contains test setup information. | COMPANY, TEST | 51 |
| PERSACTHST | PAH | Personnel Action History | COMPANY, EMPLOYEE, EFFECT-DATE, ACTION-CODE, ACTION-NBR | 26 |
| PERSACTION | PCT | Personnel Action | COMPANY, ACTION-TYPE, EFFECT-DATE, ACTION-CODE, EMPLOYEE, ACTION-NBR | 56 |
| PERSACTYPE | PAT | Personnel Action Code | COMPANY, ACTION-CODE | 17 |
| REFERENC | REF | Applicant Reference | COMPANY, APPLICANT, SEQ-NBR | 25 |
| REVGOALDTL | RVG | File holds information about specific objectives that were used in the Total Goal Score calculation. | COMPANY, EMPLOYEE, REV-SEQ-NBR, GOAL-SEQ-NBR | 6 |
| REVIEW | REV | Employee Performance Review | COMPANY, EMPLOYEE, SEQ-NBR | 31 |
Online screens (172)
| Screen | Description | Updates | References |
|---|---|---|---|
| HS00.1 | SEA Applicant Setup | 1 | 3 |
| HS11.1 | Web Competency Profile | 0 | 16 |
| HS11.2 | Web Competency Profile | 0 | 16 |
| HS12.1 | Web Expired Competencies | 0 | 15 |
| HS12.2 | Web Expired Competencies | 0 | 15 |
| HS13.1 | Web Competency Compliance Rpt | 0 | 15 |
| HS13.2 | Web Competency Compliance Rpt | 0 | 15 |
| HS14.1 | Web Profsnl Profile-Phys-Nurse | 0 | 8 |
| HS15.1 | Web Direct Rpt Inq - Emp Dtl | 0 | 4 |
| HS50.1 | Employee Qualification Search | 0 | 13 |
| HS50.2 | Employee Qualification Search | 0 | 13 |
| HS50.3 | Training Courses | 0 | 12 |
| HS50.4 | Training Courses | 0 | 12 |
| HS50.5 | Employee Job Interest | 1 | 5 |
| HS51.1 | Employee Qualification Search | 0 | 12 |
| HS51.2 | Employee Qualification Search | 0 | 12 |
| HS52.1 | Employee Qualification Search | 0 | 14 |
| HS52.2 | Employee Qualification Search | 0 | 14 |
| PA01.1 | Position Class | 2 | 5 |
| PA01.2 | Position Class by Position | 1 | 6 |
| PA01.3 | Position Class Totals | 0 | 5 |
| PA01.4 | Position Class Speed Entry | 1 | 4 |
| PA02.1 | Position | 69 | 72 |
| PA03.1 | Position Change | 2 | 4 |
| PA03.2 | Position Change - Detail | 1 | 5 |
| PA03.3 | Employee Levels | 0 | 4 |
| PA04.2 | Alpha Fields | 4 | 3 |
| PA04.3 | Numeric Fields | 4 | 3 |
| PA04.4 | Date Fields | 4 | 3 |
| PA04.5 | Alpha Field Values | 1 | 2 |
| PA06.1 | Position Rules | 1 | 3 |
| PA07.1 | Competency Proficiencies | 1 | 2 |
| PA08.1 | Qualifications | 1 | 5 |
| PA08.2 | Working Conditions | 1 | 4 |
| PA08.3 | Physical and Mental Requirements | 1 | 4 |
| PA09.1 | Job Description | 2 | 3 |
| PA10.1 | Length of Service | 0 | 5 |
| PA11.1 | Assigned Resources | 1 | 6 |
| PA12.1 | Emergency Contact | 3 | 8 |
| PA13.1 | Multiple Positions and Jobs | 53 | 68 |
| PA13.2 | Multiple Position and Job History | 53 | 68 |
| PA13.3 | Multiple Position, Job Summary | 0 | 9 |
| PA14.1 | Military Service | 3 | 6 |
| PA15.1 | Medical | 3 | 6 |
| PA15.2 | Work Restriction and Accommodation | 2 | 6 |
| PA16.1 | Company Property | 9 | 29 |
| PA17.1 | Automobile Information | 2 | 6 |
| PA18.1 | Travel Information | 2 | 9 |
| PA19.1 | Prior Work History | 2 | 7 |
| PA20.1 | Education | 11 | 30 |
| PA21.1 | Competencies | 11 | 30 |
| PA22.1 | Certifications | 11 | 32 |
| PA23.1 | Employee Qualification Override | 1 | 5 |
| PA24.1 | Relocation | 11 | 30 |
| PA25.1 | Employee Benefits | 2 | 6 |
| PA26.1 | Review | 4 | 7 |
| PA26.2 | Review Goal Detail | 0 | 2 |
| PA26.3 | Web Review Goal Detail | 2 | 3 |
| PA26.4 | Review Goal Detail | 2 | 3 |
| PA27.1 | Contracts | 10 | 29 |
| PA28.1 | Applicant Ethnicity | 4 | 16 |
| PA30.1 | Applicant Status | 1 | 2 |
| PA31.1 | Applicant | 3 | 20 |
| PA31.3 | LTM Applicant Data | 0 | 2 |
| PA32.1 | Applicant Reference | 3 | 4 |
| PA33.1 | Applicant Job History | 2 | 6 |
| PA34.1 | Applicant Education | 11 | 30 |
| PA35.1 | Applicant Competencies | 11 | 30 |
| PA36.1 | Applicant Certification | 11 | 31 |
| PA37.1 | Applicant Qualification Override | 1 | 4 |
| PA38.1 | Applicant Relocation | 11 | 30 |
| PA39.1 | Applicant Military Service | 3 | 3 |
| PA40.1 | Applicant Medical | 2 | 3 |
| PA41.1 | Interviews | 6 | 8 |
| PA42.1 | Requisition | 11 | 17 |
| PA42.3 | Requisition Approval Override | 11 | 15 |
| PA43.1 | Requisition Applicants | 7 | 6 |
| PA43.2 | Applicant Requisitions | 7 | 4 |
| PA44.1 | Requisition Costs | 2 | 7 |
| PA45.1 | Requisition Offers | 4 | 10 |
| PA46.1 | Requisition Comments | 2 | 0 |
| PA47.1 | e-Recruiting Pending Update | 1 | 0 |
| PA48.1 | Test Setup | 4 | 8 |
| PA48.2 | Test Results | 1 | 2 |
| PA48.3 | Test Eligibility - Positions and Jobs | 1 | 4 |
| PA48.4 | Position and Job Test Eligibility | 1 | 4 |
| PA49.1 | Employee Tests | 1 | 13 |
| PA49.2 | Employee Test Eligibility Override | 1 | 6 |
| PA49.3 | Applicant Tests | 1 | 13 |
| PA50.1 | Action | 1 | 11 |
| PA52.1 | Individual Action | 56 | 70 |
| PA52.2 | Mass Pay Action | 3 | 15 |
| PA52.3 | Mass Action | 52 | 69 |
| PA52.4 | Hire an Applicant | 57 | 85 |
| PA52.5 | Position and Job Action | 57 | 70 |
| PA52.6 | Import Transaction | 0 | 4 |
| PA53.1 | Personnel Action Workflow Override | 1 | 27 |
| PA54.1 | Personnel Action History Correction | 23 | 34 |
| PA55.1 | Retroactive History Audit | 3 | 5 |
| PA56.1 | Personnel Action Comments | 2 | 4 |
| PA57.1 | Personnel Action Reason Codes | 4 | 4 |
| PA57.2 | Personnel Action by Reason Code | 1 | 2 |
| PA57.3 | Reason Codes by Personnel Action | 1 | 2 |
| PA58.1 | Personnel Actions On Hold | 1 | 3 |
| PA59.1 | Grievance and Disciplinary Actions | 2 | 9 |
| PA59.2 | Grievance and Disciplinary Action Step | 1 | 3 |
| PA62.1 | Employee Qualification Search | 0 | 12 |
| PA63.1 | Applicant Qualification Search | 0 | 12 |
| PA64.1 | Employee Job Qualification | 0 | 16 |
| PA64.2 | Employee Position Qualification | 0 | 16 |
| PA65.1 | Applicant Job Qualification | 0 | 14 |
| PA65.2 | Applicant Position Qualification | 0 | 15 |
| PA66.1 | Employee Action Summary | 0 | 7 |
| PA66.2 | Action Inquiry | 0 | 12 |
| PA66.3 | Employee Action Detail | 0 | 30 |
| PA66.4 | Employee Action Comments | 0 | 7 |
| PA67.1 | Pay Rate History | 0 | 6 |
| PA70.1 | Position Budget | 1 | 5 |
| PA71.1 | Job Budget | 1 | 6 |
| PA72.1 | Preliminary Position Budget | 1 | 4 |
| PA73.1 | Preliminary Job Budget | 1 | 5 |
| PA79.1 | Current Totals | 0 | 4 |
| PA80.1 | Position Budget Inquiry | 0 | 6 |
| PA80.2 | Job Budget Inquiry | 0 | 6 |
| PA81.1 | Employee Test Inquiry | 0 | 6 |
| PA81.2 | Test Inquiry | 0 | 6 |
| PA82.1 | Salary Encumbrance Inquiry | 3 | 14 |
| PA90.1 | Health and Safety Incident | 4 | 12 |
| PA90.2 | Incident Follow Up | 1 | 6 |
| PA90.3 | Incident Costs | 2 | 6 |
| PA91.1 | Health and Safety Incident Inquiry | 0 | 6 |
| PA92.1 | Incident Establishment | 2 | 6 |
| PA92.2 | Incident Establishment Detail | 1 | 4 |
| PA93.1 | EEO-1 Company | 2 | 3 |
| PA93.2 | EEO-1 Multi-Establishment | 2 | 6 |
| PA93.3 | EEO-4 Company | 1 | 0 |
| PA93.4 | Selection Critera | 1 | 4 |
| PA93.5 | EEO-5 Single Schools/Districts | 3 | 4 |
| PA93.6 | EEO-5 Multiple Schools/Districts | 3 | 4 |
| PA94.1 | Canada EEA Setup | 2 | 3 |
| PA95.1 | Grade Range Schedule | 5 | 8 |
| PA96.1 | Official Languages Bilingual Requirements | 2 | 5 |
| TR00.1 | Training System Options | 1 | 3 |
| TR01.1 | Course | 4 | 6 |
| TR02.1 | Course Prerequisite | 1 | 5 |
| TR02.2 | Prerequisite Options | 1 | 2 |
| TR03.1 | Course Certifications and Competencies | 1 | 5 |
| TR04.1 | Session | 4 | 3 |
| TR04.2 | Session Evaluations | 0 | 1 |
| TR04.3 | Session Evaluations | 1 | 0 |
| TR05.1 | Track | 1 | 4 |
| TR06.1 | Track Courses | 1 | 3 |
| TR07.1 | Instructor | 2 | 4 |
| TR08.1 | Course Instructors | 1 | 4 |
| TR09.1 | Instructor Session | 1 | 5 |
| TR10.1 | Course Costs | 1 | 3 |
| TR10.2 | Base Currency | 0 | 1 |
| TR11.1 | Session Costs | 1 | 4 |
| TR11.2 | Base Currency | 0 | 1 |
| TR12.1 | Employee Costs | 1 | 6 |
| TR12.2 | Base Currency | 0 | 1 |
| TR13.1 | Required Training by Track and Course | 1 | 5 |
| TR13.2 | Required Training by Employee - Track or Course | 1 | 5 |
| TR14.1 | Instructor Courses | 1 | 4 |
| TR15.1 | Required Training by Employee | 1 | 5 |
| TR20.1 | Session Registration | 2 | 20 |
| TR20.2 | Mass Registration | 2 | 20 |
| TR20.3 | Session Registration Override | 2 | 20 |
| TR20.4 | Employee Session Registration | 2 | 20 |
| TR21.1 | Employee Training History | 13 | 38 |
| TR22.1 | Session Completion | 11 | 38 |
| TR26.1 | Employee Training Competency Maintenance | 10 | 37 |
Batch programs (133)
| Program | Description | Updates | References |
|---|---|---|---|
| HS701 | PDI, TalentView Data Update | 3 | 3 |
| HS702 | Review Data Update | 3 | 3 |
| HS704 | LPMH Licensure Extract | 1 | 8 |
| PA100 | Action Update | 63 | 83 |
| PA102 | Position Update | 62 | 67 |
| PA103 | Mass Position Changes | 1 | 21 |
| PA105 | Employee Audit Report | 1 | 13 |
| PA111 | Recalculate Assigned Resources | 3 | 6 |
| PA113 | Retroactive History Update | 14 | 31 |
| PA115 | Employee Purge | 108 | 110 |
| PA120 | Applicant Purge | 20 | 12 |
| PA125 | Employee History Purge | 5 | 6 |
| PA130 | Employee Comments Purge | 2 | 3 |
| PA135 | Applicant Comments Purge | 2 | 2 |
| PA149 | Update Scheduled Tests | 2 | 27 |
| PA170 | Budget Update | 2 | 6 |
| PA171 | Job Budget Transfer | 2 | 5 |
| PA172 | Initiate Preliminary Budget Data | 2 | 7 |
| PA182 | Salary Encumbrance Update | 17 | 25 |
| PA201 | Position Class Listing | 1 | 11 |
| PA202 | Position Listing | 1 | 14 |
| PA204 | Position User Field Listing | 1 | 2 |
| PA206 | Position Rules Listing | 1 | 3 |
| PA207 | Competency Proficiency Listing | 1 | 3 |
| PA208 | Position and Job Description List | 1 | 9 |
| PA210 | Length of Service Report | 1 | 18 |
| PA211 | Assigned Resource Listing | 1 | 11 |
| PA212 | Emergency Contact Listing | 1 | 13 |
| PA213 | Position and Job Listing | 3 | 17 |
| PA214 | Military Service Listing | 1 | 12 |
| PA215 | Medical Listing | 1 | 12 |
| PA216 | Company Property Listing | 2 | 13 |
| PA217 | Automobile Listing | 1 | 12 |
| PA218 | Travel Listing | 9 | 29 |
| PA219 | Prior Work History Listing | 1 | 12 |
| PA220 | Education Listing | 1 | 13 |
| PA221 | Employee Competency Listing | 1 | 13 |
| PA222 | Certification Listing | 1 | 13 |
| PA223 | Starters and Leavers Report | 1 | 18 |
| PA224 | Relocation Listing | 1 | 13 |
| PA225 | Employee Benefits Listing | 1 | 13 |
| PA227 | Contract Listing | 1 | 11 |
| PA228 | Applicant Ethnicity Listing | 1 | 5 |
| PA230 | Applicant Status Listing | 1 | 2 |
| PA231 | Applicant Profile | 1 | 22 |
| PA232 | Applicant Reference Listing | 1 | 6 |
| PA233 | Applicant Job History Listing | 1 | 8 |
| PA234 | Applicant Education Listing | 1 | 6 |
| PA235 | Applicant Competency Listing | 1 | 6 |
| PA236 | Applicant Certification Listing | 1 | 6 |
| PA238 | Applicant Relocation Listing | 1 | 6 |
| PA239 | Applicant Military Service Listing | 1 | 6 |
| PA240 | Applicant Medical Listing | 1 | 3 |
| PA241 | Interview Listing | 1 | 12 |
| PA242 | Requisition Listing | 1 | 16 |
| PA243 | Requisition Log | 1 | 8 |
| PA244 | Applicant History | 1 | 7 |
| PA248 | Test Listing | 1 | 19 |
| PA249 | Employee and Applicant Test Listing | 1 | 21 |
| PA250 | Personnel Action Code Listing | 1 | 3 |
| PA257 | Action Reason Code Listing | 1 | 3 |
| PA258 | Report of Actions on Hold | 2 | 9 |
| PA259 | Grievance and Disciplinary Listing | 1 | 10 |
| PA262 | Qualified Employees Listing | 1 | 15 |
| PA263 | Qualified Applicants Listing | 1 | 12 |
| PA271 | Budget Listing | 1 | 4 |
| PA272 | Budget and Assigned Resource Listing | 2 | 28 |
| PA290 | Health and Safety Incident Listing | 5 | 19 |
| PA292 | Incident Establishment Listing | 1 | 6 |
| PA294 | Canada EEA - Setup Listing | 1 | 5 |
| PA295 | Grade Range Schedule Listing | 1 | 7 |
| PA296 | Canadian Language Bilingual Requirements Listing | 1 | 11 |
| PA302 | Position Purge | 15 | 18 |
| PA310 | Birthdate Listing | 1 | 10 |
| PA311 | Employee Profile | 2 | 39 |
| PA313 | Employee Position and Job History Purge | 2 | 5 |
| PA315 | Telephone Listing | 1 | 9 |
| PA320 | Interoffice Directory | 1 | 9 |
| PA325 | Post Office Mailing Listing | 1 | 10 |
| PA330 | Interoffice Labels | 1 | 9 |
| PA335 | Employee Listing | 1 | 10 |
| PA340 | Action History Listing | 1 | 12 |
| PA341 | Hire and Term Listing | 1 | 10 |
| PA345 | Review Schedule Report | 1 | 13 |
| PA349 | Employee and Applicant Test Purge | 2 | 6 |
| PA350 | Review History Report | 1 | 12 |
| PA355 | Active Actions Report | 1 | 14 |
| PA360 | Wage Analysis Report | 1 | 15 |
| PA370 | Employee Review Document | 2 | 19 |
| PA371 | Budget Purge | 2 | 6 |
| PA372 | Health and Safety Incident Purge | 5 | 12 |
| PA390 | EEO-1 Report | 2 | 10 |
| PA391 | EEO-4 Report | 1 | 12 |
| PA392 | EEO-5 Report | 1 | 12 |
| PA393 | Veterans Employment Report | 1 | 9 |
| PA402 | Position Incumbent Listing | 1 | 8 |
| PA406 | Position Rules Audit Listing | 1 | 11 |
| PA490 | OSHA Log, Summary Report | 5 | 17 |
| PA495 | IPEDS Report | 4 | 29 |
| PA496 | Official Languages Report | 1 | 13 |
| PA502 | Position Conversion | 70 | 72 |
| PA512 | Emergency Contact Conversion | 4 | 8 |
| PA513 | Position and Job Conversion | 54 | 67 |
| PA520 | Employee and Applicant Code Conversion | 11 | 29 |
| PA526 | Review Conversion | 3 | 3 |
| PA531 | Applicant Conversion | 6 | 16 |
| PA532 | Code, Requisitions Exports | 2 | 17 |
| PA533 | Job History Conversion | 3 | 7 |
| PA534 | e-Recruiting Employee Export | 2 | 10 |
| PA535 | e-Recruiting Requisition Conversion | 12 | 15 |
| PA549 | Employee and Applicant Test Conversion | 2 | 13 |
| PA570 | Budget Conversion | 2 | 6 |
| PA590 | Health and Safety Incident Conversion | 5 | 12 |
| PA594 | EECRS CSV Interface | 1 | 21 |
| TR113 | Group Track | 2 | 5 |
| TR114 | Job Code Track | 2 | 6 |
| TR120 | Group Session Registration | 3 | 21 |
| TR121 | Job Code Session Registration | 3 | 21 |
| TR200 | Notification Letter Extract | 1 | 8 |
| TR201 | Course Profile | 1 | 15 |
| TR202 | Course Catalog Extract | 1 | 8 |
| TR204 | Session Listing | 1 | 6 |
| TR205 | Track Listing | 1 | 5 |
| TR207 | Instructor Listing | 1 | 10 |
| TR210 | Course Cost Listing | 1 | 9 |
| TR220 | Session Roster | 1 | 6 |
| TR221 | Session Wait List Listing | 1 | 4 |
| TR222 | Employee Training Listing | 1 | 11 |
| TR500 | Training Conversion | 11 | 37 |
| ZE526 | Import eReview Evals to PA26 | 2 | 5 |
| ZE532 | Pos Mgr Master List Interface | 1 | 12 |
| ZE533 | Import Position Qualifications | 2 | 2 |
| ZE534 | Import SYS Access Qualifications | 2 | 2 |
Other tables used by Personnel programs (181)
ACACCTCAT, ACACTGRP, ACACTIVITY, ACCAL, ACCALX, ACCATSUMX, ACCOMMIT, ACCOMMITX, ADDRDATA, BENEFIT, BNBEN, BNCHANGE, BNCOMPANY, BNCOVERAGE, BNCOVOPT, BNEMPEXER, BNEMPGRNT, BNGRPCHG, BNSIMDTL, BNSIMHDR, BNTAEMPBAL, BNTRANS, BONDBENSEQ, C6EMDDMSTR, C6PRDDEF, C6STATE, C6TAXGRP, CMASSIGN, CMCHANGE, CMCONTRACT, CMCONTRULE, CMEMPTRANS, CUCODES, CUTABLE, CWASSIGN, CWCHANGE, CWCONTRACT, CWCONTRULE, CWDISTRIB, CWEMPTRANS, DEDCODE, DEPBEN, DEPTCODE, DEPTSEGBLK, EMACHDEPST, EMDEDMASTR, EMDEPEND, EMDISTMAST, EMPALTNAME, EMPCOMMENT, EMPFLEXDOL, EMPLOYEE, EMPPICKLST, EMSTATUS, EMTAMASTR, FAMSTSHIST, FBDETAIL, FBFUNDAMT, FBFUNDDTL, FBTRANS, FBYETR, GLACCMXVAL, GLADDRESS, GLCHART, GLCHARTDTL, GLCOMMIT, GLCOMMITX, GLHISCOMBL, GLHISCOMX, GLINTCO, GLNAMES, GLSYSTEM, GMAUDIT, GMEFFORT, GMLABDIST, GMRETDIST, GMTRANEFRT, HISTERR, HRCONTNBR, HRCTRYCODE, HRDEPBEN, HREMPRCVR, HREMPUSF, HRHISTORY, HRLTMRULE, HROCCUPCD, HRPOSFLDS, HRPOSUSD, HRPOSVAL, HRSECLEV, HRSUPER, HRUSERFLDS, HRUTILITY, HRWRKSCHD, INEMPLOYEE, INSTCTRYCD, JOBCLASS, JOBCODE, LPEMPLEAVE, LPLINK, MXCATDEF, MXVALIDATE, OCCURTYPE, ONETMDED, PADICT, PADICT2, PAEMPGOAL, PAEMPLOYEE, PAEMPPOS, PARTBEN, PARTICIPNT, PASCRTY, PATHFIND, PAYCLASS, PAYDEDUCTN, PAYMASTR, PAYSUMGRP, PCODES, PCODESDTL, PCODESTYPE, PERSGROUP, PGEMPLOYEE, PGSELECT, PLAN, PRBUSGRP, PRDEDDTL, PRDISTRIB, PREMDEDHST, PREMPGARN, PREMPSTATE, PRHOURS, PRMONITOR, PROGPAY, PROVERTIME, PRPAYCODE, PRPENDTIME, PRPROCGRP, PRPROVINCE, PRQCENTGRP, PRQUALIFY, PRRATEHIST, PRRATES, PRREGPARM, PRSAGDTL, PRSAGHEAD, PRSHIFTTBL, PRSTATE, PRSYSTEM, PRTAXAUTH, PRTAXLEVY, PRTAXLOC, PRTIME, PSGRELATE, PWEMPLY, PWSUPER, QUARTDED, QUARTWAGE, REQCODE, SBBEN, STANDTIME, SUBCKPOINT, SYSRULES, SYSTEMCODE, TAACCRUAL, TAEEGROUP, TAEEMASTER, TAEMPSERV, TAEMPTRANS, TAENROLL, TAGENLEDGR, TALIMIT, TALOSHRS, TAPAYROLL, TAPLAN, TASERVCODE, TASTRUCTUR, TATABLE, TAXGROUP, TIMERECORD, VESTHOURS, WFSETUP