JobsvalidGrades
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. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
JobCode | String | JobCode |
JobId | Long | JobId |
SetId | Long | SetId |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |