PSARCHTEMPAE

(SQL Table)
 Index Back

Archiving Template AE Defn

  • 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).

    Prompt Table: PSARCHTEMPLATE

    2 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
    3 PSARCH_PREAE Character(12) VARCHAR2(12) NOT NULL Pre AE

    Prompt Table: PSAEAPPLDEFN
    Set Control Field: AE_APPLID

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

    Prompt Table: PSAEAPPLDEFN
    Set Control Field: AE_APPLID