QRY_SEC_FLD_VW

(SQL View)
 Index Back

SELECT DISTINCT BASE_RECORD , FIELDNAME0 , RECNAME , FIELDNAME FROM PS_QRY_SEC_FLD_TBL WHERE EXISTS ( SELECT 'X' FROM PS_INSTALLATION_FS WHERE QSC_SECURITY_TYPE='1' ) UNION SELECT DISTINCT BASE_RECORD ,FIELDNAME0 , RECNAME_2 , FIELDNAME FROM PS_QRY_SEC_FLD_TBL WHERE EXISTS ( SELECT 'X' FROM PS_INSTALLATION_FS WHERE QSC_SECURITY_TYPE='2' ) UNION SELECT DISTINCT BASE_RECORD , FIELDNAME0 , RECNAME_3 , FIELDNAME FROM PS_QRY_SEC_FLD_TBL WHERE EXISTS ( SELECT 'X' FROM PS_INSTALLATION_FS WHERE QSC_SECURITY_TYPE='3' )

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