| # |
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
|
| 2 |
EFFDT |
Date(10) |
DATE NOT NULL |
Effective Date
Default Value: %date
|
| 3 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 4 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 5 |
DESCRSHORT |
Character(10) |
VARCHAR2(10) NOT NULL |
Short Description
Default Value: INSTITUTION_TBL.DESCR
|
| 6 |
DESCRFORMAL |
Character(50) |
VARCHAR2(50) NOT NULL |
Formal Description field
Default Value: INSTITUTION_TBL.DESCR
|
| 7 |
COUNTRY |
Character(3) |
VARCHAR2(3) NOT NULL |
Country
Prompt Table:
SCC_CNT_ADFMTVW
|
| 8 |
ADDRESS1 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 1
|
| 9 |
ADDRESS2 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 2
|
| 10 |
ADDRESS3 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 3
|
| 11 |
ADDRESS4 |
Character(55) |
VARCHAR2(55) NOT NULL |
Address 4
|
| 12 |
CITY |
Character(30) |
VARCHAR2(30) NOT NULL |
City
|
| 13 |
NUM1 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 1
|
| 14 |
NUM2 |
Character(6) |
VARCHAR2(6) NOT NULL |
Number 2
|
| 15 |
HOUSE_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
House Type
AB=House Boat Reference
WW=House Trailer Reference
|
| 16 |
ADDR_FIELD1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Address Field 1
|
| 17 |
ADDR_FIELD2 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 2
|
| 18 |
ADDR_FIELD3 |
Character(4) |
VARCHAR2(4) NOT NULL |
Address Field 3
|
| 19 |
COUNTY |
Character(30) |
VARCHAR2(30) NOT NULL |
County
|
| 20 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
STATE_TBL
|
| 21 |
POSTAL |
Character(12) |
VARCHAR2(12) NOT NULL |
Postal
|
| 22 |
GEO_CODE |
Character(11) |
VARCHAR2(11) NOT NULL |
Geo Code
|
| 23 |
IN_CITY_LIMIT |
Character(1) |
VARCHAR2(1) NOT NULL |
In City Limit
Y/N Table Edit
|
| 24 |
GRADING_SCHEME |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Scheme
Prompt Table:
GRADESCHEME_TBL
|
| 25 |
GRADING_BASIS |
Character(3) |
VARCHAR2(3) NOT NULL |
Grading Basis
ANC=ABC/NC Grading
AUD=Audit
BMT=Multi-Term Course: Not Graded
CNC=Credit / No Credit
EQV=Equivalent
GRD=Graded
HSC=Hundred Point Scale (NLD)
LAW=Law
MED=Medical School Grades
NOG=No Grade Associated
NON=Non-Graded Component
NQF=NQF Scale
OPT=Student Option
PNP=Pass/Not Pass
SUS=Satisfactory/Unsatisfactory
TRN=Transfer Grading Basis
TSC=Ten Point Scale (NLD)
Prompt Table:
GRADE_BASIS_TBL
|
| 26 |
GRADING_BASIS_SCH |
Character(3) |
VARCHAR2(3) NOT NULL |
School Grading Basis
Prompt Table:
GRADE_BASIS_TBL
|
| 27 |
CAMPUS |
Character(5) |
VARCHAR2(5) NOT NULL |
Campus
Prompt Table:
CAMPUS_TBL
|
| 28 |
STDNT_SPEC_PERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Student Specific Permissions
Y/N Table Edit
Default Value: N
|
| 29 |
AUTO_ENRL_WAITLIST |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Enroll from Wait List
Y/N Table Edit
Default Value: Y
|
| 30 |
RESIDENCY_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Requires Residency Coding
N=Not Required
Y=Required
Default Value: Y
|
| 31 |
FA_WDCAN_RSN |
Character(3) |
VARCHAR2(3) NOT NULL |
FA Withdraw Cancel Reason
|
| 32 |
ENRL_ACTION_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Enrollment Action Reason
|
| 33 |
FACILITY_CONFLICT |
Character(1) |
VARCHAR2(1) NOT NULL |
Status of Facility
Y/N Table Edit
Default Value: INSTALLATION_SA.FACILITY_CONFLICT
|
| 34 |
NSLC_AGD_RULE |
Character(1) |
VARCHAR2(1) NOT NULL |
AGD Rule
E=Use Expected Grad Term
T=Use Term End Date
Default Value: E
|
| 35 |
NSLC_MONTH_FACTOR |
Number(3,0) |
SMALLINT NOT NULL |
NSC Month Factor
|
| 36 |
STDNT_ATTR_COHORT |
Character(4) |
VARCHAR2(4) NOT NULL |
Student Attribute for Cohort
Prompt Table:
STDNT_ATTR_TBL
|
| 37 |
CLASS_MTG_ATND_TYP |
Character(4) |
VARCHAR2(4) NOT NULL |
Class Meeting Attendance Type
Prompt Table:
XLAT_SA_VW
|
| 38 |
FICE_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
FICE Code
|
| 39 |
LOAD_CALC_APPLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate Workload
Y/N Table Edit
Default Value: N
|
| 40 |
FULLTIME_LIMIT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Full-Time Assigned FTE %
Default Value: 100
|
| 41 |
FULLTIM_LIMIT_WARN |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Full-Time Warning Limit %
Default Value: 100
|
| 42 |
PARTTIME_LIMIT_PCT |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Part-Time Assigned FTE %
Default Value: 100
|
| 43 |
PARTTIM_LIMIT_WARN |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Part-Time Warning Limit %
Default Value: 100
|
| 44 |
ASSIGN_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Assignment Type
NON=Not Included in Workload
Prompt Table:
ASSIGN_TYPE_VW
|
| 45 |
INSTRUCTOR_CLASS |
Character(6) |
VARCHAR2(6) NOT NULL |
Instructor Assignment Class
Prompt Table:
INSTR_CLAS_SRCH
|
| 46 |
CRSE_CNTCT_HRS_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Course Component Workload Hrs%
|
| 47 |
UNITS_ACAD_PRG_PCT |
Number(3,0) |
SMALLINT NOT NULL |
Academic Progress Units %
|
| 48 |
LMS_FILE_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
LMS extract file type: XML compliant, Blackboard specific, and WebCT specific
BKB=Blackboard CourseInfo 4
WCT=API Input (old WebCT format)
XML=XML V1.1 (req to authenticate)
|
| 49 |
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
|
| 50 |
ADDR_USAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table:
ADDR_USAGE_TBL
|
| 51 |
REPEAT_ENRL_CTL |
Character(1) |
VARCHAR2(1) NOT NULL |
Process on Enrollment
N=No
Y=Yes
Default Value: N
|
| 52 |
REPEAT_ENRL_SUSP |
Character(1) |
VARCHAR2(1) NOT NULL |
Temp Susp Rpt Ck on Enrl
Y/N Table Edit
Default Value: N
|
| 53 |
REPEAT_GRD_CK |
Character(1) |
VARCHAR2(1) NOT NULL |
Repeat Grade Check
A=All Courses
N=Never
O=Only Repeat Candidates
Default Value: A
|
| 54 |
REPEAT_GRD_SUSP |
Character(1) |
VARCHAR2(1) NOT NULL |
Temp Susp Rpt Ck on Grading
Y/N Table Edit
Default Value: N
|
| 55 |
GRAD_NAME_CHG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is being added to the INSTITUTION_TBL to allow institutions to control whether or not students are allowed to change their degree name on-line. The Degree name is the name printed on their degrees.
Y/N Table Edit
Default Value: N
|
| 56 |
PRINT_NID |
Character(1) |
VARCHAR2(1) NOT NULL |
Print National ID on Enrl. Ver
Y/N Table Edit
Default Value: Y
|
| 57 |
REPEAT_CHK_TOPIC |
Character(1) |
VARCHAR2(1) NOT NULL |
Repeat Check at Topic Level
Y/N Table Edit
Default Value: N
|
| 58 |
SCC_AUS_DEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Australia Features
Y/N Table Edit
Default Value: N
|
| 59 |
SCC_CAN_GOV_RPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Canada Features
Y/N Table Edit
Default Value: N
|
| 60 |
SCC_NZL_ENR |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable New Zealand Features
Y/N Table Edit
Default Value: N
|
| 61 |
SCC_NZL_NZQA |
Character(1) |
VARCHAR2(1) NOT NULL |
NZQA
Y/N Table Edit
Default Value: N
|
| 62 |
SSR_USE_WEEKS |
Character(1) |
VARCHAR2(1) NOT NULL |
Use weeks in faculty workload calculations.
Y/N Table Edit
Default Value: Y
|
| 63 |
SSR_ENBL_ACAD_PROG |
Character(1) |
VARCHAR2(1) NOT NULL |
Select Acad Prog During Enroll
Y/N Table Edit
Default Value: N
|
| 64 |
SSR_CLASS_CANC_ENR |
Character(1) |
VARCHAR2(1) NOT NULL |
Drop Related Components
Y/N Table Edit
Default Value: Y
|
| 65 |
SSR_CLASS_CANC_NON |
Character(1) |
VARCHAR2(1) NOT NULL |
Drop Related Components
Y/N Table Edit
Default Value: Y
|
| 66 |
EXT_USERID_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
UserID Extract Option
E=ID
U=User ID
|
| 67 |
LMS_PROVIDER |
Character(30) |
VARCHAR2(30) NOT NULL |
Provider for Authentication
Prompt Table:
LMS_INT_SETUP
Set Control Field: LMS_PROVIDER
|
| 68 |
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
|
| 69 |
SCC_HE_USED_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Higher Education
Y/N Table Edit
Default Value: N
|
| 70 |
SSR_RPT_MATCH_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Repeat Check Grade Matching Option
B=Best grade
W=Worst grade
Default Value: B
|
| 71 |
SSR_RPT_TRF_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Transfer Credit run option
Y/N Table Edit
Default Value: Y
|
| 72 |
SAD_SL_PARTICIPANT |
Character(1) |
VARCHAR2(1) NOT NULL |
Studielink Participant
Y/N Table Edit
Default Value: N
|
| 73 |
SAA_AARPT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service advisement reports.
Prompt Table:
SAA_OFF_TYP_VW
|
| 74 |
SAA_PLNRRPT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service planner reports.
Prompt Table:
SAA_PLNR_TYP_VW
|
| 75 |
SAA_WHIFRPT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service what-if reports.
Prompt Table:
SAA_WHIF_TYP_VW
|
| 76 |
SAA_WHRPT_TYP_PREM |
Character(5) |
VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service what-if reports.
Prompt Table:
SAA_WHIF_TYP_VW
|
| 77 |
SAA_WHRPT_TYP_ADVR |
Character(5) |
VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service what-if reports.
Prompt Table:
SAA_WHIF_TYP_VW
|
| 78 |
SAA_WHIFXFR_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service what-if reports.
Prompt Table:
SAA_XFR_TYP_VW
|
| 79 |
SAA_WHXFR_TYP_PREM |
Character(5) |
VARCHAR2(5) NOT NULL |
The field is used to track the specific advising report type used for student self service what-if reports.
Prompt Table:
SAA_XFR_TYP_VW
|
| 80 |
SSR_RPT_DATE_ENRL |
Character(1) |
VARCHAR2(1) NOT NULL |
On Enrollment Process
Y/N Table Edit
Default Value: Y
|
| 81 |
SSR_RPT_DATE_PROC |
Character(1) |
VARCHAR2(1) NOT NULL |
On Repeat Process
Y/N Table Edit
Default Value: N
|
| 82 |
SAD_UC_HESA_UCAS |
Character(1) |
VARCHAR2(1) NOT NULL |
HESA, UCAS
Y/N Table Edit
Default Value: N
|
| 83 |
SAD_PB_PBI |
Character(1) |
VARCHAR2(1) NOT NULL |
Points Based Immigration
Y/N Table Edit
Default Value: N
|
| 84 |
SSR_GRAD_CHRG_FEE |
Character(1) |
VARCHAR2(1) NOT NULL |
Charge a Graduation Fee
Y/N Table Edit
|
| 85 |
SSR_GRAD_ELIG_ONLY |
Character(1) |
VARCHAR2(1) NOT NULL |
Self Service Eligible to Apply
Y/N Table Edit
Default Value: N
|
| 86 |
SSR_GRAD_PAY_REQ |
Character(1) |
VARCHAR2(1) NOT NULL |
Self Service Payment Required
Y/N Table Edit
|
| 87 |
FEE_CODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Fee Code
Prompt Table:
TERM_FE_CD_TBL
|
| 88 |
PROG_REASON |
Character(4) |
VARCHAR2(4) NOT NULL |
Action Reason
Prompt Table:
SSR_PROGRSN_VW
|
| 89 |
SSR_USE_GRAD_TRACK |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Graduation Tracking
|
| 90 |
SSR_GRAD_ALWADUPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Address Update?
N=No
Y=Yes
|
| 91 |
SSR_GRAD_ALWNMUPD |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Name Update?
N=No
Y=Yes
|
| 92 |
SSR_GRAD_STATUS |
Character(4) |
VARCHAR2(4) NOT NULL |
eLearning Status which is used to derive the INTERNET field on SDR Course Register File
Prompt Table:
SSR_GRADSTATTBL
|
| 93 |
SSR_GRAD_SHOW_HONR |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Honors
Y/N Table Edit
Default Value: Y
|
| 94 |
SSR_GRAD_SHOW_MLST |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Milestones
Y/N Table Edit
Default Value: Y
|
| 95 |
SSR_GRAD_SHOW_NOTE |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Graduation Notes
Y/N Table Edit
Default Value: Y
|
| 96 |
SSR_GRAD_SHOW_OTCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Transfer Other Credit
Y/N Table Edit
Default Value: Y
|
| 97 |
SSR_GRAD_SHOW_SGPA |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Special GPA
Y/N Table Edit
Default Value: Y
|
| 98 |
SSR_GRAD_SHOW_STAT |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Statistics
Y/N Table Edit
Default Value: Y
|
| 99 |
SSR_GRAD_SHOW_TRCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Transfer Course Credit
Y/N Table Edit
Default Value: Y
|
| 100 |
SSR_GRAD_SHOW_TSCR |
Character(1) |
VARCHAR2(1) NOT NULL |
Display Transfer Test Credit
Y/N Table Edit
Default Value: Y
|
| 101 |
SSR_GRAD_UPDMSG |
Character(254) |
VARCHAR2(254) NOT NULL |
Graduation Name Addr Message
|
| 102 |
SSR_GRAD_UPDNAME |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Name
Y/N Table Edit
Default Value: N
|
| 103 |
SSR_GRAD_NAME_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Name Link Label
|
| 104 |
SSR_GRAD_NDT |
Character(30) |
VARCHAR2(30) NOT NULL |
Name Display Type
Prompt Table:
SCC_GRNM_USG_VW
|
| 105 |
SSR_GRAD_NAME_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
Graduation Name Type
Prompt Table:
NAME_TYPE_TBL
|
| 106 |
SSR_GRAD_UPDADDR |
Character(1) |
VARCHAR2(1) NOT NULL |
Show Address
Y/N Table Edit
Default Value: N
|
| 107 |
SSR_GRAD_ADDR_LBL |
Character(30) |
VARCHAR2(30) NOT NULL |
Address Link Label
|
| 108 |
SSR_GRAD_ADDRUSAGE |
Character(10) |
VARCHAR2(10) NOT NULL |
Address Usage
Prompt Table:
ADDR_USAGE_TBL
|
| 109 |
SSR_GRAD_STAT_AG |
Character(50) |
VARCHAR2(50) NOT NULL |
Applied for Graduation
|
| 110 |
SSR_GRAD_STAT_AP |
Character(50) |
VARCHAR2(50) NOT NULL |
Approved
|
| 111 |
SSR_GRAD_STAT_AW |
Character(50) |
VARCHAR2(50) NOT NULL |
Degree Awarded
|
| 112 |
SSR_GRAD_STAT_DN |
Character(50) |
VARCHAR2(50) NOT NULL |
Denied
|
| 113 |
SSR_GRAD_STAT_EG |
Character(50) |
VARCHAR2(50) NOT NULL |
Eligible for Graduation
|
| 114 |
SSR_GRAD_STAT_IR |
Character(50) |
VARCHAR2(50) NOT NULL |
Program in Review
|
| 115 |
SSR_GRAD_STAT_PN |
Character(50) |
VARCHAR2(50) NOT NULL |
Needs to Finish Pending Work
|
| 116 |
SSR_GRAD_STAT_WD |
Character(50) |
VARCHAR2(50) NOT NULL |
Withdrawn
|
| 117 |
SSR_APT_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
APT Instance Level
0=Not Applicable
2=Academic Program
|
| 118 |
SAD_BR_USE_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use BRON Interface
Y/N Table Edit
Default Value: N
|
| 119 |
SSR_ENRL_CRS_MLSTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Enroll into Course Milestones
Y/N Table Edit
|
| 120 |
SSR_AM_ENABLE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Activity Management
Y/N Table Edit
Default Value: N
|
| 121 |
SSR_ACM_DEFACTV |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Registry / Mgr Defaults
Y/N Table Edit
Default Value: N
|
| 122 |
SSR_AC_DFLT_LVL |
Character(1) |
VARCHAR2(1) NOT NULL |
Default Level Control
C=Enable Career Defaults
O=Enable Academic Org Defaults
Default Value: C
|
| 123 |
SSR_BRON_HO_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Use BRON Interface
Y/N Table Edit
Default Value: N
|
| 124 |
SSR_RSLT_TYPE |
Character(20) |
VARCHAR2(20) NOT NULL |
Result Type
Prompt Table:
SSR_AM_RSLT_VW
|
| 125 |
SSR_IAM_ENEVNT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Using Enrollment Event
A=Create and Remove
N=No Action
U=Remove Only
Default Value: N
|
| 126 |
SSR_IAM_BTCRTE_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable IAM Batch Create Proc
Y/N Table Edit
Default Value: N
|
| 127 |
SSR_USE_SHIFT |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Shift
Y/N Table Edit
Default Value: N
|
| 128 |
SSR_USE_SHIFT_TERM |
Character(1) |
VARCHAR2(1) NOT NULL |
Use Shift by Admit Term
Y/N Table Edit
Default Value: N
|
| 129 |
SSR_ACWC_CALC |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Calculation (WorkCenter)
Y/N Table Edit
Default Value: N
|
| 130 |
SSR_ACWC_ASGN |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Assignment (WorkCenter)
Y/N Table Edit
Default Value: N
|
| 131 |
SSR_IAM_RSLT_POST |
Character(1) |
VARCHAR2(1) NOT NULL |
Posting Option
B=Student & Program Enroll
N=Do Not Post
P=Program Enroll Only
S=Student Enroll Only
Default Value: B
|
| 132 |
SSR_STENRL_GRD_EXS |
Character(1) |
VARCHAR2(1) NOT NULL |
When Grade Exists in Stdnt Enr
C=Apply Grade Change
K=Keep Current Grade
Default Value: K
|
| 133 |
SAA_ACD_PRG_SM_FL |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Progress Summary Report Type
Prompt Table:
SAA_OFF_TYP_VW
|
| 134 |
SAA_ACAD_PROG_FL |
Character(5) |
VARCHAR2(5) NOT NULL |
Academic Progress Report Type
Prompt Table:
SAA_OFF_TYP_VW
|
| 135 |
SAA_CRS_REQ_ALT_FL |
Character(5) |
VARCHAR2(5) NOT NULL |
Course Requirement Alerts Report Type
Prompt Table:
SAA_OFF_TYP_VW
|
| 136 |
SAA_MAX_GPA_FL |
Number(4,1) |
DECIMAL(3,1) NOT NULL |
Max GPA for Chart Display
|
| 137 |
SAA_BASE_CHART_FL |
Character(1) |
VARCHAR2(1) NOT NULL |
Chart Based On
A=Units and Courses
C=Courses
U=Units
Default Value: U
|
| 138 |
SAA_CRSE_WEIGHT_FL |
Number(7,3) |
DECIMAL(6,3) NOT NULL |
Course Weight
|
| 139 |
SSR_IAM_NONUPD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
No Update switch
Y/N Table Edit
Default Value: Y
|
| 140 |
SSR_IAM_NONDEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
No Delete switch
Y/N Table Edit
Default Value: Y
|
| 141 |
SSR_IAM_PENUPD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Penalty Update switch
Y/N Table Edit
Default Value: Y
|
| 142 |
SSR_IAM_PENDEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Penalty Delete switch
Y/N Table Edit
Default Value: Y
|
| 143 |
SSR_IAM_RSTUPD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Resit Update switch
Y/N Table Edit
Default Value: Y
|
| 144 |
SSR_IAM_RSTDEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Resit delete switch
Y/N Table Edit
Default Value: Y
|
| 145 |
SSR_IAM_CALUPD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Calculate switch
Y/N Table Edit
Default Value: Y
|
| 146 |
SSR_IAM_CALDEL_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Delete Calculate switch
Y/N Table Edit
Default Value: Y
|
| 147 |
SSR_BLIND_GRADED |
Character(1) |
VARCHAR2(1) NOT NULL |
This field indicates if blind grading is active
N=Do not Use
Y=Override Display Values
Y/N Table Edit
|
| 148 |
SSR_ANID_ARR_DEF |
Character(4) |
VARCHAR2(4) NOT NULL |
Activity Result Roster default ID display
ANON=Anonymous ID only
BOTH=Anonymous, Student ID and Name
STUD=Student ID and Name only
|
| 149 |
SSR_ANID_WKC_DEF |
Character(4) |
VARCHAR2(4) NOT NULL |
Work Center default ID display
ANON=Anonymous ID
STID=Do not Display in Workcenter
|
| 150 |
SSR_ANID_IAM_DEF |
Character(4) |
VARCHAR2(4) NOT NULL |
Individual Activity Manager default ID display
ANON=Anonymous ID
BOTH=Anonymous, Student ID and Name
STUD=Student ID and Name only
|
| 151 |
SSR_IAM_PE_POSTOPT |
Character(1) |
VARCHAR2(1) NOT NULL |
IAM to PE post option
C=Current System Date
T=Max Program Effdt for Term
Default Value: T
|
| 152 |
SSR_RSLT_PEAM |
Character(1) |
VARCHAR2(1) NOT NULL |
Post from Activity Management
Y/N Table Edit
|
| 153 |
SSR_IAM_R_ATT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
IAM Most Recent Attempt Switch
Y/N Table Edit
Default Value: N
|
| 154 |
SSR_SET_FRMOFSTDY |
Character(1) |
VARCHAR2(1) NOT NULL |
Set Form Of Studey
Y/N Table Edit
Default Value: Y
|
| 155 |
SSR_CHECK_SI |
Character(1) |
VARCHAR2(1) NOT NULL |
Check Service Indicator flag
Y/N Table Edit
Default Value: N
|
| 156 |
SSR_FACCAP_EDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Option if enrollment capacity is to be edited
Y/N Table Edit
Default Value: N
|
| 157 |
SSR_FACCAP_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Option if edit is to send warning or error message
E=Reject with Error Message
W=Display Warning Message
Default Value: W
|
| 158 |
SSR_FACCAP_OMSGSET |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number
Default Value: 14600
Prompt Table:
SSR_MSGST_FAOVW
|
| 159 |
SSR_FACCAP_OMSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
Default Value: 1701
Prompt Table:
SSR_MSGCT_FAOVW
|
| 160 |
SSR_FACCAP_CMSGSET |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number
Default Value: 14600
Prompt Table:
SSR_MSGST_FACVW
|
| 161 |
SSR_FACCAP_CMSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
Default Value: 1715
Prompt Table:
SSR_MSGCT_FACVW
|
| 162 |
SSR_FACCAP_ZERO |
Character(1) |
VARCHAR2(1) NOT NULL |
Option when facility cap is zero
Y/N Table Edit
Default Value: N
|
| 163 |
SSR_RMCAP_EDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Option if enrollment capacity is to be edited
Y/N Table Edit
Default Value: N
|
| 164 |
SSR_RMCAP_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Option if edit is to send warning or error message
E=Reject with Error Message
W=Display Warning Message
Default Value: W
|
| 165 |
SSR_RMCAP_OMSGSET |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number
Default Value: 14600
Prompt Table:
SSR_MSGST_RMVW
|
| 166 |
SSR_RMCAP_OMSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
Default Value: 1702
Prompt Table:
SSR_MSGCT_RMVW
|
| 167 |
SSR_RMCAP_CMSGSET |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number
Default Value: 14600
Prompt Table:
SSR_MSGST_RMCVW
|
| 168 |
SSR_RMCAP_CMSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
Default Value: 1716
Prompt Table:
SSR_MSGCT_RMCVW
|
| 169 |
SSR_RMCAP_NOFACIL |
Character(1) |
VARCHAR2(1) NOT NULL |
No Facility Option
Y/N Table Edit
Default Value: Y
|
| 170 |
SSR_ENRFAC_EDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Option if enrollment capacity is to be edited
Y/N Table Edit
Default Value: N
|
| 171 |
SSR_ENRFAC_MSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Option if edit is to send warning or error message
E=Reject with Error Message
W=Display Warning Message
Default Value: W
|
| 172 |
SSR_ENRFAC_OMSGSET |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number
Default Value: 14640
Prompt Table:
SSR_MSG_EOFASVW
|
| 173 |
SSR_ENRFAC_OMSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
Default Value: 307
Prompt Table:
SSR_MSG_EOFACVW
|
| 174 |
SSR_ENRFAC_ZERO |
Character(1) |
VARCHAR2(1) NOT NULL |
Option when facility cap is zero
Y/N Table Edit
Default Value: N
|
| 175 |
SSR_ENRFAC_PEDIT |
Character(1) |
VARCHAR2(1) NOT NULL |
Option if enrollment capacity is to be edited
Y/N Table Edit
Default Value: N
|
| 176 |
SSR_ENRFAC_PMSG |
Character(1) |
VARCHAR2(1) NOT NULL |
Option if edit is to send warning or error message
E=Reject with Error Message
W=Display Warning Message
Default Value: W
|
| 177 |
SSR_ENRFAC_PMSGSET |
Number(5,0) |
INTEGER NOT NULL |
Message Set Number
Default Value: 14640
Prompt Table:
SSR_MSG_EPFASVW
|
| 178 |
SSR_ENRFAC_PMSGNBR |
Number(5,0) |
INTEGER NOT NULL |
Message Catalog Number
Default Value: 309
Prompt Table:
SSR_MSG_EPFACVW
|
| 179 |
SSR_ENRFAC_PZERO |
Character(1) |
VARCHAR2(1) NOT NULL |
Option when facility cap is zero
Y/N Table Edit
Default Value: N
|
| 180 |
SAA_EARN_CRD_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
Earned Credit Options used in Advisement Report
C=Enable Earned Credit Checkbox
E=Use Earned Credit Only
U=Allow Un-earned Credit
Default Value: U
|
| 181 |
SSR_APT_DESCR_OPTN |
Character(1) |
VARCHAR2(1) NOT NULL |
Display AIR and Course description option in APT
C=Curriculum Term
X=Schedule or Timeline Term
Default Value: C
|
| 182 |
SSR_NSC_CIP_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSC CIP Option for merging same CIP codes (NSC Five-Point Match Criteria).
Y/N Table Edit
Default Value: N
|
| 183 |
SSR_NSC_LOA_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSC Return from LOA Option
P=Use Active Program Start Date
R=Use Return from LOA Date
Default Value: R
|
| 184 |
SSR_NSC_LOA_DAYS |
Number(4,0) |
SMALLINT NOT NULL |
NSC Return from LOA number of days.
|
| 185 |
SSR_NSC_ENRDT_OPT |
Character(1) |
VARCHAR2(1) NOT NULL |
NSC Enrollment Status Date Option
N=Use Term Begin Date
Y=Use the Enrollment Status
Default Value: N
|
| 186 |
SSR_ENBL_ELIGTOENR |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Eligible to Enroll checkbox in Institution Table page
Y/N Table Edit
Default Value: Y
|