Managing System IDs

This chapter provides an overview of ID management and discusses how to:

See Also

Understanding ID Delete Control

Searching for Records and Using Search/Match

Entering External System IDs

Click to jump to parent topicUnderstanding ID Management

Unique IDs are vital to PeopleSoft Campus Solutions. When you add an individual or organization, the system creates a record and assigns the next available unique ID. The unique ID remains associated with that individual or organization unless or until you change or delete it.

When you want to add, update, or delete data about that individual or organization, use the unique ID to narrow your search and save time accessing the record.

See Searching for Records and Using Search/Match.

To prevent arbitrary or accidental deletion of IDs, assign priority control data. Priority control data prevents users from deleting any ID that contains that data without first evaluating the data. Priority control data also prevents users from having to ask the system administrator or other individuals with the appropriate level of system security to delete the data.

Use the PeopleSoft Process Scheduler to delete or change individual IDs. You can select one ID or several IDs at the same time. When you run the process, the system creates an ID Change/Delete Process Log for each ID, showing how many rows were deleted for that individual and listing the records and fields that it updated. The log also indicates the administrative User ID that either deleted or changed an individual ID.

Warning! When you delete an ID, the system deletes not only the ID number, but all key data that is associated with that ID throughout the system. This loss of data could affect other departments. If the ID contains priority data, coordinate the need to delete it with other departments before deleting the priority data and the ID.

See Setting Up ID Delete Control.

You can change system-generated IDs, but you must change and manage them manually. For example, you might want to change the system-generated IDs of 0000012, 0000035, and 0000062 to the IDs of PRES01, PRES02, and PRES03 to group those specific individuals within a list that only the president of the institution should manage. When you change them, the original system-generated IDs drop from the list of numbered IDs and appear instead as in a group of initial alpha character IDs. That is, the numbered ID list shows 0000033, 0000034, 0000036, 0000037, but the ID of 0000035 that you changed is not listed. That individual is now PRES02 in the list of IDs that are PRES01, PRES02, and PRES03.

Warning! Changes that you make to an ID affect the ID throughout the system, including other departments. Coordinate the need to change the ID with other departments before making the change.

You can also determine the last ID assigned, and determine or adjust the maximum length of system-generated IDs using the installation pages.

Click to jump to parent topicCreating System IDs

When you add an individual or organization to your database, the system creates a record and assigns the next available unique ID.

See Adding a Person to Your Campus Solutions Database.

See Adding Organizations to Your Database.

Click to jump to parent topicDeleting Individual IDs

This section discusses how to delete individual IDs.

Click to jump to top of pageClick to jump to parent topicPrerequisites

Identify priority control data to prevent the unwanted deletion of individual and organization IDs.

See Also

Setting Up ID Delete Control

Click to jump to top of pageClick to jump to parent topicPages Used to Delete Individual IDs

Page Name

Definition Name

Navigation

Usage

ID Delete

RUNCTL_ID_CHANGE

  • Set Up SACR, System Administration, Database Processing ID Delete

  • Campus Community, Personal Information, ID Management, ID Delete

Select individual IDs to delete.

Display Address

ADDRSS_DISPLAY_SEC

Click the Display Address link on the ID Delete page.

Review an individual's address to confirm that the ID is the correct one to delete.

Display National ID

NID_DISPLAY_SEC

Click the Display National ID link on the ID Delete page.

Review an individual's national ID to confirm that the ID is the correct one to delete.

Click to jump to top of pageClick to jump to parent topicSelecting Individual IDs to Delete

Access the ID Delete page (Set Up SACR, System Administration, Database Processing ID Delete).

Enter information and then run the Change/Delete Person ID process.

Note. This page is also used in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 PeopleBook: Administer Workforce, "Updating Person and Job Information," Changing and Deleting IDs

Person ID(s) to be processed

Person ID and Name

Enter the ID that you want to delete. The system displays the name of the person with that ID.

Display Address

Click this link to access the page on which you can review address data to further determine if this is the correct ID to delete.

Display National ID

Click this link to access the Display National ID page, on which you can review the individual's national ID numbers to further determine if this is the correct ID to delete.

After running the Change/Delete Person ID process, you can review the updated records for the specific individual on the ID Change/Delete Process Log.

See Reviewing Changed or Deleted Individual ID Records.

Click to jump to parent topicChanging Individual IDs

This section discusses how to:

Click to jump to top of pageClick to jump to parent topicPage Used to Change Individual IDs

Page Name

Definition Name

Navigation

Usage

ID Change

RUNCTL_ID_CHANGE

  • Set Up SACR, System Administration, Database Processing, ID Change

  • Campus Community, Personal Information, ID Management, ID Change

Change an individual ID.

ID Change/Delete Process Log

HR_PER502_LOG

  • Set Up SACR, System Administration, Database Processing, ID Change/Delete Process Log

  • Campus Community, Personal Information, ID Management, ID Change/Delete Process Log

Review an individual's national ID to confirm that the ID is the correct one to delete.

Click to jump to top of pageClick to jump to parent topicChanging an Individual ID

Access the ID Change page (Set Up SACR, System Administration, Database Processing, ID Change).

Enter information to change one or more individual IDs, and then use the PeopleSoft Process Scheduler to run the Change/Delete Person ID process. When you run the process, the system changes the IDs that you list here. You can review the records updated for the individuals on the ID Change/Delete Process Log.

Note. This page is also used in PeopleSoft HRMS.

See PeopleSoft HRMS 9.0 PeopleBook: Administer Workforce, "Updating Person and Job Information," Changing and Deleting IDs

New Person ID

Enter the new ID to assign to this individual; the new ID replaces the individual's existing ID.

Display Address

Click this link to access the Display Address page, on which you can review the individual's address data to further determine if this is the correct ID to change.

Display National ID

Click this link to access the Display National ID page, on which you can review the individual's national ID numbers to further determine if this is the correct ID to change.

Click to jump to top of pageClick to jump to parent topicReviewing Changed or Deleted Individual ID Records

Access the ID Change/Delete Process Log page (Set Up SACR, System Administration, Database Processing, ID Change/Delete Process Log).

Information on this page is display-only. You cannot enter or edit data here. The information displayed lists changes made as the result of the Change/Delete Person ID process, which is run from the ID Delete or ID Change pages.

Click to jump to parent topicDeleting Organization IDs

This section provides an overview of organization ID deletion and discusses how to select the organization ID to delete.

Click to jump to top of pageClick to jump to parent topicUnderstanding Organization ID Deletion

Within PeopleSoft Campus Solutions, when you try to delete an organization ID that contains data in any of the priority records that are specified on the ID Delete Control page, the system does not allow the deletion. Instead, it displays a message that lists the specific records and key fields that contain priority data for the ID. To delete the ID, you or your system administrator must first remove the associated priority data.

Click to jump to top of pageClick to jump to parent topicPage Used to Delete Organization IDs

Page Name

Definition Name

Navigation

Usage

Delete Organization ID

ORG_ID_DELETE

Campus Community, Organization, Delete Organization ID

Select an organization ID to delete.

Change Organization ID

ORG_ID_CHANGE

Campus Community, Organization, Change Organization ID

Select an organization ID to change.

Click to jump to top of pageClick to jump to parent topicSelecting the Organization ID to Delete

Access the Delete Organization ID page (Campus Community, Organization, Delete Organization ID).

Description, Org Type (organization type), Ownership, and Location

Review information here to verify that this is the correct ID to delete. When you save the page, the organization ID will be deleted.

Note. Only one organization ID can be deleted at a time.

Click to jump to parent topicChanging an External Organization ID

This section discusses changing an organization ID.

Click to jump to top of pageClick to jump to parent topicSelecting the Organization ID to Change

Access the Change Organization ID page (Campus Community, Organization, Change Organization ID).

New External Org ID (new external organization ID)

Enter the external organization ID to assign. You can enter a nonexisting ID or choose from the list of existing IDs.

Click to jump to parent topicUpdating ID Types

This section provides an overview of ID type updates and discusses how to run the Update ID Type process.

Click to jump to top of pageClick to jump to parent topicUnderstanding ID Type Updates

By storing each ID type, whether it be for a person or an organization, in a single table (ID_TYPE_TBL record) and associating an indicator flag value to each, you can use individual or organization IDs as a single ID field in applications that are common to both individuals and organizations.

For example, when using the 3C features, you can add a communication to a person by adding a communication to a person ID or you can add a communication to an organization by adding a communication to an organization ID. The Communication feature is the same for both types of IDs because they can be combined inside a common ID (COMMON_ID). Running the Update ID Type process inserts the person ID and the organization ID into the ID_TYPE_TBL and assigns to each a type (either person or organization) by which to differentiate them.

Click to jump to top of pageClick to jump to parent topicPage Used to Update ID Types

Page Name

Definition Name

Navigation

Usage

Update ID Type

RUNCTL_CCIDTYPE

  • Set Up SACR, System Administration, Database Processing, Update ID Type

  • Campus Community, Personal Information, ID Management, Update ID Type

Run the Update ID Type process to associate the correct ID type—either person or organization—with each ID in your system.

Click to jump to top of pageClick to jump to parent topicRunning the Update ID Type Process

Access the Update ID Type run control page (Set Up SACR, System Administration, Database Processing, Update ID Type) to run the Update ID Type process (CCIDTYPE SQR). Use PeopleSoft Process Scheduler to run the Update ID Type process.