SUP_OB_SETMP_VW (SQL View)	Index Back
Templates View Supplier/Bidder/SCR Template View - Used in Template Selection modal page.

SUP_OB_SETMP_VW

(SQL View)

Templates View

Supplier/Bidder/SCR Template View - Used in Template Selection modal page.

SELECT SUP_OB_TEMPLATE_ID ,SUPOB_REG_OPT_TYPE ,SUP_OB_TMPL_USAGE ,BID_CONTACT_TYPE ,DESCR60 ,DESCRLONG FROM PS_SUP_OB_REG_TEMP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SUP_OB_TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Supplier On boarding template Id

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_OB_TMPL_USAGE Character(1) VARCHAR2(1) NOT NULL Template Usage
B=Both
E=External
I=Internal
N=Not Available

4 BID_CONTACT_TYPE Character(1) VARCHAR2(1) NOT NULL Bidder Type
B=Business
I=Individual

5 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description

6 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SUP_OB_TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Supplier On boarding template Id
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_OB_TMPL_USAGE	Character(1)	VARCHAR2(1) NOT NULL	Template Usage B=Both E=External I=Internal N=Not Available
4	BID_CONTACT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Bidder Type B=Business I=Individual
5	DESCR60	Character(60)	VARCHAR2(60) NOT NULL	Description
6	DESCRLONG	Long Character	CLOB	Long Description