INSTALLATION_SR(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SSR_PROGRAM_NAME | Character(8) | VARCHAR2(8) NOT NULL | Program Name |
| 2 | SSR_PROGRAM_VERSN | Character(12) | VARCHAR2(12) NOT NULL | Program Version |
| 3 | SSR_ENRL_RQ_DT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to track the option that defines how the effective for enrollment requisites is used.
A=Enrollment Action Date C=Calculated by AA Program Default Value: C |
| 4 | SSR_REQS_COND_MSG | Character(1) | VARCHAR2(1) NOT NULL |
When enrl requirement is cond
M=Return a warning message S=Success Default Value: S |
| 5 | SSR_REQS_CLPS_CRS | Character(1) | VARCHAR2(1) NOT NULL |
Collapse Course Information
Y/N Table Edit Default Value: N |
| 6 | SSR_REQS_CLPS_REQ | Character(1) | VARCHAR2(1) NOT NULL |
Collapse Course Information
Y/N Table Edit Default Value: N |
| 7 | SSR_REQS_CLPS_FIL | Character(1) | VARCHAR2(1) NOT NULL |
Collapse Filter
Y/N Table Edit Default Value: N |
| 8 | SSR_REQS_STAT_ENRL | Character(1) | VARCHAR2(1) NOT NULL |
Enrolled
Y/N Table Edit Default Value: Y |
| 9 | SSR_REQS_STAT_WAIT | Character(1) | VARCHAR2(1) NOT NULL |
Waitlisted
Y/N Table Edit Default Value: Y |
| 10 | SSR_REQS_STAT_DROP | Character(1) | VARCHAR2(1) NOT NULL |
Dropped
Y/N Table Edit Default Value: N |
| 11 | SSR_REQS_NOT_SAT | Character(1) | VARCHAR2(1) NOT NULL |
Not Satisfied
Y/N Table Edit Default Value: Y |
| 12 | SSR_REQS_CONDITION | Character(1) | VARCHAR2(1) NOT NULL |
Conditional
Y/N Table Edit Default Value: Y |
| 13 | SSR_REQS_ENRL_COMP | Character(1) | VARCHAR2(1) NOT NULL |
Enrollment Component
Y/N Table Edit Default Value: N |
| 14 | SSR_REQS_OVERRIDDN | Character(1) | VARCHAR2(1) NOT NULL |
Overridden
Y/N Table Edit Default Value: N |
| 15 | SSR_REQS_PERMITTED | Character(1) | VARCHAR2(1) NOT NULL |
Permitted
Y/N Table Edit Default Value: N |
| 16 | SSR_REQS_SATISFIED | Character(1) | VARCHAR2(1) NOT NULL |
Satisfied
0=Overridden C=Conditional N=Not Satisfied P=Permitted S=Satisfied Y/N Table Edit Default Value: N |
| 17 | SSR_REQS_UNKNOWN | Character(1) | VARCHAR2(1) NOT NULL |
Unknown
Y/N Table Edit Default Value: N |
| 18 | SSR_REQS_DROP_RVW | Character(1) | VARCHAR2(1) NOT NULL |
Batch Drop Review Complete
Y/N Table Edit Default Value: N |
| 19 | ENRL_ACTION_REASON | Character(4) | VARCHAR2(4) NOT NULL | Enrollment Action Reason |
| 20 | SSR_REQS_LINK_CRSE | Character(1) | VARCHAR2(1) NOT NULL |
Provide link to Course History
Y/N Table Edit Default Value: Y |
| 21 | SSR_REQS_LINK_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Provide link to Statistics
Y/N Table Edit Default Value: Y |
| 22 | SSR_REQS_STAT_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Provide link to Statistics
S=From Student Services Center T=Term History page Default Value: S |
| 23 | SSR_REQS_ORG_SCRTY | Character(1) | VARCHAR2(1) NOT NULL |
Enforce Acad Org Security
Y/N Table Edit Default Value: Y |
| 24 | SSR_REQS_COMM_DELT | Character(1) | VARCHAR2(1) NOT NULL |
Enable comments to be deleted
Y/N Table Edit Default Value: N |
| 25 | SSR_REQS_WARN_LMT | Number(4,0) | SMALLINT NOT NULL |
Warning Message
Default Value: 10 |
| 26 | SSR_REQS_ERROR_LMT | Number(4,0) | SMALLINT NOT NULL |
Error Message
Default Value: 20 |
| 27 | SSR_REQS_POST_RSTR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Post Enrl Requirement Ck
Y/N Table Edit Default Value: Y |
| 28 | SSR_REQS_SET_DROP | Character(1) | VARCHAR2(1) NOT NULL |
Set Drop Requests
Y/N Table Edit Default Value: Y |
| 29 | SSR_REQS_DROP_COND | Character(1) | VARCHAR2(1) NOT NULL |
Drop Conditionally Satisfied
Y/N Table Edit Default Value: N |
| 30 | SSR_REQS_DROP_NOTS | Character(1) | VARCHAR2(1) NOT NULL |
Drop Not Satisfied
Y/N Table Edit Default Value: N |
| 31 | SSR_REQS_DROP_RSTR | Character(1) | VARCHAR2(1) NOT NULL |
Allow Drop Processing
Y/N Table Edit Default Value: Y |
| 32 | SSR_REQS_DROP_OPT | Character(1) | VARCHAR2(1) NOT NULL |
Issue Drop
C=Check Box D=Drop Request S=Status Default Value: C |
| 33 | SSR_REQS_CONDITN2 | Character(1) | VARCHAR2(1) NOT NULL |
Conditional
Y/N Table Edit Default Value: N |
| 34 | SSR_REQS_NOT_SAT2 | Character(1) | VARCHAR2(1) NOT NULL |
Not Satisfied
Y/N Table Edit Default Value: N |
| 35 | SSR_REQS_DROP_OVDT | Character(1) | VARCHAR2(1) NOT NULL |
Override Action Date
Y/N Table Edit Default Value: N |
| 36 | SSR_REQS_BTCH_DROP | Character(1) | VARCHAR2(1) NOT NULL |
Set Drop Requests
Y/N Table Edit Default Value: Y |
| 37 | SSR_REQS_BTCH_COND | Character(1) | VARCHAR2(1) NOT NULL |
Drop Conditionally Satisfied
Y/N Table Edit Default Value: N |
| 38 | SSR_REQS_BTCH_NOTS | Character(1) | VARCHAR2(1) NOT NULL |
Drop Not Satisfied
Y/N Table Edit Default Value: N |
| 39 | SSR_REQS_BDRP_RVW | Character(1) | VARCHAR2(1) NOT NULL |
Process Drop for Review Comple
Y/N Table Edit Default Value: N |
| 40 | SSR_REQS_BDRP_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Process drops for
C=Check Box D=Drop Request S=Status Default Value: D |
| 41 | SSR_REQS_BDRP_CON | Character(1) | VARCHAR2(1) NOT NULL |
Conditional
Y/N Table Edit Default Value: N |
| 42 | SSR_REQS_BDRP_NOTS | Character(1) | VARCHAR2(1) NOT NULL |
Not Satisfied
Y/N Table Edit Default Value: N |
| 43 | SSR_REQS_BTCH_OVDT | Character(1) | VARCHAR2(1) NOT NULL |
Override Action Date
Y/N Table Edit Default Value: N |
| 44 | COMM_CATEGORY | Character(6) | VARCHAR2(6) NOT NULL | Communication Category |
| 45 | SSR_ENABLE_FLUID | Character(1) | VARCHAR2(1) NOT NULL |
Fluid Self Service
Y/N Table Edit Default Value: N |