FORM_SRC_VW_LG (SQL View)	Index Back
Form Search Record Form Search Record

FORM_SRC_VW_LG

(SQL View)

Form Search Record

SELECT a.created_by , a.seq_nbr , lg.language_cd , lg.form_subject FROM PS_FORM a , PS_FORM_lg lg WHERE a.seq_nbr = lg.seq_nbr

Related Language Record for FORM_SRC_VW

# 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 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 FORM_SUBJECT Character(100) VARCHAR2(100) NOT NULL Subject

#	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	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
3	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	FORM_SUBJECT	Character(100)	VARCHAR2(100) NOT NULL	Subject