JobFamilies
JobFamilies
Columns
Name | Type | Description |
JobFamilyId [KEY] | Long | System generated primary key column. |
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. |
JobFamilyName | String | Denoted the name for the Job Family. |
JobFamilyCode | String | Denoted the code for the Job Family. |
ActionReasonId | Long | ActionReasonId of JobFamilies |
ActiveStatus | String | Indicates if a job family is active or inactive. |
CreationDate | Datetime | CreationDate of JobFamilies |
LastUpdateDate | Datetime | LastUpdateDate of JobFamilies |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
SysEffectiveDate | String | SysEffectiveDate |
Finder | String | finder |