CS SACR Security: Population Update Security

Purpose: Use this document as a guide for establishing Population Update security in ctcLink.

Audience: Campus Solutions Core and Financial Aid staff; Local Security Administrators

You must have the ZZ Local Security Admin or ZZ Local SACR Security Admin role for this navigation. For more information about these two roles, please refer to the CS 9.2 All 'ZZ' Security Roles (Processor) QRG.

Population Update is a process that uses the Population Selection utility to update values in selected fields. Your college will choose the records and fields to make available for update and set user security to identify which users can update the records. The user selects the records and fields to update on the Population Selection Update run control page.

Each record that can be updated has a query to use for population selection. This query is joined with other records to determine the population that you want to update when you use the PS Query selection tool.

Expand or collapse content Securing and Setting Up Population Update
Expand or collapse content Assigning Population Update User Security

This component sets user security for accessing records to update using the Population Selection update process.

Navigation: Set Up SACR > Security > Secure Student Administration > User ID > Population Update Security

  1. The Population Update Security search page displays.
  2. Enter User ID.
  3. Select the Search button.
  4. The Population Update Security page displays.
  5. Select the Record (Table) Name spyglass.
  6. The Look Up Record (Table) Name popup displays.
  7. Select a Record (Table) Name from the list.
  8. The Record (Table) Name field populates.
  9. To add another Record (Table) Name, select the Add a New Row [+] icon.
  10. A new, empty row displays.
  11. Repeat steps until you've added all the Record (Table) Names you wish.
  12. Select the Save button to complete the process.
Population Update Security
Expand or collapse content Setting Up the Population Update Process

When you select a record and access the Population Update Setup page, the system makes the fields from that record available in the Field Name drop-down lists. Select each field that you want to make available for users to update. Only the records and fields that you select and to which the user has security access will be available on the run control page.

Navigation: Set Up SACR > System Administration > Utilities > Population Update > Population Update Setup

  1. The Population Update Setup search page displays.
  2. Enter Record (Table) Name begins with value.
  3. Select the Search button.
  4. The Population Update Setup page displays.
  5. Select the Field Name drop-down.
  6. The Field Name drop-down list displays.
  7. Select a Field Name.
  8. The Field Name populates.
  9. Select the Attribute Sequence spyglass.
  10. The Look Up Attribute Sequence popup displays.
  11. Select an Attribute Sequence.
  12. The Attribute Sequence field populates.
  13. Select the Save button to complete the process.
Population Update Setup
Expand or collapse content Using Population Selection

Note:   You access the Population Selection pages listed here from the standard Population Selection group box on the Run Control page. You will use other pages depending on the values and parameters that you enter for a specific process. Those pages are documented where the specific run control page for that business process is documented.

Expand or collapse content Population Selection Navigation Types

Equation Editor Navigation: Select the Create Equation or Edit Equation link in the Population Selection group box on a run control page when the selection tool is Equation Engine. The Create Equation and Edit Equation links appear only if the user has appropriate security for creating or editing equations and the selection tool is Equation Engine.

Query Manager Navigation: Select the Launch Query Manager link in the Population Selection group box on a run control page when the tool is PS Query.

Preview Selection Results Navigation: Select the Preview Selection Results link in the Population Selection group box on a run control page. The Preview Selection Results link appears only if preview functionality is enabled on the Selection Tool page for the tool selected.

File Mapping Navigation: Set Up SACR, then select System Administration, then select Utilities, then select  File Parser, then select Population Selection File Map.  Select the Create File Mapping link or Edit File Mapping link in the Population Selection group box on a run control page when the tool is external file.

Expand or collapse content Population Update Records (Tables) and their Module Relationship
Population Update Records Tables and their Module Relationship
Expand or collapse content Financial Aid Population Update Records (Tables) that We Don't Use
Financial Aid Population Update Records Tables that We Don't Use
Expand or collapse content Running the Population Update Process

Now let's run through the steps of defining, previewing and launching a Population Update process.

Navigation: Set Up SACR > System Administration > Utilities > Population Update > Population Update Process

  1. The Population Update Process search page displays.  In this example, we'll create a new Run Control ID.
  2. Select the Add a New Value tab.
  3. The Add a New Value tab displays.
  4. Enter a meaningful Run Control ID.
  5. Select the Add button.
    • NOTE: It is important to note that Run Control IDs cannot be deleted. Do not include spaces in your Run Control. We encourage the Run Control ID to have the same process naming convention but unique to the step; because of this, including your institution code and a short process description in the Run Control ID is recommended--e.g., WA220_ADM_FYR_5 (Institution, Process).
  6. The Population Selection Update page displays.
  7. Select the Record (Table) Name drop-down.
  8. The Record (Table) Name drop-down list displays.
  9. Select a Record (Table) Name from the list.
  10. The Record (Table) Name field populates.
  11. Error Reporting: You can choose to have the process display error messages only or all of the messages that it encounters during the update, or you can choose not to display any of the messages. Displaying at least the error messages gives you an opportunity to decide whether to investigate and resolve the problems.  For this example, select Report Error Messages.
  12. Population Selection: A standard group box appears on run control pages for processes that use the Population Selection process to select the IDs to process. The Population Selection process may be required for some processes (for example, the Mass Assign Service Indicators process) but optional for others (for example, the 3C Engine process). The Population Selection Context Definition for a process controls whether the Population Selection process is available and if is required or optional.  Select the Selection Tool drop-down.
  13. The Selection Tool drop-down list displays.
  14. For this example, select PS Query.
  15. The Selection Tool drop-down disappears.
  16. The Selection Tool field populates.
  17. Select the Query Name spyglass.
  18. The Look Up Query Name popup displays.
  19. Select a Query Name from the list.
  20. The Look Up Query Name popup disappears.
  21. The Query Name field populates.
  22. This query demands that we provide it with some instructions.  Select the Edit Prompts link.
  1. The Query Prompts popup displays.
  2. Enter or select Institution.
  3. Enter or select Career.
  4. Enter or select Effective Term.
  5. Select the OK button.
  1. The Query Prompts popup disappears.
  2. Now let's look at the population of students that will be updated by this process.  Select the Preview Selection Results link.
  3. The Preview Selection Results page displays.  Examine the list of students.
  4. Select the Return button.
  5. The Population Selection Update page displays.  Now let's set the values for the field(s) we wish to update.

When you enter the Record (Table) Name, the fields that are available for update become available for selection.  Enter each field that you want to update and enter the value to use.  When you run the Population Update process, the system finds the record and updates the field values with the values that you specify for the records that you have identified using the Population Selection utility.

For the following records you can decide whether to update the existing effective dated row or to insert a new effective dated row:

  • ISIR Internals/Control Data
  • Student FA Term

The following records have additional functionality:

  • Admissions Application Data: Optional Batch EIP for this record.
  • Admissions Application Recruitment Category: Optional Batch EIP for this record.
  • Admissions Prospect Career: Optional Batch EIP for this record.
  • Records needing INAS Calculation: Hardcoded value "P" for Protection Reason.
  • Calculation of Total Duration.
  • Loan Origination Detail: Hold/ UnHold logic, custom XLAT.
  • Loan Origination: Logic to update Borrower Citizenship Status for Grad PLUS, Subsidized, and Unsubsidized Loans.
  • Pell Origination: The date fields associated with Pell Origination Status and Pell Trans Status are also updated with the system date.
  • Corresponding update to Student Aid Attribute
  • External Award Staging Detail: Custom translate for processing status.
  • Student Career: The date field associated with the Synchronize Advisement Report is also updated with the system date.
  • Term Activation: The Tuition Calc Required check box is selected when the Override Tuition Group is updated.
  • Student Equation Variables: Validated against term activation record. The Tuition Calc Required flag is set to Y when Student Equation Variables are processed.
  • Student Packaging Variables: Validated against student aid record.
  • Student FA Term : Update of Override fields related to update of FA Load, NSLDS Loan Year, and Direct Lending Year.
  • Validation of entered FA load value.
  • SAP records : Operator ID of the person running update and date/time stamp of the process.
  • Validation of EMPLIDs selected for Population Update process.
  1. For this example, select the Field Name drop-down at the bottom of the page.
Field Name drop-down
  1. The Field Name drop-down list displays.  
  2. Select a value from the list.
Field Name dropdown list
  1. The Field Name drop-down disappears.
  2. The Field Name value populates.
  3. Now let's provide the value that will be used to update the Field Name for each of our students.  In the Select Attributes to Update section at the bottom of the page, select the Date tab.
Select Attributes to Update section
  1. The Date tab displays.
  2. Select the Common Attribute spyglass.
Date tab
  1. The Look Up Common Attributes popup displays.
  2. Select a Common Attribute from the list.
Look Up Common Attribute popup
  1. The Look Up Common Attribute popup disappears.
  2. The Common Attribute field populates.
  3. Select the Run button at the top of the page to release the process to the Process Scheduler. Please refer to the Process Scheduler/Process Monitor QRG for guidance.
Population Selection Update page

Video Tutorial

COMING SOON

The video below demonstrates the process actions described in the steps listed above. There is no audio included with this video. Select the play button to start the video.

Video Tutorial via Panopto

View the external link to Running the Population Update Process. This link will open in a new tab/window.