ARCH_RQST

(SQL Table)
 Index Back

PS Archiving Request

  • Parent Record Of ARCH_RQST_OPT ARCH_RQST_PARM

    • # 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 PSARCH_PROCESS Character(1) VARCHAR2(1) NOT NULL Archive Process
    D=Archive Delete
    H=Remove from History
    I=Import Process
    P=Run Reports
    R=Archive Rollback
    S=Archive Selection

    Default Value: S

    5 ARCH_COMMIT_FLAG Character(1) VARCHAR2(1) NOT NULL Archive Commit Flag

    Y/N Table Edit

    Default Value: N

    6 ARCH_COMMIT_ROWS Number(18,0) DECIMAL(18) NOT NULL Num rows to commit after
    7 PSARCH_PREAE Character(12) VARCHAR2(12) NOT NULL Pre AE

    Prompt Table: PSAEAPPLDEFN

    8 PSARCH_POSTAE Character(12) VARCHAR2(12) NOT NULL Post AE

    Prompt Table: PSAEAPPLDEFN