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

SAC_CF_PRMPT2_V

(SQL View)

SAC Chartfield Template View

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

SELECT A.FIELDNAME 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).