| Table Name: | MPTrainingParticipant |
| View Name: | MARITrainingParticipant |
| Group: | Group: TrainingParticipant |
| Description: | Training Module: List Of Participants |
| ClassID: | 438. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| ParticipantNumber | ParticipantNumber NVARCHAR (20) Primary |
||
| Matchcode | Matchcode NVARCHAR (100) Index |
||
| LastName | LastName NVARCHAR (50) |
||
| MiddleName | MiddleName NVARCHAR (50) |
||
| FirstName | FirstName NVARCHAR (50) |
||
| Sex | Sex NVARCHAR (1) |
||
| Birthday | Birthday Datetime |
||
| BirthState | BirthState NVARCHAR (3) |
||
| BirthCity | BirthCity NVARCHAR (100) |
||
| BirthPlace | BirthPlace NVARCHAR (100) |
||
| Identifier | Identifier NVARCHAR (50) |
Not used | |
| ParticipantType | ParticipantType INT |
1=Business Partner Contact, 33=Employee, 438=MPTrainingParticipant | clsImportTrainingParticipant_eParticipantType |
| CompanyID | CompanyId SMALLINT Index |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| ContactPerson | ContactPerson INT Index |
OCPR.CntctCode | |
| Employee | Employee NVARCHAR (20) Index |
MPPersonenstamm.Personalnummer | |
| A0Empfaenger | A0CardCode NVARCHAR (20) |
Only FreeParticipant: Not Used | OCRD.CardCode |
| A0Einmalkunde | A0SingleCustomer SMALLINT |
Only FreeParticipant: Not used | |
| A0Anrede | A0Salutation NVARCHAR (50) |
Only FreeParticipant: Not Used | |
| A0Name1 | A0Name1 NVARCHAR (100) |
Only FreeParticipant | |
| A0Name2 | A0Name2 NVARCHAR (50) |
Only FreeParticipant | |
| A0Zusatz | A0Name3 NVARCHAR (50) |
Only FreeParticipant | |
| A0Matchcode | A0Matchcode NVARCHAR (100) |
Only FreeParticipant | |
| A0Strasse | A0Street NVARCHAR (100) |
Only FreeParticipant | |
| A0Hausnummer | A0StreetNumber NVARCHAR (100) |
Only FreeParticipant | |
| A0Land | A0Country NVARCHAR (3) |
Only FreeParticipant | |
| A0PLZ | A0ZIP NVARCHAR (20) |
Only FreeParticipant | |
| A0Ort | A0City NVARCHAR (100) |
Only FreeParticipant | |
| A0Bezirk | A0County NVARCHAR (100) |
Only FreeParticipant | |
| A0Bundesland | A0State NVARCHAR (3) |
Only FreeParticipant | |
| A0Gebaeude | A0Block NVARCHAR (100) |
Only FreeParticipant | |
| A0AnsprechpartnerID | A0ContactPerson INT |
Only FreeParticipant: Not Used | OCPR.CntctCode |
| A0AdressName | A0AddressName1 NVARCHAR (50) |
Only FreeParticipant | |
| A0AdressName2 | A0AddressName2 NVARCHAR (50) |
Only FreeParticipant | |
| A0AdressName3 | A0AddressName3 NVARCHAR (50) |
Only FreeParticipant | |
| A0GebaeudeStockwerk | A0Building NTEXT |
||
| A0AdressMemo | A0AddressMemo NTEXT |
||
| A0CardFName | A0CardFName NVARCHAR (100) |
Only FreeParticipant: Not Used | |
| A0AddrType | A0AddrType NVARCHAR (100) |
Only FreeParticipant: Not Used | |
| A0AdressLineNum | A0AddressLineNum INT |
Used to store eMail Opt Out | |
| A0GlbLocNum | A0GlbLocNum NVARCHAR (50) |
||
| A0Longitude | A0Longitude Float |
||
| A0Latitude | A0Latitude Float |
||
| LicTradNum | LicTradNum NVARCHAR (32) |
||
| Phone | Phone NVARCHAR (50) |
||
| Cellular | Cellular NVARCHAR (50) |
||
| Telefax | Telefax NVARCHAR (50) |
||
| Email NVARCHAR (100) |
|||
| Salutation2 | Salutation2 NVARCHAR (50) |
||
| Position | Position NVARCHAR (90) |
||
| Profession | Profession NVARCHAR (50) |
||
| Notes1 | Notes1 NVARCHAR (100) |
||
| Notes2 | Notes2 NVARCHAR (100) |
||
| Group1 | Group1 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10061) | |
| Group2 | Group2 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10062) | |
| Group3 | Group3 INT |
MPGruppen.GruppenID (WHERE GruppenArt=10063) | |
| CustomerLanguageID | CustomerLanguageID INT |
MPSysKundenSprachen.CustomerLanguageID | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPTrainingParticipantExams | Training Module: Passed exams of participants |
| MPTrainingParticipantGrades | Training Module: Grades of participants |
| MPTrainingRegistration | Training Module: Registratrion to training cources |
| MPTrainingRegistrationTeam | Training Module: Team for the training |
| MPWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |