Site Import

Owned by Kathleen Avery (Deactivated)
Last updated: Oct 29, 2019
1 min read

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