HR_OBD_CFG_ATT

(SQL Table)
Index Back

OnBoarding AG Document Config

  • Related Language Record: HR_OBD_CFG_ATTL
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DOCUMENT_ID Character(12) VARCHAR2(12) NOT NULL Document Id
    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 ATTACH_DESCR Character(50) VARCHAR2(50) NOT NULL Document
    5 AGC_CATEGORY_ID Character(15) VARCHAR2(15) NOT NULL Activity Guide Category

    Prompt Table: AGC_CAT_TBL

    6 DESCRLONG Long Character CLOB Long Description
    7 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).

    Prompt Table: PSURLDEFN

    8 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
    9 ATTACHUSERFILE Character(64) VARCHAR2(64) NOT NULL Attached File
    10 ATTACH_EMP_ACTION Character(1) VARCHAR2(1) NOT NULL Employee Action Required
    A=Acknowledge Document
    N=None
    U=Upload Document

    Default Value: N

    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.