CRMSYSTEMID_VW (SQL View)	Index Back
CRM View looking at PSSYSTEMID This view is used for the sole purpose of maintaining autonumbering for the PSSYSTEMID table. This is required because Tools prefixes the record name passed into GetNextNumberWithGapsCommit with 'PS_'.

CRMSYSTEMID_VW

(SQL View)

CRM View looking at PSSYSTEMID

This view is used for the sole purpose of maintaining autonumbering for the PSSYSTEMID table. This is required because Tools prefixes the record name passed into GetNextNumberWithGapsCommit with 'PS_'.

SELECT RECNAME ,PTNEXTSYSTEMID ,PTUPDSYSTEMID FROM PSSYSTEMID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

2 PTNEXTSYSTEMID Number(9,0) DECIMAL(9) NOT NULL PeopleTools Next SystemID

3 PTUPDSYSTEMID Number(9,0) DECIMAL(9) NOT NULL Peopletools Update System ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	PTNEXTSYSTEMID	Number(9,0)	DECIMAL(9) NOT NULL	PeopleTools Next SystemID
3	PTUPDSYSTEMID	Number(9,0)	DECIMAL(9) NOT NULL	Peopletools Update System ID