| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 PROCESS_INSTANCE |
Number(10,0) |
DECIMAL(10) NOT NULL |
Process Instance
|
| 2 |
REQUEST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Request ID
|
| 3 |
OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 4 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 5 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 6 |
BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Book Name
|
| 7 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 8 |
FROM_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
From Asset ID
|
| 9 |
TO_ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
To Asset ID
|
| 10 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 11 |
FISCAL_MONTH |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Month
|
| 12 |
START_PD |
Number(3,0) |
SMALLINT NOT NULL |
Start Period
|
| 13 |
END_PD |
Number(3,0) |
SMALLINT NOT NULL |
End Period
|
| 14 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 15 |
END_DT |
Date(10) |
DATE |
End Date
|
| 16 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 17 |
CAL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar SetID
|
| 18 |
CATEGORY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category SetID
|
| 19 |
RERUN_JOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Run Existing Run Control ID
|
| 20 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 21 |
GL_BEGIN_DT |
Date(10) |
DATE |
|
| 22 |
GL_END_DT |
Date(10) |
DATE |
|
| 23 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 24 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 25 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 26 |
CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Category
|
| 27 |
TRANS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Types of Asset Management Transactions
ACR=Accretion Expense
ADD=Asset Addition
ADJ=Asset Cost Adjustment
BKS=Book Adjustment
BUD=Budgeted Depreciation
DPR=Depreciation
INF=Inflation Adjustment
LEX=Lease Expense
LPB=Budgeted Lease Payments
LPY=Lease Payment
PDP=Prior Period Depreciation
PLP=Prior Lease Payment
RAD=Manual Reserve Adjustment
RCT=Asset Recategorization
REI=Asset Reinstatement
RES=Resume Depreciation
RET=Asset Retirement
RRC=Retro rate change for grp ast
SUS=Suspend Depreciation
TRF=Asset Transfer
|
| 28 |
EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Exist
|
| 29 |
BUDGET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Create budgeted depreciation
|
| 30 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 31 |
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
|
| 32 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 33 |
PARALLEL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Process in Parallel
N=Synchronous Processing
Y=Parallel Processing
|
| 34 |
PROCESSING_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Processing Sequence
|
| 35 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 36 |
RERUN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Rerun depreciation close
|
| 37 |
REVERSAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal SW
|
| 38 |
PARTIAL_RANGE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Process a range of assets
N=Do not process a partial range
Y=Process a partial range
|
| 39 |
TOT_OBLIGATION |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Lease Total Obligation
|
| 40 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
"Specifies the primary currency for a general ledger business unit, and is sometimes referred to as the ""book"" currency. Each business unit has one base currency. which is usually, but not always, the local currency for the organization. Journal entries are posted to a business unit in its base currency. "
|
| 41 |
CF_SEQNO |
Number(6,0) |
INTEGER NOT NULL |
Chartfield Sequence Number
|
| 42 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 43 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 44 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
|
| 45 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
|
| 46 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 47 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
|
| 48 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
|
| 49 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
|
| 50 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
|
| 51 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 52 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
|
| 53 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
|
| 54 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 55 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 56 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 57 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 58 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 59 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 60 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 61 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 62 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 63 |
RT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
|
| 64 |
AE_WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Dynamic where clause
|