PI_BASIS_VW (SQL View)	Index Back
View to prompt edit fields. View to prompt edit fields for PI Basis record name.

PI_BASIS_VW

(SQL View)

View to prompt edit fields.

View to prompt edit fields for PI Basis record name.

SELECT A.RECNAME FROM PSRECDEFN A WHERE A.RECNAME IN ('ASSET' , 'ASSET_LOC_VW', 'ASSET_CUST_VW' , 'COST_BAL_VW', 'NON_CAP_VW', 'LEASE_OPER', 'ASSET_COMMENTS')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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