...
...
...
Aggregate Resource | Resource |
|---|
...
Property Name |
|---|
...
IsCollection
...
DATA_TYPE
...
ODS REQUIRED/OPTIONAL
...
Is Collection | Data Type | Required / Optional | Scenario 1 | Scenario 2 | Scenario 3 | Scenario 4 |
|---|---|---|---|---|---|---|
ClassPeriods | ClassPeriods | name | FALSE |
...
string | REQUIRED |
...
["Class Period 1" if possible | system value] | ["Class Period 1" if possible | system value] | ["Class Period 01" if possible | system value] | ["Class Period 01" if possible | system value] | |
ClassPeriods | ClassPeriods | schoolReference | FALSE | schoolReference |
...
REQUIRED |
...
...
ClassPeriods | schoolReference | schoolId | FALSE |
...
int32
integer | REQUIRED |
...
| 255901107 | 255901001 | 255901107 |
...
...
| 255901001 |
...
Verification Scripts
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
SchoolId,
ClassPeriodName,
LastModifiedDate,
CreateDate
FROM
edfi.ClassPeriod
WHERE
SchoolId = 255901001
|
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
SchoolId,
ClassPeriodName,
LastModifiedDate,
CreateDate
FROM
edfi.ClassPeriod
WHERE
SchoolId = 255901107
|
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
SchoolId
,ClassPeriodName
,LastModifiedDate
,CreateDate
FROM
edfi.ClassPeriod
WHERE
SchoolId = 255901001 and
ClassPeriodName = 'Class Period 1'
|
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
SchoolId
,ClassPeriodName
,LastModifiedDate
,CreateDate
FROM
edfi.ClassPeriod
WHERE
SchoolId = 255901107 and
ClassPeriodName = 'Class Period 1'
|
| Code Block | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
SELECT
SchoolId
,ClassPeriodName
,LastModifiedDate
,CreateDate
FROM
edfi.ClassPeriod
WHERE
SchoolId = 255901001 and
ClassPeriodName = 'Class Period 01'
|
...
| language | sql |
|---|---|
| title | Verify Put 2 Update Classperiod for GrandBend Elementary School |
| firstline | 1 |
| linenumbers | true |
...