PIN

Job PINCAR2: Supplemental Billing Files

Description:

The purpose of job PINCAR2 is to consolidate data files transmitted via FTP from campus and lab locations. It sends files to the Benefits server FUEGO.

Frequency:

· This job is run monthly on the 6th working day of the month.

Programs Executed:

STEP1 PINCAR2 PROC

PSTEP01 IEFBR14

PSTEP02 SORT

PSTEP03 PINCAR2

STEP2 FTP

STEP3 PINMAIL PROC

PSTEP01 IEBGENER

STEP4 PINMAIL PROC

PSTEP01 IEBGENER

Input:

FTPUSR1.PUT.SBS562T.$MMM$YY

FTPUSR2.PUT.SBS562T.$MMM$YY

FTPUSR3.PUT.SBS562T.$MMM$YY

FTPUSR4.PUT.SBS562T.$MMM$YY

FTPUSR5.PUT.SBS562T.$MMM$YY

FTPUSR6.PUT.SBS562T.$MMM$YY

FTPUSR7.PUT.SBS562T.$MMM$YY

FTPUSR8.PUT.SBS562T.$MMM$YY

FTPUSR9.PUT.SBS562T.$MMM$YY

FTPUSR10.PUT.SBS562T.$MMM$YY

FTPUSRLB.PUT.SBS562T.$MMM$YY

FTPUSRA.PUT.SBS562T.$MMM$YY

FTPUSRH.PUT.SBS562T.$MMM$YY

where $MMM$YY is the run type, month and year designation for the prior month

Output:

· PIN.SBS01.$MMM$YY

· PIN.SBS02.$MMM$YY

· PIN.SBS03.$MMM$YY

· PIN.SBS04.$MMM$YY

· PIN.SBS05.$MMM$YY

· PIN.SBS06.$MMM$YY

· Unix files on FUEGO:

o mdolconb.$MMM$YY

o lifeconb.$MMM$YY

o disbconb.$MMM$YY

o addiconb.$MMM$YY

o pspdconb.$MMM$YY

o psplconb.$MMM$YY

where $MMM$YY is the run type, month and year designation for the prior month.

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- All 13 input FTPUSR files from campus and lab locations must be present before this job can run.

· Prompted Variables

- $MMM - 3-character name of the prior month, eg. JAN, FEB, MAR...

- $YY - 2-digit current year.

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

- STEP3 will only execute if all prior steps have COND CODE=0000

- STEP4 will only execute if at least one prior step has a non-zero condition code.

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Rowena Wong

HRB-Information Systems and Support

300 Lakeside, #4038

University of California

Office of the President

(510) 987-9965

Job PINCAR3: Delete UBH Carrier and Retiree Files from VSFTP

Description:

The purpose of job PINCAR3 is to delete the UBH carrier and retiree files sent to the VSFTP server by job PINCAR1.(carrier) and INS7013F (retiree)

Frequency:

· This job is run monthly on the 15th calendar day of the month.

Programs Executed:

STEP1 FTP(to delete carrier files)

Input:

None

Output:

None

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- None.

· Prompted Variables

- None

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- Step 1 must have COND CODE=0000

· Reports for Users

- None

· Additional Procedures

- None

STEP2 FTP(to delete retiree files)

Input:

None

Output:

None

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- None.

· Prompted Variables

- None

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- Step 1 must have COND CODE=0000

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be restarted from the failed step..

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Rowena Wong

HRB-Information Systems and Support

300 Lakeside, #4038

University of California

Office of the President

(510) 987-9965

In Rowena’s absence, contact :

Joi Adams

HRB-Information Systems and Support

300 Lakeside, #6055

University of California

Office of the President

(510) 987-0927

mailto: joi.adams@ucop.edu

Job PINCAR4: Restore deleted UBH Carrier and Retiree Files to VSFTP

Description:

The purpose of on-request job PINCAR4 is to restore the deleted UBH carrier and retiree files on the VSFTP server on request. These files are deleted by job PINCAR3.

Frequency:

· On Request

Programs Executed:

STEP1 FTP (carrier files)

Input:

None

Output:

None

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- None.

· Prompted Variables

- $MMM - 3-character name of the month that you want to restore, eg. JAN, FEB, MAR...

$YY - 2-digit year for the year that you want to restore.

· Manual Job modifications

- None

STEP2 FTP (retiree files)

Input:

None

Output:

None

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- None.

· Prompted Variables

- $MMM - 3-character name of the month that you want to restore, eg. JAN, FEB, MAR...

$YY - 2-digit year for the year that you want to restore.

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- Step 1 and Step 2 must have COND CODE=0000

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be restarted from the failed step.

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Rowena Wong

HRB-Information Systems and Support

300 Lakeside, #4038

University of California

Office of the President

(510) 987-9965

mailto:Shaun.Ruiz@ucop.edu

In Rowena’s absence, contact :

Joi Adams

HRB-Information Systems and Support

300 Lakeside, #6055

University of California

Office of the President

(510) 987-0927

mailto: joi.adams@ucop.edu

Job PINCCM1: Cal Casualty File

Description:

The purpose of job PINCCM1 is to consolidate Cal Casualty data files transmitted via FTP from campus locations. It sends a file to the vsftp server for pickup by the vendor.

Frequency:

· This job is run monthly on the 6th working day of the month.

Programs Executed:

STEP1 PINCCM1 PROC

PSTEP01 IEFBR14

PSTEP02 FILEAID

STEP2 FTP

STEP3 PINMAIL PROC

PSTEP01 IEBGENER

STEP4 PINMAIL PROC

PSTEP01 IEBGENER

Input:

FTPUSR1.PUT.CALCAS.$MMM$YY

FTPUSR2.PUT.CALCAS.$MMM$YY

FTPUSR3.PUT.CALCAS.$MMM$YY

FTPUSR4.PUT.CALCAS.$MMM$YY

FTPUSR5.PUT.CALCAS.$MMM$YY

FTPUSR6.PUT.CALCAS.$MMM$YY

FTPUSR7.PUT.CALCAS.$MMM$YY

FTPUSR8.PUT.CALCAS.$MMM$YY

FTPUSR9.PUT.CALCAS.$MMM$YY

FTPUSRH.PUT.CALCAS.$MMM$YY

where $MMM$YY is the run type, month and year designation for the prior month

Output:

· PIN.CALCAS.$MMM$YY

· /ftphome/ftpusrcc/get/car/CALCAS.$MMM$YY on vsftp

where $MMM$YY is the run type, month and year designation for the prior month.

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- All 10 input FTPUSR files from campus and lab locations must be present before this job can run.

· Prompted Variables

- $MMM - 3-character name of the prior month, eg. JAN, FEB, MAR...

- $YY - 2-digit current year.

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

- STEP3 will only execute if all prior steps have COND CODE=0000

- STEP4 will only execute if at least one prior step has a non-zero condition code.

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Shaun Ruiz

Financial Management - Payroll Coordination

1111 Franklin St., #10317

University of California

Office of the President

(510) 987-0909

Job PINNER1: New Employee Reporting to the State

Description:

The purpose of job PINNER1 is to consolidate data files transmitted via FTP from campus locations and to generate a file which is encrypted and copied to CD-ROM shipped to the state along with a transmittal.

Frequency:

· This job is run twice each month on the 2nd and 17th of the month, or the next working day after those dates if they fall on a weekend or holiday.

Programs Executed:

STEP1 PINNER1 PROC

PSTEP01 IEFBR14

PSTEP02 PINNER1

Input:

FTPUSR1.PUT.PPPNER.S$SX$MMX$YX

FTPUSR2.PUT.PPPNER.S$SX$MMX$YX

FTPUSR3.PUT.PPPNER.S$SX$MMX$YX

FTPUSR4.PUT.PPPNER.S$SX$MMX$YX

FTPUSR5.PUT.PPPNER.S$SX$MMX$YX

FTPUSR6.PUT.PPPNER.S$SX$MMX$YX

FTPUSR7.PUT.PPPNER.S$SX$MMX$YX

FTPUSR8.PUT.PPPNER.S$SX$MMX$YX

FTPUSR9.PUT.PPPNER.S$SX$MMX$YX

FTPUSRLB.PUT.PPPNER.S$SX$MMX$YX

FTPUSRA.PUT.PPPNER.S$SX$MMX$YX

FTPUSRH.PUT.PPPNER.S$SX$MMX$YX

where:

$SX is the run type (1 or 2), $MMX is the month designation and $YX is the year designation.

Output:

· PIN.NERFILE.S$SX$MMX$YX

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- All 12 input FTPUSR files from campus and lab locations must be present before this job can run.

· Prompted Variables

- $SX = 1 for the run on the 17th of the month (processes data for the first half of the current month)

= 2 for the run on the 2nd of the month (processes data for the second half of the prior month)

- $MMX 3-character month name eg. JAN, FEB, MAR... when $SX=1, use the current month, otherwise use the prior month

- $YX 2-digit year - use the current year except for the first run of January ($SX=2), in which case use the prior year.

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

· Reports for Users

- Send 1 copy of report NER0011 from STEP1.PSTEP02.CONTROL to: Helen McCullough, Payroll Coordination & Tax Services 1111 Franklin, 1032D

· Additional Procedures

- Upon completion of the Zeke PINNER1 job verify the printed report to ensure all of the campuses contain New Hire records. Once verified send an email to the Helpdesk to arrange for them to have the file transmitted to the EDD.

- The email should indicate the name of the file created in the PINNER1 job that needs to be transmitted. Operations will send a confirmation email to the UCOP contact that the file has been sent.

- A copy of the printed report is to be faxed to the UCOP contact Helen McCullough. The FAX number is 510-987-0912.

- If needed, the EDD contact information is listed below:

- EDD/NER

- MIC – 15

- 722 Capitol Mall

- Sacramento, Ca. 95814

- Phone No. 916-654-6845

- EDD email (ecom@edd.ca.gov)

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Helen McCullough - Tax Services Assistant

Payroll Coordination & Tax Services

10321D

1111 Franklin St., 10th Flr

Oakland, CA 94607

(510)987-0943

mailto: Helen.McCullough@ucop.edu

Job PINUM1: Monthly Union Rosters, Part 1

Description:

This is the first step in the monthly union roster process. The purpose of job PINUM1 is to consolidate union data files transmitted via FTP from campus locations. The resulting file is picked up by Unix (bert) via FTP. (After Unix processing is complete, job PINUM2 completes the monthly processing).

Frequency:

· This job is run monthly on the Tuesday after the first Monday of the month. It can run any time after all locations have transmitted their files, but should be completed by 4:00 p.m.

· If Tuesday is a holiday, the job should run on the next working day.

· Early in December, check with Cheryl Cline as to the job schedule over the holidays. The practice has been to not run this job when the campuses are closed.

Programs Executed:

STEP1 PINUW1 PROC

PSTEP01 IEFBR14

PSTEP02 SORT

STEP2 PINMAIL PROC

PSTEP01 IEBGENER

STEP3 PINMAIL PROC

PSTEP01 IEBGENER

Input:

· FTPUSR1.PUT.UNITS770.W1$MMM$YY

· FTPUSR2.PUT.UNITS770.W1$MMM$YY

· FTPUSR3.PUT.UNITS770.W1$MMM$YY

· FTPUSR4.PUT.UNITS770.W1$MMM$YY

· FTPUSR5.PUT.UNITS770.W1$MMM$YY

· FTPUSR6.PUT.UNITS770.W1$MMM$YY

· FTPUSR7.PUT.UNITS770.W1$MMM$YY

· FTPUSR8.PUT.UNITS770.W1$MMM$YY

· FTPUSR9.PUT.UNITS770. .W1$MMM$YY

· FTPUSR10.PUT.UNITS770. .W1$MMM$YY

· FTPUSRA.PUT.UNITS770.W1$MMM$YY

where $MMM$YY is the month and year designation

· PRO.CTL.CNTLIB(PINUM1E)

· PRO.CTL.CNTLIB(PINUM1E2)

· PRO.CTL.CNTLIB(PINUW1S1)

Output:

· PIN.UNITS770.MERGED.W1$MMM$YY

· PIN.UFILE.W1$MMM$YY

where $MMM$YY is the month and year designation

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- All 11 input FTPUSR files from campus locations must be present before this job can run.

· Prompted Variables

- $MMM - 3-character name of the current month, e.g. JAN, FEB, MAR...

- $YY - 2-digit current year.

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

- STEP3 will only execute if all prior steps have COND CODE=0000

- STEP4 will only execute if at least one prior step has a non-zero condition code.

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Cheryl Cline

Human Resources & Benefits

Labor Relations – 12^th Floor Kaiser Bldg

University of California

Office of the President

(510)268-0602 fax

In Cheryl’s absence, contact:

Anna Ornellas

Human Resources & Benefits

Labor Relations – 12^th Floor Kaiser Bldg

University of California

Office of the President

(510)987-9906

· PRO.CTL.CNTLIB(FAIDCOPY)

Job PINUM2: Monthly Union Rosters Part 2

Description:

This is the second MVS step in the monthly union roster process. After the first MVS job, PINUM1, completes, a file is transmitted to Unix for processing there. When that job has completed, MVS job PINUM2 runs to create files for each union which they retrieve via FTP and also creates files for a third-party mailing house which are also retrieved via FTP.

Frequency:

· This job is run monthly on the Tuesday after the first Monday of the month. It can be run when Unix processing is complete, and file FTPUSR0.PUT.UFILE is present.

· If Tuesday is a holiday, the job should run on the next working day.

· Early in December, check with Cheryl Cline as to the job schedule over the holidays. The practice has been to not run this job when the campuses are closed.

Programs Executed:

STEP1 FILEAID

STEP2 PINUW2 PROC

PSTEP01 IEFBR14

PSTEP02 FILEAID

PSTEP03 FILEAID

PSTEP04 FILEAID

PSTEP05 FILEAID

PSTEP06 FILEAID

PSTEP07 FILEAID

PSTEP08 FILEAID

PSTEP09 FILEAID

PSTEP10 FILEAID

PSTEP11 FILEAID

PSTEP12 FILEAID

PSTEP13 FILEAID

PSTEP14 FILEAID

PSTEP15 FILEAID

PSTEP16 SORT

PSTEP17 PINU02

PSTEP18 SORT

PSTEP19 SORT

PSTEP20 SORT

PSTEP21 SORT

PSTEP22 SORT

PSTEP23 SORT

PSTEP24 SORT

PSTEP25 SORT

PSTEP26 SORT

STEP3 FTP

STEP4 FTP

STEP5 FTP

STEP6 PINMAIL PROC

PSTEP01 IEBGENER

STEP7 PINMAIL PROC

PSTEP01 IEBGENER

Input:

· FTPUSR0.PUT.UFILE

· PRO.CTL.CNTLIB(PINUM2E)

· PRO.CTL.CNTLIB(PINUM2E2)

· PRO.CTL.CNTLIB(PINUW1FC)

· PRO.CTL.CNTLIB(PINUW1FD)

· PRO.CTL.CNTLIB(PINUW1FE)

· PRO.CTL.CNTLIB(PINUW1FF)

· PRO.CTL.CNTLIB(PINUW1F1)

· PRO.CTL.CNTLIB(PINUW1F2)

· PRO.CTL.CNTLIB(PINUW1F3)

· PRO.CTL.CNTLIB(PINUW1F4)

· PRO.CTL.CNTLIB(PINUW1F5)

· PRO.CTL.CNTLIB(PINUW1F6)

· PRO.CTL.CNTLIB(PINUW1F7)

· PRO.CTL.CNTLIB(PINUW1F8)

· PRO.CTL.CNTLIB(PINUW1F9)

· PRO.CTL.CNTLIB(PINUW1SP)

· PRO.CTL.CNTLIB(PINUW1S2)

· PRO.CTL.CNTLIB(PINUW1S3)

· PRO.CTL.CNTLIB(PINUW1S4)

· PRO.CTL.CNTLIB(PINUW1S5)

· PRO.CTL.CNTLIB(PINUW1S6)

· PRO.CTL.CNTLIB(PINUW1S7)

· PRO.CTL.CNTLIB(PINUW1S8)

· PRO.CTL.CNTLIB(PINUW1S9)

· PRO.CTL.CNTLIB(PINUW1SA)

· PRO.CTL.CNTLIB(PINUW1SB)

Output:

· PIN.UFILE.WITHMAIL.W1$MMM$YY

· FTPUSRUP.GET.UNITS770.W1$MMM$YY

· FTPUSRCN.GET.UNITS770.W1$MMM$YY

· FTPUSRAF.GET.UNITS770.W1$MMM$YY

· FTPUSRCU.GET.UNITS770.W1$MMM$YY

· FTPUSRAT.GET.UNITS770.W1$MMM$YY

· FTPUSRAS.GET.UNITS770.W1$MMM$YY

· FTPUSRSE.GET.UNITS770.W1$MMM$YY

· FTPUSRAW.GET.UNITS770.W1$MMM$YY

· FTPUSRM6.GET.UNITS770.W1$MMM$YY

· PIN.UNITS770.FTPF3.W1$MMM.$YY

· PIN.UNITS770.FTPF7.W1$MMM.$YY

· FTPUSRFP.GET.UNITS770.W1$MMM$YY

· FTPUSRPX.GET.UNITS770.W1$MMM$YY

· FTPUSRBX.GET.BXMAIL.W1$MMM$YY

· FTPUSRAM.GET.AFMAIL.W1$MMM$YY

· FTPUSRUM.GET.UPMAIL.W1$MMM$YY

· FTPUSRCM.GET.CUMAIL.W1$MMM$YY

· FTPUSRNM.GET.NXMAIL.W1$MMM$YY

· FTPUSRSM.GET.SEMAIL.W1$MMM$YY

· FTPUSRFM.GET.PAMAIL.W1$MMM$YY

· FTPUSRPM.GET.PXMAIL.W1$MMM$YY

· PIN.UNITS770.FTPFM.FFMAIL.W1$MMM.$YY

where W1$MMM$YY is the week, month and year designation

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- File FTPUSR0.PUT.UFILE must be present before this job can be run.

· Prompted Variables

- $MMM - 3-character name of the current month, e.g. JAN, FEB, MAR...

- $YY - 2-digit current year.

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- STEP1 must have COND CODE=0000.

- STEP2 may have COND CODE=0008. This is acceptable.

- All other steps must have COND CODE=0000

- STEP6 will only execute if prior step has a valid condition codes

- STEP7 will only execute if at least one prior step has an invalid condition code.

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be restarted in STEP2.

Contact Information:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Cheryl Cline

Human Resources & Benefits

Labor Relations – 12^th Floor Kaiser Bldg

University of California

Office of the President

(510)268-0602 fax

In Cheryl’s absence, contact:

Anna Ornellas

Human Resources & Benefits

Labor Relations – 12^th Floor Kaiser Bldg

University of California

Office of the President

(510)987-9906

Job PINUM3: Monthly Union Dues Files

Description:

The purpose of job PINUM3 is to consolidate union data files transmitted via FTP from campus locations. It creates files for each union which they retrieve via FTP.

Frequency:

· This job is run monthly on the 9th working day of each month, processing files for the prior month.

Programs Executed:

STEP1 PINUM3 PROC

PSTEP01 IEFBR14

PSTEP02 FILEAID

PSTEP03 SORT

PSTEP04 FILEAID

PSTEP05 FILEAID

PSTEP06 FILEAID

PSTEP07 FILEAID

PSTEP08 FILEAID

PSTEP09 FILEAID

PSTEP10 FILEAID

PSTEP11 FILEAID

PSTEP12 FILEAID

PSTEP13 FILEAID

PSTEP14 FILEAID

PSTEP15 FILEAID

PSTEP16 FILEAID

PSTEP17 FILEAID

STEP2 FTP

STEP3 FTP

STEP4 PINMAIL PROC

PSTEP01 IEBGENER

STEP5 PINMAIL PROC

PSTEP01 IEBGENER

Input:

· FTPUSR1.PUT.UNION495.$MMM$CY

· FTPUSR2.PUT.UNION495.$MMM$CY

· FTPUSR3.PUT.UNION495.$MMM$CY

· FTPUSR4.PUT.UNION495.$MMM$CY

· FTPUSR5.PUT.UNION495.$MMM$CY

· FTPUSR6.PUT.UNION495.$MMM$CY

· FTPUSR7.PUT.UNION495.$MMM$CY

· FTPUSR8.PUT.UNION495.$MMM$CY

· FTPUSR9.PUT.UNION495.$MMM$CY

· FTPUSR10.PUT.UNION495.$MMM$CY

· FTPUSRA.PUT.UNION495.$MMM$CY

where $MMM$CY is the month and year designation for the prior month

· PRO.MNT.CNTLIB(PINUM3E1)

· PRO.MNT.CNTLIB(PINUM3E2)

· PRO.MNT.CNTLIB(PINUM3FA)

· PRO.MNT.CNTLIB(PINUM3FB)

· PRO.MNT.CNTLIB(PINUM3FD)

· PRO.MNT.CNTLIB(PINUM3FE)

· PRO.MNT.CNTLIB(PINUM3FF)

· PRO.MNT.CNTLIB(PINUM3FG)

· PRO.MNT.CNTLIB(PINUM3F1)

· PRO.MNT.CNTLIB(PINUM3F2)

· PRO.MNT.CNTLIB(PINUM3F3)

· PRO.MNT.CNTLIB(PINUM3F4)

· PRO.MNT.CNTLIB(PINUM3F5)

· PRO.MNT.CNTLIB(PINUM3F6)

· PRO.MNT.CNTLIB(PINUM3F7)

· PRO.MNT.CNTLIB(PINUM3F8)

· PRO.MNT.CNTLIB(PINUM3F9)

· PRO.MNT.CNTLIB(PINUM3S1)

Output:

· FTPUSRUP.GET.UNION495.$MMM$CY

· FTPUSRAF.GET.UNION495.$MMM$CY

· FTPUSRCN.GET.UNION495.$MMM$CY

· FTPUSRCU.GET.UNION495.$MMM$CY

· FTPUSRAT.GET.UNION495.$MMM$CY

· FTPUSRAS.GET.UNION495.$MMM$CY

· FTPUSRSE.GET.UNION495.$MMM$CY

· FTPUSRAW.GET.UNION495.$MMM$CY

· FTPUSRM6.GET.UNION495.$MMM$CY

· FTPUSRPX.GET.UNION495.$MMM$CY

· FTPUSRFP.GET.UNION495.$MMM$CY

· PIN.UNION495.FTPF3.$1MM.$CY

· PIN.UNION495.FTPF7.$1MM.$CY

where $MMM$CY is the month and year designation for the prior month.

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- All 11 input FTPUSR files from campus locations must be present before this job can run.

· Prompted Variables

- $MMM - 3-character name of the prior month, eg. JAN, FEB, MAR...

- $CY - 2-digit current year.

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- STEP1 may have COND CODE=-0008. This is acceptable

- STEP2 will only execute if prior step has a valid condition code

- STEP3 will only execute if at least one prior step has a non-zero condition code.

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Cheryl Cline

Human Resources & Benefits

Labor Relations – 12^th Floor Kaiser Bldg

University of California

Office of the President

(510)268-0602 fax

In Cheryl’s absence, contact:

Anna Ornellas

Human Resources & Benefits

Labor Relations – 12^th Floor Kaiser Bldg

University of California

Office of the President

(510)987-9906

Job PINUR1: On Request Union Mail Files

Description:

The purpose of job PINUR1 is to create a mail file for a specified union on request from the user. Users will supply the substitution parameters (See "Prompted Variables" below). The resulting file is retrieved by the user via FTP.

Frequency:

· This job is run on request only.

Programs Executed:

STEP1 PINUR1 PROC

PSTEP01 IEFBR14

PSTEP02 PINU02

PSTEP03 SORT

STEP3 PINMAIL PROC

PSTEP01 IEBGENER

STEP4 PINMAIL PROC

PSTEP01 IEBGENER

Input:

· PIN.UNITS770.MERGED.W1$MMM$YY

where $MMM$YY is the month and year designation

· PRO.MNT.CNTLIB(PINUR1S1)

· PRO.MNT.CNTLIB(PINUR1E1)

· PRO.MNT.CNTLIB(PINUR1E2)

Output:

· FTPUSR$UNION.GET.MAIL.FULL.$MMM$YY

where $MMM$YY is the month and year designation and $UNION is the 2-character Union code requested.

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- None.

· Prompted Variables

- $UNION 2-character union code supplied by user. Valid values are

§ AM for AFSCME

§ CM for CUE

§ NM for CNA

§ UM for UPTE

§ SM FOR SETC

§ FM FOR FUPOA POLICE OFFICERS

§ PM for Post Docs

§ FF for F3 and F7

§ BX for Academic Student Employees

§ AT for AFT

- $MMM 3-character name of the month supplied by user, eg. JAN, FEB, MAR... This is not necessarily the current or prior month.

- $YY 2-digit year supplied by user. This is not necessarily the current or prior year.

- $RUNTYPE 1-character run type supplied by user. Valid values are

§ D for Dues Only

§ F for Agency Fee Only

§ A for All records

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

- STEP2 will only execute if all prior steps have valid condition codes

- STEP3 will only execute if at least one prior step has an invalid condition code.

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Cheryl Cline

Human Resources & Benefits

Labor Relations – 12^th Floor Kaiser Bldg

University of California

Office of the President

(510)268-0602 fax

In Cheryl’s absence, contact:

Anna Ornellas

Human Resources & Benefits

Labor Relations – 12^th Floor Kaiser Bldg

University of California

Office of the President

(510)987-9906

Job PINUW1: Weekly Union Rosters

Description:

The purpose of job PINUW1 is to consolidate union data files transmitted via FTP from campus locations. It creates files for each union which they retrieve via FTP and also creates files for a third-party mailing house which are also retrieved via FTP.

Frequency:

· This job is each Tuesday, except for the Tuesday after the first Monday of the month. It can run any time after all locations have transmitted their files, but should be completed by 4:00 p.m.

· If Tuesday is a holiday, the job should run on the next working day.

· Early in December, check with Cheryl Cline as to the job schedule over the holidays. The practice has been to not run this job when the campuses are closed.

Programs Executed:

STEP1 PINUW1 PROC

PSTEP01 IEFBR14

PSTEP02 SORT

PSTEP03 PINU01

STEP2 PINUW2 PROC

PSTEP01 IEFBR14

PSTEP02 FILEAID

PSTEP03 FILEAID

PSTEP04 FILEAID

PSTEP05 FILEAID

PSTEP06 FILEAID

PSTEP07 FILEAID

PSTEP08 FILEAID

PSTEP09 FILEAID

PSTEP10 FILEAID

PSTEP11 FILEAID

PSTEP12 FILEAID

PSTEP13 FILEAID

PSTEP14 FILEAID

PSTEP15 FILEAID

PSTEP16 SORT

PSTEP17 PINU02

PSTEP18 SORT

PSTEP19 SORT

PSTEP21 SORT

PSTEP22 SORT

PSTEP23 SORT

PSTEP24 SORT

PSTEP25 SORT

PSTEP26 SORT

STEP3 FTP

STEP4 FTP

STEP5 FTP

STEP6 PINMAIL PROC

PSTEP01 IEBGENER

STEP7 PINMAIL PROC

PSTEP01 IEBGENER

Input:

· FTPUSR1.PUT.UNITS770.W$WK$MMM$YY

· FTPUSR2.PUT.UNITS770.W$WK$MMM$YY

· FTPUSR3.PUT.UNITS770.W$WK$MMM$YY

· FTPUSR4.PUT.UNITS770.W$WK$MMM$YY

· FTPUSR5.PUT.UNITS770.W$WK$MMM$YY

· FTPUSR6.PUT.UNITS770.W$WK$MMM$YY

· FTPUSR7.PUT.UNITS770.W$WK$MMM$YY

· FTPUSR8.PUT.UNITS770.W$WK$MMM$YY

· FTPUSR9.PUT.UNITS770. .W$WK$MMM$YY

· FTPUSR10.PUT.UNITS770. .W$WK$MMM$YY

· FTPUSRA.PUT.UNITS770.W$WK$MMM$YY

where W$WK$MMM$YY is the week, month and year designation

· PRO.CTL.CNTLIB(FAIDCOPY)

· PRO.CTL.CNTLIB(PINUM2E)

· PRO.CTL.CNTLIB(PINUM2E2)

· PRO.CTL.CNTLIB(PINUW1FC)

· PRO.CTL.CNTLIB(PINUW1FD)

· PRO.CTL.CNTLIB(PINUW1FE)

· PRO.CTL.CNTLIB(PINUW1FF)

· PRO.CTL.CNTLIB(PINUW1F1)

· PRO.CTL.CNTLIB(PINUW1F2)

· PRO.CTL.CNTLIB(PINUW1F3)

· PRO.CTL.CNTLIB(PINUW1F4)

· PRO.CTL.CNTLIB(PINUW1F5)

· PRO.CTL.CNTLIB(PINUW1F6)

· PRO.CTL.CNTLIB(PINUW1F7)

· PRO.CTL.CNTLIB(PINUW1F8)

· PRO.CTL.CNTLIB(PINUW1F9)

· PRO.CTL.CNTLIB(PINUW1SP)

· PRO.CTL.CNTLIB(PINUW1S2)

· PRO.CTL.CNTLIB(PINUW1S3)

· PRO.CTL.CNTLIB(PINUW1S4)

· PRO.CTL.CNTLIB(PINUW1S5)

· PRO.CTL.CNTLIB(PINUW1S6)

· PRO.CTL.CNTLIB(PINUW1S7)

· PRO.CTL.CNTLIB(PINUW1S8)

· PRO.CTL.CNTLIB(PINUW1S9)

· PRO.CTL.CNTLIB(PINUW1SA)

· PRO.CTL.CNTLIB(PINUW1SB)

Output:

· PIN.UNITS770.MERGED.W&WK&MMM&YY

· FTPUSRUP.GET.UNITS770.W1$MMM$YY

· FTPUSRCN.GET.UNITS770.W1$MMM$YY

· FTPUSRAF.GET.UNITS770.W1$MMM$YY

· FTPUSRCU.GET.UNITS770.W1$MMM$YY

· FTPUSRAT.GET.UNITS770.W1$MMM$YY

· FTPUSRAS.GET.UNITS770.W1$MMM$YY

· FTPUSRSE.GET.UNITS770.W1$MMM$YY

· FTPUSRAW.GET.UNITS770.W1$MMM$YY

· FTPUSRM6.GET.UNITS770.W1$MMM$YY

· FTPUSRFP.GET.UNITS770.W1$MMM$YY

· FTPUSRPX.GET.UNITS770.W1$MMM$YY

· FTPUSRBX.GET.BXMAIL.W1$MMM$YY

· FTPUSRAM.GET.AFMAIL.W1$MMM$YY

· FTPUSRUM.GET.UPMAIL.W1$MMM$YY

· FTPUSRCM.GET.CUMAIL.W1$MMM$YY

· FTPUSRNM.GET.NXMAIL.W1$MMM$YY

· FTPUSRSM.GET.SEMAIL.W1$MMM$YY

· FTPUSRFM.GET.PAMAIL.W1$MMM$YY

· FTPUSRPM.GET.PXMAIL.W1$MMM$YY

· PIN.UNITS770.FTPF3.W$WK.$MMM.$YY

· PIN.UNITS770.FTPF7.W$WK.$MMM.$YY

· PIN.UNITS770.FTPFM.FFMAIL.W$WK.$MMM.$YY

where W$WK$MMM$YY is the week, month and year designation

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- All 11 input FTPUSR files from campus locations must be present before this job can run.

· Prompted Variables

- $WK - 1-digit number indicating the week number in the current month

- $MMM - 3-character name of the current month, eg. JAN, FEB, MAR...

- $YY - 2-digit current year.

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

Verification

- Steps STEP2.PSTEP02 through STEP2.PSTEP14 may have COND CODE=0008. This is acceptable.

- All other steps must have COND CODE=0000

- STEP6 will only execute if all prior steps have valid condition codes

- STEP7 will only execute if at least one prior step has an invalid condition code.

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Cheryl Cline

Human Resources & Benefits

Labor Relations – 12^th Floor Kaiser Bldg

University of California

Office of the President

(510)268-0602 fax

In Cheryl’s absence, contact:

Anna Ornellas

Human Resources & Benefits

Labor Relations – 12^th Floor Kaiser Bldg

University of California

Office of the President

(510)987-9906

Job PINCAROE: Open Enrollment Carrier Files

Description:

The purpose of job PINCAROE is to format data files generated by the open enrollment process on unix and prepare them for transmission to the carriers.

Frequency:

· This job is run annually on request.

Programs Executed:

STEP1 FTP

STEP2 PINCAROE PROC

PSTEP01 IEFBR14

PSTEP02 SORT

PSTEP03 PINCAROE

PSTEP04 SORT

PSTEP05 IEBGENER

PSTEP06 SORT

PSTE07 IKJEFT1A(Rexx)

PSTE08 IKJEFT1A(Rexx)

PSTE09 IKJEFT1A(Rexx)

STEP3 FTP

STEP4 FTP

STEP5 FTP

STEP6 FTP

STEP7 FTP

STEP8 PINMAIL PROC

PSTEP01 IEBGENER

STEP9 PINMAIL PROC

PSTEP01 IEBGENER

STEP10 PINMAIL PROC

PSTEP01 IEBGENER

STEP11 PINMAIL PROC

PSTEP01 IEBGENER

Input:

unix file on bert - "consolidated"

Output:

· PIN.CAROE.OE$YY

· file on vsftp for Staywell - /ftphome/ftpusrsw/get/ivr/eoe/PAYROLL.SW.EOE$YY

· Report DD name PRINTFIL from PSTEP04.

· PIN.FTPAV.OEO$YY - FTP statements for Avidity

· PIN.FTPUBH.OEO$YY - FTP statements for UBH

· PIN.FTPGP.OEO$YY - FTP statements for Garnett Powers

· vsftp files for Avidity in /ftpother/ftpusrav/get/ivr/eoe

o PAYROLL.B1.OEO$YY

o PAYROLL.CG. OEO$YY

o PAYROLL.D1. OEO$YY

o PAYROLL.D3. OEO$YY

o PAYROLL.H1. OEO$YY

o PAYROLL.J2. OEO$YY

o PAYROLL.KN. OEO$YY

o PAYROLL.KS. OEO$YY

o PAYROLL.KU. OEO$YY

o PAYROLL.KW. OEO$YY

o PAYROLL.P1. OEO$YY

o PAYROLL.P2. OEO$YY

o PAYROLL.P3. OEO$YY

o PAYROLL.P4. OEO$YY

o PAYROLL.P5. OEO$YY

o PAYROLL.VI. OEO$YY

o PAYROLL.WH. OEO$YY

· vsftp files for UBH in /ftphome/ftpusrbh/get/ivr/eoe

o PAYROLL.B1. OEO$YY

o PAYROLL.CG. OEO$YY

o PAYROLL.H1. OEO$YY

o PAYROLL.KN. OEO$YY

o PAYROLL.KS. OEO$YY

o PAYROLL.WH. OEO$YY

· vsftp files for Garnett Powers in /ftphome/ftpusrgp/get/ivr/eoe

o P1. OEO$YY

o P2. OEO$YY

o P3. OEO$YY

o P4. OEO$YY

o P5. OEO$YY

· vsftp files for Kaiser Umbrella in /ftpother/ftpusrkp/get/ivr/eoe

o PAYROLL.KU.EOE$YY

o PAYROLL.KPMA.EOE$YY

where $YY is the run year.

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- Unix file must be present.

· Prompted Variables

- $YY - 2-digit open enrollment plan year.

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000, except for PINCAROE PROC (STEP2) which can have COND CODE=0003.

· Reports for Users

- Send 1 copy of report PINCAROE from STEP2.PSTEP05.SYSUT2 to: Rowena Wong 300 Lakeside, #6060

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Rowena Wong

HRB-Information Systems and Support

300 Lakeside, #6060

University of California

Office of the President

(510) 987-9965

Job PINLMS1: Create Learning Management System Job Details File

Description:

The purpose of job PINLMS1 is to create a file for the Learning Management System from specific TCS and PPS DB2 tables.

Frequency:

· This job is run every Monday through Friday at 3pm.

Programs Executed:

STEP1 PINLMS1 PROC

PSTEP01 IEFBR14

PSTEP02 PINLMS1

PSTEP03 IKJEFT1A

Input:

FTPUSR4.PUT.CTLDB2

FTPUSR1.PUT.CTLDB2

A3257.PPS.PRD1.UNLDCTL.PPPHME

PP3.CTL.DSNTIAUL

PP5.CTL.DSNTIAUL

PP6.CTL.DSNTIAUL

PP7.CTL.DSNTIAUL

PP8.CTL.DSNTIAUL

PP9.CTL.DSNTIAUL

PPA.CTL.DSNTIAUL

Output:

· PIN.PINLMS1.D&MMDDYY

· OMVS file /prod/pin/lms/data/LMS_job_detail.txt

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- None.

· Prompted Variables

- $MM - Current Month

- $DD - Current Day

- $YY - Current year

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Rowena Wong

HRB-Information Systems and Support

300 Lakeside, #4038

University of California

Office of the President

(510) 987-9965

Sylvia Jiang

HRB-Client Relations & Diversity

300 Lakeside, #12071

University of California

Office of the President

(510) 987-0320

Job PINLMS2: Create Learning Management System Org Details File

Description:

The purpose of job PINLMS2 is to create a file for the Learning Management System from PPS data.

Frequency:

· This job is run every Monday through Friday at 3pm.

Programs Executed:

STEP1 PINLMS2 PROC

PSTEP01 IEFBR14

PSTEP02 IKJEFT01

PSTEP03 IKJEFT01

PSTEP04 FILEAID

PSTEP05 PINLMS2

PSTEP06 IKJEFT1A

Input:

All input is from DB2 tables and CNTLIB.

Output:

· PIN.PINLMS2.D&MMDDYY

· OMVS file /prod/pin/lms/data/LMS_org_detail.txt

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- None.

· Prompted Variables

- $MM - Current Month

- $DD - Current Day

- $YY - Current year

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Rowena Wong

HRB-Information Systems and Support

300 Lakeside, #4038

University of California

Office of the President

(510) 987-9965

Sylvia Jiang

HRB-Client Relations & Diversity

300 Lakeside, #12071

University of California

Office of the President

(510) 987-0320

Job PINLMS3: Transmit Files to SumTotal

Description:

The purpose of job PINLMS3 is to transmit Learning Management System files to the SumTotal vendor.

Frequency:

· This job is run every Monday through Friday after the completion of jobs PINLMS1 & PINLMS2 and Unix job /apps/iscprod/pip/zekejobs/piplmso.

Programs Executed:

STEP1 PINLMS3 PROC

PSTEP01 IKJEFT1A

PSTEP02 IEBGENER

PSTEP03 IEFB414

PSTEP04 IKJEFT01

PSTEP05 IKJEFT1A

Input:

· OMVS Files in /prod/pin/lms/data

LMS_emp_detail.txt
LMS_job_det_assoc.txt
LMS_org_det_assoc.txt
LMS_job_detail.txt
LMS_org_detail.txt

Output:

· Files on SumTotal server in /Inbound/Live/DataSync

o LMS_emp_detail.txt

o LMS_job_det_assoc.txt

o LMS_org_det_assoc.txt

o LMS_job_detail.txt

o LMS_org_detail.txt

· Archived files

o PIN.HRBH.LMS.EMPDET.Dmmddyy

o PIN.HRBH.LMS.JOBDETAS.Dmmddyy

o PIN.HRBH.LMS.ORGDETAS.Dmmddyy

o PIN.HRBH.LMS.JOBDET.Dmmddyy

o PIN.HRBH.LMS.ORGDET.Dmmddyy

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- Successful completion of job PINLMS1.

- Successful completion of job PINLMS2.

- Successful completion of Unix job /apps/iscprod/pip/zekejobs/piplmso

· Prompted Variables

- None

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Rowena Wong

HRB-Information Systems and Support

300 Lakeside, #4038

University of California

Office of the President

(510) 987-9965

Sylvia Jiang

HRB-Client Relations & Diversity

300 Lakeside, #12071

University of California

Office of the President

(510) 987-0320

Job PINLMS4: Transmit Files to SumTotal's Test Directory

Description:

The purpose of job PINLMS4 is to transmit production Learning Management System files to the test directory at SumTotal .

Frequency:

· This job is run monthly on the first of the month (including weekends and holidays), after the completion of Unix job /apps/iscprod/pip/zekejobs/piplmsto.

Programs Executed:

STEP1 PINLMS4 PROC

PSTEP01 IKJEFT1A

PSTEP02 IEBGENER

PSTEP03 IKJEFT1A

Input:

· OMVS Files in /prod/pin/lms/data

LMS_emp_detail_testenv.txt
LMS_job_det_assoc_testenv.txt
LMS_org_det_assoc_testenv.txt
LMS_job_detail.txt
LMS_org_detail.txt

Output:

· Files on SumTotal server in /Inbound/Stage/DataSync

o LMS_emp_detail.txt

o LMS_job_det_assoc.txt

o LMS_org_det_assoc.txt

o LMS_job_detail.txt

o LMS_org_detail.txt

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- Successful completion of Unix job /apps/iscprod/pip/zekejobs/piplmsto.

· Prompted Variables

- None

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Rowena Wong

HRB-Information Systems and Support

300 Lakeside, #4038

University of California

Office of the President

(510) 987-9965

Sylvia Jiang

HRB-Client Relations & Diversity

300 Lakeside, #12071

University of California

Office of the President

(510) 987-0320

Job PINLMSRQ: Transmit Test Files to SumTotal on Request

Description:

The purpose of job PINLMSRQ is to transmit test Learning Management System files to the SumTotal vendor.

Frequency:

· This job is run on request

Programs Executed:

STEP1 PINLMS3 PROC

PSTEP01 IEFBR14

PSTEP02 IKJEFT01

PSTEP03 IEBGENER

PSTEP04 IKJEFT1A

Input:

· OMVS Files in /test/pin/lms/data

LMS_emp_detail.txt
LMS_job_det_assoc.txt
LMS_org_det_assoc.txt
LMS_job_detail.txt
LMS_org_detail.txt

Output:

· Files on SumTotal server in /Inbound/Stage/DataSync

o LMS_emp_detail.txt

o LMS_job_det_assoc.txt

o LMS_org_det_assoc.txt

o LMS_job_detail.txt

o LMS_org_detail.txt

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- None

· Prompted Variables

- None

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Rowena Wong

HRB-Information Systems and Support

300 Lakeside, #4038

University of California

Office of the President

(510) 987-9965

Sylvia Jiang

HRB-Client Relations & Diversity

300 Lakeside, #12071

University of California

Office of the President

(510) 987-0320

Job PINFS1: FSA Vendor Files

Description:

The purpose of job PINFS1 is to consolidate data files transmitted via FTP from campus locations. It sends the consolidated file to vsftp for vendor pickup.

Frequency:

· This job is run twice monthly on the 3rd and 18th of each month and annually on January 3. If the scheduled run date falls on a weekend or holiday, the job should be run on the next working day.

Programs Executed:

STEP1 PINFS1 PROC

PSTEP01 IEFBR14

PSTEP02 FILEAID

PSTEP03 PINFSA

STEP2 FTP

STEP3 FTP

STEP4 PINMAIL PROC

PSTEP01 IEBGENER

STEP5 PINMAIL PROC

PSTEP01 IEBGENER

Input:

· FTPUSR1.PUT.FSA467.$RUN$MMM$YY

· FTPUSR2.PUT.FSA467.$RUN$MMM$YY

· FTPUSR3.PUT.FSA467.$RUN$MMM$YY

· FTPUSR4.PUT.FSA467.$RUN$MMM$YY

· FTPUSR5.PUT.FSA467.$RUN$MMM$YY

· FTPUSR6.PUT.FSA467.$RUN$MMM$YY

· FTPUSR7.PUT.FSA467.$RUN$MMM$YY

· FTPUSR8.PUT.FSA467.$RUN$MMM$YY

· FTPUSR9.PUT.FSA467.$RUN$MMM$YY

· FTPUSR10.PUT.FSA467.$RUN$MMM$YY

· FTPUSRA.PUT.FSA467.$RUN$MMM$YY

· FTPUSRH.PUT.FSA467.$RUN$MMM$YY

· FTPUSRLB.PUT.FSA467.$RUN$MMM$YY

where $RUN$MMM$YY is the run type, month and year designation for the current month

Output:

· PIN.FSADATA.$RUN$MMM$YY

· PIN.FSASUM.$RUN$MMM$YY

· /ftpother/ftpusrcx/get/ivr/UC-SM-$CCYY.$MM.$DD-FSA.TXT on vsftp

· fsa.$RUN.$MMM.$YY on the HR&B server fuego

where $RUN$MMM$YY is the run type, month and year designation for the current month.

and $CCYY is the 4-digit year

and $MM is the 2-digit month number

and $DD is the 2-digit day number

Job Pre-Processing Instructions:

· CICS or Other Restrictions

- None

· Dependencies

- All 13 input FTPUSR files from campus and lab locations must be present before this job can run.

· Prompted Variables

- $RUN - Run type = S1 for the first run of the month

S2 for the second run of the month

S3 for the annual run

- $MMM - 3-character name of the current month, e.g. JAN, FEB, MAR...

- $YY - 2-digit current year or prior year if annual run.

- $CCYY - 4-digit current year, or prior year if annual run.

- $MM 2-digit month number of the current month, eg. 01, 02

- $DD 2-digit current day

· Manual Job modifications

- None

Job Post-Processing Instructions:

· Log Entries

- Date job ran

- JES number

· Verification

- All steps must have COND CODE=0000

- STEP4 will only execute if all prior steps have COND CODE=0000

- STEP5 will only execute if at least one prior step has a non-zero condition code.

· Reports for Users

- None

· Additional Procedures

- None

Rerun/Restart Procedures:

· Job is NOCALL.

· If the job fails, it should be rerun from the beginning.

Contact Information:

For Technical issues, or if all files from the campuses are not present:

See Technical Contacts at the beginning of this document

For Functional issues, including informing of a delay in delivery:

Rowena Wong

HRB – Information Systems and Support

300 Lakeside, #4038

(510) 987-9965