HR_ATT_CNFG_TBL

(SQL Table)
 Index Back

Attachment Configuration

Attachment Configuration Table

  • Related Language Record: HR_ATT_CNFG_LNG

  • Parent Record Of HR_ATT_CNFG_DD HR_ATT_CNFG_ROL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_ATT_CNFG_ID Character(18) VARCHAR2(18) NOT NULL Attachment Configuration
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 COMMENTS Long Character CLOB Comment
    7 HR_ATT_TYPE Character(3) VARCHAR2(3) NOT NULL Attachment Types
    001=URL
    002=Attachment
    003=Document Definition
    004=Note

    Default Value: 001

    8 URL Character(254) VARCHAR2(254) NOT NULL Internet URL (Universal Resource Locator)

    Default Value: http://

    9 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    10 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    11 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    12 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    13 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: N