| # |
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 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
Default Value: 9999
|
| 4 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table:
SP_SETID_NONVW
|
| 5 |
CONSOLIDATION_SET |
Character(10) |
VARCHAR2(10) NOT NULL |
Consolidation Set
Prompt Table:
CONSOL_TBL
|
| 6 |
TREE_NAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Tree Name
Prompt Table:
TREE_FLDNAME_VW
|
| 7 |
CREATE_JRNL_ENTRY |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Journal Entries
Y/N Table Edit
Default Value: Y
|
| 8 |
CREATE_LOG_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Calculation Log
Y/N Table Edit
Default Value: N
|
| 9 |
UNDO_PREV_PROCESS |
Character(1) |
VARCHAR2(1) NOT NULL |
Undo Previous Process
Y/N Table Edit
Default Value: N
|
| 10 |
UNDO_PREVPROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Undo Options
C=Matching Request Parameters
L=Selected from List
Default Value: C
|
| 11 |
AS_OF_DATE |
Date(10) |
DATE NOT NULL |
As of Date
Default Value: %date
|
| 12 |
INCLUDE_ADJ_PER |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Adjustment Period(s)
Y/N Table Edit
Default Value: N
|
| 13 |
TREE_SCOPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Scope of Consolidation
C=Process the Whole Tree
L=Process a Level
S=Process a Tree Node
Default Value: C
|
| 14 |
TREE_NODE |
Character(20) |
VARCHAR2(20) NOT NULL |
Node name
Prompt Table:
TREE_NODE_VW
|
| 15 |
TREE_LEVEL |
Character(10) |
VARCHAR2(10) NOT NULL |
Tree Level Number
Prompt Table:
TREE_LEVEL_VW
|
| 16 |
TREE_DATE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Tree Effective Date Option
A=Use As of Date
E=Use Period End Date
O=Use Override Date
Default Value: A
|
| 17 |
DATE_OVERRIDE |
Date(10) |
DATE |
Use Date override
|
| 18 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
Default Value: N
|
| 19 |
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
Default Value: N
|
| 20 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
Default Value: N
|
| 21 |
PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 22 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
CURRENCY_CD_TBL
|
| 23 |
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.
|
| 24 |
JRNL_EDIT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Edit Journal(s)
Y/N Table Edit
Default Value: N
|
| 25 |
JRNL_POST_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Journal(s)
Y/N Table Edit
Default Value: N
|
| 26 |
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.
Y/N Table Edit
Default Value: N
|
| 27 |
DONOT_DELETE_JRNL |
Character(1) |
VARCHAR2(1) NOT NULL |
Journal Delete Option
N=Physical Delete
X=Retain/Do Not Delete
Y=Mark as Deleted
Default Value: N
|
| 28 |
INCL_LOW_NODES_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Include Lower Level Nodes
Y/N Table Edit
Default Value: N
|