Location Import
HR/CORE-CT data is retrieved using the HRISWebAPI.
RS_PS_LOCATION_TBL java field Page-Up field
LOCATION locationID LocationID
EFFDT effectiveDate
EFF_STATUS effectiveStatus
DESCR description Name
DESCRSHORT descriptionShort
BUILDING building
COUNTRY country
ADDRESS1 addressLine
CITY city
STATE state
POSTAL postalCode
SETID setID
country Country
state State
Find all Effective Sites:
For each location id, retrieve the row with an effectiveStatus of “A” and the most recent effectiveDate.
Create Page-up file:
Page-up locationID is the locationID.
Page-up name is the description.
Page-up country defaults to “USA”.
Page-up country defaults to “CT”.
Fields are separated by the pipe (|) delimiter.
Name of the file:
locations-page-up.txt
Sample data:
LocationID|Name|Country|State
0008|School Of Social Work|USA|CT
0010|Hartford County Extension Ctr|USA|CT
0015|Tolland County Extension Ctr|USA|CT
0017|Farmington|USA|CT
0009|Fairfield County Extension Ctr|USA|CT
Execution Command:
/createLocationFileJob.html
Control-M Schedule and Job:
UAT - UAT_AEWEB_SCHEDULE/UAT_RPM_LOCATION_TO_PAGEUP
PRD - Not being run in production