| # |
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 |
POST_REC_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Single Record
Y/N Table Edit
Default Value: N
|
| 5 |
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
|
| 6 |
LS_DATA_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Data Source
A8=TEAS Degree Information
AAD=AADSAS
ACT=American College Testing
AE=Ad-Hoc Employee
AMC=AMCAS
AO=Ad-Hoc Organizational
E=Extract
ETS=Educational Testing Service
GH=OLSAS Last Secondary-G2
LSD=LSDAS
PI=Prev/Post Secondary Info
RS=OLSAS Postsecondary Info
SCH=School
SLF=Self-Reported Information
WWW=World Wide Web
|
| 7 |
EXT_ADM_APPL_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
External Application Nbr
Prompt Table:
%EDITTABLE
|
| 8 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
ADDRESS_TYP_TBL
|
| 9 |
PHONE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
|
| 10 |
EMAIL_ADDR_POP |
Character(1) |
VARCHAR2(1) NOT NULL |
Populate Email Address
Y/N Table Edit
Default Value: N
|
| 11 |
E_ADDR_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Address Type.
Note: Dorm long name has been updated as Dormitory as part of PI26 updates. And, the owner id of the field is updated to CC from HR.
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
|
| 12 |
COMMIT_FREQ |
Number(7,0) |
INTEGER NOT NULL |
Commit Frequency
Default Value: 1000
|
| 13 |
ADM_APPL_METHOD |
Character(3) |
VARCHAR2(3) NOT NULL |
Application Method
DSK=Diskette
EDI=EDI
HRD=Hard Copy
OUA=Ontario University Application
SRV=Application Service
WWW=Web Application
|
| 14 |
SAD_CREATE_PRS |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Prospect Flag
Y/N Table Edit
Default Value: N
|