FF_FILE_INF_VW

(SQL View)
 Index Back

SELECT DISTINCT A.FF_FILE_NAME , A.FF_VERSION , A.FF_ACCESSID , A.FF_FILE_TYPE , A.FF_FILE_STATUS , A.FF_CATEGORY , A.DESCR , C.OPRID FROM PS_FF_SETTINGS A ,PS_FF_ACCESSAUTH B ,PSOPRDEFN C ,PSROLEUSER R WHERE A.FF_ACCESSID = B.FF_ACCESSID AND(( B.AUTHORID = C.OPRID) OR (R.ROLEUSER = C.OPRID AND R.ROLENAME = B.AUTHORID ))

  • Related Language Record: FF_FILE_INF_LNG

  • Parent record: FF_SETTINGS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FF_FILE_NAME Character(30) VARCHAR2(30) NOT NULL Flat file name
    2 FF_VERSION Character(30) VARCHAR2(30) NOT NULL Message Version
    3 FF_ACCESSID Character(18) VARCHAR2(18) NOT NULL Access ID

    Prompt Table: FF_ACCESS

    4 FF_FILE_TYPE Character(1) VARCHAR2(1) NOT NULL File Type
    D=Delimited
    F=Fixed

    Default Value: D

    5 FF_FILE_STATUS Character(1) VARCHAR2(1) NOT NULL File status
    A=Active
    I=Inactive
    P=In Progress

    Default Value: P

    6 FF_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).