SP_BK_PRF_NONVW (SQL View)	Index Back
Asset Profile Prompt Table This view, when used as a prompt table on asset.profile_id, filters out non-effective profiles from the drop down list during the asset add process.

SP_BK_PRF_NONVW

(SQL View)

Asset Profile Prompt Table

This view, when used as a prompt table on asset.profile_id, filters out non-effective profiles from the drop down list during the asset add process.

SELECT SETID , PROFILE_ID , BOOK FROM PS_PROFILE_BK_TBL

Parent record: PROFILE_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID

2 PROFILE_ID_ORIG Character(10) VARCHAR2(10) NOT NULL Original Profile ID

3 BOOK Character(10) VARCHAR2(10) NOT NULL Asset Book Name

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID
2	PROFILE_ID_ORIG	Character(10)	VARCHAR2(10) NOT NULL	Original Profile ID
3	BOOK	Character(10)	VARCHAR2(10) NOT NULL	Asset Book Name