HR data is retrieved using the HRISAPI and HRINTRECRUIT Database
UC_HR_DUMP_TREE_VW java field Page-Up field
ROWID rowid
DT_ID dtId
DT_J_DEPT_ID deptId used in BusinessUnitLevel1ID
used in BusinessUnitLevel12D
used in BusinessUnitLevel3ID
DT_DEPT_DESC description Name
DT_DEPT_PARENT_NODE_ID parentNodeId
DT_DEPT_NODE_ID nodeID
DT_NODE_LEVEL nodeLevelNumber
DT_TREE_LEVEL_NUM treeLevelNumber
DataBase View – taken from PSTREENODE-VW
UC_HR_DUMP_TREE_VW
DT_J_DEPT_ID – Department Number
DT_DEPT_DESC – Department Description
DT_PARENT_NODE_ID
DT_DEPT_NODE_ID
DT_NODE_LEVEL
DT_TREE_LEVEL_NUM – Level
Logic:
The Business Unit files must have a header record followed by all the detail records. The delimiter used to separate the fields is the pipe(|). All three Business Unit files will be created with one job, multiple steps.
Create a hierarchy tree for each department from the lowest level to the highest level, where the highest level is 4 and the lowest level is 10. This hierarchy is used to create all three Business Unit Files. Do not include any departments where the department description is blank.
Business Unit 1 file is a file containing the highest level department. In the case of UConn, the highest level is 4, which are the President of the University, the Provost of Academic Affairs, and the Executive Vice President and CFO.
Business Unit File 1 contains only the level 4 records (hierarchy tree size = 4). Levels 1, 2, and 3 are ignored.
The BusinessUnitLevel1ID will be the department number. This is the key to the file, therefore must be unique.
The Name is the department description.
Sample Business Unit 1 file:
BusinessUnitLevel1ID|Name
UOC01000|President
UOC01522|Exec VP Admin and CFO
UOC01052|Provost Academic Affairs
Business Unit 2 file is a file containing levels mainly 5, 6, and 7. Highest level is 5 and lowest level is 7.
Remove any level with a department description stating with INA-. These are UConn inactive accounts. HR uses the INA- prefix in the description because Core-CT will not allow them to delete any department numbers.
Combinations:
Levels:
All three levels (5, 6, 7)
Level 5 and Level 6
Level 5 and Level 7
Level 6 and Level 7
Level 5, only
Level 6, only
Level 7, only
No Level 5, Level 6, or Level 7
If there is no level 5, 6 or 7, determine if level 8, 9, or 10 exists. If level 8, 9, or 10 exists use levels 8, 9, and 10 in place of levels 5, 6, and 7 to create the BusinessUnitLevel2ID and Name. If only a level 4 exists, use the level 4 department id for both the BusinessUnitLevel2ID and the BusinessUnitLevel1ID and use the department description for level 4, as the Name.
Levels 1, 2, and 3 are ignored.
BusinessUnitLevel2ID is the key to the file, therefore must be unique.
If only one of these levels exist the BusinessUnitLevel2ID is the department number of the level. If multiple levels exist, the BusinessUnitLevel2ID is the department number of the highest level followed by a dash followed by the next highest level number and if needed (followed by a dash followed by the lowest level).
Examples:
UOC01151
UOC01179-UOC01895
UOC01179-UOC01895-UOC01161
The Name is the department description. In the case of multiple departments the second and third descriptions are entered into parenthesis. Remove entire record if the department description is blank. These are invalid organizations.
Examples:
Agriculture,Health,Natural Rcs
Business(Business Undergrad Programs)
Business(Business Undergrad Programs)(Research)
The BusinessUnitLevel1ID is the level 4 department for the particular hierarchy. This should point back to an entry in the Business Unit 1 file.
The entries in Business Unit 1 file must also appear in the Business Unit 2 file. Page-Up needs this to create a waterfall effect.
Sample Business Unit 2 file:
BusinessUnitLevel2ID|Name|BusinessUnitLevel1ID
UOC01179-UOC01896|Business(Business Graduate Programs)|UOC01052
UOC01226|Engineering|UOC01052
UOC01179|Business|UOC01052
UOC01151|Agriculture,Health,Natural Rcs|UOC01052
UOC01843|Planning, Design and Construct|UOC01522
UOC01609|Facilities Operations|UOC01522
UOC01116|INA(Torrington Campus)|UOC01052
UOC01267-UOC01878|Liberal Arts and Sciences(CLAS Life Sciences)|UOC01052
UOC01059|Information Technology Svcs|UOC01052
UOC01927|Privacy Protection and Mgmt|UOC01000
UOC01928|University Compliance|UOC01000
Business Unit 3 file is a file containing all departments. Highest level is 4 and lowest level is 10. The BusinessUnitLevel3ID is to be created using level 8, 9, and 10 in reverse order unless levels 8, 9, an 10, do not exist in the departments hierarchy. Levels 1, 2, and 3 are ignored.
Remove any level with a department description stating with INA-. These are UConn inactive accounts. HR uses the INA- prefix in the description because Core-CT will not allow them to delete any department numbers.
Combinations:
Levels:
All three levels (8, 9, 10)
Level 8and Level 9
Level 8 and Level 10
Level 9 and Level 10
Level 8, only
Level 9, only
Level 10, only
No Level 8, Level 9, or Level 10 – Then evaluate for levels 5, 6, and 7.
All three levels (5, 6, 7)
Level 5 and Level 6
Level 5 and Level 7
Level 6 and Level 7
Level 5, only
Level 6, only
Level 7, only
No Level 5, Level 6, or Level 7
If there is no level 8, 9, or 10, determine if level 5, 6, or 7 exists. If level 5, 6, or 7 exists use Levels 5, 6, and 7 in place of levels 8, 9, and 10 to create the BusinessUnitLevel3ID and Name. If only a level 4 exists, use the level 4 department id for both the BusinessUnitLevel3ID and the BusinessUnitLevel2ID and use the department description for level 4, as the name.
BusinessUnitLevel3ID is the key to the file, therefore must be unique.
If only one of these levels exist the BusinessUnitLevel3ID is the department number of the level. If multiple levels exist, the BusinessUnitLevel3ID is the department number of the highest level followed by a dash followed by the next highest level number and if needed (followed by a dash followed by the lowest level). Note that this is in the reverse order of how the keys are created in Business Unit 2 file.
Examples:
UOC01151
UOC01895-UOC01179
UOC01161-UOC01895-UOC01179
The Name is the department description. In the case of multiple departments the second and third descriptions are entered into parenthesis. Note that the department descriptions are also reversed from the way they are created in the Business Unit 2 file. Remove entire record if the department description is blank. Organizations with blank descriptions are invalid organizations.
Examples:
Agriculture,Health,Natural Rcs
Business Undergrad Programs(Business)
Research(Business Undergrad Programs)(Business)
The BusinessUnitLevel2ID is the level 5, 6, and/or 7 created similar to the BusinessUnitLevel2ID from the Business Unit 2 file.
The entries in Business Unit 2 file must also appear in the Business Unit 3 file. Page-Up needs this to create a waterfall effect.
Sample Business Unit 3 file:
BusinessUnitLevel3ID|Name|BusinessUnitLevel2ID
UOC01897|MS BAPM|UOC01179-UOC01896
UOC01179|Business|UOC01179
UOC01177-UOC01175|Plant Sci and Landscape Garden(Plant Sci and Landscape Arch)|UOC01151
UOC01649|INA(Capital Projects)|UOC01843
UOC01170-UOC01178|Environmental Health Center(Allied Health Sciences)|UOC01151
UOC01911|Emergency Management|UOC01885
UOC01646|Facilities Energy Services|UOC01609
UOC01065|Global Affairs|UOC01065
UOC01122|INA(Torrington Student Service)|UOC01116
UOC01324|Social Work Instruct and Rsrch|UOC01323
UOC01578|UConn Police Services|UOC01885
UOC01327-UOC01325|Library Administration(University Libraries)|UOC01325-UOC01327
Page-Up Files:
BusinessUnit1File – (delimiter is a pipe(|))
BusinessUnitLevel1ID
Name
BusinessUnit2File – (delimiter is a pipe(|))
BusinessUnitLevel2ID
Name
BusinessUnitLevel1ID
BusinessUnit3File – (delimiter is a pipe(|))
BusinessUnitLevel3ID
Name
BusinessUnitLevel2ID
Names of the files:
business-unit-1-page-up.txt
business-unit-2-page-up.txt
business-unit-3-page-up.txt
Execution Commands:
/createBusinessUnitFilesJob.html
Control-M Schedule and Job:
UAT - UAT_AEWEB_SCHEDULE/UAT_RPM_BUSINESS_UNITS_TO_PAGEUP
PRD - PRD_AEWEB_RPM_SCHEDULE1/PRD_RPM_BUSINESS_UNITS_TO_PAGEUP1