| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
BP_EXPORT_SEQ |
Character(30) |
VARCHAR2(30) NOT NULL |
Export Sequence
|
| 2 |
 BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 3 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
EMPL_RCD_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Employee Record Number
|
| 6 |
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.
|
| 7 |
DISTR_SEQ_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Distribution Seq Nbr
|
| 8 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
|
| 9 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 10 |
ACCOUNT |
Character(10) |
VARCHAR2(10) NOT NULL |
Account
Prompt Table:
%EDITTABLE30
|
| 11 |
ALTACCT |
Character(10) |
VARCHAR2(10) NOT NULL |
Alternate Account
Prompt Table:
%EDITTABLE31
|
| 12 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Prompt Table:
%EDITTABLE32
|
| 13 |
STATISTICS_CODE |
Character(3) |
VARCHAR2(3) NOT NULL |
Statistics Code
Prompt Table:
%EDITTABLE33
|
| 14 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project/Grant
Prompt Table:
%EDITTABLE34
|
| 15 |
BUDGET_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget Period
Prompt Table:
%EDITTABLE35
|
| 16 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit
Prompt Table:
%EDITTABLE11
|
| 17 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
%EDITTABLE12
|
| 18 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product
Prompt Table:
%EDITTABLE13
|
| 19 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
Prompt Table:
%EDITTABLE14
|
| 20 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code
Prompt Table:
%EDITTABLE15
|
| 21 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Public Sector Financials Chart Field.
Prompt Table:
%EDITTABLE16
|
| 22 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference Chartfield
Prompt Table:
%EDITTABLE17
|
| 23 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Public Sector Financials Chart Field
Prompt Table:
%EDITTABLE18
|
| 24 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
Prompt Table:
%EDITTABLE19
|
| 25 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
Prompt Table:
%EDITTABLE20
|
| 26 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield number 1
Prompt Table:
%EDITTABLE21
|
| 27 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
Prompt Table:
%EDITTABLE22
|
| 28 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
Prompt Table:
%EDITTABLE23
|
| 29 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
Prompt Table:
%EDITTABLE24
|
| 30 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table:
%EDITTABLE25
|
| 31 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Resource Type
Prompt Table:
%EDITTABLE26
|
| 32 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
Prompt Table:
%EDITTABLE27
|
| 33 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Resource Category
Prompt Table:
%EDITTABLE28
|
| 34 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Resource Sub Category
Prompt Table:
%EDITTABLE29
|
| 35 |
BP_BNFT_PERCENT |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
% Salary
|
| 36 |
BP_BNFT_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Fixed Amount
|
| 37 |
PERCENTAGE |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
FTE Percentage
|
| 38 |
AMOUNT |
Signed Number(20,3) |
DECIMAL(18,3) NOT NULL |
Commuting Allowance Paid Per Cycle.
|
| 39 |
BP_BUDGET_CENTER1 |
Character(15) |
VARCHAR2(15) NOT NULL |
Budget Center
|
| 40 |
BP_BUDGET_CENTER2 |
Character(15) |
VARCHAR2(15) NOT NULL |
Budget Center 2
|
| 41 |
BP_BUDGET_VERSION |
Character(1) |
VARCHAR2(1) NOT NULL |
Budget Version
|
| 42 |
BP_LEDGER_NAME |
Character(30) |
VARCHAR2(30) NOT NULL |
Ledger Type1
|
| 43 |
BP_BUDG_CNTR_ADV |
Character(30) |
VARCHAR2(30) NOT NULL |
Budget Center
|
| 44 |
LEDGER |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger
|
| 45 |
SCENARIO |
Character(10) |
VARCHAR2(10) NOT NULL |
Scenario
|