EOCM_CTLG_ARCH

(SQL Table)
 Index Back

Run Control Params for Archive

Run Control Parameters for Catalog Management Archiving

  • Parent Record Of EOCM_ARCH_VER EOCM_AVER_TMP

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EOCM_ARCH_ID Character(7) VARCHAR2(7) NOT NULL Arch Id
    2 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Prompt Table: SETID_TBL

    3 EOCM_CATALOG_ID Character(32) VARCHAR2(32) NOT NULL Catalog ID

    Prompt Table: EOCM_CATALOG

    4 EOCM_CAT_VER_ID Number(10,0) DECIMAL(10) NOT NULL Catalog Version Id
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 EOCM_ARCH_OPTION Character(1) VARCHAR2(1) NOT NULL Archive Option
    A=Archive the data
    P=Purge from Archive
    R=Restore from Archive
    7 EOCM_ARCH_STATE Character(1) VARCHAR2(1) NOT NULL Archive State
    A=Archived
    N=Not Archived
    P=Purged
    R=Restored
    8 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.
    9 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.