HR/CORE-CT data is retrieved using the HRISWebAPI.

PS_LOCATION_TBL_VW java field Page-Up field

LOCATION locationID siteID, siteNo, part of name

EFFDT effectiveDate

EFF_STATUS effectiveStatus

DESCR description part of name

DESCRSHORT descriptionShort part of address1

BUILDING building

COUNTRY country

ADDRESS1 addressLine

CITY city part of address1

STATE state

POSTAL postalCode

SETID setID

campusID address1, build based on specific criteria

campusName address2

Find all Effective Sites:

For each site id, retrieve the row with an effectiveStatus of “A” and the most recent effectiveDate.

Create campusID:

Check the descriptionShort field, if there is a dash(-) in the data, take the data following the dash, concatenate a dash, then concatenate the city. This will be the campusID.

Ex. dataFollowingDash-Storrs

If the descriptionShort does not contain a dash, set the campusID to the city.

Ex. Hartford

If the locationID contains the string “LAW”, concatenate a dash (-) followed by the string “LAW” to the campusID.

Ex. Hartford-LAW

Create campusName:

Split campusID into parts, using dash(-) as the separator.

If there is more than one dash in the field issue a warning, ignoring the campusName field.

If there is only one dash, retrieve the information following the dash and place it in the campusName field.

Create Page-up file:

Page-up siteId and site number are the locationID.

Page-up name is the locationid concatenated with a dash(-) concatenated with the description.

Page-up address1 is the campusID.

Page-up address2 is the campus name.

Name of the file:

site-page-up.txt

Sample data:

SiteID|SiteNo|Name|Address1|Address2

UOC00064B|UOC00064B|UOC00064B-GENTRY BLDG-B|01STO|STORRS MANSFIELD

UOC00077R|UOC00077R|UOC00077R-WILBUR CROSS-R-REGISTRAR|01STO|STORRS MANSFIELD

UOC000171|UOC000171|UOC000171-JOHN W ROWE CTR-EARLY COLL EX|01STO|STORRS MANSFIELD

UOC00064E|UOC00064E|UOC00064E-GENTRY BLDG-E|01STO|STORRS MANSFIELD

UOC00068J|UOC00068J|UOC00068J-MANCHESTER HALL-JUDAIC STUDIES|01STO|STORRS MANSFIELD

UOC000224|UOC000224|UOC000224-GENTRY BLDG-COMMPACT|01STO|STORRS MANSFIELD

UOC000233|UOC000233|UOC000233-DEPOT FUEL CELL|01STO|STORRS MANSFIELD

UOC000236|UOC000236|UOC000236-UNITED TECH ENG-ENG COMP SVCS|01STO|STORRS MANSFIELD

UOC000130|UOC000130|UOC000130-BUDDS BLDG-TREASURY|01STO|STORRS MANSFIELD

UOC0005MR|UOC0005MR|UOC0005MR-BABBIDGE LIBR.-MR|01STO|STORRS MANSFIELD

Execution Command:

/createSiteFileJob.html

Control-M Schedule and Job:

UAT - UAT_AEWEB_SCHEDULE/UAT_RPM_SITE_TO_PAGEUP

PRD - PRD_AEWEB_RPM_SCHEDULE1/PRD_RPM_SITE_TO_PAGEUP1