FORM_ACTIVE_VW (SQL View)	Index Back
Active Forms View

FORM_ACTIVE_VW

(SQL View)

Active Forms View

SELECT FORM_TYPE , FORM_TYPE_STATUS , PORTAL_LABEL FROM PS_FORM_TYPE WHERE FORM_TYPE_STATUS = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 FORM_TYPE_STATUS Character(1) VARCHAR2(1) NOT NULL Status
A=Application Designer Form
D=In Design
I=Inactivated
S=Supplemental Data Form

3 PORTAL_LABEL Character(30) VARCHAR2(30) NOT NULL Label

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FORM_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Form and Builder Field
2	FORM_TYPE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Status A=Application Designer Form D=In Design I=Inactivated S=Supplemental Data Form
3	PORTAL_LABEL	Character(30)	VARCHAR2(30) NOT NULL	Label