HCSC_FLDNM1_VW

(SQL View)
Index Back

view to prompt record field

View to prompt record field.

SELECT RECNAME , FIELDNAME FROM PSRECFIELDDB A WHERE EXISTS ( SELECT 'X' FROM PSDBFIELD B WHERE A.FIELDNAME = B.FIELDNAME AND B.FIELDTYPE = 0)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).