1、Business Requirements SpecificationE:wenkufile12018-423da70221d-8b49-4d85-9e59-9c221f82a319c3339b51b9074e1ffb50ee891b466c0c.pdfSystem: HRISName: ODS Legacy Data Extract1.1 Business OverviewCurrently HR information is provided to other on-line mainframe legacy applications through mainframe-based dat
2、a primarily obtained from the legacy Payroll Master and Personnel Data Block files. To keep these other applications opertional once HRIS is implemented, the information needed for these legacy applications has been mapped to data on the HRIS ODS, and new files will be recreated nightly from the ODS
3、 data. These files are: Employee, Position, Compensation Plans, Leave Activity, and Pay Cycle.1.2 Business Requirements MatrixBusinessRequirementFunctional Requirement Detail1 A persons demographic information is needed by the legacy systems1a Extract person table data from HRIS ODS PERSON table.For
4、 each person (row) in the HRIS ODS PERSON table, extract the person table data to populate the Employee file.2 Information concerning the positions a person holds is required by the legacy system2a Extract position table data from the HRIS ODS POSITION table.For each “current” of “future” position (
5、row) in the POSITION tables as determined by a “C” or “F” in Position Trans Status Code, extract the ODS data from the tables to populate the Position file.3 Information concerning the various compensation plans a person has is required by the legacy systems.3a Extract compensation plan table data f
6、rom the HRIS ODS Compensation Participation Activity Star.For each person (row) in the PERSON table, extract the PERSON and “current” or “future” COMPENSATION Business Requirements SpecificationE:wenkufile12018-423da70221d-8b49-4d85-9e59-9c221f82a319c3339b51b9074e1ffb50ee891b466c0c.pdfPLANS (tables)
7、 tadat to populate the Compensation Plan file. A “C” or “F” in Compensation Participation Status code determines “current” and “future”.4 Pay cycle information is needed in order to perform processig in the legacy systems,4a Extract pay cycle table data from HRIS ODS Employee Pay Activity Star.For e
8、ach “current” or “future” Pay Calendar (row) in the Pay Calendar tbale, as determined by a “C” or “F” in Pay Calendar Status Code, extract the ODS data from the tables to populate the Pay Cycle file.5 Extracted data transferred and formatted for use on the mainframe.5a FTP data, format numeric data, and load cluster.FTP data to awaiting mainframe file. Use File Aid to reformat numeric data into COBOL signed numeric format, define and load cluster.
