| Agency | |
| 1. Table Code: X0058 | |
| 2. Table Name: AGENCY | |
| 3. Agency Number | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Agency Abbreviation | |
| 7. Agency Short Name | |
| 8. Agency Long Name | |
| 9. Parent Agency Number (X0058) | |
| 10. Category | |
| 11. Education Exclusion Code | |
| 12. Functional Area (X0047) | |
| 13. Secretary Number (X0006) | |
| 14. Agency Type | |
| Agency History | |
| 1. Table Code: X0079 | |
| 2. Table Name: AGENCY-HISTORY | |
| 3. Agency Number | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Parent Agency Number | |
| 7. Agency Name | |
| 8. Agency Category | |
| 9. Secretary Number | |
| 10. Higher Ed Code | |
| 11. Func Code | |
| 12. Agency Abbreviation | |
| 13. Agency Type | |
| Agency Payroll | |
| 1. Table Code: X0060 | |
| 2. Table Name: AGENCY-PAYROLL | |
| 3. Agency Number | |
| 4. Payroll Number | |
| 5. Expire Date CCYYMMDD | |
| 6. Begin Date: CCYYMMDD | |
| Agency Program | |
| 1. Table Code: X0059 | |
| 2. Table Name: AGENCY-PROGRAM | |
| 3. Agency Number | |
| 4. Agency Program Code | |
| 5. Agency Sub-Program Code | |
| 6. Expire Date CCYYMMDD | |
| 7. Begin Date: CCYYMMDD | |
| Alien Code | |
| 1. Table Code: X0030 | |
| 2. Table Name: ALIEN | |
| 3. Alien Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Alien Description | |
| Alternate Localities For A ZIP Code | |
| 1. Table Code: X0062 | |
| 2. Table Name: ZIP-LOCALITY | |
| 3. ZIP Code | |
| 4. Location Code | |
| 5. Expire Date CCYYMMDD | |
| 6. Begin Date: CCYYMMDD | |
| 7. State Abbrev | |
| 8. Location Name | |
| Benefit Agency / Groups | |
| 1. Table Code: X0001 | |
| 2. Table Name: AGENCY-GROUP | |
| 3. Agency Number | |
| 4. Group Number | |
| 5. Expire Date CCYYMMDD | |
| 6. Begin Date: CCYYMMDD | |
| BES Coverage Types | |
| 1. Table Code: X0013 | |
| 2. Table Name: COVERAGE-TYPE | |
| 3. Coverage Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Coverage Abbreviation | |
| 7. Coverage Description | |
| Benefits Employee Status | |
| 1. Table Code: X0053 | |
| 2. Table Name: EMPLOYEE-STATUS | |
| 3. Benefits Employee Status Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Benefits Employee Status Description | |
| 7. Active Status (internal use only) | |
| 8. Retiree Indicator (internal use only) | |
| 9. Extended Coverage Indicator (internal use only) | |
| 10. Redefinition Indicator (internal use only) | |
| 11. Local Employee Indicator (internal use only) | |
| 12. Local Retiree Indicator (internal use only) | |
| 13. Age 65 Edit (internal use only) | |
| 14. Optional Retiree Indicator (internal use only) | |
| 15. Link Indicator (internal use only) | |
| 16. Benefits Employee Status Short Description | |
| 17. Survivor Indicator (internal use only) | |
| Benefit Plans | |
| 1. Table Code: X0003 | |
| 2. Table Name: BES-PLAN | |
| 3. Plan Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Plan Abbreviation | |
| 7. Plan Short Name | |
| 8. Plan Long Name | |
| Benefit Reasons | |
| 1. Table Code: X0061 | |
| 2. Table Name: SUBMIT-REASON | |
| 3. Reason Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Reason Short Description | |
| 7. Reason Long Description | |
| 8. Reason Submit Other Indicator (internal use only) | |
| 9. Reason Submit Date Edit (internal use only) | |
| 10. PSB000 Indicator (internal use only) | |
| 11. Medicare Indicator (internal use only) | |
| 12. Dependent Delete Indicator (internal use only) | |
| 13. Dependent Add Indicator (internal use only) | |
| 14. Participant Delete Indicator (internal use only) | |
| 15. Not Used (internal use only) | |
| 16. PSB100 Participant Indicator (internal use only) | |
| 17. PSB301 Indicator (internal use only) | |
| 18. PSB100 Dependent Indicator (internal use only) | |
| 19. IVR Indicator (internal use only) | |
| 20. Help Screen Indicator (internal use only) | |
| 21. Event Date Required Indicator (internal use only) | |
| 22. Not Used (internal use only) | |
| 23. Upper/Lower Agency Allowed (internal use only) | |
| 24. IVR Membership Change Indicator (internal use only) | |
| 25. IVR Premium Conversion Indicator (internal use only) | |
| 25. Not Used (internal use only) | |
| 27. Not Used (internal use only) | |
| 28. Not Used (internal use only) | |
| 29. Not Used (internal use only) | |
| 30. Premium Conversion Indicator (internal use only) | |
| 31. Not Used (internal use only) | |
| 32. Not Used (internal use only) | |
| 33. Not Used (internal use only) | |
| 34. Not Used (internal use only) | |
| 35. User Authority Indicator (internal use only) | |
| Canadian Provinces | |
| 1. Table Code: X0010 | |
| 2. Table Name: CANADA | |
| 3. Provincial Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Provincial Name | |
| Degree Code | |
| 1. Table Code: X0051 | |
| 2. Table Name: DEGREE-CODE | |
| 3. Degree Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Degree Description | |
| EEO Occupation Code | |
| 1. Table Code: X0029 | |
| 2. Table Name: EEO | |
| 3. EEO Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. EEO Description | |
| FP Pay Area Localities | |
| 1. Table Code: X0022 | |
| 2. Table Name: FP-LOCALITY | |
| 3. Locality Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Locality Name | |
| Functional Area | |
| 1. Table Code: X0047 | |
| 2. Table Name: FUNC-AREA | |
| 3. Functional Area Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Functional Area Description | |
| Handicap Codes | |
| 1. Table Code: X0016 | |
| 2. Table Name: HANDICAP | |
| 3. Handicap Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Handicap Description | |
| 7. Handicap Description (Long) | |
| HEGIS Codes | |
| 1. Table Code: X0014 | |
| 2. Table Name: HEGIS | |
| 3. HEGIS Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. HEGIS Description | |
| Insurance Companies | |
| 1. Table Code: X0005 | |
| 2. Table Name: INSURANCE | |
| 3. Insurance Company Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Insurance Company Name | |
| Leave Code | |
| 1. Table Code: X0048 | |
| 2. Table Name: LEAVE-CODE | |
| 3. Leave Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Leave Description | |
| Nations | |
| 1. Table Code: X0007 | |
| 2. Table Name: NATION | |
| 3. Nation Code A (Two Character) - Used By PMIS | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Nation Code B (Three Character) - Not Used By PMIS | |
| 7. Nation Code C (Three Digit) - Not Used By PMIS | |
| 8. Nation Name | |
| Occupation Families | |
| 1. Table Code: X0068 | |
| 2. Table Name: OCC-FAMILY | |
| 3. Family Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Family Name | |
| Occupation Groups | |
| 1. Table Code: X0069 | |
| 2. Table Name: OCC-GROUP | |
| 3. Group Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Group Name | |
| 7. Family Code | |
| Pay Adjustment Reasons | |
| 1. Table Code: X0072 | |
| 2. Table Name: PAY-ADJUST | |
| 3. Pay Adjustment Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Pay Adjustment Description | |
| 7. Y/N State Salary Must Increase | |
| 8. Y/N State Salary Must Decrease | |
| 9. Y/N State Salary Must Not Change | |
| 10. Y/N One Time Amount Required | |
| 11. Y/N One Time Amount Must Be Zero | |
| 12. Y/N Valid In Transaction PSE065 | |
| Pay Bands | |
| 1. Table Code: X0070 | |
| 2. Table Name: PAY-BAND | |
| 3. Pay Band Number | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Pay Band Minimum Salary | |
| 7. Pay Band Maximum Salary | |
| Pay Schedules - Number of Payments Per Year | |
| 1. Table Code: X0066 | |
| 2. Table Name: PAY-SCHEDULE | |
| 3. Pay Schedule Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| Personal Titles | |
| 1. Table Code: X0017 | |
| 2. Table Name: PERSONAL-TITLE | |
| 3. Title Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Title Description | |
| Position Level Codes - Internal Numeric | |
| 1. Table Code: X0074 | |
| 2. Table Name: POS-LEVEL-NUM | |
| 3. Position Level Numeric Internal Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Position Level Alpha External Code | |
| 7. Position Level Description | |
| Publication | |
| 1. Table Code: X0027 | |
| 2. Table Name: PUBLICATION | |
| 3. Publication Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Publication Name | |
| 7. Publication Country | |
| 8. Publication State | |
| 9. Publication City | |
| Race Codes | |
| 1. Table Code: X0026 | |
| 2. Table Name: RACE | |
| 3. Race Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Race Description | |
| Retirement Acts | |
| 1. Table Code: X0009 | |
| 2. Table Name: RETIRE-ACT | |
| 3. Retiree Act Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Retiree Act Description | |
| 7. Retiree Act Optional Indicator | |
| 8. Retiree Act Survivor Indicator | |
| Role Data | |
| 1. Table Code: X0076 | |
| 2. Table Name: CLASS | |
| 3. Role Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Compensation Table Code | |
| 6. Category | |
| 7. Role Short Name | |
| 8. Role Long Name | |
| 9. Create Date | |
| 10. Expire Date | |
| 11. Band | |
| 12. Wage Indicator | |
| 13. Family Code | |
| 14. Group Code | |
| 15. Wage Expire Date | |
| 16. Overtime Eligibility Code | |
| 17. Spec Date | |
| 18. Spec Review Date | |
| 19. Spec Revise Date | |
| Role / SOC Codes Edits | |
| 1. Table Code: X0080 | |
| 2. Table Name: ROLE-SOC | |
| 3. Role Code | |
| 4. SOC Code | |
| 5. Expire Date CCYYMMDD | |
| 6. Begin Date: CCYYMMDD | |
| Salary Steps | |
| 1. Table Code: X0067 | |
| 2. Table Name: SALARY-STEP | |
| 3. Salary Type | |
| 4. Salary Step | |
| 5. Expire Date CCYYMMDD | |
| 6. Begin Date: CCYYMMDD | |
| 7. Salary Amount | |
| Sex | |
| 1. Table Code: X0028 | |
| 2. Table Name: SEX | |
| 3. Sex Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Sex Description | |
| Standard Occupation Codes (SOC) | |
| 1. Table Code: X0071 | |
| 2. Table Name: SOC-CODE | |
| 3. SOC Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. SOC Description | |
| Transaction Codes | |
| 1. Table Code: X0078 | |
| 2. Table Name: TRANS-CODE | |
| 3. Transaction Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Production Program-ID | |
| 7. Test Program-ID | |
| 8. Transaction Description | |
| US States | |
| 1. Table Code: X0008 | |
| 2. Table Name: STATE | |
| 3. State Abbreviation | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. State Name | |
| Virginia Area Codes | |
| 1. Table Code: X0002 | |
| 2. Table Name: VIRGINIA-AREA-CODE | |
| 3. Area Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| Virginia Government Secretariats | |
| 1. Table Code: X0006 | |
| 2. Table Name: SECRETARY | |
| 3. Secretary Number | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Secretary Abbreviation | |
| 7. Secretary Name | |
| 8. DOA Secretary Number | |
| Virginia Localities | |
| 1. Table Code: X0004 | |
| 2. Table Name: LOCALITY | |
| 3. Locality Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. Locality Name | |
| Virginia ZIP Codes | |
| 1. Table Code: X0024 | |
| 2. Table Name: ZIP | |
| 3. ZIP Code | |
| 4. Expire Date CCYYMMDD | |
| 5. Begin Date: CCYYMMDD | |
| 6. ZIP City Name | |
| 7. ZIP State | |
| 8. ZIP PO Box Only | |
| 9. ZIP Default Locality Code | |