Oracle's Virtual Private Database (VPD) is a tool that
allows users of a combined database to access their own, and only their own,
data in specific tables. Oracle
"filters" the data before it reaches the application using it.
In the new SIS environment, there are currently two tables,
PS_INSTALLATION_FA and PS_INSTALLATION_SF, each of which originally contained
one row (record) shared by everyone.
The concept of VPD allowed us to create multiple records,
one for each application server. When
the user logs on to the SIS, the application server is used to determine which
row the SIS "sees". To
maintain data integrity, the rules used by VPD are such that if VPD does not
recognize the application server through which the user logs on, any access to
the table(s) on which VPD has been placed will cause a "policy
predicate" error to be generated. Since
the applications were written to believe that only one row exists in these
tables, and VPD supplies only one row, the application functions as designed.
Executing processes (pressing
) presented a different scenario. When executed on the "client", the process
re-establishes a connection with the database.
If the process is designed to access a table on which VPD has been
applied, the process will receive an error because the connection did not come
through an application server. On
the other hand, the application server information is "passed" to the
process when it is executed on the "server".
For this reason, we have modified the process definitions of the
"affected" programs, forcing them to execute on the USEME server.
Although we can force them to execute on the USEME server, we are not
able to "gray out" the option to select "client", and
neither are we able to limit the choice of "servers" from which to
choose. Therefore, although the Run Location is still available in
the Process Scheduler Request window, it is not used and will have no affect on
where the program executes.
Executing processes, especially report processes (usually SQRs) presented another hurdle � How does one retrieve their output? We have developed a procedure to automatically move report output from the server to the PSCONV\PSREPORTS folder in a sub-folder named for the instance (PRODSIS, PRODDEV, etc.). The name of the report output is created using the process name (e.g., SFPCLCAN) and process instance (e.g., 214866) and usually a file extension of .lis. In this case the output file would be named SFPCLCAN_214866.lis.
Some processes create output files as well as
reports. Previously the values
entered were generally in the Drive:\path\filename.ext format, e;g., C:\TEMP\VENDOR.DAT.
This is no longer the case. The
USEME server is on a machine that does not use a Windows operating system and
therefore has a different file structure. Therefore,
you must now supply a Unix-style path. The
format of this new path is:
/ut70/home/psdata/psreports/instance/filename.ext
Instance would be prodsis for Production and proddev
for PRODDEV. Note: The
path name is case sensitive and must be entered in lowercase. (You
must also use lowercase true for the output destination File/Printer:
designation on the Process Scheduler Request panel when you press the �stop
light�
to run the process.)
It is suggested that the filename be such that it is easily distinguished
from other colleges� files, e.g., BRVENDOR.DAT
and BRVOUCHER.DAT for Blue Ridge�s vendor and voucher files.
Listed below are the identified processes that must run on
the USEME server.
|
Process Name |
Navigation |
Process ID |
|
ISIR
Load (Cobol) |
Go,
Administer Financial Aid, Exhange Financial Aid Data, ISIR Load |
FAPSAR00 |
|
NSLDS
Transfer File Alert |
Go,
Administer Financial Aid, Exhange Financial Aid Data, NSLDS FAT Load |
FAPTALRT |
|
Verification-Batch
Consolidation |
Go,
Administer Financial Aid, Manage Need Analysis, Batch Consolidation |
FAPTFSCL |
|
Verification-Batch
Verification |
Go,
Administer Financial Aid, Manage Need Analysis, Batch Verification |
FAPCMPR1 |
|
Mass
Budget Move |
Go,
Administer Financial Aid, Manage Need Analysis, Bdgt Assign/Assign Budget |
FAPBDGTM |
|
Mass
Budget Formulas |
Go,
Administer Financial Aid, Manage Need Analysis, Bdgt Assign/Process
Forumulas |
FAPBDGTF |
|
Mass
Budget Tuition/Tree |
Go,
Administer Financial Aid, Manage Need Analysis, Bdgt Assign/Process
Tuition |
FAPBDGTT |
|
Mass
Budget Select |
Go,
Administer Financial Aid, Manage Need Analysis, Bdgt Assign/Select
Students |
FAPBDGTS |
|
Budget
Table Maintenance |
Go,
Administer Financial Aid, Manage Need Analysis, Bdgt Assign/Table Maint |
FAPBDGTD |
|
Process
Pell Adjustments |
Go,
Administer Financial Aid, Manage Need Analysis, Pell Adjustments |
FAPPBGTB |
|
Mass
Packaging Assign |
Go,
Administer Financial Aid, Package and Disburse Aid, Mass Packaging Assign |
FAPPKASN |
|
Mass
Packaging Update |
Go,
Administer Financial Aid, Package and Disburse Aid, Mass Packaging Process |
FAPPKBKG |
|
Mass
Packaging Select |
Go,
Administer Financial Aid, Package and Disburse Aid, Mass Packaging Select |
FAPPKSEL |
|
Commonline
Inbound Files |
Go,
Administer Financial Aid, Process Loans, Commonline Loan In |
FAPLCID4 |
|
Commonline
Outbound Files |
Go,
Administer Financial Aid, Process Loans, Commonline Loan Out |
FAPLCOD4 |
|
Create
Pnote & Comm. Recs |
Go,
Administer Financial Aid, Process Loans, Create DL Pnote Comm |
FAPLDPN2 |
|
Direct
Loan Inbound Files |
Go,
Administer Financial Aid, Process Loans, Direct Loan In |
FAPLDID0 |
|
Direct
Loan Outbound Files |
Go,
Administer Financial Aid, Process Loans, Direct Loan Out |
FAPLDOD0 |
|
Loan
Origination |
Go,
Administer Financial Aid, Process Loans, Loan Origination |
FAPLBOG1 |
|
Pell
Originations/Disbursements |
Go,
Administer Financial Aid, Process Pell Payment, Pell Origination |
FAPPLBL0 |
|
Pell
Inbound Files |
Go,
Administer Financial Aid, Process Pell Payment, Pell Process In |
FAPPIDR0 |
|
Pell
Outbound Files |
Go,
Administer Financial Aid, Process Pell Payment, Pell Process Out |
FAPPODR0 |
|
Mass
Build of FATERM (Cobol) |
Go,
Design Student Administration, Design Financial Aid 1, 2. Build FA Terms |
FAPTRMU1 |
|
Program
for Payment Plan |
Go,
Manage Student Financials, Administer Payment Plans, Process, Re-Calc
Payment Plan |
SFPPLNCL |
|
SF
Third Party Process |
Go,
Manage Student Financials, Administer Payment Plans, Process, Re-Calc
Third Party Contracts |
SFPTPPRC |
|
Billing
Cancellation |
Go,
Manage Student Financials, Bill Customers, Process Bill Cancellation |
SFPUNPRC |
|
Invoice
Batch Process |
Go,
Manage Student Financials, Bill Customers, Process, Billing Request |
SFPBIPRC |
|
Invoice
Batch Process |
Go,
Manage Student Financials, Bill Customers, Process, Billing Request Corp |
SFPBIPRC |
|
Recalc
for Term Cancellation |
Go,
Manage Student Financials, Calculate Tuition and Fees, Process, Tuition
after Cancellation |
SFPCCALC |
|
Student
Fees Calc (Batch) |
Go,
Manage Student Financials, Calculate Tuition and Fees, Process, Tuition
for Multiple Students |
SFPBCALC |
|
Tuition
Residency Calculation |
Go,
Manage Student Financials, Calculate Tuition and Fees, Process, Tuition
Residency |
SFCALTUI |
|
Class
by Class Cancellation |
Go,
Manage Student Financials, Maintain Receivables, Process, Enrollment
Cancellation |
SFPCLCAN |
|
Group
Posting Process |
Go,
Manage Student Financials, Maintain Receivables, Process, Posting Groups |
SFPGRPST |
|
Table
Validation Report |
Go,
Manage Student Financials, Maintain Receivables, Process, Table Validation |
SFTBLVAL |
|
A/P
Refund Processing |
Go,
Manage Student Financials, Refund Customers, Process, AP Refund |
SFAPRFND |
|
Batch
Refund |
Go,
Manage Student Financials, Refund Customers, Process, Batch Refund |
SFPREFND |
|
SF
Cashiering GL Interface |
Go,
Manage Student Financials, Run Cashiering, Process, Cashiering GL
Interface |
SFDPTREC |