FF_ACCESSAUTH

(SQL Table)
 Index Back

Flat File authorization

Flat File authorization

  • Parent record: FF_ACCESS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FF_ACCESSID Character(18) VARCHAR2(18) NOT NULL Access ID
    2 AUTHORIDTYPE Character(1) VARCHAR2(1) NOT NULL Author ID Type
    2=User
    3=Role

    Default Value: 2

    3 AUTHORID Character(30) VARCHAR2(30) NOT NULL Author ID

    Prompt Table: %EDITTABLE

    4 FF_READONLY Character(1) VARCHAR2(1) NOT NULL FF_READONLY
    N=No
    Y=Yes

    Default Value: N

    5 FF_GENERATE Character(1) VARCHAR2(1) NOT NULL FF_READONLY
    N=No
    Y=Yes

    Default Value: Y

    6 DATA_TYPE_CD Character(1) VARCHAR2(1) NOT NULL Data Type Code
    N=Customer Data
    S=Sample Data
    Y=System Data

    Default Value: N