This report lists all organization codes. It displays the name, budget and actual information with effective and inactive dates.
Report Criteria
| Category |
Position Control |
| Distribution |
Agency |
| Frequency |
Annually at Fiscal Year-End; Upon Request |
| Form |
|
| Sort Sequence |
Organization Code |
| Page Break |
|
| Parameters |
HNKPC – START DATE, END DATE |
| Databases Used |
H0C, HNO, HNK |
| Selection Criteria |
All organization codes with an effective date between the HNK dates and an inactive date greater than START DATE, or null. |
| Produce Output? |
Yes |
| Request Screen |
HNKPC – 4 options – Select one:
| 0 | Total by agency only |
|---|
| 1 | Total by agency and first level of the organization code |
|---|
| 2 | Total by agency, first and second levels of the organization code |
|---|
| 3 | Total by agency, first, second, and third levels of the organization code |
|---|
|
| Posting Report? |
No |
| Additional Notes |
|
Report Headings
- FROM/TO HNK.PCSTDT/HNK.PCEDT
- Display the beginning and ending dates of the requested period.
- ORG CODE/TITLE HNO.ORGCODE/HNO.ORGNAME
- Displays the organization code and name. This code determines how pay is reported and allows reporting breaks at different levels of an organization.
| Positions 1-3 | Division/Region |
|---|
| Positions 4-5 | Goal/Program |
|---|
| Positions 7-9 | Strategy/Activity |
|---|
| Positions 10-11 | User Defined |
|---|
- EFF DT HNO.HISTORYDT
- Displays the date the organization code can be used.
- INACT DT HNO.NACTDT
- Displays the date the organization code can no longer be used.
- APPROPRIATED AMOUNT HNO.APRNAMT
- Displays the total amount of budgeted money allocated to the organization to be disbursed as wages throughout the fiscal year. This amount should be manually entered into USPS each fiscal year.
- ADJUSTED AMOUNT HNO.BUDADJAMT
- Displays an amount of money by which to adjust the appropriated amount. This is an optional user-defined value that is not considered in any budgeted calculations.
- BUDGETED AMOUNT HNO.BUDGAMT
- Displays the total amount of wages expected to be paid in the fiscal year within the organization. Amounts are calculated from the agency's position records.
- ACTUAL EXPENDITURE HNO.FYXPNAMT
- Displays the total amount of wages paid-to-date in the fiscal year within the organization. Amounts are calculated from both regular and supplemental payrolls.
- PROJECTED EXPENDITURE HNO.FYXPNPROJ
- Displays the total amount of wages that are expected to be paid for the remainder of the fiscal year within the organization. Amounts are calculated based on the pay period salary and either the end of the fiscal year or the inactive date of the agency's position records.
- PROJECTED LAPSE HNO.FYLPSPROJ
- Displays the difference between the budgeted amount from the actual expenditures and the projected expenditures on the agency's position records.
Projected Lapse = Budgeted Amount - (Actual Expenditures + Projected Expenditures)
- TOTALS DERIVED
- Displays the totals of each level of the organization code.
- AGENCY TOTALS DERIVED
- Displays the totals for the agency.
- ACTIVE ORGS DERIVED
- Displays the number of active organization codes during the requested period.
- INACTIVE ORGS DERIVED
- Displays the number of inactive organization codes during the requested period.
Sample Report
REPORT: 535 UNIFORM STATEWIDE PAYROLL/PERSONNEL SYSTEM PAGE: 1
AGENCY: XXX XXXXX XXXXX XXXXXXXXXXX XXXXXX RUN DATE: XX/XX/20XX
ORGANIZATION TABLE LISTING RUN TIME: 2:00:00
FROM 09/01/20XX TO 08/31/20XX
0ORG CODE/TITLE APPROPRIATED ADJUSTED BUDGETED ACTUAL PROJECTED P
EFF DT INACT DT AMOUNT AMOUNT AMOUNT EXPENDITURE EXPENDITURE
000000100000 / BOARD MEMBERS
09/01/05 0.00 0.00 0.00 0.00 0.00
-000001000 TOTALS: 0.00 0.00 0.00 0.00 0.00
000001 TOTALS: 0.00 0.00 0.00 0.00 0.00
000000203100 / TECHANICAL SERVICES - PROGRAM
09/01/05 0.00 0.00 0.00 0.00 0.00
-000002031 TOTALS: 0.00 0.00 0.00 0.00 0.00
000002 TOTALS: 0.00 0.00 0.00 0.00 0.00
000000410000 / AUDIT & FUNDS MGMT/ADMIN
09/01/05 0.00 0.00 0.00 0.00 0.00
-000004100 TOTALS: 0.00 0.00 0.00 0.00 0.00
000000430200 / RED RIVER/PERMIAN BASIN REGION
09/01/05 0.00 0.00 0.00 0.00 0.00
-000004302 TOTALS: 0.00 0.00 0.00 0.00 0.00
000004 TOTALS: 0.00 0.00 0.00 0.00 0.00
000000500000 / RESOURCE INFORMATION OFFICE
09/01/05 0.00 0.00 0.00 0.00 0.00
-000005000 TOTALS: 0.00 0.00 0.00 0.00 0.00
000005 TOTALS: 0.00 0.00 0.00 0.00 0.00
000002003000 / CONSUMERS SERVICES
09/01/05 0.00 0.00 0.00 0.00 0.00
-000020030 TOTALS: 0.00 0.00 0.00 0.00 0.00
000002004000 / DIV. OF INFO. SYSTEMS
09/01/05 0.00 0.00 0.00 0.00 0.00
-000020040 TOTALS: 0.00 0.00 0.00 0.00 0.00