| # |
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: PSAUS
Prompt Table:
INSTITUTION_TBL
|
| 4 |
TEST_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Test ID
Prompt Table:
SAD_TAC_SCTY_VW
|
| 5 |
DATE_LOADED |
Date(10) |
DATE |
Date Loaded
Default Value: %Date
|
| 6 |
SAD_TAC_FILE1 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 1
|
| 7 |
SAD_TAC_FILE2 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 2
|
| 8 |
SAD_TAC_FILE3 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 3
|
| 9 |
SAD_TAC_FILE4 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 4
|
| 10 |
SAD_TAC_FILE5 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 5
|
| 11 |
SAD_TAC_FILE6 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 6
|
| 12 |
SAD_TAC_FILE7 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 7
|
| 13 |
SAD_TAC_FILE8 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 8
|
| 14 |
SAD_TAC_FILE9 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 9
|
| 15 |
SAD_TAC_FILE10 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 10
|
| 16 |
SAD_TAC_FILE11 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 11
|
| 17 |
SAD_TAC_FILE12 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 12
|
| 18 |
SAD_TAC_FILE13 |
Character(254) |
VARCHAR2(254) NOT NULL |
TAC Filepath 13
|
| 19 |
POST_REC_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Single Record
Y/N Table Edit
Default Value: N
|
| 20 |
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
|
| 21 |
PURGE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Option
A=All Suspense Rows
M=Marked Suspense Rows
Default Value: M
|
| 22 |
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
|
| 23 |
EXT_ADM_APPL_NBR |
Character(15) |
VARCHAR2(15) NOT NULL |
External Application Nbr
Prompt Table:
%EDITTABLE
|
| 24 |
SAD_TAC_PROC_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
TAC VTAC Proc. Indicator
G=Graduate Files
N=None
U=Undergraduate Files
Default Value: N
|
| 25 |
ADDRESS_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Type
Prompt Table:
ADDRESS_TYP_TBL
|
| 26 |
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
|
| 27 |
ACADEMIC_LEVEL |
Character(3) |
VARCHAR2(3) NOT NULL |
Academic Level
00=Not Set
01=First Year
02=Second Year
03=Third Year
04=Fourth Year
05=Fifth Year
06=Sixth Year
10=Freshman
20=Sophomore
30=Junior
40=Senior
50=Post-Bacc Undergraduate
GR=Graduate
GRA=Graduate AUS
HON=Honours
IE=Industrial Experience
MAS=Masters
P1=Professional Year 1
P2=Professional Year 2
P3=Professional Year 3
P4=Professional Year 4
PHD=PhD
|
| 28 |
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
|
| 29 |
SAD_TAC_OFFERS |
Character(1) |
VARCHAR2(1) NOT NULL |
TAC Offers
Y/N Table Edit
Default Value: N
|
| 30 |
SAD_TAC_CRSE_INIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Initial Course Character
|
| 31 |
ADMIT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Admit Type
Prompt Table:
ADMIT_TYPE_TBL
|
| 32 |
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
|
| 33 |
SAD_QTC_PERMADRTYP |
Character(4) |
VARCHAR2(4) NOT NULL |
Permanent Address Type
Prompt Table:
ADDRESS_TYP_TBL
|
| 34 |
SAD_QTC_MOBILE_TYP |
Character(4) |
VARCHAR2(4) NOT NULL |
Mobile 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
|
| 35 |
SAD_TAC_SWAP_A2C |
Character(1) |
VARCHAR2(1) NOT NULL |
Swap A & C Numbers After Load
Y/N Table Edit
Default Value: Y
|