PC_CR_FIELDS_VW (SQL View)	Index Back
Custom Rates Fieldname prompt Prompt view for Custom Rates fields.

PC_CR_FIELDS_VW

(SQL View)

Custom Rates Fieldname prompt

Prompt view for Custom Rates fields.

SELECT A.FIELDNAME FROM PS_PC_CRATE_FIELDS A , PS_INSTALLATION B WHERE (B.RS = 'Y') OR (B.RS <> 'Y' AND A.FIELDNAME NOT IN ('REGION_CD'))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).