TalentPersonProfilesmembershipSectionsmembershipItems
TalentPersonProfilesmembershipSectionsmembershipItems
Columns
Name | Type | Description |
TalentPersonProfilesProfileId [KEY] | Long | Surrogate identifier for the person profile. |
MembershipsectionsProfileSectionId [KEY] | Long | Surrogate identifier for the membership section. |
MembershipId [KEY] | Long | Identifier of the membership. |
ContentItemId | Long | Unique identifier for the content item. |
Membership | String | Name of the affiliation or professional Body. Valid values are defined in the contentItemsLOV. |
OtherMembership | String | Name of any other affiliation or professional body. |
MembershipStartDate | Date | Date on which the membership starts. |
MembershipEndDate | Date | Date on which the membership ends. |
MembershipNumber | String | Number of the membership. |
TitleOrPositionHeld | String | Title or position held at the membership. |
PositionStartDate | Date | Date on which the position begins. |
PositionEndDate | Date | Date on which the position ends. |
MembershipDate | Date | Date of membership. |
MandatePosition | String | Specifies the mandate position for the membership. |
Fee | Long | Fees for the membership. |
MonthlyTimeCommitment | String | Time committed in a month. |
VolunteerCause | String | Volunteer cause for the membership item. |
Description | String | Description of the membership item. |
Comments | String | Comments of the content item. |
AwardingBody | String | Name of the awarding body. |
SubscriptionPaymentMethod | String | Payment method of the subscription. Valid values are defined in commonLookupsLOV. |
Status | String | Status of the membership. Valid values are defined in the commonLookupsLOV. |
CurrentVolunteer | String | Indicates whether the member is currently a volunteer. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
InternalOrganization | String | Indicates whether the membership is for an internal organization. Valid values are Y and N. Valid values are defined in the commonLookupsLOV. |
EstablishmentId | Long | Unique identifier of the establishment. |
Establishment | String | Name of the educational establishment. Valid values are defined in the contentItemsLOV. |
OtherEstablishment | String | Name of the other educational establishment. |
FeeCurrencyCode | String | Currency of the membership fee. Valid values are defined in the currenciesLOV. |
MembershipCategory | String | Category of the membership. |
OrganizationURL | String | URL related to the membership. |
OtherProfessionalBodyName | String | Name of the other professional body. |
CreatedBy | String | User who created the membership item. |
CreationDate | Datetime | Date and time when the membership item was created. |
LastUpdatedBy | String | User who last updated the membership item. |
LastUpdateDate | Datetime | Date and time when the membership item was last update. |
StatusMeaning | String | Meaning of the status of membership. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
Group | String | Group |
PersonId | Long | PersonId |
ProfileId | Long | ProfileId |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |