RSRC_TYPE_VW

(SQL View)
 Index Back

RSRC_TYPE prompt table


SELECT %Substring(A.FIELDVALUE, 1, 1) FROM PSXLATITEM A WHERE A.FIELDNAME = 'RSRC_TYPE' AND A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PSXLATITEM B WHERE A.FIELDNAME = B.FIELDNAME AND B.EFFDT <= %CurrentDateIn)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RSRC_TYPE Character(1) VARCHAR2(1) NOT NULL Work Order Management Resource Types
1=Labor
2=Tools
3=Material