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

SAC_CF_PRMPT1_V

(SQL View)

SAC Chartfield Template View

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

SELECT DISTINCT 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 ORIG_CF_NAME Character(18) VARCHAR2(18) NOT NULL Holds the Original Chartfield Name. This will not change!