SAD_RC_UEBS_NZL(SQL Table) |
Index Back |
|---|---|
UEBS Run Control RecordUEBS Run Control Record |
| # | 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 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 4 | SAD_UEBS_YEAR | Character(4) | VARCHAR2(4) NOT NULL | New Zealand NCEA processing |
| 5 | SAD_UEBS_FILE_NBR | Character(1) | VARCHAR2(1) NOT NULL |
New Zealand NCEA processing
1=First Examination File 2=Second Examination File 3=Third Examination File |
| 6 | SAD_UEBS_FILEPATH1 | Character(70) | VARCHAR2(70) NOT NULL | New Zealand NCEA processing |
| 7 | SAD_UEBS_FILEPATH2 | Character(70) | VARCHAR2(70) NOT NULL | New Zealand NCEA processing |
| 8 | SAD_UEBS_FILEPATH3 | Character(70) | VARCHAR2(70) NOT NULL | New Zealand NCEA processing |
| 9 | SAD_UEBS_FILEPATH4 | Character(70) | VARCHAR2(70) NOT NULL | New Zealand NCEA processing |
| 10 | PURGE_OPTION | Character(1) | VARCHAR2(1) NOT NULL |
Purge Option
A=All Suspense Rows M=Marked Suspense Rows Default Value: M |
| 11 | 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 |
| 12 | POST_REC_SELECTION | Character(1) | VARCHAR2(1) NOT NULL |
Process Single Record
Y/N Table Edit Default Value: N |
| 13 | 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 |
| 14 | SCC_NSN | Number(10,0) | DECIMAL(10) NOT NULL | National Student Number (NZL) |