| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
Prompt Table:
SAD_TST_SCTY_VW
|
| 2 |
TEST_REC_NBR |
Number(9,0) |
DECIMAL(9) NOT NULL |
Test Type Record Nbr
|
| 3 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 4 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 5 |
SEARCH_ORDER_NBR |
Number(3,0) |
SMALLINT NOT NULL |
This field identifies the Search Order Number where potential duplicate ID(s) is/are encountered by Search/Match when run as part of a batch process.
Prompt Table:
SEARCH_ORDR_TBL
|
| 6 |
MATCH_NBR |
Number(6,0) |
INTEGER NOT NULL |
Number of Matches
|
| 7 |
EDIT_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Processsing Options
C=Complete
E=Error
P=Perform
Default Value: C
|
| 8 |
SRCH_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Match processing option
C=Complete
E=Error
P=Perform
Default Value: P
|
| 9 |
POST_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Post Processing Option
A=Awaiting Search/Match
D=Delete Existing ID
E=Error
N=New ID Add
P=Purge
T=Take No Action
U=Update Existing ID
Default Value: A
Prompt Table:
XL_POST_PROC_VW
|
| 10 |
DATE_LOADED |
Date(10) |
DATE |
Date Loaded
|
| 11 |
LAST_NAME_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Name Error
Y/N Table Edit
Default Value: N
|
| 12 |
FIRST_NAME_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
First Name Error
Y/N Table Edit
Default Value: N
|
| 13 |
BIRTHDATE_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Birthdate Error
Y/N Table Edit
Default Value: N
|
| 14 |
TEST_DT_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Date Error
Y/N Table Edit
Default Value: N
|
| 15 |
TEST_COMP_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Test Component Error
Y/N Table Edit
Default Value: N
|
| 16 |
HS_GRAD_DT_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
High School Graduation Date
Y/N Table Edit
Default Value: N
|
| 17 |
GRAD_DT_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Graduation Date Error
Y/N Table Edit
Default Value: N
|
| 18 |
SAD_COUNTRY_ERR |
Character(1) |
VARCHAR2(1) NOT NULL |
Country Error
Y/N Table Edit
Default Value: N
|
| 19 |
SUBJ_TEST_CD_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Subject Test Code
Y/N Table Edit
Default Value: N
|
| 20 |
SAD_DEG_DT_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Degree Date Error
Y/N Table Edit
Default Value: N
|