Ansicht
Dokumentation
RPUSWFG0 - Report RPUSWFG0
BAL_S_LOG - Application Log: Log header data Fill RESBD Structure from EBP Component StructureThis documentation is copyright by SAP AG.
Purpose
This report allows School Work Force data to be extracted in a CSV file format that is supported by the DCSF's CSV -> XML file conversion tool. Once converted to XML file format the data in the the XML file(s) can then be loaded up manually into the DCSF's COLLECT system when you have logged into the COLLECT system.
The CSV -> XML file conversion kit can be down loaded from the TeacherNet website.
Integration
The first step in this process is trying to work out how much data (if any) you will be taking from your SAP HR/Payroll system and which employees you will be taking this data for.
The School Work Force Census consists of the following sets of data;
- Staff,,,,,,(required if any of the other modules are being sent)
- Contract,,,,(Changes in the last 4 months + Spring Census only: all employees active on Census Date)
- Payment,,,,(Spring Census only: Payments made in the previous calendar year)
- Absence,,,,(Spring Census only: Payments made in the previous calendar year)
- Staff Information ,,(Spring Census only)
- Occasional Staff Head Count,,,,,,(Numbers of Qualified/Unqualified/Not Known)
- Vacancy,,,,,,,,,,,,(Vacancies in each school)
- Agency/Third Party Staff Head Count,,,,(Numbers per Role in each school)
o,,Curriculum,,,,(Autumn Census only)
o,,Qualification,,,,(Autumn Census only)
So you will need to perform a data mapping exercise to ensure that you know where all the relevant data included in the census is being held. Curriculum data is not held in SAP so for the Autumn Census at least you will need to a "partial" return. A "partial" return is where data is sourced from more than one systems, it is not where the data for a school is sent in two parts. The DCSF do not allow customer to send some data for one school in one file and then the rest in another file. If a customer were to do this the data sent first would be overwritten by the by the data sent second.
The SWF solution provided by SAP does try to support customers that wish to perform a "complete" return (even in Autumn) by providing database tables that can be populated with data which will then be picked up and sent. It is not expected that many customers will attempt this as loading data into SAP would require that the data was matched to the correct Personnel Number to make certain that the rest of the data was matched up with the correct employee.
It is our expectation that;
a) ALL customers will return one file (Type 3: Centrals) every census.
b) customers that pay their schools on SAP will return one file per school (Types 2: Schools complete data) for the Spring and Summer Census, but will return one file per school (Types 1b: Schools partial data) for the Autumn Census.
c) customers that do not pay their schools on SAP will
EITHER return one file per school (Types 1b: Schools partial data) for any data that they do want to take from SAP and the rest of the data will be taken from their Schools system (i.e. SIMMS)
OR return no data from SAP at all
So deciding upon the File Types that you will end up extracting is the first step to running this report.
The second step in this process is trying to work ensure that the data you wish to take from SAP is in a suitable state.
a) If you wish to take data from each school's MIS system (i.e. SIMMS) that data must be in a clean and consistent state).
b) If you wish to take data from SAP then you will need to populate the new SWF census infotypes;
,,SWF Census Staff Details infotype (3215) - mandatory for all teaching staff included in the Census
,,SWF Census Contract Details infotype (3216) - mandatory all staff included in the Census
,,SWF Census Qualification Details infotype (3217) - optional*
*Obviously, you may not wish to extract qualifications data from SAP and if you do not then you will not have to populated the new SWF Census Qualification Details infotype (3217). Equally, you may wish to take qualifications data from SAP, but already hold that information in Personnel Development (PD), in which case you can either populate the SWF Census Qualification Details infotype (3217) in time for the Autumn Census from your PD data (i.e. via a Batch Input Session or you can use the Qualifications BADI within the SWF Census report to read in your PD data.
c) If you wish just to perform a "partial" return from SAP, then even though the Minimum Data Set is allowed, it is still necessary to know the employee's "Employment Type" to be able to extract any other data modules. "Employment Type" is derived from the fields in the SWF Census Contract Details infotype (3216). This means that all staff except centrals (as they are always "Employment Type" 4: Other Support Staff) must have a SWF Census Contract Details infotype (3216) to have their data returned.
Prerequisites
You will need to have all your data in a clean and consistent state, filled all the necessary infotypes, performed all the necessary customizing steps and implemented any BADIs that are necessary for the report to correctly read your specific implementation of SAP's HR/Payroll solution.
Features
Selection
- Selection Tab
-,,Select the employees for whom you want to run the report.
-,,The date selection options are not provided as they are hard-coded within the report as follows;
-,,All employees that match the selection fields between the Current Start of Continual Assessment Date and the Current Census Date
SPRING: All employee data in the previous year up to the Spring Census Date
SUMMER: All employee data in the current year up to the Summer Census Date
AUTUMN: All employee data in the current year up to the Autumn Census Date
o,,Census Date tab
-,,Select the Return Year and the Return Term
Note
The system generates the following details according to the term that you specify.
For term type 1,,(Spring) ,,Staff, Contract, Payment, Absence, Vacancy and Staff Information
For term type 2 ,,(Summer) ,,Staff, Contract
For term type 3 ,,(Autumn),,Staff, Contract, Curriculum and Qualification.
o,,Processing Steps Tab
Select any one of the following:
-,,Generation,,,,Select this option to fill the data modules you have selected
-,,Maintenance,,Select this option to display and edit the data modules you have selected in the ALV.
-,,Extraction,,,,Select this option to extract any data modules that you have populated with data.
Standard Variants
Output
Activities
Example
Addresses (Business Address Services) ROGBILLS - Synchronize billing plans
This documentation is copyright by SAP AG.
Length: 7499 Date: 20240601 Time: 044211 sap01-206 ( 135 ms )
