ARCH_RQST_OPT

(SQL Table)
 Index Back

PS Archiving Request Option

  • Parent record: ARCH_RQST

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: PSOPRDEFN

    2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
    3 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

    Prompt Table: ARCH_PROJ

    4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    5 ARCH_PROC_FLAG Character(1) VARCHAR2(1) NOT NULL Archiving Process Flag

    Y/N Table Edit

    6 RECNAME1 Character(15) VARCHAR2(15) NOT NULL Record Name 1

    Prompt Table: RECDEFN_VW