| View Name: | MARITrainingRegistration |
| Based on table: | MPTrainingRegistration |
| Group: | Group: TrainingParticipant |
| Description: | Training Module: Registratrion to training cources |
| ClassID: | 439. See Overview of ClassIDs by table. |
| Field | Table(Germ.field)/Type | Description | Related |
|---|---|---|---|
| RegistrationID | RegistrationID INT Primary |
||
| ParticipantNumber | ParticipantNumber NVARCHAR (20) Index |
MARITrainingParticipant.ParticipantNumber | |
| GroupParticipantNumber | GroupParticipantNumber NVARCHAR (20) Index |
MARITrainingParticipant.GroupParticipantNumber | |
| WorkItemID | WorkItemID INT Index |
Link to trainings cource | MARIWorkItem.WorkItemID (WHERE WorkItemType=492) |
| Project | Project NVARCHAR (20) Index |
MARIProjectMaster.Project | |
| PhaseID | Phase INT |
MARIProjectPhases.PhaseID | |
| ContractID | ContractID INT |
MARIContract.ContractID | |
| BaseContractID | BaseContractID INT |
Not used | |
| RegistrationStatus | RegistrationStatus INT Index |
MARISupportSettings.RegistrationStatus (WHERE Setting=24) | |
| RegistrationDate | RegistrationDate Datetime |
||
| InvoiceMethod | InvoiceMethod INT |
||
| InvoiceLink | InvoiceLink INT |
||
| CardCode | CardCode NVARCHAR (20) Index |
OCRD.CardCode | |
| Company | Company INT |
MARISysConnections.Company (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) |
MARIUser.CreateUser (WHERE BenutzerTyp=1) | |
| ChangeDate | ChangeDate Datetime |
||
| ChangeUser | ChangeUser NVARCHAR (4) |
MARIUser.ChangeUser (WHERE BenutzerTyp=1) | |
| Notes | Notes NVARCHAR (100) |
||
| VisibilityMode | VisibilityMode INT |
||
| Remark | Remark NTEXT |
||
| UpdateStamp | UpdateStamp INT |
| Table | Description |
|---|---|
| MARITrainingRegistrationContractLink | Training Module: Selection of billable contract positions (Contract from registration) |
| MARITrainingRegistrationPhaseLink | Training Module: Selected options=Phases from the project linked to the training cource |
| MARITrainingRegistrationTeamLink | Training Module: Link to the team |
| MARITrainingRegistrationOptionLink | Training Module: Selectable options (formaly phases) |