Grades

Columns


Name	Type	Description
GradeId [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.
SetId	Long	Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs.
GradeName	String	Denotes the name for grade.
GradeCode	String	Numbers or Characters that uniquely defines a short form for Grade for identification purposes.
ActiveStatus	String	Indicates if a grade is active or inactive.
CreationDate	Datetime	CreationDate of Grades
LastUpdateDate	Datetime	LastUpdateDate of Grades
CategoryCode	String	Extensible Flexfield Category Code

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