FORM_TYPE_SVW (SQL View)	Index Back
Form Type Form Type Search View make FORM_OWNER_ID as key OPRID, component processor will automatically use operator id as bind value NOTE: making PORTAL_NAME with search edit and no edit can prohibit the form being designed from different portal

FORM_TYPE_SVW

(SQL View)

Form Type

Form Type Search View make FORM_OWNER_ID as key OPRID, component processor will automatically use operator id as bind value NOTE: making PORTAL_NAME with search edit and no edit can prohibit the form being designed from different portal

SELECT FORM_OWNER_ID , FORM_TYPE , FORM_TYPE_STATUS , PORTAL_NAME , PORTAL_LABEL FROM PS_FORM_TYPE WHERE FLUIDMODE = 0

Related Language Record: FORM_TYPE_SVW_L

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 FORM_TYPE Character(10) VARCHAR2(10) NOT NULL Form and Builder Field

3 EOFM_STATUS Character(1) VARCHAR2(1) NOT NULL ePro team accidentaly changed the translate values of FORM_TYPE_STATUS field. Created this field to workaround the issue.
A=Activated
D=In Design
I=Inactivated

4 PORTAL_NAME Character(30) VARCHAR2(30) NOT NULL Portal Name (see PSPRDMDEFN).

5 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Portal Label

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field
3	EOFM_STATUS	Character(1)	VARCHAR2(1) NOT NULL	ePro team accidentaly changed the translate values of FORM_TYPE_STATUS field. Created this field to workaround the issue. A=Activated D=In Design I=Inactivated
4	PORTAL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Name (see PSPRDMDEFN).
5	PORTAL_LABEL	Character(30)	VARCHAR2(30) NOT NULL	Portal Label