CheckInDocuments

Columns


Name	Type	Description
CheckInDocumentId [KEY]	Long	System-generated primary key for the check-in document.
CheckInTemplateId	Long	System-generated primary key for the check-in template.
CheckInTemplateName	String	Name of the check-in template.
ReviewPeriodId	Long	System-generated primary key of the review period.
ReviewPeriodName	String	Name of the review period.
ManagerPersonId	Long	System-generated primary key of the manager in the check-in document.
ManagerPersonNumber	String	Unique person identifier of the manager.
PersonId	Long	System-generated primary key of the worker in the check-in document.
PersonNumber	String	Unique person identifier of the worker.
AssignmentId	Long	System-generated identifier of the job assignment of the worker.
AssignmentNumber	String	Unique assignment identifier of the worker.
DocumentName	String	Name of the check-in document.
CheckInDate	Date	Date when the check-in document was created.

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