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