| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table:
INSTITUTION_TBL
|
| 2 |
PROG_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Action Reason
Prompt Table:
SAD_UC_PRSN_VW
|
| 3 |
ADMIT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Admit Type
Prompt Table:
ADMIT_TYPE_TBL
|
| 4 |
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
Default Value: 01
|
| 5 |
ADM_APPL_CTR |
Character(4) |
VARCHAR2(4) NOT NULL |
Application Center
Prompt Table:
ADM_APPLCTR_TBL
|
| 6 |
APPL_FEE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Application Fee Type
INT=International
STN=Standard
Default Value: STN
|
| 7 |
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
Default Value: WWW
|
| 8 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
Prompt Table:
CAMPUS_TBL
|
| 9 |
SAD_UC_COURSE |
Character(4) |
VARCHAR2(4) NOT NULL |
UTT Course Code
Prompt Table:
SAD_UC_GTCRSEVW
|
| 10 |
SAD_UC_INTRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Interview
Y/N Table Edit
Default Value: N
|
| 11 |
SAD_UC_UNCOND |
Character(1) |
VARCHAR2(1) NOT NULL |
Unconditional Offer
Y/N Table Edit
Default Value: N
|
| 12 |
SAD_UC_COND |
Character(1) |
VARCHAR2(1) NOT NULL |
Conditional Offer
Y/N Table Edit
Default Value: N
|
| 13 |
SAD_UC_REJECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejection
Y/N Table Edit
Default Value: N
|
| 14 |
SAD_UC_WITHDRAWAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Withdrawal
Y/N Table Edit
Default Value: N
|
| 15 |
SAD_UC_CONF_ACC |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmation Acceptance
Y/N Table Edit
Default Value: N
|
| 16 |
SAD_UC_CONF_REJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmation Rejection
Y/N Table Edit
Default Value: N
|
| 17 |
SAD_UC_COND_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Offer
Prompt Table:
SAD_UC_PRGACTVW
|
| 18 |
SAD_UC_COND_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Offer Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 19 |
SAD_UC_ACON_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Conditional Offer
Prompt Table:
SAD_UC_PRGACTVW
|
| 20 |
SAD_UC_ACON_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Conditional Offer Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 21 |
SAD_UC_UCON_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Offer
Prompt Table:
SAD_UC_PRGACTVW
|
| 22 |
SAD_UC_UCON_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Offer Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 23 |
SAD_UC_AUNC_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Unconditional Offer
Prompt Table:
SAD_UC_PRGACTVW
|
| 24 |
SAD_UC_AUNC_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Unconditional Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 25 |
SAD_UC_REJ_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Rejection
Prompt Table:
SAD_UC_PRGACTVW
|
| 26 |
SAD_UC_REJ_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Rejection Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 27 |
SAD_UC_AREJ_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Rejection
Prompt Table:
SAD_UC_PRGACTVW
|
| 28 |
SAD_UC_AREJ_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Rejection Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 29 |
SAD_UC_EREJ_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Rejection - English
Prompt Table:
SAD_UC_PRGACTVW
|
| 30 |
SAD_UC_EREJ_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Rejection - English Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 31 |
SAD_UC_AERJ_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Rejection - English
Prompt Table:
SAD_UC_PRGACTVW
|
| 32 |
SAD_UC_AERJ_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Rejection -English Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 33 |
SAD_UC_MREJ_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Rejection - Maths
Prompt Table:
SAD_UC_PRGACTVW
|
| 34 |
SAD_UC_MREJ_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Rejection - Maths Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 35 |
SAD_UC_AMRJ_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Rejection - Maths
Prompt Table:
SAD_UC_PRGACTVW
|
| 36 |
SAD_UC_AMRJ_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Rejection - Maths Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 37 |
SAD_UC_SREJ_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Rejection - Science
Prompt Table:
SAD_UC_PRGACTVW
|
| 38 |
SAD_UC_SREJ_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Rejection - Science Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 39 |
SAD_UC_ASRJ_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Rejection - Science
Prompt Table:
SAD_UC_PRGACTVW
|
| 40 |
SAD_UC_ASRJ_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Rejection -Science Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 41 |
SAD_UC_CRSC_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Closed
Prompt Table:
SAD_UC_PRGACTVW
|
| 42 |
SAD_UC_CRSC_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Closed Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 43 |
SAD_UC_ACRC_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Course Closed
Prompt Table:
SAD_UC_PRGACTVW
|
| 44 |
SAD_UC_ACRC_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Course Closed Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 45 |
SAD_UC_INTR_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Interview
Prompt Table:
SAD_UC_PRGACTVW
|
| 46 |
SAD_UC_INTR_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Interview Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 47 |
SAD_UC_AINT_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Interview
Prompt Table:
SAD_UC_PRGACTVW
|
| 48 |
SAD_UC_AINT_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Interview Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 49 |
SAD_UC_WDRW_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal
Prompt Table:
SAD_UC_PRGACTVW
|
| 50 |
SAD_UC_WDRW_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 51 |
SAD_UC_AWDR_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Withdrawal
Prompt Table:
SAD_UC_PRGACTVW
|
| 52 |
SAD_UC_AWDR_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Withdrawal Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 53 |
SAD_UC_UFWD_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Withdrawal - Institution
Prompt Table:
SAD_UC_PRGACTVW
|
| 54 |
SAD_UC_UFWD_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Withdrawal-Institution Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 55 |
SAD_UC_CFRM_REPACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Firm
Prompt Table:
SAD_UC_PRGACTVW
|
| 56 |
SAD_UC_CFRM_REPRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Firm Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 57 |
SAD_UC_UFRM_REPACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Firm
Prompt Table:
SAD_UC_PRGACTVW
|
| 58 |
SAD_UC_UFRM_REPRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Firm Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 59 |
SAD_UC_CDEC_REPACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Decline
Prompt Table:
SAD_UC_PRGACTVW
|
| 60 |
SAD_UC_CDEC_REPRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Decline Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 61 |
SAD_UC_UDEC_REPACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Decline
Prompt Table:
SAD_UC_PRGACTVW
|
| 62 |
SAD_UC_UDEC_REPRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Decline Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 63 |
SAD_UC_CRSE_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Course
Prompt Table:
SAD_UC_PRGACTVW
|
| 64 |
SAD_UC_CRSE_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Course Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 65 |
SAD_UC_CAMP_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Campus
Prompt Table:
SAD_UC_PRGACTVW
|
| 66 |
SAD_UC_CAMP_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Campus Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 67 |
SAD_UC_TERM_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Term
Prompt Table:
SAD_UC_PRGACTVW
|
| 68 |
SAD_UC_TERM_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Term Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 69 |
SAD_UC_WDRW_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal - UCAS
Prompt Table:
SAD_UC_PRGACTVW
|
| 70 |
SAD_UC_WDRW_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal - UCAS Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 71 |
SAD_UC_UFWD_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Withdrawal - UTT
Prompt Table:
SAD_UC_PRGACTVW
|
| 72 |
SAD_UC_UFWD_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Withdrawal - UTT Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 73 |
SAD_UC_WDRR_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal Re-instated
Prompt Table:
SAD_UC_PRGACTVW
|
| 74 |
SAD_UC_WDRR_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal Re-instated Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 75 |
SAD_UC_REJD_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Reject by Default
Prompt Table:
SAD_UC_PRGACTVW
|
| 76 |
SAD_UC_REJD_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Reject by Default Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 77 |
SAD_UC_DECD_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Decline by Default
Prompt Table:
SAD_UC_PRGACTVW
|
| 78 |
SAD_UC_DECD_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Decline by Default Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 79 |
SAD_UC_ACPF_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Accept Firm
Prompt Table:
SAD_UC_PRGACTVW
|
| 80 |
SAD_UC_ACPF_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Accepr Firm Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 81 |
SAD_UC_REJF_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Reject Firm
Prompt Table:
SAD_UC_PRGACTVW
|
| 82 |
SAD_UC_REJF_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Reject Firm Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 83 |
SAD_UC_AMND_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Confirmation
Prompt Table:
SAD_UC_PRGACTVW
|
| 84 |
SAD_UC_AMND_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Confirmation Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 85 |
SAD_UC_CHG_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Confirmation with Change
Prompt Table:
SAD_UC_PRGACTVW
|
| 86 |
SAD_UC_CHG_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Confirmation with Change Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 87 |
SAD_UC_CLR_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Elsewhere
Prompt Table:
SAD_UC_PRGACTVW
|
| 88 |
SAD_UC_CLR_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Elsewhere Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 89 |
SAD_UC_EAR_APPYEAR |
Number(4,0) |
SMALLINT NOT NULL |
Earliest Application Year
|
| 90 |
SAD_UC_APP_CLRACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Application
Prompt Table:
SAD_UC_PRGACTVW
|
| 91 |
SAD_UC_APP_CLRRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Application Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 92 |
SAD_UC_ACP_CLRACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Acceptance
Prompt Table:
SAD_UC_PRGACTVW
|
| 93 |
SAD_UC_ACP_CLRRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Acceptance Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 94 |
SAD_UC_OFR_CLRACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Offer
Prompt Table:
SAD_UC_PRGACTVW
|
| 95 |
SAD_UC_OFR_CLRRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Offer Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 96 |
SAD_UC_RPA_CLRACT |
Character(4) |
VARCHAR2(4) NOT NULL |
RPA Applicant
Prompt Table:
SAD_UC_PRGACTVW
|
| 97 |
SAD_UC_RPA_CLRRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
RPA Applicant Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 98 |
SAD_UC_AUF_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Amendment
Prompt Table:
SAD_UC_PRGACTVW
|
| 99 |
SAD_UC_AUF_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Amendment Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 100 |
SAD_UC_GTPREV_NAME |
Character(3) |
VARCHAR2(3) NOT NULL |
Previous Name Type
Prompt Table:
SAD_UC_NAMTYPVW
|
| 101 |
SAD_UC_DCON_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Delayed Conditional
Prompt Table:
SAD_UC_PRGACTVW
|
| 102 |
SAD_UC_DCON_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Delayed Conditional Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 103 |
SAD_UC_ADCN_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Delayed Conditional
Prompt Table:
SAD_UC_PRGACTVW
|
| 104 |
SAD_UC_ADCN_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Delayed Conditional
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 105 |
HOUSING_INTEREST |
Character(1) |
VARCHAR2(1) NOT NULL |
Housing Interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing
|
| 106 |
NOTIFICATION_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Notification Plan
ERLY=Early Admission Decision
REG=Regular Admission Decision
ROLL=Rolling Admission
Default Value: REG
|