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

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