Get all student academic plans
get
/fscmRestApi/resources/11.13.18.05/studentAcademicPlans
Request
Query Parameters
-
effectiveDate: string
This query parameter is used to fetch resources which are effective dated as of the specified start date. The value of this query parameter is a string having a date in yyyy-MM-dd format
-
expand: string
When this parameter is provided, the specified children are included in the resource payload (instead of just a link). The value of this query parameter is "all" or "". More than one child can be specified using comma as a separator. Example: ?expand=Employees,Localizations. Nested children can also be provided following the format "Child.NestedChild" (Example: ?expand=Employees.Managers). If a nested child is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?expand=Employees.Managers" is the same as "?expand=Employees,Employees.Managers" (which will expand Employees and Managers).
-
fields: string
This parameter filters the resource fields. Only the specified fields are returned, which means that if no fields are specified, no fields are returned (useful to get only the links). If an indirect child resource is provided (Example: Employees.Managers), the missing children will be processed implicitly. For example, "?fields=Employees.Managers:Empname" is the same as "?fields=;Employees:;Employees.Managers:Empname" (which will only return the "Empname" field for Managers). the value of this query parameter is a list of resource fields. The attribute can be a direct (Example: Employees) or indirect (Example: Employees.Managers) child. It cannot be combined with expand query parameter. If both are provided, only fields will be considered.
Format: ?fields=Attribute1,Attribute2
Format for fields in child resource: ?fields=Accessor1:Attribute1,Attribute2 -
finder: string
Used as a predefined finder to search the collection.
Format ?finder=<finderName>;<variableName>=<variableValue>,<variableName2>=<variableValue2>
The following are the available finder names and corresponding finder variables- PrimaryKey Finds all student academic plans that match the primary key criteria specified.
Finder Variables- PlanId; integer; Unique identifier for the plan.
- PrimaryKey Finds all student academic plans that match the primary key criteria specified.
-
limit: integer
This parameter restricts the number of resources returned inside the resource collection. If the limit exceeds the resource count then the framework will only return the available resources.
-
links: string
This parameter can be used to show only certain links while accessing a singular resource or a resource collection. The parameter value format is a comma-separated list of : <link_relation>
Example:
self,canonical -
offset: integer
Used to define the starting position of the resource collection. If offset exceeds the resource count then no resources are returned. Default value is 0.
-
onlyData: boolean
The resource item payload will be filtered in order to contain only data (no links section, for example).
-
orderBy: string
This parameter orders a resource collection based on the specified fields. The parameter value is a comma-separated string of attribute names, each optionally followed by a colon and "asc" or "desc". Specify "asc" for ascending and "desc" for descending. The default value is "asc". For example, ?orderBy=field1:asc,field2:desc
-
q: string
This query parameter defines the where clause. The resource collection will be queried using the provided expressions. The value of this query parameter is one or more expressions. Example: ?q=Deptno>=10 and <= 30;Loc!=NY
Format: ?q=expression1;expression2
You can use these queryable attributes to filter this collection resource using the q query parameter:- CommentText; string; The attribute to store student's comments or notes for the academic plan.
- CommentUpdateDateTime; string; Indicates the date and time of the last update of the comment for the student academic plan.
- InstitutionId; integer; Unique identifier for the associated institution.
- InstitutionName; string; The name of the associated institution.
- LastUpdateDate; string; Who column: indicates the date and time of the last update of the row for the student academic plan.
- PlanFormatId; integer; Unique identifier for the associated plan format.
- PlanFormatName; string; The name of the associated plan format.
- PlanId; integer; Unique identifier for a student academic plan.
- PlanName; string; The name of the student academic plan.
- PlanStatusCode; string; The status code of the student academic plan.
- PlanStatusCodeMeaning; string; The status code meaning of the student academic plan.
- PlannedGraduationDate; string; The student planned graduation date.
- TemplateId; integer; Unique identifier for the associated plan template.
- TemplateName; string; The name of the associated plan template.
-
totalResults: boolean
The resource collection representation will include the "estimated row count" when "?totalResults=true", otherwise the count is not included. The default value is "false".
Header Parameters
-
Effective-Of:
This header accepts a string value. The string is a semi-colon separated list of
= . It is used to perform effective date range operations. The accepted parameters are RangeMode, RangeSpan, RangeStartDate, RangeEndDate, RangeStartSequence and RangeEndSequence. The parameter values are always strings. The possible values for RangeMode are SET_LOGICAL_START, SET_LOGICAL_END, END_DATE, SET_EFFECTIVE_START, SET_EFFECTIVE_END, REPLACE_CORRECTION, REPLACE_UPDATE, RECONCILE_CORRECTION, CORRECTION, RECONCILE_UPDATE, UPDATE, ZAP and DELETE_CHANGES. The possible values for RangeSpan are PHYSICAL_ROW_END_DATE and LOGICAL_ROW_END_DATE. The values for RangeStartDate and RangeEndDate have to be a string representation of a date in yyyy-MM-dd format. The value for RangeStartSequence and RangeEndSequence must be strings such that when parsed they yield positive integers. -
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/json
Default Response
The following table describes the default response for this task.
Headers
-
Metadata-Context:
If the REST API supports runtime customizations, the shape of the service may change during runtime. The REST client may isolate itself from these changes or choose to interact with the latest version of the API by specifying this header. For example: Metadata-Context:sandbox="TrackEmployeeFeature".
-
REST-Framework-Version:
The protocol version between a REST client and service. If the client does not specify this header in the request the server will pick a default version for the API.
Root Schema : studentAcademicPlans
Type:
Show Source
object-
count(required): integer
The number of resource instances returned in the current range.
-
hasMore(required): boolean
Indicates whether more resources are available on the server than the subset returned in the response. If the value is true, then there are more resources to retrieve from the server. The default value is false.
-
items: array
Items
Title:
ItemsThe items in the collection. -
limit(required): integer
The actual paging size used by the server.
-
links(required): array
Links
Title:
LinksThe link relations associated with the resource instance. -
offset(required): integer
The offset value used in the current page.
-
totalResults: integer
The estimated row count when "?totalResults=true", otherwise the count is not included.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : studentAcademicPlans-item-response
Type:
Show Source
object-
CommentText: string
Title:
Comment TextThe attribute to store student's comments or notes for the academic plan. -
CommentUpdateDateTime: string
Title:
Comment Update Date TimeRead Only:trueIndicates the date and time of the last update of the comment for the student academic plan. -
conflicts: array
Conflicts
Title:
ConflictsThe conflicts resource is a child of the student academic plans resource and provides a list of conflicts associated with a student academic plan. -
InstitutionId: integer
(int64)
Title:
Institution IDUnique identifier for the associated institution. -
InstitutionName: string
Title:
InstitutionRead Only:trueMaximum Length:50The name of the associated institution. -
items: array
Items
Title:
ItemsThe items resource is a child of the student academic plans resource and provides a list of curriculum items associated with a student academic plan. -
LastUpdateDate: string
(date-time)
Read Only:
trueWho column: indicates the date and time of the last update of the row for the student academic plan. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
periods: array
Periods
Title:
PeriodsThe periods resource is a child of the academic plan templates resource and provides a list of academic periods associated with an academic plan template. -
PlanFormatId: integer
(int64)
Title:
Plan Format IDUnique identifier for the associated plan format. -
PlanFormatName: string
Title:
Format NameRead Only:trueMaximum Length:50The name of the associated plan format. -
PlanId: integer
(int64)
Title:
Academic Plan IDUnique identifier for a student academic plan. -
PlanName: string
Title:
Academic Plan NameMaximum Length:50The name of the student academic plan. -
PlannedGraduationDate: string
(date)
Title:
Planned Graduation DateThe student planned graduation date. -
PlanStatusCode: string
Title:
Academic Plan Status CodeRead Only:trueMaximum Length:30Default Value:ORA_ACTIVEThe status code of the student academic plan. -
PlanStatusCodeMeaning: string
Title:
Plan Status Code MeaningRead Only:trueMaximum Length:80The status code meaning of the student academic plan. -
TemplateId: integer
(int64)
Title:
Plan Template IDUnique identifier for the associated plan template. -
TemplateName: string
Title:
Plan Template NameRead Only:trueMaximum Length:50The name of the associated plan template.
Nested Schema : Conflicts
Type:
arrayTitle:
ConflictsThe conflicts resource is a child of the student academic plans resource and provides a list of conflicts associated with a student academic plan.
Show Source
Nested Schema : Items
Type:
arrayTitle:
ItemsThe items resource is a child of the student academic plans resource and provides a list of curriculum items associated with a student academic plan.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : Periods
Type:
arrayTitle:
PeriodsThe periods resource is a child of the academic plan templates resource and provides a list of academic periods associated with an academic plan template.
Show Source
Nested Schema : studentAcademicPlans-conflicts-item-response
Type:
Show Source
object-
ConflictContextCode: string
Title:
Conflict Context CodeMaximum Length:30The context code of the plan conflict. -
ConflictId: integer
(int64)
Title:
Plan Conflict IDThe unique identifier for the plan conflict. -
ConflictReferenceId: integer
(int64)
Title:
Conflict Reference IDUnique identifier for the source of the edit conflict. -
FifthTokenName: string
Title:
Message Token 5 NameMaximum Length:30The fifth token for the message text. -
FifthTokenValue: string
Title:
Message Token 5 ValueMaximum Length:80The fifth token value for the message text. -
FirstTokenName: string
Title:
Message Token 1 NameMaximum Length:30The first token for the message text. -
FirstTokenValue: string
Title:
Message Token Value 1Maximum Length:80The first token value for the message text. -
FourthTokenName: string
Title:
Message Token 4 NameMaximum Length:30The fourth token for the message text. -
FourthTokenValue: string
Title:
Message Token 4 ValueMaximum Length:80The fourth token value for the message text. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
MessageName: string
Title:
Message NameMaximum Length:30The message identifier for the plan conflict. -
MessageSeverityCode: string
Title:
Message Severity CodeMaximum Length:30The severity code of the conflict message. -
MessageText: string
Title:
Message TextThe stack trace or the text of the conflict message. -
SecondTokenName: string
Title:
Message Token 2 NameMaximum Length:30The second token for the message text. -
SecondTokenValue: string
Title:
Message Token 2 ValueMaximum Length:80The second token value for the message text. -
ThirdTokenName: string
Title:
Message Token 3 NameMaximum Length:30The third token for the message text. -
ThirdTokenValue: string
Title:
Message Token 3 ValueMaximum Length:80The third token value for the message text.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : link
Type:
Show Source
object-
href: string
Title:
hyperlink referenceThe URI to the related resource. -
kind: string
Title:
kindAllowed Values:[ "collection", "item", "describe", "other" ]The kind of the related resource. -
name: string
Title:
nameThe name of the link to the related resource. -
properties: object
properties
-
rel: string
Title:
relationAllowed Values:[ "self", "lov", "parent", "canonical", "child", "enclosure", "action", "custom" ]The name of the relation to the resource instance. Example: self.
Nested Schema : properties
Type:
Show Source
object-
changeIndicator: string
Change indicator or the ETag value of the resource instance.
Nested Schema : studentAcademicPlans-items-item-response
Type:
Show Source
object-
CurriculumId: integer
(int64)
Title:
Curriculum IDUnique identifier for a curriculum item. -
CurriculumName: string
Title:
Curriculum NameRead Only:trueThe name of a curriculum item. -
CurriculumType: string
Title:
Curriculum TypeRead Only:trueMaximum Length:30The curriculum type of the curriculum item. -
CurriculumTypeId: integer
(int64)
Title:
Curriculum Type IDUnique identifier for the type category of a curriculum item. -
ItemId: integer
(int64)
Title:
Planned Item IDUnique identifier for a plan item. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
PlanItemFlag: boolean
Title:
Primary Plan ItemMaximum Length:1Default Value:falseIdentifies the primary curriculum item for the plan. -
ProgramTypeCode: string
Title:
Program Type CodeRead Only:trueMaximum Length:30The program type code indicating the type of program. -
ProgramTypeId: integer
(int64)
Title:
Program Type IDThe unique identifier for a program type that's associated with a program. -
ProgramTypeName: string
Title:
Program TypeRead Only:trueMaximum Length:50The name of a program type that's associated with a program. -
SequenceNumber: integer
(int32)
Title:
Plan Item SequenceUsed to sequence the order of the plan item.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : studentAcademicPlans-periods-item-response
Type:
Show Source
object-
elements: array
Elements
Title:
ElementsThe elements resource is a child of the periods resource and provides a list of curriculum items associated with a student academic plan. -
EndDate: string
(date)
Title:
End DateRead Only:trueThe end date of the period. -
FormatPeriodId: integer
(int64)
Title:
Period IDThe unique identifier for the associated plan format period. -
FormatPeriodName: string
Title:
Period NameRead Only:trueMaximum Length:50The name of the academic plan format period. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LockPeriodFlag: boolean
Title:
Lock PeriodMaximum Length:1Default Value:falseLocks the plan period, indicating the period is required. -
ParentFormatPeriodId: integer
(int64)
Title:
Parent Format Period IDRead Only:trueThe Identifier for the parent format period. -
ParentFormatPeriodName: string
Title:
Parent Format Period NameRead Only:trueMaximum Length:50The name of the parent format period. -
ParentTemplatePeriodId: integer
(int64)
Title:
Parent Template Period IDRead Only:trueThe Identifier for the parent template period. -
ParentTemplatePeriodName: string
Title:
Parent Template Period NameRead Only:trueMaximum Length:50The name of the parent template period. -
PeriodCourseCountQuantity: integer
(int32)
Title:
Period Course CountThe courses planned for the plan period. -
PeriodInstructions: string
Title:
Period InstructionsRead Only:trueThe period instructions that convey academic plan requirements to the student or administrator. -
PeriodSequence: integer
(int32)
Title:
Period Sequence NumberSequence of the plan format period within a level. -
PeriodUnitCountQuantity: number
Title:
Period Unit CountThe units planned for the plan period. -
PlanPeriodId: integer
(int64)
Title:
Plan Period IDThe unique identifier for the plan period. -
ReportingPeriodId: integer
(int64)
Title:
Reporting Period IDUnique identifier for the student academic plan reporting period. -
ReportingPeriodName: string
Title:
Reporting Period NameRead Only:trueMaximum Length:50The name of the reporting period. -
ScheduleEnabledFlag: boolean
Indicates whether the period can be used to create a scheduler.
-
StartDate: string
(date)
Title:
Start DateRead Only:trueThe start date of the period. -
TemplatePeriodId: integer
(int64)
Title:
Template Period IDThe unique identifier for the academic plan template period record. -
TemplatePeriodName: string
Title:
Period NameRead Only:trueMaximum Length:50The name of the academic plan template period.
Nested Schema : Elements
Type:
arrayTitle:
ElementsThe elements resource is a child of the periods resource and provides a list of curriculum items associated with a student academic plan.
Show Source
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Nested Schema : studentAcademicPlans-periods-elements-item-response
Type:
Show Source
object-
ContactHoursQuantity: integer
(int32)
Title:
Contact HoursThe number of contact hours required for the period element. -
DeleteActionFlag: boolean
Title:
Delete ActionIndicates whether the delete action for curriculum course element is active or inactive. -
ElementCurriculumId: integer
(int64)
Title:
Element Curriculum IDThe curriculum item identifier for the curriculum course element. -
ElementCurriculumName: string
Title:
Element Curriculum NameRead Only:trueMaximum Length:50The curriculum item name of the curriculum course element. -
ElementCurriculumType: string
Title:
Element Curriculum TypeRead Only:trueMaximum Length:30The curriculum item type of the curriculum course element. -
ElementCurriculumTypeId: integer
(int64)
Title:
Element Curriculum Type IDRead Only:trueThe curriculum item type identifier for the curriculum course element. -
ElementCurriculumTypeName: string
Title:
Element Curriculum Type NameRead Only:trueMaximum Length:50The curriculum item type name of the curriculum course element. -
ElementSubjectCode: string
Title:
Element Subject CodeRead Only:trueMaximum Length:30The curriculum item subject code of the curriculum course element. -
links: array
Links
Title:
LinksThe link relations associated with the resource instance. -
LockElementFlag: boolean
Title:
Lock ElementMaximum Length:1Default Value:falseLocks the plan template element, preventing changes or removal of the element. -
MinimumRequiredUnitsQuantity: number
Title:
Minimum Required UnitsThe minimum units required for the period element. -
NumberOfUnitsTakenQuantity: number
Title:
Number of Units TakenThe number of units taken for the period element. -
PeriodElementId: integer
(int64)
Title:
Plan Period Element IDThe unique identifier for the plan period element. -
PeriodElementSequence: integer
(int32)
Title:
Period Element SequenceThe sequence of the plan elements within a plan period. - relatedElements: array Related Elements
-
SourceCurriculumId: integer
(int64)
Title:
Source Curriculum IDUnique identifier for the requirement source curriculum item. -
SourceCurriculumName: string
Title:
Source Curriculum NameRead Only:trueMaximum Length:50The curriculum item name of the requirement source curriculum item. -
SourceCurriculumType: string
Title:
Source Curriculum TypeRead Only:trueMaximum Length:30The curriculum item type of the requirement source curriculum item. -
SourceCurriculumTypeId: integer
(int64)
Title:
Source Curriculum Type IDRead Only:trueUnique identifier for the requirement source curriculum type. -
SourceCurriculumTypeName: string
Title:
Source Curriculum Type NameRead Only:trueMaximum Length:50The curriculum item type name of the requirement source curriculum item.
Nested Schema : Links
Type:
arrayTitle:
LinksThe link relations associated with the resource instance.
Show Source
Links
- createFromTemplate
-
Creates a plan from the matching template if it's found. Otherwise, creates the plan based on the academic plan format structure.