DISP_CODE_VW (SQL View)	Index Back
Disposal Code for Worksheet These view restricts what codes to be

DISP_CODE_VW

(SQL View)

Disposal Code for Worksheet

These view restricts what codes to be

SELECT %Substring(A.FIELDVALUE,1,1) , A.XLATLONGNAME , A.XLATSHORTNAME FROM PSXLATITEM A WHERE A.FIELDNAME='DISPOSAL_CODE' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE a.fieldname=b.fieldname AND B.EFFDT <= %CurrentDateIn AND B.FIELDVALUE = A.FIELDVALUE) AND A.EFF_STATUS = 'A' AND A.FIELDVALUE NOT IN ('L','V')

# 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

3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short 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
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description