Process Sequence Numbers

The table, PS_PRCSSEQUENCE stores the last sequence numbers for the process scheduler and report manager.

In PeopleTools 8.48.15 there are 5 process sequence keys (PRCSSEQKEY) which you can view yourself by looking at the translates on this field:

0 = Process Instance

1 = Report Instance

2 = Transfer Instance

3 = Report ID

4 = Folder ID

Its probably a good health check to ensure that the numbers in PS_PRCSSEQUENCE match those in the relevant tables:

select max(PRCSINSTANCE) as PRCSSEQKEY0 from PSPRCSRQST;

select max(CONTENTID) PRCSSEQKEY1 from PS_CDM_AUTH;

select max(TRANSFERINSTANCE) PRCSSEQKEY2 from PS_CDM_LIST;

select max(PSRF_REPORT_ID) PRCSSEQKEY3 from PSRF_RINFO_TBL;

select max(PSRF_FOLDER_ID) PRCSSEQKEY4 from PSRF_FINFO_TBL;

Especially if you happen to be clearing out data from these tables manually. If you do clear out processes/reports you'll want to update the PS_PRCSSEQUENCE accordingly.