| # |
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 |
PANELNAME |
Character(18) |
VARCHAR2(18) NOT NULL |
Panelname
|
| 4 |
TABLE_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Table Name
|
| 5 |
NUM_TIMES |
Number(3,0) |
SMALLINT NOT NULL |
Number of Times to Repeat
|
| 6 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 7 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 8 |
REQUEST_NBR |
Number(4,0) |
SMALLINT NOT NULL |
Request Number
|
| 9 |
FLEX_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Flexible Analysis Template
|
| 10 |
SEQ_NBR |
Number(15,0) |
DECIMAL(15) NOT NULL |
Sequence Number
|
| 11 |
ANALYSIS_GROUP |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis Group
|
| 12 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 13 |
PC_BUDGET_ID |
Number(3,0) |
SMALLINT NOT NULL |
Budget Plan ID
|
| 14 |
BUDGET_PERIOD |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Period
|
| 15 |
PC_BUDGET_ITEM |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Budgeting: Budget Item
11/15/2004- FS - Added label COST_BUDGET_ITEM
|
| 16 |
PC_BUD_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field defines a Projects Budget as either Cost or Revenue Based.
C=Cost Budget
R=Revenue Budget
|
| 17 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 18 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 19 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 20 |
START_DT |
Date(10) |
DATE |
Start Date
|
| 21 |
END_DT |
Date(10) |
DATE |
End Date
|
| 22 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 23 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 24 |
SELECT_PARM |
Character(254) |
VARCHAR2(254) NOT NULL |
Dynamic Where Clause Sel Parms
|
| 25 |
WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 26 |
GROUP_BY_TEXT |
Character(254) |
VARCHAR2(254) NOT NULL |
Group by text
|
| 27 |
SQL_STMT_254 |
Character(254) |
VARCHAR2(254) NOT NULL |
An internal work field that contains SQL text that is to be utilized in treasury application p
|
| 28 |
DO_SECTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Do AE Section
|
| 29 |
TEMP_VALUE |
Character(18) |
VARCHAR2(18) NOT NULL |
Temporary Query Value
|
| 30 |
HEADING |
Character(30) |
VARCHAR2(30) NOT NULL |
Field Heading
|
| 31 |
BUPRJACT_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
BU/Proj/Act Option
A=Business Unit/Project/Activity
B=Business Unit
E=All
P=Business Unit/Project
|
| 32 |
DATE_RANGE_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Date Option
A=Accounting Date
E=All
T=Transaction Date
|
| 33 |
FROM_DATE |
Date(10) |
DATE |
From Date
|
| 34 |
THRU_DATE |
Date(10) |
DATE |
Through Date
|
| 35 |
WHERE_CLAUSE_LONG |
Long Character(4000) |
CLOB |
Where Clause
|
| 36 |
RESOURCE_ID_FROM |
Character(40) |
VARCHAR2(40) NOT NULL |
Original Transaction ID
|
| 37 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Transaction ID
|
| 38 |
INTFC_ID |
Number(8,0) |
INTEGER NOT NULL |
Interface ID
|
| 39 |
LOAD_STATUS |
Character(3) |
VARCHAR2(3) NOT NULL |
/* -> JMZ. PSOFT. 11-OCT-2002 */
New Status were added : HLD and INP for Asset Management.
/* <- JMZ. PSOFT. 11-OCT-2002 */
CON=Consolidated
DON=Loaded
ERR=Errored
EXC=Excluded
HLD=On Hold
INP=In Process
NEW=Pending
PGI=PO Grp Incomplete
REP=Replaced
UNI=Unitized
|
| 40 |
SUMMARY_ACT |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity is summary or detail.
N=Detail Activity
Y=Summary Activity
|
| 41 |
PARENT_ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
An Activity that is the parent of another Activity within a WBS tree structure.
|
| 42 |
TREE_LEVEL_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Parent tree level if this is a part of the PSTREEBRANCH record
|
| 43 |
PC_REFRSH_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Refresh Type
ACT=Actuals Refresh
BUD=Budget Refresh
F=Full
P=Partial
|
| 44 |
PC_WEIGHT_POINTS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Weight Points
|
| 45 |
UNIT_OF_MEASURE |
Character(3) |
VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 46 |
WORK_CNT |
Number(10,0) |
DECIMAL(10) NOT NULL |
Count of Anything
|
| 47 |
BUDGET_UOM |
Character(3) |
VARCHAR2(3) NOT NULL |
Budgeted Unit of Measure
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
|
| 48 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 49 |
CURRENCY_CD_PC |
Character(3) |
VARCHAR2(3) NOT NULL |
Projects BU Currency
|
| 50 |
RESOURCE_QUANTITY |
Signed Number(16,2) |
DECIMAL(14,2) NOT NULL |
Quantity
|
| 51 |
FOREIGN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Specifies the monetary amount of a debit or credit (accounting entry line) in the entry currency of the item. The sum of FOREIGN_AMOUNT values on AR lines should equal the ENTRY_AMT on the pending item.
|
| 52 |
FOREIGN_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Foreign Currency Code
|
| 53 |
AE_APPLID |
Character(12) |
VARCHAR2(12) NOT NULL |
Program Name (see PSAEAPPLDEFN).
|
| 54 |
AE_SECTION |
Character(8) |
VARCHAR2(8) NOT NULL |
Section
|