ARCH_TBL

(SQL Table)
 Index Back

PS Archiving Tables

  • Parent record: ARCH_PROJ

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: RECDEFN_VW

    3 HIST_RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name

    Prompt Table: RECDEFN_VW

    4 PSARCH_ROW_COPY Character(1) VARCHAR2(1) NOT NULL Copy Parent Criteria

    Y/N Table Edit

    Default Value: N

    5 PARENTRECNAME Character(15) VARCHAR2(15) NOT NULL Parent Record Name

    Prompt Table: RECDEFN_VW