ATP_PARMS(SQL Table) |
Index Back |
|---|---|
Run Control ATP (School) LoadThis record contains the parameters for the ATP School Load Process. |
| # | 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_COLLEGE | Character(254) | VARCHAR2(254) NOT NULL | Path/Name College Input File |
| 4 | FILE_INPUT_SCHOOL | Character(254) | VARCHAR2(254) NOT NULL | Path/Name School Input File |
| 5 | POST_REC_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Process Single Record
Y/N Table Edit Default Value: N |
| 6 | SRCH_MTCH_PST_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Search/Match/Post Process Optn
B=Search, Match and Post P=Post Only S=Search and Match Only Default Value: B |
| 7 | ATP_REC_NBR | Number(9,0) | DECIMAL(9) NOT NULL |
ATP Record Number
Prompt Table: %EDITTABLE |
| 8 | ATP_PURGE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
ATP Purge Option
A=All Suspense Rows M=Marked Suspense Rows Default Value: M |
| 9 | PURGE_MSGS_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Purge Messages
A=All Messages M=Remove Associated Messages N=Retain Associated Messages Default Value: N |
| 10 | ATP_ADD_ONE_PARM | Character(1) | VARCHAR2(1) NOT NULL |
One match
I=Ignore S=Suspend U=Update Default Value: S |
| 11 | ATP_CHG_NO_PARM | Character(1) | VARCHAR2(1) NOT NULL |
One match
A=Add I=Ignore S=Suspend Default Value: S |
| 12 | ATP_DELETE_NO_PARM | Character(1) | VARCHAR2(1) NOT NULL |
No match
I=Ignore S=Suspend Default Value: S |
| 13 | ATP_MULTI_PARM | Character(1) | VARCHAR2(1) NOT NULL |
Multiple match
I=Ignore S=Suspend Default Value: S |