DISPOSAL_CD_VW (SQL View)	Index Back
Disposal code view Disposal Code View from XLats for Mass Change prompt

DISPOSAL_CD_VW

(SQL View)

Disposal code view

Disposal Code View from XLats for Mass Change prompt

SELECT DISTINCT %Substring(a.fieldvalue, 1, 1) , a.xlatlongname FROM PSXLATITEM a WHERE A.FIELDNAME = 'DISPOSAL_CODE' AND A.EFF_STATUS = 'A' AND a.effdt = ( SELECT MAX(b.effdt) FROM PSXLATITEM b WHERE a.fieldvalue = b.fieldvalue AND a.fieldname = b.fieldname )

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description