Tools--PSU.LIB

Office of Information Services - Application Programming

PSU.LIB Tools



OS.LIB   --   Systems level and database level programs. Some application level programs have been stored here.
PSU.LIB   --   Applications level programs generic enough to be used across a wide variety of accounts and applications.


NameDescription/ExampleAuthorTypeGNotes
AGE Send internal formatted birthdate and return persons age based on today's date. L. Weaver Subr Y
ANALYZE.CATALOG.SAVEDLIST Input a savedlist to display cataloged information. D. Stuckey Prog Y
APP.EMAIL.ADDRESS Returns email addresses (ADDRESSES) for persons associated with a particular application or group of applications (APPLICATION.NAME - the record key in APPLICATION.EMAILS file.). L. Weaver Subr Y Additional Information
(use back to return)
APP.USED.MSG Used in a paragraph to list when and who last used application. Requires application name and email address.
i.e. VOCLIB PO.ENTRY
K. Sanley Prog N
BUILD.NAMES.XREF Combine name fields to enhance name search capabilities. K. Sanley Prog N ONLY used by KSanley and/or MBrennan.
CHANGE Change occurrence of string to new.string. S. Sesher Func Y
CHANGE.DIRECTION Reverse the order of a multi-valued field from any dictionary. T.Vaughan Subr Y
CHANGE.SUBR Change occurrence of string to new.string. S. Sesher Subr Y
CHANGE.VM.FM Input savedlist to remove blank lines and to break @FM into new lines. K. Sanley Prog N Use with "Select filename Saving Unique fieldname" where fieldname is multivalued.
CHECK.DUP.ADDRESSES Input a savedlist of ID's to check for duplicate addresses and store selected ID's in a savedlist. person Prog
CHECK.DUP.IDS Build a list of duplicate ids not in FILES.USED and of corresponding ids that do not contain the same primary and secondary fields. Prog N
CHECK.FILES.USED Build a list of primary and secondary id's not listed correctly on their corresponding id records. Prog N
CHECK.FILES.USED.SSN Build a list of secondary id's not found on POEPLE and of primary and secondary id's whose ssn do not match. Prog N
CHECK.FOR.CATALOG Build a savedlist of the current accounts cataloged pointer (V) records that reference a program not cataloged. K. Sanley Prog N
CHECK.FOR.VOCLIB Build a savedlist of the current accounts voc records that point to a VOCLIB that doesn't exist. K. Sanley Prog N
CHECK.LOGIN Prior to executing, you need to run GET.LOGINS. See Program for instructions to ftp log file to &HOLD&. K. Sanley Prog N
CHECK.PROGRAM.NAMES Builds a master savedlist of duplicate program names and savedlists by account for accounts listed in program. K. Sanley Prog N
CLEAN.ADDRESS Enter a savedlist and indicate cleanup on Permanent or Local address field to removed blank field lines. K. Sanley Prog N
CLEAN.OIS.PROJECTS Convert CHAR(010) and (013) to a blank space. K. Sanley Prog N Stuff coming from web contains these 2 CHAR which throw stuff out of alignment.
CLEAN.PREFERRED.MAIL Use to clean up ".pittstate.edu" address that are no longer valid. Enter the savedlist of people to clean up.
NO verification is preformed on the list, so make sure the list contains addresses to be deleted.
K. Sanley Prog N Use Extreme Caution when running. Check with Scott Parish or Kathy Sanley before executing.
CLEAN.PROGRAMS Enter in file and savedlist of files to move to SOURCE.HOLD (indexing added to file name). Locate and delete any compiled or cataloged version. K. Sanley Prog Y
CLEAN.RECORDS Select record(s) from CONTROL.POINT CLEAN.RECORDS when expires date is less than today and expires not null then delete that record.
Add a new line for each file that needs to be looked at.
The file being looked at needs an EXPIRES field
(i.e. FORM.1098.ARCHIVE).
This program automatically runs once a month.
K. Sanley Prog N Runs Monthly.
CONVERT.DICT.TABS Separate fields with tabs in dict GL.ACTIVITY.MO. Prog N
COPY.DICT.TO.HOLD Copies dictionary items lines 1-6 to SOURCE.HOLD (indexing added to dictionary name). Enter in dictname and select to process either savedlist, dict F2 string selection, or enter in record name(s). Dictionary items are not deleted from the dictionary. D. Stuckey Prog Y
COPY.TO.HOLD Copies records (paragraphs or programs) to SOURCE.HOLD (indexing added to file name). Enter in file name and select to process either savedlist, @ID string selection, or enter in record name(s). Records are not deleted from the dictionary. D. Stuckey Prog Y
CREATE.RANDOM.LIST Enter savedlist to select random records from to create another savedlist. Does not check NO.SELECT with the input savedlists size. K. Sanley Prog N
CREATE.TAB.DEL.FILE Uses an active savedlist and writes a tab delimited file to TRANSMIT. Prompts for the filename, field name(s), and verifies them before creating the file. S. Sesher Prog Y
CREATE.WEB.DOC Create a web doc from a file in &HOLD& and adds the PSU web footer. K. Sanley Subr Y
CREATE.WEB.DOC.REC Create a web doc from a file in &HOLD&. K. Sanley Subr Y
DELETER Deletes the passed CONTROL.POINT record. Prog N
DISPLAY.ALUMNI.CHANGES Display alumni demographic information changes. K. Sanley Subr Y
DISPLAY.DEMO.CHANGES Display demographic changes made by personnel office K. Sanley Subr Y
FIND.GROUP Determine if an individual is in a UNIX group for access privileges K. Sanley Prog N
FIND.MENU.SCREENS Build savedlists that contain the menu name and process, the voc record, and the menu record. K. Sanley Prog N
FIND.PHRASE Build a savedlist of records from an entered file name that contain the entered phrase to look for. K. Sanley Prog Y
FIND.VOC.SCREENS Build savedlists that contain the screen name and process, and the voc record. K. Sanley Prog N
FIND.VOCLIB.SCREENS Build savedlists that contain the screen name and process, the voc record, and the voclib record. K. Sanley Prog N
FIX.DICT.NAMES Replace dictionary title if blank with dictionary @ID then edit title. K. Sanley Prog N
FORMAT.PHONE Format passed phone number argument as ###-#### or ###-###-### or if the length is not 7 or 10 then return the argument unchanged. L. Weaver Subr Y
GET.ALL.DEPTS Returns all departments associated with an employee separated by @VMs. C. Kuehn Subr Y
GET.ALL.POSITIONS Gets all active positions of an employee and removes those whose therms have expired. Positions separated by @VMs. C. Kuehn Subr Y
GET.FILE.EXT Returns a file's extension. Also takes into account when a period is also part of the basename. C. Kuehn Subr Y
GET.ID Select id and verify access to privacy hold records. J. Keith Subr Y
GET.LOGINS Build a savedlist of all PSU Logins. Use savedlist with CHECK.LOGIN. K. Sanley Prog N
GET.PREF.EMAIL.ADDRESS Pass PEOPLE.ID and ADDRESS and retrieve the preferred email address from PEOPLE.CONTACT.INFO
(use back to return).
L. Weaver Subr Y Additional Information
(use back to return)
HTML.COMMANDS Establish preset commands for web.
(i.e. GL.SOURCE JRNL.ENTS.INFO.PRINT)
K. Sanley Subr Y
MAKE.TRANSMIT.PARAMS Enter a dictionary phrase name from an entered file name and create a TRANSMIT.PARAMS record using the fields in the phrase record. K. Sanley Prog N
MOVE.FILE Input file to read from &HOLD& and move to TRANSMIT file. Prog N
NAME.MAINT.INIT Combine name fields to enhance name search capabilities. K. Sanley Subr Y
PARAGRAPH.CASE Changes entered text to paragraph case. L. Weaver Subr Y
PCL.COMMANDS Set print controls for CONTROL.POINT FEE.CARD.TEXT. Prog N
PRIM.DUP Return result of 'P' for primary id or 'D' for duplicate.id. J. Keith Subr Y
PROGRAMMING.STANDARDS Parse programming.standards.html to look for special embedded tags that contain valid parsex expressions to evaluate, substitute the value of the expressions, and return this back into the html document. K.Sanley Subr Y
PUNC.REMOVAL Used in program to remove punctuation from passed field and upcase result.
i.e. SOURCE DEGREE.16
R. Krause Subr Y
READ.RECORD Pass file and record name to read and return complete record or error message. M. Wheeler Subr Y
REV.DATA Reverse the presentation of multivalued data. K. Sanley Subr Y
SEND.ARGS.EMAIL Send to a passed email addresss a message and name of a file that is ready for use. R. Krause Prog Y Additional Information
(use back to return)
SET.APPLICATION.EMAIL Generic program which can be ran from a paragraph and uses 3 data statements to create and execute a SETPTR command from the APPLICATION.EMAILS file.
(i.e. VOCLIB FA.SCH.DELETE.REPORT)
K. Sanley Prog Y Additional Information
(use back to return)
STANDARD.FOOT PSU Web Footer (returns a result). K. Sanley Subr Y
STANDARD.FOOT.PRINT PSU Web Footer (print statements). K. Sanley Subr Y
STANDARD.HEAD PSU Web Header (returns a result). K. Sanley Subr Y
STANDARD.HEAD.PRINT PSU Web Header (print statements). K. Sanley Subr Y
TEST.OUT Verify entries of '1', '2', and '3'. Testing Program. K.Sanley Prog N
UPDATE.ACCOUNTS Create and-or update a file pointer for voc entries in all voc accounts listed. Prog Y
UPDATE.COUNTY.FIELDS Update PEOPLE COUNTY<11> using a savedlist and entered code. D. Stuckey Prog Y
UPDATE.ZIPS.COUNTIES Update ZIPS COUNTY<3> using a savedlist and entered code. D. Stuckey Prog Y
VOC.CLEAN Input a single record name or a savedlist of records to search for in the voc files (hardcoded in). If found, copy record to SOURCE.HOLD and delete record in the appropriate voc file. Prog Y
WHICH.YEAR Takes a 2-digit year or term and returns a 4-digit year. M. Brennan Subr Y
WHICH.YEAR.MULTI Takes multivalued 2-digit year or term and returns a 4-digit year. T. Vaughan Subr Y
Back to Top


Tools Library Menu

Application Tools- Cleanup Tools- OS.LIB- PSU.LIB- Paragraphs- Program Lists- References Menu- Search Tools- Skin Menu Maker- Subroutines