hschan, 2005/05/24

HR ABSENCE DETAIL

Extract from PA2001

should include the following fields:

PERNR

SUBTY

ENDDA

BEGDA

AEDTM

UNAME

BEGUZ

ENDUZ

AWART

ABWTG

STDAZ

ABRTG

ABRST

HRSIF

ALLDF

For each pernr, also extract from PA001 the employee's:

WERKS

BTRTL

Instructions from Nitin Jog:

Extract Absences & Attendance for current & prior period

Absences are stored in infotype 2001 (table PA2001) and attendances are stored in table 2002 (table PA2002). Data Warehouse will extract the attendances and absences after completion of time & payroll processing every week (every Wednesday) for non-exempt and exempt employees. Following steps will be followed to extract this data:

1. Take all the records from PA2001 or PA2002 which are changed in the prior week. The field AEDTM (Last changed by) will be used to query records changed in the prior week.

2. Find the oldest date for which the data was changed. The Start Date (BEGDA) in the table identifies the date for which the data was changed.

3. Extract all the records in PA2001 or PA2002 from this date onwards

For example: If the data warehouse is extracting Attendance Data on Wednesday, March 13, 2005 for the week March 4-10. They would look for all the records which are changed between March 4 and 10 (both dates included)...by looking at field value AEDTM (Last Changed on). Let's say we come across the following table entries:

Start Date (BEGDA)    End Date (ENDDA)    Attendance Type (SUBTY)    Last Changed On (AEDTM)   
03/04/05                    03/04/05                    WORK                                    03/10/05
03/05/05                    03/05/05                    WORK                                     03/10/05
03/05/05                    03/05/05                    WORK                                     03/10/05
03/05/05                    03/05/05                    WORK                                     03/10/05
03/05/05                    03/05/05                    WORK                                     03/10/05
01/05/05                    01/05/05                    WORK                                     03/10/05
02/10/05                    02/10/05                    WORK                                     03/10/05

Since the oldest record was changed for date 01/05/05...Data Warehouse will extract all the records from table PA2002 for this employee from 01/05/05.

HR ABSENCE BALANCE

Extract from PA2006

should include the following fields:

PERNR

SUBTY

ENDDA

BEGDA

AEDTM

UNAME

KTART

ANZHL

KVERB

For each pernr, also extract from PA001 the employee's:

WERKS

BTRTL

PERSG

PERSK

Instructions from Nitin Jog:

Extract Balance Information

The quota balances are stored in table PA2006. Data Warehouse will extract data once a week or daily depending on the requirement. Every employee will have one record for each type of balance which will be valid from 1/1/06 or date of hire to 12/31/9999.

In the final version, we will have just one record for each quota type which will be valid from some day (it may be conversion date or date before that - it has not been decided yet).

Following are the various types of balances stored:
01: Vacation
02: 5th Week Vacation
03: Sick
04: Personal

(Exempts will have Vacation and fifth week vacation only. Service and Support will have all 4 leave types. MIT Students will not have leave balances.)

Following are important fields in table PA2006:
KTART: Absence Quota Type (type of absences as above)
ANZHL: Total Quota Entitlement
KVERB: Total Quota Deducted so far
BEGDA: Start date (it will be constant - 1/1/06 or date of hire)
ENDDA: End Date (it will be a constant ..12/31/9999)

All values for entitlement and deduction are stored in hours.

When an employee reports an absence of a specific type, the values in ANZHL and KVERB of the specific balance type will be updated accordingly for the employee, as well as AEDTM and UNAME