PI_TARGET_VW (SQL View)	Index Back
View to prompt edit fields. View to prompt edit fields on PI target record name

PI_TARGET_VW

(SQL View)

View to prompt edit fields.

View to prompt edit fields on PI target record name

SELECT A.RECNAME FROM PSRECDEFN A WHERE A.RECNAME IN ('PI_RES_COMMENT','PI_RES_CUSTOD','PI_RES_DEPTID','PI_RES_DESCR','PI_RES_EMPLID', 'PI_RES_LOCATION','PI_RES_MANUF','PI_RES_MODEL','PI_RES_SERIAL','PI_RES_TAG','PI_RES_AREA_ID', 'PI_RES_CUSTDEPT', 'PI_RES_IP_ADDR', 'PI_RES_IP_ALIAS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).