ID_DEL_PRVN_VW (SQL View)	Index Back
Setup Tbl - View This is a view of the setup table ID_DEL_PRVN_TBL and is exclusively used for avoiding confusion of the field RECNAME on the panel EMPLOYEE_ID_DELETE from other RECNAME fields from EMPL_RCRDS_VIEW and EMPL_RCRDS_VW2. When no records are present in the ID_DEL_PRVN_TBL the RECNAME field has nothing in it and the SQLExec code on EMPL_RCRDS_VW2.RECNAME@SavePostChg fails because of this.

ID_DEL_PRVN_VW

(SQL View)

Setup Tbl - View

This is a view of the setup table ID_DEL_PRVN_TBL and is exclusively used for avoiding confusion of the field RECNAME on the panel EMPLOYEE_ID_DELETE from other RECNAME fields from EMPL_RCRDS_VIEW and EMPL_RCRDS_VW2. When no records are present in the ID_DEL_PRVN_TBL the RECNAME field has nothing in it and the SQLExec code on EMPL_RCRDS_VW2.RECNAME@SavePostChg fails because of this.

SELECT RECNAME, FIELDNAME, MESSAGE_SET_NBR, MESSAGE_NBR FROM PS_ID_DEL_PRVN_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
Prompt Table: PSFIELD_VW

3 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

4 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRCFLD_VW
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD). Prompt Table: PSFIELD_VW
3	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
4	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.