GP_ABS_RCDFVWL (SQL View)	Index Back
Template Record View Configurable Sections: This is the related-language record for the Template Record View, which is the search view for the Template Record/Field Setup component. This view will exlcude the Instance Number and join the Template Record Setup Table to the PeopleTools Record Definition table so as to include the record name in field prompts.

GP_ABS_RCDFVWL

(SQL View)

Template Record View

Configurable Sections: This is the related-language record for the Template Record View, which is the search view for the Template Record/Field Setup component. This view will exlcude the Instance Number and join the Template Record Setup Table to the PeopleTools Record Definition table so as to include the record name in field prompts.

SELECT A.RECNAME , B.LANGUAGE_CD , B.RECDESCR FROM PS_HR_TBH_RECDEFN A , PSRECDEFNLANG B WHERE A.INSTANCE = 1 AND B.RECNAME = A.RECNAME

Related Language Record for GP_ABS_RCDEFVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

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

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description