INSTITUTIONDefault Value: OPR_DEF_TBL_CS.INSTITUTION
Prompt Table: INSTITUTION_TBL
EFFDTDefault Value: %date
A=Active
I=Inactive
Default Value: A
N=No
Y=Yes
A=All Courses
N=Never
O=Only Repeat Candidates
INST_RPTVW(SQL View) |
Index Back |
|---|---|
Institution View 1Used as a search record by the Enrollment Requirement Search |
| SELECT INSTITUTION , EFFDT , EFF_STATUS , REPEAT_ENRL_CTL , REPEAT_ENRL_SUSP , REPEAT_GRD_CK , REPEAT_GRD_SUSP FROM PS_INSTITUTION_TBL |
| # | 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 | 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 | REPEAT_ENRL_CTL | Character(1) | VARCHAR2(1) NOT NULL |
Process on Enrollment
N=No Y=Yes |
| 5 | REPEAT_ENRL_SUSP | Character(1) | VARCHAR2(1) NOT NULL | Temp Susp Rpt Ck on Enrl |
| 6 | REPEAT_GRD_CK | Character(1) | VARCHAR2(1) NOT NULL |
Repeat Grade Check
A=All Courses N=Never O=Only Repeat Candidates |
| 7 | REPEAT_GRD_SUSP | Character(1) | VARCHAR2(1) NOT NULL | Temp Susp Rpt Ck on Grading |