Sync App アプリケーションの接続 ページに移動し、接続の追加 パネルで対応するアイコンを選択して、Workday への接続を作成します。Workday アイコンが利用できない場合は、Add More アイコンをクリックしてCData サイトからWorkday コネクタをダウンロードおよびインストールします。

必須プロパティは［設定］タブにリストされています。［Advanced］タブには、通常は必要ない接続プロパティが表示されます。

Workday WQL API への接続

The WQL service must be enabled before connecting:

1. Open Workday and enter View Domain in the search bar. Enter Workday Query Language for the prompt.
2. Check that one of the Allowed Security Group Types includes the user you are connecting to.

The Workday WQL API leverages OAuth for authentication.

It is necessary to create a custom OAuth application to establish a connection.

See カスタムOAuth アプリの作成 to create an OAuth app and obtain the OAuthClientId and OAuthClientSecret, then supply the following to connect.

• OAuthClientId: The Client ID obtained from the View API Client page.
• OAuthClientSecret: The Client Secret obtained from the View API Client page.
• Tenant: The tenant for the account.
• Host: The host for the API URL.
• UseWQL: Set this to true.

To obtain the Host and Tenant properties, log into Workday and search for View API Clients. In the listed values, find the Workday REST API Endpoint. For example: https://wd3-impl-services1.workday.com/ccx/api/v1/mycompany. In this case, Host is https://wd3-impl-services1.workday.com and Tenant is mycompany.

You also have the option of connecting to reports when the UseWQL property is enabled. See データアクセスのファインチューニング for details on how to configure this.

Workday SOAP API への接続

To authenticate, specify the following:

• User: The Workday user account used to authenticate.
• Password: The password used to authenticate the user.
• Tenant: The tenant for the account.
• Host: The host for the API URL.

See above for examples of the tenant and host values.

You also have the option of connecting to reports when UseWQL is enabled. See データアクセスのファインチューニング for details on how to configure this.

データアクセスのファインチューニング

SOAP API

When connecting with UseWQL disabled, the following properties will determine what tables are exposed:

• Service: A comma-separated list of Workday WSDLs to load. Each WSDL contains one schema which exposes multiple tables.
• WSDLURL: The URL to load a Workday WSDLs from. If provided, this will override Service and present WSDLs tables under the Workday schema.
• WSDLVersion: The version of the Workday API to load the WSDLs for. This can be used to request a newer or older version of the Workday data model.

Accessing Reports as a Service

When connecting with the UseWQL property enabled, the Sync App supports reading reports that have been exposed through Workday Reports as a Service (RaaS). Workday does not have a built-in way for the Sync App to determine which reports have been exposed via RaaS, so you must create a custom report to use this feature:

1. Open the Create Custom Report form.
2. Name the report Reports as a Service.
3. Enter Advanced for the report type.
4. Select Enable As Web Service.
5. Clear Optimized for Performance.
6. Enter All Custom Reports for the Data Source.

After the report is created, you need to add a few columns and filters:

1. In Fields
   • For the first column, enter Report Name.
   • Add a second colum and enter Web Service Namespace.
   • Add a third colum and enter Report Owner.
   • Add a fourth colum and enter Brief Description.
2. Make sure all columns have the primary business object as their Business Object. The primary business object has the name Custom Report and should have a box-and-arrow icon beside it. If the icon is an ellipsis (...) instead, then click menu , select Primary Business Object and then Custom Field.
3. Open the Filter tab and create a new filter. Enter Web Service Namespace as the field and is not blank as the Operator.
4. Add a second filter. Enter Current User as the field, in the selection list as the Operator, Value from Another Field as the comparison type, and Authorized Users as the comparison value.
5. Click OK to save the report. If Workday displays any warnings then click OK again to dismiss them.

The final step is to find the URL associated with the report. This URL is used to set the CustomReportURL connection property.

1. Open the newly created report.
2. Click the ellipsis (...) button beside the report title in the upper-left corner of the screen
3. Find the Web Services tab within the pop-up. You may have to scroll down inside the pop-up to see it.
4. Hover over it and select View URLs.
5. Copy the Workday XML link.

Troubleshooting

Invalid Request

While connecting, you may receive an error stating "Invalid Request". This is a server-side Workday error. It often indicates that your user account has not been granted the permissions required to either connect via the API, or to obtain the specific information you have requested.

The tables and columns are retrieved from a publicly available service that requires no authentication, so this error may appear while either testing the connection, or when trying to retrieve data after metadata has been obtained.

The Task Submitted is not Authorized

While connecting, you may receive an error stating "Processing error occurred. The task submitted is not authorized".

This is a server-side error Workday error. This error typically indicates that your Workday account does not have the necessary module activated to access the table or Service you are attempting to connect to.

Ensure the correct module is activated if you receive this error. The Sync App is unable to dynamically determine which modules are available at runtime, but the exposed services can be configured via the Service connection property.

このセクションでは、Workday Sync App の高度な機能を厳選して説明します。

ユーザー定義ビュー

Sync App を使用すると、事前設定されたクエリによって内容が決定されるユーザー定義ビューと呼ばれる仮想テーブルを定義できます。 These views are useful when you cannot directly control queries being issued to the drivers.カスタムビューの作成と設定の概要については、ユーザー定義ビュー を参照してください。

SSL の設定

SSL の設定 を使用して、Sync App が証明書のネゴシエーションをどのように扱うかを調整します。さまざまな証明書形式を選択できます。 詳しくは、接続文字列オプションにあるSSLServerCert プロパティを参照してください。

ファイアウォールとプロキシ

Windows プロキシとHTTP プロキシを含むファイアウォールとプロキシ に合致するようSync App を設定します。トンネル接続を設定することもできます。

ログ

CData ログを調整するために使用可能な設定の概要については、ログ を参照してください。For basic logging, you only need to set two connection properties, but there are numerous features that support more refined logging, where you can select subsets of information to be logged using the LogModules connection property.

SSL 設定のカスタマイズ

デフォルトでは、Sync App はサーバーの証明書をシステムの信頼できる証明書ストアと照合してSSL / TLS のネゴシエーションを試みます。

別の証明書を指定するには、利用可能なフォーマットについてSSLServerCert プロパティを参照してください。

Firewall またはProxy 経由の接続

HTTP プロキシ

Windows のシステムプロキシ経由の接続では、接続プロパティを追加で設定する必要はありません。他のプロキシに接続するには、ProxyAutoDetect をfalse に設定します。

さらにHTTP プロキシへの認証には、ProxyServer とProxyPort に加えてProxyAuthScheme、ProxyUser、およびProxyPassword を設定します。

その他のプロキシ

次のプロパティを設定します。

• プロキシベースのファイヤーウォールを使用するには、FirewallType、FirewallServer、およびFirewallPort を設定します。
• 接続をトンネルするには、FirewallType をTUNNEL に設定します。
• 認証するには、FirewallUser とFirewallPassword を設定します。
• SOCKS プロキシへの認証には、さらにFirewallType をSOCKS5 に設定します。

WQL APIs

When UseWQL is enabled, the Sync App models Workday data sources as views. You can get a complete list of these data sources using the Data Sources standard report in Workday. The Sync App exposes each data source using its WQL Alias which is shown on the View Data Source page. All WQL data sources appear under the REST schema.

The Sync App does not list all the data sources defined within Workday:

1. The Sync App only exposes data sources that are accessible to the user you have authenticated as. For example, a user with only HR roles is able to view data sources containing employee records but not data sources about financial assets.
2. The Sync App does not expose data sources with required filters. The Sync App only supports the effective and entry filters.

Workday data sources can expose hundreds or thousands of columns, which is too high for many tools to handle. UseSplitTables may be used to work around this limtiation by splitting each data source into multiple views with fewer columns.

Reports

When UseWQL is enabled, the Sync App also grants access to reports that are exposed using Reports as a Service (RaaS). These reports are exposed as views within the Reports schema. Accessing these reports requires extra connection setup beyond the basic settings for WQL access. See データアクセスのファインチューニング details on what is required.

Many Workday reports have prompts that affect the output of the report. The Sync App exposes these prompts as input columns that have the _Prompt suffix. Most prompts accept only a single value, but prompts that accept multiple values can be set with IN or equals:

SELECT * FROM [Account Balance Data]
WHERE Company_Prompt IN ('1234567890abcdef', 'f1234567890abcde')
AND Region_Prompt = 'ef1234567890abcd'
AND Include_Managers_Prompt = TRUE
AND Start_Date_Prompt = '2022-01-01'

Other filters may be included with prompts. These do not affect the way Workday generates the report, but the Sync App removes non-matching rows from the response:

SELECT * FROM [Account Balance Data]

/* Prompts */
WHERE Company_Prompt IN ('1234567890abcdef', 'f1234567890abcde')
AND Region_Prompt = 'ef1234567890abcd'
AND Include_Managers_Prompt = TRUE
AND Start_Date_Prompt = '2022-01-01'

/* Other filters */
AND Department = 'Sales and Marketing'
AND Account_Type = 'LIABILITY'

The Sync App considers WQL views as higher priority than report views. If you write a query that does not specify a schema, the Sync App first tries to find a WQL data source with the name of the table. If it cannot find one then it tries to find a report with a title that matches the table name. Though in practice this kind of conflict is unlikely, as WQL data sources and report titles have different naming conventions.

SELECT * FROM [Possible Report Or Data Source]
/* Executed as SELECT * FROM REST.[Possible Report Or Data Source] 
   if there is both a report and WQL data source with this name */

SOAP APIs

The following APIs are only available in the SOAP API. Accessing them requires disabling UseWQL.

Using Absence_Management API

See Absence_Management Data Model for the available entities in the Absence_Management API.

Using Academic_Advising API

See Academic_Advising Data Model for the available entities in the Academic_Advising API.

Using Academic_Foundation API

See Academic_Foundation Data Model for the available entities in the Academic_Foundation API.

Using Admissions API

See Admissions Data Model for the available entities in the Admissions API.

Using Adoption API

See Adoption Data Model for the available entities in the Adoption API.

Using Benefits_Administration API

See Benefits_Administration Data Model for the available entities in the Benefits_Administration API.

Using Campus_Engagement API

See Campus_Engagement Data Model for the available entities in the Campus_Engagement API.

Using Cash_Management API

See Cash_Management Data Model for the available entities in the Cash_Management API.

Using Compensation API

See Compensation Data Model for the available entities in the Compensation API.

Using Compensation_Review API

See Compensation_Review Data Model for the available entities in the Compensation_Review API.

Using Dynamic_Document_Generation API

See Dynamic_Document_Generation Data Model for the available entities in the Dynamic_Document_Generation API.

Using Financial_Aid API

See Financial_Aid Data Model for the available entities in the Financial_Aid API.

Using Financial_Management API

See Financial_Management Data Model for the available entities in the Financial_Management API.

Using Human_Resources API

See Human_Resources Data Model for the available entities in the Human_Resources API.

Using Identity_Management API

See Identity_Management Data Model for the available entities in the Identity_Management API.

Using Integrations API

See Integrations Data Model for the available entities in the Integrations API.

Using Inventory API

See Inventory Data Model for the available entities in the Inventory API.

Using Learning API

See Learning Data Model for the available entities in the Learning API.

Using Payroll API

See Payroll Data Model for the available entities in the Payroll API.

Using Payroll_CAN API

See Payroll_CAN Data Model for the available entities in the Payroll_CAN API.

Using Payroll_GBR API

See Payroll_GBR Data Model for the available entities in the Payroll_GBR API.

Using Payroll_Interface API

See Payroll_Interface Data Model for the available entities in the Payroll_Interface API.

Using Performance_Management API

See Performance_Management Data Model for the available entities in the Performance_Management API.

Using Recruiting API

See Recruiting Data Model for the available entities in the Recruiting API.

Using Resource_Management API

See Resource_Management Data Model for the available entities in the Resource_Management API.

Using Revenue_Management API

See Revenue_Management Data Model for the available entities in the Revenue_Management API.

Using Settlement_Services API

See Settlement_Services Data Model for the available entities in the Settlement_Services API.

Using Staffing API

See Staffing Data Model for the available entities in the Staffing API.

Using Student_Core API

See Student_Core Data Model for the available entities in the Student_Core API.

Using Student_Finance API

See Student_Finance Data Model for the available entities in the Student_Finance API.

Using Student_Recruiting API

See Student_Recruiting Data Model for the available entities in the Student_Recruiting API.

Using Talent API

See Talent Data Model for the available entities in the Talent API.

Using Time_Tracking API

See Time_Tracking Data Model for the available entities in the Time_Tracking API.

Using Workday_Connect API

See Workday_Connect Data Model for the available entities in the Workday_Connect API.

Using Workday_Extensibility API

See Workday_Extensibility Data Model for the available entities in the Workday_Extensibility API.

Using Workforce_Planning API

See Workforce_Planning Data Model for the available entities in the Workforce_Planning API.

Overview

This section describes the Data Model for the AbsenceManagement API.

Views

ビュー are tables that cannot be modified. Typically, read-only data are shown as views.

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。テーブルおよびストアドプロシージャの詳細については、このヘルプドキュメントの該当エントリを参照してください。

Workday Connector for CData Sync ビュー

Name	Description
AbsenceInputs	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
CarryoverOverride	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
OverrideBalances	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
OverrideBalances_Override_Balance_Units_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
TimeOffPlanBalances	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
TimeOffPlanBalances_Time_Off_Plan_Balance_Record	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Absence_Input_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Absence_Input_Reference_Absence_Input_ID	String		Contains a unique identifier for an instance of an object.
Absence_Input_ID	String		Absence Input ID (Used as a Lookup ID to perform an update. If not provided, the web service will add a new instance).
Batch_ID	String		Batch ID is the unique identifier.
Worker_Reference_WID	String		Contains a unique identifier for an instance of an object.
Worker_Reference_Contingent_Worker_ID	String		Contains a unique identifier for an instance of an object.
Worker_Reference_Employee_ID	String		Contains a unique identifier for an instance of an object.
Position_Reference_WID	String		Contains a unique identifier for an instance of an object.
Position_Reference_Position_ID	String		Contains a unique identifier for an instance of an object.
Absence_Component_Reference_WID	String		Contains a unique identifier for an instance of an object.
Absence_Component_Reference_Accrual_Code	String		Contains a unique identifier for an instance of an object.
Absence_Component_Reference_Time_Off_Code	String		Contains a unique identifier for an instance of an object.
Start_Date	Date		Start Date of Start Period.
End_Date	Date		End Date of End Period.
Reference_Date	Date		Reference Date is required for Time Off and Accrual.
Hours	Decimal		Absence Hours.
Adjustment	Bool		Adjustment (1=True, 0=False).
Comment	String		Comment.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Carryover_Override_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Carryover_Override_Reference_Carryover_Override_ID	String		Contains a unique identifier for an instance of an object.
ID	String		Reference ID.
Worker_Reference_WID	String		Contains a unique identifier for an instance of an object.
Worker_Reference_Contingent_Worker_ID	String		Contains a unique identifier for an instance of an object.
Worker_Reference_Employee_ID	String		Contains a unique identifier for an instance of an object.
Absence_Plan_Reference_WID	String		Contains a unique identifier for an instance of an object.
Absence_Plan_Reference_Absence_Plan_ID	String		Contains a unique identifier for an instance of an object.
Absence_Plan_Reference_Workday_Absence_Plan_ID	String		Contains a unique identifier for an instance of an object.
Carryover_Date	Date		Carryover Date.
Position_Reference_WID	String		Contains a unique identifier for an instance of an object.
Position_Reference_Position_ID	String		Contains a unique identifier for an instance of an object.
Carryover_Override_Amount	Decimal		Carryover Limit Override Amount.
Carryover_Expiration_Date	Date		Carryover Expiration Date.
Comments	String		Comments.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Override_Balance_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Override_Balance_Reference_Calculated_and_Override_Balance_Index	String		Contains a unique identifier for an instance of an object.
ID	String		Reference ID.
Batch_ID	String		Batch ID.
Worker_Reference_WID	String		Contains a unique identifier for an instance of an object.
Worker_Reference_Contingent_Worker_ID	String		Contains a unique identifier for an instance of an object.
Worker_Reference_Employee_ID	String		Contains a unique identifier for an instance of an object.
Position_Reference_WID	String		Contains a unique identifier for an instance of an object.
Position_Reference_Position_ID	String		Contains a unique identifier for an instance of an object.
Time_Off_Plan_Reference_WID	String		Contains a unique identifier for an instance of an object.
Time_Off_Plan_Reference_Absence_Plan_ID	String		Contains a unique identifier for an instance of an object.
Time_Off_Plan_Reference_Workday_Absence_Plan_ID	String		Contains a unique identifier for an instance of an object.
Override_Balance_Date	Date		Override Balance Date.
Override_Balance_Units	Decimal		Override Balance Units.
Comments	String		Comments.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
OverrideBalance_Override_Balance_Reference_WID	String	OverrideBalances.Override_Balance_Reference_WID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Carryover_Date	Date		Carryover Date.
Carryover_Expiration_Date	Date		Carryover Expiration Date.
Carryover_Override_Balance_Units	Decimal		Carryover Override Balance Units.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Employee_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Employee_Reference_Contingent_Worker_ID	String		Contains a unique identifier for an instance of an object.
Employee_Reference_Employee_ID	String		Contains a unique identifier for an instance of an object.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
TimeOffPlanBalance_Employee_Reference_WID	String	TimeOffPlanBalances.Employee_Reference_WID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Time_Off_Plan_Reference_WID	String		Contains a unique identifier for an instance of an object.
Time_Off_Plan_Reference_Absence_Plan_ID	String		Contains a unique identifier for an instance of an object.
Time_Off_Plan_Reference_Workday_Absence_Plan_ID	String		Contains a unique identifier for an instance of an object.
Unit_of_Time_Reference_WID	String		Contains a unique identifier for an instance of an object.
Unit_of_Time_Reference_Unit_of_Time_ID	String		Contains a unique identifier for an instance of an object.
Time_Off_Plan_Balance_Position_Record	String		Time Off Plan Balance Position Record.

Overview

This section describes the Data Model for the AcademicAdvising API.

Views

ビュー are tables that cannot be modified. Typically, read-only data are shown as views.

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。テーブルおよびストアドプロシージャの詳細については、このヘルプドキュメントの該当エントリを参照してください。

Workday Connector for CData Sync ビュー

Name	Description
AcademicAdvisingNotes	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicProgressforStudent	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicRequirementOverrides	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicRequirementOverrides_Add_Course_Override_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicRequirementOverrides_Add_Course_to_Eligibility_Rule_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicRequirementOverrides_Adjust_Units_Override_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicRequirementOverrides_Assign_Course_Override_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicRequirementOverrides_Assign_Course_to_Eligibility_Rule_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicRequirementOverrides_Course_Override_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicRequirementsEffectiveDate	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
Advisors	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
CriteriaBasedStudentCohorts	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
EducationTestTransferCreditRules	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
EducationTestTransferCreditRules_Education_Test_Rule_Snapshot_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentCohortMemberships	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentCohorts	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentTransferCreditRules	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentTransferCreditRules_Student_Articulation_Rule_Snapshot_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
TransferCreditReasons	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
ID	String		Reference ID for Get Note data Task.
Student_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Reference_Academic_Person_ID	String		Contains a unique identifier for an instance of an object.
Student_Reference_Student_ID	String		Contains a unique identifier for an instance of an object.
Academic_Record_Reference_WID	String		Contains a unique identifier for an instance of an object.
Academic_Record_Reference_Student_Record_ID	String		Contains a unique identifier for an instance of an object.
Student_Note_Topic_Reference	String		Engagement Conversation Topic Reference.
Student_Note_Type_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Note_Type_Reference_Student_Note_Type_ID	String		Contains a unique identifier for an instance of an object.
Student_Note_Date	Datetime		Student Note Date.
Public	Bool		Public.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Student_Record_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Student_Record_Reference_Student_Record_ID	String		Contains a unique identifier for an instance of an object.
Program_of_Study_Student_Academic_Progress_Data	String		Program of Study Student Academic Progress Data.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Academic_Requirement_Override_Reference_IID	String		Contains a unique identifier for an instance of an object.
Academic_Requirement_Override_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Reference_Academic_Person_ID	String		Contains a unique identifier for an instance of an object.
Student_Reference_Student_ID	String		Contains a unique identifier for an instance of an object.
Academic_Record_Reference_WID	String		Contains a unique identifier for an instance of an object.
Academic_Record_Reference_Student_Record_ID	String		Contains a unique identifier for an instance of an object.
Academic_Requirement_Reference_WID	String		Contains a unique identifier for an instance of an object.
Academic_Requirement_Reference_Academic_Requirement_ID	String		Contains a unique identifier for an instance of an object.
Override_Type_Reference_WID	String		Contains a unique identifier for an instance of an object.
Override_Type_Reference_Academic_Requirement_Override_Type_ID	String		Contains a unique identifier for an instance of an object.
Override_Reason_Reference_WID	String		Contains a unique identifier for an instance of an object.
Override_Reason_Reference_Academic_Requirement_Override_Reason_ID	String		Contains a unique identifier for an instance of an object.
Competency_Reference	String		The competencies for the academic requirement override.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicRequirementOverride_Academic_Requirement_Override_Reference_IID	String	AcademicRequirementOverrides.Academic_Requirement_Override_Reference_IID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Course_To_Add_Reference	String		The course(s) to be added.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicRequirementOverride_Academic_Requirement_Override_Reference_IID	String	AcademicRequirementOverrides.Academic_Requirement_Override_Reference_IID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Student_Eligibility_Rule_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Eligibility_Rule_Reference_Application_Additional_Educational_Interest_Eligibility_Rule_ID	String		Contains a unique identifier for an instance of an object.
Student_Eligibility_Rule_Reference_Eligibility_Rule_ID	String		Contains a unique identifier for an instance of an object.
Student_Eligibility_Rule_Reference_Student_Condition_Rule_ID	String		Contains a unique identifier for an instance of an object.
Add_Course_Override_Data	String		Add Course Override Data.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicRequirementOverride_Academic_Requirement_Override_Reference_IID	String	AcademicRequirementOverrides.Academic_Requirement_Override_Reference_IID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Student_Eligibility_Rule_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Eligibility_Rule_Reference_Application_Additional_Educational_Interest_Eligibility_Rule_ID	String		Contains a unique identifier for an instance of an object.
Student_Eligibility_Rule_Reference_Eligibility_Rule_ID	String		Contains a unique identifier for an instance of an object.
Student_Eligibility_Rule_Reference_Student_Condition_Rule_ID	String		Contains a unique identifier for an instance of an object.
Adjust_Units	Decimal		The units to be adjusted to.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicRequirementOverride_Academic_Requirement_Override_Reference_IID	String	AcademicRequirementOverrides.Academic_Requirement_Override_Reference_IID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Student_Registration_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Registration_Reference_Student_Course_Registration_ID	String		Contains a unique identifier for an instance of an object.
Student_Registration_Reference_Student_Prospect_Record_ID	String		Contains a unique identifier for an instance of an object.
Academic_Progress_Satisfiable_Assignment_Units_Applied	Decimal		The units that should be applied for the academic progress satisfiable.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicRequirementOverride_Academic_Requirement_Override_Reference_IID	String	AcademicRequirementOverrides.Academic_Requirement_Override_Reference_IID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Student_Eligibility_Rule_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Eligibility_Rule_Reference_Application_Additional_Educational_Interest_Eligibility_Rule_ID	String		Contains a unique identifier for an instance of an object.
Student_Eligibility_Rule_Reference_Eligibility_Rule_ID	String		Contains a unique identifier for an instance of an object.
Student_Eligibility_Rule_Reference_Student_Condition_Rule_ID	String		Contains a unique identifier for an instance of an object.
Assign_Course_Override_Data	String		Assign Course Override Data.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicRequirementOverride_Academic_Requirement_Override_Reference_IID	String	AcademicRequirementOverrides.Academic_Requirement_Override_Reference_IID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Course_To_Override_Reference_WID	String		Contains a unique identifier for an instance of an object.
Course_To_Override_Reference_Student_Course_ID	String		Contains a unique identifier for an instance of an object.
Alternate_Course_Sub_Edit_Data	String		Alternate Course Sub Edit Data.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
ID	String		The Reference ID for the Student Program of Study Record.
Requirements_Effective	Date		The Requirements Effective Date for the Student Program of Study Record.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
ID	String		Reference ID.
Academic_Affiliate_Reference_WID	String		Contains a unique identifier for an instance of an object.
Academic_Affiliate_Reference_Academic_Affiliate_ID	String		Contains a unique identifier for an instance of an object.
Student_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Reference_Academic_Person_ID	String		Contains a unique identifier for an instance of an object.
Student_Reference_Student_ID	String		Contains a unique identifier for an instance of an object.
Universal_ID_Reference_WID	String		Contains a unique identifier for an instance of an object.
Universal_ID_Reference_Universal_Identifier_ID	String		Contains a unique identifier for an instance of an object.
Worker_Reference_WID	String		Contains a unique identifier for an instance of an object.
Worker_Reference_Contingent_Worker_ID	String		Contains a unique identifier for an instance of an object.
Worker_Reference_Employee_ID	String		Contains a unique identifier for an instance of an object.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
ID	String		Ref ID for Criteria Based Student Cohort.
Student_Cohort_Name	String		Name for Criteria Based Student Cohort.
Student_Cohort_Type_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Cohort_Type_Reference_Student_Cohort_Types_ID	String		Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_WID	String		Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_Academic_Unit_Hierarchy_ID	String		Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_Academic_Unit_ID	String		Contains a unique identifier for an instance of an object.
Academic_Level_Reference	String		Academic Level Nonsingular Workset.
Evaluate_Security_by_Cohort	Bool		Evaluate Security by Cohort.
Custom_Report_Reference_WID	String		Contains a unique identifier for an instance of an object.
Custom_Report_Reference_Custom_Report_ID	String		Contains a unique identifier for an instance of an object.
Saved_Search_Reference_IID	String		Contains a unique identifier for an instance of an object.
Saved_Search_Reference_WID	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_WID	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_LearningUserName	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_RecruitingUserName	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_StudentUserName	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_SupplierUserName	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_System_Account_ID	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_System_User_ID	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_System_User_OpenID	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_System_User_OpenID_Connect_Internal	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_System_User_OpenID_Internal	String		Contains a unique identifier for an instance of an object.
Run_As_User_Reference_WorkdayUserName	String		Contains a unique identifier for an instance of an object.
Refresh_Membership_Automatically	Bool		Refresh Membership Automatically boolean for Criteria Based Student Cohort.
Ending_Automatic_Refresh_Academic_Period_Reference_WID	String		Contains a unique identifier for an instance of an object.
Ending_Automatic_Refresh_Academic_Period_Reference_Academic_Period_ID	String		Contains a unique identifier for an instance of an object.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Education_Test_Rule_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Education_Test_Rule_Reference_Education_Test_Rule_ID	String		Contains a unique identifier for an instance of an object.
ID	String		ID.
Institution_Academic_Unit_Reference_WID	String		Contains a unique identifier for an instance of an object.
Institution_Academic_Unit_Reference_Academic_Unit_ID	String		Contains a unique identifier for an instance of an object.
Education_Test_Reference_WID	String		Contains a unique identifier for an instance of an object.
Education_Test_Reference_Education_Test_ID	String		Contains a unique identifier for an instance of an object.
Education_Test_Reference_Workday_Education_Test_ID	String		Contains a unique identifier for an instance of an object.
Education_Test_Section_Reference_WID	String		Contains a unique identifier for an instance of an object.
Education_Test_Section_Reference_Education_Test_Section_ID	String		Contains a unique identifier for an instance of an object.
Education_Test_Section_Reference_Workday_Education_Test_Section_ID	String		Contains a unique identifier for an instance of an object.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
EducationTestRule_Education_Test_Rule_Reference_WID	String	EducationTestTransferCreditRules.Education_Test_Rule_Reference_WID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
ID	String		ID.
Effective_Date	Date		Effective Date.
No_Internal_Equivalent	Bool		No Internal Equivalent.
Transfer_Credit_Reason_Reference	String		Transfer Credit Reason Reference.
Education_Test_Rule_Snapshot_Line_Data	String		Education Test Rule Snapshot Line Data.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
ID	String		ID.
Student_Cohort_Assignment_Data	String		Student Cohort Assignment Data.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
ID	String		ID.
Student_Cohort_Name	String		Student Cohort Name.
Student_Cohort_Type_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Cohort_Type_Reference_Student_Cohort_Types_ID	String		Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_WID	String		Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_Academic_Unit_Hierarchy_ID	String		Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_Academic_Unit_ID	String		Contains a unique identifier for an instance of an object.
Academic_Level_Reference	String		Academic Level Nonsingular Workset.
Evaluate_Security_by_Cohort	Bool		Evaluate Security by Cohort.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Student_Articulation_Rule_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Student_Articulation_Rule_Reference_Student_Articulation_Rule_ID	String		Contains a unique identifier for an instance of an object.
ID	String		ID.
Institution_Academic_Unit_Reference_WID	String		Contains a unique identifier for an instance of an object.
Institution_Academic_Unit_Reference_Academic_Unit_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_WID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_CCD_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_CEEB_ATP_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_Federal_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_IPEDS_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_Local_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_OPEID_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_Other_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_State_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_CEEB_ATP_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_Local_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_NCES_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_Other_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_State_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Course_Reference	String		Educational Institution Course Reference.
Preferred_Unit_Type_Reference_WID	String		Contains a unique identifier for an instance of an object.
Preferred_Unit_Type_Reference_Student_Course_Unit_Type_ID	String		Contains a unique identifier for an instance of an object.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
StudentArticulationRule_Student_Articulation_Rule_Reference_WID	String	StudentTransferCreditRules.Student_Articulation_Rule_Reference_WID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
ID	String		ID.
Effective_Date	Date		Effective Date.
No_Internal_Equivalent	Bool		No Internal Equivalent.
Minimum_Unit_Threshold	Decimal		Sets the minimum threshold of units earned from the external courses taken to award credit from the transfer credit rule.
Transfer_Credit_Reason_Reference	String		Transfer Credit Reason Reference.
Student_Articulation_Course_Data	String		Student Articulation Course Data.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Transfer_Credit_Reason_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Transfer_Credit_Reason_Reference_Transfer_Credit_Reason_ID	String		Contains a unique identifier for an instance of an object.
ID	String		ID.
Institution_Academic_Unit_Reference_WID	String		Contains a unique identifier for an instance of an object.
Institution_Academic_Unit_Reference_Academic_Unit_ID	String		Contains a unique identifier for an instance of an object.
Transfer_Credit_Reason_Name	String		Transfer Credit Reason Name.
Transfer_Credit_Reason_Description	String		Transfer Credit Reason Description.

Overview

This section describes the Data Model for the AcademicFoundation API.

Views

ビュー are tables that cannot be modified. Typically, read-only data are shown as views.

ビューは、カラムと疑似カラムで構成されます。ビューは、データを示すという点でテーブルに似ていますが、ビューでは更新はサポートされません。通常、ビューとして表されるエンティティは、読み取り専用のエンティティです。多くの場合、これらのデータはストアドプロシージャを使用することで更新できます（その機能がデータソースに適用できる場合）。

ビューに対しては、通常のテーブルと同じようにクエリを実行でき、このときに返されるデータも同様です。テーブルおよびストアドプロシージャの詳細については、このヘルプドキュメントの該当エントリを参照してください。

Workday Connector for CData Sync ビュー

Name	Description
AcademicContacts	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicContacts_Address_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicContacts_Email_Address_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicContacts_Instant_Messenger_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicContacts_Phone_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicContacts_Web_Address_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AcademicPeriodDateControls	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
AccommodationsforStudent	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
EducationalInstitutionAttendances	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
EducationalInstitutionCourse	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
EducationalInstitutionGradingSchemes	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
EducationalTaxonomySchemes	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
EducationalTaxonomySchemes_Educational_Taxonomy_Code_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
EducationTestResults	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
ExternalAssociations	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
ExternalAssociations_Contact_Information_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
ExtracurricularActivities	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
ExtracurricularActivities_Academic_Unit_Shareable_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
MaintainedAcademicPeriods	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
PrimaryDisabilityforStudents	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
ProgramofStudyExplorationDetails	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
ProgramsofStudy	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
ProgramsofStudy_Addable_Configuration_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
ProspectiveStudents	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentEducationalInstitution	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentEducationalInstitutionDistricts	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentFriendsandFamily	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentGradingSchemes	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentHoldAssignments	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentHoldAssignments_Student_Hold_Assignment_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentHoldAssignments_Student_Hold_Assignment_Override_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentHoldReasons	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentHousingAssignments	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentImmigrationDatas	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentNoteTopics	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentResidencies	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
Students	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
Students_Student_Additional_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
Students_Student_Data	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentTagCategories	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentTags	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
StudentVeteransBenefits	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.
UniversalIdentifiers	Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Academic_Contact_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Academic_Contact_Reference_Academic_Contact_ID	String		Contains a unique identifier for an instance of an object.
ID	String		Academic Contact (also known as Representative) Reference ID.
Has_Academic_Contact_Reference_WID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_CCD_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Postsecondary_CEEB_ATP_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Postsecondary_Federal_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Postsecondary_IPEDS_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Postsecondary_Local_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Postsecondary_OPEID_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Postsecondary_Other_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Postsecondary_State_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Secondary_CEEB_ATP_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Secondary_Local_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Secondary_NCES_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Secondary_Other_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Educational_Institution_Secondary_State_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_External_Association_ID	String		Contains a unique identifier for an instance of an object.
Has_Academic_Contact_Reference_Student_Recruiting_Event_Series_ID	String		Contains a unique identifier for an instance of an object.
Job_Title	String		Academic Contact Job Title.
Country_Reference_WID	String		Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Alpha_2_Code	String		Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Alpha_3_Code	String		Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Numeric_3_Code	String		Contains a unique identifier for an instance of an object.
Title_Reference_WID	String		Contains a unique identifier for an instance of an object.
Title_Reference_Predefined_Name_Component_ID	String		Contains a unique identifier for an instance of an object.
Title_Descriptor	String		The description of the reference to the Title of a person.
Salutation_Reference_WID	String		Contains a unique identifier for an instance of an object.
Salutation_Reference_Predefined_Name_Component_ID	String		Contains a unique identifier for an instance of an object.
Name_Detail_First_Name	String		The First Name (Given Name) for a person.
Name_Detail_Middle_Name	String		The Middle Name for a person.
Name_Detail_Last_Name	String		The Last Name (Family Name) for a person.
Name_Detail_Secondary_Last_Name	String		The Secondary Last Name (Secondary Family Name) for a person.
Tertiary_Last_Name	String		The Tertiary Last Name for a person.
Local_Name_Detail_First_Name	String		Contains First Name in local script, which is generally configured to as Given Name, for supporting Countries.
Local_Name_Detail_Middle_Name	String		Contains Middle Name in local script for supporting Countries.
Local_Name_Detail_Last_Name	String		Contains Last Name in local script, which is generally configured as Family Name, for supporting Countries.
Local_Name_Detail_Secondary_Last_Name	String		Contains Secondary Last Name in local script, which is generally configured as Maternal Family Name, for supporting Countries.
First_Name_2	String		Contains First Name in second local script, which is generally configured as Given Name, for supporting Countries.
Middle_Name_2	String		Contains Middle Name in second local script for supporting Countries.
Last_Name_2	String		Contains Last Name in second local script, which is generally configured as Given Name, for supporting Countries.
Secondary_Last_Name_2	String		Contains Secondary Last Name in second local script, which is generally configured as Maternal Family Name, for supporting Countries.
Social_Suffix_Reference_WID	String		Contains a unique identifier for an instance of an object.
Social_Suffix_Reference_Predefined_Name_Component_ID	String		Contains a unique identifier for an instance of an object.
Social_Suffix_Descriptor	String		A reference to the description of Social Suffix for a person.
Academic_Suffix_Reference_WID	String		Contains a unique identifier for an instance of an object.
Academic_Suffix_Reference_Predefined_Name_Component_ID	String		Contains a unique identifier for an instance of an object.
Hereditary_Suffix_Reference_WID	String		Contains a unique identifier for an instance of an object.
Hereditary_Suffix_Reference_Predefined_Name_Component_ID	String		Contains a unique identifier for an instance of an object.
Honorary_Suffix_Reference_WID	String		Contains a unique identifier for an instance of an object.
Honorary_Suffix_Reference_Predefined_Name_Component_ID	String		Contains a unique identifier for an instance of an object.
Professional_Suffix_Reference_WID	String		Contains a unique identifier for an instance of an object.
Professional_Suffix_Reference_Predefined_Name_Component_ID	String		Contains a unique identifier for an instance of an object.
Religious_Suffix_Reference_WID	String		Contains a unique identifier for an instance of an object.
Religious_Suffix_Reference_Predefined_Name_Component_ID	String		Contains a unique identifier for an instance of an object.
Royal_Suffix_Reference_WID	String		Contains a unique identifier for an instance of an object.
Royal_Suffix_Reference_Predefined_Name_Component_ID	String		Contains a unique identifier for an instance of an object.
Full_Name_for_Singapore_and_Malaysia	String		Full Person Name is used by Malaysia and Singapore. It is designed for Workers in these countries to enter their Full Legal Name. It is an attribute of Global Person Name Class and is not a concatenation of First and Last Names.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicContact_Academic_Contact_Reference_WID	String	AcademicContacts.Academic_Contact_Reference_WID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Country_Reference_WID	String		Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Alpha_2_Code	String		Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Alpha_3_Code	String		Contains a unique identifier for an instance of an object.
Country_Reference_ISO_3166_1_Numeric_3_Code	String		Contains a unique identifier for an instance of an object.
Last_Modified	Datetime		The moment when the address was last modified.
Address_Line_Data	String		The address line for the address. This typically contains street name, street number, apartment, suite number.
Municipality	String		City part of the address.
Country_City_Reference_WID	String		Contains a unique identifier for an instance of an object.
Country_City_Reference_Country_Subregion_Code_In_Country	String		Contains a unique identifier for an instance of an object.
Country_City_Reference_Country_Subregion_Internal_ID	String		Contains a unique identifier for an instance of an object.
Submunicipality_Data	String		The submunicipality of the address.
Country_Region_Reference_WID	String		Contains a unique identifier for an instance of an object.
Country_Region_Reference_Country_Region_ID	String		Contains a unique identifier for an instance of an object.
Country_Region_Reference_ISO_3166_2_Code	String		Contains a unique identifier for an instance of an object.
Country_Region_Descriptor	String		The region part of the address. Typically this contains the state/province information.
Subregion_Data	String		The subregion part of the address.
Postal_Code	String		The postal code part of the address.
Usage_Data	String		Encapsulating element for all Communication Method Usage data.
Number_of_Days	Decimal		Tracks the number of days an employee works from home per week.
Municipality_Local	String		City in local script part of the address.
Address_Reference_WID	String		Contains a unique identifier for an instance of an object.
Address_Reference_Address_ID	String		Contains a unique identifier for an instance of an object.
Address_ID	String		New ID value used in address updates. The ID cannot already be in use by another address.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicContact_Academic_Contact_Reference_WID	String	AcademicContacts.Academic_Contact_Reference_WID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Email_Address	String		Email Address Information.
Email_Comment	String		Email comments.
Usage_Data	String		Encapsulating element for all Communication Method Usage data.
Email_Reference_WID	String		Contains a unique identifier for an instance of an object.
Email_Reference_Email_ID	String		Contains a unique identifier for an instance of an object.
ID	String		New ID value used in email address updates. The ID cannot already be in use by another email address.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicContact_Academic_Contact_Reference_WID	String	AcademicContacts.Academic_Contact_Reference_WID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Instant_Messenger_Address	String		Instant Messenger Address.
Instant_Messenger_Type_Reference_WID	String		Contains a unique identifier for an instance of an object.
Instant_Messenger_Type_Reference_Instant_Messenger_Type_ID	String		Contains a unique identifier for an instance of an object.
Instant_Messenger_Comment	String		Instant messenger comment.
Usage_Data	String		Encapsulating element for all Communication Method Usage data.
Instant_Messenger_Reference_WID	String		Contains a unique identifier for an instance of an object.
Instant_Messenger_Reference_Instant_Messenger_ID	String		Contains a unique identifier for an instance of an object.
ID	String		New ID value used in instant messenger updates. The ID cannot already be in use by another instant messenger.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicContact_Academic_Contact_Reference_WID	String	AcademicContacts.Academic_Contact_Reference_WID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Country_ISO_Code	String		Country ISO code. If the Country ISO code is specified, then this ISO code will be used to determine the Country Phone Code for (eliminate space between f and o) the phone. Pass this ISO code to distinguish between multiple countries sharing the same Country Phone Code. (For example, 1 is the Country Phone Code that is shared by USA, Canada, Dominican Republic, Bermuda, Jamaica, and Puerto Rico.)
International_Phone_Code	String		International phone code number.
Phone_Number	String		Full phone number.
Phone_Extension	String		Phone extension.
Phone_Device_Type_Reference_WID	String		Contains a unique identifier for an instance of an object.
Phone_Device_Type_Reference_Phone_Device_Type_ID	String		Contains a unique identifier for an instance of an object.
Usage_Data	String		Encapsulating element for all Communication Method Usage data.
Phone_Reference_WID	String		Contains a unique identifier for an instance of an object.
Phone_Reference_Phone_ID	String		Contains a unique identifier for an instance of an object.
ID	String		New ID value used in phone updates. The ID cannot already be in use by another phone.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
AcademicContact_Academic_Contact_Reference_WID	String	AcademicContacts.Academic_Contact_Reference_WID	The unique identifier type. Each ID for an instance of an object contains a type and a value. A single instance of an object can have multiple IDs but only a single ID per type.
Web_Address	String		Web address (Example: URL).
Web_Address_Comment	String		Web address comment.
Usage_Data	String		Encapsulating element for all Communication Method Usage data.
Web_Address_Reference_WID	String		Contains a unique identifier for an instance of an object.
Web_Address_Reference_Web_Address_ID	String		Contains a unique identifier for an instance of an object.
ID	String		New ID value used in web address updates. The ID cannot already be in use by another web address.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Academic_Period_ID	String		Reference ID for the Academic Period.
Academic_Unit_Reference_WID	String		Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_Academic_Unit_ID	String		Contains a unique identifier for an instance of an object.
Academic_Level_Reference_WID	String		Contains a unique identifier for an instance of an object.
Academic_Level_Reference_Academic_Level_ID	String		Contains a unique identifier for an instance of an object.
Program_of_Study_Reference_WID	String		Contains a unique identifier for an instance of an object.
Program_of_Study_Reference_Program_of_Study_ID	String		Contains a unique identifier for an instance of an object.
Academic_Period_Date_Control	String		Wrapper element for each Academic Period Control Date.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Student_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Student_Reference_Academic_Person_ID	String		Contains a unique identifier for an instance of an object.
Student_Reference_Student_ID	String		Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_WID	String		Contains a unique identifier for an instance of an object.
Academic_Unit_Reference_Academic_Unit_ID	String		Contains a unique identifier for an instance of an object.
Student_Accommodation_Assignment_Data	String		Student Accommodation Assignment Data.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
ID	String		The ID Attribute for the Educational Institution Attendance WS.
Student_Reference_WID	String		Contains a unique identifier for an instance of an object.
Student_Reference_Academic_Person_ID	String		Contains a unique identifier for an instance of an object.
Student_Reference_Student_ID	String		Contains a unique identifier for an instance of an object.
Universal_ID_Reference_WID	String		Contains a unique identifier for an instance of an object.
Universal_ID_Reference_Universal_Identifier_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_WID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_CCD_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_CEEB_ATP_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_Federal_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_IPEDS_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_Local_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_OPEID_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_Other_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_State_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_CEEB_ATP_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_Local_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_NCES_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_Other_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_State_ID	String		Contains a unique identifier for an instance of an object.
Start_Date	Date		The Start Date for the Educational Institution Attendance WS.
Exit_Date	Date		The Exit Date for the Educational Institution Attendance WS.

Tables are dynamically determined at runtime based on the Version connection property. This table is presented as an example of what is available, but more may be available due to newer API releases.

Columns

Name	Type	References	Description
Educational_Institution_Course_Reference_WID [KEY]	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Course_Reference_Educational_Institution_Course_ID	String		Contains a unique identifier for an instance of an object.
ID	String		Reference ID for the Educational Institution Course.
Educational_Institution_Reference_WID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_CCD_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_CEEB_ATP_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_Federal_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_IPEDS_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_Local_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_OPEID_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_Other_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Postsecondary_State_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_CEEB_ATP_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_Local_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_NCES_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_Other_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Reference_Educational_Institution_Secondary_State_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Course_Number	String		Specifies the Course Number for the Educational Institution Course.
Educational_Institution_Course_Academic_Area_Reference_WID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Course_Academic_Area_Reference_Educational_Institution_Course_Academic_Area_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Course_Title	String		Specifies the Title of the Educational Institution Course.
Educational_Institution_Course_Designations_Reference	String		References the Course Designation for the Educational Institution Course.
Educational_Institution_Course_Credits	Decimal		Specifies the Credits for the Educational Institution Course.
Educational_Institution_Course_Unit_Type_Reference_WID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Course_Unit_Type_Reference_Student_Course_Unit_Type_ID	String		Contains a unique identifier for an instance of an object.
Educational_Institution_Course_Description	String		Specifies the Description for the Educational Institution Course.
Educational_Institution_Course_Notes	String		Specifies the Notes for the Educational Institution Course.