| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 ORIGINATOR_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Originator
|
| 2 |
DATE_SUBMITTED |
Date(10) |
DATE |
Date Submitted
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
SP_BU_AM_NONVW
|
| 4 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
|
| 5 |
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.
|
| 6 |
ROLEUSER |
Character(30) |
VARCHAR2(30) NOT NULL |
Role User
|
| 7 |
APPROVER_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Approver ID
|
| 8 |
DATE_APPROVED |
Date(10) |
DATE |
Date Approved
|
| 9 |
APPR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending
|
| 10 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 11 |
TAG_NUMBER |
Character(12) |
VARCHAR2(12) NOT NULL |
Tag Number
|
| 12 |
SERIAL_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Serial ID
|
| 13 |
CATEGORY |
Character(5) |
VARCHAR2(5) NOT NULL |
Asset Category
|
| 14 |
COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Total Cost
|
| 15 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
|
| 16 |
QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Qty Interface
|
| 17 |
PROCEEDS |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Retirement Proceeds
|
| 18 |
TXN_CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency
Prompt Table:
CURR_TXN_VW1
|
| 19 |
REMOVAL_COST |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Removal Cost
|
| 20 |
TXN_CURRENCY_CD1 |
Character(3) |
VARCHAR2(3) NOT NULL |
Transaction Currency Display
Prompt Table:
CURR_TXN_VW
|
| 21 |
RETIRE_QUANTITY |
Signed Number(17,4) |
DECIMAL(15,4) NOT NULL |
Retirement Quantity
|
| 22 |
DISPOSAL_CODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Retirement Type
A=Abandonment
C=Cannibalize for Other Assets
D=Disappeared Assets
E=Expensed
F=Disposal Due to Theft
I=Returned to Inventory
L=Like Kind Exchange
M=Missing Asset
N=Donated to External Group
O=ARO Settlement
R=Scrapped Assets
S=Retirement by Sale
T=Traded In for another Asset
V=Auto-Retire Fully Depr Assets
Y=Casualty Loss
Prompt Table:
DISP_CODE_VW
|
| 23 |
RETIREMENT_DT |
Date(10) |
DATE |
Projected Retirement Date
|
| 24 |
TRANS_CODE |
Character(5) |
VARCHAR2(5) NOT NULL |
Transaction Code
Prompt Table:
TRANS_CODE_VW
|
| 25 |
TRANS_DT |
Date(10) |
DATE |
Transaction Date
|
| 26 |
ACCOUNTING_DT |
Date(10) |
DATE |
The accounting entry construction date for a given transaction (a generic field that crosses multiple
|
| 27 |
CONVENTION |
Character(2) |
VARCHAR2(2) NOT NULL |
Book Depreciation Convention
or Cost Convention
Prompt Table:
CONV_BU_VW
|
| 28 |
PROCEEDS_PERCENT |
Number(18,12) |
DECIMAL(17,12) NOT NULL |
Ratio of total proceeds to the par principal. Used in yield calculation.
|
| 29 |
REFERENCE |
Character(30) |
VARCHAR2(30) NOT NULL |
Field to show when a variable is a reference variable.
|
| 30 |
FINANCIAL_ASSET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Capitalized Asset
N=Non Cap
Y=Capitalize
|
| 31 |
PARENT_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Parent ID
|
| 32 |
RETIREMENT_AMT |
Signed Number(28,3) |
DECIMAL(26,3) NOT NULL |
Retirement Amount
|
| 33 |
FULLY_DEPR_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Retire As Fully Depreciated SW
F=Fully Depr with Future Expense
N=Calculate Gain/Loss
Y=Fully Depr no Future Expense
|