HR_ATT_AUTH_TBL

(SQL Table)
 Index Back

Attachment Authorization

Attachment Authorization Record

  • Related Language Record: HR_ATT_AUTH_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_ATT_AUTH_ID Character(18) VARCHAR2(18) NOT NULL Attachment Authorization ID
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 COMMENTS Long Character CLOB Comment
    5 HR_ATT_VATCH Character(1) VARCHAR2(1) NOT NULL View Attachments

    Y/N Table Edit

    Default Value: Y

    6 HR_ATT_EATCH Character(1) VARCHAR2(1) NOT NULL Edit Attachments

    Y/N Table Edit

    Default Value: Y

    7 HR_ATT_VNOTE Character(1) VARCHAR2(1) NOT NULL View Notes

    Y/N Table Edit

    Default Value: Y

    8 HR_ATT_ENOTE Character(1) VARCHAR2(1) NOT NULL Edit Notes

    Y/N Table Edit

    Default Value: Y

    9 HR_ATT_VURL Character(1) VARCHAR2(1) NOT NULL View URLs

    Y/N Table Edit

    Default Value: Y

    10 HR_ATT_EURL Character(1) VARCHAR2(1) NOT NULL Edit URLs

    Y/N Table Edit

    Default Value: Y

    11 HR_ATT_DELETE Character(3) VARCHAR2(3) NOT NULL Attachment Delete Options
    001=Mark as deleted
    002=Delete from database

    Default Value: 001

    12 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Y/N Table Edit

    Default Value: Y