SAD_TEST_PURGE(SQL Table) |
Index Back |
|---|---|
Test Score Purge ParmsSAD_TEST_PURGE holds the parameters needed for the processing of the Admissions Test Score purge. |
| # | 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 | TEST_ID | Character(11) | VARCHAR2(11) NOT NULL |
Test ID
Prompt Table: SAD_TST_SCTY_VW |
| 4 | PURGE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Purge Option
A=All Suspense Rows M=Marked Suspense Rows Default Value: M |
| 5 | PURGE_MSGS_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Purge Messages
A=All Messages M=Remove Associated Messages N=Retain Associated Messages Default Value: M |
| 6 | SAD_PURGE_P_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Purge Option for Marked Rows
A=All Marked Suspense Rows L=Rows Loaded before or on P=Rows Posted before or on Default Value: A |
| 7 | DATE_LOADED | Date(10) | DATE | Date Loaded |
| 8 | SAD_PURGE_S_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Purge Option for Marked Rows
A=All Marked Suspense Rows L=Rows Loaded before or on P=Rows Posted before or on S=All Suspense Rows |
| 9 | DATE_LOADED_S | Date(10) | DATE | Date Loaded |