Penn: Business Enterprise Network (BEN)

	Business Enterprise Network
	BEN Financials Home
	Frequently Asked Questions
	Advisories
	Closing Schedules
	Logging On
	Desktop/Printer Standards
	Documentation
	Training
	Security Access
	Enhancement Requests

	Document/Forms
	Contact Information
	Feedback

University of Pennsylvania
Suite 318 Franklin Building
3451 Walnut Street
Philadelphia, PA 19104
215.746.4357 (Phone)
215.898.0817 (Fax)

[ BEN Financials ]

921. Active Users with Org Security Extract
Documentation :|: BEN Balances Report Documentation :|: Quick View

* Return to Quick View List

Last Updated: 04/19/02

This process is designed to provide a detail extract of “active” BEN Financials users with their current responsibilities and Org security. If a responsibility is secured, the extract will contain one record or line for each Org or Org range assigned in the user's security profile for that responsibility. The procedures to run an extract can be found in the BEN Balances Report Documentation>Report Extracts.

This extract is unsecured and can be run from the Senior BA Reporting Responsibility.

Sort Order:

The extract file is not sorted in any particular order. Since this is a "generic" extract designed to serve multiple purposes, each user can choose how best to sort the data once it has been transferred to a local workstation.

Parameters:

This extract has the following parameters:

Enter a valid File Name (no spaces) in the FILE NAME parameter- The extract will need the file name to determine how to name the extract file. Spaces and special characters are not allowed in the file name- an error will show up in the Request Log.
Enter the 2-Digit Center Number (required only if the ORG is blank)
Enter the ORGanization (required only if the CENTER is blank)

*In order for the extract to run, either the Center or the Org must be entered. The extract will fail with an error if both parameters are left blank. The extract will also fail with an error if both parameters are entered. Errors will show up in the View Log of the Requests form.

File Layout:

From left to right, the columns will provide the following information:

Field Position #	Column Name	Description	Maximum Length
1	User Name	Name end user enters onto the logon screen when accessing BEN Financials	240
2	Name	Full Name of End User (LAST, FIRST MI)	240
3	Responsibility	End Users' Active BEN Financials responsibilities	240
4	Email Address	Email address associated with the End User	240
5	Home ORG Value	4-digit number assigned to school/ center for which the report is being run	4
6	Home ORG Name	Name of the ORGanization that manages the End User and their responsibilities	60
7	ORG Security (Low)	Range of ORGs within an End Users Security Profile	4
8	ORG Security (High)	Range of ORGs within an End Users Security Profile	4

File Transfer:

When the request completes successfully and the file has been created under the specified name, it will automatically be placed in the user's home directory on the BEN Financials FTP server, where it is available for transfer to the user''s workstation. The file name will be the name provided in the parameter at the time the extract was submitted. For more information, please refer to Section 8, REPORT EXTRACTS at http://www.finance.upenn.edu/ben/benfin/documentation/reportdoc/

Note: Files will remain on the FTP server for a period of 5 days. After that time, the files are deleted in order to manage the space on the server.

Comptroller Spotlights

	New Category Codes
	2007 Financial Report
	GL Object Codes FY09
	FY08 Closing Instructions

BEN Offices

	BEN Deposits
	BEN Financials
	BEN Reports

Visit Penn's website