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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。