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

GP_ABS_RCALSVW

(SQL View)

Template Record Alias View

Configurable Sections: 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_GP_ABS_RECDEFN A , PSRECDEFN B WHERE B.RECNAME = A.RECNAME

Related Language Record: GP_ABS_RCALVWL

# 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: GP_ABS_CS_RECVW

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: GP_ABS_CS_RECVW
4	INSTANCE	Number(3,0)	SMALLINT NOT NULL	Instance Number
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description