| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 3 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 4 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 5 |
SOURCE_INSTANCE |
Number(15,4) |
DECIMAL(14,4) NOT NULL |
Identifies a Process Instance (PROCESS_INSTANCE), and is used by the PeopleSoft Process Scheduler to save this identifier.
|
| 6 |
BUSINESS_UNIT_IU |
Character(5) |
VARCHAR2(5) NOT NULL |
Specifies the Business Unit for which InterUnit activity is being generated.
|
| 7 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 8 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 9 |
SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the origin of a journal entry and defines journal entry error handling options. The journal source provides a means of selectively tracking, reporting, and inquiring on journal entries. It can be almost anything within the enterprise - a subsystem that generates transactions, a department, or even an individual.
|
| 10 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
|
| 11 |
PROC_PART_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Process Partition ID
|
| 12 |
JOURNAL_ID_FROM |
Character(10) |
VARCHAR2(10) NOT NULL |
Range From Journal ID
|
| 13 |
JOURNAL_ID_TO |
Character(10) |
VARCHAR2(10) NOT NULL |
Range to Journal ID
|
| 14 |
JOURNAL_DATE_FROM |
Date(10) |
DATE |
Journal Date From
|
| 15 |
JOURNAL_DATE_TO |
Date(10) |
DATE |
To Journal Date
|
| 16 |
JRNL_EDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Journal(s)
|
| 17 |
JRNL_BGTCHK_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Budget Check option. Used in Journal Edit request or other GL processes (e.g. Allocations, Closing, Revaluation, ...) to flag if journals will be budget checked after they are edited valid.
|
| 18 |
JRNL_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Journal(s)
|
| 19 |
JRNL_UNPOST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
UnPost Journal(s)
|
| 20 |
JRNL_DELETE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Posted Journal(s)
L=Logical Delete
P=Physical Delete
R=Retain/Do Not Delete
|
| 21 |
JRNL_REEDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Edit Previously Edited
|
| 22 |
JRNL_REEDIT_OPTN2 |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Edit Commitment Control Adjustment Journals
|
| 23 |
MARK_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
|
| 24 |
RECALC_EXCHNG_RT |
Character(1) |
VARCHAR2(1) NOT NULL |
Yes/No Indicator
|
| 25 |
AUTOPLT_RUNCNTL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This run control is for autopilot. Used to edit process request parameters for values that don't make sense for recurring process.
Y/N Table Edit
Default Value: N
|
| 26 |
MULTI_SEL_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Select Option
Y/N Table Edit
Default Value: N
|
| 27 |
RECNAME_MSEL |
Character(15) |
VARCHAR2(15) NOT NULL |
Multiple Select Record name.
|
| 28 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 29 |
PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
A=Active
C=Successfully Completed
E=Completed With Errors
N=Not Yet Processed
P=Processing Now
X=No Success
|
| 30 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 31 |
RUN_ONLINE_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Process run in online mode or not
Y/N Table Edit
Default Value: N
|
| 32 |
DTTM_STAMP_SEC |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 33 |
COMMITMENT_CNTL_GL |
Character(1) |
VARCHAR2(1) NOT NULL |
Commitment Control on GL
|
| 34 |
ALTACCT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Alternate Account
|
| 35 |
PC |
Character(1) |
VARCHAR2(1) NOT NULL |
Projects
|
| 36 |
DELETE_LIMIT |
Number(12,0) |
DECIMAL(12) NOT NULL |
Used in GL AE batch processes to perform deletes rather than truncate.
|
| 37 |
ACTIVE_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Flag
A=Active
I=Inactive
|
| 38 |
ALL_FROM_JE_PANEL |
Character(1) |
VARCHAR2(1) NOT NULL |
All From Journal Entry Panels
|
| 39 |
JOURNAL_DATE_NEW |
Date(10) |
DATE |
New Journal Date
|
| 40 |
JRNL_ERR_HEADERS |
Number(9,0) |
DECIMAL(9) NOT NULL |
# of Journal Headers in Error
|
| 41 |
JRNL_ERR_LINES |
Number(9,0) |
DECIMAL(9) NOT NULL |
# of Journal Lines In Error
|
| 42 |
EDIT_CHARTFIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit ChartField Values
Y/N Table Edit
Default Value: Y
|
| 43 |
WHERE_TXT_LONG |
Long Character(4000) |
CLOB |
Where clause
|
| 44 |
AE_APPSTATUS |
Number(1,0) |
SMALLINT NOT NULL |
AE Application Warning Status
|
| 45 |
KK_PROCESS_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Status
E=Errors Exist
I=Document in process
N=Process Unsuccessful
P=Provisionally Valid
V=No Errors or Warnings
W=Only Warnings Exist
X=Unrecorded Errors Exist
|
| 46 |
BAL_SHEET_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Balance Sheet Indicator Active Flag
Y/N Table Edit
Default Value: N
|
| 47 |
BOOK_CODE_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Book Code Active Flag
Y/N Table Edit
Default Value: N
|
| 48 |
FIRST_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
First Request Flag
Y/N Table Edit
Default Value: Y
|
| 49 |
GLJE_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Entry Mode
|
| 50 |
RECNAME_HEADER |
Character(15) |
VARCHAR2(15) NOT NULL |
Header Record
|
| 51 |
RECNAME_LINE |
Character(15) |
VARCHAR2(15) NOT NULL |
Line Record
|
| 52 |
SCE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Scenario ID
|
| 53 |
RTBL_MODE |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Mode
Y/N Table Edit
Default Value: N
|
| 54 |
RTBL_COMBO_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
RTBL Combination Edit Flag
Y/N Table Edit
Default Value: N
|
| 55 |
USE_GTT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Global Temp Table Flag
Y/N Table Edit
Default Value: N
|
| 56 |
SQLROWS_2 |
Number(12,0) |
DECIMAL(12) NOT NULL |
Used in AE
|
| 57 |
GL_APPROVAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Submit for Approval
Default Value: N
|