CS 9.2 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.

Securing and Setting Up Population Update
Assigning Population Update User Security

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

Navigation:  NavBar > Navigator > 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.
Population Update Security search page
  1. The Population Update Security page displays.
  2. Select the Record (Table) Name spyglass.
Population Update Security page
  1. The Look Up Record (Table) Name popup displays.
  2. Select a Record (Table) Name from the list.
Look Up Record Table Name popup
  1. The Look Up Record (Table) Name popup disappears.
  2. The Record (Table) Name field populates.
  3. To add another Record (Table) Name, select the Add a New Row [+] icon.
Population Update Security page
  1. A new, empty row displays.
  2. Repeat steps 5 through 10 until you've added all the Record (Table) Names you wish.
  3. Select the Save button.
Population Update Security page
  1. Section complete.
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 dropdown 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:  NavBar > Navigator > 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.
  3. Select the Search button.
Population Update Setup page
  1. The Population Update Setup page displays.
  2. Select the Field Name dropdown.
Population Update Setup page
  1. The Field Name dropdown list displays.
  2. Select a Field Name.
Field Name dropdown list
  1. The Field Name dropdown disappears.
  2. The Field Name populates.
  3. Select the Attribute Sequence spyglass.
Population Update Setup page
  1. The Look Up Attribute Sequence popup displays.
  2. Select an Attribute Sequence.
Look Up Attribute Sequence popup
  1. The Look Up Attribute Sequence popup disappears.
  2. The Attribute Sequence field populates.
  3. Select the Save button.
Population Update Setup page
  1. Section complete.
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.

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.

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

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

Navigation:  NavBar > Navigator > 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.
Population Update Process search page
  1. The Add a New Value tab displays.
  2. Enter a meaningful Run Control ID.
  3. Select the Add button.
Add a New Value tab
  1. The Population Selection Update page displays.
  2. Select the Record (Table) Name dropdown.
Population Selection Update dropdown
  1. The Record (Table) Name dropdown list displays.
  2. Select a Record (Table) Name from the list.
Record Table Name dropdown list
  1. The Record (Table) Name dropdown list disappears.
  2. The Record (Table) Name field populates.
  3. 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.
Error Reporting Selection
  1. 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 dropdown.
Population Selection section
  1. The Selection Tool dropdown list displays.
  2. For this example, select PS Query.
Selection Tool dropdown
  1. The Selection Tool dropdown disappears.
  2. The Selection Tool field populates.
  3. Select the Query Name spyglass.
Population Selection section
  1. The Look Up Query Name popup displays.
  2. Select a Query Name from the list.
Look Up Query Name popup
  1. The Look Up Query Name popup disappears.
  2. The Query Name field populates.
  3. This query demands that we provide it with some instructions.  Select the Edit Prompts link.
Population Selection section
  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.
Query Prompts popup
  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.
Preview Selection Results link
  1. The Preview Selection Results page displays.  Examine the list of students.
  2. Select the Return button.
Preview Selection Results page
  1. 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 dropdown at the bottom of the page.
Field Name dropdown
  1. The Field Name dropdown list displays.  
  2. Select a value from the list.
Field Name dropdown list
  1. The Field Name dropdown 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
  1. Process complete.