FS_CF_PROMPT (SQL Table)	Index Back
Affiliate Chartfield Prompt Prompt for Affiliate Chartfield

FS_CF_PROMPT

(SQL Table)

Affiliate Chartfield Prompt

Prompt for Affiliate Chartfield

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 PROMPT_TBL Character(15) VARCHAR2(15) NOT NULL Prompt Table
Prompt Table: RECDEFN_VW

3 PROMPT_TBL2 Character(15) VARCHAR2(15) NOT NULL Prompt Table 2
Prompt Table: RECDEFN_VW

4 CF_ACTIVE_STATUS Character(1) VARCHAR2(1) NOT NULL The user can specify CF to be Active, Inactive or Deleted. This field was formerly called User Option.
A=Active ChartField
D=Delete
I=Inactive ChartField

5 USE_BY_PRODUCT Character(5) VARCHAR2(5) NOT NULL Will tell which product uses this chartfield.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
2	PROMPT_TBL	Character(15)	VARCHAR2(15) NOT NULL	Prompt Table Prompt Table: RECDEFN_VW
3	PROMPT_TBL2	Character(15)	VARCHAR2(15) NOT NULL	Prompt Table 2 Prompt Table: RECDEFN_VW
4	CF_ACTIVE_STATUS	Character(1)	VARCHAR2(1) NOT NULL	The user can specify CF to be Active, Inactive or Deleted. This field was formerly called User Option. A=Active ChartField D=Delete I=Inactive ChartField
5	USE_BY_PRODUCT	Character(5)	VARCHAR2(5) NOT NULL	Will tell which product uses this chartfield.