PSRF_FINFO_VW

index back

Report Folder Info Table

Folder Information for Reporting folder
SELECT A.PSRF_FOLDER_ID , A.PSRF_PRNT_FLDR_ID , A.PSRF_FOLDER_NAME , A.DBNAME , B.DESCR FROM PSRF_FINFO_TBL A , PSRF_FVIEW_TBL B WHERE A.PSRF_FOLDER_NAME = B.PSRF_FOLDER_NAME

  • Related language record: PSRF_FINFO_LGVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PSRF_FOLDER_IDNumber(12,0)DECIMAL(12) NOT NULLReporting Folder's Unique Identifier
    PSRF_PRNT_FLDR_IDNumber(12,0)DECIMAL(12) NOT NULLParent Folder's Unique identifier
    PSRF_FOLDER_NAMECharacter(18)VARCHAR2(18) NOT NULLReporting Folder's Name
    DBNAMECharacter(8)VARCHAR2(8) NOT NULLDatabase Name
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19