SAC_CF_PRMPT3_V (SQL View)	Index Back
SAC Chartfield Template View Use as the prompt record of the Chartfield Template Page..

SAC_CF_PRMPT3_V

(SQL View)

SAC Chartfield Template View

Use as the prompt record of the Chartfield Template Page..

SELECT DISTINCT A.FIELDNAME , A.RECNAME FROM PSRECFIELDDB A WHERE A.FIELDNUM = ( SELECT MIN(B.FIELDNUM) FROM PSRECFIELDDB B WHERE A.RECNAME = B.RECNAME AND A.FIELDNAME = B.FIELDNAME)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

2 PROMPT_RECNAME Character(15) VARCHAR2(15) NOT NULL Prompt record name in Chart field template Prompt record name in Form and Approval Builder

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	PROMPT_RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Prompt record name in Chart field template Prompt record name in Form and Approval Builder