| View Name: | MARITrainingParticipant |
| Based on table: | MPTrainingParticipant |
| Group: | Group: TrainingParticipant |
| Description: | Training Module: List Of Participants |
| ClassID: | 438. See Overview of ClassIDs by table. |
| Field | Table(Germ.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 |
MARISysConnections.CompanyId (WHERE ConnectionType=6) | |
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| ContactPerson | ContactPerson INT Index |
OCPR.CntctCode | |
| Employee | Employee NVARCHAR (20) Index |
MARIEmployeeMaster.Employee | |
| A0CardCode | A0Empfaenger NVARCHAR (20) |
Only FreeParticipant: Not Used | OCRD.CardCode |
| A0SingleCustomer | A0Einmalkunde SMALLINT |
Only FreeParticipant: Not used | |
| A0Salutation | A0Anrede NVARCHAR (50) |
Only FreeParticipant: Not Used | |
| A0Name1 | A0Name1 NVARCHAR (100) |
Only FreeParticipant | |
| A0Name2 | A0Name2 NVARCHAR (50) |
Only FreeParticipant | |
| A0Name3 | A0Zusatz NVARCHAR (50) |
Only FreeParticipant | |
| A0Matchcode | A0Matchcode NVARCHAR (100) |
Only FreeParticipant | |
| A0Street | A0Strasse NVARCHAR (100) |
Only FreeParticipant | |
| A0StreetNumber | A0Hausnummer NVARCHAR (100) |
Only FreeParticipant | |
| A0Country | A0Land NVARCHAR (3) |
Only FreeParticipant | |
| A0ZIP | A0PLZ NVARCHAR (20) |
Only FreeParticipant | |
| A0City | A0Ort NVARCHAR (100) |
Only FreeParticipant | |
| A0County | A0Bezirk NVARCHAR (100) |
Only FreeParticipant | |
| A0State | A0Bundesland NVARCHAR (3) |
Only FreeParticipant | |
| A0Block | A0Gebaeude NVARCHAR (100) |
Only FreeParticipant | |
| A0ContactPerson | A0AnsprechpartnerID INT |
Only FreeParticipant: Not Used | OCPR.CntctCode |
| A0AddressName1 | A0AdressName NVARCHAR (50) |
Only FreeParticipant | |
| A0AddressName2 | A0AdressName2 NVARCHAR (50) |
Only FreeParticipant | |
| A0AddressName3 | A0AdressName3 NVARCHAR (50) |
Only FreeParticipant | |
| A0Building | A0GebaeudeStockwerk NTEXT |
||
| A0AddressMemo | A0AdressMemo NTEXT |
||
| A0CardFName | A0CardFName NVARCHAR (100) |
Only FreeParticipant: Not Used | |
| A0AddrType | A0AddrType NVARCHAR (100) |
Only FreeParticipant: Not Used | |
| A0AddressLineNum | A0AdressLineNum 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 |
MARIGroups.Group1 (WHERE GruppenArt=10061) | |
| Group2 | Group2 INT |
MARIGroups.Group2 (WHERE GruppenArt=10062) | |
| Group3 | Group3 INT |
MARIGroups.Group3 (WHERE GruppenArt=10063) | |
| CustomerLanguageID | CustomerLanguageID INT |
MARISysCustomerLanguages.CustomerLanguageID | |
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Memo | Memo NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARITrainingParticipantExams | Training Module: Passed exams of participants |
| MARITrainingParticipantGrades | Training Module: Grades of participants |
| MARITrainingRegistration | Training Module: Registratrion to training cources |
| MARIWorkItemPosition | Positions for Service Task, Internal Service Task, Result Task, Serice Plan, Qualification (Plan+Task), AP Audit (+Plan+Task), Training Cource |
| MARITrainingRegistrationTeam | Training Module: Team for the training |