|
Notes for Application Programmers
If you are a new application programmer, these are notes on things you need to know. These are not official requirements, but rather more like guidelines. A few are geared mainly to the major administrative systems of SIS, HRS and FRS.
|
1. Email
While there are several email systems on campus, you will be assigned a
Microsoft Exchange account.
Microsoft Outlook is your email software.
Your userid or email address will be formatted as
xxxxxx@email.uky.edu where xxxxxx is your userid.
The initial password will be set to small u$ followed by the last
six digits of your social security number.
Your name is added to the global directory by filling out the form
on the Directory Update Page
on the web.
Your UK ID is your social security number (all nine digits with no dashes).
You cannot be added to the global directory until Human Resources has completed
their entry of you into their system - this sometimes takes three or four days after you are hired.
UK and Microsoft have a licensing agreement
which allows employees to install certain products on their home machines for business use.
You may get instructions from the
Customer Service Center Help Desk (first floor McVey
Hall) for installing email on your home computer.
You have been subscribed, by your manager, to the Applications Listserv known
as APPLSTAFF-L.
You may post to it by sending email to
applstaff-l@lsv.uky.edu.
Feel free to use it to circulate information or if you need to request information.
If you are required to create or maintain a listserv, the documentation is
on the web at: lsv.uky.edu.
Separate from your email account, you will also need a
U-Connect account to accommodate such things as
downloading software.
2. MVS
MVS
is an operating system on an
IBM host.
UK upgraded to OS/390 during August 1998, then to Z/OS during the summer
of 2003 - both are recent releases of IBM's MVS operating system.
The host is UKCCB.UKY.EDU.
You can access MVS via TSO and
run batch jobs against MVS via TSO.
You can also run batch jobs against MVS via
VM although we are moving away from that method.
The UK Bookserver has manuals
for the Z/OS Operating System including COBOL manuals.
Hummingbird's Host Explorer is used to connect to the IBM host - both from your
office or from a more remote site such as your home. You can download
Host Explorer software from UK's download site.
3. TSO
You get to TSO by logging on to UKCCB.UKY.EDU.
To view most files, you enter "p.3.4" on the command line, then
enter the dataset name beside the "Dsname Level" literal on the
Data Set Utility List screen.
There are several manuals on TSO and even a couple on ISPF on
the UK BookServer but they may be changed to another location in the
near future.
Some very basic instructions will get you started.
There are handouts from a course once taught
in the Applications Group which will also be of help.
Dataset Naming Conventions
The naming convention for SIS is something like this: OAR.TEST.jobname.stepname.ddname,
meaning OAR.TEST.BXBJA200.A0BBA200.SYSIN--(+0) is the filename
for the SYSIN DD statement in the first step of job BXBJA200.
The first step executes program BBA200. We use generation
data groups (GDGs) and we pad low level qualifiers to 8
positions with dashes.
The Standards Document (STANDARD SCRIPT)
has greater detail on naming conventions.
JCL and Procedure Libraries
Most developmental JCL for SIS is stored in IDMSMIS.SIS.TEST.SCHEDULE.JOBX.MVSJCL.
You may create your own PDSes for JCL and PROCs. The prefix
should be your userid. You will have access to create development
files (files prefixed by OAR.TEST) and may have access to create
some production files (OAR.PROD prefixes). Until you are more
familiar, it is safer to create files with your userid as the
highlevel prefix.
Utilities
Compile and Link JCL
Load Libraries
For HRS, FRS & FES:
Once again, you may create your own to become familiar.
4. IDMS
IDMS is the database system where UK's major administrative systems reside.
The Database Administrators have provided a website for IDMS developers.
You can enter and change data in the development systems.
Data
Application Development Tools
User Menus or Screens
Online Help
If you press PF1 on any screen, you go to the Online Reference
System where you may enter a program name (i.e. SBA800 - must
be in caps) to see program documentation.
How to Logoff
The UK BookServer has manuals for IDMS14.
IDMS manuals are also available via the Book Manager in TSO.
Here are some Mini Diagrams used in the past
to simplify the SIS component.
5. VM
VM is an operating system we are moving away from but many folks
still find it helpful. The host is UKCC.UKY.EDU.
You may submit batch jobs against MVS from it.
You may send and receive mail on it as xxxxxx@ukcc.uky.edu
(where xxxxxx is your userid) although we are encouraged to
use Microsoft's Outlook and our Exchange account instead.
Logon and Logoff Procedures
CMS
The format for CMS or VM files is "filename filetype filemode".
There are some very old notes on using VM, CMS and XEDIT.
Changing Your Password
File Transfer Protocol (FTP) from VM
See notes on FTP Procedures.
6. Librarian
Librarian, another Computer Associates product, is the software used to modify and store source code.
You may submit JCL from TSO (or VM) to select and punch members,
add new members, update members, list an index of all members, and
delete members. There is a batch version of Librarian and, also, an online
interactive version known as ELIPS which is accessed through the
Z/OS ISPF Master Menu (known as TSO to most of us).
Librarian Source Code Master File
The name of the Librarian source code dataset for HRS is "IDMSMIS.HRS.PROD.SOURCE".
The name of the Librarian source code dataset for FRS is "IDMSMIS.FRS.SOURCE".
The name of the Librarian source code dataset for FES is "IDMSMIS.FES.SOURCE".
Program Naming Conventions
Vendor Delivered Programs
Programs Written In-house
Standards Document
99% of our source is written in COBOL.
The UK BookServer has manuals on Librarian.
7. Program Modifications
Change Files
Delivery and Storage of Modifications
As of March 2000, programmers are required to use the
Change Control System.
The Change Control System requires an account on the
UK Web Server.
Large deliveries are sometimes delivered from an
SCT website and must be
downloaded from there. And sometimes, they are delivered on tape
or cartridge via regular postal mail.
See notes on installing SCT modifications
and major upgrades from SCT.
Help Messages
Modification and Program Name Indexes
Modification Marking
Newly created production jobs must adhere to several requirements. Here
are some guidelines.
8. The Web and Internet Browsers
Microsoft's Internet Explorer is our preferred and supported browser.
The URL for UK's main home page is www.uky.edu.
There is a LOT of information there. i.e. Human Resource policies
and procedures, campus maps, schedule of classes, phone numbers, etc.
We still have occasional need to review old projects documented on the web such as
the
SIS Y2K Project.
You have been given an account on the
UK Web Server as www.uky.edu/~userid where
userid is the same as your email account userid.
You are encouraged to become familiar with web tools and techniques by creating
a home site. The UK Web Server is a Unix operating system, so you may need to
learn a
few Unix commands. You are responsible for adhering to
UK's policy governing web use.
Each team is responsible for maintaining
their respective sites which are linked from the
Applications Programming website.
There is Unix help on the UK Web Server.
Web help is also available on the UK Web Server.
There is also
HTML Help stored on our website which may be helpful.
9. Report Writers
Programmers generally use OLQ, CULPRIT and ZWriter. Some also
use FOCUS, Brio and Crystal. There are some notes on CULPRIT to get you started.
Documentation for ZWriter can be found by going to the IDMS/SIS menus and
entering "ZWS" as the screen. There is a ZWriter Element List stored on
VM account FAMS (which you may GRAB). The name of the file is WJASIS HELPTASK.
A schema listing is helpful for CULPRIT reports - SCHEMA OUTPUT is also stored
on the FAMS VM account.
OLQ and CULPRIT are Computer Associates products. ZWriter is an SCT product.
FOCUS is used by a segment of the Computing Center which specializes
in adhoc report writing for users.
10. Time Reporting
Programmers use
Microsoft Project 2000 to record their time spent on tasks and projects.
MS Project 2000 resides on the Grabthar server under the MSProject folder. Each team
has a person responsible for gathering and submitting the time entries to
Project Central. That person
also provides a
task list on a weekly basis to
Data Administration for review by the data stewards and data custodians.
Time reporting, prior to Microsoft Project, was stored on the SuperOne server.
11. Supported Software
Software supported by UK can be downloaded from the
UK download site. Questions
regarding supported software should be directed to the
Customer Service Center Help Desk.
Prior to March 1, 2000, the McVey Server was used as the download site
for UK supported software.
During January 2001, our ability to TELNET became unavailable. Instead,
we are using a utility known as puTTY which can be downloaded from
download.uky.edu/SSH_w_m.html
and installed on your workstation.
12. Windows
Microsoft Windows 2000 (although we are moving toward XP) is the supported operating system for the PC in your
office. If you must install Windows, there are some notes on how
to do it.
If you need to map a drive on your machine to the UK Web Server, here are some
instructions on drive mapping.
You can install a licensed copy of Microsoft Office from the
UK download site.
Microsoft Office includes Outlook (email), MSWord (word processing), Excel (spreadsheet software),
Access (database), and PowerPoint Presentation software.
You will receive email containing attachments created by MSWord and Excel
and will be expected to maintain documents in these formats.
You are responsible for keeping your operating system and software updated to
the current supported releases, for promptly installing security patches and
ensuring that your machine is virus free and not vulnerable to hackers.
13. Major Administrative Systems
SIS,
HRS
and FRS are purchased software systems supported and maintained by the
Applications Programming Group at the UK Computing Center. The
systems were purchased from
SCT Software. The batch parts of
the systems are written, mainly, in COBOL and MVS JCL. The online
portions are written, mainly, in IDMS/ADSO. The systems run on an
IDMS database on an IBM host.
14. Absence Report
Whenever you are away from the office such as vacation, illness, or
official University travel, you are required to fill out an absence
report and give it to your manager. The form is available on
UK's FORMS website.
15. More Help
There is also helpful documentation prepared by the HRS team at
www.uky.edu/IS/AdminApps/HRS/HowTo/welcome.html.
16. Holidays, Severe Weather & Special Events
Prepared by Sarah N. Hall - August 1998 Sarah N. Hall, Information Technology Manager
You are Inquiring Mind
UK |
Information Technology |
IT Departments |
IT&HS |
Computing Center |
Applications Programming
TSO is the software you use to
- view and edit MVS disk datasets via ISPF
- submit MVS batch jobs via ISPF
- perform utilities such as allocating datasets, copying datasets,
creating datasets, deleting datasets via ISPF
- monitor MVS batch jobs via SDSF
- view and edit ACF security access rules (see notes on TSO Access)
- view documentation for several systems
- use the online Librarian ELIPS
- use the Smart Scheduler (see notes on Smart Scheduler)
- use Beta93 to view certain reports and job output
(see notes on Beta93)
There is a website prepared by the Beta93 Triage Team which contains
documentation on the Beta93 Online Viewing System.
Most of the user datasets for SIS begin with "OAR.TEST" for development and "OAR.PROD" for production.
Most of the user datasets for HRS begin with "HRS.USER" or "HRS.PROD".
Most of the user datasets for HRS begin with "HRS.USER" or "HRS.PROD".
For SIS:
Most production JCL is stored in IDMSMIS.SIS.PROD.SCHEDULE.JOBX.MVSJCL.
The corresponding procedure library is IDMSMIS.SIS.PROD.SCHEDULE.JOBX.JOBLIB.
These two datasets are used by Smart Scheduler to run SIS batch jobs.
The corresponding procedure library is IDMSMIS.SIS.TEST.SCHEDULE.JOBX.JOBLIB.
There are some basic utilities stored in
IDMSSIS.FAM.TEAM.JCL. Things like LIBPUN to punch a member
from Librarian and LIBNDX to get a Librarian index listing.
UK recently underwent an upgrade to a newer MVS operating system
known as Z/OS and we run under LE370 which is a language
environment.
A team member can point you to the current JCL to use for
compiling and linking. Batch COBOL programs are compiled
with different compile and link parameters from those used to compile
online DC COBOL programs.
For SIS:
The load libraries for production programs are IDMS.SISP.BATCH,
IDMS.SISP.ONLINE and IDMS.SISP.REMOTE. For development, SISP
becomes SISD.
The load libraries for production programs are IDMS.BISP.BATCH and
IDMS.BISP.ONLINE. For development, BISP
becomes BISD.
The database software vendor is Computer Associates.
The application software vendor is
SCT (formerly Pinnacle Software Corp.)
The host is UKCCB.UKY.EDU.
UK's Human Resource System (HRS), Faculty Effort System (FES) and Financial Reporting
System (FRS) are also under IDMS.
SIS, HRS, FES & FRS development menus are under CV1.
SIS production menus are under CV2.
HRS, FES & FRS production menus are under CV3.
You can submit MVS batch jobs to inquire against and update the database.
There are two main types of data in the database - user data and
software.
User data is the information regarding students, classes, etc.
The software data which you are able to modify includes:
record formats, maps, tables, elements, dialogues, etc. - all
stored in IDD (Integrated Data Dictionary).
Several different tools are used to view and maintain the database
software. Some of those are:
IDD - allows you to view and modify certain types of entities.
MAPC - allows you to view and modify the maps.
ADSC - allows you to view and modify the dialogs which are
written in a language from Computer Associates known as
ADSO - appears similar to COBOL but lots of differences.
Dialogs generally have 3 main parts.
1)The DIALOG itself - named something like IASDL326.
The IA prefix simply means it was delivered from
Pinnacle (formerly known as Information Associates).
The third character designates the SIS component.
The DL indicates the member is a Dialog.
The last three characters are the screen number
a user enters to see a certain online menu.
2)A corresponding PREMAP. The premap
for dialog IASDL326 is IASPR326, where the PR designates
PRemap
3)A corresponding RESPONSE PROCESS.
i.e. IASRP326 where RP indicates Response Process. The
premap and response processes may link to other dialogs
or online DC COBOL programs and subroutines.
To use the online menus,
- connect to UKCCB.UKY.EDU
- at the UK logo screen, press pf2 and ENTER
- choose IDMSDC1 for development or IDMSDC2 for production
(you make the choice by moving your cursor to the desired line
and pressing ENTER)
- enter your userid and password, then press ENTER
- select SIS-DVL or SIS-PROD by placing any character on the
desired line and pressing ENTER
- you should be at the SIS main menu (screen 001)
- you may go to other screens by entering their number in the
action line beside the literal "SCREEN:"
- Main Menus for each SIS component are
001 for Shared Components
201 for Admissions
301 for Financial Aid
401 for Billing & Receivables
601 for Degree Audit (OnCourse)
- Other information that may be necessary on the action line:
INST (institution) - always UK
AU (academic unit) - LC for Lexington Campus
AU is not used for the 3xx series of screens
FIN UNIT (financial unit - UK for Lexington Campus
FIN UNIT is used only for the 3xx
series of screens
SID (student Identification) - a student's social security number (no dashes)
TERM - 985 is used for the fall term of 1998
YR and SES (award year and session) - used for 3xx series of
screens only. For the fall of 1998, the year is 99 and
the session is 1.
The values to enter for Term, Award Year and Session are sometimes confusing
to beginners. There is a chart which explains the relationship between
Term as it is used in Student Records applications and Award Year and Session
as they are used in Financial Aid applications.
To see permissible values for any fields on any screen, including those
on the action line, position the cursor on the field to be entered and
press PF2 (or F2). This function is called field help.
If you position the cursor on a non-entry field
and press PF2, screen help will be displayed - general information
about the screen.
To exit the menus, press the HOME key, until you are at the
Main Menu where you select SIGNOFF by placing any character
beside the SIGNOFF literal followed by f3 at the SuperSession menu.
To logon to VM: Connect to UKCC.UKY.EDU.
Then, at the UK logo screen, enter your userid and password.
To logoff from VM: Enter LOGOFF.
CMS is the shell with which to communicate with VM.
Some CMS commands:
Q RDR ALL - to see a list of files in your reader list. These will
be files folks have sent you, output from MVS batch jobs submitted from VM,
any mail sent to your UKCC account.
RL - is another way to see files in your reader list
pf3 - used to back out of things.
pf7 - used to scroll backward.
pf8 - used to scroll forward.
XEDIT - to edit a file.
Q DISK - to see which disks you are attached to.
GRAB xxxxxx - to access another VM account.
Note: If you change your password while on VM, MVS or IDMS, it may or may not
automatically change to the same password for the other two systems.
The name of the Librarian source code dataset for SIS is
"IDMSSIS.SISD.G0001V00.SOURCE".
The SISD implies development (as opposed to SISP for production),
but there is only one used for both development and production.
We use the archiving option when members are changed, thus creating
a new level number.
Most of SIS programs (delivered from SCT) are stored in the
SIS Librarian source file with names like SBA800, BBA200, RBA350,
ABA900, etc.
The beginning character indicates SIS components as follows:
A - Shared Components
B - Billing & Receivables
D - Degree Audit (sometimes referred to as OnCourse)
M - Admissions
R - Student Records
S - Financial Aid
Z - ZCore Components
The beginning character indicates HRS components as follows:
E - Human Resources
The beginning character indicates FRS components as follows:
F - Financial Accounting
V - Accounts Payable
P - Purchasing
For most programs, you will also find another version which has a
"C" prefix - i.e. CSBA800, CBBA200, CRBA350, etc. This is the original
version, as it was received from the vendor.
It is never modified. The non-C-prefixed versions contain
our modifications.
We also have several in-house written programs. Their names are
usually like UXSBIAM, UXRBIAB, etc. They begin with "UX" meaning
SIS in-house and the third character designates the
SIS component.
The Standards Document STANDARD SCRIPT
explains naming conventions in greater detail.
We use "change files" to maintain modifications to the source. Change
files include Librarian commands such as -INS to insert lines and
-REP to replace lines of code.
As of 9/23/98, UK accounts were created with SCT/Pinnacle's
Client Service Network (CSN) so team members receive
modifications via email as postings to listserv
mailing lists (UKSIS-L for SIS). The modifications are stored by team members
in MVS PDSes.
For SIS:
Change Files - IDMSMIS.SIS.DOC.CHANGES
Migration Requests - IDMSMIS.SIS.DOC.MIGRATE
SCT Mods - IDMSMIS.SIS.DOC.REQUEST (individual TOSes) and
IDMSMIS.SIS.DOC.TOSMODS (summary list)
In-house Mods - IDMSMIS.SIS.DOC.TOSMODS
Production JCL - IDMSMIS.SIS.PROD.SCHEDULE.JOBX.MVSJCL
Production Procedures - IDMSMIS.SIS.PROD.SCHEDULE.PROC.JOBLIB
Production Documentation - IDMSMIS.SIS.PROD.SCHEDULE.PROC.JOBDOC
Development JCL - IDMSMIS.SIS.TEST.SCHEDULE.JOBX.MVSJCL
Development Procedures - IDMSMIS.SIS.TEST.SCHEDULE.PROC.JOBLIB
Development Documentation- IDMSMIS.SIS.TEST.SCHEDULE.PROC.JOBDOC
In-house Program List - IDMSMIS.SIS.DOC.SISPGMS
For HRS:
Development Change Files - IDMSMIS.HRS.TEST.G4V0.CHANGES
Production Change Files - IDMSMIS.HRS.PROD.G4V0.CHANGES
Migration Requests - IDMSMIS.HRS.TEAM.DOC.UKTOSMOD
SCT Mods - IDMSMIS.HRS.TEAM.DOC.IATOSMOD
In-house Mods - IDMSMIS.HRS.TEAM.DOC.UKTOSMOD
Production JCL - IDMSMIS.HRS.PROD.G4V0.JOBSUB.MVSJCL
Execution JCL - IDMSMIS.HRS.PROD.G4V0.JOBSUB.JCLLLIB (rebuilt daily)
Production Procedures - IDMSMIS.HRS.PROD.G4V0.PROCLIB
Development JCL - IDMSMIS.HRS.TEST.G4V0.JOBSUB.JCLLIB
Development Procedures - IDMSMIS.HRS.TEST.G4V0.PROCLIB
For FRS:
Change Files - IDMSMIS.FRS.PROD.F5V0.CHANGES
Migration Requests - IDMSMIS.FRS.TEAM.DOC.MIGRATE
SCT Mods - IDMSMIS.FRS.TEAM.DOC.TOSMODS
In-house Mods - IDMSMIS.FRS.TEAM.DOC.HELPMSG
Production JCL - IDMSMIS.FRS.PROD.F5V0.JOBSUB.MVSJCL (pre-build JCL)
Scheduler JCL - IDMSMIS.FRS.PROD.F5V0.JOBSUB.JCLLIB
Production Procedures - IDMSMIS.FRS.PROD.F5V0.PROCLIB
Development JCL - IDMSMIS.FRS.TEST.F5V0.JOBSUB.MVSJCL
Development Procedures - IDMSMIS.FRS.TEST.F5V0.PROCLIB
Batch Job Documentation - IDMSMIS.FRS.PROD.JOBDOC
Files containing the modifications from SCT are named something like
Sxxxx726 where the prefix designates the SIS component and the last three
characters are a sequentially assigned number. They have a file
type of "HELPMSG". In-house modifications also have a HELPMSG file.
The filename for in-house modifications is prefixed with a U followed
by a three digit sequentially assigned number.
Lists of in-house modifications and in-house programs are stored on MVS.
For SIS:
Modifications Index - IDMSMIS.SIS.DOC.TOSMODS
In-house Programs Index - IDMSMIS.SIS.DOC.SISPGMS
We also use a procedure known as "mod markers" where all changes to
source code are indicated in columns 1-6 (of COBOL programs).
Currently (9/2003), there are plans to migrate to MS Project 2002 and MS Project
Server.
McAfee Anti-Virus software is available from the
UK download site.
Microsoft operating system updates are available directly from
Microsoft's website.
Microsoft Office updates are available directly from
Microsoft Office website.
For SIS, the Registrar's Office has prepared an
online User Guide.
Revised October 10, 2001
Revised September 12, 2003
Revised January 15, 2004 (forms link only)
University of Kentucky Computing Center
225 McVey Hall
Lexington, KY 40506-0045
sarah@email.uky.edu
859.257.2900x271 voice
859.323.1978 fax
to visit this site.