TSE_JHDRFLD_STG (SQL Table)	Index Back
TSE Journal Header Staging Tbl

TSE_JHDRFLD_STG

(SQL Table)

TSE Journal Header Staging Tbl

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 TSE_JOBID Character(10) VARCHAR2(10) NOT NULL TSE Job Identifier

2 TSE_PROC_INSTANCE Number(10,0) DECIMAL(10) NOT NULL TSE Run ID

3 TSE_SET_NBR Number(6,0) INTEGER NOT NULL TSE Set Number

4 TSE_EDIT_TYPE Character(1) VARCHAR2(1) NOT NULL TSE Edit Type
A=Application Edit
D=Date Range Edit
P=Prompt Table Edit
R=Required Field Edit
X=Translate Table Edit
Y=Yes/No Edit

5 TSE_FIELDNAME Character(18) VARCHAR2(18) NOT NULL TSE Field Name

6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

8 MESSAGE_PARM Character(254) VARCHAR2(254) NOT NULL Message Parameter Text

9 MESSAGE_PARM2 Character(30) VARCHAR2(30) NOT NULL Message Parameter 2

10 MESSAGE_PARM3 Character(30) VARCHAR2(30) NOT NULL Message Parameter 3

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

12 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.

13 JOURNAL_DATE Date(10) DATE NOT NULL Specifies the date the journal was created.

14 UNPOST_SEQ Number(2,0) SMALLINT NOT NULL Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	TSE_JOBID	Character(10)	VARCHAR2(10) NOT NULL	TSE Job Identifier
2	TSE_PROC_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	TSE Run ID
3	TSE_SET_NBR	Number(6,0)	INTEGER NOT NULL	TSE Set Number
4	TSE_EDIT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	TSE Edit Type A=Application Edit D=Date Range Edit P=Prompt Table Edit R=Required Field Edit X=Translate Table Edit Y=Yes/No Edit
5	TSE_FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	TSE Field Name
6	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog.
7	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
8	MESSAGE_PARM	Character(254)	VARCHAR2(254) NOT NULL	Message Parameter Text
9	MESSAGE_PARM2	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 2
10	MESSAGE_PARM3	Character(30)	VARCHAR2(30) NOT NULL	Message Parameter 3
11	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
12	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.
13	JOURNAL_DATE	Date(10)	DATE NOT NULL	Specifies the date the journal was created.
14	UNPOST_SEQ	Number(2,0)	SMALLINT NOT NULL	Identifies the sequence of journal entries when a journal is "unposted". When a journal is posted the UnPost Sequence is automatically set to "0". When a journal is unposted, a new reversing entry is automatically created with an UnPost Sequence of "1".