OPRIDPrompt Table: OPERATOR_VW
RUN_CNTL_IDC=Copy Asset
D=Delete
E=Extract
L=Load AM Tables
R=Extract Depr. Expected Results
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
AMDTEXTR_RQST(SQL Table) |
Index Back |
|---|---|
Request for program AMDTEXTR |
| # | 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: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 4 | FROM_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | From Asset ID |
| 5 | TO_ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | To Asset ID |
| 6 | AMDTEXTR_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Depr Test Flat File Options
C=Copy Asset D=Delete E=Extract L=Load AM Tables R=Extract Depr. Expected Results |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 8 | BACKUP_FILES_SW | Character(1) | VARCHAR2(1) NOT NULL |
Backup Files
Y/N Table Edit Default Value: N |
| 9 | LOAD_FROM_FILE | Character(1) | VARCHAR2(1) NOT NULL |
Load From File
Y/N Table Edit Default Value: N |
| 10 | PATHNAME | Character(254) | VARCHAR2(254) NOT NULL | PATHNAME |
| 11 | NUM_OF_COPIES | Number(3,0) | SMALLINT NOT NULL | Number Of Copies |
| 12 | REFRESH | Character(1) | VARCHAR2(1) NOT NULL |
Load Netting Rows
Y/N Table Edit Default Value: N |