Loading External ATP Data

Understanding ATP Data Load

Use File Parser to load ATP secondary school data into the ATP suspense tables.

The ATP Load External Data process (CCATPLOD.SQR) is deprecated.

The File Parser setup supports the 2024 secondary school file format. If the source file format changes, you can copy and modify the File Parser definitions to meet your institution's requirements. If you load college data, create and maintain File Parser definitions based on the file format provided to your institution.

The ATP suspense tables hold records that have not yet been posted to the organization tables. School data from these tables migrates to your database during posting based on the options that you select on the ATP Search Parameters and ATP Post Parameters pages.

You can review data in the ATP suspense tables after loading it, after performing Search/Match, or after posting it. You can determine whether a record is waiting to be processed, whether a record was added or updated, and whether errors were encountered.

The updated secondary school file supports school names and address values that can be longer than the corresponding Campus Solutions fields. The File Parser mapping loads the characters that fit in the target ATP suspense fields. The full school name, up to 50 characters, is loaded into the Description field and is also used to calculate the Search Name.

After loading the ATP data, run the ATP Search/Match process to check for matching organization records before posting the data. Each ATP suspense record has a Change Code value of Add, Change, or Delete. Add creates a new organization record, Change updates an existing organization, and Delete causes the existing organization to be made inactive during posting.

After reviewing the ATP data and selecting the Search/Match parameters, run the ATP Search/Match/Post process to post the data. You can process and post a single record or all eligible records in the suspense tables.

You can remove records from the ATP suspense tables by running the ATP Purge Suspense File process.

Pages Used to Load External ATP Data

Page Name	Definition Name	Navigation	Usage
ATP Load External Data	ATP_LOAD_PARMS	Campus Community, and then Organization, and then Organizations Data Load, and then ATP Load External Data	(Deprecated) Specify the source from which the load process should get the ATP data.
Field Conversion Definition	SCCFP_CNVR	Set Up SACR, and then System Administration, and then Utilities, and then File Parser, and then Field Conversion Definition	Review or copy the delivered ATP Organization Load field conversion definition.
Context Definition	SCCFP_CNTXT_DFN	Set Up SACR, and then System Administration, and then Utilities, and then File Parser, and then Context Definition	Review or copy the delivered ATP Schools context definition.
File Definition	SCCFP_FILE_DFN	Set Up SACR, and then System Administration, and then Utilities, and then File Parser, and then File Mapping Definition	Review or copy the delivered ATP SCHOOLS file mapping definition.
Run File Parser	SCCFP_RUNCNTL	Set Up SACR, and then System Administration, and then Utilities, and then File Parser, and then Run File Parser	Load ATP school data into the ATP suspense tables.
ATP Suspense Process Options	ATP_SUSP_PROC_OPTN	Campus Community, and then Organization, and then Organizations Data Load, and then ATP Suspense, and then ATP Suspense Process Options	Review and edit the status of data in the ATP Suspense Table.
ATP Suspense Address Data	ATP_SUSP_ADDRESS	Campus Community, and then Organization, and then Organizations Data Load, and then ATP Suspense, and then ATP Suspense Address Data	Review address information loaded for a specific school.
ATP Suspense Data	ATP_SUSP_DATA	Campus Community, and then Organization, and then Organizations Data Load, and then ATP Suspense, and then ATP Suspense Data	Review data other than address data for the school record loaded.
ATP Messages	ATP_SUSP_MESSAGE	Campus Community, and then Organization, and then Organizations Data Load, and then ATP Suspense, and then ATP Messages	Review and resolve ATP suspense messages.
ATP Messages	ATP_MESSAG_TABLE	Campus Community, and then Organization, and then Organizations Data Load, and then ATP Messages	Review any of the ATP data messages in your system.
ATP Search Parameters	ATP_SEARCH_PARMS	Campus Community, and then Organization, and then Organizations Data Load, and then ATP Search/Match/Post, and then ATP Search Parameters	Select search parameters to identify duplicate matching records before posting the data.
ATP Post Parameters	ATP_POST_PARMS	Campus Community, and then Organization, and then Organizations Data Load, and then ATP Search/Match/Post, and then ATP Post Parameters	Select parameters for posting the data.
ATP Purge Suspense File	ATP_PURGE_PARMS	Campus Community, and then Organization, and then Organizations Data Load, and then ATP Purge Suspense File	Purge data from the ATP Suspense Table.

Specifying the Data Source

Access the ATP Load External Data (Campus Community, and then Organization, and then Organizations Data Load, and then ATP Load External Data).

Note:

This process is deprecated.

Field or Control	Description
College Data	If the ATP data is college data, specify the correct path to the input file here.
Secondary School Data	If the ATP data is secondary school data, specify the correct path to the input file here.

Loading ATP School Data Using File Parser

Copy and modify these File Parser definitions to meet your institution's requirements.

This File Parser setup supports the 2024 secondary school file format and loads secondary school data into the ATP suspense tables. If the source file format changes, you can modify these definitions to meet your requirements.

These are the elements included in the setup:

Setup	Value
Context Definition	ATP Schools
Context Definition ID	200
Staging Record	ATP_SUSPN
Field Conversion Definition	ATP Organization Load
Field Conversion Definition ID	200
File Mapping Definition	ATP SCHOOLS
File Mapping Definition ID	200
File Type	Flat

The ATP Organization Load conversion definition converts the country, change code, and school type values from the external file to Campus Solutions values.

This file mapping:

Loads the school code into the ATP Code field.
Loads the first 30 characters of the school name into ATP Name.
Loads the first 10 characters of the school name into Short Description.
Loads up to 50 characters of the school name into Description.
Calculates Search Name from Description.
Converts the two-character country code in the file to the corresponding Campus Solutions country code.
Loads address values up to the maximum lengths supported by the ATP suspense record.
Loads the Change Date from the eight-character MMDDYYYY value in the source file.
Converts the source file change codes for use by ATP Search/Match/Post processing.

The secondary school file contains separate fields for a US ZIP code and an international postal code. The mapping populates the Postal Code field from the US ZIP code.

Run the File Parser process using the delivered ATP SCHOOLS file mapping definition.

For general information about running File Parser, see Running the File Parser Process.

Loading ATP College Data Using File Parser

If your institution loads college data, use the ATP Schools definitions as a template and create File Parser definitions that match the college file supplied to your institution.

Create a context definition that uses the ATP_SUSPN staging record. You can use the school data country conversion definition. Define the appropriate change code, proprietorship, and school type conversions for the values in the college file, and create a file mapping definition that matches the file layout.

File Parser doesn't automatically add leading zeros to a four- or five-character college code. If you want college ATP codes to use a six-character format, add the leading zeros to the source data before running File Parser or update the ATP Code value in the suspense record before running ATP Search/Match/Post.

Reviewing Suspense Process Options Data

Access the ATP Suspense Process Options page (Campus Community, and then Organization, and then Organizations Data Load, and then ATP Suspense, and then ATP Suspense Process Options).

When searching for records, you can use Change Code to locate Delete records and review them before posting. If you don't want a Delete record to be processed, you can set its post processing option to Take No Action.

Note:

For secondary school records loaded using the File Parser setup, Edit defaults to Complete, Search defaults to Perform, and Post defaults to Wait Search. These values can be updated in the Context Definition setup.

Processing Options

Values for the Edit, Search, and Post fields are delivered preset with Campus Solutions (CS).

WARNING:

You can manually edit the values in the Edit, Search, and Post fields; however, if any of these fields shows a status of Error and you manually change the status without correcting the error, you might have problems when posting the data.

Field or Control	Description
Edit	The status of the record as the result of the load external data process. Complete: The program was able to process this record without a problem. Error: The program encountered problems when processing this record. Perform: This value is only set manually and is for informational purposes.
Search	The status of the record as the result of the Search/Match process: Complete: The Search/Match process ran without errors. Error: The Search/Match process ran and errors were detected in this record. Perform: The Search/Match process was not yet run for this record or the Search/Match process is set so that the record will be re-selected.
Post	The status of the record as the result of the post process. These values can be entered manually; however, some are entered by the after processes are run, as described below: Delete ID: CS encountered an indication that the organization was deleted from the tape. Set by CS during the Search/Match process if it is unable to add data to a deleted organization. Can also be set manually. Error: The Post process encountered a problem. Set by CS during the Post process. New ID Add: CS was unable to find a match in the database and will add a record with a new ID when the Post process is run, provided that CS finds no matches and an ATP change code of Add. Set by CS during the Search/Match process if no match is found and a new one is added. No Action: This value is only added manually. It is not automatically entered by CS. If this value is entered, the Post and Purge processes ignore the record. Set manually. Purge: This value indicates that this suspense record is removed from CS during the Purge process. Set by CS during the Post process if the record is successfully processed. Update ID: CS found a matching ID in the database. This existing ID record is updated with the data from this ATP record during the Post process. Set by CS during the Search/Match process if a match is found in the database. Wait Search: This record is in the Suspense Table and is waiting to be processed by the Search/Match process. Set by CS during the ATP Load External Data process.

Field or Control

Description

Edit

The status of the record as the result of the load external data process.

Complete: The program was able to process this record without a problem.

Error: The program encountered problems when processing this record.

Perform: This value is only set manually and is for informational purposes.

Search

The status of the record as the result of the Search/Match process:

Complete: The Search/Match process ran without errors.

Error: The Search/Match process ran and errors were detected in this record.

Perform: The Search/Match process was not yet run for this record or the Search/Match process is set so that the record will be re-selected.

Post

The status of the record as the result of the post process. These values can be entered manually; however, some are entered by the after processes are run, as described below:

Delete ID: CS encountered an indication that the organization was deleted from the tape.

Set by CS during the Search/Match process if it is unable to add data to a deleted organization. Can also be set manually.

Error: The Post process encountered a problem.

Set by CS during the Post process.

New ID Add: CS was unable to find a match in the database and will add a record with a new ID when the Post process is run, provided that CS finds no matches and an ATP change code of Add.

Set by CS during the Search/Match process if no match is found and a new one is added.

No Action: This value is only added manually. It is not automatically entered by CS. If this value is entered, the Post and Purge processes ignore the record. Set manually.

Purge: This value indicates that this suspense record is removed from CS during the Purge process.

Set by CS during the Post process if the record is successfully processed.

Update ID: CS found a matching ID in the database. This existing ID record is updated with the data from this ATP record during the Post process.

Set by CS during the Search/Match process if a match is found in the database.

Wait Search: This record is in the Suspense Table and is waiting to be processed by the Search/Match process.

Set by CS during the ATP Load External Data process.

Error Indicators

When the Error indicator appears in the Edit field in the Processing Options group box, the Error Indicators group box identifies the type of error.

Note:

Correct errors on the appropriate page before running the Post process. When you make and save the correction, CS updates the Processing Options group box fields accordingly. For example, if the Edit field value is Error and you fix the errors in the file so that CS now recognizes the data, when you save the change, CS changes the Edit field to Complete. You should always save before changing any of the processing options so that you can review the results of any data changes.

Field or Control	Description
Name Error	When selected, indicates that CS could not recognize the name data.
Foreign Address Error	When selected, indicates that CS could not recognize the address data or that the country of the address is not in the database.

Change Code Options

Field or Control	Description
Change Date	Displays the change date loaded from the source file. You can update this date if necessary. This field can be blank. If Change Date is blank when the record is posted, CS uses the current date as the effective date of the external organization record.
Change Code	Indicates how the record is processed during ATP Search/Match/Post. Add: Add the organization as a new record. Change: Update the existing organization. Delete: Make the existing organization inactive. For secondary school records loaded using the File Parser setup, the incoming file change codes are converted to the corresponding ATP Change Code values.

Field or Control

Description

Change Date

Displays the change date loaded from the source file. You can update this date if necessary.

This field can be blank. If Change Date is blank when the record is posted, CS uses the current date as the effective date of the external organization record.

Change Code

Indicates how the record is processed during ATP Search/Match/Post.

Add: Add the organization as a new record.
Change: Update the existing organization.
Delete: Make the existing organization inactive.

For secondary school records loaded using the File Parser setup, the incoming file change codes are converted to the corresponding ATP Change Code values.

Search/Match Results

Field or Control	Description
Matches	The number of matches that the Search/Match process found for this organization.

Note:

You can view additional information about errors and other processing actions on the ATP Messages page.

Reviewing School Address Data

Access the ATP Suspense Address Data page (Campus Community, and then Organization, and then Organizations Data Load, and then ATP Suspense, and then ATP Suspense Address Data).

The external data load provides the information on this page. You can change the address information if necessary.

Reviewing Other School Data

Access the ATP Suspense Data page (Campus Community, and then Organization, and then Organizations Data Load, and then ATP Suspense, and then ATP Suspense Data).

Field or Control	Description
External Organization ID	CS displays the existing ID of the organization or, if none exists, assigns the next available new ID when you save.
Location Number	The address location number of this organization. The default location number when adding a new organization is one.
New Location	When selected, indicates that CS found the organization exists in your database, but the location address was changed or added. You can override the new location by specifying a location number or clearing the New Location checkbox.
School Type	For secondary school records loaded using the delivered File Parser setup, the system displays the LS School Type derived from the school type in the source file. For college files, the value depends on the School Type conversion defined in your institution's File Parser setup.
Program In Years	For the College data file, CS displays the program in years if a value exists in the source file.
Proprietorship	For the College data file, CS displays the proprietorship if a value exists in the source file. If the College data file does not contain a value, CS sets the proprietorship value to Other. Values for this field are delivered with CS. Do not modify these values in any way. Any modifications to these values could require substantial programming effort.
Status of Institution	For the College data file, CS displays the status of institution if a value exists in the source file.
Transcript Translation	When selected, indicates that the transcript from this organization needs to be translated.

For the Secondary School data file, CS does not display the Program in Years, Proprietorship, and Status of Institution values because these values do not exist in the source file.

Reviewing ATP Data Suspense Messages

Access the ATP Messages (Suspense) page (Campus Community, and then Organization, and then Organizations Data Load, and then ATP Suspense, and then ATP Messages).

The ATP Messages (Suspense) page is for viewing purposes only. You cannot enter or modify data here.

Reviewing All ATP Messages

Access the ATP Messages page (Campus Community, and then Organization, and then Organizations Data Load, and then ATP Messages).

Enter any combination of record number, process instance (generated by the process scheduler), date loaded, and ATP code. Click the Search button to launch the search for all ATP messages based on the criteria you selected.

Specifying Search Parameters

Access the ATP Search Parameters page (Campus Community, and then Organization, and then Organizations Data Load, and then ATP Search/Match/Post, and then ATP Search Parameters).

These values are common to each group box on this page:

Field or Control	Description
Add	Select for the system to automatically add the load data.
Update	Select for the system to automatically overwrite the existing data with the new load data.
Suspend	Select for the system to set the load data aside and post a message about it to the ATP Messages page until you can investigate further.
Ignore	Select for the system to do nothing with the load data or to your database, but to continue with the ATP Search/Match process.

Add

Field or Control	Description
One Match	Select what you want the system to do (update, suspend, or ignore) when the change code is Add and the Search/Match process finds one match.

Change

Field or Control	Description
No Match	Select what you want the system to do (update, suspend, or ignore) when the change code is Change and the Search/Match process finds no match.

Delete

Field or Control	Description
No Match	Select what you want the system to do (update, suspend, or ignore) when the change code is Delete and the Search/Match process finds no match.

Add/Change/Delete

Field or Control	Description
Multiple Matches	Select what you want the system to do (update, suspend, or ignore) when the change code is Add, Change, or Delete and the Search/Match process finds multiple matches. Note: The Search/Match process used inside the ATP Search/Match/Post process is independent from Search/Match for organizations.

Field or Control

Description

Multiple Matches

Select what you want the system to do (update, suspend, or ignore) when the change code is Add, Change, or Delete and the Search/Match process finds multiple matches.

Note: The Search/Match process used inside the ATP Search/Match/Post process is independent from Search/Match for organizations.

Searching for Duplicate Records and Posting the Data

Access the ATP Post Parameters page (Campus Community, and then Organization, and then Organizations Data Load, and then ATP Search/Match/Post, and then ATP Post Parameters).

Execution Option

Select the processes to run: Search, Match and Post, Post Only, or Search and Match Only.

Note:

If you choose to run either Search, Match and Post, or Search and Match Only, you should indicate the conflict parameters on the ATP Search Parameters page.

Post Processing

Field or Control	Description
Process Single Record	Select to set the specified process to run only on one record. You must specify the ATP record number for the school that Campus Solutions (CS) posts.

When the Post process creates or updates an External Organization record, it uses the Description value for the organization's 50-character description. If Description is blank, CS uses ATP Name. If Change Date is blank, CS uses the current date as the effective date of the External Organization record. For a US postal code containing nine digits without a hyphen, the Post process inserts a hyphen between the fifth and sixth digits when it creates or updates the Organization Location record. When a Delete record is successfully posted, CS creates an inactive effective-dated row for the existing organization. The organization record isn't physically deleted.

When you click Run and schedule the process, the PeopleSoft Process Scheduler runs the CCATPPST.SQR process and posts the ATP data.

Purging ATP Data from the Suspense File

Access the ATP Purge Suspense File page (Campus Community, and then Organization, and then Organizations Data Load, and then ATP Purge Suspense File).

ATP Purge Processing Parameters

Field or Control	Description
All Suspense Rows	Select to set the process to purge all records in the suspense tables.
Marked Suspense Rows	Select to set the process to purge only those records marked Purge in the suspense file, as indicated in the ATP Suspense Process Options page.

ATP Message Purge Processing Parameters

Field or Control	Description
Remove Associated Messages	Select to set the process to purge messages associated with the row of data selected by the Marked Suspense Rows option.
Retain Associated Messages	Select to set the process not to purge any messages associated with the row of data selected by the Marked Suspense Rows option.
All Messages	Select to set the process to purge all messages from the suspense files. You should select this option if you selected the All Suspense Rowsoption.