JPM_RLAT_RECVW2 (SQL View)	Index Back
Key Field Count - All records Displays the count of key fields in all records

JPM_RLAT_RECVW2

(SQL View)

Key Field Count - All records

Displays the count of key fields in all records

SELECT F.RECNAME , COUNT(*) FROM PSKEYDEFN F WHERE F.INDEXID = '_' AND F.FIELDNAME NOT IN ('EFFDT', 'SETID') GROUP BY F.RECNAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 JPM_FIELD_COUNT Number(3,0) SMALLINT NOT NULL Field Count

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	JPM_FIELD_COUNT	Number(3,0)	SMALLINT NOT NULL	Field Count