The BRS Purge Process is typically run for each campus at the end of each term, although it can be run whenever a campus requests it. During the purge process, detail transactions that have been billed, paid and applied, and fed to accounting are moved to the history area of the database. To maximize the number of records that are moved, the process begins with an accounting feed and a billing cycle. An extract is also run that uses the billing code to identify which student accounts will be processed by the purge.
By removing this detail, only active items appear on a student’s bill, the on-line system is easier to navigate, and batch run times are better managed.
The BRS purge can be run for more than one campus at one time, or it
can be run separately for each campus/AU. If it is run for
more than one campus, the campuses running together must agree to the setups
to be used. Under the current process, three purge jobs (TEUO$) are
run on a selected weekend at the end of the semester. Boulder (UCB)
and Health Sciences (HSC) run separately, while Denver (UCD), Colorado
Springs (UCCS), and Boulder Continuing Ed (UCBCE) run together.
Purge Process:
Purge jobs that will be run during the purge weekend are listed in the process chart (above). These jobs must run in the following sequence:
TEFF - SID Extract
TECB$ - Combined Sched/Bill Extract and Update
TERJ - Account Snapshot
TEUO$ - Billing Detail Purge
Within the week following the Billing Detail Purge (TEUO$), schedule these jobs to run:
TEUU$ - Student Billing Code Reset
TEUR$ - SIS Student Billing Code Load
Purge Program Selection Criteria:
Calendar:
Purges are scheduled three times per year. A purge is run near the end or after each semester. Typical purge run dates follow:
Beginning to mid December – Fall purge
Beginning to mid May – Spring Purge
Beginning of August – Summer Purge
Purge Tasks:
| When | Responsible Party | Task |
| Prior to purge week | Key users |
|
| Purge week - Wednesday by 5:00 pm | Each key user | Provide UMS production services with:
|
| Purge week - Thursday by 5:00 pm | Each key user | Provide UMS production services with:
|
| Purge week - Friday by noon | UMS Production Services | Will contact each campus production services area if problems are discovered with control records or setups. |
| Week following purge | Each key user | Provide UMS production services with:
|
Sample Purge Flow:
Production Purge Process
Flow Chart
Sample Setups for UCB:
TEFF@BPG - Provide UMS with name of USER LIBRARY & MEMBER that contain control records, and dataset name qualifier for FINDER FILE that will be created.
Example of control records from BBUR.PROD.LIB(TEFFBPG):
| SIPR699;INST=BD;EXTERNALS=
L***;
SIPR699;BC=BD,FB,SU,BC,IE,TC,SU,UW, ,** |
Example for dataset name qualifier: 024B1PG (Will produce finder file named SIS.TEFF.PURGE.FINDER.V024B1PG)
TECB$5BP - Provide UMS with name of USER LIBRARY & MEMBER that contain control records, and dataset name qualifier for FINDER FILE produced in TEFF@BPG.
Example of control records from BBUR.PROD.LIB(TECBBPG)
| SIPR702
ROUTE=BD ,UPDATE=Y,SELECT=*******;HOURS:TERM=20024,AU=B1;
SIPR702 MAIN CBBBJA 080902 N 080902BBMP080902 SIPR702 BYPS 19950-19951 999999-999999 ***-*** |
TERJ@BB - Provide UMS with name of USER LIBRARY & MEMBER that contain control records.
Example of control records from BBUR.PROD.LIB(TERJEOT)
| PGM=BBR300,INST=BD,ACCTSEL=I,TERM=***,
OPTION1=D,OPTION2=C,OPTION3=N AUB1 L111111111 L222222222 |
TEUO$5BP - Provide UMS with USER LIBRARY & MEMBER that contain control records, and dataset name qualifier of FINDER FILE produced in TEFF@BPG.
Example of control records from BBUR.PROD.LIB(TEUOPRG)
| PGM=BBT380,INST=BD,ACCTSEL=I,OPTION1=B,
SPURGEDT=080902,EPURGEDT=080902, TERM1=801,TERM2=024,TERM3=021 AU** BILLDT20020809 |
TEUU$5B - Provide UMS with USER LIBRARY & MEMBERS that contain control records.
Example of control records from BBUR.PROD.LIB(TEUU2A)
| SIPR207,BD,B1, ,A,OBA,Y, |
Example of control records from BBUR.PROD.LIB(TEUU2B)
| SIPR207,BD,
,*********,
SIPR207,UW, ,*********, SIPR207,IE, ,*********, |
TEUR$5B - Provide UMS with USER LIBRARY & MEMBERS that contain control records.
Example of control records from BBUR.PROD.LIB(TEUR1)
| PGM=SIPR698,YR/T=031,INST=BD,AU1=B1,AU2= ,EXT= ,UPDATE=Y |
Sample Setups for UCBCE:
TEFF@WPG - Provide UMS with name of USER LIBRARY & MEMBER that contain control records, and dataset name qualifier for FINDER FILE that will be created.
Example of control records from CEBUR.PROD.LIB(TEFFPRGW):
| SIPR699;INST=BD;EXTERNALS=WO***;
SIPR699;BC=CC,CB,CN, ,FW,CA,C4,CE,CI,CL,CR,CS,CT,CW,CX,CD,CP,CV,** |
Example for dataset name qualifier: 024B2PG (Will produce finder file named SIS.TEFF.PURGE.FINDER.V024B2PG)
TECB$5WP - Provide UMS with name of USER LIBRARY & MEMBER that contain control records, and dataset name qualifier for FINDER FILE produced in TEFF@WPG.
Example of control records from CEBUR.PROD.LIB(TECBPRGW)
| SIPR702
ROUTE=BD ,UPDATE=Y,SELECT=*******;HOURS:TERM=20024,AU=B2B3
;
SIPR702 MAIN CBBBKA 080902 N 080902BMPB080902 |
TERJ@B2,B2A,B2B - Provide UMS with name of USER LIBRARY & MEMBER that contain control records.
Example of control records from CEBUR.PROD.LIB(TERJEOT)
| PGM=BBR300,INST=BD,ACCTSEL=I,TERM=***,
OPTION1=D,OPTION2=C,OPTION3=N AU** W111111111 W222222222 |
TEUO$5 - Provide UMS with USER LIBRARY & MEMBER that contain control records, and dataset name qualifier of FINDER FILE produced in TEFF@WPG.
Example of control records from CEBUR.PROD.LIB(TEUOPRG)
| PGM=BBT380,INST=**,ACCTSEL=I,OPTION1=B,
SPURGEDT=050302,EPURGEDT=050302, TERM1=801,TERM2=024,TERM3=017 AU** BILLDT20020809 |
TEUU$5B2 - Provide UMS with USER LIBRARY & MEMBERS that contain control records.
Example of control records from CEBUR.PROD.LIB(TEUU2A)
- not available
Example of control records from CEBUR.PROD.LIB(TEUU2B)
- not available
TEUR$5B2 - Provide UMS with USER LIBRARY & MEMBERS that contain control records.
Example of control records from CEBUR.PROD.LIB(TEUR1)
| PGM=SIPR698,YR/T=031,INST=BD,AU1=B2,AU2=B3,EXT=W,UPDATE=Y |
Sample Setups for UCCS:
TEFF@CPG - Provide UMS with name of USER LIBRARY & MEMBER that contain control records, and dataset name qualifier for FINDER FILE that will be created.
Example of control records from CBUR.PROD.LIB(TEFFCPG):
| SIPR699;INST=CS;EXTERNALS=
P***;
SIPR699;BC=FA,FC,UW,UX,UY,UZ, ** |
Example for dataset name qualifier: 024C1PG (Will produce finder file named SIS.TEFF.PURGE.FINDER.V024C1PG)
TECB$5CP - Provide UMS with name of USER LIBRARY & MEMBER that contain control records, and dataset name qualifier for FINDER FILE produced in TEFF@CPG.
Example of control records from CBUR.PROD.LIB(TECBPRG)
| SIPR702
ROUTE=CS ,UPDATE=Y,SELECT=*******;HOURS:TERM=20024,AU=C1;
SIPR702 MAIN CBBBJA 080902 N 080902BMPL080902 |
TERJ@C,CC,CCC, - Provide UMS with name of USER LIBRARY & MEMBER that contain control records.
Example of control records from CBUR.PROD.LIB(TERJEOT)
| PGM=BBR300,INST=CS,ACCTSEL=I,TERM=***,
OPTION1=D,OPTION2=C,OPTION3=N AUC1 111111111 222222222 |
TEUO$5 - Provide UMS with USER LIBRARY & MEMBER that contain control records, and dataset name qualifier of FINDER FILE produced in TEFF@CPG.
Example of control records from CBUR.PROD.LIB(TEUOPRG)
| PGM=BBT380,INST=**,ACCTSEL=I,OPTION1=B,
SPURGEDT=050302,EPURGEDT=050302, TERM1=801,TERM2=024,TERM3=017 AU** BILLDT20020809 |
TEUU$5C - Provide UMS with USER LIBRARY & MEMBERS that contain control records.
Example of control records from CBUR.PROD.LIB(TEUU2A)
| SIPR207,CS,C1, ,A,OBA,Y, |
Example of control records from CBUR.PROD.LIB(TEUUBLK)
| SIPR207,FC,
,*********,
SIPR207,FA, ,*********, SIPR207,UW, ,*********, |
TEUR$5C - Provide UMS with USER LIBRARY & MEMBERS that contain control records.
Example of control records from CBUR.PROD.LIB(TEUR1)
| PGM=SIPR698,YR/T=031,INST=CS,AU1=C1,AU2=C2,EXT= ,UPDATE=Y |
Sample Setups for UCD:
TEFF@DPG - Provide UMS with name of USER LIBRARY & MEMBER that contain control records, and dataset name qualifier for FINDER FILE that will be created.
Example of control records from DBUR.PROD.LIB(TEFFPRG):
| SIPR699;INST=DN;EXTERNALS=
NY**;
SIPR699;BC=DN,DY,IE,DC,DD,ST,WS,TD,TP,PA,DT,FD,FA,TY, ,** |
Example for dataset name qualifier: 024D1PG (Will produce finder file named SIS.TEFF.PURGE.FINDER.V024D1PG)
TECB$5DP - Provide UMS with name of USER LIBRARY & MEMBER that contain control records, and dataset name qualifier for FINDER FILE produced in TEFF@DPG.
Example of control records from CBUR.PROD.LIB(TECBPRG)
| SIPR702
ROUTE=DN ,UPDATE=Y,SELECT= ******;HOURS:TERM=20024,AU=D1D2
;
SIPR702 MAIN CBBBJA 080902 N 080902BBMP080902 |
TERJ@D,DD,DDD - Provide UMS with name of USER LIBRARY & MEMBER that contain control records.
Example of control records from DBUR.PROD.LIB(TERJEOT)
| PGM=BBR300,INST=DN,ACCTSEL=I,TERM=***,
OPTION1=D,OPTION2=C,OPTION3=N AU** N111111111 222222222 |
TEUO$5 - Provide UMS with USER LIBRARY & MEMBER that contain control records, and dataset name qualifier of FINDER FILE produced in TEFF@DPG.
Example of control records from DBUR.PROD.LIB(TEUOPRG)
| PGM=BBT380,INST=**,ACCTSEL=I,OPTION1=B,
SPURGEDT=050302,EPURGEDT=050302, TERM1=801,TERM2=024,TERM3=017 AU** BILLDT20020809 |
TEUU$5D - Provide UMS with USER LIBRARY & MEMBERS that contain control records.
Example of control records from DBUR.PROD.LIB(TEUU2A)
| SIPR207,DN,D1, ,A,OBA,Y, |
Example of control records from DBUR.PROD.LIB(TEUU2B)
| SIPR207,DN,
,*********,
SIPR207,DT, ,*********, SIPR207,PA, ,*********, |
TEUR$5D - Provide UMS with USER LIBRARY & MEMBERS that contain control records.
Example of control records from DBUR.PROD.LIB(TEUR7)
| PGM=SIPR698,YR/T=027,INST=DN,AU1=D1,AU2=D2,EXT= ,UPDATE=Y |
Sample Setups for UCHSC:
TEFF@HPG - Provide UMS with name of USER LIBRARY & MEMBER that contain control records, and dataset name qualifier for FINDER FILE that will be created.
Example of control records from HBUR.PROD.LIB(TEFFHPRG):
| SIPR699;INST=HS;EXTERNALS=
X***;
SIPR699;BC=M1,M2,M3,M4,CH,GQ,T1,T2,T3,T4,T5,T6,T7,T8,FH,** SIPR699;BC=D1,D2,D3,D4,DH,HJ,HS,GS,NU,GN,NJ,NS,CE,UN,ND,** SIPR699;BC=P1,P2,P3,P4,P5,P6,P7,P8,P9,PH,MH,SN, ,** |
Example for dataset name qualifier: 022H1PG (Will produce finder file named SIS.TEFF.PURGE.FINDER.V022H1PG)
TECB$5HP - Provide UMS with name of USER LIBRARY & MEMBER that contain control records, and dataset name qualifier for FINDER FILE produced in TEFF@HPG.
Example of control records from HBUR.PROD.LIB(TECBHSPG)
| SIPR702
ROUTE=HS ,UPDATE=Y,SELECT=*******;HOURS:TERM=20025,AU=H1;
SIPR702 MAIN CBBBJA 080902 N 080902BPBM080902 |
TERJ@H,HH,HHH - Provide UMS with name of USER LIBRARY & MEMBER that contain control records.
Example of control records from HBUR.PROD.LIB(TERJH1)
| PGM=BBR300,INST=HS,ACCTSEL=I,TERM=***,
OPTION1=D,OPTION2=C,OPTION3=N AU** M111111111 X222222222 |
TEUO$5H - Provide UMS with USER LIBRARY & MEMBER that contain control records, and dataset name qualifier of FINDER FILE produced in TEFF@HPG.
Example of control records from HBUR.PROD.LIB(TEUO1HS)
| PGM=BBT380,INST=**,ACCTSEL=I,OPTION1=B,
SPURGEDT=080902,EPURGEDT=080902, TERM1=801,TERM2=022,TERM3=017 AU** BILLDT20020809 |
TEUU$5H - Provide UMS with USER LIBRARY & MEMBERS that contain control records.
Example of control records from HBUR.PROD.LIB(TEUU2A)
| SIPR207,HS,H1, ,A,OBA,Y, |
Example of control records from HBUR.PROD.LIB(TEUUBLK)
| SIPR207,M1,
,*********,
SIPR207,M2, ,*********, SIPR207,M3, ,*********, |
TEUR$5H - Provide UMS with USER LIBRARY & MEMBERS that contain control records.
Example of control records from HBUR.PROD.LIB(TEUR027)
| PGM=SIPR698,YR/T=027,INST=HS,AU1=H1,AU2= ,EXT= ,UPDATE=Y |
Hints:
[currently under development]