NST_ASGN_TBL_VW (SQL View)	Index Back
NST ASGNM view NST ASGNM view

NST_ASGN_TBL_VW

(SQL View)

NST ASGNM view

SELECT DISTINCT A.TEMP_TBL_NAME , R.RECDESCR FROM PS_TEMP_TBL_ASGNM A , PSRECDEFN R WHERE R.RECNAME = A.TEMP_TBL_NAME

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TEMP_TBL_NAME Character(12) VARCHAR2(12) NOT NULL Temporary Table name

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TEMP_TBL_NAME	Character(12)	VARCHAR2(12) NOT NULL	Temporary Table name
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description