Creating New Users

Users fall into 3 basic categories:

• Regular Staff and Student Employees
• Consultants and VA Interns
• OIT - SX accounts

Regular Staff and Student Employees

Both the old manual process for creating new employees and a description of the new process can be found in ​UA - Role Provisioning Operations Manual. The old process description is useful in that it provides a listing of campus prefixes which comes in handy for Consultant and VA Work Study Banner User ID creation.

The current process follows the following steps:

1. Security Coordinators open a Cherwell Ticket under the category Account Management. The ticket includes:
   1. Campus
   2. UA ID (3xxxxxxx)
   3. The user's full name
2. A Zuausr Administrator claims the ticket and runs the user creation script:
   1. Login in as self to RPTP : ssh sx...@…
   2. Shell from home directory to PROD as ZUASUR : ssh zuausr@prod
   3. From the command line run the creation script with the new user's UA ID as input
      • $ zuaseed.ksh 3xxxxxxx
      • Enter Y at first prompt to create the account
      • Enter Y at the second prompt if there are no other new user creations pending; step 2 can be applied to several users
   4. Handle any errors that arise, commonly by informing the requesting Security Coordinator of the results
      • An ID already exists for the user
      • The user has transferred from one campus to another and the old ID is still for that campus
      • The user has not been entered into appropriate tables by HR

Consultants and VA Interns

Consultants and VA Interns must be entered via SQL. The data must be entered into both ztbusrh and ztbusrh_load. For this reason, ZUAUSR administrators must be logged into SQLPLUS as zuausr@prod. The basic template is the same, but some features of the data entered differ.

• IDS Creation
  • Unique Ids are determined by ZUAUSR administrators for consultants based on the initials of the first and last name of the user and one to two letters representing the company for which they work.
  • VA students are determined by ZUAUSR administrators based on first, last, and middle initial as other users, adding numbers if necessary
• Default Password
  • Consultants do not have SSN numbers: the letters 'cs'+ the first 8 numbers of their office phone provides the default password normally found under UID.
  • VA Interns do have SSN numbers: These are queried in Banner
• ZTBUSRH_MISC2
  • Consultants will be identified by Department for which they work: <Last>/First Company_{UA Department}
  • VA Interns are categorized solely by campus: UA<c> - VA Work Study, e.g., UAA - VA Work Study
• Ending Date
  • Consultant end dates are based on contract length
  • VA Intern end dates are based on semesters and renewed when the student remains on staff
• ZTBUSRH_USER_UID
  • Consultants will not have a Banner PIDM, the key used to connect various Banner tables
  • VA Students may have a PIDM and if known, may be supplied in the record creation

Template for Consultants

Only the query for inserting into ztbusrh load is listed below. The identical query is run for ztbusrh_load by replacing ztbusrh_load after INTO. The following steps outline how to insert a consultant into ZUAUSR.

1. Determine which campus prefix is needed based on the list in ​UA - Role Provisioning Operations Manual.
2. Login in to RPTP : $ ssh sx...@…
3. Open SQLPLUS as ZUAUSR : $ sqlplus zuausr@prod
4. Supply ZUAUSR password at prompt
5. Run the following query for both ZTBUSRH and ZTBUSRH_LOAD

   INSERT INTO ztbusrh<_load>
   (
    ztbusrh_user_acct_id, ztbusrh_user_uid, ztbusrh_first_name, ztbusrh_last_name,
    ztbusrh_middle_initial, ztbusrh_ssn, ztbusrh_misc1, ztbusrh_misc2
   )
   values
   (
    user ID, -1, <first>, <last>,
    <Company initials>, cs<nnnnnnn>, '-1', 'Last/First Co.,,UA Campus/Department'
   )
   

Query Template for VA Interns

Only the query for inserting into ztbusrh load is listed below. The identical query is run for ztbusrh_load by replacing ztbusrh_load after INTO. The following steps outline how to insert a consultant into ZUAUSR.

1. Login in to RPTP : $ ssh sx...@…
2. Open SQLPLUS as ZUAUSR : $ sqlplus zuausr@prod
3. Supply ZUAUSR password at prompt
4. Run the following query for both ZTBUSRH and ZTBUSRH_LOAD

   INSERT INTO ztbusrh<_load>
   (
    ztbusrh_user_acct_id, ztbusrh_user_uid, ztbusrh_first_name, ztbusrh_last_name,
    ztbusrh_middle_initial, ztbusrh_ssn, ztbusrh_misc1, ztbusrh_misc2
   )
   values
   (
    user ID, -1, <first>, <last>,
    <Middle>, SSN, '-1', 'Last/First Co.,,UA<c> - VA Work Study'
   )