EmpsassignmentsassignmentDFF
EmpsassignmentsassignmentDFF
Columns
| Name | Type | Description |
| EmpsCitizenshipId [KEY] | Long | EmpsCitizenshipId of EmpsassignmentsassignmentDFF |
| EmpsDriversLicenseId [KEY] | Long | EmpsDriversLicenseId of EmpsassignmentsassignmentDFF |
| EmpsEffectiveStartDate [KEY] | Date | EmpsEffectiveStartDate of EmpsassignmentsassignmentDFF |
| EmpsPassportId [KEY] | Long | EmpsPassportId of EmpsassignmentsassignmentDFF |
| EmpsPersonId [KEY] | Long | EmpsPersonId of EmpsassignmentsassignmentDFF |
| EmpsReligionId [KEY] | Long | EmpsReligionId of EmpsassignmentsassignmentDFF |
| AssignmentsAssignmentId [KEY] | Long | AssignmentsAssignmentId of EmpsassignmentsassignmentDFF |
| AssignmentsEffectiveEndDate [KEY] | Date | AssignmentsEffectiveEndDate of EmpsassignmentsassignmentDFF |
| AssignmentsEffectiveStartDate [KEY] | Date | AssignmentsEffectiveStartDate of EmpsassignmentsassignmentDFF |
| AssignmentsTermsEffectiveStartDate [KEY] | Date | AssignmentsTermsEffectiveStartDate of EmpsassignmentsassignmentDFF |
| AssignmentId [KEY] | Long | Assignment ID |
| EffectiveStartDate [KEY] | Date | Descriptive flexfield for assignment. |
| EffectiveEndDate [KEY] | Date | Descriptive flexfield for assignment. |
| EffectiveSequence [KEY] | Int | Descriptive flexfield for assignment. |
| EffectiveLatestChange [KEY] | String | Descriptive flexfield for assignment. |
| AssignmentType | String | AssignmentType of EmpsassignmentsassignmentDFF |
| _FLEX_Context | String | Descriptive flexfield for assignment. Valid values are defined in the list LVVO___FLEX_Context. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| BusinessUnitName | String | BusinessUnitName |
| CitizenshipId | Long | CitizenshipId |
| DepartmentName | String | DepartmentName |
| DriversLicenseId | Long | DriversLicenseId |
| GradeName | String | GradeName |
| JobName | String | JobName |
| LocationName | String | LocationName |
| ManagerFullName | String | ManagerFullName |
| PassportId | Long | PassportId |
| PersonId | Long | PersonId |
| ReligionId | Long | ReligionId |
| SysEffectiveDate | String | SysEffectiveDate |
| Finder | String | finder |