GP_VER_REC_C_VW (SQL View)	Index Back
View-Child Records-Versioning View used to select child records in Versioning. These are records (whose data when changed) needs to clear the GP_VERSION field on the parent record. This view selects both records and views because in some cases, a view is used to update the underlying record. An example is GP_ACM_MBR2_VW which updates the GP_ACM_MBR record. In this case, GP_VERSION on GP_ACCUMUKATOR needs to be cleared.

GP_VER_REC_C_VW

(SQL View)

View-Child Records-Versioning

View used to select child records in Versioning. These are records (whose data when changed) needs to clear the GP_VERSION field on the parent record. This view selects both records and views because in some cases, a view is used to update the underlying record. An example is GP_ACM_MBR2_VW which updates the GP_ACM_MBR record. In this case, GP_VERSION on GP_ACCUMUKATOR needs to be cleared.

SELECT A.RECNAME , A.RECDESCR FROM PSRECDEFN A WHERE A.RECTYPE IN (0,1) AND A.OBJECTOWNERID='HG' AND A.RECNAME LIKE 'GP%'

Related Language Record: GP_RECDESCR_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description