Public Member Functions |
Static Public Member Functions |
Public Attributes |
Static Public Attributes |
Protected Member Functions |
Static Protected Attributes |
Properties |
List of all members
Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable Class Reference
Table for short term applications. More...
Inheritance diagram for Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable:
Public Member Functions | |
| PmShortTermApplicationTable () | |
| constructor More... | |
| PmShortTermApplicationTable (string ATablename) | |
| constructor More... | |
| PmShortTermApplicationTable (System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context) | |
| constructor for serialization More... | |
| override void | InitVars () |
| assign columns to properties, set primary key More... | |
| PmShortTermApplicationRow | NewRowTyped (bool AWithDefaultValues) |
| create a new typed row More... | |
| PmShortTermApplicationRow | NewRowTyped () |
| create a new typed row, always with default values More... | |
| PmShortTermApplicationTable | GetChangesTyped () |
| get typed set of changes More... | |
| override OdbcParameter | CreateOdbcParameter (Int32 AColumnNr) |
| get an odbc parameter for the given column More... | |
| new DataTable | GetChanges () |
| make sure that we use GetChangesType instead of GetChanges More... | |
| virtual string | GetCustomReportPermission () |
| string to indicate which permissions a user needs to access table for custom reports (e.g. "PTNRUSER", "OR(FINANCE-1,DEVUSER)", "AND(PTNRUSER,FINANCE-1)" This should be returned by method in derived class More... | |
| virtual bool | IsAvailableForCustomReport () |
| Is this table generally available in custom reports? More... | |
| virtual List< String > | GetCustomReportFieldList () |
| Return a list of fields that are available for custom reports More... | |
| DataTable | GetChangesTypedInternal () |
| our own version of GetChanges More... | |
| void | RemoveColumnsNotInTableTemplate (DataTable ATableTemplate) |
| remove columns that are not needed More... | |
Static Public Member Functions | |
| static string | GetTableName () |
| return the CamelCase name of the table More... | |
| static string | GetTableDBName () |
| return the name of the table as it is used in the database More... | |
| static string | GetTableDBLabel () |
| static method to return the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about) More... | |
| static string | GetPartnerKeyDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetPartnerKeyLength () |
| get character length for column More... | |
| static string | GetPartnerKeyHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetApplicationKeyDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetApplicationKeyLength () |
| get character length for column More... | |
| static string | GetApplicationKeyHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetRegistrationOfficeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetRegistrationOfficeLength () |
| get character length for column More... | |
| static string | GetRegistrationOfficeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStAppDateDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStAppDateLength () |
| get character length for column More... | |
| static string | GetStAppDateHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStApplicationTypeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStApplicationTypeLength () |
| get character length for column More... | |
| static string | GetStApplicationTypeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStBasicOutreachIdDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStBasicOutreachIdLength () |
| get character length for column More... | |
| static string | GetStBasicOutreachIdHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStBasicDeleteFlagDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStBasicDeleteFlagLength () |
| get character length for column More... | |
| static string | GetStBasicDeleteFlagHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStApplicationOnHoldDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStApplicationOnHoldLength () |
| get character length for column More... | |
| static string | GetStApplicationOnHoldHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStApplicationHoldReasonDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStApplicationHoldReasonLength () |
| get character length for column More... | |
| static string | GetStApplicationHoldReasonHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetConfirmedOptionCodeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetConfirmedOptionCodeLength () |
| get character length for column More... | |
| static string | GetConfirmedOptionCodeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStOutreachOnlyFlagDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStOutreachOnlyFlagLength () |
| get character length for column More... | |
| static string | GetStOutreachOnlyFlagHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStConfirmedOptionDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStConfirmedOptionLength () |
| get character length for column More... | |
| static string | GetStConfirmedOptionHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStCurrentFieldDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStCurrentFieldLength () |
| get character length for column More... | |
| static string | GetStCurrentFieldHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetArrivalDetailsStatusDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetArrivalDetailsStatusLength () |
| get character length for column More... | |
| static string | GetArrivalDetailsStatusHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetArrivalPointCodeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetArrivalPointCodeLength () |
| get character length for column More... | |
| static string | GetArrivalPointCodeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetTravelTypeToCongCodeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetTravelTypeToCongCodeLength () |
| get character length for column More... | |
| static string | GetTravelTypeToCongCodeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetArrivalDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetArrivalLength () |
| get character length for column More... | |
| static string | GetArrivalHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetArrivalHourDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetArrivalHourLength () |
| get character length for column More... | |
| static string | GetArrivalHourHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetArrivalMinuteDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetArrivalMinuteLength () |
| get character length for column More... | |
| static string | GetArrivalMinuteHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetToCongTravelInfoDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetToCongTravelInfoLength () |
| get character length for column More... | |
| static string | GetToCongTravelInfoHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetArrivalTransportNeededDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetArrivalTransportNeededLength () |
| get character length for column More... | |
| static string | GetArrivalTransportNeededHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetArrivalCommentsDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetArrivalCommentsLength () |
| get character length for column More... | |
| static string | GetArrivalCommentsHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetDepartureDetailsStatusDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDepartureDetailsStatusLength () |
| get character length for column More... | |
| static string | GetDepartureDetailsStatusHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetDeparturePointCodeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDeparturePointCodeLength () |
| get character length for column More... | |
| static string | GetDeparturePointCodeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetTravelTypeFromCongCodeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetTravelTypeFromCongCodeLength () |
| get character length for column More... | |
| static string | GetTravelTypeFromCongCodeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetDepartureDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDepartureLength () |
| get character length for column More... | |
| static string | GetDepartureHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetDepartureHourDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDepartureHourLength () |
| get character length for column More... | |
| static string | GetDepartureHourHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetDepartureMinuteDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDepartureMinuteLength () |
| get character length for column More... | |
| static string | GetDepartureMinuteHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetFromCongTravelInfoDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetFromCongTravelInfoLength () |
| get character length for column More... | |
| static string | GetFromCongTravelInfoHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetDepartureTransportNeededDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDepartureTransportNeededLength () |
| get character length for column More... | |
| static string | GetDepartureTransportNeededHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetDepartureCommentsDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDepartureCommentsLength () |
| get character length for column More... | |
| static string | GetDepartureCommentsHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetTransportInterestDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetTransportInterestLength () |
| get character length for column More... | |
| static string | GetTransportInterestHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStPreCongressCodeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStPreCongressCodeLength () |
| get character length for column More... | |
| static string | GetStPreCongressCodeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStCongressCodeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStCongressCodeLength () |
| get character length for column More... | |
| static string | GetStCongressCodeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStSpecialApplicantDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStSpecialApplicantLength () |
| get character length for column More... | |
| static string | GetStSpecialApplicantHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetOutreachRoleDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetOutreachRoleLength () |
| get character length for column More... | |
| static string | GetOutreachRoleHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStFgLeaderDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStFgLeaderLength () |
| get character length for column More... | |
| static string | GetStFgLeaderHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStFgCodeDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStFgCodeLength () |
| get character length for column More... | |
| static string | GetStFgCodeHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStOutreachSpecialCostDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStOutreachSpecialCostLength () |
| get character length for column More... | |
| static string | GetStOutreachSpecialCostHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStCngrssSpecialCostDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStCngrssSpecialCostLength () |
| get character length for column More... | |
| static string | GetStCngrssSpecialCostHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStFieldChargedDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStFieldChargedLength () |
| get character length for column More... | |
| static string | GetStFieldChargedHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetStCongressLanguageDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetStCongressLanguageLength () |
| get character length for column More... | |
| static string | GetStCongressLanguageHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetDateCreatedDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDateCreatedLength () |
| get character length for column More... | |
| static string | GetDateCreatedHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetCreatedByDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetCreatedByLength () |
| get character length for column More... | |
| static string | GetCreatedByHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetDateModifiedDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetDateModifiedLength () |
| get character length for column More... | |
| static string | GetDateModifiedHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetModifiedByDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetModifiedByLength () |
| get character length for column More... | |
| static string | GetModifiedByHelp () |
| get the help text for the field in the database for this column More... | |
| static string | GetModificationIdDBName () |
| get the name of the field in the database for this column More... | |
| static short | GetModificationIdLength () |
| get character length for column More... | |
| static string | GetModificationIdHelp () |
| get the help text for the field in the database for this column More... | |
| static OdbcParameter | CreateOdbcParameter (short ATableNumber, TSearchCriteria ASearchCriteria) |
| create an odbc parameter for the given column More... | |
| static OdbcParameter | CreateOdbcParameter (short ATableNumber, Int32 AColumnNr) |
| create an odbc parameter for the given column More... | |
| static void | ResetStaticVariables () |
| reset the static variables for each Web Request call. More... | |
| static string | GetTableNameSQL (short ATableNumber) |
| the table name as it is in the SQL database More... | |
| static string | GetTableName (short ATableNumber) |
| the table name in CamelCase More... | |
| static TTypedTableInfo | GetTableByName (string ATableName) |
| the table name in CamelCase More... | |
| static string | GetColumnNameSQL (short ATableNumber, short AColumnNr) |
| the column name as it is in the SQL database More... | |
| static string | GetLabel (short ATableNumber, short AColumnNr) |
| returns the translated label for the column More... | |
| static Int32 | GetLength (short ATableNumber, short AColumnNr) |
| get the maximum length for the field More... | |
| static Int32 | GetLength (string ATableName, string AColumnName) |
| get the maximum length for the field More... | |
| static string[] | GetKeyColumnStringList (short ATableNumber, int[] AKeyColumnsOrder) |
| get the names of the columns that are part of the key More... | |
| static string[] | GetPrimaryKeyColumnStringList (short ATableNumber) |
| get the names of the columns that are part of the primary key More... | |
| static string[] | GetUniqueKeyColumnStringList (short ATableNumber) |
| get the names of the columns that are part of the unique key More... | |
| static int[] | GetPrimaryKeyColumnOrdList (short ATableNumber) |
| get the order number of the columns that are part of the primary key More... | |
| static int[] | GetUniqueKeyColumnOrdList (short ATableNumber) |
| get the order number of the columns that are part of a unique key More... | |
| static string[] | GetColumnStringList (short ATableNumber) |
| get the names of the columns in this table More... | |
Public Attributes | |
| DataColumn | ColumnPartnerKey |
| This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number. More... | |
| DataColumn | ColumnApplicationKey |
| Key to uniquely identify application. More... | |
| DataColumn | ColumnRegistrationOffice |
| Partner key of office by which application was entered. More... | |
| DataColumn | ColumnStAppDate |
| Date of application. More... | |
| DataColumn | ColumnStApplicationType |
| DataColumn | ColumnStBasicOutreachId |
| TODO: this field is a combination of registration office and application number. might not be needed??? More... | |
| DataColumn | ColumnStBasicDeleteFlag |
| This field will not appear on the screen but will be updated when someone chooses to delete a record. Rather that an actual deletion, the record will be 'marked' for deletion after an agreed upon interval. More... | |
| DataColumn | ColumnStApplicationOnHold |
| Indicates if the application is on hold. More... | |
| DataColumn | ColumnStApplicationHoldReason |
| Comment on why the application is on hold. More... | |
| DataColumn | ColumnConfirmedOptionCode |
| Indicates the outreach code of the confirmed option. More... | |
| DataColumn | ColumnStOutreachOnlyFlag |
| Indicates if for outreach only. More... | |
| DataColumn | ColumnStConfirmedOption |
| Indicates the confirmed outreach option. More... | |
| DataColumn | ColumnStCurrentField |
| Indicates the current field. More... | |
| DataColumn | ColumnArrivalDetailsStatus |
| Indicates the status of given arrival details (not known, being planned,...). More... | |
| DataColumn | ColumnArrivalPointCode |
| This code indicates the arrival point of the congress attendee. More... | |
| DataColumn | ColumnTravelTypeToCongCode |
| This code indicates the type of travel to the congress.. More... | |
| DataColumn | ColumnArrival |
| Date of arrival at the conference. More... | |
| DataColumn | ColumnArrivalHour |
| The hour of arrival. More... | |
| DataColumn | ColumnArrivalMinute |
| The minutes of arrival. More... | |
| DataColumn | ColumnToCongTravelInfo |
| Information concerning flight or bus numbers. More... | |
| DataColumn | ColumnArrivalTransportNeeded |
| Indicates if transport from arrival point to congress needs to be arranged by Registrar. More... | |
| DataColumn | ColumnArrivalComments |
| Gives further comments on arrival information. More... | |
| DataColumn | ColumnDepartureDetailsStatus |
| Indicates the status of given departure details (undetermined, being planned,...). More... | |
| DataColumn | ColumnDeparturePointCode |
| This code indicates the departure point of the congress attendee. More... | |
| DataColumn | ColumnTravelTypeFromCongCode |
| This code indicates the type of travel from the congress. More... | |
| DataColumn | ColumnDeparture |
| Date of departure from the conference. More... | |
| DataColumn | ColumnDepartureHour |
| The hour of departure. More... | |
| DataColumn | ColumnDepartureMinute |
| The minutes of departure. More... | |
| DataColumn | ColumnFromCongTravelInfo |
| Information concerning flight or bus numbers. More... | |
| DataColumn | ColumnDepartureTransportNeeded |
| Indicates if transport from congress to departure point needs to be arranged by Registrar. More... | |
| DataColumn | ColumnDepartureComments |
| Gives further comments on departure information. More... | |
| DataColumn | ColumnTransportInterest |
| Applicant is interested if there would be a transport possibility from/to arrival/departure point. More... | |
| DataColumn | ColumnStPreCongressCode |
| This code indicates what role they have during pre-congress. More... | |
| DataColumn | ColumnStCongressCode |
| Indicates the role for the Congress. More... | |
| DataColumn | ColumnStSpecialApplicant |
| Indicates any special information about the applicant. More... | |
| DataColumn | ColumnOutreachRole |
| The role a participant has during a outreach. More... | |
| DataColumn | ColumnStFgLeader |
| Indicates if the person is a leader of a fellowship group. More... | |
| DataColumn | ColumnStFgCode |
| A free form field for group codes. More... | |
| DataColumn | ColumnStOutreachSpecialCost |
| Special Costs related to the outreach. More... | |
| DataColumn | ColumnStCngrssSpecialCost |
| Special Costs related to the congress. More... | |
| DataColumn | ColumnStFieldCharged |
| This field idenifies the field to be charged for the costs. More... | |
| DataColumn | ColumnStCongressLanguage |
| This is the language spoken by the applicant at the Congress. More... | |
| DataColumn | ColumnDateCreated |
| The date the record was created. More... | |
| DataColumn | ColumnCreatedBy |
| User ID of who created this record. More... | |
| DataColumn | ColumnDateModified |
| The date the record was modified. More... | |
| DataColumn | ColumnModifiedBy |
| User ID of who last modified this record. More... | |
| DataColumn | ColumnModificationId |
| This identifies the current version of the record. More... | |
| bool | ThrowAwayAfterSubmitChanges = false |
| if you want the datatable to be cleared after submitchanges. This will increase the speed significantly: no updating of modificationID, no slow AcceptChanges. More... | |
| bool | DontThrowAwayAfterSubmitChanges = false |
| if you want no warning about that the datatable should be cleared after submitchanges. in some cases you must keep the data, eg when you need the new keys after INSERT More... | |
Static Public Attributes | |
| static readonly short | TableId = 200 |
| TableId for Ict.Common.Data generic functions. More... | |
| static readonly short | ColumnPartnerKeyId = 0 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnApplicationKeyId = 1 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnRegistrationOfficeId = 2 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStAppDateId = 3 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStApplicationTypeId = 4 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStBasicOutreachIdId = 5 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStBasicDeleteFlagId = 6 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStApplicationOnHoldId = 7 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStApplicationHoldReasonId = 8 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnConfirmedOptionCodeId = 9 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStOutreachOnlyFlagId = 10 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStConfirmedOptionId = 11 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStCurrentFieldId = 12 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnArrivalDetailsStatusId = 13 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnArrivalPointCodeId = 14 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnTravelTypeToCongCodeId = 15 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnArrivalId = 16 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnArrivalHourId = 17 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnArrivalMinuteId = 18 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnToCongTravelInfoId = 19 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnArrivalTransportNeededId = 20 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnArrivalCommentsId = 21 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDepartureDetailsStatusId = 22 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDeparturePointCodeId = 23 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnTravelTypeFromCongCodeId = 24 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDepartureId = 25 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDepartureHourId = 26 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDepartureMinuteId = 27 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnFromCongTravelInfoId = 28 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDepartureTransportNeededId = 29 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDepartureCommentsId = 30 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnTransportInterestId = 31 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStPreCongressCodeId = 32 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStCongressCodeId = 33 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStSpecialApplicantId = 34 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnOutreachRoleId = 35 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStFgLeaderId = 36 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStFgCodeId = 37 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStOutreachSpecialCostId = 38 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStCngrssSpecialCostId = 39 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStFieldChargedId = 40 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnStCongressLanguageId = 41 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDateCreatedId = 42 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnCreatedById = 43 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnDateModifiedId = 44 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnModifiedById = 45 |
| used for generic TTypedDataTable functions More... | |
| static readonly short | ColumnModificationIdId = 46 |
| used for generic TTypedDataTable functions More... | |
Protected Member Functions | |
| override void | InitClass () |
| create the columns More... | |
| override System.Data.DataRow | NewRowFromBuilder (System.Data.DataRowBuilder builder) |
| new typed row using DataRowBuilder More... | |
Static Protected Attributes | |
| static SortedList< short, TTypedTableInfo > | TableInfo = new SortedList <short, TTypedTableInfo>() |
| stores information about typed tables More... | |
Properties | |
| PmShortTermApplicationRow | this[int i] [get] |
| Access a typed row by index. More... | |
| override string | TableDBLabel [get] |
| instance property to get the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about) More... | |
| int | Count [get] |
| the number of rows in the current table More... | |
Detailed Description
Table for short term applications.
Constructor & Destructor Documentation
◆ PmShortTermApplicationTable() [1/3]
|
inline |
constructor
◆ PmShortTermApplicationTable() [2/3]
|
inline |
constructor
◆ PmShortTermApplicationTable() [3/3]
|
inline |
constructor for serialization
Member Function Documentation
◆ CreateOdbcParameter() [1/3]
|
inlinevirtual |
get an odbc parameter for the given column
Implements Ict.Common.Data.TTypedDataTable.
◆ CreateOdbcParameter() [2/3]
|
inlinestaticinherited |
create an odbc parameter for the given column
◆ CreateOdbcParameter() [3/3]
|
inlinestaticinherited |
create an odbc parameter for the given column
◆ GetApplicationKeyDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetApplicationKeyHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetApplicationKeyLength()
|
inlinestatic |
get character length for column
◆ GetArrivalCommentsDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetArrivalCommentsHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetArrivalCommentsLength()
|
inlinestatic |
get character length for column
◆ GetArrivalDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetArrivalDetailsStatusDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetArrivalDetailsStatusHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetArrivalDetailsStatusLength()
|
inlinestatic |
get character length for column
◆ GetArrivalHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetArrivalHourDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetArrivalHourHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetArrivalHourLength()
|
inlinestatic |
get character length for column
◆ GetArrivalLength()
|
inlinestatic |
get character length for column
◆ GetArrivalMinuteDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetArrivalMinuteHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetArrivalMinuteLength()
|
inlinestatic |
get character length for column
◆ GetArrivalPointCodeDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetArrivalPointCodeHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetArrivalPointCodeLength()
|
inlinestatic |
get character length for column
◆ GetArrivalTransportNeededDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetArrivalTransportNeededHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetArrivalTransportNeededLength()
|
inlinestatic |
get character length for column
◆ GetChanges()
|
inlineinherited |
make sure that we use GetChangesType instead of GetChanges
- Returns
- throws an exception
◆ GetChangesTyped()
|
inline |
get typed set of changes
◆ GetChangesTypedInternal()
|
inlineinherited |
our own version of GetChanges
- Returns
- returns a typed table with the changes
◆ GetColumnNameSQL()
|
inlinestaticinherited |
the column name as it is in the SQL database
◆ GetColumnStringList()
|
inlinestaticinherited |
get the names of the columns in this table
◆ GetConfirmedOptionCodeDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetConfirmedOptionCodeHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetConfirmedOptionCodeLength()
|
inlinestatic |
get character length for column
◆ GetCreatedByDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetCreatedByHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetCreatedByLength()
|
inlinestatic |
get character length for column
◆ GetCustomReportFieldList()
|
inlinevirtualinherited |
Return a list of fields that are available for custom reports
◆ GetCustomReportPermission()
|
inlinevirtualinherited |
string to indicate which permissions a user needs to access table for custom reports (e.g. "PTNRUSER", "OR(FINANCE-1,DEVUSER)", "AND(PTNRUSER,FINANCE-1)" This should be returned by method in derived class
◆ GetDateCreatedDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetDateCreatedHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetDateCreatedLength()
|
inlinestatic |
get character length for column
◆ GetDateModifiedDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetDateModifiedHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetDateModifiedLength()
|
inlinestatic |
get character length for column
◆ GetDepartureCommentsDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetDepartureCommentsHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetDepartureCommentsLength()
|
inlinestatic |
get character length for column
◆ GetDepartureDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetDepartureDetailsStatusDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetDepartureDetailsStatusHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetDepartureDetailsStatusLength()
|
inlinestatic |
get character length for column
◆ GetDepartureHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetDepartureHourDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetDepartureHourHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetDepartureHourLength()
|
inlinestatic |
get character length for column
◆ GetDepartureLength()
|
inlinestatic |
get character length for column
◆ GetDepartureMinuteDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetDepartureMinuteHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetDepartureMinuteLength()
|
inlinestatic |
get character length for column
◆ GetDeparturePointCodeDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetDeparturePointCodeHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetDeparturePointCodeLength()
|
inlinestatic |
get character length for column
◆ GetDepartureTransportNeededDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetDepartureTransportNeededHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetDepartureTransportNeededLength()
|
inlinestatic |
get character length for column
◆ GetFromCongTravelInfoDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetFromCongTravelInfoHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetFromCongTravelInfoLength()
|
inlinestatic |
get character length for column
◆ GetKeyColumnStringList()
|
inlinestaticinherited |
get the names of the columns that are part of the key
◆ GetLabel()
|
inlinestaticinherited |
returns the translated label for the column
◆ GetLength() [1/2]
|
inlinestaticinherited |
get the maximum length for the field
◆ GetLength() [2/2]
|
inlinestaticinherited |
get the maximum length for the field
◆ GetModificationIdDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetModificationIdHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetModificationIdLength()
|
inlinestatic |
get character length for column
◆ GetModifiedByDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetModifiedByHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetModifiedByLength()
|
inlinestatic |
get character length for column
◆ GetOutreachRoleDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetOutreachRoleHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetOutreachRoleLength()
|
inlinestatic |
get character length for column
◆ GetPartnerKeyDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetPartnerKeyHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetPartnerKeyLength()
|
inlinestatic |
get character length for column
◆ GetPrimaryKeyColumnOrdList()
|
inlinestaticinherited |
get the order number of the columns that are part of the primary key
◆ GetPrimaryKeyColumnStringList()
|
inlinestaticinherited |
get the names of the columns that are part of the primary key
◆ GetRegistrationOfficeDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetRegistrationOfficeHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetRegistrationOfficeLength()
|
inlinestatic |
get character length for column
◆ GetStAppDateDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStAppDateHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStAppDateLength()
|
inlinestatic |
get character length for column
◆ GetStApplicationHoldReasonDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStApplicationHoldReasonHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStApplicationHoldReasonLength()
|
inlinestatic |
get character length for column
◆ GetStApplicationOnHoldDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStApplicationOnHoldHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStApplicationOnHoldLength()
|
inlinestatic |
get character length for column
◆ GetStApplicationTypeDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStApplicationTypeHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStApplicationTypeLength()
|
inlinestatic |
get character length for column
◆ GetStBasicDeleteFlagDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStBasicDeleteFlagHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStBasicDeleteFlagLength()
|
inlinestatic |
get character length for column
◆ GetStBasicOutreachIdDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStBasicOutreachIdHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStBasicOutreachIdLength()
|
inlinestatic |
get character length for column
◆ GetStCngrssSpecialCostDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStCngrssSpecialCostHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStCngrssSpecialCostLength()
|
inlinestatic |
get character length for column
◆ GetStConfirmedOptionDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStConfirmedOptionHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStConfirmedOptionLength()
|
inlinestatic |
get character length for column
◆ GetStCongressCodeDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStCongressCodeHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStCongressCodeLength()
|
inlinestatic |
get character length for column
◆ GetStCongressLanguageDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStCongressLanguageHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStCongressLanguageLength()
|
inlinestatic |
get character length for column
◆ GetStCurrentFieldDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStCurrentFieldHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStCurrentFieldLength()
|
inlinestatic |
get character length for column
◆ GetStFgCodeDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStFgCodeHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStFgCodeLength()
|
inlinestatic |
get character length for column
◆ GetStFgLeaderDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStFgLeaderHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStFgLeaderLength()
|
inlinestatic |
get character length for column
◆ GetStFieldChargedDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStFieldChargedHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStFieldChargedLength()
|
inlinestatic |
get character length for column
◆ GetStOutreachOnlyFlagDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStOutreachOnlyFlagHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStOutreachOnlyFlagLength()
|
inlinestatic |
get character length for column
◆ GetStOutreachSpecialCostDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStOutreachSpecialCostHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStOutreachSpecialCostLength()
|
inlinestatic |
get character length for column
◆ GetStPreCongressCodeDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStPreCongressCodeHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStPreCongressCodeLength()
|
inlinestatic |
get character length for column
◆ GetStSpecialApplicantDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetStSpecialApplicantHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetStSpecialApplicantLength()
|
inlinestatic |
get character length for column
◆ GetTableByName()
|
inlinestaticinherited |
the table name in CamelCase
◆ GetTableDBLabel()
|
inlinestatic |
static method to return the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about)
◆ GetTableDBName()
|
inlinestatic |
return the name of the table as it is used in the database
◆ GetTableName() [1/2]
|
inlinestatic |
return the CamelCase name of the table
◆ GetTableName() [2/2]
|
inlinestaticinherited |
the table name in CamelCase
◆ GetTableNameSQL()
|
inlinestaticinherited |
the table name as it is in the SQL database
◆ GetToCongTravelInfoDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetToCongTravelInfoHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetToCongTravelInfoLength()
|
inlinestatic |
get character length for column
◆ GetTransportInterestDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetTransportInterestHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetTransportInterestLength()
|
inlinestatic |
get character length for column
◆ GetTravelTypeFromCongCodeDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetTravelTypeFromCongCodeHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetTravelTypeFromCongCodeLength()
|
inlinestatic |
get character length for column
◆ GetTravelTypeToCongCodeDBName()
|
inlinestatic |
get the name of the field in the database for this column
◆ GetTravelTypeToCongCodeHelp()
|
inlinestatic |
get the help text for the field in the database for this column
◆ GetTravelTypeToCongCodeLength()
|
inlinestatic |
get character length for column
◆ GetUniqueKeyColumnOrdList()
|
inlinestaticinherited |
get the order number of the columns that are part of a unique key
◆ GetUniqueKeyColumnStringList()
|
inlinestaticinherited |
get the names of the columns that are part of the unique key
◆ InitClass()
|
inlineprotectedvirtual |
create the columns
Implements Ict.Common.Data.TTypedDataTable.
◆ InitVars()
|
inlinevirtual |
assign columns to properties, set primary key
Implements Ict.Common.Data.TTypedDataTable.
◆ IsAvailableForCustomReport()
|
inlinevirtualinherited |
Is this table generally available in custom reports?
◆ NewRowFromBuilder()
|
inlineprotected |
new typed row using DataRowBuilder
◆ NewRowTyped() [1/2]
|
inline |
create a new typed row, always with default values
◆ NewRowTyped() [2/2]
|
inline |
create a new typed row
◆ RemoveColumnsNotInTableTemplate()
|
inlineinherited |
remove columns that are not needed
- Parameters
-
ATableTemplate this table only contains the columns that should be kept
◆ ResetStaticVariables()
|
inlinestaticinherited |
reset the static variables for each Web Request call.
Member Data Documentation
◆ ColumnApplicationKey
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnApplicationKey |
Key to uniquely identify application.
◆ ColumnApplicationKeyId
|
static |
used for generic TTypedDataTable functions
◆ ColumnArrival
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnArrival |
Date of arrival at the conference.
◆ ColumnArrivalComments
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnArrivalComments |
Gives further comments on arrival information.
◆ ColumnArrivalCommentsId
|
static |
used for generic TTypedDataTable functions
◆ ColumnArrivalDetailsStatus
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnArrivalDetailsStatus |
Indicates the status of given arrival details (not known, being planned,...).
◆ ColumnArrivalDetailsStatusId
|
static |
used for generic TTypedDataTable functions
◆ ColumnArrivalHour
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnArrivalHour |
The hour of arrival.
◆ ColumnArrivalHourId
|
static |
used for generic TTypedDataTable functions
◆ ColumnArrivalId
|
static |
used for generic TTypedDataTable functions
◆ ColumnArrivalMinute
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnArrivalMinute |
The minutes of arrival.
◆ ColumnArrivalMinuteId
|
static |
used for generic TTypedDataTable functions
◆ ColumnArrivalPointCode
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnArrivalPointCode |
This code indicates the arrival point of the congress attendee.
◆ ColumnArrivalPointCodeId
|
static |
used for generic TTypedDataTable functions
◆ ColumnArrivalTransportNeeded
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnArrivalTransportNeeded |
Indicates if transport from arrival point to congress needs to be arranged by Registrar.
◆ ColumnArrivalTransportNeededId
|
static |
used for generic TTypedDataTable functions
◆ ColumnConfirmedOptionCode
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnConfirmedOptionCode |
Indicates the outreach code of the confirmed option.
◆ ColumnConfirmedOptionCodeId
|
static |
used for generic TTypedDataTable functions
◆ ColumnCreatedBy
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnCreatedBy |
User ID of who created this record.
◆ ColumnCreatedById
|
static |
used for generic TTypedDataTable functions
◆ ColumnDateCreated
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnDateCreated |
The date the record was created.
◆ ColumnDateCreatedId
|
static |
used for generic TTypedDataTable functions
◆ ColumnDateModified
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnDateModified |
The date the record was modified.
◆ ColumnDateModifiedId
|
static |
used for generic TTypedDataTable functions
◆ ColumnDeparture
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnDeparture |
Date of departure from the conference.
◆ ColumnDepartureComments
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnDepartureComments |
Gives further comments on departure information.
◆ ColumnDepartureCommentsId
|
static |
used for generic TTypedDataTable functions
◆ ColumnDepartureDetailsStatus
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnDepartureDetailsStatus |
Indicates the status of given departure details (undetermined, being planned,...).
◆ ColumnDepartureDetailsStatusId
|
static |
used for generic TTypedDataTable functions
◆ ColumnDepartureHour
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnDepartureHour |
The hour of departure.
◆ ColumnDepartureHourId
|
static |
used for generic TTypedDataTable functions
◆ ColumnDepartureId
|
static |
used for generic TTypedDataTable functions
◆ ColumnDepartureMinute
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnDepartureMinute |
The minutes of departure.
◆ ColumnDepartureMinuteId
|
static |
used for generic TTypedDataTable functions
◆ ColumnDeparturePointCode
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnDeparturePointCode |
This code indicates the departure point of the congress attendee.
◆ ColumnDeparturePointCodeId
|
static |
used for generic TTypedDataTable functions
◆ ColumnDepartureTransportNeeded
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnDepartureTransportNeeded |
Indicates if transport from congress to departure point needs to be arranged by Registrar.
◆ ColumnDepartureTransportNeededId
|
static |
used for generic TTypedDataTable functions
◆ ColumnFromCongTravelInfo
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnFromCongTravelInfo |
Information concerning flight or bus numbers.
◆ ColumnFromCongTravelInfoId
|
static |
used for generic TTypedDataTable functions
◆ ColumnModificationId
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnModificationId |
This identifies the current version of the record.
◆ ColumnModificationIdId
|
static |
used for generic TTypedDataTable functions
◆ ColumnModifiedBy
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnModifiedBy |
User ID of who last modified this record.
◆ ColumnModifiedById
|
static |
used for generic TTypedDataTable functions
◆ ColumnOutreachRole
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnOutreachRole |
The role a participant has during a outreach.
◆ ColumnOutreachRoleId
|
static |
used for generic TTypedDataTable functions
◆ ColumnPartnerKey
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnPartnerKey |
This is the partner key assigned to each partner. It consists of the fund id followed by a computer generated six digit number.
◆ ColumnPartnerKeyId
|
static |
used for generic TTypedDataTable functions
◆ ColumnRegistrationOffice
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnRegistrationOffice |
Partner key of office by which application was entered.
◆ ColumnRegistrationOfficeId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStAppDate
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStAppDate |
Date of application.
◆ ColumnStAppDateId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStApplicationHoldReason
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStApplicationHoldReason |
Comment on why the application is on hold.
◆ ColumnStApplicationHoldReasonId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStApplicationOnHold
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStApplicationOnHold |
Indicates if the application is on hold.
◆ ColumnStApplicationOnHoldId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStApplicationType
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStApplicationType |
◆ ColumnStApplicationTypeId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStBasicDeleteFlag
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStBasicDeleteFlag |
This field will not appear on the screen but will be updated when someone chooses to delete a record. Rather that an actual deletion, the record will be 'marked' for deletion after an agreed upon interval.
◆ ColumnStBasicDeleteFlagId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStBasicOutreachId
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStBasicOutreachId |
TODO: this field is a combination of registration office and application number. might not be needed???
◆ ColumnStBasicOutreachIdId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStCngrssSpecialCost
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStCngrssSpecialCost |
Special Costs related to the congress.
◆ ColumnStCngrssSpecialCostId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStConfirmedOption
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStConfirmedOption |
Indicates the confirmed outreach option.
◆ ColumnStConfirmedOptionId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStCongressCode
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStCongressCode |
Indicates the role for the Congress.
◆ ColumnStCongressCodeId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStCongressLanguage
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStCongressLanguage |
This is the language spoken by the applicant at the Congress.
◆ ColumnStCongressLanguageId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStCurrentField
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStCurrentField |
Indicates the current field.
◆ ColumnStCurrentFieldId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStFgCode
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStFgCode |
A free form field for group codes.
◆ ColumnStFgCodeId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStFgLeader
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStFgLeader |
Indicates if the person is a leader of a fellowship group.
◆ ColumnStFgLeaderId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStFieldCharged
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStFieldCharged |
This field idenifies the field to be charged for the costs.
◆ ColumnStFieldChargedId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStOutreachOnlyFlag
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStOutreachOnlyFlag |
Indicates if for outreach only.
◆ ColumnStOutreachOnlyFlagId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStOutreachSpecialCost
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStOutreachSpecialCost |
Special Costs related to the outreach.
◆ ColumnStOutreachSpecialCostId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStPreCongressCode
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStPreCongressCode |
This code indicates what role they have during pre-congress.
◆ ColumnStPreCongressCodeId
|
static |
used for generic TTypedDataTable functions
◆ ColumnStSpecialApplicant
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnStSpecialApplicant |
Indicates any special information about the applicant.
◆ ColumnStSpecialApplicantId
|
static |
used for generic TTypedDataTable functions
◆ ColumnToCongTravelInfo
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnToCongTravelInfo |
Information concerning flight or bus numbers.
◆ ColumnToCongTravelInfoId
|
static |
used for generic TTypedDataTable functions
◆ ColumnTransportInterest
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnTransportInterest |
Applicant is interested if there would be a transport possibility from/to arrival/departure point.
◆ ColumnTransportInterestId
|
static |
used for generic TTypedDataTable functions
◆ ColumnTravelTypeFromCongCode
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnTravelTypeFromCongCode |
This code indicates the type of travel from the congress.
◆ ColumnTravelTypeFromCongCodeId
|
static |
used for generic TTypedDataTable functions
◆ ColumnTravelTypeToCongCode
| DataColumn Ict.Petra.Shared.MPersonnel.Personnel.Data.PmShortTermApplicationTable.ColumnTravelTypeToCongCode |
This code indicates the type of travel to the congress..
◆ ColumnTravelTypeToCongCodeId
|
static |
used for generic TTypedDataTable functions
◆ DontThrowAwayAfterSubmitChanges
|
inherited |
if you want no warning about that the datatable should be cleared after submitchanges. in some cases you must keep the data, eg when you need the new keys after INSERT
◆ TableId
|
static |
TableId for Ict.Common.Data generic functions.
◆ TableInfo
|
staticprotectedinherited |
stores information about typed tables
◆ ThrowAwayAfterSubmitChanges
|
inherited |
if you want the datatable to be cleared after submitchanges. This will increase the speed significantly: no updating of modificationID, no slow AcceptChanges.
Property Documentation
◆ Count
|
getinherited |
the number of rows in the current table
◆ TableDBLabel
|
get |
instance property to get the 'Label' of the table as it is used in the database (the 'Label' is usually a short description of what the db table is about)
◆ this[int i]
|
get |
Access a typed row by index.
The documentation for this class was generated from the following file:
- csharp/ICT/Petra/Shared/lib/data/Personnel.Tables-generated.cs
