GPFR_AF_FUNC_VW (SQL View)	Index Back
Function Name View Application Framework - Used as prompt table for record field GPFR_AF_EMPFUNC.GPFR_AF_FUNCT_NM

GPFR_AF_FUNC_VW

(SQL View)

Function Name View

Application Framework - Used as prompt table for record field GPFR_AF_EMPFUNC.GPFR_AF_FUNCT_NM

SELECT DISTINCT COUNTRY ,GPFR_AF_APPL ,GPFR_AF_FUNCT_NM FROM PS_GPFR_AF_PRMTMPT WHERE GPFR_AF_PRM_SCOPE = 'EED'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

2 GPFR_AF_APPL Character(10) VARCHAR2(10) NOT NULL Application Framework - Application

3 GPFR_AF_FUNCT_NM Character(16) VARCHAR2(16) NOT NULL Application Framework - Function

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country
2	GPFR_AF_APPL	Character(10)	VARCHAR2(10) NOT NULL	Application Framework - Application
3	GPFR_AF_FUNCT_NM	Character(16)	VARCHAR2(16) NOT NULL	Application Framework - Function