Empsassignmentsempreps

Columns


Name	Type	Description
EmpsCitizenshipId [KEY]	Long	EmpsCitizenshipId of Empsassignmentsempreps
EmpsDriversLicenseId [KEY]	Long	EmpsDriversLicenseId of Empsassignmentsempreps
EmpsEffectiveStartDate [KEY]	Date	EmpsEffectiveStartDate of Empsassignmentsempreps
EmpsPassportId [KEY]	Long	EmpsPassportId of Empsassignmentsempreps
EmpsPersonId [KEY]	Long	EmpsPersonId of Empsassignmentsempreps
EmpsReligionId [KEY]	Long	EmpsReligionId of Empsassignmentsempreps
AssignmentsAssignmentId [KEY]	Long	AssignmentsAssignmentId of Empsassignmentsempreps
AssignmentsEffectiveEndDate [KEY]	Date	AssignmentsEffectiveEndDate of Empsassignmentsempreps
AssignmentsEffectiveStartDate [KEY]	Date	AssignmentsEffectiveStartDate of Empsassignmentsempreps
AssignmentsTermsEffectiveStartDate [KEY]	Date	AssignmentsTermsEffectiveStartDate of Empsassignmentsempreps
PersonId	Long	PersonId of Empsassignmentsempreps
AssignmentId [KEY]	Long	AssignmentId of Empsassignmentsempreps
ResponsibilityName	String	ResponsibilityName of Empsassignmentsempreps
AsgResponsibilityId [KEY]	Long	AsgResponsibilityId of Empsassignmentsempreps
ResponsibilityTypeCode	String	ResponsibilityTypeCode of Empsassignmentsempreps
ResponsibilityTypeName	String	ResponsibilityTypeName of Empsassignmentsempreps

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