| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 INSTITUTION |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table:
INSTITUTION_TBL
|
| 2 |
SAD_UC_INST |
Character(3) |
VARCHAR2(3) NOT NULL |
UCAS Institution Code
|
| 3 |
SAD_UC_CYCLE |
Number(4,0) |
SMALLINT NOT NULL |
UCAS Cycle
|
| 4 |
SAD_UC_MATR_UPDATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Matriculated Students
Y/N Table Edit
Default Value: N
|
| 5 |
MAR_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Marital Status
C=Common-Law
D=Divorced
E=Separated
H=Head of Household
L=DissDeclLost Civil Partner
M=Married
P=Civil Partnership
S=Single
T=Surviving Civil Partner
U=Unknown
V=Dissolved Civil Partnership
W=Widowed
Default Value: U
|
| 6 |
SAD_UC_HEDATAIMPRT |
Character(4) |
VARCHAR2(4) NOT NULL |
HESA Data Import
ALL=Update all values
NULL=Update only null values
Default Value: NULL
|
| 7 |
SAD_UC_UCAS |
Character(1) |
VARCHAR2(1) NOT NULL |
UCAS
N=No
Y=Yes
Y/N Table Edit
Default Value: Y
|
| 8 |
SAD_UC_GTTR |
Character(1) |
VARCHAR2(1) NOT NULL |
UTT
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 9 |
SAD_UC_DB_LINK |
Character(30) |
VARCHAR2(30) NOT NULL |
UCAS Database Link
|
| 10 |
SAD_UC_IMPORT_LIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Live
Y/N Table Edit
Default Value: N
|
| 11 |
SAD_UC_CAMPUS_USED |
Character(1) |
VARCHAR2(1) NOT NULL |
Campus Used
Y/N Table Edit
Default Value: N
|
| 12 |
SAD_UC_CORRADDRTYP |
Character(4) |
VARCHAR2(4) NOT NULL |
Correspondence Address Type
Prompt Table:
ADDRESS_TYP_TBL
|
| 13 |
SAD_UC_HOMEADDRTYP |
Character(4) |
VARCHAR2(4) NOT NULL |
Home Address Type
Prompt Table:
ADDRESS_TYP_TBL
|
| 14 |
SAD_UC_TELEPHONETY |
Character(4) |
VARCHAR2(4) NOT NULL |
Telephone Type
Prompt Table:
SAD_UC_PHONEVW
|
| 15 |
SAD_UC_MOBILE_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
Mobile phone Type
Prompt Table:
SAD_UC_PHONEVW
|
| 16 |
E_ADDR_TYP2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Email Address Type
BUSN=Business
CAMP=Campus
DORM=Dormitory
HOME=Home
OTHR=Other
PREF=Preferred
Default Value: HOME
|
| 17 |
PROG_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Action Reason
Prompt Table:
SAD_UC_PRSN_VW
|
| 18 |
ADMIT_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Admit Type
Prompt Table:
ADMIT_TYPE_TBL
|
| 19 |
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
|
| 20 |
ADM_APPL_CTR |
Character(4) |
VARCHAR2(4) NOT NULL |
Application Center
Prompt Table:
ADM_APPLCTR_TBL
|
| 21 |
APPL_FEE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Application Fee Type
INT=International
STN=Standard
Default Value: STN
|
| 22 |
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
|
| 23 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
Prompt Table:
CAMPUS_TBL
|
| 24 |
SAD_UC_COURSE |
Character(4) |
VARCHAR2(4) NOT NULL |
UCAS Course Code
Prompt Table:
SAD_UC_COURSEVW
|
| 25 |
SAD_UC_UNCOND |
Character(1) |
VARCHAR2(1) NOT NULL |
Unconditional Offer
Y/N Table Edit
Default Value: N
|
| 26 |
SAD_UC_COND |
Character(1) |
VARCHAR2(1) NOT NULL |
Conditional Offer
Y/N Table Edit
Default Value: N
|
| 27 |
SAD_UC_REJECT |
Character(1) |
VARCHAR2(1) NOT NULL |
Rejection
Y/N Table Edit
Default Value: N
|
| 28 |
SAD_UC_WITHDRAWAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Withdrawal
Y/N Table Edit
Default Value: N
|
| 29 |
SAD_UC_AUT_CONF |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic Confirmation
Y/N Table Edit
Default Value: N
|
| 30 |
SAD_UC_CONF_ACC |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmation Acceptance
Y/N Table Edit
Default Value: N
|
| 31 |
SAD_UC_CONF_REJ |
Character(1) |
VARCHAR2(1) NOT NULL |
Confirmation Rejection
Y/N Table Edit
Default Value: N
|
| 32 |
SAD_UC_COND_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Offer
Prompt Table:
SAD_UC_PRGACTVW
|
| 33 |
SAD_UC_COND_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Offer Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 34 |
SAD_UC_ACON_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Conditional Offer
Prompt Table:
SAD_UC_PRGACTVW
|
| 35 |
SAD_UC_ACON_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Conditional Offer Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 36 |
SAD_UC_UCON_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Offer
Prompt Table:
SAD_UC_PRGACTVW
|
| 37 |
SAD_UC_UCON_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Offer Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 38 |
SAD_UC_AUNC_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Unconditional Offer
Prompt Table:
SAD_UC_PRGACTVW
|
| 39 |
SAD_UC_AUNC_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Unconditional Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 40 |
SAD_UC_REJ_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Rejection
Prompt Table:
SAD_UC_PRGACTVW
|
| 41 |
SAD_UC_REJ_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Rejection Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 42 |
SAD_UC_AREJ_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Rejection
Prompt Table:
SAD_UC_PRGACTVW
|
| 43 |
SAD_UC_AREJ_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Rejection Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 44 |
SAD_UC_WDRW_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal
Prompt Table:
SAD_UC_PRGACTVW
|
| 45 |
SAD_UC_WDRW_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 46 |
SAD_UC_AWDR_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Withdrawal
Prompt Table:
SAD_UC_PRGACTVW
|
| 47 |
SAD_UC_AWDR_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Withdrawal Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 48 |
SAD_UC_UFWD_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Withdrawal - Institution
Prompt Table:
SAD_UC_PRGACTVW
|
| 49 |
SAD_UC_UFWD_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Withdrawal-Institution Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 50 |
SAD_UC_CRSC_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Closed
Prompt Table:
SAD_UC_PRGACTVW
|
| 51 |
SAD_UC_CRSC_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Closed Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 52 |
SAD_UC_CFRM_REPACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Firm
Prompt Table:
SAD_UC_PRGACTVW
|
| 53 |
SAD_UC_CFRM_REPRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Firm Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 54 |
SAD_UC_CINS_REPACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Insurance
Prompt Table:
SAD_UC_PRGACTVW
|
| 55 |
SAD_UC_CINS_REPRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Insurance Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 56 |
SAD_UC_UFRM_REPACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Firm
Prompt Table:
SAD_UC_PRGACTVW
|
| 57 |
SAD_UC_UFRM_REPRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Firm Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 58 |
SAD_UC_UINS_REPACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Insurance
Prompt Table:
SAD_UC_PRGACTVW
|
| 59 |
SAD_UC_UINS_REPRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Insurance Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 60 |
SAD_UC_CDEC_REPACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Decline
Prompt Table:
SAD_UC_PRGACTVW
|
| 61 |
SAD_UC_CDEC_REPRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Conditional Decline Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 62 |
SAD_UC_UDEC_REPACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Decline
Prompt Table:
SAD_UC_PRGACTVW
|
| 63 |
SAD_UC_UDEC_REPRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Unconditional Decline Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 64 |
SAD_UC_CRSE_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Course
Prompt Table:
SAD_UC_PRGACTVW
|
| 65 |
SAD_UC_CRSE_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Course Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 66 |
SAD_UC_CAMP_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Campus
Prompt Table:
SAD_UC_PRGACTVW
|
| 67 |
SAD_UC_CAMP_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Campus Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 68 |
SAD_UC_ENPT_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Entry Point
Prompt Table:
SAD_UC_PRGACTVW
|
| 69 |
SAD_UC_ENPT_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Entry Point Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 70 |
SAD_UC_TERM_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Term
Prompt Table:
SAD_UC_PRGACTVW
|
| 71 |
SAD_UC_TERM_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Changed Term Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 72 |
SAD_UC_CANC_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cancelled Choice
Prompt Table:
SAD_UC_PRGACTVW
|
| 73 |
SAD_UC_CANC_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Cancelled Choice Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 74 |
SAD_UC_WDRW_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal - UCAS
Prompt Table:
SAD_UC_PRGACTVW
|
| 75 |
SAD_UC_WDRW_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal - UCAS Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 76 |
SAD_UC_UFWD_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Withdrawal - UTT
Prompt Table:
SAD_UC_PRGACTVW
|
| 77 |
SAD_UC_UFWD_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Withdrawal - UTT Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 78 |
SAD_UC_WDRR_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal Re-instated
Prompt Table:
SAD_UC_PRGACTVW
|
| 79 |
SAD_UC_WDRR_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Withdrawal Re-instated Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 80 |
SAD_UC_REJD_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Reject by Default
Prompt Table:
SAD_UC_PRGACTVW
|
| 81 |
SAD_UC_REJD_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Reject by Default Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 82 |
SAD_UC_DECD_CHGACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Decline by Default
Prompt Table:
SAD_UC_PRGACTVW
|
| 83 |
SAD_UC_DECD_CHGRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Decline by Default Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 84 |
SAD_UC_ACPF_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Accept Firm
Prompt Table:
SAD_UC_PRGACTVW
|
| 85 |
SAD_UC_ACPF_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Accepr Firm Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 86 |
SAD_UC_ACPI_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Accept Insurance
Prompt Table:
SAD_UC_PRGACTVW
|
| 87 |
SAD_UC_ACPI_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Accept Insurance Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 88 |
SAD_UC_REJF_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Reject Firm
Prompt Table:
SAD_UC_PRGACTVW
|
| 89 |
SAD_UC_REJF_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Reject Firm Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 90 |
SAD_UC_REJI_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Reject Insurance
Prompt Table:
SAD_UC_PRGACTVW
|
| 91 |
SAD_UC_REJI_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Reject Insurance Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 92 |
SAD_UC_AMND_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Confirmation
Prompt Table:
SAD_UC_PRGACTVW
|
| 93 |
SAD_UC_AMND_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Confirmation Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 94 |
SAD_UC_CHG_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Confirmation with Change
Prompt Table:
SAD_UC_PRGACTVW
|
| 95 |
SAD_UC_CHG_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Confirmation with Change Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 96 |
SAD_UC_UF_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Elsewhere
Prompt Table:
SAD_UC_PRGACTVW
|
| 97 |
SAD_UC_UF_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Elsewhere Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 98 |
SAD_UC_CLR_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Elsewhere
Prompt Table:
SAD_UC_PRGACTVW
|
| 99 |
SAD_UC_CLR_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Elsewhere Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 100 |
SAD_UC_UIUF_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
UI to UF at Confirmation
Prompt Table:
SAD_UC_PRGACTVW
|
| 101 |
SAD_UC_UIUF_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
UI to UF at Confirmation Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 102 |
SAD_UC_REL_CLR |
Character(1) |
VARCHAR2(1) NOT NULL |
Release to Clearing
Y/N Table Edit
Default Value: N
|
| 103 |
SAD_UC_AUF_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Amendment
Prompt Table:
SAD_UC_PRGACTVW
|
| 104 |
SAD_UC_AUF_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
UF Amendment Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 105 |
SAD_UC_ACP_CLRACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Acceptance
Prompt Table:
SAD_UC_PRGACTVW
|
| 106 |
SAD_UC_ACP_CLRRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Acceptance Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 107 |
SAD_UC_APP_CLRACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Application
Prompt Table:
SAD_UC_PRGACTVW
|
| 108 |
SAD_UC_APP_CLRRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Application Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 109 |
SAD_UC_REL_CLRACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Release to Clearing
Prompt Table:
SAD_UC_PRGACTVW
|
| 110 |
SAD_UC_REL_CLRRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Release to Clearing Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 111 |
SAD_UC_RPA_CLRACT |
Character(4) |
VARCHAR2(4) NOT NULL |
RPA Applicant
Prompt Table:
SAD_UC_PRGACTVW
|
| 112 |
SAD_UC_RPA_CLRRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
RPA Applicant Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 113 |
SAD_UC_REJ_CLRACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Rejection
Prompt Table:
SAD_UC_PRGACTVW
|
| 114 |
SAD_UC_REJ_CLRRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Clearing Rejection Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 115 |
SAD_UC_ACP_ADJACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Adjustment Acceptance
Prompt Table:
SAD_UC_PRGACTVW
|
| 116 |
SAD_UC_ACP_ADJRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Adjustment Acceptance Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 117 |
SAD_UC_DEC_ADJACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Adjustment Decline
Prompt Table:
SAD_UC_PRGACTVW
|
| 118 |
SAD_UC_DEC_ADJRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Adjustment Decline Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 119 |
SAD_UC_INTRV |
Character(1) |
VARCHAR2(1) NOT NULL |
Interview
Y/N Table Edit
Default Value: N
|
| 120 |
SAD_UC_EAR_APPYEAR |
Number(4,0) |
SMALLINT NOT NULL |
Earliest Application Year
|
| 121 |
SAD_UC_DEC_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
Disable Decision Link
Y/N Table Edit
Default Value: N
|
| 122 |
SAD_UC_INTR_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Interview
Prompt Table:
SAD_UC_PRGACTVW
|
| 123 |
SAD_UC_INTR_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Interview Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 124 |
SAD_UC_AINT_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Interview
Prompt Table:
SAD_UC_PRGACTVW
|
| 125 |
SAD_UC_AINT_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Interview Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 126 |
SAD_UC_CFUL_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Full
Prompt Table:
SAD_UC_PRGACTVW
|
| 127 |
SAD_UC_CFUL_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Full Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 128 |
SAD_UC_AFUL_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Course Full
Prompt Table:
SAD_UC_PRGACTVW
|
| 129 |
SAD_UC_AFUL_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Course Full Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 130 |
SAD_UC_IMP_UNITS |
Character(1) |
VARCHAR2(1) NOT NULL |
Unit Results
Y/N Table Edit
Default Value: Y
|
| 131 |
SAD_UC_CREATE_CAS |
Character(1) |
VARCHAR2(1) NOT NULL |
Create CAS Records
Y/N Table Edit
Default Value: N
|
| 132 |
SAD_UC_HRMS_EMP |
Character(1) |
VARCHAR2(1) NOT NULL |
HRMS Decision Approver
Y/N Table Edit
Default Value: N
|
| 133 |
SAD_UC_PREV_NAME |
Character(3) |
VARCHAR2(3) NOT NULL |
Previous Name Type
Prompt Table:
SAD_UC_NAMTYPVW
|
| 134 |
SAD_UC_DCON_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Delayed Conditional
Prompt Table:
SAD_UC_PRGACTVW
|
| 135 |
SAD_UC_DCON_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Delayed Conditional Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 136 |
SAD_UC_ADCN_DECACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Delayed Conditional
Prompt Table:
SAD_UC_PRGACTVW
|
| 137 |
SAD_UC_ADCN_DECRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Amended Delayed Conditional
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 138 |
SAD_UC_CICF_CNFACT |
Character(4) |
VARCHAR2(4) NOT NULL |
CI to CF at Confirmation
Prompt Table:
SAD_UC_PRGACTVW
|
| 139 |
SAD_UC_CICF_CNFRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
CI to CF at Confirmation Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 140 |
SAD_UC_SAVE_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic Save
Y/N Table Edit
Default Value: N
|
| 141 |
SAD_UC_OUTCM_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Outcome Required
Y/N Table Edit
Default Value: N
|
| 142 |
SAD_UC_UNICODE |
Character(1) |
VARCHAR2(1) NOT NULL |
Unicode
Y/N Table Edit
Default Value: N
|
| 143 |
SAD_UC_CONTEXTUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Contextual Data
Y/N Table Edit
Default Value: N
|
| 144 |
SAD_UC_HEADDFIELD |
Character(1) |
VARCHAR2(1) NOT NULL |
Add HESA Person fields
Y/N Table Edit
Default Value: Y
|
| 145 |
SAD_UC_ADMIN_FUNCT |
Character(4) |
VARCHAR2(4) NOT NULL |
Default Admin Function
Prompt Table:
SAD_UC_ADMFNCVW
|
| 146 |
SAD_UC_CFRMU_RACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cond Firm - Upgraded
Prompt Table:
SAD_UC_PRGACTVW
|
| 147 |
SAD_UC_CFRMU_RRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Cond Firm - Upgraded Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 148 |
SAD_UC_CINSD_RACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Cond Insurance - Downgraded
Prompt Table:
SAD_UC_PRGACTVW
|
| 149 |
SAD_UC_CINSD_RRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Cond Insurance - Downgrade Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 150 |
SAD_UC_UFRMU_RACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Uncond Firm - Upgraded
Prompt Table:
SAD_UC_PRGACTVW
|
| 151 |
SAD_UC_UFRMU_RRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Uncond Firm - Upgraded Reason
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 152 |
SAD_UC_UINSD_RACT |
Character(4) |
VARCHAR2(4) NOT NULL |
Uncond Insurance - Downgraded
Prompt Table:
SAD_UC_PRGACTVW
|
| 153 |
SAD_UC_UINSD_RRSN |
Character(4) |
VARCHAR2(4) NOT NULL |
Uncond Insurance-Downgrade Rsn
Prompt Table:
SAD_UC_ACTRSNVW
Set Control Field: INSTITUTION
|
| 154 |
SAD_UC_MISMATCHED |
Character(1) |
VARCHAR2(1) NOT NULL |
Process Mismatched Applicants
Y/N Table Edit
Default Value: N
|
| 155 |
HOUSING_INTEREST |
Character(1) |
VARCHAR2(1) NOT NULL |
Housing Interest
C=Commuter
F=Off Campus Housing
H=On Campus Housing
|
| 156 |
SAD_UC_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Apply
Y/N Table Edit
Default Value: N
|
| 157 |
SAD_UC_ATTRN |
Character(120) |
VARCHAR2(120) NOT NULL |
Attribution Name
|
| 158 |
SAD_UC_ATTRE |
Character(100) |
VARCHAR2(100) NOT NULL |
Attribution Email
|
| 159 |
SAD_UC_ATTRU |
Character(100) |
VARCHAR2(100) NOT NULL |
Attribution User ID
|
| 160 |
SAD_UC_ATTRT |
Character(50) |
VARCHAR2(50) NOT NULL |
Attribution Token
|
| 161 |
SAD_UC_DEF_DEC |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Decision Maker
Y/N Table Edit
Default Value: N
|
| 162 |
SAD_UC_UCAPXML |
Character(1) |
VARCHAR2(1) NOT NULL |
Use XML for Applicants
Y/N Table Edit
|
| 163 |
SAD_UC_UCDCXML |
Character(1) |
VARCHAR2(1) NOT NULL |
Use XML for Decisions
Y/N Table Edit
|
| 164 |
SAD_UC_UCIDXML |
Character(100) |
VARCHAR2(100) NOT NULL |
XML-Link User ID
|
| 165 |
SAD_UC_UCPWXML |
Character(50) |
VARCHAR2(50) NOT NULL |
XML-Link Password
|
| 166 |
SAD_UC_UCREFXML |
Character(1) |
VARCHAR2(1) NOT NULL |
Use XML for Reference
Y/N Table Edit
|
| 167 |
SAD_UC_IMP_SCN |
Character(1) |
VARCHAR2(1) NOT NULL |
Import SCN
Y/N Table Edit
Default Value: Y
|
| 168 |
SAD_UC_SCN_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
SCN Update Option
1=Add/Update
2=Add if blank
Default Value: 1
|
| 169 |
SAD_UC_IMP_ULN |
Character(1) |
VARCHAR2(1) NOT NULL |
Import ULN
Y/N Table Edit
Default Value: Y
|
| 170 |
SAD_UC_ULN_UPD |
Character(1) |
VARCHAR2(1) NOT NULL |
ULN Update Option
1=Add/Update
2=Add if blank
Default Value: 1
|
| 171 |
SAD_UC_IMP_ENQUAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Import Entry Qualifications
Y/N Table Edit
Default Value: Y
|
| 172 |
SAD_UC_UENC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
UCAS Encryption flag
Y/N Table Edit
|
| 173 |
SAD_UC_AENC_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Apply encryption flag
Y/N Table Edit
|
| 174 |
SAD_UC_UDECRYPT |
Character(30) |
VARCHAR2(30) NOT NULL |
UCAS Decryption Profile ID
|
| 175 |
SAD_UC_ADECRYPT |
Character(30) |
VARCHAR2(30) NOT NULL |
Apply Decryption Profile ID
|