HR_TBH_RECALSVW (SQL View)	Index Back
Template Record Alias View Prompt view used to select the record on the Template Section Setup page. It uses the record alias instead of the record name.

HR_TBH_RECALSVW

(SQL View)

Template Record Alias View

Prompt view used to select the record on the Template Section Setup page. It uses the record alias instead of the record name.

SELECT A.ALIAS_TBL_NAME , A.EFF_STATUS , A.RECNAME , A.INSTANCE , B.RECDESCR FROM PS_HR_TBH_RECDEFN A , PSRECDEFN B WHERE B.RECNAME = A.RECNAME

Related Language Record: HR_TBH_RECALVWL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ALIAS_TBL_NAME Character(18) VARCHAR2(18) NOT NULL Alias Table Name

2 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: HR_TBH_RECLKPVW

4 INSTANCE Number(3,0) SMALLINT NOT NULL Instance Number

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ALIAS_TBL_NAME	Character(18)	VARCHAR2(18) NOT NULL	Alias Table Name
2	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
3	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: HR_TBH_RECLKPVW
4	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description