Interface: PROJ - Absences Version 2019.00

This documentation describes the AbaConnect Interface Absences for the PROJ Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :PROJ
Interface Name :Absences
ID :Absences ( N11 )
Version :2019.00
Status:Productive


Displays the possible import and export features for this interface.

Export / Import Modus
Export :XML
Import :XML


Displays additional information for this interface.

Additional Information

                                  Highest field Revision for this interface : 0



Mapping Information

The following displays the Mapping details for this interface.

Mapping Information
Mapping ID :AbaDefault
Mapping Name :Absences
Description :

                



Example AbaConnect XML Structure

The following is an example of an XML Header structure. This information is also visible in an AbaConnect XML Export file, that has been exported via the Abacus AbaConnect User Interface.

AbaConnect XML Struktur
<?xml version='1.0' encoding='UTF-8'?>
<AbaConnectContainer>
  <TaskCount>1</TaskCount>
  <Task>
    <Parameter>
      <Application>PROJ</Application>
      <Id>Absences</Id>
      <MapId>AbaDefault</MapId>
      <Version>2019.00</Version>
      <!-- Attention : The client number (Mandant) is optional and implies that the data can only be imported into specified client (Mandant) -->
      <!-- The Client Option (Mandant) only has an influence when importing data. It can be configured in the AbaConnect Export Settings. -->
      <!-- By default, the client number (Mandant) is not written to the export file -->
      <Mandant>7777</Mandant>
    </Parameter>
    <Transaction>
      <Absence mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </Absence>
    </Transaction>
  </Task>
</AbaConnectContainer>



Example AbaConnect Command Line

The following includes examples of AbaConnect Command Line. The AbaConnect Command Line is executed with the abaconnectexportconsole.exe and abaconnectimportconsole.exe programmes. The AbaConnect Command Line must be run direct on the Abacus server. More detailed information about AbaConnect Command Line is available on the Abacus Homepage. The following examples serve as starting point for creating a simple command line.

AbaConnect Command Line
Export :
abaconnectexportconsole.exe "/USRuser" "/PWxxx"  "-aPROJ"  "-version2019.00"  "-M7777"  "-acidAbsences"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aPROJ"  "-version2019.00"  "-M7777"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-importfileX:\data.xml"

N.B. : For importing XML data, it is not necessary to specify the Interface ID and Mapping on the Command Line. This information is contained in the XML Import file.



Mapping Structure

The following displays a simplified mapping structure for this interface.
The XML-Element and Parent-Name are always in english. Click on the row to display additional information.

XML Element Name Field Name Parent Name Type Length Mandatory
+ AbsenceAbsences---Yes
    - AbsenceIdAbsence no.AbsenceNumber8No
    - IdIdAbsenceGUID36No
    - ProgramProgramAbsenceNumber4No
    - StatusStatusAbsenceNumber8No
    - StartDateTimeStart dateAbsenceDate/Time-No
    - EndDateTimeEnd dateAbsenceDate/Time-No
    - DescriptionDescriptionAbsenceText60No
    - EmployeeIdEmployee no.AbsenceNumber10No
    - AbsenceTypeType of absenceAbsenceNumber2No
    - ServiceCodeService codeAbsenceNumber8No
    - FormatStartAbsence format for start dateAbsenceNumber2No
    - FormatEndAbsence format for end dateAbsenceNumber2No
    - SourceProgramCreated in programAbsenceNumber2No
    - SequenceIdProcedureAbsenceNumber4No
    - ApprovalIdRelease process IdAbsenceGUID36No
    - QuantityNumberAbsenceNumber10No
    - UnitUnitAbsenceText4No
    - RepetitionNrRepetitionAbsenceNumber8No
    - RepStartDateStarts onAbsenceDate-No
    - RepEndDateEnds onAbsenceDate-No
    - RepLimitEnds afterAbsenceNumber4No
    - EmplContractEmploymentAbsenceNumber8No
    - ProRataPercentageAbsenceNumber4No



Field Information

The following is a detailed description of the fields used in this interface.

Absence no.
XML Element Name:AbsenceId
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "AbsenceNr")
                    

Id
XML Element Name:Id
Parent Element:Absence
Field Type:GUID
Action Type:Import und Export
Field Length:   36Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   2
Description:

                                  (The internal field ID for this element is "Id")
                    

Program
XML Element Name:Program
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   3
Description:

                                  (The internal field ID for this element is "Program")
                    

Status
XML Element Name:Status
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

                                  (The internal field ID for this element is "Status")
                    

Start date
XML Element Name:StartDateTime
Parent Element:Absence
Field Type:Datum/Zeit (2006-08-08T10:16:54.509+02:00)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:

                                  (The internal field ID for this element is "StartDateTime")
                    

End date
XML Element Name:EndDateTime
Parent Element:Absence
Field Type:Datum/Zeit (2006-08-08T10:16:54.509+02:00)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   6
Description:

                                  (The internal field ID for this element is "EndDateTime")
                    

Description
XML Element Name:Description
Parent Element:Absence
Field Type:Text
Action Type:Import und Export
Field Length:   60Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   7
Description:

                                  (The internal field ID for this element is "Description")
                    

Employee no.
XML Element Name:EmployeeId
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   8
Description:

                                  (The internal field ID for this element is "EmplNr")
                    

Type of absence
XML Element Name:AbsenceType
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   9
Description:

                                  (The internal field ID for this element is "AbsenceType")
                    

Service code
XML Element Name:ServiceCode
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   10
Description:

                                  (The internal field ID for this element is "ServiceCode")
                    

Absence format for start date
XML Element Name:FormatStart
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   11
Description:

                                  (The internal field ID for this element is "FormatStart")
                    

Absence format for end date
XML Element Name:FormatEnd
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   12
Description:

                                  (The internal field ID for this element is "FormatEnd")
                    

Created in program
XML Element Name:SourceProgram
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   13
Description:

                                  (The internal field ID for this element is "Source")
                    

Procedure
XML Element Name:SequenceId
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   14
Description:

                                  (The internal field ID for this element is "Sequence")
                    

Release process Id
XML Element Name:ApprovalId
Parent Element:Absence
Field Type:GUID
Action Type:Import und Export
Field Length:   36Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   15
Description:

                                  (The internal field ID for this element is "ApprovalId")
                    

Number
XML Element Name:Quantity
Parent Element:Absence
Field Type:Nummer
Action Type:Export only
Field Length:   10Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   16
Description:

                                  (The internal field ID for this element is "Quantity")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Unit
XML Element Name:Unit
Parent Element:Absence
Field Type:Text
Action Type:Export only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   17
Description:

                                  (The internal field ID for this element is "Unity")
                    

Repetition
XML Element Name:RepetitionNr
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "RepetitionNr")
                    

Starts on
XML Element Name:RepStartDate
Parent Element:Absence
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:
The repetition will be executed starting from this date
(The internal field ID for this element is "RepStartDate")

Ends on
XML Element Name:RepEndDate
Parent Element:Absence
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:
The repetition will be executed until this date (maximum 1 year from start date)
(The internal field ID for this element is "RepEndDate")

Ends after
XML Element Name:RepLimit
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   1
Description:
Number of repetitions
(The internal field ID for this element is "RepLimit")

Employment
XML Element Name:EmplContract
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   1
Description:
Terms of employment of employee
(The internal field ID for this element is "EmplContract")

Percentage
XML Element Name:ProRata
Parent Element:Absence
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   2Mandatory Field:   NoRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "ProRata")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.