AVN_TPL_DFLD_VW

(SQL View)
 Index Back

SELECT DISTINCT ACV_NDTPL_ID , ACV_NDFLD_ID_1 FROM PS_AVN_NODE_LINE WHERE ACV_NDFLD_TYPE_1 = 'F' UNION SELECT DISTINCT ACV_NDTPL_ID , ACV_NDFLD_ID_2 FROM PS_AVN_NODE_LINE WHERE ACV_NDFLD_TYPE_2 = 'F'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ACV_NDTPL_ID Character(8) VARCHAR2(8) NOT NULL Node Template ID
2 DATA_FIELD_ID Character(8) VARCHAR2(8) NOT NULL Data Field ID