OPRIDDefault Value: OPR_DEF_TBL_CS.OPRID
RUN_CNTL_IDPrompt Table: INSTITUTION_TBL
C=Correction
R=Resubmit
V=Validation
X=Populate Historical Data
Default Value: V
1/0 Table Edit (1=True, 0=False)
SCC_SFP_RUN_MV(SQL Table) |
Index Back |
|---|---|
Msg Validation Run ControlMessage Validation Process Run Control |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 4 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 5 | SCC_SFP_FROM_DATE | Date(10) | DATE NOT NULL | From Date |
| 6 | SCC_SFP_THRU_DATE | Date(10) | DATE NOT NULL | Through Date |
| 7 | SCC_SFP_MV_MODE | Character(1) | VARCHAR2(1) NOT NULL |
SFP Processing Mode
C=Correction R=Resubmit V=Validation X=Populate Historical Data Default Value: V |
| 8 | SCC_SFP_LOGMSG_FLG | Number(1,0) | SMALLINT NOT NULL |
Log Message Detail
1/0 Table Edit (1=True, 0=False) |
| 9 | SCC_SFP_GRBG_FREQ | Number(4,0) | SMALLINT NOT NULL | Garbage Collection Frequency |