SSR_HE_INST_DAT(SQL Table) |
Index Back |
---|---|
Institution Data Capture |
# | 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 | SSR_HE_FIELD | Character(20) | VARCHAR2(20) NOT NULL |
Field
Prompt Table: SSR_HE_FIELD_VW |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
5 | SSR_HE_SEPARATE | Character(3) | VARCHAR2(3) NOT NULL |
Display Region
ENP=Entry Profile FED=Further Education INS=Instance KCR=KIS Course LOC=KIS Location NTD=Not Displayed OTH=Other OVS=Aggregate Offshore RES=Restricted |
6 | SSR_HE_INSTTN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Institution Flag
Y/N Table Edit Default Value: N |
7 | SSR_HE_STUDENT_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Student
Y/N Table Edit Default Value: N |
8 | SSR_HE_INSTANC_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Instance
Y/N Table Edit Default Value: N |
9 | SSR_HE_ADVISR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Advisor Flag
Y/N Table Edit Default Value: N |
10 | SSR_HE_PRGM_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Program
Y/N Table Edit Default Value: N |
11 | SSR_HE_PRGM_OFRFLG | Character(1) | VARCHAR2(1) NOT NULL |
Program Offering
Y/N Table Edit Default Value: N |
12 | SSR_HE_PRGM_OYRFLG | Character(1) | VARCHAR2(1) NOT NULL |
Program Offering Year
Y/N Table Edit Default Value: N |
13 | SSR_HE_PLAN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Plan
Y/N Table Edit Default Value: N |
14 | SSR_HE_PLN_OFFRFLG | Character(1) | VARCHAR2(1) NOT NULL |
Plan Offering
Y/N Table Edit Default Value: N |
15 | SSR_HE_PLN_OYR_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Plan Offering Year
Y/N Table Edit Default Value: N |
16 | SSR_HE_SPLAN_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Subplan
Y/N Table Edit Default Value: N |
17 | SSR_HE_SPLN_OFRFLG | Character(1) | VARCHAR2(1) NOT NULL |
Sub-Plan Offering
Y/N Table Edit Default Value: N |
18 | SSR_HE_SPLN_OYRFLG | Character(1) | VARCHAR2(1) NOT NULL |
Sub-Plan Offering Year
Y/N Table Edit Default Value: N |
19 | SSR_HE_MODULE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Module
Y/N Table Edit Default Value: N |