OPRIDRUN_CNTL_IDA=Applications
B=Both
W=Withdrawals
Prompt Table: SAD_CA_PRUID_VW
SAD_CA_SELRN(SQL Table) |
Index Back |
|---|---|
Fetch selected applicationsRuncontrol to fetch selected applications Bug 35713596 - removed obsolete fields SAD_CA_DTTM_UPD_FR and SAD_CA_DTTM_UPD_TO. |
| # | 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 | SAD_CA_DTTM_ADD_FR | DateTime(26) | TIMESTAMP | Date/time Created From |
| 4 | SAD_CA_DTTM_ADD_TO | DateTime(26) | TIMESTAMP | Date/time Created Until |
| 5 | SAD_CA_WD_SEL_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Messages to be retrieved
A=Applications B=Both W=Withdrawals |
| 6 | SAD_CA_RIO_PRG_NLD | Character(50) | VARCHAR2(50) NOT NULL |
Offered program UUID
Prompt Table: SAD_CA_PRUID_VW |
| 7 | SAD_CA_SEQ_NBR_FR | Number(31,0) | DECIMAL(31) NOT NULL | From mutation seq nbr |
| 8 | SAD_CA_MAX_MSG | Number(15,0) | DECIMAL(15) NOT NULL | maximum number of messages to be retrieved (0 = infinite) |