Workersnames
Workersnames
Columns
| Name | Type | Description |
| WorkersPersonId [KEY] | Long | WorkersPersonId of Workersnames |
| PersonNameId [KEY] | Long | PersonNameId of Workersnames |
| EffectiveStartDate [KEY] | Date | Start date of the date-effective changes to the record. |
| EffectiveEndDate [KEY] | Date | End date of the date-effective changes to the record. |
| LegislationCode | String | Legislation code. Valid values are defined in the hcmCountriesLov. |
| LegislationName | String | LegislationName of Workersnames |
| LastName | String | Person's last name. |
| FirstName | String | Person's first name. |
| Title | String | Person salutation such as Mr., Ms., and so on. Valid values are defined in the commonLookupsLOV. |
| TitleMeaning | String | TitleMeaning of Workersnames |
| PreNameAdjunct | String | Part of the name added before a person's first name. |
| Suffix | String | Part of the name appended to a person's last name such as Jr., III, and so on. |
| MiddleNames | String | Person's middle name. |
| Honors | String | Higher qualification appended to a person's name such as PhD. |
| KnownAs | String | Person's preferred name. |
| PreviousLastName | String | Person's previous last name. |
| DisplayName | String | DisplayName of Workersnames |
| OrderName | String | OrderName of Workersnames |
| ListName | String | ListName of Workersnames |
| FullName | String | FullName of Workersnames |
| MilitaryRank | String | Person's military rank. |
| NameLanguage | String | NameLanguage of Workersnames |
| NameLanguageMeaning | String | NameLanguageMeaning of Workersnames |
| NameInformation1 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation2 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation3 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation4 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation5 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation6 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation7 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation8 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation9 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation10 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation11 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation12 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation13 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation14 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| NameInformation15 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation16 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation17 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation18 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation19 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation20 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation21 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation22 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation23 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation24 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation25 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation26 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation27 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation28 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation29 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| NameInformation30 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| CreatedBy | String | CreatedBy of Workersnames |
| CreationDate | Datetime | CreationDate of Workersnames |
| LastUpdatedBy | String | LastUpdatedBy of Workersnames |
| LastUpdateDate | Datetime | LastUpdateDate of Workersnames |
| LocalPersonNameId [KEY] | Long | Surrogate identifier for the local name record. |
| LocalEffectiveStartDate [KEY] | Date | Start date of the date-effective changes to the record. |
| LocalEffectiveEndDate [KEY] | Date | End date of the date-effective changes to the record. |
| LocalLegislationCode | String | Legislation code of the local language. Valid values are defined in the hcmCountriesLov. |
| LocalLegislationName | String | LocalLegislationName of Workersnames |
| LocalLastName | String | Person's last name in local language. |
| LocalFirstName | String | Person's first name in local language. |
| LocalTitle | String | Person's salutation such as Mr., Ms., and so on in local language. Valid values are defined in the commonLookupsLOV. |
| LocalTitleMeaning | String | LocalTitleMeaning of Workersnames |
| LocalPreNameAdjunct | String | Part of the name added before a person's first name in local language. |
| LocalSuffix | String | Part of the name appended to a person's last name such as Jr., III, and so on, in local language. |
| LocalMiddleNames | String | Person's middle name in local language. |
| LocalHonors | String | Higher qualification appended to a person's name such as PhD in local language. |
| LocalKnownAs | String | Person's preferred name in local language. |
| LocalPreviousLastName | String | Person's previous last name in local language. |
| LocalDisplayName | String | LocalDisplayName of Workersnames |
| LocalOrderName | String | LocalOrderName of Workersnames |
| LocalListName | String | LocalListName of Workersnames |
| LocalFullName | String | LocalFullName of Workersnames |
| LocalMilitaryRank | String | Person's military rank in local language. |
| LocalNameLanguage | String | Local language of the name. This is not required for global names. If you're creating a local name, you must provide the language code. |
| LocalNameLanguageMeaning | String | LocalNameLanguageMeaning of Workersnames |
| LocalNameInformation1 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation2 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation3 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation4 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation5 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation6 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation7 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation8 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation9 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation10 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation11 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation12 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation13 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation14 | String | Additional name attribute reserved for Oracle Development for legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation15 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation16 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation17 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation18 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation19 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation20 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation21 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation22 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation23 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation24 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation25 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation26 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation27 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation28 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation29 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalNameInformation30 | String | Additional name attribute reserved for customer legislation-specific name requirements as defined in the person name style definition. |
| LocalCreatedBy | String | LocalCreatedBy of Workersnames |
| LocalCreationDate | Datetime | LocalCreationDate of Workersnames |
| LocalLastUpdatedBy | String | LocalLastUpdatedBy of Workersnames |
| LocalLastUpdateDate | Datetime | LocalLastUpdateDate of Workersnames |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| AssignmentId | Long | AssignmentId |
| AssignmentName | String | AssignmentName |
| AssignmentNumber | String | AssignmentNumber |
| DirectReportsFlag | String | DirectReportsFlag |
| LineManagerFlag | String | LineManagerFlag |
| PersonId | Long | PersonId |
| PersonNumber | String | PersonNumber |
| PrimaryAssignmentFlag | String | PrimaryAssignmentFlag |
| RelationshipType | String | RelationshipType |
| SysEffectiveDate | String | SysEffectiveDate |
| WorkerType | String | WorkerType |
| Finder | String | finder |
| EffectiveDate | Date | This query parameter is used to fetch resources which are effective dated as of the specified start date. The value of this query parameter is a string having a date in yyyy-MM-dd format. |