SJE_NU_JNLS_TMP (SQL Table)	Index Back
SJE New Journals temp For SJE. Holds a list of the new journal dates to be generated. The "composite key" is a concatenation of key values to make it easy to step through them.

SJE_NU_JNLS_TMP

(SQL Table)

SJE New Journals temp

For SJE. Holds a list of the new journal dates to be generated. The "composite key" is a concatenation of key values to make it easy to step through them.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 COMPOSITE_KEY Character(35) VARCHAR2(35) NOT NULL For SJE. Holds a concatenation of the keys of the SJE_DATE table in a temp table, for ease of walking through the rows.

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

4 SJE_ID Character(10) VARCHAR2(10) NOT NULL Standard Journal

5 SEQ_NUM Number(3,0) SMALLINT NOT NULL Sequence

6 NEW_JOURNAL_DATE Date(10) DATE New Journal Date

7 RUN_DT Date(10) DATE Run Date

8 JRNL_DAY_IN_PER Number(3,0) SMALLINT NOT NULL For SJE. The day within a period (e.g. "day #10") when the user wants standard journals to be generated. This indicates the date stamped on the journal, not the run date for generating it.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	COMPOSITE_KEY	Character(35)	VARCHAR2(35) NOT NULL	For SJE. Holds a concatenation of the keys of the SJE_DATE table in a temp table, for ease of walking through the rows.
3	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
4	SJE_ID	Character(10)	VARCHAR2(10) NOT NULL	Standard Journal
5	SEQ_NUM	Number(3,0)	SMALLINT NOT NULL	Sequence
6	NEW_JOURNAL_DATE	Date(10)	DATE	New Journal Date
7	RUN_DT	Date(10)	DATE	Run Date
8	JRNL_DAY_IN_PER	Number(3,0)	SMALLINT NOT NULL	For SJE. The day within a period (e.g. "day #10") when the user wants standard journals to be generated. This indicates the date stamped on the journal, not the run date for generating it.