| Table Name: | MPTrainingRegistration |
| View Name: | MARITrainingRegistration |
| Group: | Group: TrainingParticipant |
| Description: | Training Module: Registratrion to training cources |
| ClassID: | 439. See Overview of ClassIDs by table. |
| Field | View(engl.field)/Type | Description | Related |
|---|---|---|---|
| RegistrationID | RegistrationID INT Primary |
||
| ParticipantNumber | ParticipantNumber NVARCHAR (20) Index |
MPTrainingParticipant.ParticipantNumber | |
| GroupParticipantNumber | GroupParticipantNumber NVARCHAR (20) Index |
MPTrainingParticipant.ParticipantNumber | |
| WorkItemID | WorkItemID INT Index |
Link to trainings cource | MPWorkItem.WorkItemID (WHERE WorkItemType=492) |
| Project | Project NVARCHAR (20) Index |
MPProjektstamm.Projektnummer | |
| Phase | PhaseID INT |
MPProjektPhasen.PhasenID | |
| ContractID | ContractID INT |
MPVKVertraege.VertragsID | |
| BaseContractID | BaseContractID INT |
Not used | |
| RegistrationStatus | RegistrationStatus INT Index |
MPHotlineSettings.ID (WHERE Setting=24) | |
| RegistrationDate | RegistrationDate Datetime |
||
| InvoiceMethod | InvoiceMethod INT |
||
| InvoiceLink | InvoiceLink INT |
||
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| Company | Company INT |
MPSysConnections.CompanyID (WHERE ConnectionType=6) | |
| ArrivalDate | ArrivalDate Datetime |
||
| ArrivalInformation | ArrivalInformation NVARCHAR (100) |
||
| PaymentMethod | PaymentMethod INT |
||
| PaymentReference | PaymentReference NTEXT |
||
| PaymentStatus | PaymentStatus INT |
||
| ReferenceNumber | ReferenceNumber NVARCHAR (100) |
||
| ReferenceSign | ReferenceSign NVARCHAR (100) |
||
| CreateDate | CreateDate Datetime |
||
| CreateUser | CreateUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MPBenutzer.Benutzer (WHERE BenutzerTyp=1) | |
| Notes | Notes NVARCHAR (100) |
||
| VisibilityMode | VisibilityMode INT |
||
| Remark | Remark NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MPTrainingRegistrationContractLink | Training Module: Selection of billable contract positions (Contract from registration) |
| MPTrainingRegistrationOptionLink | Training Module: Selectable options (formaly phases) |
| MPTrainingRegistrationPhaseLink | Training Module: Selected options=Phases from the project linked to the training cource |
| MPTrainingRegistrationTeamLink | Training Module: Link to the team |