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 |