PEIMS Account Map/ Cross Walk
The PEIMS - Account Map/Crosswalk (PIUPAC) page allows financial account segments to be mapped to PEIMS codes and account segments. The part match code can have anything in it that would pass the LIKE option in SQL (e.g., to select all Financials funds that begin with 1, enter 1%). The start and end dates can be used if the mapping changes over time or PEIMS changes its code from year to year.
Field | Details |
|---|---|
Start Date | Select the start date for this account code mapping definition from the drop-down menu. |
End Date | Select the end date for this account code mapping definition from the drop-down menu. |
Code Name | Used to categorize the mapping code value being defined. Enter up to 12 characters. |
Value | For those code categories that have multiple entries, the Value is used to differentiate between the entries. Enter up to 20 characters. |
Fund | A three-character code used to identify the PEIMS Fund or Fund Group value being mapped. |
Function | A two-character code used to identify the PEIMS Function value being mapped. Function codes are a general operational area and group together related activities. |
Object | A four-character code used to identify the PEIMS Object value being mapped |
Object Codes | identify an account, a transaction, or a source of funds. |
Organization | A three-character code used to identify the PEIMS Organization being mapped. |
Organization Codes | The unique organizational unit within the district with which the account is associated. |
Fiscal Year | Choose a one-digit fiscal year code (0-9) from the list provided. |
Program | A two-character code used to identify the PEIMS Program being mapped. |
Fiscal Year | Choose a one-digit fiscal year code (0-9) from the list provided. |
Program | A two-character code used to identify the PEIMS Program being mapped. |
Code Name 1-12 | Up to 10-characters which identify the code name to be mapped. Up to 12 entries may be made. |
Part Match 1-12 | Up to 50-characters which identify the code value to be mapped. Up to 12 entries may be made. |
Created | The date and time that this record was created. This field is system generated and display only. |
By | The Nucleus User ID of the user that created this record. This field is system generated and is display only. |
Updated | The date and time that this record was last updated. This field is system generated and display only. |
By | The Nucleus User ID of the last user that updated this record. This field is system generated and display only. |
Extracted | The date and time that this record was extracted. This field will be updated by an external process and is display only. |
As Of | The "As Of" date for this record. This field will be updated by an external process and is display only. |
Source | The origin of this record. This field will be updated by an external process and is display only. |
By | The name of the user who extracted this record. This field will be updated by an external process and is display only. |