WISDM Data View
Detail Payroll Transactions
Name of the View: DETAIL_PAYROLL_TRANS
Description: This view displays salary and fringe benefit expenditures and salary encumbrance transaction detail for the UW-Madison campus. Fringe benefit encumbrances are not available. The basis for this view is the WISDM data, so it is updated daily and contains data starting with FY2005. Detail salary data prior to FY2005 can be retrieved from the Detail Accounting Transactions view.
Data Custodian: Accounting Services: Hua Ramer – phone: 262-4858, email: hramer@bussvc.wisc.edu
Authorization: You must receive approval to access this data view. Authorization forms and procedures can be found at the following web site: http://www.bussvc.wisc.edu/acct/sfs/.
Special Considerations:
- Fringe benefit and longevity payments for GPR funds will be included unless you take action to exclude them. These expenditures are recorded to the Organization and also to a project/grant (e.g. 101A000 for fringes and 101A001 for longevity). One way to exclude them would be to use the following statement in your selection: PROJECT GRANT EQ " ". Note that the space within the double quotes will have the effect of excluding all Project/Grants within the funds that you have selected.
- For Brio users, please do not use the “Show Values” option whenever possible, because this option will slow down your query processing and your query may be “timed out”.
Data View Contents:
Data field |
Lgth |
Description |
Example/Possible Values |
|---|---|---|---|
ACCOUNTING_PERIOD |
3 |
The period within the fiscal year. |
001 - July |
FISCAL_YEAR |
4 |
The year that the budget covers on state funds. |
2004, 2005, etc. |
PERSON_ID |
8 |
Person ID is assigned in the IADS system. An employee may have multiple Appointment IDs connected to one Person ID. |
e.g. 00123456 |
APPOINTMENT_ID |
8 |
Appointment id is assigned in the IADS system. |
e.g. 00123456 |
FUND |
3 |
A code identifying the source of funds being reported on. In all cases, except clearing accounts, it represents an appropriation by the state legislature. |
101, 128, 133, 144, etc. |
PROJECT_GRANT |
7 |
A code used by records that are organized by project. This code is made up of the fund and the proj/grant# – e.g. 144AB12. Normally used by gift and grant funds (133) Federal grant funds (144) and Trust funds (161). |
e.g.144GH01 |
DIVISION |
2 |
The first and second characters of the organization code. They define the college or division. |
e.g. 03 |
DEPARTMENT |
2 |
The third and fourth characters of the organization code. They define the major department within a college or division. |
e.g. 05 |
SUBDEPARTMENT |
2 |
The fifth and sixth characters of the organization code. They define a sub-department of the major department. |
e.g. 00 |
ORGANIZATION |
6 |
A code identifying the combined codes for division, department and sub-department. |
e.g. 030500 |
ORG_DESCR |
30 |
The name of the organization code. |
e.g. Business Svcs/Acctg Svcs |
PROGRAM_CODE |
1 |
A code that identifies the general purpose for which money is being spent. |
0-Student Services |
ACCOUNT |
4 |
In expense accounting, accounts are used to classify financial transactions according to the object of the expenditure. For encumbrances, accounts identify the purpose for which the money is encumbered. |
e.g. 1531 |
ACCT_DESCR |
30 |
Descriptive name associated with the account. |
e.g. Classified – Hourly |
CLASS |
5 |
Displays the class field, which can contain the building number, tuition remission code, or county sales tax county. |
0034 |
SCENARIO |
10 |
Budget scenario code. |
ADJUSTED |
EMPLOYEE_NAME |
30 |
Name of the employee that the transaction applies to. |
Employee Name |
JRNL_LN_REF |
15 |
A catch-all field. Can have voucher number, PO number or other information depending on the type and the source of the transaction |
01173763 |
TRANSACTION_TYPE |
11 |
Identifier for type of transaction. |
Expense |
EXPENSE_AMOUNT |
17.2 |
Posted amount of salary and fringe expenditures. |
00000000001000000.00 |
ENCUMBRANCE_ AMOUNT |
17.2 |
Posted amount of salary encumbrances. |
00000000001000000.00 |
ORIGINAL_ENC_AMT |
17.2 |
Posted amount of the original salary encumbrance. |
00000000001000000.00 |
APPT_EFF_DATE |
8 |
Beginning Date of Appointment within Fiscal Year. |
20030701 |
APPT_END_DATE |
8 |
End Date of Appointment within Fiscal Year. |
20040630 |
APPT_BASE_RATE |
11.3 |
The base rate for the appointment. |
Either an hourly rate or a yearly salary. |
PAY_BASIS |
1 |
Pay Basis |
“A” for Academic; “C” for classified. |
TITLE_CODE |
5 |
Numeric Title Code |
e.g. 00265 |
TITLE_DESCR |
30 |
Description connected to the Title Code |
e.g. Accountant-Advanced |
OPR_ID |
32 |
SFS operator ID. You may only see this in salary cash transfers. |
|
SALARY_COST_TRANSFER |
3 |
Indicates if the transaction was a Salary Cost Transfer |
A value of “SCT” indicates the transaction is a Salary Cost Transfer. |
CALC_ID |
9 |
Payroll Calc ID. YYYYMM plus a number. |
e.g. 200406100 |
CALC_DESCRIPTION |
30 |
Description of Calc ID |
e.g. “May Regular Unclassified”. |
CALC_EARN_PER |
6 |
Period of earnings related to the Calc ID. |
e.g. 200405, 200405A, 200405B. |
CALC_PAY_DATE |
|
Pay Date relating to the Calc ID. |
e.g. 20040601 |
CALC_PERIOD_TYPE |
1 |
Indicates the period and type of calc. |
“A” for the A Student or Classified calc; “B” for the B Student or Classified calc; “C” for the C Student or Classified calc; “M” for the Regular Unclassified. |
TRANSACTION_DATE |
8 |
The date of the transaction formatted as YYYYMMDD. |
20030715 |
POSTED_DATE |
8 |
The date that the transaction was posted to SFS – formatted YYYYMMDD. |
20030715 |
JOURNAL_ID |
10 |
A code that identifies a journal in SFS. The beginning of this number has meaning as listed in the next column. |
The beginning of this number has meaning as follows:
|