SUP_PBLUSRTL_VW (SQL View)	Index Back
Profile Questions

SUP_PBLUSRTL_VW

(SQL View)

Profile Questions

SELECT SUP_INSTALL_KEY , SUPOB_REG_OPT_TYPE , SUP_USER_TYPE , SUP_OB_TEMPLATE_ID FROM PS_SUP_INTUSERTMPL WHERE SUP_USER_TYPE = 'P'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUP_INSTALL_KEY Character(1) VARCHAR2(1) NOT NULL Bid Factor List Items
Default Value: 1

2 SUPOB_REG_OPT_TYPE Character(2) VARCHAR2(2) NOT NULL On boarding manage invite options
AD=Ad-hoc Tasks
NB=Register New Bidders
NS=Register New Suppliers
NU=Register New User Accounts
PC=Profile Change Request
RB=Request Change for Bidder
RS=Request Supplier Change

3 SUP_USER_TYPE Character(1) VARCHAR2(1) NOT NULL User Type
I=Internal
P=Public

4 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id
Prompt Table: %EDITTABLE

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUP_INSTALL_KEY	Character(1)	VARCHAR2(1) NOT NULL	Bid Factor List Items Default Value: 1
2	SUPOB_REG_OPT_TYPE	Character(2)	VARCHAR2(2) NOT NULL	On boarding manage invite options AD=Ad-hoc Tasks NB=Register New Bidders NS=Register New Suppliers NU=Register New User Accounts PC=Profile Change Request RB=Request Change for Bidder RS=Request Supplier Change
3	SUP_USER_TYPE	Character(1)	VARCHAR2(1) NOT NULL	User Type I=Internal P=Public
4	SUP_OB_TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Supplier On boarding template Id Prompt Table: %EDITTABLE