JobsvalidGrades

Columns


Name	Type	Description
JobsEffectiveEndDate [KEY]	Date	JobsEffectiveEndDate of JobsvalidGrades
JobsEffectiveStartDate [KEY]	Date	JobsEffectiveStartDate of JobsvalidGrades
JobsJobId [KEY]	Long	JobsJobId of JobsvalidGrades
GradeId	Long	Foreign Key to PER_GRADES_F table.
EffectiveStartDate [KEY]	Date	Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EffectiveEndDate [KEY]	Date	Date Effective Entity: indicates the date at the end of the date range within which the row is effective.

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