| Person_Award_Id |
No |
Key Id Field |
"12345" |
|
| Student_Id |
Yes, unless lookup fields are used to identify the student |
Identifier |
"67890" |
Must match an existing Student ID in the system. |
| Student_First_Name |
No, unless Student_Id is not specified |
Lookup |
"John" |
Must match an existing Student first name in the system. |
| Student_Last_Name |
No, unless Student_Id is not specified |
Lookup |
"Doe" |
Must match an existing Student last name in the system. |
| Student_Birthdate |
No, unless Student_Id is not specified |
Lookup |
"2005/07/15" |
Must match an existing Student birthdate in the system. |
| Award_Description |
Yes |
Text |
"Remission" |
|
| Academic_Year |
No |
Datasource Data |
"20232024" |
|
| Award_Grade_Level_Id |
Yes, unless lookup fields are used to identify the award grade level |
Identifier |
"123" |
Must match an existing Award Grade Level ID in the system. |
| Award_Grade_Level_Code |
No, unless Award_Grade_Level_Id is not specified |
Lookup |
"11" |
Must match an existing Award Grade Level Code in the system. |
| Award_Date |
No |
Date |
"2025/01/01" |
|
| Award_Institution |
No |
Text |
"ABC Academy" |
|
| Award_Amount |
No |
Decimal |
"500.00" |
|
| Award_Comment |
No |
Text |
"Excellent performance" |
|
| Award_Accepted |
No |
Boolean |
"1" |
1 = Yes, 0 = No |