AM_RETIREAPPRV

(SQL View)
 Index Back

Retirement Information


SELECT BUSINESS_UNIT , ASSET_ID , DTTM_STAMP , DATE_SUBMITTED ,ORIGINATOR_ID , ROLEUSER , APPROVER_ID , DATE_APPROVED , APPR_STATUS , DESCR , TAG_NUMBER , SERIAL_ID , CATEGORY , COST , CURRENCY_CD , QUANTITY , PROCEEDS , TXN_CURRENCY_CD , REMOVAL_COST , TXN_CURRENCY_CD1 , RETIRE_QUANTITY , DISPOSAL_CODE , RETIREMENT_DT , TRANS_CODE , TRANS_DT , ACCOUNTING_DT , CONVENTION , PROCEEDS_PERCENT , REFERENCE , FINANCIAL_ASSET_SW , PARENT_ID FROM PS_AM_RETIRE_APPR

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_AM_NONVW

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 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.
4 DATE_SUBMITTED Date(10) DATE Date Submitted
5 ORIGINATOR_ID Character(30) VARCHAR2(30) NOT NULL Originator
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