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