KK_AF_JID_VW (SQL View)	Index Back
Journal ID Prompt For AF Journal ID Prompt For AF Setting the OPRID field as the first key will force the component processor to auto filter out the data per the current sign-in user ID.

KK_AF_JID_VW

(SQL View)

Journal ID Prompt For AF

Journal ID Prompt For AF Setting the OPRID field as the first key will force the component processor to auto filter out the data per the current sign-in user ID.

SELECT DISTINCT %subrec(KK_AF_JID_VW,J) FROM PS_KK_AF_SRCH_VW J

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 JOURNAL_ID Character(10) VARCHAR2(10) NOT NULL Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.

3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

4 JOURNAL_DATE Date(10) DATE Specifies the date the journal was created.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	JOURNAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Identifies a journal entry, consisting of a header and one or more lines. The Journal ID itself does not have to be unique, but together with the journal business unit and journal date, it forms a unique journal identifier.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	JOURNAL_DATE	Date(10)	DATE	Specifies the date the journal was created.