ARCH_AUDIT_RQST |
index back |
|---|---|
PS Archiving Report Request |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
 OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: PSOPRDEFN |
| RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
Prompt Table: ARCH_PROJ |
| ARCH_CLASS | Character(30) | VARCHAR2(30) NOT NULL | Archive Operator Class |
| ARCH_EVENT | Character(2) | VARCHAR2(2) NOT NULL |
Archiving Event
AE=Archive Edit SQL AI=Archive Import SQL AR=Archive Run SQL AV=Archive Events AX=Archive Export SQL BF=Batch Flat File Process BH=Batch History Process BI=Batch Import Process BP=Batch AE Process UC=Copy Archive ID UD=Delete Archive ID UG=Generate DM Script UR=Rename Archive ID UV=Utility Events |
| FROM_DT | Date(10) | DATE | From Date |
| TO_DT | Date(10) | DATE | To Date |
| PSARCH_PRINT_SQL | Character(1) | VARCHAR2(1) NOT NULL |
Print SQL?
Y/N Table Edit Default: N |
| PSARCH_FILE_PATH | Character(70) | VARCHAR2(70) NOT NULL | File Path |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |