GENERAL PERSON UPDATE SCRIPTS
Keeping addresses correct
and up-to-date can be quite a challenge. The three processes described below are performed nightly
to help in this task:
Seasonal Address Update
Address Status Indicator Update
Campus Phone Extension Update
Seasonal
Address Update
A nightly process has been created to update TO: and FROM: dates on Seasonal Addresses.
This process will be run Monday through Friday, and will process as follows:
| Will
process addresses of type 'SE' only.
Will find each address and check the FROM: and TO: dates. If today's date is greater than the FROM: and TO: dates on the address record, the dates will be updated as follows: The 'Month and Day' will be left as is, and the 'Year' field will be incremented by one. |
Examples:
Program run on 1/15/98 -
| FROM: 12/1/97 | TO: 4/1/98 | NOT UPDATED - Active |
| FROM: 6/1/98 | TO: 9/1/98 | NOT UPDATED - Inactive |
| FROM: 12/1/97 | TO: 1/1/98 | CHANGED -- FROM: 12/1/98, TO: 1/1/99 - Inactive |
| FROM: 1/1/97 | TO: 9/1/97 | CHANGED -- FROM: 1/1/98, TO: 9/1/98 - Active |
Address Status Indicator Update
A nightly process has been created to update the Status Indicator field on all addresses. This process will be run Monday through Friday, and will process as follows:
Will process addresses of all types.
Will find each address and check the FROM: and TO: dates. If today's date does not fall within the FROM: and TO: date range, the status indicator field will be updated as follows:
| if FROM: date > today's date | Status Indicator will be set to I |
| if TO: date < today's date | Status Indicator will be set to I |
| if
FROM: date <= today's date
AND TO: date >= today's date |
Status Indicator will be set to NULL (i.e. blank) |
| if
FROM: date <= today's date
AND TO: date is NULL |
Status Indicator will be set to NULL (i.e. blank) |
Examples:
Program run on 1/15/98 -
| FROM: 2/1/98 | TO: 4/1/99 | Status Indicator will be set to I |
| FROM: 4/1/97 | TO: 12/1/97 | Status Indicator will be set to I |
| FROM: 12/1/97 | TO: 3/1/98 | Status Indicator will be set to NULL (i.e. blank) |
| FROM: 6/1/97 | TO: | Status Indicator will be set to NULL (i.e. blank) |
A nightly process has been created to update students' phone extensions on 'CB' phone records. This process will be run Monday through Friday, and will process as follows:
| Will delete all 'CB' phone records in the Telephone file (SPRTELE). |
| Will search the Housing Assignment file (SLRRASG) to find an Active assignment for each student in the current term. |
| Will create a new SPRTELE phone record for each student with an extension equal to the extension in the room that she is assigned to. The new record created will be populated as follows: |
| phone type: | PH |
| address type: | CB |
| sequence: | 1 |
| area code | 413 585 |
| exchange: activity date: | today's date |
