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 |