| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SCC_NSN |
Number(10,0) |
DECIMAL(10) NOT NULL |
National Student Number (NZL)
|
| 2 |
SAD_UEBS_YEAR |
Character(4) |
VARCHAR2(4) NOT NULL |
New Zealand NCEA processing
|
| 3 |
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
|
| 4 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 5 |
LAST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
Last Name
|
| 6 |
FIRST_NAME_SRCH |
Character(30) |
VARCHAR2(30) NOT NULL |
First Name
|
| 7 |
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.
|
| 8 |
MATCH_NBR |
Number(6,0) |
INTEGER NOT NULL |
Number of Matches
|
| 9 |
EDIT_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Processsing Options
C=Complete
E=Error
P=Perform
|
| 10 |
SRCH_PROC_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Match processing option
C=Complete
E=Error
P=Perform
|
| 11 |
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
|
| 12 |
SAD_LOAD_BIO_DEMO |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand NCEA processing
|
| 13 |
LAST_NAME_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Last Name Error
Y/N Table Edit
Default Value: N
|
| 14 |
FIRST_NAME_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
First Name Error
Y/N Table Edit
Default Value: N
|
| 15 |
BIRTHDATE_ERROR |
Character(1) |
VARCHAR2(1) NOT NULL |
Birthdate Error
Y/N Table Edit
Default Value: N
|
| 16 |
SEX |
Character(1) |
VARCHAR2(1) NOT NULL |
Gender
F=Female
M=Male
U=Unknown
X=Indeterminate/Intersex/Unspec
|
| 17 |
SAD_NCEA_FNAME_NZL |
Character(100) |
VARCHAR2(100) NOT NULL |
New Zealand NCEA processing
|
| 18 |
SAD_NCEA_NAME2_NZL |
Character(100) |
VARCHAR2(100) NOT NULL |
New Zealand NCEA processing
|
| 19 |
SAD_NCEA_NAME3_NZL |
Character(100) |
VARCHAR2(100) NOT NULL |
New Zealand NCEA processing
|
| 20 |
SAD_NCEA_SURNAME_N |
Character(100) |
VARCHAR2(100) NOT NULL |
New Zealand NCEA processing
|
| 21 |
BIRTHDATE |
Date(10) |
DATE |
Date of Birth
|
| 22 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 23 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 24 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 25 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 26 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 27 |
SCHOOL_CODE |
Character(10) |
VARCHAR2(10) NOT NULL |
School Code
|
| 28 |
SAD_UEBS_CITIZEN |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand NCEA processing
Y/N Table Edit
|
| 29 |
SAD_NCEA_L3CR_APYR |
Number(3,0) |
SMALLINT NOT NULL |
New Zealand NCEA processing
|
| 30 |
SAD_NCEA_LEV_3_ACH |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand NCEA processing
Y/N Table Edit
|
| 31 |
SAD_NCEA_S_Q_AWARD |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand NCEA processing
Y/N Table Edit
|
| 32 |
SAD_NCEA_TTCL3NACH |
Number(3,0) |
SMALLINT NOT NULL |
New Zealand NCEA processing
|
| 33 |
SAD_NCEA_TTCRL3ACH |
Number(3,0) |
SMALLINT NOT NULL |
New Zealand NCEA processing
|
| 34 |
SAD_NCEA_TTS_S_ACH |
Number(1,0) |
SMALLINT NOT NULL |
New Zealand NCEA processing
|
| 35 |
SAD_NCEA_TTSSN_ACH |
Number(1,0) |
SMALLINT NOT NULL |
New Zealand NCEA processing
|
| 36 |
SAD_NCEA_UEACHIEVE |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand NCEA processing
Y/N Table Edit
|
| 37 |
SAD_NCEA_UELIT_ACH |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand NCEA processing
Y/N Table Edit
|
| 38 |
SAD_NCEA_UENUM_ACH |
Character(1) |
VARCHAR2(1) NOT NULL |
New Zealand NCEA processing
Y/N Table Edit
|