EPS_PARMS(SQL Table) |
Index Back |
|---|---|
Parms for EPS processesThis record contains the parameters for the EPS background processes. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | FILE_INPUT_EPS | Character(254) | VARCHAR2(254) NOT NULL | EPS Input File Name |
| 4 | DATA_TYPE_IND_EPS | Character(1) | VARCHAR2(1) NOT NULL |
EPS Load Data Type Indicator
Y/N Table Edit Default Value: N |
| 5 | LOAD_DATA_TYPE_EPS | Character(10) | VARCHAR2(10) NOT NULL |
EPS Code Type
Prompt Table: EXORGCDTYPE_VW |
| 6 | DEL_DATA_IND_EPS | Character(1) | VARCHAR2(1) NOT NULL |
EPS Delete Data Type Indicator
Y/N Table Edit Default Value: N |
| 7 | DELETE_DATA_EPS | Character(1) | VARCHAR2(1) NOT NULL |
EPS Deleting Data
A=All T=Specific Type Default Value: A |
| 8 | DEL_DATA_TYPE_EPS | Character(10) | VARCHAR2(10) NOT NULL |
EPS Delete Data Type
Prompt Table: EXORGCDTYPE_VW |
| 9 | PURGE_DATA_EPS | Character(1) | VARCHAR2(1) NOT NULL |
EPS Purge Data
A=All Type T=Specific Type Default Value: A |
| 10 | PURG_DATA_TYPE_EPS | Character(10) | VARCHAR2(10) NOT NULL |
EPS Purge Data Type
Prompt Table: EPS_SUSP_VW |
| 11 | ALL_EPS | Character(1) | VARCHAR2(1) NOT NULL |
All
Y/N Table Edit Default Value: N |
| 12 | COMPLETED_EPS | Character(1) | VARCHAR2(1) NOT NULL |
Completed
Y/N Table Edit Default Value: N |
| 13 | ERROR_EPS | Character(1) | VARCHAR2(1) NOT NULL |
Error
Y/N Table Edit Default Value: N |
| 14 | OK_TO_PURGE_EPS | Character(1) | VARCHAR2(1) NOT NULL |
OK to Purge
Y/N Table Edit Default Value: N |