| # |
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 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUS_UNIT_TBL_GL
|
| 5 |
BP_LEDGER_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Ledger Type1
|
| 6 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
%EDITTABLE30
|
| 7 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
%EDITTABLE31
|
| 8 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
%EDITTABLE32
|
| 9 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
Prompt Table:
%EDITTABLE33
|
| 10 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project/Grant
Prompt Table:
%EDITTABLE34
|
| 11 |
BUDGET_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget Period
Prompt Table:
%EDITTABLE35
|
| 12 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit
Prompt Table:
%EDITTABLE11
|
| 13 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
%EDITTABLE12
|
| 14 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product
Prompt Table:
%EDITTABLE13
|
| 15 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
%EDITTABLE14
|
| 16 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code
Prompt Table:
%EDITTABLE15
|
| 17 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Public Sector Financials Chart Field.
Prompt Table:
%EDITTABLE16
|
| 18 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference Chartfield
Prompt Table:
%EDITTABLE17
|
| 19 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Public Sector Financials Chart Field
Prompt Table:
%EDITTABLE18
|
| 20 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDITTABLE19
|
| 21 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate2
Prompt Table:
%EDITTABLE20
|
| 22 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield number 1
Prompt Table:
%EDITTABLE21
|
| 23 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
%EDITTABLE22
|
| 24 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
%EDITTABLE23
|
| 25 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Business Unit
Prompt Table:
%EDITTABLE24
|
| 26 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDITTABLE25
|
| 27 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Type
Prompt Table:
%EDITTABLE26
|
| 28 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDITTABLE27
|
| 29 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Category
Prompt Table:
%EDITTABLE28
|
| 30 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Costing Resource Sub Category
Prompt Table:
%EDITTABLE29
|
| 31 |
RESOURCE_ID |
Character(40) |
VARCHAR2(40) NOT NULL |
Resource ID
|
| 32 |
WHERE_CLAUSE |
Long Character(500) |
VARCHAR2(500) |
Where Clause
|
| 33 |
WHERE_CLAUSE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Clause
|
| 34 |
SEQNO |
Number(5,0) |
INTEGER NOT NULL |
Sequence Number
|
| 35 |
TOTAL_CNT |
Number(4,0) |
SMALLINT NOT NULL |
Total Objects
|
| 36 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 37 |
BP_NO_OF_ROWS |
Number(10,0) |
DECIMAL(10) NOT NULL |
Number of Rows Processsed
|
| 38 |
AMOUNT |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Commuting Allowance Paid Per Cycle.
|
| 39 |
PLAN_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Identifies a category of benefit plan, such as Medical, Dental, and Life (Insurance). A set of plan type codes, as well as rules for creating new codes, is provided by PeopleSoft. Plan Type codes determine how the system processes and defines eligibility for the various benefit plans.
|
| 40 |
BD_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Budget Sequence Number
|
| 41 |
EFFDT |
Date(10) |
DATE |
Effective Date
Default Value: %date
|
| 42 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 43 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 44 |
EMPL_RCD_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Employee Record Number
|
| 45 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 46 |
BP_OVERRIDE_SCN |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Scenario
Y/N Table Edit
Default Value: N
|
| 47 |
SCENARIO2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget Scenario
|
| 48 |
FISCAL_YEAR2 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 49 |
BP_EXCLUDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Excluded Positions
Y/N Table Edit
Default Value: N
|
| 50 |
WHERECHUNK_FACT |
Character(254) |
VARCHAR2(254) NOT NULL |
Where Chunk
|
| 51 |
BP_BC_SKIP_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Center skip flag.
|
| 52 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
|
| 53 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
FTE Percentage
|