| # |
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 |
REQUEST_BOOK |
Character(10) |
VARCHAR2(10) NOT NULL |
Request Book
|
| 8 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 9 |
FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 10 |
ASSET_ID_FROM |
Character(12) |
VARCHAR2(12) NOT NULL |
From Asset ID
|
| 11 |
ASSET_ID_TO |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset ID to
|
| 12 |
ACCOUNTING_PERIOD |
Number(3,0) |
SMALLINT NOT NULL |
Identifies a time period to which you post transactions. Typically, an accounting period represents a month, but it can also represent a week, a day, or any user-defined interval. An accounting period has a beginning date and an ending date, and is defined in the calendar table.
|
| 13 |
START_PD |
Number(3,0) |
SMALLINT NOT NULL |
Start Period
|
| 14 |
END_PD |
Number(3,0) |
SMALLINT NOT NULL |
End Period
|
| 15 |
BEGIN_DT |
Date(10) |
DATE |
Begin Date
|
| 16 |
END_DT |
Date(10) |
DATE |
End Date
|
| 17 |
CF_SEQNO |
Number(6,0) |
INTEGER NOT NULL |
Chartfield Sequence Number
|
| 18 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
|
| 19 |
CAL_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Calendar SetID
|
| 20 |
CATEGORY_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Category SetID
|
| 21 |
RERUN_JOB |
Character(1) |
VARCHAR2(1) NOT NULL |
Re-Run Existing Run Control ID
|
| 22 |
DEPR_TOTAL |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Depreciation Total
|
| 23 |
TOTAL_ALLOC |
Number(20,15) |
DECIMAL(19,15) NOT NULL |
Total Allocation
|
| 24 |
DECIMAL_POSITIONS |
Number(2,0) |
SMALLINT NOT NULL |
Decimal Positions
|
| 25 |
GL_BEGIN_DT |
Date(10) |
DATE |
|
| 26 |
GL_END_DT |
Date(10) |
DATE |
|
| 27 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 28 |
LEASE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Leased Assets
|
| 29 |
AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Amount
|
| 30 |
LEDGER_GROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Ledger Group
|
| 31 |
COST_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Cost Type
|
| 32 |
PYMNT_DT |
Date(10) |
DATE |
Payment Date
|
| 33 |
PYMNT_CNT |
Number(5,0) |
INTEGER NOT NULL |
Payments
|
| 34 |
TOTAL_COST_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cost Amount
|
| 35 |
CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Category
|
| 36 |
DEPR |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Depreciation Amt
|
| 37 |
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
|
| 38 |
DISTRIBUTION_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
Distribution Type
|
| 39 |
EXIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Exist
|
| 40 |
CALENDAR_ID |
Character(2) |
VARCHAR2(2) NOT NULL |
Calendar ID
|
| 41 |
PD_ALLOC |
Number(19,15) |
DECIMAL(18,15) NOT NULL |
Period Allocation
|
| 42 |
PD_ALLOC_TOTAL |
Number(19,15) |
DECIMAL(18,15) NOT NULL |
Total Allocation Periods
|
| 43 |
LENGTH_MAX |
Number(5,0) |
INTEGER NOT NULL |
Maximum Length
|
| 44 |
BUDGET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Create budgeted depreciation
|
| 45 |
PROCESS_FREQUENCY |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Frequency
A=Always Process
N=Don't Run
O=Process Once
|
| 46 |
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
|
| 47 |
PROCESS_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Origin
N=Other Source
P=Process Scheduler
|
| 48 |
PARALLEL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Process in Parallel
N=Synchronous Processing
Y=Parallel Processing
|
| 49 |
PROCESSING_SEQ |
Number(5,0) |
INTEGER NOT NULL |
Processing Sequence
|
| 50 |
AS_OF_DATE |
Date(10) |
DATE |
As of Date
|
| 51 |
RERUN_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Rerun depreciation close
|
| 52 |
REVERSAL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Reversal SW
|
| 53 |
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
|
| 54 |
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. "
|
| 55 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
|
| 56 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
|
| 57 |
OPERATING_UNIT |
Character(8) |
VARCHAR2(8) NOT NULL |
Operating Unit ChartField
|
| 58 |
PRODUCT |
Character(6) |
VARCHAR2(6) NOT NULL |
Product ChartField
|
| 59 |
FUND_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Fund Code
|
| 60 |
CLASS_FLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Class Field
|
| 61 |
PROGRAM_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Program Code ChartField
|
| 62 |
BUDGET_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Budget Reference
|
| 63 |
AFFILIATE |
Character(5) |
VARCHAR2(5) NOT NULL |
Affiliate
|
| 64 |
AFFILIATE_INTRA1 |
Character(10) |
VARCHAR2(10) NOT NULL |
IntraUnit Affiliate1
|
| 65 |
AFFILIATE_INTRA2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Operating Unit Affiliate
|
| 66 |
CHARTFIELD1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion chartfield 1
|
| 67 |
CHARTFIELD2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 2
|
| 68 |
CHARTFIELD3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Expansion Chartfield 3
|
| 69 |
BUSINESS_UNIT_PC |
Character(5) |
VARCHAR2(5) NOT NULL |
PC Business Unit
|
| 70 |
ACTIVITY_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Activity ID
|
| 71 |
RESOURCE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Source Type
|
| 72 |
RESOURCE_CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Category
|
| 73 |
RESOURCE_SUB_CAT |
Character(5) |
VARCHAR2(5) NOT NULL |
Subcategory
|
| 74 |
ANALYSIS_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Analysis Type
|
| 75 |
PERIOD_DEPR |
Signed Number(29,4) |
DECIMAL(27,4) NOT NULL |
Period Depreciation
|
| 76 |
OBLIGATION_REM |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
|
| 77 |
TEMPLATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate whether a given bank transfer transaction should be designated as a
|
| 78 |
BREAK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
|
| 79 |
SECD_BOOK_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondary Book Switch
|
| 80 |
SECD_BOOK_CNT |
Number(3,0) |
SMALLINT NOT NULL |
Secondary Book Count
|
| 81 |
FIRST_PASS_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
First Pass Switch
|
| 82 |
DTTM_STAMP |
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.
|
| 83 |
AE_WHERE_CLAUSE |
Character(254) |
VARCHAR2(254) NOT NULL |
Dynamic where clause
|
| 84 |
AE_WHERE_1 |
Character(50) |
VARCHAR2(50) NOT NULL |
AE_WHERE_1
|
| 85 |
BKC_DIST_GRP |
Character(10) |
VARCHAR2(10) NOT NULL |
Book Code Distribution Code
|
| 86 |
BOOK_IS_SECD |
Character(1) |
VARCHAR2(1) NOT NULL |
Secondary Book Switch
Default Value: N
|
| 87 |
GL_DISTRIB_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Distribution Status
C=Available to Contracts
D=Distributed
G=Generated
H=Hold
I=Ignored
J=Creating Journals
M=Modified
N=None
P=To be processed
X=Waiting for Reversal
|
| 88 |
TEMP_FLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Temporary Field for App Engine
|
| 89 |
CURRENT_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Current Datetime Stamp
|
| 90 |
ARO_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Asset Retirement Obligations
N=No
Y=Yes
|
| 91 |
PROFILE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid
|
| 92 |
COUNT_01 |
Number(8,0) |
INTEGER NOT NULL |
Count
|
| 93 |
COST_TYPE_RE |
Character(1) |
VARCHAR2(1) NOT NULL |
Rent Expense Cost Type
|
| 94 |
COST_TYPE_LI |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Incentive Cost Type
|
| 95 |
COST_TYPE_LR |
Character(1) |
VARCHAR2(1) NOT NULL |
Lease Remeasurement Cost Type
|
| 96 |
RE_NEW_AC_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
New RE Acct Rule Flag
|
| 97 |
TXN_AMOUNT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Transaction Amount
|
| 98 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
|
| 99 |
RATE_MULT |
Signed Number(17,8) |
DECIMAL(15,8) NOT NULL |
Rate Multiplier
|
| 100 |
RATE_DIV |
Number(16,8) |
DECIMAL(15,8) NOT NULL |
Rate Divisor
|
| 101 |
FISCAL_YEAR2 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 102 |
ACCOUNTING_PERIOD2 |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|
| 103 |
FISCAL_YEAR3 |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 104 |
ACCOUNTING_PERIOD3 |
Number(3,0) |
SMALLINT NOT NULL |
Accounting Period
|