RecruitingRepresentativesLOV
RecruitingRepresentativesLOV
Columns
| Name | Type | Description |
| PersonId [KEY] | Long | ID assigned to the person. |
| PersonNumber | String | Number assigned to the person. |
| EffectiveStartDate | Date | Effective start date of the representatives. |
| EffectiveEndDate | Date | Effective end date of the representatives. |
| PersonNameId | Long | ID assigned to the person name. |
| NameEffectiveStartDate | Date | Name effective start date. |
| NameEffectiveEndDate | Date | Name effective end date. |
| DisplayName | String | Name of the list displayed. |
| ListName | String | Name assigned to the list of representatives. |
| EmailAddressId | Long | ID assigned to the email of the representatives. |
| WorkEmailAddress | String | Work email address of the representative. |
| EmailType | String | Type of email of the representatives. |
| ImageId | Long | ID assigned to the image files. |
| ImageOvn | Int | Version number for an Image. |
| AssignmentId | Long | ID of the assignment given to the representatives. |
| AssignmentEffectiveStartDate | Date | Effective start date of the assignment assigned to the representatives. |
| AssignmentEffectiveEndDate | Date | Effective end date of the assignment assigned to the representatives. |
| EffectiveSequence | Int | Effective sequence of the representatives. |
| AssignmentEffectiveLatestChange | String | Latest change implemented in the assignment assigned to the representatives |
| AssignmentNumber | String | Number of the assignment assigned to the representatives. |
| AssignmentType | String | Type of assignment. |
| AssignmentName | String | Name of the assignment assigned to the representatives. |
| AssignmentStatusType | String | Type of assignment status. |
| WorkTermsAssignmentId | Long | ID assigned to the work terms of the assignments assigned to the representatives. |
| PrimaryFlag | Bool | Indicates the primary representative. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CurrentUserAssignmentId | String | CurrentUserAssignmentId |
| CurrentUserPersonId | String | CurrentUserPersonId |
| FilterAttributes | String | FilterAttributes |
| SearchTerms | String | SearchTerms |
| StartsWithFlag | Bool | StartsWithFlag |
| Finder | String | finder |